global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where capacity_mw = "80.0" and country_long = "United States of America"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_gwh_2015, estimated_generation_note_2013, estimated_generation_note_2014, estimated_generation_note_2016, estimated_generation_note_2017
owner 28
- Dominion Renewable Energy 7
- Leeward Asset Management LLC 3
- Air Liquide America Corp 1
- Aulander Holloman Solar LLC 1
- Avangrid Renewables LLC 1
- Black Hills Electric Generation LLC 1
- City of Grand Haven - (MI) 1
- City of St George 1
- Conetoe II Solar LLC 1
- DeWind Co. 1
- Gauley River Power Partners LP 1
- Grand View PV Solar Two LLC 1
- Llano Estacado Wind Ranch 1
- Lorenzo Wind LLC 1
- MidAmerican Energy Co 1
- NRG Energy Gas & Wind Holdings Inc 1
- NorthWestern Energy - (SD) 1
- ORCAL Geothermal Inc 1
- Ormat Nevada Inc 1
- Siemens Gamesa Renewable Energy Inc. 1
- Signal Hill Generating LLC 1
- Southern Power Co 1
- Sustainable Power Group LLC 1
- Three Peaks Power LLC 1
- USACE Northwestern Division 1
- Utah Red Hills Renewable Energy Park LLC 1
- Verso Paper Androscoggin LLC 1
- Walton Bainbridge LLC 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24933 | 24933 | USA | United States of America | Allegheny Ridge Wind Farm | USA0056451 | 80.0 | 40.3839 | -78.5794 | Wind | 2007.0 | Leeward Asset Management LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55121 | 2019 | 162.302 | 202.479 | 188.143 | 202.849 | 212.986 | 215.962 | 194.116 | U.S. Energy Information Administration | 251.27 | 244.52 | 228.95 | 252.58 | 234.47 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
25061 | 25061 | USA | United States of America | Androscoggin Mill | USA0054085 | 80.0 | 44.5063 | -70.2395 | Biomass | Waste | Oil | 1968.375 | Verso Paper Androscoggin LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 41512 | 2019 | 466.41800200000006 | 437.745994 | 408.181001 | 337.77100500000006 | 213.600997 | 308.862996 | 387.25299999999993 | U.S. Energy Information Administration | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||
25228 | 25228 | USA | United States of America | Aulander Holloman Solar LLC | USA0062340 | 80.0 | 36.2912 | -77.0666 | Solar | 2019.0 | Aulander Holloman Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.03861 | 84.78 | U.S. Energy Information Administration | 130.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
25451 | 25451 | USA | United States of America | Beethoven Wind | USA0059187 | 80.0 | 43.16 | -98.08 | Wind | 2015.0 | NorthWestern Energy - (SD) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68526 | 2019 | 177.114 | 327.112 | 313.372 | 290.80400000000003 | 283.63800000000003 | U.S. Energy Information Administration | 344.05 | 306.86 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | WIND-V1 | ||||||||
26171 | 26171 | USA | United States of America | Caprock Wind Farm | USA0056293 | 80.0 | 34.9806 | -103.3539 | Wind | 2005.0 | Leeward Asset Management LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49783 | 2019 | 320.829 | 316.68 | 296.624 | 324.918 | 317.735 | 330.326 | 320.798 | U.S. Energy Information Administration | 237.5 | 260.31 | 231.45 | 251.44 | 237.59 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
26344 | 26344 | USA | United States of America | Charles City Wind Farm | USA0056677 | 80.0 | 43.0003 | -92.62 | Wind | 2008.0 | MidAmerican Energy Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 58380 | 2019 | 233.922 | 240.82 | 230.23187 | 211.333 | 216.311 | 206.113 | 236.902 | U.S. Energy Information Administration | 257.51 | 250.85 | 219.76 | 234.53 | 222.28 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
26640 | 26640 | USA | United States of America | Conetoe II Solar LLC | USA0059944 | 80.0 | 35.822 | -77.481 | Solar | 2016.0 | Conetoe II Solar LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 69903 | 2019 | 1.126 | 166.259 | 170.872 | 156.127 | 156.601 | U.S. Energy Information Administration | 141.83 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||
26997 | 26997 | USA | United States of America | Decatur Parkway Solar Project LLC | USA0059450 | 80.0 | 30.9919 | -84.6339 | Solar | 2016.0 | Southern Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 68807 | 2019 | 0.176 | 198.822 | 185.46 | 175.16 | 184.912 | U.S. Energy Information Administration | 181.9 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||
27319 | 27319 | USA | United States of America | Eastern Shore Solar LLC | USA0060127 | 80.0 | 37.9439 | -75.5696 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 15.912 | 157.538 | 153.665 | 165.334 | U.S. Energy Information Administration | 178.49 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
27463 | 27463 | USA | United States of America | Enterprise Solar LLC | USA0059386 | 80.0 | 37.6411 | -113.6125 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 140.267 | 224.267 | 225.336 | 220.046 | U.S. Energy Information Administration | 200.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
27487 | 27487 | USA | United States of America | Escalante Solar I LLC | USA0059387 | 80.0 | 38.5242 | -113.0339 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 85.34 | 206.822 | 204.549 | 205.146 | U.S. Energy Information Administration | 199.7 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
27488 | 27488 | USA | United States of America | Escalante Solar II LLC | USA0059388 | 80.0 | 38.5008 | -113.03 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 94.435 | 209.256 | 208.002 | 203.681 | U.S. Energy Information Administration | 199.7 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
27489 | 27489 | USA | United States of America | Escalante Solar III LLC | USA0059389 | 80.0 | 38.4978 | -112.9869 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 97.501 | 207.945 | 206.537 | 204.442 | U.S. Energy Information Administration | 184.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
27932 | 27932 | USA | United States of America | GSG LLC | USA0056450 | 80.0 | 41.6436 | -89.1731 | Wind | 2007.0 | Leeward Asset Management LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 153.373 | 146.651 | 183.624 | 198.797 | 220.858 | 195.181 | 202.278 | U.S. Energy Information Administration | 230.19 | 220.42 | 218.36 | 222.51 | 217.57 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||
28006 | 28006 | USA | United States of America | Gauley River Power Partners | USA0056333 | 80.0 | 38.2192 | -80.8906 | Hydro | 2001.0 | Gauley River Power Partners LP | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 227.808 | 145.356 | 204.711 | 201.67 | 165.946 | 290.062 | 174.844 | U.S. Energy Information Administration | 258.0 | 284.06 | 233.95 | 288.3 | 227.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||
28208 | 28208 | USA | United States of America | Grand View Solar Two | USA0060068 | 80.0 | 42.9896 | -116.0934 | Solar | 2017.0 | Grand View PV Solar Two LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 61930 | 2019 | 3.5820000000000003 | 163.316 | 182.356 | 180.168 | U.S. Energy Information Administration | 130.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
28219 | 28219 | USA | United States of America | Granite Mountain Solar East LLC | USA0059946 | 80.0 | 37.7751 | -113.2264 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 55.797 | 208.687 | 208.091 | 204.075 | U.S. Energy Information Administration | 197.5 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
28284 | 28284 | USA | United States of America | Green Peter | USA0003080 | 80.0 | 44.4494 | -122.5494 | Hydro | 1967.0 | USACE Northwestern Division | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35563 | 2019 | 235.619 | 299.515 | 150.826 | 215.9 | 276.245 | 250.419 | 158.218 | U.S. Energy Information Administration | 212.9 | 287.04 | 213.59 | 271.04 | 244.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28990 | 28990 | USA | United States of America | Iron Springs Solar LLC | USA0059941 | 80.0 | 37.7212 | -113.1516 | Solar | 2016.0 | Dominion Renewable Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 114.476 | 212.005 | 211.796 | 208.224 | U.S. Energy Information Administration | 202.3 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||||
29003 | 29003 | USA | United States of America | J B Sims | USA0001825 | 80.0 | 43.0706 | -86.235 | Coal | 1983.0 | City of Grand Haven - (MI) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21256 | 2019 | 123.691002 | 174.46200299999998 | 205.406996 | 285.80500200000006 | 274.707997 | 171.38100200000002 | 167.248998 | U.S. Energy Information Administration | 369.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29165 | 29165 | USA | United States of America | KODE Novus I | USA0057516 | 80.0 | 36.5439 | -101.3936 | Wind | 2012.0 | DeWind Co. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 63398 | 2019 | 176.472 | 242.593 | 214.63 | 147.30145000000002 | 0.919 | 8.605 | 45.697 | U.S. Energy Information Administration | 339.59 | 341.42 | 283.14 | 269.26 | 286.5 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
29695 | 29695 | USA | United States of America | Llano Estacado Wind Ranch | USA0055579 | 80.0 | 35.4677 | -101.2533 | Wind | 2002.0 | Llano Estacado Wind Ranch | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 264.529 | 259.869 | 209.123 | 198.781 | 121.412 | 113.65 | 118.242 | U.S. Energy Information Administration | 262.87 | 239.07 | 221.83 | 228.37 | 238.63 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||
29749 | 29749 | USA | United States of America | Lorenzo Wind | USA0059244 | 80.0 | 33.6992 | -101.5247 | Wind | 2019.0 | Lorenzo Wind LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 79.714 | 360.411 | U.S. Energy Information Administration | 234.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
30258 | 30258 | USA | United States of America | Millcreek Power Generation | USA0056253 | 80.0 | 37.1121 | -113.5166 | Gas | 2008.0 | City of St George | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 57666 | 2019 | 88.068 | 77.404 | 78.233 | 131.617 | 96.796 | 111.468 | 78.406 | U.S. Energy Information Administration | 282.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30472 | 30472 | USA | United States of America | Mountain Wind Power II LLC | USA0056753 | 80.0 | 41.2639 | -110.5444 | Wind | 2008.0 | NRG Energy Gas & Wind Holdings Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 56126 | 2019 | 227.852 | 255.792 | 183.055 | 211.254 | 216.909 | 5.674 | 198.886 | U.S. Energy Information Administration | 226.38 | 225.29 | 197.79 | 216.43 | 226.07 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
30771 | 30771 | USA | United States of America | North Brawley Geothermal Plant | USA0056832 | 80.0 | 33.0139 | -115.5439 | Geothermal | 2009.0 | Ormat Nevada Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 56704 | 2019 | 183.896 | 138.508 | 102.677 | 70.885 | 54.116 | 55.668 | 55.693 | U.S. Energy Information Administration | 432.42 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30823 | 30823 | USA | United States of America | Northern Iowa Windfarm | USA0055804 | 80.0 | 43.3833 | -93.4167 | Wind | 2001.0 | Black Hills Electric Generation LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 48025 | 2019 | 169.776 | 170.217 | 172.515 | 178.852 | 149.32500000000002 | 116.85 | 124.079 | U.S. Energy Information Administration | 220.38 | 231.12 | 213.99 | 198.62 | 191.4 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
30824 | 30824 | USA | United States of America | Northern Iowa Windpower II | USA0056383 | 80.0 | 43.3608 | -93.2978 | Wind | 2008.0 | Avangrid Renewables LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 201.466 | 217.718 | 209.253 | 204.649 | 194.481 | 174.3 | 158.114 | U.S. Energy Information Administration | 267.46 | 276.37 | 263.0 | 227.74 | 240.83 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | ||||
31461 | 31461 | USA | United States of America | Pioneer Wind Park LLC | USA0060259 | 80.0 | 42.7282 | -105.8668 | Wind | 2016.0 | Sustainable Power Group LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 69542 | 2019 | 74.999 | 269.177 | 252.682 | 282.137 | U.S. Energy Information Administration | 346.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | ||||||||||
31516 | 31516 | USA | United States of America | Pocahontas Prairie Wind Farm | USA0057976 | 80.0 | 42.5681 | -94.6581 | Wind | 2012.0 | Siemens Gamesa Renewable Energy Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 64673 | 2019 | 219.522 | 248.206 | 264.801 | 271.002 | 257.148 | 225.362 | 234.072 | U.S. Energy Information Administration | 322.15 | 325.84 | 283.14 | 273.0 | 257.01 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | WIND-V1 | |||
32424 | 32424 | USA | United States of America | Second Imperial Geothermal | USA0054111 | 80.0 | 32.7144 | -115.5356 | Geothermal | 1998.6 | ORCAL Geothermal Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 222.882 | 226.191 | 204.689 | 165.507 | 144.302 | 226.7 | 216.998 | U.S. Energy Information Administration | 432.42 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
32512 | 32512 | USA | United States of America | Shell Chemical | USA0056248 | 80.0 | 30.1875 | -90.984 | Gas | 2002.0 | Air Liquide America Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 603.321 | 557.243 | 579.246 | 574.969 | 576.287 | 559.232 | 587.644 | U.S. Energy Information Administration | 282.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
32577 | 32577 | USA | United States of America | Signal Hill Generating LLC | USA0050127 | 80.0 | 33.8625 | -98.5894 | Gas | 1987.0 | Signal Hill Generating LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 19.724 | 3.687 | 5.303 | 4.122 | 0.0 | 18.556 | 14.676 | U.S. Energy Information Administration | 282.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
33372 | 33372 | USA | United States of America | Three Peaks Power | USA0060432 | 80.0 | 37.8271 | -113.1371 | Solar | 2017.0 | Three Peaks Power LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 8.739 | 220.677 | 225.931 | 216.718 | U.S. Energy Information Administration | 130.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||
33708 | 33708 | USA | United States of America | Utah Red Hills Renewable Energy Park | USA0058660 | 80.0 | 37.8828 | -112.9042 | Solar | 2016.0 | Utah Red Hills Renewable Energy Park LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 63058 | 2019 | 12.281 | 208.071 | 209.574 | 209.479 | 198.228 | U.S. Energy Information Administration | 197.5 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | SOLAR-V1 | |||||||||
33958 | 33958 | USA | United States of America | Walton Bainbridge Power Facility | USA0056015 | 80.0 | 30.911 | -84.5473 | Oil | 2000.0 | Walton Bainbridge LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 0.233 | 0.316 | 0.281 | 0.737 | 0.065 | 1.036 | 0.0 | U.S. Energy Information Administration | 46.88 | 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");