global-power-plants

Table actions

9 rows where owner = "Kansas City Power & Light Co"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year, generation_gwh_2016

primary_fuel 5

owner 1

  • Kansas City Power & Light Co · 9 ✖

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
27912 27912 USA United States of America Hawthorn USA0002079 1070.3 39.1306 -94.4778 Coal Gas     1982.2934691208075 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23829 2017 4034.817954 3413.1790220000007 3570.742963 2704.2949670000003 3253.038991 U.S. Energy Information Administration  
28215 28215 USA United States of America Iatan USA0006065 1640.0 39.4472 -94.98 Coal       1996.719512195122 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23831 2017 10597.274733 9187.941971 9406.011973 9762.360035999998 10886.599106 U.S. Energy Information Administration  
28498 28498 USA United States of America KCP&L SmartGrid Innovation Park USA0059772 1.0 39.0403 -94.5712 Storage       2012.0 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       0.0 0.0 U.S. Energy Information Administration  
28712 28712 USA United States of America La Cygne USA0001241 1578.0 38.3481 -94.6456 Coal       1974.7363751584287 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23832 2017 7520.252028 7939.783023999999 6981.2319910000015 8369.774995 4038.4439520000005 U.S. Energy Information Administration  
29584 29584 USA United States of America Montrose USA0002080 376.0 38.3114 -93.9348 Coal       1962.0 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23833 2017 2792.63597 2870.968965 1420.0630090000002 727.9150050000002 366.39599599999997 U.S. Energy Information Administration  
29980 29980 USA United States of America Northeast (MO) USA0002081 486.0 39.1228 -94.5606 Oil       1975.1275720164608 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 23834 2017 -0.5680000000000001 0.0 0.0 0.0 -0.107 U.S. Energy Information Administration  
30191 30191 USA United States of America Osawatomie USA0007928 90.0 38.5322 -94.9026 Gas       2003.0 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 51827 2017 0.257 12.149 3.616 1.375 0.433 U.S. Energy Information Administration  
31769 31769 USA United States of America Spearville USA0056351 148.5 37.8641 -99.7528 Wind       2007.6161616161614 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 51958 2017 490.566 476.587 461.099 408.55699999999996 310.296 U.S. Energy Information Administration  
32885 32885 USA United States of America West Gardner USA0007929 365.2 38.7875 -94.9861 Gas       2003.0 Kansas City Power & Light Co U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 51826 2017 23.643 34.444 34.974000000000004 12.165999999999999 9.856 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");