global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where estimated_generation_note_2017 = "CAPACITY-FACTOR-V1", geolocation_source = "U.S. Energy Information Administration", owner = "Tennessee Valley Authority" and primary_fuel = "Gas"
This data as json, CSV (advanced)
Suggested facets: other_fuel1, commissioning_year, generation_gwh_2016, generation_gwh_2017, generation_gwh_2018
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24934 | 24934 | USA | United States of America | Allen | USA0003393 | 1791.7000000000007 | 35.0741 | -90.1487 | Gas | Oil | 2001.8481888709032 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34370 | 2019 | 4293.542978 | 4204.161024 | 3132.3809730000003 | 3480.660013 | 3301.607003 | 3038.160998 | 5842.650000000001 | U.S. Energy Information Administration | 6318.42 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
25853 | 25853 | USA | United States of America | Brownsville Peaking Power | USA0055081 | 460.0 | 35.5438 | -89.198 | Gas | Oil | 1999.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 45236 | 2019 | 77.72200000000001 | 152.4 | 243.625 | 498.836 | 316.517 | 579.165 | 489.287 | U.S. Energy Information Administration | 1622.18 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
26087 | 26087 | USA | United States of America | Caledonia | USA0055197 | 801.0 | 33.6464 | -88.2717 | Gas | 2003.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 46063 | 2019 | 3277.217 | 2717.829 | 3413.509 | 4773.396 | 4340.826 | 4064.345 | 3958.083 | U.S. Energy Information Administration | 2824.72 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
26558 | 26558 | USA | United States of America | Colbert | USA0000047 | 476.0 | 34.7439 | -87.8486 | Gas | Oil | 1972.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34339 | 2019 | 3218.7699650000004 | 3594.7810310000004 | 2690.553993 | 0.0 | 0.0 | 0.0 | 1.67 | U.S. Energy Information Administration | 1678.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
28105 | 28105 | USA | United States of America | Gleason Generating Facility | USA0055251 | 567.8 | 36.2454 | -88.612 | Gas | Oil | 2000.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 49362 | 2019 | 3.23 | 3.515 | 40.082 | 468.396 | 297.373 | 547.375 | 461.137 | U.S. Energy Information Administration | 2002.34 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29112 | 29112 | USA | United States of America | John Sevier | USA0003405 | 996.9 | 36.3767 | -82.9639 | Gas | 2012.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34355 | 2019 | 2137.658016 | 3333.750997 | 4769.048 | 5429.704 | 5199.092000000001 | 4786.9490000000005 | 4954.09 | U.S. Energy Information Administration | 3515.56 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
29126 | 29126 | USA | United States of America | Johnsonville | USA0003406 | 1426.0 | 36.0278 | -87.9861 | Gas | Oil | 1980.9256661991585 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34353 | 2019 | 2122.0580120000004 | 2137.668028 | 2115.257009 | 1679.7329550000002 | 1365.8499930000005 | 0.0 | 140.219005 | U.S. Energy Information Administration | 5028.78 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29255 | 29255 | USA | United States of America | Kemper County | USA0007960 | 372.0 | 32.7976 | -88.606 | Gas | Oil | 2002.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 55618 | 2019 | 99.919 | 97.817 | 222.71899700000003 | 474.082002 | 0.0 | 0.0 | 244.737 | U.S. Energy Information Administration | 1311.85 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29444 | 29444 | USA | United States of America | Lagoon Creek | USA0007845 | 1625.2000000000005 | 35.6578 | -89.3964 | Gas | Oil | 2004.5591927147425 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 46819 | 2019 | 2479.502045 | 2396.239965 | 3648.055004 | 3906.402996 | 3422.485001 | 3624.058997 | 3574.039998 | U.S. Energy Information Administration | 5731.26 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
29898 | 29898 | USA | United States of America | Magnolia Power Plant | USA0055451 | 1003.5 | 34.835 | -89.2026 | Gas | 2003.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 4418.171 | 4079.143 | 4945.105 | 5731.838 | 5144.767 | 5554.67 | 3768.367 | U.S. Energy Information Administration | 3538.83 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
29998 | 29998 | USA | United States of America | Marshall Energy Facility | USA0055232 | 688.0 | 37.0286 | -88.3958 | Gas | Oil | 2002.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 74.99000000000001 | 66.61800000000001 | 66.73400000000001 | 201.851002 | 348.893002 | 321.338003 | 73.105 | U.S. Energy Information Administration | 2426.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||
31247 | 31247 | USA | United States of America | Paradise | USA0001378 | 2310.2 | 37.2608 | -86.9783 | Gas | Coal | 1993.599688338672 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34365 | 2019 | 11900.73309 | 13334.680439 | 12008.149056 | 0.0 | 6406.921023 | 9702.461978 | 9500.743009 | U.S. Energy Information Administration | 8146.91 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||
31684 | 31684 | USA | United States of America | Quantum Choctaw Power LLC | USA0055694 | 850.5 | 33.3792 | -89.2089 | Gas | 2006.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 225.929 | 837.5129999999999 | 2635.031 | 3477.951 | 3193.0420000000004 | 3116.556 | 3036.6580000000004 | U.S. Energy Information Administration | 2999.28 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||
33220 | 33220 | USA | United States of America | TVA Southaven Combined Cycle | USA0055269 | 903.9 | 34.9939 | -90.0378 | Gas | 2003.0 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 2019 | 2952.097 | 2197.86 | 3798.27 | 4909.8240000000005 | 3800.973 | 4013.086 | 3433.556 | U.S. Energy Information Administration | 3187.59 | 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");