global-power-plants

Table actions

13 rows where owner = "Tennessee Valley Authority", primary_fuel = "Gas" and source = "U.S. Energy Information Administration"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, commissioning_year, generation_gwh_2016

primary_fuel 1

  • Gas · 13 ✖

owner 1

  • Tennessee Valley Authority · 13 ✖

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_data_source estimated_generation_gwh
25534 25534 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 2017 77.72200000000002 152.4 243.625 498.836 316.517 U.S. Energy Information Administration  
25740 25740 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 2017 3277.217 2717.829 3413.509 4773.396 4340.826 U.S. Energy Information Administration  
26175 26175 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 2017 3218.7699650000004 3594.7810310000004 2690.553993 0.0 13.968 U.S. Energy Information Administration  
27542 27542 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 2017 3.23 3.515 40.082 468.39599999999996 297.373 U.S. Energy Information Administration  
28454 28454 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 2017 2137.658016 3333.750997 4769.048 5429.704000000001 5199.0920000000015 U.S. Energy Information Administration  
28466 28466 USA United States of America Johnsonville USA0003406 1426.0 36.0278 -87.9861 Gas Oil     1980.9256661991587 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34353 2017 2122.0580120000004 2137.668028 2115.257009 1679.7329550000004 1365.8499930000005 U.S. Energy Information Administration  
28568 28568 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 2017 99.919 97.817 222.71899700000003 474.08200199999993 226.745 U.S. Energy Information Administration  
28736 28736 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 2017 2479.5020449999997 2396.2399649999998 3648.055004 3906.4029960000003 3422.485001 U.S. Energy Information Administration  
29142 29142 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   2017 4418.170999999999 4079.143 4945.105 5731.838000000001 5144.767 U.S. Energy Information Administration  
29233 29233 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   2017 74.99000000000002 66.61800000000001 66.73400000000001 201.851002 348.893002 U.S. Energy Information Administration  
30338 30338 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 2017 11900.73309 13334.680439 12008.149056 0.0 6406.921023 U.S. Energy Information Administration  
30733 30733 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   2017 225.929 837.5129999999998 2635.031 3477.9509999999996 3193.042000000001 U.S. Energy Information Administration  
32101 32101 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   2017 2952.097 2197.86 3798.27 4909.824000000001 3800.973 U.S. Energy Information Administration  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");