global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where commissioning_year = "1970.0", estimated_generation_note_2016 = "NO-ESTIMATION" and primary_fuel = "Oil"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, estimated_generation_gwh_2017
owner 13
- Exelon Power 2
- Central Hudson Gas & Elec Corp 1
- City of McGregor- (IA) 1
- City of Spencer - (IA) 1
- City of Springfield - (IL) 1
- Consolidated Edison Co-NY Inc 1
- Constellation Power Source Gen 1
- DTE Electric Company 1
- FPL Energy Cape LLC 1
- Georgia Power Co 1
- NAES Corp 1
- NorthWestern Energy - (SD) 1
- Puget Sound Energy Inc 1
primary_fuel 1
- Oil · 14 ✖
country_long 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25740 | 25740 | USA | United States of America | Boulevard | USA0000732 | 15.6 | 32.0411 | -81.145 | Oil | Gas | 1970.0 | Georgia Power Co | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 32179 | 2019 | -0.091 | -0.0329999999999999 | 0.171 | 0.005 | -0.008 | 0.043 | -0.017 | U.S. Energy Information Administration | 9.14 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
26164 | 26164 | USA | United States of America | Cape Gas Turbine | USA0001484 | 35.0 | 43.6436 | -70.2544 | Oil | 1970.0 | FPL Energy Cape LLC | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15887 | 2019 | 0.436 | 1.841 | 2.218 | 0.649 | 1.282 | 0.744 | 1.456 | U.S. Energy Information Administration | 20.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26486 | 26486 | USA | United States of America | Clark (SD) | USA0003341 | 2.7 | 44.8765 | -97.7321 | Oil | 1970.0 | NorthWestern Energy - (SD) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 28424 | 2019 | -0.078 | -0.078 | -0.118 | -0.069 | -0.111 | -0.118 | -0.122 | U.S. Energy Information Administration | 1.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26837 | 26837 | USA | United States of America | Crystal Mountain | USA0003853 | 2.7 | 46.9535 | -121.4752 | Oil | 1970.0 | Puget Sound Energy Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 30959 | 2019 | 0.056 | 0.358 | 0.294 | 0.196 | 0.396 | 0.071 | 0.186 | U.S. Energy Information Administration | 1.58 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
27594 | 27594 | USA | United States of America | Falls | USA0003162 | 63.6 | 40.1765 | -74.79 | Oil | 1970.0 | Exelon Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29829 | 2019 | 0.182 | 1.163 | 1.184 | 0.6910000000000001 | 2.801 | 2.001 | 0.657 | U.S. Energy Information Administration | 37.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
28745 | 28745 | USA | United States of America | Hudson Avenue | USA0002496 | 32.6 | 40.7052 | -73.9807 | Oil | 1970.0 | Consolidated Edison Co-NY Inc | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17346 | 2019 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.648 | U.S. Energy Information Administration | 19.1 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30070 | 30070 | USA | United States of America | McGregor | USA0001163 | 1.5 | 43.0237 | -91.1749 | Oil | 1970.0 | City of McGregor- (IA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 25870 | 2019 | 0.013 | 0.007 | 0.009 | 0.01 | 0.013 | 0.008 | 0.009 | U.S. Energy Information Administration | 0.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30439 | 30439 | USA | United States of America | Moser Generating Station | USA0003163 | 63.6 | 40.2352 | -75.6193 | Oil | 1970.0 | Exelon Power | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 29832 | 2019 | 2.286 | 6.904 | 5.019 | 3.674 | 1.048 | 2.362 | 0.597 | U.S. Energy Information Administration | 37.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
30974 | 30974 | USA | United States of America | Oliver | USA0001735 | 13.5 | 43.8264 | -83.2383 | Oil | 1970.0 | DTE Electric Company | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 18396 | 2019 | -0.31 | -0.379 | -0.368 | -0.331 | -0.186 | -0.386 | -0.41 | U.S. Energy Information Administration | 7.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31386 | 31386 | USA | United States of America | Philadelphia | USA0001557 | 82.8 | 39.2986 | -76.5636 | Oil | 1970.0 | Constellation Power Source Gen | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 13951 | 2019 | 3.725 | 13.387 | 3.921 | 5.178 | 1.175 | 4.833 | 1.804 | U.S. Energy Information Administration | 48.52 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31894 | 31894 | USA | United States of America | Reynolds | USA0000965 | 17.5 | 39.8069 | -89.6417 | Oil | 1970.0 | City of Springfield - (IL) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33413 | 2019 | 0.102 | 0.078 | 0.098 | 0.042 | 0.284 | 0.121 | 0.039 | U.S. Energy Information Administration | 10.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32751 | 32751 | USA | United States of America | South Cairo | USA0002485 | 21.6 | 42.2913 | -73.9865 | Oil | 1970.0 | Central Hudson Gas & Elec Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 15852 | 2019 | 0.005 | 0.097 | 0.058 | 0.06 | 0.059 | 0.265 | 0.14 | U.S. Energy Information Administration | 12.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32777 | 32777 | USA | United States of America | South Meadow | USA0000563 | 167.2 | 41.7495 | -72.6524 | Oil | 1970.0 | NAES Corp | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 17284 | 2019 | 3.208 | 4.121 | 1.696 | 1.295 | 0.749 | 1.005 | 1.668 | U.S. Energy Information Administration | 97.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
32834 | 32834 | USA | United States of America | Spencer Gas Turbine | USA0001186 | 23.8 | 43.1446 | -95.1443 | Oil | 1970.0 | City of Spencer - (IA) | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 33356 | 2019 | 0.0 | 0.17 | 0.0 | 0.055 | 0.051 | 0.189 | 0.354 | U.S. Energy Information Administration | 13.94 | 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");