global-power-plants

Table actions

10 rows where owner = "Great River Energy"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, other_fuel1, commissioning_year

primary_fuel 4

owner 1

  • Great River Energy · 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
25761 25761 USA United States of America Cambridge CT USA0002038 194.2 45.601 -93.2081 Gas Oil     2003.266735324408 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35359 2017 83.051 32.339 33.011 44.336999999999996 22.024 U.S. Energy Information Administration  
26151 26151 USA United States of America Coal Creek USA0006030 1215.6 47.3777 -101.1571 Coal Oil     1979.680157946693 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17629 2017 0.0 0.0 0.0 0.0 7949.503044999998 U.S. Energy Information Administration  
26649 26649 USA United States of America Dickinson Solar Array USA0060652 2.3 45.1144 -93.8138 Solar       2016.0 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 70082 2017       0.6679999999999999 2.469 U.S. Energy Information Administration 1.0223838409177732
26920 26920 USA United States of America Elk River USA0002039 239.3 45.2968 -93.5584 Gas Waste Oil   1998.201838696197 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35361 2017 227.283 176.69400000000005 164.035 206.083 170.392 U.S. Energy Information Administration  
28770 28770 USA United States of America Lakefield Junction USA0007925 537.8 43.7984 -94.8415 Gas Oil     2001.003718854593 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 45233 2017 128.249005 35.258 84.12899999999999 189.393004 72.492 U.S. Energy Information Administration  
29184 29184 USA United States of America Maple Lake USA0002042 25.0 45.2291 -94.0097 Oil       1978.0 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35364 2017 0.22 0.452 0.131 0.28800000000000003 0.26 U.S. Energy Information Administration  
30564 30564 USA United States of America Pleasant Valley (MN) USA0007843 467.8 43.7994 -92.6829 Gas Oil     2001.2838820008553 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 61140 2017 164.182005 73.554 65.558 129.81899900000002 47.577 U.S. Energy Information Administration  
31028 31028 USA United States of America Rock Lake CT USA0006741 25.0 45.8054 -92.9718 Oil       1978.0 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 35368 2017 0.217 0.26899999999999996 0.149 0.27399999999999997 0.308 U.S. Energy Information Administration  
31788 31788 USA United States of America Spiritwood Station USA0056786 106.2 46.9264 -98.4997 Coal Gas     2014.0 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 55722 2017   32.125 208.875003 228.724002 212.494005 U.S. Energy Information Administration  
31822 31822 USA United States of America St Bonifacius USA0006824 61.2 44.905 -93.8208 Oil       1978.0 Great River Energy U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 17631 2017 0.5379999999999999 0.685 0.379 0.639 0.536 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");