global-power-plants

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

57 rows where owner = "U S Bureau of Reclamation" and primary_fuel = "Hydro"

View and edit SQL

primary_fuel

  • Hydro · 57

owner

  • U S Bureau of Reclamation · 57

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
21002 USA United States of America Alcova USA0006409 41.4 42.5484 -106.7175 Hydro       1955.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35616 2017 91.92200000000001 73.132 78.306 108.678 133.364  
21132 USA United States of America Anderson Ranch USA0006395 40.0 43.3571 -115.4515 Hydro       1951.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35617 2017 112.885 86.29899999999999 122.346 145.394 162.52100000000004  
21567 USA United States of America Big Thompson USA0000515 4.5 40.421 -105.2238 Hydro       1959.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35618 2017 7.223 2.006 4.123 5.722 7.627000000000001  
21604 USA United States of America Black Canyon USA0006396 10.2 43.9305 -116.4372 Hydro       1926.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35619 2017 55.598 63.647 61.394 62.55900000000001 65.214  
21652 USA United States of America Blue Mesa USA0000512 86.4 38.4532 -107.3375 Hydro       1967.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35620 2017 134.60399999999998 221.259 258.762 252.915 311.473  
21683 USA United States of America Boise R Diversion USA0006397 3.3000000000000003 43.5377 -116.0938 Hydro       2004.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 7.997999999999999 7.037999999999999 8.252 8.849 11.825  
21735 USA United States of America Boysen USA0000505 15.0 43.4179 -108.1775 Hydro       1952.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35623 2017 30.586 69.50399999999999 65.509 67.47399999999999 88.947  
21857 USA United States of America Buffalo Bill USA0007317 18.0 44.5082 -109.1707 Hydro       1992.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35622 2017 58.247 97.067 58.193999999999996 53.641000000000005 119.56  
22092 USA United States of America Canyon Ferry USA0006400 49.8 46.649 -111.7279 Hydro       1954.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35625 2017 264.915 363.024 303.399 310.096 347.272  
22250 USA United States of America Chandler USA0006406 12.0 46.2668 -119.5898 Hydro       1956.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35624 2017 41.2 44.288999999999994 29.108 53.86 55.456  
22706 USA United States of America Crystal USA0006159 28.0 38.5106 -107.6253 Hydro       1978.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35626 2017 105.40700000000001 139.47 133.844 175.78 155.734  
22812 USA United States of America Davis Dam USA0000152 254.8 35.197 -114.5707 Hydro       1951.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35627 2017 1124.512 1162.92 1139.658 1118.857 1071.015  
22844 USA United States of America Deer Creek (UT) USA0006404 4.8 40.4044 -111.5284 Hydro       1958.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35628 2017 20.401 18.559 21.205 20.055999999999997 26.046  
23192 USA United States of America Elephant Butte USA0006402 27.9 33.1534 -107.192 Hydro       1940.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35633 2017 9.308 12.799000000000001 37.645 43.49100000000001 44.865  
23294 USA United States of America Estes USA0000513 45.0 40.3768 -105.5097 Hydro       1950.666666666667 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35632 2017 84.165 95.294 57.328 114.737 100.277  
23459 USA United States of America Flaming Gorge USA0006405 151.8 40.9146 -109.4217 Hydro       1963.666666666667 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35631 2017 303.057 416.74300000000005 548.65 495.226 838.404  
23467 USA United States of America Flatiron USA0000518 94.5 40.365 -105.236 Hydro       1954.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35634 2017 179.93099999999998 222.61599999999999 143.563 208.112 156.385  
23490 USA United States of America Folsom USA0000441 198.6 38.7067 -121.1584 Hydro       1955.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35629 2017 341.902 185.14700000000002 203.50099999999998 593.96 861.6160000000001  
23495 USA United States of America Fontenelle USA0004185 10.0 42.027 -110.064 Hydro       1968.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35630 2017 37.453 68.718 67.928 44.169 48.358  
23614 USA United States of America Fremont Canyon USA0004176 66.8 42.4766 -106.7959 Hydro       1961.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35639 2017 147.69 133.507 189.039 229.509 289.3280000000001  
23830 USA United States of America Glen Canyon Dam USA0000153 1312.0 36.9366 -111.4839 Hydro       1964.9939024390244 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35638 2017 3332.256 3344.619 3839.205 4016.225 3949.678  
23839 USA United States of America Glendo USA0004177 38.0 42.4673 -104.9555 Hydro       1959.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35637 2017 53.979 80.112 69.95 99.274 107.756  
23910 USA United States of America Grand Coulee USA0006163 6809.0 47.9575 -118.9773 Hydro       1967.470333382288 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35636 2017 21073.181 20261.569 18878.623 19011.492 20983.99  
23992 USA United States of America Green Mountain USA0000516 26.0 39.8788 -106.3327 Hydro       1943.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35643 2017 33.149 93.802 76.642 59.568000000000005 56.94  
23999 USA United States of America Green Springs USA0006403 17.2 42.1212 -122.5479 Hydro       1960.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35641 2017 56.96 64.423 54.481 52.255 43.685  
24041 USA United States of America Guernsey USA0004178 6.4 42.2899 -104.7606 Hydro       1927.5 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35640 2017 8.711 15.838 18.089000000000002 17.942 12.004000000000001  
24217 USA United States of America Heart Mountain USA0006408 5.0 44.5138 -109.1296 Hydro       1949.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35642 2017 17.292 18.14 17.239 17.72 23.241999999999997  
24372 USA United States of America Hoover Dam (AZ) USA0008902 1039.4 36.0155 -114.738 Hydro       1944.097460073119 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35645 2017 1245.441 1436.779 1401.8470000000002 1818.612 1653.271  
24373 USA United States of America Hoover Dam (NV) USA0000154 1039.4 36.0155 -114.738 Hydro       1940.9797960361745 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35644 2017 2624.6330000000007 2352.308 2248.649 1748.122 1738.8829999999998  
24412 USA United States of America Hungry Horse USA0002203 428.0 48.3415 -114.0144 Hydro       1952.75 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35647 2017 1023.385 1004.8710000000001 1000.298 835.1619999999999 1034.475  
24769 USA United States of America Judge F Carr USA0000442 154.4 40.6469 -122.627 Hydro       1963.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35648 2017 423.712 338.338 248.667 133.554 359.6860000000001  
24885 USA United States of America Keswick USA0000443 117.0 40.6119 -122.4464 Hydro       1949.666666666667 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35650 2017 383.661 284.27299999999997 277.776 333.401 437.401  
24966 USA United States of America Kortes USA0004180 36.0 42.1743 -106.8805 Hydro       1950.333333333333 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35649 2017 113.335 130.209 115.25200000000001 135.22899999999998 111.056  
25330 USA United States of America Lower Molina USA0000520 5.6 39.1937 -108.0441 Hydro       1963.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35651 2017 6.596 15.693 14.062999999999999 15.148 12.732  
25548 USA United States of America Marys Lake USA0000517 8.1 40.3441 -105.5343 Hydro       1951.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35653 2017 27.759 35.205 18.996 36.793 31.145  
25606 USA United States of America McPhee USA0007372 1.2 37.5752 -108.574 Hydro       1993.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35654 2017 0.35000000000000003 3.56 4.855 5.055 5.47  
25777 USA United States of America Minidoka USA0006398 27.7 42.6699 -113.4832 Hydro       1980.2490974729244 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35655 2017 85.25200000000001 96.317 110.976 75.153 50.897  
25908 USA United States of America Morrow Point USA0000514 173.2 38.4518 -107.5393 Hydro       1971.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35657 2017 183.43099999999998 295.791 341.545 326.7750000000001 338.514  
25925 USA United States of America Mount Elbert USA0006208 200.0 39.0942 -106.3523 Hydro       1982.5 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35656 2017 -134.35 -52.967 -101.211 -80.734 -87.77799999999999  
26133 USA United States of America New Melones USA0006158 300.0 37.9469 -120.5282 Hydro       1979.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35658 2017 410.549 275.57 130.222 212.09400000000002 713.048  
26182 USA United States of America Nimbus USA0000444 13.4 38.6373 -121.2202 Hydro       1955.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35659 2017 45.661 26.149 27.656999999999996 53.958999999999996 64.65  
26318 USA United States of America ONeill USA0000446 25.2 37.0987 -121.0477 Hydro       1967.6666666666665 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35661 2017 -29.413 -5.735 -12.192 -50.858999999999995 -105.76799999999999  
26595 USA United States of America Palisades Dam USA0000850 176.4 43.3348 -111.2058 Hydro       1957.25 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35660 2017 356.031 513.643 626.3480000000001 581.315 688.052  
26638 USA United States of America Parker Dam USA0000447 120.0 34.2953 -114.1402 Hydro       1943.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35662 2017 433.745 448.589 439.9 440.87199999999996 435.51599999999996  
26772 USA United States of America Pilot Butte USA0000674 1.6 43.219 -108.7877 Hydro       1927.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35664 2017           73.1090892626952
26869 USA United States of America Pole Hill USA0000519 38.2 40.3651 -105.3251 Hydro       1954.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35663 2017 150.626 191.968 120.246 190.64700000000002 146.464  
27400 USA United States of America Roza USA0006407 12.9 46.6184 -120.4778 Hydro       1958.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35665 2017 70.205 67.48100000000001 62.193000000000005 67.63 63.24800000000001  
27689 USA United States of America Seminoe USA0004182 51.6 42.1561 -106.9085 Hydro       1939.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35666 2017 90.352 119.627 125.244 138.3 128.499  
27731 USA United States of America Shasta USA0000445 714.0 40.7175 -122.4223 Hydro       1946.5854341736692 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35670 2017 1794.5539999999999 1012.933 1096.894 1748.0410000000002 2908.434  
27787 USA United States of America Shoshone (WY) USA0004183 3.0 44.5029 -109.1812 Hydro       1922.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35667 2017 19.133 19.748 18.051 17.579 19.202  
28072 USA United States of America Spirit Mountain USA0007541 4.5 44.5127 -109.1299 Hydro       1994.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35668 2017 16.92 16.315 18.386 16.839000000000002 15.017999999999999  
28079 USA United States of America Spring Creek USA0000450 180.0 40.6281 -122.4675 Hydro       1964.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35669 2017 352.401 283.44599999999997 200.467 193.724 417.597  
28143 USA United States of America Stampede USA0007066 3.6 39.4704 -120.1046 Hydro       1988.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35671 2017 13.2 9.542 3.4960000000000004 4.982 13.538  
28577 USA United States of America Towaoc USA0007373 11.4 37.4295 -108.5749 Hydro       1993.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35673 2017 8.786 18.008 17.45 17.862000000000005 17.877  
28621 USA United States of America Trinity USA0000451 140.0 40.7973 -122.7626 Hydro       1964.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35672 2017 449.91 279.059 195.16099999999997 277.80400000000003 411.16900000000004  
28780 USA United States of America Upper Molina USA0000521 9.9 39.1438 -108.0048 Hydro       1963.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35674 2017 17.221 24.43 25.206 25.913 22.859  
29502 USA United States of America Yellowtail USA0002204 259.4 45.3074 -107.9575 Hydro       1966.0 U S Bureau of Reclamation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35676 2017 471.034 1095.85 744.118 690.297 1124.349  

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 52.37ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute