global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where country_long = "United States of America" and estimated_generation_gwh_2017 = "2.93"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, wepp_id, generation_gwh_2017, estimated_generation_gwh_2013, estimated_generation_gwh_2015, estimated_generation_gwh_2016, estimated_generation_note_2013, estimated_generation_note_2015, estimated_generation_note_2016, estimated_generation_note_2017
owner >30
- AEP Onsite Partners 2
- AES Distributed Energy 2
- Clean Focus Renewables Inc. 2
- DG AMP Solar LLC 2
- Moore 1 2
- Ahana Renewables LLC 1
- Ashby Solar LLC 1
- Caelum Community Solar 1
- Citizens Enterprises Corporation 1
- City of Alta - (IA) 1
- City of St. John - (KS) 1
- CoreSite Real Estate 1656 McCarthy L.P. 1
- Cypress Creek Renewables 1
- DG Minnesota CSG LLC 1
- Enfield Community Solar 1
- EnterSolar 1
- GD West Greenwich Victory I LLC 1
- Green Mountain Power Corp 1
- Heritage Sustainable Energy. LLC 1
- Hoosier Energy R E C Inc 1
- Idaho Power Co 1
- LSE Cassiopeia LLC 1
- Minisink Solar 1 LLC 1
- North Central Public Pwr Dist 1
- Northstar Macy's Maryland 2015 LLC 1
- Spencer TGC Westminster LLC 1
- Tesla Inc. 1
- UGI Energy Services LLC 1
- Vitro Architectural Glass (PA) 1
- Washington Island El Coop Inc 1
- …
country_long 1
- United States of America · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24835 | 24835 | USA | United States of America | Acushnet-Braley Road 1 | USA0059121 | 1.9 | 41.7517 | -70.9706 | Solar | 2013.0 | Ahana Renewables LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.319 | 2.539 | 2.529 | 2.705 | 2.437 | 2.411 | 2.438 | U.S. Energy Information Administration | 2.92 | 2.87 | 2.94 | 2.93 | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | |||||
24973 | 24973 | USA | United States of America | Alta Municipal Utilities | USA0001121 | 5.0 | 42.6736 | -95.3026 | Oil | 2003.8 | City of Alta - (IA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 12957 | 2019 | 0.008 | 0.0 | 0.0 | 0.0 | 0.0 | 0.009 | 0.119 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
25116 | 25116 | USA | United States of America | Arapahoe 3 Community Solar Array | USA0060724 | 1.8 | 39.6384 | -104.6742 | Solar | 2017.0 | Clean Focus Renewables Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 2.767 | 3.62 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
25179 | 25179 | USA | United States of America | Ashby Duffy CSG Solar Farm | USA0061399 | 1.8 | 42.68 | -71.83 | Solar | 2018.0 | LSE Cassiopeia LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.03168 | 2.996 | 3.228 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
25180 | 25180 | USA | United States of America | Ashby Solar LLC CSG | USA0062199 | 1.8 | 42.6302 | -71.7987 | Solar | 2018.0 | Ashby Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.164 | 2.975 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
25644 | 25644 | USA | United States of America | Blue Breezes II LLC | USA0056581 | 1.3 | 43.6558 | -94.1564 | Wind | 2006.0 | Moore 1 | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 62639 | 2019 | 2.997 | 3.72 | 3.414 | 3.286 | 3.18 | 2.705 | 3.013 | U.S. Energy Information Administration | 2.77 | 2.73 | 3.14 | 2.92 | 2.93 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
25645 | 25645 | USA | United States of America | Blue Breezes LLC | USA0056580 | 1.3 | 43.6558 | -94.1536 | Wind | 2006.0 | Moore 1 | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 62639 | 2019 | 3.402 | 3.436 | 3.34 | 3.216 | 3.154 | 2.737 | 2.708 | U.S. Energy Information Administration | 2.77 | 2.73 | 3.14 | 2.92 | 2.93 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
25966 | 25966 | USA | United States of America | CBP Solar | USA0062613 | 1.8 | 41.2662 | -73.9469 | Solar | 2019.0 | EnterSolar | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.003 | 2.15 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
26002 | 26002 | USA | United States of America | CF Novel Solar CSG Gardens Two LLC | USA0061140 | 1.8 | 43.8459 | -93.8367 | Solar | 2018.0 | Cypress Creek Renewables | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 2.024 | 2.837 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26071 | 26071 | USA | United States of America | Caelum Community Solar | USA0061180 | 1.8 | 45.662 | -93.9368 | Solar | 2017.0 | Caelum Community Solar | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.498 | 3.264 | 2.673 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26111 | 26111 | USA | United States of America | Camden CSD Solar Array | USA0061604 | 1.8 | 43.3123 | -75.6953 | Solar | 2018.0 | AEP Onsite Partners | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.1 | 2.507 | 2.255 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26265 | 26265 | USA | United States of America | Cedar Creek PV | USA0061376 | 1.8 | 40.6489 | -73.5067 | Solar | 2017.0 | AES Distributed Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.72 | 2.9130000000000003 | 3.041 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26455 | 26455 | USA | United States of America | Citizens Agawam Landfill Solar | USA0061596 | 1.8 | 42.093 | -72.5972 | Solar | 2017.0 | Citizens Enterprises Corporation | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.033 | 2.852 | 2.967 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26472 | 26472 | USA | United States of America | City of Rochester Solar | USA0061804 | 1.8 | 43.1769 | -77.6785 | Solar | 2018.0 | AES Distributed Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.013 | 2.797 | 2.5380000000000003 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26685 | 26685 | USA | United States of America | CoreSite Real Estate 1656 McCarthy L.P. | USA0061475 | 5.0 | 37.4057 | -121.9162 | Oil | 2000.0 | CoreSite Real Estate 1656 McCarthy L.P. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.036 | 0.0 | 0.0 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26899 | 26899 | USA | United States of America | DG AMP Solar Piqua Staunton | USA0061805 | 1.8 | 40.1409 | -84.2315 | Solar | 2018.0 | DG AMP Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.491 | 2.831 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
26901 | 26901 | USA | United States of America | DG AMP Solar Versailles | USA0061437 | 1.8 | 40.2207 | -84.4978 | Solar | 2018.0 | DG AMP Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 2.607 | 2.739 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
27261 | 27261 | USA | United States of America | EHC West Hopkinton | USA0054384 | 1.0 | 43.1897 | -71.7483 | Hydro | 1985.0 | Green Mountain Power Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22547 | 2019 | 2.948 | 2.438 | 2.254 | 1.554 | 0.255 | 1.852 | 3.781 | U.S. Energy Information Administration | 2.84 | 3.3 | 3.65 | 2.89 | 2.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27452 | 27452 | USA | United States of America | Enfield Community Solar | USA0062029 | 1.8 | 42.4533 | -76.5948 | Solar | 2018.0 | Enfield Community Solar | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.352 | 2.325 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
27504 | 27504 | USA | United States of America | Estrella Mountain PV | USA0060230 | 1.8 | 33.4098 | -112.3403 | Solar | 2019.0 | Tesla Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 3.722 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
27904 | 27904 | USA | United States of America | GD West Greenwich Victory I LLC | USA0062568 | 1.8 | 41.6579 | -71.6875 | Solar | 2020.0 | GD West Greenwich Victory I LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
29821 | 29821 | USA | United States of America | M72 West Solar | USA0063660 | 1.8 | 44.7768 | -85.7014 | Solar | 2020.0 | Heritage Sustainable Energy. LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.053 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
29882 | 29882 | USA | United States of America | Macy's MD Joppa Solar Project | USA0062323 | 1.8 | 39.4475 | -76.3209 | Solar | 2016.0 | Northstar Macy's Maryland 2015 LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.704 | 2.9210000000000003 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
29890 | 29890 | USA | United States of America | Madison County | USA0061725 | 1.8 | 43.0283 | -75.701 | Solar | 2017.0 | AEP Onsite Partners | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.95 | 2.587 | 2.6710000000000003 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
30288 | 30288 | USA | United States of America | Minisink Solar 1 LLC | USA0062145 | 1.8 | 41.3212 | -74.5141 | Solar | 2018.0 | Minisink Solar 1 LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.102 | 3.103 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
31027 | 31027 | USA | United States of America | Orchard Hills Renewable Energy Station | USA0059792 | 16.2 | 42.1424 | -89.079 | Waste | 2016.0000000000005 | Hoosier Energy R E C Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 67245 | 2019 | 0.314 | 1.465 | 0.247 | 15.482 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
31486 | 31486 | USA | United States of America | Plainview Muncipal Power | USA0002297 | 5.0 | 42.35 | -97.7906 | Oil | 1971.98 | North Central Public Pwr Dist | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30276 | 2019 | 0.017 | 0.024 | 0.008 | 0.025 | 0.024 | 0.014 | 0.003 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32265 | 32265 | USA | United States of America | Salmon Diesel | USA0000817 | 5.0 | 45.1834 | -113.8853 | Oil | 1968.0 | Idaho Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 22765 | 2019 | 0.038 | 0.001 | 0.061 | 0.02 | 0.018 | 0.036 | 0.033 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32398 | 32398 | USA | United States of America | Schultz CSG | USA0062088 | 1.8 | 44.5576 | -93.376 | Solar | 2018.0 | DG Minnesota CSG LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.871 | 1.882 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
32896 | 32896 | USA | United States of America | St John | USA0001322 | 5.0 | 37.9953 | -98.7602 | Oil | 1981.82 | City of St. John - (KS) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33486 | 2019 | 0.03 | 0.029 | 0.002 | 0.008 | 0.004 | 0.006 | 0.02 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
33296 | 33296 | USA | United States of America | Temple Solar Arrays | USA0060848 | 2.2 | 40.4235 | -75.9252 | Solar | 2011.0 | UGI Energy Services LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 66412 | 2019 | 3.206 | 2.96 | 2.737 | 3.018 | U.S. Energy Information Administration | 3.25 | 3.29 | 3.42 | 3.1 | 2.93 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | ||||||
33849 | 33849 | USA | United States of America | Vitro Architectural Glass (PA) | USA0058051 | 5.0 | 40.1264 | -77.1644 | Oil | 1986.4 | Vitro Architectural Glass (PA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.05978 | 0.0637 | 0.05194 | 0.05684 | 0.049 | 0.05586 | 0.03724 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
34002 | 34002 | USA | United States of America | Washington Island | USA0004148 | 5.0 | 45.3709 | -86.9308 | Oil | 1985.84 | Washington Island El Coop Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36331 | 2019 | 0.049 | 0.045 | 0.03 | 0.125 | 0.014 | 0.235 | 0.027 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34191 | 34191 | USA | United States of America | Westminster | USA0062443 | 1.8 | 43.0864 | -72.4554 | Solar | 2017.0 | Spencer TGC Westminster LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.91 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
34195 | 34195 | USA | United States of America | Westmont 301 | USA0061593 | 1.8 | 33.763 | -118.2866 | Solar | 2017.0 | Westmont Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.109 | 3.152 | 3.106 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
34479 | 34479 | USA | United States of America | Xcel Adams 1 Community Solar Array | USA0060726 | 1.8 | 39.7655 | -104.5886 | Solar | 2017.0 | Clean Focus Renewables Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.241 | 3.604 | 3.467 | U.S. Energy Information Administration | 2.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-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");