global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
34 rows where capacity_mw = "3.4" and country_long = "United States of America"
This data as json, CSV (advanced)
Suggested facets: commissioning_year, generation_gwh_2017, estimated_generation_gwh_2017, estimated_generation_note_2014, estimated_generation_note_2015, estimated_generation_note_2016
owner >30
- AES Distributed Energy 1
- Ampersand Mount Ida Hydro LLC 1
- Brass Mill Center 1
- Briar-Hydro Associates 1
- California Dept. of Water Resources 1
- City of Curtis - (NE) 1
- Consolidated Edison Solutions Inc 1
- Cypress Creek Renewables 1
- Denver Airport Solar LLC 1
- Dept of Corrections NCCI Wind 1
- Eagle 2 US LLC 1
- GCL New Energy Inc. 1
- GR Catalyst One LLC 1
- Half Moon Ventures LLC 1
- Hampshire Paper Co Inc 1
- Harlan Municipal Utilities - (IA) 1
- Indiana Michigan Power Co 1
- KDC Solar CSCP LLC 1
- Merced Irrigation District 1
- Mt Wachusett Community College 1
- Pine Gate Renewables 1
- Saluda Solar II LLC 1
- SoCore Energy LLC 1
- Solar Star California XLII LLC 1
- Southern Minnesota Mun P Agny 1
- TX LFG Energy LP 1
- UIL Distributed Resources LLC 1
- US Air Force 1
- Upper Peninsula Power Company 1
- Valdosta City of 1
- …
country_long 1
- United States of America · 34 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25079 | 25079 | USA | United States of America | Anoka County MN CONX | USA0062061 | 3.4 | 45.2347 | -93.483 | Solar | 2018.0 | SoCore Energy LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 5.123 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
25779 | 25779 | USA | United States of America | Brass Mill Center | USA0063288 | 3.4 | 41.5489 | -73.0245 | Solar | 2018.0 | Brass Mill Center | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.146 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
26000 | 26000 | USA | United States of America | CF Novel Solar CSG Gardens Five LLC | USA0061543 | 3.4 | 44.0938 | -93.4017 | 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 | 3.631 | 5.38 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
26163 | 26163 | USA | United States of America | Cape Cod Air Force Station - 6 SWS | USA0058661 | 3.4 | 41.7525 | -70.5389 | Wind | 2014.0 | US Air Force | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.834 | 8.322000000000001 | 8.99 | 9.235 | 7.996 | 6.315 | U.S. Energy Information Administration | 11.28 | 11.65 | 11.1 | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | WIND-V1 | WIND-V1 | |||||||
26459 | 26459 | USA | United States of America | City & County of Denver at Denver Int'l | USA0057645 | 3.4 | 39.9041 | -104.6542 | Solar | 2011.0 | Denver Airport Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 5.853 | 6.732 | 6.5280000000000005 | 7.039000000000001 | 6.92 | 7.034 | 6.74 | U.S. Energy Information Administration | 6.1 | 6.06 | 6.25 | 5.63 | 5.88 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | SOLAR-V1 | ||||
26854 | 26854 | USA | United States of America | Curtis | USA0002232 | 3.4 | 40.6315 | -100.5152 | Gas | Oil | 1967.764705882353 | City of Curtis - (NE) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0139999999999999 | 0.006 | 0.022 | 0.018 | 0.002 | 0.047 | 0.038 | U.S. Energy Information Administration | 11.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27061 | 27061 | USA | United States of America | Dept of Corrections NCCI Wind | USA0058992 | 3.4 | 42.5722 | -71.9447 | Wind | 2013.0 | Dept of Corrections NCCI Wind | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.688 | 6.58 | 7.26 | 2.208 | 2.927 | 7.377 | 7.252 | U.S. Energy Information Administration | 11.05 | 11.02 | 7.99 | 8.52 | NO-ESTIMATION | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||||
27212 | 27212 | USA | United States of America | Duke Building 129 | USA0059434 | 3.4 | 39.9108 | -86.2453 | Solar | 2015.0 | Half Moon Ventures LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.071 | 4.091 | 3.241 | 2.81 | 3.968 | 4.588 | U.S. Energy Information Administration | 4.74 | 5.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | SOLAR-V1 | ||||||||
27402 | 27402 | USA | United States of America | Elkhart | USA0000986 | 3.4 | 41.6928 | -85.965 | Hydro | 1917.7058823529408 | Indiana Michigan Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 23017 | 2019 | 16.038 | 15.704 | 11.303 | 14.737 | 17.008 | 17.857 | 17.757 | U.S. Energy Information Administration | 11.66 | 12.39 | 11.5 | 13.0 | 11.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27742 | 27742 | USA | United States of America | Forestport | USA0050768 | 3.4 | 43.4425 | -75.2159 | Hydro | 1988.0 | Ampersand Mount Ida Hydro LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34826 | 2019 | 8.466 | 8.05 | 9.237 | 9.494 | 12.435 | 7.231 | 5.0 | U.S. Energy Information Administration | 11.48 | 11.47 | 11.01 | 11.5 | 9.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28417 | 28417 | USA | United States of America | Hampshire Paper | USA0010116 | 3.4 | 44.2965 | -75.3665 | Hydro | 1987.0 | Hampshire Paper Co Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 20.992 | 18.774 | 15.872 | 16.867 | 19.976 | 14.869 | 17.678 | U.S. Energy Information Administration | 12.02 | 13.65 | 11.65 | 12.21 | 12.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
28458 | 28458 | USA | United States of America | Harlan | USA0001146 | 3.4 | 41.6445 | -95.3153 | Oil | 2001.0 | Harlan Municipal Utilities - (IA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21775 | 2019 | 0.009 | 0.004 | 0.004 | 0.004 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 1.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
28665 | 28665 | USA | United States of America | Hoist | USA0007115 | 3.4 | 46.5628 | -87.5686 | Hydro | 1988.0 | Upper Peninsula Power Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35499 | 2019 | 13.076 | 12.585 | 12.378 | 12.881 | 17.612000000000002 | 14.645 | 16.499 | U.S. Energy Information Administration | 11.41 | 11.43 | 10.81 | 11.84 | 11.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29121 | 29121 | USA | United States of America | Johnson Falls | USA0004067 | 3.4 | 45.2875 | -88.1603 | Hydro | 1923.0 | Wisconsin Public Service Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 37252 | 2019 | 9.567 | 12.186 | 12.742 | 12.664 | 15.883 | 11.171 | 11.966 | U.S. Energy Information Administration | 8.89 | 10.79 | 12.42 | 13.87 | 11.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29162 | 29162 | USA | United States of America | KDC Solar CSCP LLC | USA0062746 | 3.4 | 40.2378 | -74.3144 | Solar | 2019.0 | KDC Solar CSCP LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.03 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
30136 | 30136 | USA | United States of America | Merced Falls | USA0000258 | 3.4 | 37.523 | -120.3299 | Hydro | 1930.0 | Merced Irrigation District | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29403 | 2019 | 7.141 | 4.3340000000000005 | -0.078 | 7.997 | 13.181 | 9.677 | 12.524 | U.S. Energy Information Administration | 11.8 | 9.97 | 9.51 | 11.93 | 11.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30347 | 30347 | USA | United States of America | Monroe County Sites A & B | USA0061509 | 3.4 | 43.1741 | -77.3922 | 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.002 | 4.513 | 4.779 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
30486 | 30486 | USA | United States of America | Mt Wachusett Community College | USA0058025 | 3.4 | 42.5886 | -71.9842 | Wind | 2011.0 | Mt Wachusett Community College | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 60619 | 2019 | 5.466 | 5.359 | 5.471 | 5.033 | 5.61385 | 4.58865 | 5.29749 | U.S. Energy Information Administration | 10.7 | 7.48 | 11.94 | 8.64 | 8.3 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
31152 | 31152 | USA | United States of America | PPG Plant C Caustic | USA0050490 | 3.4 | 30.2264 | -93.2938 | Gas | 1986.0 | Eagle 2 US LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 7.908 | 11.97 | 8.965 | 12.498 | 14.322 | 14.046 | 12.894 | U.S. Energy Information Administration | 11.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
31338 | 31338 | USA | United States of America | Penacook Upper Falls Hydro | USA0050414 | 3.4 | 43.2832 | -71.6008 | Hydro | 1987.0 | Briar-Hydro Associates | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 19763 | 2019 | 15.51 | 17.721 | 11.735 | 10.42 | 15.758 | 18.346 | 13.014 | U.S. Energy Information Administration | 9.78 | 10.41 | 9.63 | 9.83 | 10.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31761 | 31761 | USA | United States of America | RP Wind | USA0058630 | 3.4 | 40.4494 | -83.8933 | Wind | 2014.0 | Consolidated Edison Solutions Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.028 | 8.790000000000001 | 9.192 | 8.523 | 7.219 | 7.422000000000001 | 8.724 | U.S. Energy Information Administration | 9.27 | 8.97 | 7.56 | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | WIND-V1 | WIND-V1 | ||||||
31869 | 31869 | USA | United States of America | Redwood Falls Wind | USA0056414 | 3.4 | 44.5028 | -95.175 | Wind | 2005.0 | Southern Minnesota Mun P Agny | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 54490 | 2019 | 1.0791 | 10.26 | 10.234 | 8.893 | 9.016 | 8.395 | U.S. Energy Information Administration | 9.61 | 10.2 | 10.12 | 9.88 | 9.89 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||
32281 | 32281 | USA | United States of America | Saluda Solar II | USA0061323 | 3.4 | 34.011 | -81.739 | Solar | 2017.0 | Saluda Solar II LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.625 | 6.6850000000000005 | 6.462 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
32426 | 32426 | USA | United States of America | Security | USA0055556 | 3.4 | 30.3225 | -95.2681 | Waste | 2003.5 | TX LFG Energy LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 50584 | 2019 | 22.91 | 24.98 | 25.233 | 24.072 | 23.097 | 20.399 | 15.33 | U.S. Energy Information Administration | 0.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32726 | 32726 | USA | United States of America | Soluga Farms IV | USA0059934 | 3.4 | 35.2187 | -78.6695 | Solar | 2018.0 | Pine Gate Renewables | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 1.792 | 6.039 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
32940 | 32940 | USA | United States of America | Stanford Campus Solar | USA0062020 | 3.4 | 37.4343 | -122.1608 | Solar | 2017.0 | Solar Star California XLII LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 6.799 | 6.344 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
33008 | 33008 | USA | United States of America | Stillwater Hydro Electric Project | USA0054395 | 3.4 | 42.9375 | -73.6544 | Hydro | 1993.0 | GR Catalyst One LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 15.6 | 14.372 | 11.447 | 13.255 | 15.287 | 13.931 | 13.926 | U.S. Energy Information Administration | 13.94 | 15.03 | 11.03 | 13.94 | 11.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
33347 | 33347 | USA | United States of America | Thermalito Diverson Dam | USA0007129 | 3.4 | 39.5287 | -121.5464 | Hydro | 1987.0 | California Dept. of Water Resources | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15336 | 2019 | 16.184 | 19.459 | 19.947 | 20.321 | 12.982 | 20.461 | 16.179000000000002 | U.S. Energy Information Administration | 13.05 | 13.14 | 12.37 | 15.6 | 13.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33578 | 33578 | USA | United States of America | UDR Glastonbury Fuel Cell | USA0060109 | 3.4 | 41.717 | -72.5361 | Gas | 2016.0 | UIL Distributed Resources LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 20.073 | 23.255 | 22.3 | 19.474 | U.S. Energy Information Administration | 11.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
33728 | 33728 | USA | United States of America | Valdosta Water Treatment Plant | USA0054839 | 3.4 | 30.9136 | -83.2529 | Oil | 2000.5 | Valdosta City of | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 1.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
34251 | 34251 | USA | United States of America | Whitakers Farm (Fisher Rd) | USA0060438 | 3.4 | 36.1155 | -77.7251 | Solar | 2016.0 | Whitakers Farm LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2.85 | 6.481 | 6.003 | 6.0760000000000005 | U.S. Energy Information Administration | 5.85 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
34355 | 34355 | USA | United States of America | Wilson Solar Farm 1 | USA0061274 | 3.4 | 35.7 | -77.9 | Solar | 2017.0 | GCL New Energy Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4.8020000000000005 | 5.966 | 5.9510000000000005 | U.S. Energy Information Administration | 5.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
34507 | 34507 | USA | United States of America | Yellowhammer Gas Plant | USA0054730 | 3.4 | 30.4035 | -88.1283 | Gas | 1992.0 | W&T Offshore Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 15.691 | 14.838 | 14.341 | 17.476 | 16.473 | 17.911 | 16.795 | U.S. Energy Information Administration | 11.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
34541 | 34541 | USA | United States of America | Zotos International WPGF | USA0057648 | 3.4 | 42.8869 | -76.9683 | Wind | 2012.0 | Zotos International | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 3.671 | 2.46015 | 2.489 | 1.67 | 1.23349 | 2.63 | 1.211 | U.S. Energy Information Administration | 8.31 | 8.46 | 6.57 | 6.52 | 6.81 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-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");