global-power-plants

Table actions

17 rows where owner = "Puget Sound Energy Inc"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, commissioning_year

primary_fuel 5

owner 1

  • Puget Sound Energy Inc · 17 ✖

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
26423 26423 USA United States of America Crystal Mountain USA0003853 2.7 46.9535 -121.4752 Oil       1970.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30959 2017 0.055999999999999994 0.358 0.294 0.196 0.396 U.S. Energy Information Administration  
26963 26963 USA United States of America Encogen USA0007870 176.39999999999995 48.746 -122.486 Gas Oil     1993.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 24990 2017 283.5200040000001 219.64300099999997 300.298002 212.71700299999998 202.464001 U.S. Energy Information Administration  
27132 27132 USA United States of America Ferndale Generating Station USA0054537 285.5 48.829 -122.6851 Gas Oil     1994.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 28043 2017 869.388005 723.051996 868.8479949999999 742.347002 741.3570000000002 U.S. Energy Information Administration  
27312 27312 USA United States of America Frederickson USA0000099 177.8 47.0797 -122.365 Gas Oil     1981.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30961 2017 30.694000000000006 14.22 39.935 19.474 25.535999999999998 U.S. Energy Information Administration  
27315 27315 USA United States of America Fredonia USA0000607 376.0 48.4558 -122.4358 Gas Oil     1989.3260638297877 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30962 2017 102.053003 67.54599999999999 161.449001 245.80400099999997 120.50299999999999 U.S. Energy Information Administration  
27537 27537 USA United States of America Glacier Battery Storage USA0060444 2.0 48.888 -121.9462 Storage       2016.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       0.257 0.746 U.S. Energy Information Administration  
27578 27578 USA United States of America Goldendale Generating Station USA0055482 284.3 45.8114 -120.833 Gas       2004.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 47176 2017 1434.154 1005.123 1466.052 1004.047 1076.003 U.S. Energy Information Administration  
28094 28094 USA United States of America Hopkins Ridge Wind USA0056255 156.6 46.4211 -117.8331 Wind       2005.1379310344828 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 53714 2017 404.14 453.219 362.25300000000004 415.07 342.81 U.S. Energy Information Administration  
29039 29039 USA United States of America Lower Baker USA0003855 111.2 48.5478 -121.7407 Hydro       1974.4892086330935 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30963 2017 352.565 429.608 308.611 358.833 313.113 U.S. Energy Information Administration  
29052 29052 USA United States of America Lower Snake River Wind Energy Project USA0057195 342.7 46.5242 -117.8217 Wind       2012.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59211 2017 808.8889999999999 875.6560000000002 732.789 865.023 705.788 U.S. Energy Information Administration  
29501 29501 USA United States of America Mint Farm Generating Station USA0055700 319.0 46.1388 -122.9855 Gas       2008.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48654 2017 1614.3410000000001 1288.911 1699.886 1057.948 878.5160000000002 U.S. Energy Information Administration  
31606 31606 USA United States of America Snoqualmie USA0003860 12.8 47.5401 -121.837 Hydro       1959.09375 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30970 2017 0.588 28.503 17.849 53.051 60.898999999999994 U.S. Energy Information Administration  
31607 31607 USA United States of America Snoqualmie 2 USA0007867 38.7 47.5445 -121.8414 Hydro       1977.8372093023254 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30968 2017 77.315 141.602 100.98 152.53799999999998 135.067 U.S. Energy Information Administration  
31980 31980 USA United States of America Sumas Power Plant USA0054476 125.5 48.9905 -122.2733 Gas       1993.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 537.92 446.06500000000005 602.0930000000002 394.995 257.63100000000003 U.S. Energy Information Administration  
32484 32484 USA United States of America Upper Baker USA0003861 104.8 48.649 -121.6907 Hydro       1959.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30972 2017 356.5540000000001 340.085 278.75 369.105 355.744 U.S. Energy Information Administration  
33017 33017 USA United States of America Whitehorn USA0006120 169.2 48.8856 -122.7516 Gas Oil     1981.0 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30973 2017 27.796 24.255 38.733 33.638000000000005 31.452 U.S. Energy Information Administration  
33040 33040 USA United States of America Wild Horse USA0056322 273.1 47.0363 -120.2065 Wind Solar     2007.3222262907361 Puget Sound Energy Inc U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 52656 2017 659.8629999999998 650.5630000000001 609.9630000000001 672.926 613.464 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");