global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where capacity_mw = "3.6" and primary_fuel = "Hydro" sorted by generation_gwh_2013
This data as json, CSV (advanced)
Suggested facets: country, source, geolocation_source, year_of_capacity_data, generation_gwh_2016, generation_gwh_2017, generation_data_source, estimated_generation_gwh_2016, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2016
owner 24
- Appalachian Power Co 1
- Boyce Hydro Power LLC 1
- Brassua Hydroelectric LP 1
- Brookfield White Pine Hydro LLC 1
- Central Rivers Power MA LLC 1
- City of Bryan - (OH) 1
- Dry Creek LLC 1
- EONY Generation Limited 1
- Fall River Rural Elec Coop Inc 1
- Gia Nghi Co. Ltd 1
- Green Mountain Power Corp 1
- Guadalupe Blanco River Authority 1
- Jamaica Public Service Company 1
- Lake Lure Town of 1
- McBryde Sugar Co Ltd 1
- Midwest Hydro LLC 1
- Nevada Irrigation District 1
- Public Service Co of Colorado 1
- Ry Ninh Hydro Power Enterprise 1
- SUUR-SAVON SÄHKÖ Oy 1
- Strawberry Water Users Assn 1
- Ta Niet Hydro Power JSC 1
- U S Bureau of Reclamation 1
- Utica Water & Power Authority 1
country_long 8
primary_fuel 1
- Hydro · 36 ✖
Link | rowid | country | country_long | name | gppd_idnr | capacity_mw | latitude | longitude | primary_fuel | other_fuel1 | other_fuel2 | other_fuel3 | commissioning_year | owner | source | url | geolocation_source | wepp_id | year_of_capacity_data | generation_gwh_2013 ▼ | generation_gwh_2014 | generation_gwh_2015 | generation_gwh_2016 | generation_gwh_2017 | generation_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1384 | 1384 | BRA | Brazil | Belmonte | BRA0030091 | 3.6 | -26.8333 | -53.6667 | Hydro | 2012.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 1084634 | 2017 | 11.19 | 15.05 | 15.08 | 14.65 | 13.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
2032 | 2032 | BRA | Brazil | Funil | BRA0027066 | 3.6 | -20.4967 | -43.4722 | Hydro | 2014.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 2017 | 6.83 | 11.75 | 11.27 | 11.3 | 9.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
2160 | 2160 | BRA | Brazil | Ijuizinho | BRA0001108 | 3.6 | -28.365 | -54.3743 | Hydro | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 1043352 | 2017 | 12.23 | 15.15 | 14.63 | 14.36 | 13.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
2961 | 2961 | BRA | Brazil | Santa Clara I | BRA0028850 | 3.6 | -25.6478 | -51.9536 | Hydro | 2005.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 2017 | 14.14 | 15.15 | 17.88 | 15.16 | 15.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3511 | 3511 | BRA | Brazil | Ângelo Cassol | BRA0028849 | 3.6 | -11.93 | -62.1008 | Hydro | 2011.0 | Agência Nacional de Energia Elétrica (Brazil) | http://www2.aneel.gov.br/aplicacoes/capacidadebrasil/capacidadebrasil.cfm | Agência Nacional de Energia Elétrica (Brazil) | 1068038 | 2017 | 14.3 | 17.52 | 16.44 | 16.72 | 14.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4480 | 4480 | CAN | Canada | Sandy Lake | CAN0008334 | 3.6 | 44.7116 | -63.896 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28510 | 2000 | 8.27 | 8.27 | 8.27 | 8.29 | 8.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
10276 | 10276 | FIN | Finland | Vaaja | WRI1002570 | 3.6 | 63.096 | 21.6158 | Hydro | SUUR-SAVON SÄHKÖ Oy | Finnish Energy Authority | http://www.energiavirasto.fi/en/voimalaitosrekisteri | CARMA | 1030636 | 14.68 | 16.32 | 10.61 | 11.23 | 14.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
11101 | 11101 | FRA | France | Izernore | WRI1025045 | 3.6 | 46.2184 | 5.5632 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 12.78 | 13.22 | 14.08 | 13.31 | 14.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
11201 | 11201 | FRA | France | Lacourt | WRI1025047 | 3.6 | 42.9332 | 1.1708 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 1014856 | 11.73 | 11.38 | 15.32 | 13.61 | 14.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
11595 | 11595 | FRA | France | Méolans-Revel | WRI1025046 | 3.6 | 44.371 | 6.498 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 11.96 | 12.28 | 14.69 | 11.27 | 14.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
11966 | 11966 | FRA | France | Saint-Flour | WRI1025050 | 3.6 | 45.7102 | 3.5096 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 9.58 | 10.21 | 11.58 | 10.36 | 11.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
16477 | 16477 | JAM | Jamaica | Upper White River | WRI1023927 | 3.6 | 18.3751 | -77.0514 | Hydro | 1945.0 | Jamaica Public Service Company | Jamaica Public Service Company | https://www.jpsco.com/about-jps/how-we-serve-you/ | WRI | 1020008 | 15.44 | 14.42 | 13.94 | 15.87 | 9.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
18868 | 18868 | PRT | Portugal | Montargil | WRI1022739 | 3.6 | 39.0542 | -8.1766 | Hydro | 1970.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1012727 | 10.88 | 10.88 | 8.41 | 11.3 | 7.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
26161 | 26161 | USA | United States of America | Caonillas 2 | WRI1028016 | 3.6 | 18.2397 | -66.6691 | Hydro | CEPR | http://energia.pr.gov/datos/plantas/ | WRI | 30932 | 8.0 | 8.0 | 7.9 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
26386 | 26386 | USA | United States of America | Chester Diversion Hydroelectric Project | USA0056893 | 3.6 | 44.0183 | -111.5836 | Hydro | 2014.0 | Fall River Rural Elec Coop Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55102 | 2019 | 4.121 | 3.712 | 6.663 | 7.884 | 5.265 | 7.551 | U.S. Energy Information Administration | 13.28 | 13.19 | 12.05 | 13.3 | 12.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
34732 | 34732 | VNM | Vietnam | Dak Po ne 2 | WRI1030839 | 3.6 | 14.526 | 108.2992 | Hydro | 2008.0 | Gia Nghi Co. Ltd | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dak-po-ne-2-hydropower | Open Development Vietnam | 1076635 | 15.78 | Open Development Vietnam | 16.03 | 15.77 | 14.0 | 15.47 | 11.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34852 | 34852 | VNM | Vietnam | Ry Ninh | WRI1030833 | 3.6 | 14.209 | 107.8141 | Hydro | Ry Ninh Hydro Power Enterprise | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ry-ninh-hydropower | Open Development Vietnam | 1068340 | 15.85 | 15.75 | 12.65 | 15.24 | 9.97 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
34885 | 34885 | VNM | Vietnam | Ta Niet | WRI1030882 | 3.6 | 20.8944 | 104.5229 | Hydro | 2014.0 | Ta Niet Hydro Power JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ta-niet-hydropower | Open Development Vietnam | 18.0 | Open Development Vietnam | 11.75 | 10.87 | 9.58 | 11.3 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
25221 | 25221 | USA | United States of America | Auglaize Hydro | USA0007657 | 3.6 | 41.2372 | -84.3998 | Hydro | 1996.111111111111 | City of Bryan - (OH) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30522 | 2019 | 0.011 | 10.76922 | 8.861 | 8.743 | 11.105 | 11.728 | 12.116 | U.S. Energy Information Administration | 13.08 | 12.36 | 12.64 | 13.85 | 11.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25033 | 25033 | USA | United States of America | Ames Hydro | USA0006207 | 3.6 | 37.866 | -107.8831 | Hydro | 1906.0 | Public Service Co of Colorado | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.964 | 2.294 | 8.996 | 6.972 | 8.109 | 2.295 | 3.398 | U.S. Energy Information Administration | 11.45 | 11.54 | 11.44 | 11.88 | 11.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
27200 | 27200 | USA | United States of America | Dry Creek Project | USA0054394 | 3.6 | 44.0274 | -112.7194 | Hydro | 1988.0 | Dry Creek LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 48767 | 2019 | 5.158 | 7.719 | 8.465 | 11.163 | 13.16 | 12.788 | 10.341 | U.S. Energy Information Administration | 8.02 | 8.02 | 8.44 | 8.04 | 6.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27221 | 27221 | USA | United States of America | Dunlap TP 1 | USA0003582 | 3.6 | 29.6402 | -98.0459 | Hydro | 1927.0 | Guadalupe Blanco River Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21549 | 2019 | 5.674 | 3.145 | 15.303 | 17.322 | 16.179000000000002 | 12.304 | 5.974 | U.S. Energy Information Administration | 10.12 | 9.65 | 7.89 | 10.11 | 8.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25755 | 25755 | USA | United States of America | Bowman | USA0050546 | 3.6 | 39.4484 | -120.6534 | Hydro | 1986.0 | Nevada Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55103 | 2019 | 6.28 | 5.083 | 3.953 | 14.7 | 20.462 | 13.92 | 14.275 | U.S. Energy Information Administration | 8.02 | 8.02 | 8.44 | 8.04 | 6.82 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32819 | 32819 | USA | United States of America | Spanish Fork | USA0003691 | 3.6 | 40.08 | -111.6048 | Hydro | 1980.4444444444443 | Strawberry Water Users Assn | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33803 | 2019 | 8.514 | 7.848 | 4.974 | 4.915 | 12.86 | 7.1930000000000005 | 13.871 | U.S. Energy Information Administration | 9.52 | 10.38 | 9.4 | 11.23 | 8.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32337 | 32337 | USA | United States of America | Sanford Dam | USA0050157 | 3.6 | 43.6773 | -84.3802 | Hydro | 1923.0 | Boyce Hydro Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37308 | 2019 | 9.045 | 8.364 | 5.11 | 9.749 | 11.534 | 11.592 | 13.452 | U.S. Energy Information Administration | 13.87 | 14.41 | 11.5 | 12.98 | 12.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31387 | 31387 | USA | United States of America | Philadlephia | USA0010197 | 3.6 | 44.1586 | -75.7088 | Hydro | 1986.0 | EONY Generation Limited | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.83 | 8.325 | 0.926 | 6.121 | 12.72 | 10.197 | 14.769 | U.S. Energy Information Administration | 11.25 | 12.92 | 11.5 | 11.33 | 12.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
31475 | 31475 | USA | United States of America | Pittsford | USA0003722 | 3.6 | 43.694 | -72.955 | Hydro | 1914.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.848 | 8.439 | 8.359 | 7.725 | 9.608 | 10.15 | 11.389 | U.S. Energy Information Administration | 8.3 | 8.3 | 8.46 | 8.32 | 7.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
30714 | 30714 | USA | United States of America | Niagara | USA0003778 | 3.6 | 37.2544 | -79.8756 | Hydro | 1954.0 | Appalachian Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13362 | 2019 | 10.449 | 8.006 | 0.0 | 0.0 | 0.0 | 7.858 | 10.524 | U.S. Energy Information Administration | 7.67 | 8.96 | 7.46 | 8.98 | 8.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29465 | 29465 | USA | United States of America | Lake Lure | USA0002773 | 3.6 | 35.4259 | -82.184 | Hydro | 1927.0000000000005 | Lake Lure Town of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 24464 | 2019 | 11.62656 | 7.99524 | 6.272 | 7.99 | 5.492 | 10.526 | 10.171 | U.S. Energy Information Administration | 8.0 | 8.0 | 7.95 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31858 | 31858 | USA | United States of America | Redbridge | USA0001638 | 3.6 | 42.176 | -72.4095 | Hydro | 1930.0 | Central Rivers Power MA LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36698 | 2019 | 11.68 | 8.595 | 6.6240000000000006 | 6.694 | 10.719 | 22.792 | 17.848 | U.S. Energy Information Administration | 9.0 | 10.38 | 10.05 | 9.02 | 10.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30510 | 30510 | USA | United States of America | Murphys | USA0000261 | 3.6 | 38.1471 | -120.4464 | Hydro | 1954.0 | Utica Water & Power Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29404 | 2019 | 12.227 | 11.545 | 6.187 | 13.756 | 18.573 | 14.187 | 14.963 | U.S. Energy Information Administration | 8.3 | 8.3 | 8.46 | 8.32 | 7.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32937 | 32937 | USA | United States of America | Stampede | USA0007066 | 3.6 | 39.4704 | -120.1046 | Hydro | 1988.0 | U S Bureau of Reclamation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35671 | 2019 | 13.2 | 9.542 | 3.496 | 4.982 | 13.538 | 9.61 | 12.236 | U.S. Energy Information Administration | 8.0 | 8.0 | 7.9 | 8.02 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25780 | 25780 | USA | United States of America | Brassua Hydroelectric Project | USA0010555 | 3.6 | 45.6603 | -69.8122 | Hydro | 1989.0 | Brassua Hydroelectric LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34037 | 2019 | 16.740000000000002 | 15.548 | 15.582 | 17.404 | 19.295 | 16.339 | 15.207 | U.S. Energy Information Administration | 14.49 | 14.76 | 12.09 | 14.65 | 12.85 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26980 | 26980 | USA | United States of America | Dayton Hydro | USA0010520 | 3.6 | 41.3878 | -88.7897 | Hydro | 1925.0 | Midwest Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 17.563 | 19.951 | 15.878 | 21.31 | 19.595 | 21.856 | 23.487 | U.S. Energy Information Administration | 14.03 | 13.87 | 12.5 | 15.02 | 12.84 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33924 | 33924 | USA | United States of America | Wainiha Hydro | USA0010413 | 3.6 | 22.1963 | -159.5561 | Hydro | 1908.0 | McBryde Sugar Co Ltd | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 23.136 | 25.253 | 25.222 | 24.533 | 21.475 | 20.814 | 20.536 | U.S. Energy Information Administration | 13.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
25059 | 25059 | USA | United States of America | Androscoggin 3 | USA0001480 | 3.6 | 44.1353 | -70.2015 | Hydro | 1928.0 | Brookfield White Pine Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15881 | 2019 | 26.22 | 31.136 | 14.652 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 15.9 | 16.21 | 13.97 | 15.31 | 14.03 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "global-power-plants" ( "country" TEXT, "country_long" TEXT, "name" TEXT, "gppd_idnr" TEXT, "capacity_mw" REAL, "latitude" REAL, "longitude" REAL, "primary_fuel" TEXT, "other_fuel1" TEXT, "other_fuel2" TEXT, "other_fuel3" TEXT, "commissioning_year" REAL, "owner" TEXT, "source" TEXT, "url" TEXT, "geolocation_source" TEXT, "wepp_id" TEXT, "year_of_capacity_data" INTEGER, "generation_gwh_2013" REAL, "generation_gwh_2014" REAL, "generation_gwh_2015" REAL, "generation_gwh_2016" REAL, "generation_gwh_2017" REAL, "generation_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");