global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

55 rows where owner = "Tennessee Valley Authority"

View and edit SQL

Suggested facets: other_fuel1

primary_fuel

owner

  • Tennessee Valley Authority · 55

country_long

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 estimated_generation_gwh
21025 USA United States of America Allen USA0003393 1610.8000000000006 35.0741 -90.1487 Coal Oil Gas   1963.772783709956 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34370 2017 4293.542978 4204.161024 3132.3809730000007 3480.660013 3301.607003  
21168 USA United States of America Apalachia USA0003394 93.6 35.1677 -84.2956 Hydro       1943.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34329 2017 551.17 415.735 310.461 177.87 310.805  
21475 USA United States of America Bellefonte USA0006150 14.0 34.7092 -85.9278 Oil       1999.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.0         78.20117383730593
21654 USA United States of America Blue Ridge USA0000757 23.5 34.8839 -84.2822 Hydro       1935.0212765957447 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34333 2017 57.416 31.844 29.178 27.71 20.067999999999998  
21696 USA United States of America Boone Dam USA0003395 105.9 36.4403 -82.4381 Hydro       1953.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34334 2017 306.139 111.295 138.638 117.98 139.096  
21820 USA United States of America Browns Ferry USA0000046 3494.0 34.7042 -87.1189 Nuclear       1975.351459645106 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34332 2017 26718.113000000005 26738.300000000007 27669.694 26214.623000000003 27847.879  
21821 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  
21863 USA United States of America Buffalo Mountain USA0007927 1.7999999999999998 36.121 -84.3387 Wind       2000.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 46140 2017 0.0 0.0 0.0 0.0 0.0  
21873 USA United States of America Bull Run USA0003396 950.0 36.0211 -84.1567 Coal       1967.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34331 2017 924.890997 3201.812011 2487.210032 1967.008013 2911.0370359999997  
22027 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  
22276 USA United States of America Chatuge USA0002778 13.2 35.0191 -83.7914 Hydro       1955.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34335 2017 44.909 24.839 27.77 27.983 17.415  
22289 USA United States of America Cherokee Dam USA0003397 135.0 36.1682 -83.4977 Hydro       1947.4592592592594 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34337 2017 551.922 277.652 371.991 265.132 347.50699999999995  
22313 USA United States of America Chickamauga USA0003398 159.6 35.1018 -85.2295 Hydro       1943.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34336 2017 942.029 714.29 801.7810000000002 542.242 755.9989999999999  
22461 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  
22714 USA United States of America Cumberland (TN) USA0003399 2600.0 36.3903 -87.6539 Coal       1973.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34338 2017 13568.659236 14500.956235 14438.617474 12897.681053 8792.837979000002  
22997 USA United States of America Douglas Dam USA0003400 150.8 35.9623 -83.5393 Hydro       1947.909151193633 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34341 2017 718.304 334.445 373.015 317.58299999999997 381.35400000000004  
23493 USA United States of America Fontana Dam USA0002779 254.7 35.4507 -83.805 Hydro       1947.8621908127207 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34342 2017 1437.819 855.2090000000002 903.7739999999999 796.8889999999999 731.222  
23531 USA United States of America Fort Loudoun USA0003402 153.3 35.7917 -84.2431 Hydro       1946.2230919765168 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34345 2017 936.2560000000001 727.2819999999999 810.553 595.934 733.4069999999999  
23535 USA United States of America Fort Patrick Henry USA0003401 59.4 36.4982 -82.5086 Hydro       1954.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34346 2017 176.487 89.72200000000002 118.375 90.514 107.90100000000001  
23691 USA United States of America Gallatin (TN) USA0003403 1918.4 36.3156 -86.4006 Coal Oil Gas   1968.1540867389488 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34343 2017 6615.988011 5912.253015 3932.506015 5667.283975 5326.075044000001  
23828 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  
23968 USA United States of America Great Falls (TN) USA0003404 33.7 35.8067 -85.6341 Hydro       1920.8219584569729 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34348 2017 151.732 162.719 138.40800000000002 85.43900000000002 119.165  
24049 USA United States of America Guntersville USA0000048 115.2 34.4213 -86.3939 Hydro       1942.5 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34347 2017 839.939 713.367 740.8639999999999 506.256 724.5219999999999  
24325 USA United States of America Hiwassee Dam USA0002780 165.6 35.1509 -84.1775 Hydro       1949.178743961353 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34350 2017 430.98699999999997 250.96500000000003 307.722 244.627 180.166  
24739 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  
24751 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  
24853 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  
24871 USA United States of America Kentucky Dam USA0001377 218.6 37.0131 -88.2692 Hydro       1945.4281793229638 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34351 2017 1429.0729999999999 1238.5639999999999 1265.1789999999999 924.3689999999999 1268.492  
24930 USA United States of America Kingston USA0003407 1700.0 35.8992 -84.5194 Coal       1954.7058823529408 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34352 2017 3944.785953 5063.43296 3857.821002 5192.643937 4635.016982  
25021 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  
25427 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  
25518 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  
25639 USA United States of America Melton Hill USA0003408 72.0 35.8853 -84.3003 Hydro       1964.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34356 2017 211.37099999999998 149.741 151.872 112.664 66.92  
25653 USA United States of America Meridian USA0007719 9.0 32.5508 -88.6067 Oil       1998.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 41318 2017 0.096 0.07200000000000001 0.0 0.043 0.011000000000000001  
26175 USA United States of America Nickajack USA0003409 103.9 35.0017 -85.6218 Hydro       1968.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34359 2017 731.6569999999999 570.889 617.0459999999999 430.032 609.172  
26216 USA United States of America Norris Dam USA0003411 131.4 36.2242 -84.0914 Hydro       1936.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34362 2017 577.951 464.48800000000006 517.5070000000002 326.289 382.957  
26293 USA United States of America Nottely USA0000758 15.9 34.9592 -84.0876 Hydro       1958.0943396226412 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34361 2017 52.273 27.441999999999997 32.874 32.493 16.092  
26354 USA United States of America Ocoee 1 USA0003412 19.0 35.0947 -84.6478 Hydro       1912.6 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34357 2017 112.641 74.755 86.11399999999999 67.852 54.738  
26355 USA United States of America Ocoee 2 USA0003413 23.0 35.0823 -84.4912 Hydro       1913.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34358 2017 100.255 42.283 101.575 77.686 55.519  
26356 USA United States of America Ocoee 3 USA0003414 28.8 35.075 -84.4833 Hydro       1943.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34360 2017 201.53099999999998 152.648 176.642 120.05 118.583  
26623 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  
26757 USA United States of America Pickwick Landing Dam USA0003415 240.0 35.0683 -88.2494 Hydro       1944.166666666667 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34364 2017 1531.144 1221.813 1269.68 791.047 1293.27  
27018 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  
27090 USA United States of America Raccoon Mountain USA0006151 1713.6 35.0558 -85.3879 Hydro       1979.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34366 2017 -42.012 -491.18300000000005 -530.702 -703.946 -686.154  
27705 USA United States of America Sequoyah USA0006152 2441.0 35.2267 -85.0917 Nuclear       1981.5 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34367 2017 18526.011000000002 18892.391 16511.322 17242.608 18241.299  
27737 USA United States of America Shawnee USA0001379 1575.0 37.1517 -88.775 Coal       1954.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34368 2017 6966.080964000002 7030.667029000001 6141.8069909999995 0.0 6334.862022  
28000 USA United States of America South Holston USA0003416 38.5 36.5232 -82.0902 Hydro       1951.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34369 2017 201.438 115.255 143.775 108.62799999999999 86.015  
28386 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  
28543 USA United States of America Tims Ford USA0003417 45.7 35.1967 -86.2783 Hydro       1972.2297592997809 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34372 2017 58.001000000000005 37.506 61.717 63.306999999999995 36.382  
29069 USA United States of America Watauga USA0003418 57.6 36.3413 -82.1264 Hydro       1949.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34377 2017 232.468 70.848 132.025 89.926 77.196  
29098 USA United States of America Watts Bar Hydro USA0003420 174.60000000000005 35.6197 -84.7855 Hydro       1942.765177548682 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 40829 2017 1224.851 841.865 974.303 705.84 890.182  
29099 USA United States of America Watts Bar Nuclear Plant USA0007722 2539.8 35.6021 -84.7895 Nuclear       2006.0 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34375 2017 9967.803 8777.615 8449.15 12335.478000000001 13576.203000000001  
29272 USA United States of America Wheeler Dam USA0000049 404.00000000000006 34.8069 -87.3819 Hydro       1949.90198019802 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34376 2017 1863.392 1247.298 1439.8229999999999 1014.935 1295.648  
29324 USA United States of America Wilbur USA0003421 10.6 36.3417 -82.1264 Hydro       1938.9056603773588 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34384 2017 32.223 10.478 5.952000000000001 12.16 12.873  
29366 USA United States of America Wilson Dam USA0006440 666.6999999999998 34.7978 -87.6254 Hydro       1942.6673166341682 Tennessee Valley Authority U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34383 2017 3538.795 2448.335 2683.901 1809.161 2520.583  

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,
  "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");
Powered by Datasette · Query took 72.077ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute