global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
38 rows where estimated_generation_gwh_2017 = "3.87"
This data as json, CSV (advanced)
Suggested facets: source, estimated_generation_gwh_2013, estimated_generation_note_2015, estimated_generation_note_2017
owner 17
- Bloom Energy 19
- 2016 ESA Project Company LLC 2
- Sustainable Power Group LLC 2
- Bloom Energy 2009 PPA 1
- Bos Dairy LLC 1
- Catawba Solar LLC 1
- City of Martinsville - (VA) 1
- Fort Smith City of 1
- Jefferson Torresdale Hospital 1
- Mount Joy Wire Corp 1
- Natural Power / SITA UK 1
- Prairies Edge Dairy Farms LLC 1
- Shanks Avondale 1
- South Wales Power Ltd 1
- Thames Waste Management Ltd 1
- Thames Water Utilities 1
- Waste Recycling Group 1
country_long 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
18956 | 18956 | PRT | Portugal | Roxo | WRI1022785 | 1.7 | 37.9303 | -8.0812 | Hydro | 2010.0 | Energias Endogenas de Portugal | http://e2p.inegi.up.pt/index.asp | Energias Endogenas de Portugal | 1088851 | 4.58 | 4.6 | 3.9 | 5.41 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
22069 | 22069 | GBR | United Kingdom | Avondale | GBR0000639 | 4.0 | 55.905 | -3.945 | Waste | Shanks Avondale | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23343 | 23343 | GBR | United Kingdom | Lamby Way Landfill Site | GBR0000606 | 4.0 | 51.4983 | -3.1222 | Waste | South Wales Power Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1046570 | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23791 | 23791 | GBR | United Kingdom | Norlands Lane Landfill Site (Extension) | GBR0000790 | 4.0 | 51.4115 | -0.5139 | Waste | Thames Waste Management Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1044643 | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24059 | 24059 | GBR | United Kingdom | Riverside Sewage Treatment Works Digestion Plant | GBR2001028 | 4.0 | 51.5164 | 0.1855 | Waste | Thames Water Utilities | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24124 | 24124 | GBR | United Kingdom | Salt Ayre | GBR0000748 | 4.0 | 54.0556 | -2.834 | Waste | Natural Power / SITA UK | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24558 | 24558 | GBR | United Kingdom | Weldon Phase 1 and 2 | GBR0000538 | 4.0 | 52.4866 | -0.6422 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24998 | 24998 | USA | United States of America | Amazon San Bernardino | USA0059800 | 1.1 | 34.0884 | -117.2458 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 57248 | 2019 | 0.801 | 8.699 | 7.923 | 7.715 | 7.166 | 6.823 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
25725 | 25725 | USA | United States of America | Bos Dairy LLC | USA0057625 | 1.1 | 41.1153 | -87.2328 | Gas | 2011.3636363636365 | Bos Dairy LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 54149 | 2019 | 7.034 | 7.497 | 7.86 | 7.804 | 7.56 | 4.7940000000000005 | 6.60618 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26251 | 26251 | USA | United States of America | Catawba Solar LLC | USA0060800 | 2.0 | 35.61 | -80.53 | Solar | 2016.0 | Catawba Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.082 | 2.688 | 3.093 | 3.414 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
26543 | 26543 | USA | United States of America | Coca Cola American Canyon | USA0057807 | 1.1 | 38.1907 | -122.2751 | Gas | Biomass | 2011.0 | Bloom Energy 2009 PPA | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68302 | 2019 | 6.13107 | 6.557 | 5.296 | 0.003 | 3.256 | 1.566 | 0.397 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
27474 | 27474 | USA | United States of America | Equinix San Jose | USA0060223 | 1.1 | 37.2417 | -121.7814 | Gas | 2015.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68297 | 2019 | 1.18404 | 8.755 | 8.357 | 7.872 | 7.358 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
27833 | 27833 | USA | United States of America | Franklin Templeton San Mateo | USA0057809 | 1.1 | 37.5425 | -122.2928 | Gas | 2011.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68292 | 2019 | 6.16572 | 7.141 | 7.1240000000000006 | 7.144 | 7.553 | 7.098 | 0.635 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
28697 | 28697 | USA | United States of America | Honda Torrance | USA0058300 | 1.1 | 33.8381 | -118.315 | Gas | 2013.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55352 | 2019 | 7.485390000000001 | 5.197 | 6.539 | 6.958 | 7.329 | 6.954 | 5.8340000000000005 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
28795 | 28795 | USA | United States of America | IBM Southbury | USA0059801 | 1.1 | 41.4725 | -73.207 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.94 | 8.477 | 7.736 | 7.363 | 6.978 | 6.412 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
28916 | 28916 | USA | United States of America | Innovative Solar 14 LLC | USA0059553 | 2.0 | 35.3689 | -82.3575 | Solar | 2014.0 | Sustainable Power Group LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.964 | 3.009 | 4.013 | 3.607 | 3.479 | 3.514 | U.S. Energy Information Administration | 3.49 | 3.74 | 3.87 | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | |||||||
28917 | 28917 | USA | United States of America | Innovative Solar 15 LLC | USA0059554 | 2.0 | 35.3194 | -81.7642 | Solar | 2014.0 | Sustainable Power Group LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.186 | 3.21 | 3.917 | 3.39 | 3.306 | 3.346 | U.S. Energy Information Administration | 3.52 | 3.74 | 3.87 | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | |||||||
28946 | 28946 | USA | United States of America | Intel Santa Clara | USA0060224 | 1.1 | 37.3847 | -121.9638 | Gas | 2015.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 8.4249 | 7.853 | 7.529 | 7.413 | 7.458 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
29027 | 29027 | USA | United States of America | JSR000 N Mathilda Fuel Cell | USA0063711 | 1.1 | 37.4124 | -122.024 | Gas | 2019.0 | 2016 ESA Project Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.904 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
29076 | 29076 | USA | United States of America | Jefferson Torresdale Hospital | USA0063023 | 1.1 | 40.0711 | -74.9831 | Gas | 2016.0 | Jefferson Torresdale Hospital | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 8.55246 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
29154 | 29154 | USA | United States of America | Juniper Networks Sunnyvale | USA0058301 | 1.1 | 37.4069 | -122.0269 | Gas | 2013.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68299 | 2019 | 2.83239 | 5.2170000000000005 | 6.1370000000000005 | 6.751 | 7.777 | 7.364 | 6.97 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29251 | 29251 | USA | United States of America | Kellogg's - San Jose | USA0059280 | 1.1 | 37.3564 | -121.8719 | Gas | 2013.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.858 | 6.555 | 7.256 | 7.642 | 6.390000000000001 | 6.594 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
29585 | 29585 | USA | United States of America | Lee Creek Water Treatment Facility | USA0054283 | 1.3 | 35.4845 | -94.3929 | Hydro | 1992.0 | Fort Smith City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20443 | 2019 | -4.307 | 0.003 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 4.54 | 4.6 | 4.83 | 5.09 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29628 | 29628 | USA | United States of America | Life Technologies - Pleasanton | USA0059279 | 1.1 | 37.6439 | -121.8842 | Gas | 2013.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.14394 | 7.768 | 7.333 | 7.545 | 7.807 | 7.543 | 7.224 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
29629 | 29629 | USA | United States of America | Life Technologies Carlsbad | USA0058302 | 1.1 | 33.1372 | -117.2869 | Gas | 2012.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68300 | 2019 | 8.02692 | 7.18 | 3.934 | 7.328 | 7.890000000000001 | 7.045 | 6.977 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29703 | 29703 | USA | United States of America | Lockheed Martin Sunnyvale | USA0057808 | 1.1 | 37.4131 | -122.0281 | Gas | 2012.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68291 | 2019 | 6.19542 | 5.407 | 6.836 | 7.301 | 7.862 | 6.847 | 5.929 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30025 | 30025 | USA | United States of America | Martinsville | USA0003826 | 1.3 | 36.6641 | -79.8836 | Hydro | 1932.0 | City of Martinsville - (VA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25698 | 2019 | 2.308 | 2.004 | 2.491 | 3.217 | 1.294 | 0.647 | 0.31 | U.S. Energy Information Administration | 4.54 | 4.28 | 4.19 | 4.33 | 3.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30041 | 30041 | USA | United States of America | Maxim | USA0059802 | 1.1 | 37.4057 | -121.9494 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.854 | 9.368 | 8.128 | 7.948 | 7.215 | 7.172 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
30450 | 30450 | USA | United States of America | Mount Joy Wire | USA0062741 | 1.1 | 40.1085 | -76.4767 | Gas | 2012.0 | Mount Joy Wire Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.6499200000000003 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
30548 | 30548 | USA | United States of America | NHH003 Clarkson Fuel Cell | USA0063648 | 1.1 | 40.6565 | -73.9428 | Gas | 2018.0 | 2016 ESA Project Company LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 9.364 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
31477 | 31477 | USA | United States of America | Pixar - Emeryville | USA0059803 | 1.1 | 37.8329 | -122.284 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.447 | 7.418 | 7.758 | 7.969 | 7.604 | 7.267 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
31613 | 31613 | USA | United States of America | Prairies Edge Generating Facility | USA0058129 | 1.1 | 41.0606 | -87.3071 | Gas | 2012.0 | Prairies Edge Dairy Farms LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.564 | 7.0520000000000005 | 7.09 | 7.5 | 8.2 | 5.5 | 6.075 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
32060 | 32060 | USA | United States of America | Roll Delano | USA0058297 | 1.1 | 35.7342 | -119.2367 | Gas | 2012.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68295 | 2019 | 5.64795 | 6.474 | 4.923 | 6.409 | 2.242 | 8.434000000000001 | 3.851 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32062 | 32062 | USA | United States of America | Roll Lost Hills | USA0058298 | 1.1 | 35.6531 | -119.8897 | Gas | 2013.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68296 | 2019 | 6.4350000000000005 | 2.957 | 1.732 | 7.462 | 6.902 | 6.4990000000000006 | 4.961 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32947 | 32947 | USA | United States of America | Starbucks - Evolution Fresh | USA0059804 | 1.1 | 34.0937 | -117.551 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.527 | 7.555 | 7.018 | 7.498 | 7.167 | 6.640000000000001 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
33276 | 33276 | USA | United States of America | Taylor Farms Salinas | USA0058303 | 1.1 | 36.6575 | -121.6233 | Gas | 2012.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68288 | 2019 | 6.83793 | 6.697 | 6.048 | 6.91 | 7.640000000000001 | 5.838 | 4.196 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34482 | 34482 | USA | United States of America | Xilinx San Jose | USA0058299 | 1.1 | 37.2528 | -121.9342 | Gas | 2012.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68297 | 2019 | 7.816050000000001 | 6.307 | 6.365 | 5.548 | 7.689 | 7.704 | 8.327 | U.S. Energy Information Administration | 3.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
34488 | 34488 | USA | United States of America | Yahoo! - HQ | USA0059805 | 1.1 | 37.4154 | -122.0257 | Gas | 2014.0 | Bloom Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.304 | 8.700000000000001 | 7.498 | 7.844 | 7.471 | 6.452 | U.S. Energy Information Administration | 3.87 | 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");