global-power-plants

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

37 rows where owner = "PacifiCorp" and primary_fuel = "Hydro"

View and edit SQL

Suggested facets: capacity_mw

primary_fuel

  • Hydro · 37

owner

  • PacifiCorp · 37

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
21247 USA United States of America Ashton USA0000825 6.7 44.0786 -111.4973 Hydro       1921.7761194029847 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29484 2017 34.536 32.826 29.969 28.779 36.863  
21489 USA United States of America Bend USA0006484 1.1 44.0623 -121.3133 Hydro       1916.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29487 2017 1.925 2.498 2.396 1.9580000000000002 2.295  
21553 USA United States of America Big Fork USA0006459 4.1 48.0592 -114.0708 Hydro       1924.5121951219517 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29486 2017 30.165 31.24 26.515 29.483 21.447  
22406 USA United States of America Clearwater 1 USA0003020 15.0 43.2512 -122.3379 Hydro       1953.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29491 2017 37.778 41.246 31.575 40.459 49.391999999999996  
22407 USA United States of America Clearwater 2 USA0003021 26.0 43.2669 -122.4098 Hydro       1953.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29491 2017 39.381 44.891999999999996 32.141999999999996 45.43899999999999 67.71900000000001  
22555 USA United States of America Copco 1 USA0000294 20.0 41.9789 -122.3353 Hydro       1918.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 67.577 65.39 60.538999999999994 80.964 107.722  
22556 USA United States of America Copco 2 USA0000295 27.0 41.9757 -122.3581 Hydro       1925.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 83.609 86.43900000000002 77.098 104.792 138.29  
22732 USA United States of America Cutler Hydro USA0003646 30.0 41.8347 -112.0521 Hydro       1927.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29499 2017 31.877 40.61 35.726 64.221 147.609  
23098 USA United States of America Eagle Point USA0003024 2.8 42.5146 -122.7571 Hydro       1957.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29502 2017 16.334 16.187 16.857 18.526 18.371  
23124 USA United States of America East Side USA0003025 3.2 42.2248 -121.7955 Hydro       1924.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29504 2017 0.0 0.0 0.002 0.0 0.0  
23379 USA United States of America Fall Creek USA0000296 2.1 41.9856 -122.3605 Hydro       1907.7619047619046 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29505 2017 9.863999999999999 7.396 9.699 10.146 7.872000000000001  
23441 USA United States of America Fish Creek USA0003026 11.0 43.2742 -122.449 Hydro       1952.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29506 2017 15.765999999999998 24.131999999999998 7.941 34.839 42.303999999999995  
23896 USA United States of America Grace USA0000827 33.0 42.5367 -111.794 Hydro       1923.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29508 2017 70.991 56.068999999999996 63.25100000000001 78.074 162.13299999999998  
23934 USA United States of America Granite USA0003651 2.0 40.6192 -111.7821 Hydro       1896.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29510 2017 5.671 6.05 5.516 6.218999999999999 7.476  
24623 USA United States of America Iron Gate USA0000297 18.0 41.933 -122.4368 Hydro       1962.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29516 2017 85.34899999999999 85.55 82.04299999999999 100.75200000000001 108.851  
24729 USA United States of America John C Boyle USA0003028 98.7 42.0936 -122.0703 Hydro       1958.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29513 2017 166.834 172.588 160.121 214.77599999999998 318.732  
25110 USA United States of America Last Chance USA0000987 1.7 42.6033 -111.7053 Hydro       1984.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29521 2017 3.2569999999999997 3.094 1.929 1.162 3.725  
25152 USA United States of America Lemolo 1 USA0003029 32.0 43.3558 -122.2494 Hydro       1955.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 123.88799999999999 140.861 123.55 134.067 174.923  
25153 USA United States of America Lemolo 2 USA0006421 38.5 43.2806 -122.4025 Hydro       1956.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 150.001 173.729 136.64 146.665 200.914  
25661 USA United States of America Merwin USA0003847 136.0 45.9567 -122.5544 Hydro       1946.5514705882354 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29525 2017 460.852 579.582 398.837 560.116 629.623  
26395 USA United States of America Olmstead USA0003655 10.3 40.3158 -111.6547 Hydro       1916.407766990291 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 69651 2017 8.225 7.064 6.4750000000000005 0.0 0.0  
26405 USA United States of America Oneida USA0000829 30.0 42.2678 -111.7485 Hydro       1917.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29529 2017 28.182 21.691 28.864 39.854 94.117  
26806 USA United States of America Pioneer USA0003656 5.0 41.2436 -111.9465 Hydro       1910.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29537 2017 7.718 9.008 9.846 11.369000000000002 27.134  
26984 USA United States of America Prospect 1 USA0003032 3.8 42.7307 -122.5151 Hydro       1912.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29536 2017 20.789 23.728 6.377999999999999 0.0 21.105999999999998  
26985 USA United States of America Prospect 2 USA0003033 32.0 42.7312 -122.514 Hydro       1928.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29532 2017 215.139 206.474 166.763 239.892 256.205  
26986 USA United States of America Prospect 3 USA0003034 7.2 42.7306 -122.4185 Hydro       1932.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29533 2017 33.745 35.937 27.781 32.997 40.779  
26987 USA United States of America Prospect 4 USA0003035 1.0 42.7331 -122.5151 Hydro       1944.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29535 2017 4.178 4.567 1.219 0.0 4.599  
27867 USA United States of America Slide Creek USA0003036 18.0 43.2939 -122.4728 Hydro       1951.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29540 2017 53.119 70.42 44.735 75.625 79.047  
27902 USA United States of America Soda USA0000831 14.5 42.6446 -111.6967 Hydro       1924.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29542 2017 15.674000000000001 14.51 14.474 17.769000000000005 33.872  
27904 USA United States of America Soda Springs USA0003037 11.0 43.3061 -122.5014 Hydro       1952.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29543 2017 45.782 54.071000000000005 34.278 61.093 60.373999999999995  
28142 USA United States of America Stairs USA0003659 1.0 40.6236 -111.7533 Hydro       1912.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29544 2017 3.909 4.648 3.897 4.5440000000000005 5.643  
28346 USA United States of America Swift 1 USA0003850 240.0 46.0608 -122.2017 Hydro       1959.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29547 2017 574.062 812.195 583.525 761.592 866.791  
28347 USA United States of America Swift 2 USA0006265 72.0 46.0594 -122.2594 Hydro       1959.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29545 2017           3289.9090168212842
28556 USA United States of America Toketee Falls USA0003040 42.6 43.2727 -122.4475 Hydro       1950.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29548 2017 195.898 226.36599999999999 183.99200000000002 232.82 255.226  
28990 USA United States of America Wallowa Falls USA0003041 1.1 45.2667 -117.2127 Hydro       1921.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29551 2017 5.34 2.354 3.49 4.34 4.6419999999999995  
29124 USA United States of America Weber USA0003661 3.8 41.1376 -111.8849 Hydro       1911.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29550 2017 8.908 5.031000000000001 9.926 13.610999999999999 0.0  
29484 USA United States of America Yale USA0003852 134.0 45.9628 -122.3355 Hydro       1953.0 PacifiCorp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29554 2017 506.285 671.693 482.06699999999995 645.247 726.025  

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