global-power-plants

Table actions

14 rows where owner = "Avista Corp"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 4

owner 1

  • Avista Corp · 14 ✖

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
25428 25428 USA United States of America Boulder Park USA0008022 24.6 47.6972 -117.1472 Gas       2001.9999999999993 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 49300 2017 25.921 14.811 22.428 18.358 26.649 U.S. Energy Information Administration  
25722 25722 USA United States of America Cabinet Gorge USA0000833 265.2 48.0844 -116.0531 Hydro       1952.5 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36351 2017 1042.427 1194.48 994.875 1075.975 1062.8110000000001 U.S. Energy Information Administration  
26376 26376 USA United States of America Coyote Springs II USA0007931 287.0 45.848 -119.674 Gas       2003.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30442 2017 1796.28 1493.933 1891.951 1765.406 1659.029 U.S. Energy Information Administration  
28604 28604 USA United States of America Kettle Falls Generating Station USA0000550 57.90000000000001 48.6203 -118.1111 Waste Gas     1986.238341968912 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36353 2017 300.011002 263.44299900000004 324.65799599999997 344.83799700000003 295.117 U.S. Energy Information Administration  
28940 28940 USA United States of America Little Falls (WA) USA0003866 34.8 47.8217 -117.9167 Hydro       1910.5402298850574 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36355 2017 176.53900000000004 195.005 147.602 182.385 183.422 U.S. Energy Information Administration  
28994 28994 USA United States of America Long Lake USA0003867 70.0 47.8344 -117.8361 Hydro       1918.5 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36354 2017 504.779 476.44199999999995 394.39 525.331 508.341 U.S. Energy Information Administration  
29559 29559 USA United States of America Monroe Street USA0009095 14.8 47.6536 -117.4206 Hydro       1993.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36357 2017 104.654 102.775 84.084 96.851 95.459 U.S. Energy Information Administration  
29899 29899 USA United States of America Nine Mile USA0003869 37.6 47.7697 -117.5372 Hydro       1954.212765957447 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36360 2017 82.92200000000001 55.63 66.89 108.78 114.367 U.S. Energy Information Administration  
29981 29981 USA United States of America Northeast (WA) USA0006210 61.8 47.7351 -117.3705 Gas       1979.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.222 2.431 1.073 1.087 0.39 U.S. Energy Information Administration  
30013 30013 USA United States of America Noxon Rapids USA0002199 569.5 47.9605 -115.7336 Hydro       1963.203160667252 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36359 2017 1581.223 1968.07 1635.111 1695.642 1866.144 U.S. Energy Information Administration  
30629 30629 USA United States of America Post Falls USA0000835 14.5 47.7033 -116.9539 Hydro       1924.7103448275864 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36362 2017 84.904 83.87200000000001 73.223 88.444 79.12 U.S. Energy Information Administration  
30845 30845 USA United States of America Rathdrum USA0007456 166.4 47.8043 -116.8673 Gas       1994.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36363 2017 33.688 12.789000000000001 52.558 40.615 71.741 U.S. Energy Information Administration  
32371 32371 USA United States of America Turner Energy Storage Project USA0060675 1.2 46.7518 -117.1614 Storage       2014.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 53629 2017       -0.46799999999999997 -0.601 U.S. Energy Information Administration  
32490 32490 USA United States of America Upper Falls USA0009096 10.0 47.6544 -117.4189 Hydro       1922.0 Avista Corp U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 36365 2017 68.384 67.033 38.374 62.708 68.396 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");