global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
38 rows where commissioning_year = "1957.0" and primary_fuel = "Hydro"
This data as json, CSV (advanced)
Suggested facets: country, geolocation_source
owner 20
- 100% Vattenfall 2
- E.ON Kraftwerke GmbH 2
- EDF 2
- Erie Boulevard Hydropower LP 2
- IBERDROLA GENERACION S.A. 2
- Oakdale&South San Joaquin Irrigation D. 2
- 51% Statkraft 1
- AzerEnerji 1
- Brookfield Smoky Mountain Hydropower LP 1
- CEZ Group 1
- EPEC 1
- Great River Hydro LLC 1
- HINISA 1
- Imperial Irrigation District 1
- JSC "Vitimenergosbyt" 1
- Korea Hydro and Nuclear 1
- PacifiCorp 1
- Societe Nationale D'elec 1
- Southern California Edison Co 1
- Vattenfall Europe Generation AG 1
country_long 14
- United States of America 9
- India 5
- Switzerland 4
- Brazil 3
- Germany 3
- Sweden 3
- Argentina 2
- France 2
- Spain 2
- Azerbaijan 1
- Czech Republic 1
- Democratic Republic of the Congo 1
- Russia 1
- South Korea 1
primary_fuel 1
- Hydro · 38 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
258 | 258 | ARG | Argentina | LOS MOLINOS I | ARG0000096 | 59.04 | -31.838 | -64.4452 | Hydro | 1957.0 | EPEC | Ministerio de Energía y Minería | http://energia3.mecon.gov.ar/contenidos/archivos/Reorganizacion/informacion_del_mercado/publicaciones/mercado_electrico/estadisticosectorelectrico/2015/A1.POT_GEN_COMB_POR_CENTRAL_2015.xlsx | Ministerio de Energía y Minería | 1009876 | 2015 | 122.29 | 136.89 | 187.39 | 164.98 | 135.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
270 | 270 | ARG | Argentina | NIHUIL I | ARG0000214 | 74.24 | -34.9907 | -68.6237 | Hydro | 1957.0 | HINISA | Ministerio de Energía y Minería | http://energia3.mecon.gov.ar/contenidos/archivos/Reorganizacion/informacion_del_mercado/publicaciones/mercado_electrico/estadisticosectorelectrico/2015/A1.POT_GEN_COMB_POR_CENTRAL_2015.xlsx | Ministerio de Energía y Minería | 1018404 | 2015 | 224.77 | 223.41 | 266.72 | 264.03 | 223.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
938 | 938 | AZE | Azerbaijan | Varvara | WRI1002201 | 16.0 | 40.6837 | 47.0926 | Hydro | 1957.0 | AzerEnerji | AzerEnerji | http://www.azerenerji.gov.az/index.php?option=com_content&view=article&id=91&Itemid=112&lang=az | GEODB | 1010581 | 72.11 | 69.4 | 72.28 | 70.06 | 72.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
2105 | 2105 | BRA | Brazil | Guaricana | BRA0001075 | 36.0 | -25.7148 | -48.9745 | Hydro | 1957.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) | 1012662 | 2017 | 119.24 | 155.0 | 149.67 | 146.91 | 128.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
2407 | 2407 | BRA | Brazil | Marechal Mascarenhas de Moraes (Antiga Peixoto) | BRA0002038 | 492.1 | -20.2878 | -47.0661 | Hydro | 1957.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) | 1017338 | 2017 | 2015.07 | 2228.29 | 1636.47 | 1873.27 | 1677.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
2617 | 2617 | BRA | Brazil | Paranapanema | BRA0001972 | 31.5 | -23.1869 | -49.3839 | Hydro | 1957.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) | 1012603 | 2017 | 109.27 | 132.08 | 130.2 | 136.86 | 117.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
9609 | 9609 | CZE | Czech Republic | Lipno II | WRI1019183 | 1.5 | 48.6333 | 14.2375 | Hydro | 1957.0 | CEZ Group | CEZ Group | https://www.cez.cz/en/power-plants-and-environment/hydroelectric-power-plants.html | GEODB | 1065735 | 5.41 | 3.83 | 4.03 | 4.06 | 4.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
9890 | 9890 | COD | Democratic Republic of the Congo | Nzilo | WRI1000007 | 228.0 | -10.5024 | 25.4458 | Hydro | 1957.0 | Societe Nationale D'elec | International Journal on Hydropower and Dams | http://www.hydropower-dams.com/pdfs/2017_Africa_Map.pdf and http://enipedia.tudelft.nl/wiki/N%27zilo_Powerplant | GEODB | 1029297 | 739.39 | 630.69 | 613.28 | 614.97 | 613.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
10365 | 10365 | FRA | France | Argentat | WRI1026718 | 47.5 | 45.104 | 1.954 | Hydro | 1957.0 | EDF | EDF | https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower | GEODB | 1014617 | 119.49 | 145.4 | 144.19 | 144.56 | 160.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
11019 | 11019 | FRA | France | Grangent | WRI1026701 | 37.0 | 45.467 | 4.248 | Hydro | 1957.0 | EDF | EDF | https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower | GEODB | 1014799 | 88.49 | 105.63 | 125.28 | 104.67 | 115.99 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
12700 | 12700 | DEU | Germany | Dingolfing | WRI1005632 | 15.0 | 48.634 | 12.4837 | Hydro | 1957.0 | E.ON Kraftwerke GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1024985 | 77.7 | 58.42 | 65.69 | 61.36 | 58.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
12894 | 12894 | DEU | Germany | Gummering | WRI1005725 | 14.8 | 48.6225 | 12.398 | Hydro | 1957.0 | E.ON Kraftwerke GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 1024988 | 76.67 | 57.64 | 64.81 | 60.54 | 57.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
13357 | 13357 | DEU | Germany | Niederwartha | WRI1005980 | 39.8 | 51.0915 | 13.6098 | Hydro | 1957.0 | Vattenfall Europe Generation AG | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 177.12 | 130.88 | 154.68 | 131.24 | 130.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
14493 | 14493 | IND | India | GANGUWAL | IND0000124 | 77.65 | 31.268 | 76.492 | Hydro | 1957.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1011039 | 2019 | 420.77555 | 419.82035 | 414.4573 | 491.61955 | 596.37315 | Central Electricity Authority | 328.66 | 317.74 | 324.62 | 292.71 | 304.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14713 | 14713 | IND | India | KOTLA | IND0000215 | 77.65 | 31.268 | 76.492 | Hydro | 1957.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1011040 | 2019 | 428.1684 | 428.29775 | 428.4271 | 505.6789 | 606.552 | Central Electricity Authority | 328.66 | 317.74 | 324.62 | 292.71 | 304.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14884 | 14884 | IND | India | MACHKUND | IND0000243 | 114.75 | 18.5323 | 82.4645 | Hydro | 1957.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1010148 | 2019 | 517.1910499999999 | 475.08265 | 696.80845 | 465.3615 | 590.7116 | Central Electricity Authority | 463.71 | 389.44 | 412.35 | 354.96 | 332.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14894 | 14894 | IND | India | MAITHON | IND0000250 | 63.2 | 23.7872 | 86.8284 | Hydro | 1957.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1063096 | 2019 | 137.3498 | 107.0023 | 121.41985 | 113.83795 | 100.8532 | Central Electricity Authority | 249.93 | 209.02 | 241.84 | 172.31 | 189.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
15550 | 15550 | IND | India | UMTRU (NEW) | IND0000478 | 11.2 | 26.0069 | 91.8114 | Hydro | 1957.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1022472 | 2019 | 54.18 | 40.9 | 54.11 | 35.22 | 42.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
19448 | 19448 | RUS | Russia | Mamakanskaya HPP | WRI1062093 | 86.0 | 57.8092 | 114.0322 | Hydro | 1957.0 | JSC "Vitimenergosbyt" | EnergyBase (RUS) | https://energybase.ru/power-plant/mamakansky-hpp | EnergyBase (RUS) | 327.26 | 263.46 | 329.36 | 316.28 | 272.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20044 | 20044 | KOR | South Korea | Goesan | WRI1000226 | 2.8 | 36.8108 | 127.7947 | Hydro | 1957.0 | Korea Hydro and Nuclear | KHNP | https://cms.khnp.co.kr/eng/hydroelectric-plants/ | CARMA | 1048950 | 7.79 | 7.27 | 6.87 | 7.29 | 7.27 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20201 | 20201 | ESP | Spain | BARAZAR 1 | WRI1006226 | 82.7 | 43.1 | -2.75 | Hydro | 1957.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | CARMA | 1019084 | 274.01 | 274.01 | 184.76 | 274.76 | 175.15 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
20471 | 20471 | ESP | Spain | MONTEFURADO 3 | WRI1006689 | 44.29 | 42.4768 | -7.2746 | Hydro | 1957.0 | IBERDROLA GENERACION S.A. | Red Eléctrica de España | http://www.ree.es/en/statistical-data-of-spanish-electrical-system/annual-report/preliminary-report-spanish-electricity-system-2015 | CARMA | 1019198 | 141.4 | 141.4 | 93.04 | 142.7 | 73.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
21090 | 21090 | SWE | Sweden | Harrsele | WRI1002058 | 223.0 | 64.0155 | 19.5619 | Hydro | 1957.0 | 51% Statkraft | Statkraft | http://www.statkraft.com/energy-sources/Power-plants/Sweden/Harrsele/ | WRI | 1018182 | 762.48 | 868.36 | 923.16 | 753.15 | 897.61 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
21133 | 21133 | SWE | Sweden | Ligga | WRI1002104 | 332.0 | 66.8094 | 19.8968 | Hydro | 1957.0 | 100% Vattenfall | Vattenfall | http://powerplants.vattenfall.com/#/countries=Sweden/view=list/sort=elcap | GEODB | 1032788 | 453.658 | 158.423 | JRC-PPDB-OPEN | 1073.12 | 1180.25 | 1326.4 | 1028.91 | 1227.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||
21193 | 21193 | SWE | Sweden | Umluspen | WRI1002131 | 100.0 | 65.0959 | 17.1173 | Hydro | 1957.0 | 100% Vattenfall | Vattenfall | http://powerplants.vattenfall.com/#/countries=Sweden/view=list/sort=elcap | CARMA | 1032828 | 404.2 | 414.57 | 372.99 | 379.78 | 428.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
21241 | 21241 | CHE | Switzerland | Croix | WRI1004136 | 66.0 | 46.3087 | 7.4356 | Hydro | 1957.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | GEODB | 1015149 | 205.32 | 255.66 | 208.11 | 203.15 | 217.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21250 | 21250 | CHE | Switzerland | Fionnay (Dixence) | WRI1004178 | 306.0 | 46.0731 | 7.4034 | Hydro | 1957.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | GEODB | 1017763 | 741.16 | 849.47 | 697.67 | 668.17 | 672.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21253 | 21253 | CHE | Switzerland | Gabi | WRI1004189 | 11.33 | 46.1882 | 8.0702 | Hydro | 1957.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | GEODB | 1016328 | 27.26 | 29.8 | 29.8 | 29.06 | 34.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
21334 | 21334 | CHE | Switzerland | Safien Platz | WRI1004486 | 90.0 | 46.6826 | 9.3157 | Hydro | 1957.0 | Swiss Federal Office of Energy | http://www.bfe.admin.ch/themen/00490/00491/index.html?lang=en | CARMA | 1021362 | 242.4 | 258.62 | 258.62 | 252.84 | 296.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
25416 | 25416 | USA | United States of America | Beardsley | USA0000414 | 10.0 | 38.2026 | -120.077 | Hydro | 1957.0 | Oakdale&South San Joaquin Irrigation D. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28662 | 2019 | 34.571 | 15.182 | 18.739 | 68.443 | 84.257 | 53.455 | 68.18900000000001 | U.S. Energy Information Administration | 33.84 | 29.49 | 25.96 | 32.04 | 32.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25627 | 25627 | USA | United States of America | Blake | USA0002547 | 15.0 | 44.5065 | -74.7534 | Hydro | 1957.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27793 | 2019 | 64.116 | 58.115 | 52.242 | 51.528 | 75.858 | 60.615 | 75.09 | U.S. Energy Information Administration | 64.61 | 68.83 | 56.56 | 66.59 | 60.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26409 | 26409 | USA | United States of America | Chilhowee | USA0054901 | 49.8 | 35.5453 | -84.0503 | Hydro | 1957.0 | Brookfield Smoky Mountain Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34173 | 2019 | 240.909 | 151.78300000000002 | 97.998 | 11.016 | 78.46900000000001 | 194.467 | 219.77 | U.S. Energy Information Administration | 196.87 | 180.93 | 169.24 | 185.58 | 154.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27158 | 27158 | USA | United States of America | Donnells | USA0000415 | 72.0 | 38.2467 | -120.0341 | Hydro | 1957.0 | Oakdale&South San Joaquin Irrigation D. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28663 | 2019 | 207.972 | 134.635 | 143.134 | 347.22 | 434.431 | 129.198 | 302.325 | U.S. Energy Information Administration | 210.56 | 193.87 | 168.96 | 196.32 | 205.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27280 | 27280 | USA | United States of America | Eagle Point | USA0003024 | 2.8 | 42.5146 | -122.7571 | Hydro | 1957.0 | PacifiCorp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29502 | 2019 | 16.334 | 16.187 | 16.857 | 18.526 | 18.371 | 16.411 | 16.812 | U.S. Energy Information Administration | 9.73 | 10.01 | 10.39 | 11.08 | 9.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31417 | 31417 | USA | United States of America | Pilot Knob | USA0000388 | 33.0 | 32.7366 | -114.7139 | Hydro | 1957.0 | Imperial Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22909 | 2019 | 20.569 | 22.206 | 22.674 | 23.619 | 25.55 | 31.763 | 23.465 | U.S. Energy Information Administration | 114.16 | 115.05 | 83.29 | 115.85 | 98.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31558 | 31558 | USA | United States of America | Portal | USA0000354 | 10.8 | 37.257 | -119.1589 | Hydro | 1957.0 | Southern California Edison Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33157 | 2019 | 15.953 | 22.88 | 9.696 | 11.019 | 33.309 | 9.717 | 21.961 | U.S. Energy Information Administration | 28.29 | 28.29 | 26.14 | 28.37 | 24.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32138 | 32138 | USA | United States of America | S C Moore | USA0002351 | 190.8 | 44.3356 | -71.8742 | Hydro | 1957.0 | Great River Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27445 | 2019 | 267.08 | 280.85 | 268.199 | 233.359 | 317.125 | 266.391 | 336.232 | U.S. Energy Information Administration | 578.24 | 636.31 | 390.21 | 577.33 | 531.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32948 | 32948 | USA | United States of America | Stark | USA0002613 | 26.0 | 44.4553 | -74.7614 | Hydro | 1957.0 | Erie Boulevard Hydropower LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 27865 | 2019 | 106.171 | 91.567 | 82.824 | 80.566 | 116.919 | 95.999 | 123.538 | U.S. Energy Information Administration | 91.0 | 96.39 | 74.4 | 94.34 | 81.94 | 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");