global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where country_long = "United States of America", generation_gwh_2015 = "0.0", other_fuel1 = "Oil" and primary_fuel = "Coal"
This data as json, CSV (advanced)
Suggested facets: generation_gwh_2014, generation_gwh_2016, generation_gwh_2019
owner 17
- ALLETE Inc. 2
- Arizona Public Service Co 1
- City Utilities of Springfield - (MO) 1
- City of Fremont - (NE) 1
- Crawfordsville Energy LLC 1
- Dairyland Power Coop 1
- Golden Valley Elec Assn Inc 1
- Great River Energy 1
- Illinois Power Generating Co 1
- Illinois Power Resources Generating LLC 1
- RED-Rochester LLC 1
- Seward Generating LLC 1
- Southern Illinois University Carbondale 1
- Union Electric Co - (MO) 1
- University of Alaska 1
- University of North Carolina 1
- Virginia Electric & Power Co 1
primary_fuel 1
- Coal · 18 ✖
country_long 1
- United States of America · 18 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
26392 | 26392 | USA | United States of America | Chesterfield | USA0003797 | 1499.5000000000002 | 37.3822 | -77.3833 | Coal | Oil | Gas | 1974.823207735912 | Virginia Electric & Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 36094 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3614.833011 | U.S. Energy Information Administration | 6926.45 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
26429 | 26429 | USA | United States of America | Cholla | USA0000113 | 839.9 | 34.9394 | -110.3033 | Coal | Oil | Gas | 1978.0583402786049 | Arizona Public Service Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13489 | 2019 | 6606.593978 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 2782.781025 | U.S. Energy Information Administration | 3879.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
26493 | 26493 | USA | United States of America | Clay Boswell | USA0001893 | 923.3 | 47.2611 | -93.6528 | Coal | Oil | Gas | 1977.2365428354813 | ALLETE Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 26506 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 4810.980033 | U.S. Energy Information Administration | 4264.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
26535 | 26535 | USA | United States of America | Coal Creek | USA0006030 | 1215.6 | 47.3777 | -101.1571 | Coal | Oil | 1979.6801579466933 | Great River Energy | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17629 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 8192.593007 | U.S. Energy Information Administration | 5615.06 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
26795 | 26795 | USA | United States of America | Crawfordsville Power Plant | USA0001024 | 24.9 | 40.0489 | -86.8992 | Coal | Oil | 1961.313253012048 | Crawfordsville Energy LLC | 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 | 115.01 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27243 | 27243 | USA | United States of America | E D Edwards | USA0000856 | 644.3 | 40.5958 | -89.6631 | Coal | Oil | 1970.2585751978893 | Illinois Power Resources Generating LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15857 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3212.49996 | U.S. Energy Information Administration | 2976.13 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
28036 | 28036 | USA | United States of America | Genoa | USA0004143 | 345.6 | 43.5589 | -91.2325 | Coal | Oil | 1969.0 | Dairyland Power Coop | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18015 | 2019 | 0.0 | 1605.45602 | 0.0 | 0.0 | 0.0 | 0.0 | 1188.925048 | U.S. Energy Information Administration | 1596.38 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
28538 | 28538 | USA | United States of America | Healy | USA0006288 | 92.8 | 63.8542 | -148.95 | Coal | Oil | 1987.711206896552 | Golden Valley Elec Assn Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 21140 | 2019 | 191.318003 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 344.55999799999995 | U.S. Energy Information Administration | 428.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29113 | 29113 | USA | United States of America | John Twitty Energy Center | USA0006195 | 603.0 | 37.1517 | -93.388 | Coal | Oil | Gas | 1994.678275290216 | City Utilities of Springfield - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33404 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1785.013002 | U.S. Energy Information Administration | 2785.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
29722 | 29722 | USA | United States of America | Lon Wright | USA0002240 | 213.2 | 41.4281 | -96.4623 | Coal | Oil | Gas | Wind | 1986.5722326454036 | City of Fremont - (NE) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 20590 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 649.105003 | U.S. Energy Information Administration | 984.8 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||
30134 | 30134 | USA | United States of America | Meramec | USA0002104 | 1041.0 | 38.4017 | -90.3358 | Coal | Oil | Gas | 1961.335734870317 | Union Electric Co - (MO) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35259 | 2019 | 2480.9279730000003 | 0.0 | 0.0 | 1663.303969 | 0.0 | 0.0 | 496.946004 | U.S. Energy Information Administration | 4808.56 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
30707 | 30707 | USA | United States of America | Newton | USA0006017 | 617.4 | 38.9361 | -88.2781 | Coal | Oil | 1977.0 | Illinois Power Generating Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15798 | 2019 | 6918.123021 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3201.17399 | U.S. Energy Information Administration | 2851.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
31756 | 31756 | USA | United States of America | RED-Rochester LLC | USA0010025 | 133.3 | 43.1989 | -77.6319 | Coal | Oil | Gas | Hydro | 1970.7051762940732 | RED-Rochester LLC | 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 | 316.292001 | U.S. Energy Information Administration | 615.73 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
32189 | 32189 | USA | United States of America | SIUC | USA0057928 | 5.1 | 37.7119 | -89.215 | Coal | Oil | 1998.0 | Southern Illinois University Carbondale | 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 | 8.126 | U.S. Energy Information Administration | 23.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32465 | 32465 | USA | United States of America | Seward (PA) | USA0003130 | 585.0 | 40.4062 | -79.0337 | Coal | Oil | 2004.0 | Seward Generating LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29929 | 2019 | 1802.583015 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 1866.63301 | U.S. Energy Information Administration | 2702.21 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
33227 | 33227 | USA | United States of America | Taconite Harbor Energy Center | USA0010075 | 168.0 | 47.5314 | -90.9114 | Coal | Oil | 1957.0 | ALLETE Inc. | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25205 | 2019 | 1064.433986 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | U.S. Energy Information Administration | 776.02 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
33656 | 33656 | USA | United States of America | Univ of NC Chapel Hill Cogen Facility | USA0054276 | 32.0 | 35.9069 | -79.0617 | Coal | Oil | Gas | 1993.0 | University of North Carolina | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 35420 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 51.408 | U.S. Energy Information Administration | 147.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||
33663 | 33663 | USA | United States of America | University of Alaska Fairbanks | USA0050711 | 22.6 | 64.8542 | -147.8221 | Coal | Oil | Gas | 1986.8141592920356 | University of Alaska | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 47.55246 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 28.328 | U.S. Energy Information Administration | 104.39 | 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");