global-power-plants

Table actions

13 rows where owner = "NorthWestern Energy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year

primary_fuel 3

owner 1

  • NorthWestern Energy · 13 ✖

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
25321 25321 USA United States of America Black Eagle USA0002181 24.0 47.5213 -111.2614 Hydro       1927.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26726 2017 109.985 120.985 127.279 118.288 126.346 U.S. Energy Information Administration  
26161 26161 USA United States of America Cochrane USA0002182 60.4 47.5375 -111.195 Hydro       1958.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26730 2017 229.22299999999998 244.51 260.568 234.165 288.168 U.S. Energy Information Administration  
27897 27897 USA United States of America Hauser USA0002185 14.2 46.7659 -111.8873 Hydro       1911.8450704225354 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26733 2017 115.817 111.83 122.257 120.43700000000001 130.317 U.S. Energy Information Administration  
28068 28068 USA United States of America Holter USA0002186 38.4 46.9915 -112.0047 Hydro       1918.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26735 2017 226.345 249.642 258.627 254.06400000000002 299.866 U.S. Energy Information Administration  
28739 28739 USA United States of America Lake (WY) USA0007039 2.7 44.415 -110.5739 Oil       1967.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 60549 2017 0.0 0.08700000000000001 0.206 0.094 0.27699999999999997 U.S. Energy Information Administration  
29135 29135 USA United States of America Madison Dam USA0006422 8.8 45.4879 -111.6338 Hydro       1906.5000000000007 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26738 2017 56.473 53.648999999999994 59.401 57.101000000000006 62.278999999999996 U.S. Energy Information Administration  
29619 29619 USA United States of America Morony USA0002191 54.0 47.5817 -111.0609 Hydro       1930.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26741 2017 225.296 254.979 247.097 258.995 289.76599999999996 U.S. Energy Information Administration  
29712 29712 USA United States of America Mystic USA0002192 12.0 45.2257 -109.7625 Hydro       1925.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26739 2017 54.123999999999995 57.106 57.481 51.416 61.891000000000005 U.S. Energy Information Administration  
30093 30093 USA United States of America Old Faithful USA0002196 2.0 44.4533 -110.8347 Oil       1980.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26742 2017 0.198 0.124 0.158 0.069 0.212 U.S. Energy Information Administration  
30820 30820 USA United States of America Rainbow (MT) USA0002193 59.0 47.5344 -111.2045 Hydro       2013.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 62549 2017 289.2030000000001 367.241 347.74199999999996 343.233 376.048 U.S. Energy Information Administration  
31136 31136 USA United States of America Ryan USA0002194 50.4 47.5699 -111.1225 Hydro       1915.3174603174607 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26745 2017 395.44 468.99199999999996 447.914 413.97900000000004 423.168 U.S. Energy Information Administration  
31785 31785 USA United States of America Spion Kop Wind Farm USA0058218 40.0 47.3333 -110.6392 Wind       2013.0 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63422 2017 144.11 136.35 127.626 130.661 131.18200000000002 U.S. Energy Information Administration  
32224 32224 USA United States of America Thompson Falls USA0002195 87.1 47.5932 -115.3582 Hydro       1915.3444316877155 NorthWestern Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26747 2017 482.93199999999996 529.751 522.509 510.256 498.356 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");