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 = "8.4"
This data as json, CSV (advanced)
Suggested facets: url, generation_data_source, estimated_generation_gwh_2014, estimated_generation_gwh_2016, estimated_generation_note_2013, estimated_generation_note_2015, estimated_generation_note_2016
owner 22
- AgriWind Project LLC 1
- Allete Clean Energy 1
- Centaur Mercantile Pvt. Ltd. 1
- City of Windom 1
- Energy Ottawa Inc 1
- FVE Klenovka 1
- Golden State Water Company 1
- Hazelton/Wilson Joint Venture 1
- Hydro-Electric Corporation (Tasmania) 1
- Ichigo ECO Energy Co Ltd 1
- Infinis (formerly Novera Energy) 1
- Ingredion Inc - Winston Salem 1
- Kodiak Electric Assn Inc 1
- NJR Clean Energy Ventures Corporation 1
- Nuon 1
- PNG Power Limited 1
- PNM Resources 1
- Pacific Gas & Electric Co. 1
- RWE npower 1
- Song Hong Joint Stock Corporation 1
- Sovereign Partners 1
- Xuan Thien Trading Construction Investment and Development Co 1
country_long 16
- United States of America 10
- France 6
- Germany 4
- United Kingdom 4
- Brazil 2
- India 2
- Vietnam 2
- Australia 1
- Canada 1
- Czech Republic 1
- Italy 1
- Japan 1
- Mexico 1
- Papua New Guinea 1
- Spain 1
- Turkey 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
759 | 759 | AUS | Australia | Upper Lake Margaret | AUS0000133 | 8.4 | -42.0046 | 145.5437 | Hydro | Hydro-Electric Corporation (Tasmania) | Australian Renewable Energy Mapping Infrastructure | https://www.nationalmap.gov.au/ | Australian Renewable Energy Mapping Infrastructure | 1023164 | 37.87 | 26.4975 | 47.25861111111111 | 42.23083333333334 | 48.12861111111111 | 45.38611111111111 | Australia Clean Energy Regulator | 21.96 | 21.96 | 17.83 | 17.87 | 25.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||
1249 | 1249 | BRA | Brazil | Aparecida Parte II | BRA0030275 | 8.4 | -3.1257 | -60.0233 | Oil | 1997.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) | 1011756 | 2017 | 16.59 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
3203 | 3203 | BRA | Brazil | Tabu | BRA0030099 | 8.4 | -7.5052 | -34.8669 | Biomass | 2006.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 | ||||||||||||||||||
3788 | 3788 | CAN | Canada | Chaudiere 2 | CAN0007746 | 8.4 | 45.4191 | -75.7139 | Hydro | Energy Ottawa Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 45.25 | 45.17 | 44.07 | 45.29 | 45.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
9558 | 9558 | CZE | Czech Republic | Klenovka Solar Power Plant | WRI1029667 | 8.4 | 50.0209 | 15.5919 | Solar | FVE Klenovka | Elektrarny | http://www.elektrarny.pro/detail.php?id=1927 | Industry About | 10.91 | 12.31 | 12.31 | 11.69 | 11.53 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
10757 | 10757 | FRA | France | Collorec | WRI1024656 | 8.4 | 48.2915 | -3.7716 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 15.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
11476 | 11476 | FRA | France | Maure-de-Bretagne | WRI1024657 | 8.4 | 47.8971 | -1.9981 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 15.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
11589 | 11589 | FRA | France | Méautis | WRI1024658 | 8.4 | 49.2812 | -1.2951 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 15.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
11807 | 11807 | FRA | France | Péré | WRI1024655 | 8.4 | 46.0924 | -0.8163 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 15.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||||
11953 | 11953 | FRA | France | Saint-Congard | WRI1024659 | 8.4 | 47.768 | -2.3283 | Wind | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 1115112 | 15.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
12372 | 12372 | FRA | France | Villard-sur-Doron | WRI1024660 | 8.4 | 45.7274 | 6.5193 | Hydro | Open Power System Data | http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ | Open Power System Data | 20.97 | 21.58 | 25.04 | 21.64 | 24.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
12856 | 12856 | DEU | Germany | Grabow | WKS0066153 | 8.4 | 53.2651 | 11.5728 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 11.59 | 12.1 | 12.32 | 12.32 | 12.19 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
12901 | 12901 | DEU | Germany | G�ttelborn Solar Power Plant | WRI1030290 | 8.4 | 49.3386 | 7.035 | Solar | City Solar AG | http://enipedia.tudelft.nl/wiki/City_Solar_Ag | Industry About | 11.53 | 12.12 | 12.35 | 12.16 | 12.33 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
13607 | 13607 | DEU | Germany | Sörup E1 | WKS0068645 | 8.4 | 54.718 | 9.622 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 11.86 | 12.13 | 12.29 | 12.33 | 12.29 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
13639 | 13639 | DEU | Germany | Trier | WKS0060190 | 8.4 | 49.854 | 6.78 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 11.19 | 12.26 | 12.3 | 11.69 | 12.19 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
14648 | 14648 | IND | India | Jogipet | WKS0071771 | 8.4 | 17.866 | 78.016 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 15.97 | 16.46 | 17.13 | 16.69 | 17.36 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
15434 | 15434 | IND | India | Sonu Wind Farm | WRI1026764 | 8.4 | 27.2081 | 70.6958 | Wind | Centaur Mercantile Pvt. Ltd. | CDM | https://cdm.unfccc.int/Projects/DB/LRQA%20Ltd1321971513.67/view | WRI | 12.19 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
16399 | 16399 | ITA | Italy | Santa Croce Camerina | WKS0060189 | 8.4 | 36.814 | 14.542 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.8 | 15.62 | 14.91 | 15.25 | 16.69 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
16730 | 16730 | JPN | Japan | Nago Futami Solar Power Plant | WRI1026530 | 8.4 | 26.5451 | 128.0296 | Solar | Ichigo ECO Energy Co Ltd | Ichigo ECO Energy Co Ltd | https://www.ichigo.gr.jp/eco/english/ | Industry About | 15.02 | 15.06 | 15.73 | 15.79 | 15.03 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
17557 | 17557 | MEX | Mexico | Zumpimito | MEX0006567 | 8.4 | 19.3607 | -102.0697 | Hydro | CFE | http://base.energia.gob.mx/nacei/Archivos/3%20P%C3%A1gina%20Datos%20de%20Infraestructura/Ingl%C3%A9s/PowerPlantsRenewGE1MW_NorthAmerica_201606.xlsx | North American Cooperation on Energy Information and Comisión Reguladora de Energía | 1013179 | 2016 | 26.19 | 22.0 | 22.16 | 22.22 | 22.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
18278 | 18278 | PNG | Papua New Guinea | Ulagunan | WRI1022422 | 8.4 | -4.3557 | 152.2454 | Oil | PNG Power Limited | PNG Power Limited | http://www.pngpower.com.pg/pdfs/PNG-Power-Info-Booklet-2016.pdf | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
20393 | 20393 | ESP | Spain | Isla Mayor | WKS0060191 | 8.4 | 37.1488 | -6.1452 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 16.18 | 16.03 | 15.19 | 14.6 | 15.86 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21693 | 21693 | TUR | Turkey | Altınekin | WKS0068673 | 8.4 | 38.282 | 32.882 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.61 | 13.51 | 13.31 | 13.49 | 13.35 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
22156 | 22156 | GBR | United Kingdom | Beinn Ghlas | GBR0003295 | 8.4 | 56.3823 | -5.2977 | Wind | RWE npower | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1040486 | 21.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23405 | 23405 | GBR | United Kingdom | Land at Heywood Grange | GBR0005015 | 8.4 | 52.997 | -2.0604 | Solar | Sovereign Partners | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 11.5 | 12.4 | 12.13 | 12.17 | 12.55 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23882 | 23882 | GBR | United Kingdom | Parc Cynog Extension | GBR0002950 | 8.4 | 51.7592 | -4.5337 | Wind | Nuon | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 21.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24204 | 24204 | GBR | United Kingdom | Sisters | GBR0004167 | 8.4 | 55.2499 | -1.6182 | Wind | Infinis (formerly Novera Energy) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1108367 | 21.17 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24873 | 24873 | USA | United States of America | Agriwind | USA0056408 | 8.4 | 41.3017 | -89.6236 | Wind | 2007.0 | AgriWind Project LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 62635 | 2019 | 5.952 | 6.271 | 6.235 | 5.891 | 23.378 | 20.756 | 15.456 | U.S. Energy Information Administration | 19.56 | 21.87 | 19.66 | 20.22 | 21.16 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
25413 | 25413 | USA | United States of America | Bear Valley Power Plant | USA0056346 | 8.4 | 34.2506 | -116.9025 | Gas | 2005.0 | Golden State Water Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 52891 | 2019 | 0.058 | 0.0 | 0.048 | -0.036 | 0.174 | 0.056 | 0.385 | U.S. Energy Information Administration | 29.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26453 | 26453 | USA | United States of America | Cisco | USA0063431 | 8.4 | 43.6256 | -95.3725 | Wind | 2008.0 | Allete Clean Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 17.583000000000002 | U.S. Energy Information Administration | 26.03 | 22.4 | 21.71 | 26.03 | 26.1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||||||||
28910 | 28910 | USA | United States of America | Ingredion Winston Salem | USA0054618 | 8.4 | 36.0338 | -80.2274 | Waste | Coal | Gas | 1986.75 | Ingredion Inc - Winston Salem | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17759 | 2019 | 39.18412 | 49.194 | 55.609 | 41.277 | 8.75037 | 29.381000000000004 | 45.605 | U.S. Energy Information Administration | 1.52 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
29945 | 29945 | USA | United States of America | Manzano Solar | USA0058521 | 8.4 | 34.7467 | -106.6544 | Solar | 2013.0 | PNM Resources | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.508 | 18.826 | 18.078 | 18.799 | 18.901 | 18.631 | 18.061 | U.S. Energy Information Administration | 18.34 | 18.41 | 17.87 | 18.32 | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | |||||
31813 | 31813 | USA | United States of America | Raritan Solar - 53 Highway | USA0061601 | 8.4 | 40.4539 | -74.863 | Solar | 2018.0 | NJR Clean Energy Ventures Corporation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.916 | 12.238 | U.S. Energy Information Administration | 13.68 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
33153 | 33153 | USA | United States of America | Swampy Acres Microgrid | USA0060250 | 8.4 | 57.7756 | -152.4803 | Oil | 2008.809523809524 | Kodiak Electric Assn Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 47745 | 2019 | 0.0 | 0.0 | 0.036 | 0.0 | 0.0 | U.S. Energy Information Administration | 4.92 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
33512 | 33512 | USA | United States of America | Tule River | USA0000289 | 8.4 | 36.1631 | -118.7071 | Hydro | 1914.0 | Pacific Gas & Electric Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 5.508 | 1.656 | -2.389 | 14.898 | 0.0 | 0.001 | 0.0 | U.S. Energy Information Administration | 22.0 | 22.0 | 21.01 | 22.06 | 19.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
34352 | 34352 | USA | United States of America | Wilson Lake Hydroelectric Project | USA0054306 | 8.4 | 42.6289 | -114.1747 | Hydro | 1993.0 | Hazelton/Wilson Joint Venture | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22743 | 2019 | 26.493 | 26.868 | 27.395 | 25.933 | 25.144 | 26.672 | 25.457 | U.S. Energy Information Administration | 22.3 | 20.8 | 20.89 | 21.17 | 18.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34376 | 34376 | USA | United States of America | Windom | USA0002023 | 8.4 | 43.8681 | -95.1144 | Oil | 1993.5 | City of Windom | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37091 | 2019 | 0.015 | 0.034 | 0.015 | 0.019 | 0.015 | 0.0849999999999999 | 0.03 | U.S. Energy Information Administration | 4.92 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34769 | 34769 | VNM | Vietnam | Hang Dong A1 | WRI1030885 | 8.4 | 21.2658 | 104.5407 | Hydro | 2012.0 | Xuan Thien Trading Construction Investment and Development Co | Open Development Vietnam | https://vietnam.opendevelopmentmekong.net/dataset/?id=danh-sach-cac-th-y-di-n-t-i-vi-t-nam-tinh-d-n-thang-06-2016&search_query=P3BhZ2U9Mg== | Open Development Vietnam | 1093412 | 30.9 | 28.73 | 25.65 | 29.86 | 19.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
34826 | 34826 | VNM | Vietnam | Ngoi Hut 1 | WRI1030909 | 8.4 | 21.8093 | 104.4361 | Hydro | 2011.0 | Song Hong Joint Stock Corporation | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ngoi-hut-1-hydropower | Open Development Vietnam | 1062841 | 36.0 | Open Development Vietnam | 30.32 | 28.16 | 25.07 | 29.28 | 18.62 | 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");