global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
30 rows where estimated_generation_note_2013 = "HYDRO-V1", owner = "Tennessee Valley Authority" and year_of_capacity_data = 2019
This data as json, CSV (advanced)
Suggested facets: longitude, commissioning_year
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25099 | 25099 | 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 | 2019 | 551.17 | 415.735 | 310.461 | 177.87 | 310.805 | 457.704 | 493.037 | U.S. Energy Information Administration | 336.64 | 320.84 | 302.67 | 307.04 | 234.48 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25660 | 25660 | USA | United States of America | Blue Ridge | USA0000757 | 23.5 | 34.8839 | -84.2822 | Hydro | 1935.021276595745 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34333 | 2019 | 57.416 | 31.844 | 29.178 | 27.71 | 20.068 | 47.429 | 42.23 | U.S. Energy Information Administration | 67.88 | 67.88 | 62.82 | 68.07 | 58.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
25717 | 25717 | 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 | 2019 | 306.139 | 111.295 | 138.638 | 117.98 | 139.096 | 196.906 | 216.312 | U.S. Energy Information Administration | 382.27 | 388.39 | 318.47 | 390.53 | 328.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26361 | 26361 | 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 | 2019 | 44.909 | 24.839 | 27.77 | 27.983 | 17.415 | 36.086 | 30.591 | U.S. Energy Information Administration | 34.33 | 34.33 | 31.7 | 34.42 | 29.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26375 | 26375 | USA | United States of America | Cherokee Dam | USA0003397 | 135.0 | 36.1682 | -83.4977 | Hydro | 1947.4592592592592 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34337 | 2019 | 551.922 | 277.652 | 371.991 | 265.132 | 347.507 | 421.274 | 425.133 | U.S. Energy Information Administration | 488.67 | 431.97 | 423.61 | 438.71 | 366.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
26402 | 26402 | 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 | 2019 | 942.029 | 714.29 | 801.7810000000001 | 542.242 | 755.999 | 839.244 | 776.22 | U.S. Energy Information Administration | 662.93 | 684.93 | 632.69 | 708.02 | 603.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27169 | 27169 | USA | United States of America | Douglas Dam | USA0003400 | 150.8 | 35.9623 | -83.5393 | Hydro | 1947.9091511936333 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34341 | 2019 | 718.304 | 334.445 | 373.015 | 317.583 | 381.354 | 573.158 | 581.808 | U.S. Energy Information Administration | 540.84 | 495.3 | 470.68 | 554.95 | 414.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27718 | 27718 | USA | United States of America | Fontana Dam | USA0002779 | 254.7 | 35.4507 | -83.805 | Hydro | 1947.8621908127209 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34342 | 2019 | 1437.819 | 855.2090000000001 | 903.774 | 796.889 | 731.222 | 1150.561 | 1136.206 | U.S. Energy Information Administration | 867.19 | 782.34 | 692.1 | 781.11 | 646.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27763 | 27763 | 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 | 2019 | 936.256 | 727.282 | 810.553 | 595.934 | 733.407 | 913.24 | 932.129 | U.S. Energy Information Administration | 670.53 | 535.64 | 596.23 | 555.31 | 452.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
27767 | 27767 | 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 | 2019 | 176.487 | 89.72200000000001 | 118.375 | 90.514 | 107.901 | 145.155 | 157.595 | U.S. Energy Information Administration | 209.28 | 212.71 | 167.72 | 213.9 | 179.38 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28253 | 28253 | USA | United States of America | Great Falls (TN) | USA0003404 | 33.7 | 35.8067 | -85.6341 | Hydro | 1920.821958456973 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34348 | 2019 | 151.732 | 162.719 | 138.40800000000002 | 85.43900000000001 | 119.165 | 160.871 | 133.06300000000002 | U.S. Energy Information Administration | 108.92 | 89.77 | 91.12 | 99.65 | 81.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28347 | 28347 | 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 | 2019 | 839.939 | 713.367 | 740.864 | 506.256 | 724.522 | 733.655 | 667.523 | U.S. Energy Information Administration | 512.3 | 511.2 | 489.78 | 467.51 | 450.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
28654 | 28654 | 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 | 2019 | 430.987 | 250.96500000000003 | 307.722 | 244.627 | 180.166 | 351.812 | 342.21500000000003 | U.S. Energy Information Administration | 496.85 | 475.08 | 463.58 | 448.29 | 345.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
29273 | 29273 | USA | United States of America | Kentucky Dam | USA0001377 | 218.6 | 37.0131 | -88.2692 | Hydro | 1945.428179322964 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34351 | 2019 | 1429.073 | 1238.564 | 1265.179 | 924.369 | 1268.492 | 1098.259 | 923.969 | U.S. Energy Information Administration | 1192.56 | 903.76 | 1299.5 | 906.23 | 795.33 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30129 | 30129 | 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 | 2019 | 211.371 | 149.741 | 151.872 | 112.664 | 66.92 | 152.381 | 193.878 | U.S. Energy Information Administration | 316.21 | 263.59 | 246.59 | 338.41 | 220.58 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30719 | 30719 | 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 | 2019 | 731.657 | 570.889 | 617.046 | 430.032 | 609.172 | 570.936 | 584.994 | U.S. Energy Information Administration | 471.53 | 467.27 | 436.18 | 482.36 | 415.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30761 | 30761 | 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 | 2019 | 577.951 | 464.488 | 517.5070000000001 | 326.289 | 382.957 | 356.633 | 419.405 | U.S. Energy Information Administration | 458.87 | 415.32 | 468.18 | 424.47 | 349.59 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30848 | 30848 | 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 | 2019 | 52.273 | 27.442 | 32.874 | 32.493 | 16.092 | 40.579 | 48.504 | U.S. Energy Information Administration | 49.37 | 53.71 | 48.67 | 53.52 | 46.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30932 | 30932 | 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 | 2019 | 112.641 | 74.755 | 86.114 | 67.852 | 54.738 | 103.594 | 108.616 | U.S. Energy Information Administration | 79.38 | 66.99 | 74.3 | 59.98 | 63.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30933 | 30933 | 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 | 2019 | 100.255 | 42.283 | 101.575 | 77.686 | 55.519 | 57.245000000000005 | 122.402 | U.S. Energy Information Administration | 88.75 | 73.2 | 81.82 | 64.69 | 68.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
30934 | 30934 | 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 | 2019 | 201.531 | 152.648 | 176.642 | 120.05 | 118.583 | 193.684 | 148.02 | U.S. Energy Information Administration | 106.27 | 87.3 | 96.21 | 77.26 | 81.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31401 | 31401 | USA | United States of America | Pickwick Landing Dam | USA0003415 | 240.0 | 35.0683 | -88.2494 | Hydro | 1944.1666666666667 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34364 | 2019 | 1531.144 | 1221.813 | 1269.68 | 791.047 | 1293.27 | 1267.568 | 712.392 | U.S. Energy Information Administration | 1084.0 | 921.83 | 1045.79 | 933.55 | 835.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
31768 | 31768 | 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 | 2019 | -42.012 | -491.183 | -530.702 | -703.946 | -686.154 | -619.844 | -615.36 | U.S. Energy Information Administration | 6778.97 | 6953.73 | 6408.36 | 7154.26 | 6082.96 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
32773 | 32773 | 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 | 2019 | 201.438 | 115.255 | 143.775 | 108.628 | 86.015 | 1.246 | 156.507 | U.S. Energy Information Administration | 144.33 | 104.08 | 105.46 | 101.7 | 89.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
33400 | 33400 | 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 | 2019 | 58.001 | 37.506 | 61.717 | 63.307 | 36.382 | 68.369 | 74.758 | U.S. Energy Information Administration | 147.38 | 133.45 | 117.46 | 134.34 | 108.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34023 | 34023 | 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 | 2019 | 232.468 | 70.848 | 132.025 | 89.926 | 77.196 | 180.698 | 173.228 | U.S. Energy Information Administration | 193.08 | 173.61 | 170.55 | 190.32 | 163.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34055 | 34055 | USA | United States of America | Watts Bar Hydro | USA0003420 | 174.60000000000002 | 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 | 2019 | 1224.851 | 841.865 | 974.303 | 705.84 | 890.182 | 1085.928 | 1132.634 | U.S. Energy Information Administration | 756.65 | 686.65 | 727.5 | 649.23 | 655.99 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34239 | 34239 | 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 | 2019 | 1863.392 | 1247.298 | 1439.823 | 1014.935 | 1295.648 | 1623.825 | 1630.3 | U.S. Energy Information Administration | 1813.69 | 1366.64 | 1778.7 | 1489.41 | 1392.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34298 | 34298 | 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 | 2019 | 32.223 | 10.478 | 5.952 | 12.16 | 12.873 | 24.556 | 20.488 | U.S. Energy Information Administration | 39.02 | 35.11 | 36.72 | 38.2 | 34.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||
34350 | 34350 | USA | United States of America | Wilson Dam | USA0006440 | 666.6999999999999 | 34.7978 | -87.6254 | Hydro | 1942.667316634168 | Tennessee Valley Authority | U.S. Energy Information Administration | http://www.eia.gov/electricity/data/browser/ | U.S. Energy Information Administration | 34383 | 2019 | 3538.795 | 2448.335 | 2683.901 | 1809.161 | 2520.583 | 2923.233 | 3045.105 | U.S. Energy Information Administration | 2988.44 | 2250.71 | 2920.67 | 2453.3 | 2292.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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");