global-power-plants

Table actions

20 rows where owner = "ALLETE Inc."

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, other_fuel1, commissioning_year, wepp_id, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016

primary_fuel 5

owner 1

  • ALLETE Inc. · 20 ✖

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
25307 25307 USA United States of America Bison 2 Wind Energy Center USA0057800 105.0 46.98 -101.5547 Wind       2013.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59506 2017 272.699 324.08799999999997 294.291 328.83099999999996 328.92199999999997 U.S. Energy Information Administration  
25308 25308 USA United States of America Bison 3 Wind Energy Center USA0057801 105.0 46.98 -101.5547 Wind       2013.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59506 2017 274.47700000000003 326.7270000000001 293.7560000000001 326.999 333.8160000000001 U.S. Energy Information Administration  
25309 25309 USA United States of America Bison 4 Wind Energy Center USA0058872 205.0 46.98 -101.5547 Wind       2015.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59506 2017     712.056 832.159 840.9200000000002 U.S. Energy Information Administration 36.36854895777275
25310 25310 USA United States of America Bison I Wind Energy Center USA0057038 81.8 46.98 -101.5547 Wind       2011.5501222493888 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59506 2017 232.623 269.839 239.495 268.839 271.815 U.S. Energy Information Administration  
25341 25341 USA United States of America Blanchard USA0001892 18.0 45.8614 -94.3592 Hydro       1946.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26505 2017 86.962 100.39299999999999 85.85600000000002 114.265 110.12200000000001 U.S. Energy Information Administration  
26112 26112 USA United States of America Clay Boswell USA0001893 1073.3 47.2611 -93.6528 Coal Oil     1974.6878785055442 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26506 2017 0.0 0.0 0.0 0.0 7080.406965000001 U.S. Energy Information Administration  
27205 27205 USA United States of America Fond Du Lac USA0001894 12.0 46.6668 -92.2939 Hydro       1924.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 47165 2017 13.936 34.37 44.863 69.19 84.348 U.S. Energy Information Administration  
28670 28670 USA United States of America Knife Falls USA0001895 2.4000000000000004 46.7266 -92.4486 Hydro       1922.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26508 2017 9.107999999999999 8.397 10.552 14.834000000000001 12.142999999999999 U.S. Energy Information Administration  
28939 28939 USA United States of America Little Falls (MN) USA0001896 4.6000000000000005 45.975 -94.3691 Hydro       1932.608695652173 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26509 2017 32.604 34.311 32.266 34.385 23.503 U.S. Energy Information Administration  
29076 29076 USA United States of America M L Hibbard USA0001897 72.8 46.7353 -92.1517 Waste Coal Gas   1950.03021978022 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26510 2017 25.267000000000003 19.635 0.973 7.468 4.357 U.S. Energy Information Administration  
30485 30485 USA United States of America Pillager USA0001898 1.6 46.316 -94.4849 Hydro       1917.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26513 2017 8.476 9.891 9.496 11.33 9.547 U.S. Energy Information Administration  
30658 30658 USA United States of America Prairie River USA0000378 1.0 47.2872 -93.4983 Hydro       1920.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26512 2017 1.2930000000000001 2.524 2.971 4.36 4.053999999999999 U.S. Energy Information Administration  
30840 30840 USA United States of America Rapids Energy Center USA0010686 28.4 47.2348 -93.5372 Waste Coal Gas Hydro 1972.6830985915487 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 14634 2017 108.12988999999999 118.662986 118.02688899999998 119.80816599999999 126.47367 U.S. Energy Information Administration  
31357 31357 USA United States of America Scanlon USA0001899 1.6 46.7091 -92.4217 Hydro       1923.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26514 2017 6.7730000000000015 5.684 7.776 10.076 9.454 U.S. Energy Information Administration  
32070 32070 USA United States of America Syl Laskin USA0001891 116.0 47.5306 -92.1619 Gas       1953.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26516 2017 471.94900500000006 0.0 0.0 0.0 5.617999999999999 U.S. Energy Information Administration  
32071 32071 USA United States of America Sylvan USA0001900 1.7999999999999998 46.305 -94.3775 Hydro       1913.666666666667 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26515 2017 7.8358500000000015 10.927999999999999 10.981 11.457 12.425 U.S. Energy Information Administration  
32108 32108 USA United States of America Taconite Harbor Energy Center USA0010075 168.0 47.5314 -90.9114 Coal Oil     1957.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25205 2017 1064.433986 0.0 0.0 0.0 0.0 U.S. Energy Information Administration  
32109 32109 USA United States of America Taconite Ridge 1 Wind Energy Center USA0056630 25.0 47.5747 -92.5917 Wind       2008.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 57091 2017 55.891000000000005 66.61 67.415 47.148 56.593999999999994 U.S. Energy Information Administration  
32225 32225 USA United States of America Thomson USA0001901 72.6 46.655 -92.3333 Hydro       1916.7685950413227 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26517 2017   11.395 199.037 417.421 477.94699999999995 U.S. Energy Information Administration  
33126 33126 USA United States of America Winton USA0001902 4.0 47.9344 -91.7639 Hydro       1923.0 ALLETE Inc. U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 26518 2017 21.34242 19.602 19.804 26.025 30.163 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");