global-power-plants

Table actions

10 rows where owner = "Archer Daniels Midland Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, other_fuel1, other_fuel2, commissioning_year, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016

primary_fuel 3

owner 1

  • Archer Daniels Midland Co · 10 ✖

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
24911 24911 USA United States of America Archer Daniels Midland Cedar Rapids USA0010864 294.6 41.9221 -91.6875 Coal Waste Gas   1996.5139171758317 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 969.2930050000001 941.471997 937.485004 943.5200039999999 1019.3619960000001 U.S. Energy Information Administration  
24912 24912 USA United States of America Archer Daniels Midland Clinton USA0010860 180.0 41.8206 -90.2097 Coal Waste Biomass Other 2009.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 800.823 838.855003 812.7869969999998 720.965996 677.0990039999998 U.S. Energy Information Administration  
24913 24913 USA United States of America Archer Daniels Midland Columbus USA0057046 71.4 41.4164 -97.2863 Coal Waste Other   2010.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63207 2017 0.0 0.0 0.0 0.0 303.324004 U.S. Energy Information Administration  
24914 24914 USA United States of America Archer Daniels Midland Decatur USA0010865 335.0 39.8701 -88.8908 Coal Waste Other   1995.620895522388 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 13430 2017 1081.8409929999998 1168.7430050000005 1094.1449940000002 1047.995003 1340.591998 U.S. Energy Information Administration  
24915 24915 USA United States of America Archer Daniels Midland Des Moines USA0010861 7.9 41.6244 -93.5845 Coal       1988.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 13429 2017 0.0 0.0 0.0 0.0 26.633000000000003 U.S. Energy Information Administration  
24916 24916 USA United States of America Archer Daniels Midland Lincoln USA0010862 7.9 40.8665 -96.6145 Coal       1988.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.0 0.0 0.0 0.0 27.122 U.S. Energy Information Administration  
24917 24917 USA United States of America Archer Daniels Midland Mankato USA0010863 6.1 44.1871 -93.9924 Coal       1987.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 13434 2017 21.372 22.415 23.087 22.83 23.314 U.S. Energy Information Administration  
24918 24918 USA United States of America Archer Daniels Midland Peoria USA0010866 36.0 40.6772 -89.6049 Gas       1988.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 166.857 189.007 0.0 0.0 192.567 U.S. Energy Information Administration  
24919 24919 USA United States of America Archer Daniels Midland Southport USA0054316 52.5 33.9397 -77.9905 Gas Oil     1992.9714285714285 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.0 0.0 2.72 1.3130000000000002 0.5 U.S. Energy Information Administration  
26964 26964 USA United States of America Enderlin USA0054908 9.8 46.6144 -97.5765 Waste Gas     1983.0 Archer Daniels Midland Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 29238 2017 5.481 2.6519999999999997 3.594 5.606 1.996 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");