global-power-plants

Table actions

13 rows where owner = "Interstate Power and Light Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, commissioning_year, generation_gwh_2013, generation_gwh_2014, generation_gwh_2016

primary_fuel 5

owner 1

  • Interstate Power and Light Co · 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
25600 25600 USA United States of America Burlington (IA) USA0001104 290.7999999999999 40.7412 -91.1167 Coal Gas     1975.248624484182 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 22797 2017 1124.88202 0.0 1082.225999 1121.6940069999996 1091.577021 U.S. Energy Information Administration  
26953 26953 USA United States of America Emery Station USA0008031 602.8 43.094 -93.2922 Gas       2004.0000000000007 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50572 2017 0.0 0.0 0.0 0.0 1980.141 U.S. Energy Information Administration  
27302 27302 USA United States of America Franklin County Wind Farm USA0057844 99.0 42.6067 -93.3365 Wind       2013.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 64041 2017 219.005 221.965 251.019 257.192 224.727 U.S. Energy Information Administration  
28810 28810 USA United States of America Lansing USA0001047 274.5 43.3359 -91.1675 Coal Oil     1977.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23243 2017 0.0 0.0 860.4199980000001 0.0 974.8469960000001 U.S. Energy Information Administration  
28906 28906 USA United States of America Lime Creek USA0007155 90.2 43.2481 -93.205 Oil       1991.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23245 2017 -1.041 -0.674 0.062 0.063 0.366 U.S. Energy Information Administration  
29244 29244 USA United States of America Marshalltown USA0001068 189.0 42.0474 -92.8594 Gas Oil     1978.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 22814 2017 18.277 9.729 2.157 3.095 17.910999999999998 U.S. Energy Information Administration  
29245 29245 USA United States of America Marshalltown Generating Station USA0058236 705.9 42.0433 -92.8728 Gas       2017.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         1307.6280000000004 U.S. Energy Information Administration 4973.396700490711
29484 29484 USA United States of America Milton L Kapp USA0001048 218.5 41.8081 -90.2336 Gas       1967.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23248 2017 761.610997 787.812997 279.51499900000005 -6.271 20.518 U.S. Energy Information Administration  
30221 30221 USA United States of America Ottumwa USA0006254 725.9 41.0961 -92.5558 Coal       1981.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 22820 2017 3363.2170180000007 2632.396017 3855.965982 3708.987035000001 4019.132027 U.S. Energy Information Administration  
30653 30653 USA United States of America Prairie Creek USA0001073 213.4 41.944 -91.6392 Coal Gas     1966.9437675726333 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 22821 2017 0.0 0.0 308.278998 322.11299999999994 322.31900400000006 U.S. Energy Information Administration  
30863 30863 USA United States of America Red Cedar USA0007595 22.5 41.9691 -91.6689 Gas       1997.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 22799 2017 6.744 -0.21100000000000002 -0.528 -0.71 -0.667 U.S. Energy Information Administration  
32881 32881 USA United States of America West Dubuque Solar USA0060951 3.8 42.4918 -90.7922 Solar       2017.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         0.672 U.S. Energy Information Administration 1.6891559110815384
32993 32993 USA United States of America Whispering Willow Wind Farm - East USA0056355 199.7 42.6305 -93.2064 Wind       2010.0 Interstate Power and Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 57872 2017 639.069 621.597 653.1030000000002 630.455 626.369 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");