global-power-plants

Table actions

13 rows where capacity_mw = "2.0", country_long = "United States of America" and primary_fuel = "Gas"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016

primary_fuel 1

  • Gas · 13 ✖

country_long 1

  • United States of America · 13 ✖
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
25158 25158 USA United States of America Beaver City USA0002217 2.0 40.1303 -99.8278 Gas Oil     1960.9 City of Beaver City - (NE) U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.006999999999999999 0.02 0.001     U.S. Energy Information Administration  
25403 25403 USA United States of America Bonanza BioEnergy LLC USA0058193 2.0 37.9586 -100.8361 Gas       2008.0 Bonanza BioEnergy LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 5.0760000000000005 4.345 0.0 4.814 4.385 U.S. Energy Information Administration  
25420 25420 USA United States of America Boston Medical Center CHP Plant USA0061186 2.0 42.3347 -71.0742 Gas       2017.0 Boston Medical Center U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017         10.38408 U.S. Energy Information Administration 14.0909383779309
25588 25588 USA United States of America Bull Street Plant USA0059727 2.0 33.4898 -80.8703 Gas       2005.0 City of Orangeburg - (SC) U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017   -0.04 -0.011000000000000001 -0.008 -0.021 U.S. Energy Information Administration  
25592 25592 USA United States of America Bunge North America East LLC USA0050316 2.0 40.8465 -84.9333 Gas       1951.0 Bunge North America East LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 65572 2017 0.0 0.0 0.0 0.0 12.505999999999998 U.S. Energy Information Administration  
25710 25710 USA United States of America CSU Northridge Plant USA0058422 2.0 34.2433 -118.5306 Gas Solar     2005.7 California State University Northridge U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 50806 2017 5.9102999999999986 0.0 0.0 7.054740000000002 7.79922 U.S. Energy Information Administration  
26106 26106 USA United States of America Clark University USA0010408 2.0 42.2508 -71.8226 Gas       2013.0 Clark University U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 16663 2017 0.0 0.0 0.0 0.0 9.09244 U.S. Energy Information Administration  
26914 26914 USA United States of America Elk Basin Gasoline Plant USA0052127 2.0 44.9806 -108.8428 Gas       1948.0 Vanguard Natural Resources LLC 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 0.011000000000000001 U.S. Energy Information Administration  
27933 27933 USA United States of America Heat Plant 770 USA0057926 2.0 39.7941 -84.0805 Gas       2003.0 Wright Patterson AFB U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 2.91   0.0 0.0 0.0 U.S. Energy Information Administration 14.0909383779309
29686 29686 USA United States of America Municipal Power Plant USA0056504 2.0 42.8129 -86.0335 Gas       2002.0 City of Zeeland - (MI) U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.057999999999999996 0.038 0.036000000000000004 0.19399999999999998 0.11199999999999999 U.S. Energy Information Administration  
31964 31964 USA United States of America Substation 20 Plant USA0059728 2.0 33.4402 -80.8417 Gas       2014.0 City of Orangeburg - (SC) U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017   0.040999999999999995 -0.012 -0.035 -0.001 U.S. Energy Information Administration  
32809 32809 USA United States of America Watkins Manufacturing Co. USA0057715 2.0 33.1438 -117.2369 Gas       2001.0 Watkins Manufacturing Corporation U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 3.155 2.8789999999999996 0.606 4.2860000000000005 3.3153400000000004 U.S. Energy Information Administration  
32935 32935 USA United States of America Western Sugar Coop - Torrington USA0057967 2.0 42.0469 -104.1863 Gas Coal     1978.0 Western Sugar Cooperative U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 5.311 5.5950000000000015 5.593999999999999 6.893789999999999 8.47974 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");