global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
39 rows where capacity_mw = "34.0"
This data as json, CSV (advanced)
Suggested facets: country, commissioning_year, source, geolocation_source, year_of_capacity_data, generation_gwh_2013, generation_gwh_2014, generation_gwh_2017, estimated_generation_gwh_2017, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2016
owner 24
- CENTRALES DE LA COSTA ATLANTICA SA 1
- ENERGIAS RENOVABLES DE LA REGION DE MURCIA 1
- EOLICA MONTE REDONDO S.A. 1
- Foresight Solar Fund 1
- IBERENOVA PROMOCIONES S.A. 1
- JSC "Chukotenergo" 1
- Korea Electric Power Company 1
- MB Holding 1
- MVA Bielefeld-Herford GmbH 1
- Maui Electric Co Ltd 1
- Mercury Energy 1
- OOO LUKOIL-Rostovenergo 1
- PGE 1
- PT. Pakerin (pulp industry) 1
- Polenergia 1
- Renewables Infrastructure Group (TRIG) 1
- Scottish Power Renewables 1
- Scottish and Southern: Hydro Schemes - Tummel 1
- Southern Hydropower JSC. 1
- Tesoro Refining & Marketing Company LLC 1
- Uniper UK Limited 1
- Verbund 1
- Vortex Energy 1
- WestRock Corp-Panama City 1
country_long 23
primary_fuel 10
- Wind 13
- Hydro 9
- Gas 5
- Biomass 2
- Geothermal 2
- Oil 2
- Solar 2
- Waste 2
- Coal 1
- Cogeneration 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
263 | 263 | ARG | Argentina | MAR DE AJO | ARG0000006 | 34.0 | -36.7208 | -63.1977 | Gas | CENTRALES DE LA COSTA ATLANTICA SA | 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 | 1011951 | 2015 | 190.43 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
894 | 894 | AUT | Austria | Rosenau | WRI1005233 | 34.0 | 48.489 | 14.6288 | Hydro | 1953.0 | Verbund | Verbund | http://www.verbund.com/pp/de/region/oesterreich | CARMA | 1016515 | 97.25 | 121.97 | 91.92 | 92.17 | 91.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
1111 | 1111 | BOL | Bolivia | Chururaqui Hydroelectric Power Plant Bolivia | GEODB0044746 | 34.0 | -16.105 | -68.067 | Hydro | GEODB | http://globalenergyobservatory.org | GEODB | 1012480 | 2017 | 97.51 | 134.92 | 98.39 | 107.99 | 100.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
1119 | 1119 | BOL | Bolivia | Huaji Hydroelectric Power Plant Bolivia | GEODB0044749 | 34.0 | -16.0416 | -67.9566 | Hydro | GEODB | http://globalenergyobservatory.org | GEODB | 1012485 | 2017 | 97.51 | 134.92 | 98.39 | 107.99 | 100.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
2103 | 2103 | BRA | Brazil | Guarani Tanabi 2 | BRA0031445 | 34.0 | -20.4818 | -49.5282 | Biomass | 2015.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 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
3294 | 3294 | BRA | Brazil | Unidade de Geração de Energia Elétrica - Agrenco - Mato Grosso | BRA0029649 | 34.0 | -17.2901 | -53.2675 | Biomass | 2015.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 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
4893 | 4893 | CHL | Chile | LAJA 1 | CHL0001059 | 34.0 | -37.2441 | -72.5302 | Hydro | EOLICA MONTE REDONDO S.A. | Energía Abierta | http://energiaabierta.cl/electricidad/ | Energía Abierta | 2016 | 120.39 | 112.33 | 127.85 | 103.74 | 119.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
5529 | 5529 | CHN | China | Datang Jia County Yunyang | WRI1072296 | 34.0 | 33.8772 | 113.3644 | Wind | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6793 | UNFCCC CDM Registry | 63.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
5556 | 5556 | CHN | China | Datang Qingyuan Phase 2 Wind | WRI1071792 | 34.0 | 36.7728 | 111.4175 | Wind | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5199 | UNFCCC CDM Registry | 63.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
6959 | 6959 | CHN | China | Jiangxi Jiujiang Changling | WRI1071142 | 34.0 | 29.5261 | 116.0864 | Wind | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2809 | UNFCCC CDM Registry | 1086084 | 63.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
11889 | 11889 | FRA | France | Roye | WRI1023968 | 34.0 | 49.6727 | 2.7927 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 62.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
12404 | 12404 | FRA | France | Vitry-la-Ville | WRI1023967 | 34.0 | 48.8249 | 4.4015 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 1068937 | 62.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
13250 | 13250 | DEU | Germany | MVA Bielefeld | WRI1005962 | 34.0 | 52.0427 | 8.6072 | Waste | 1981.0 | MVA Bielefeld-Herford GmbH | Open Power System Data | http://data.open-power-system-data.org/ | Open Power System Data | 71.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
14159 | 14159 | IND | India | BHANDARDHARA | IND0000048 | 34.0 | 19.5555 | 73.8087 | Hydro | 1996.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1022179 | 2019 | 65.07300000000001 | 82.13725 | 46.8844 | 42.33725 | 56.1578 | Central Electricity Authority | 121.97 | 101.82 | 121.97 | 85.62 | 94.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
14770 | 14770 | IND | India | Kamareddy SP | WKS0067116 | 34.0 | 18.38 | 78.265 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 72.75 | 77.34 | 78.35 | 78.37 | 81.32 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
15762 | 15762 | IDN | Indonesia | PLTU Pakerin | WRI1000965 | 34.0 | -2.5213 | 121.357 | Coal | PT. Pakerin (pulp industry) | Indonesia Power Generation | https://repit.wordpress.com/ | CARMA | 185.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
17229 | 17229 | MYS | Malaysia | Sandakan Power Corporation(IPP) | WRI1000265 | 34.0 | 5.8124 | 118.0642 | Oil | Penisular Malaysia Electricity Supply Company | http://www.st.gov.my/index.php/component/k2/item/606-peninsular-malaysia-electricity-supply-industry-outlook-2014.html | GEODB | 1047114 | 16.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
17784 | 17784 | NZL | New Zealand | Rotokawa | WRI1000325 | 34.0 | -38.6125 | 176.1932 | Geothermal | 2000.0 | Mercury Energy | Mercury Energy | https://www.mercury.co.nz/About/Renewable-Energy/Geothermal-Generation.aspx | GEODB | 1025693 | 253.9 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
18052 | 18052 | NOR | Norway | Lakshola | WRI1003308 | 34.0 | 67.4482 | 15.7505 | Hydro | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show?name=&defaultValue=true&viewType=TABLE&areaType=BZN&atch=false&dateTime.dateTime=01.01.2016+00:00|UTC|YEAR&area.values=CTY|10YNO-0--------C!BZN|10YNO-1--------2&productionType.values=B01&productionType.values=B02&productionType.values=B03&productionType.values=B04&productionType.values=B05&productionType.values=B06&productionType.values=B07&productionType.values=B08&productionType.values=B09&productionType.values=B10&productionType.values=B11&productionType.values=B12&productionType.values=B13&productionType.values=B14&productionType.values=B20&productionType.values=B15&productionType.values=B16&productionType.values=B17&productionType.values=B18&productionType.values=B19&DataTables_Table_0_length=229 | WRI | 1047932 | 136.23 | 128.33 | 128.33 | 128.68 | 128.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
18511 | 18511 | POL | Poland | EW Lake Ostrowo | WRI1061556 | 34.0 | 53.8333 | 14.6673 | Wind | 2007.0 | PGE | PGE Energia Odnawialna | https://pgeeo.pl/Nasze-obiekty/Elektrownie-wiatrowe/Lake-Ostrowo | University of Dąbrowa Górnicza | 90.53 | 100.78 | 92.4 | 86.12 | 112.7 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||||||||||||
18547 | 18547 | POL | Poland | FW Mogilno I-VI | WRI1061596 | 34.0 | 52.8157 | 18.1439 | Wind | 2011.0 | Vortex Energy | Vortex Energy | https://vortex-energy-group.com/pl/portfolio-galleries/park-wiatrowy-w-mogilnie-i-v/ | University of Dąbrowa Górnicza | 106.33 | 95.8 | 96.39 | 95.47 | 96.15 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||||||||||||
18567 | 18567 | POL | Poland | FW Łukaszów | WRI1061588 | 34.0 | 51.1809 | 15.9079 | Wind | 2012.0 | Polenergia | Polenergia | http://polenergia.pl/pol/pl/page/farmy-wiatrowe-wlasne | University of Dąbrowa Górnicza | 99.87 | 105.5 | 99.91 | 94.68 | 97.41 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||||||||||||
18817 | 18817 | PRT | Portugal | Lagoa de D. João e Feirão | WRI1023361 | 34.0 | 41.0317 | -7.9352 | Wind | 2008.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 107.24 | 91.85 | 76.68 | 82.18 | 81.21 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||||||||||||
19287 | 19287 | RUS | Russia | Egvenkinotskaya TPP | WRI1003701 | 34.0 | 66.4013 | -179.1338 | Gas | JSC "Chukotenergo" | EnergyBase (RUS) | https://energybase.ru/power-plant/Egvekinotskaya_TPP | EnergyBase (RUS) | 149.14 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
19386 | 19386 | RUS | Russia | Kamenskaya TPP | WRI1061767 | 34.0 | 48.3214 | 40.2394 | Gas | Oil | OOO LUKOIL-Rostovenergo | EnergyBase (RUS) | https://energybase.ru/power-plant/Kamensky_CHP | EnergyBase (RUS) | 149.14 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
20106 | 20106 | KOR | South Korea | Somjingang (Chilbo) | WRI1029845 | 34.0 | 34.9191 | 126.857 | Hydro | Korea Electric Power Company | KEPCO | https://home.kepco.co.kr/kepco/EN/C/htmlView/ENCBHP003.do?menuCd=EN030204 | WRI | 1021181 | 91.92 | 75.94 | 71.99 | 76.15 | 75.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
20557 | 20557 | ESP | Spain | P. E. LOS REVENTONES | WRI1006832 | 34.0 | 38.4792 | -1.325 | Wind | 2007.0 | ENERGIAS RENOVABLES DE LA REGION DE MURCIA | 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 | 1070262 | 87.26 | 73.31 | 80.87 | 81.56 | 78.93 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||||||||||
20709 | 20709 | ESP | Spain | P.E. VALMEDIANO | WRI1007263 | 34.0 | 41.8347 | -5.8888 | Wind | IBERENOVA PROMOCIONES 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 | 1053835 | 72.3 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
21684 | 21684 | TUN | Tunisia | Zarzis | WRI1023599 | 34.0 | 33.4701 | 11.0112 | Gas | 1984.0 | Arab Union of Electricity | https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&sqi=2&ved=0ahUKEwi_xP3Co7PQAhXH7SYKHWDVCxQQFggbMAA&url=http%3A%2F%2Fwww.auptde.org%2FNewsDetails.aspx%3Flang%3Den%26NID%3D283&usg=AFQjCNEkUcc5GeGitCkuTTJR3QTQZU1lMg&sig2=FaVNwaTMbtVIKuotQfNLwQ&bvm=bv.139250283 d.eWE | WRI | 1050689 | 192.08 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
21738 | 21738 | TUR | Turkey | Dora 3 | WRI1018960 | 34.0 | 37.857 | 28.0716 | Geothermal | 2013.0 | MB Holding | Enerji Atlasi | http://www.enerjiatlasi.com/jeotermal/dora-3-jeotermal-enerji-santrali.html | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
22919 | 22919 | GBR | United Kingdom | Garreg Lwyd | GBR0003711 | 34.0 | 52.4131 | -3.2841 | Wind | Renewables Infrastructure Group (TRIG) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 85.71 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23069 | 23069 | GBR | United Kingdom | Halsary Wind Farm | GBR2001074 | 34.0 | 58.4309 | -3.4444 | Wind | Scottish Power Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 85.71 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24012 | 24012 | GBR | United Kingdom | Ratcliffe GT | GBR1000498 | 34.0 | 52.8653 | -1.255 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 157.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24477 | 24477 | GBR | United Kingdom | Tummel | GBR1000409 | 34.0 | 56.7075 | -4.021 | Hydro | Scottish and Southern: Hydro Schemes - Tummel | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028355 | 103.51 | 75.4 | 155.51 | 95.59 | 94.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24701 | 24701 | GBR | United Kingdom | Wymeswold Airfield | GBR0001585 | 34.0 | 52.8033 | -1.1116 | Solar | Foresight Solar Fund | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1097025 | 48.25 | 49.21 | 49.5 | 49.64 | 50.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
29179 | 29179 | USA | United States of America | Kahului | USA0006056 | 34.0 | 20.8969 | -156.4627 | Oil | 1956.9411764705883 | Maui Electric Co Ltd | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25777 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 162.612 | U.S. Energy Information Administration | 19.92 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
33325 | 33325 | USA | United States of America | Tesoro Wilmington Calciner | USA0010601 | 34.0 | 33.777 | -118.2282 | Cogeneration | 1983.0 | Tesoro Refining & Marketing Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13451 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 191.101 | U.S. Energy Information Administration | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||
34165 | 34165 | USA | United States of America | WestRock Panama City Mill | USA0050807 | 34.0 | 30.142 | -85.6211 | Waste | Coal | Oil | Gas | 1950.8823529411768 | WestRock Corp-Panama City | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33752 | 2019 | 232.988257 | 236.607092 | 253.096996 | 252.692085 | 249.96188300000003 | 197.50869000000003 | 195.430539 | U.S. Energy Information Administration | 6.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
34714 | 34714 | VNM | Vietnam | Da Dang 2 | WRI1030783 | 34.0 | 11.7219 | 108.2468 | Hydro | 2010.0 | Southern Hydropower JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/da-dang-2-hydropower | Open Development Vietnam | 1063305 | 152.0 | Open Development Vietnam | 142.72 | 141.24 | 101.11 | 148.03 | 92.27 | 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");