global-power-plants

Table actions

8 rows where owner = "National Grid Generation LLC" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

owner 1

  • National Grid Generation LLC · 8 ✖

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
26829 26829 USA United States of America East Hampton USA0002512 27.3 40.9617 -72.2103 Oil       1969.2417582417584 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25008 2017 8.884 6.339 10.742 12.337 7.624 U.S. Energy Information Administration  
27556 27556 USA United States of America Glenwood USA0002514 110.0 40.8271 -73.6475 Oil       1972.0 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 52010 2017 2.1430000000000002 5.016 4.615 3.097 0.755 U.S. Energy Information Administration  
28070 28070 USA United States of America Holtsville USA0008007 567.0 40.817 -73.0663 Oil       1974.5 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25015 2017 66.039 35.961999999999996 0.0 0.0 13.29 U.S. Energy Information Administration  
31498 31498 USA United States of America Shoreham USA0002518 71.5 40.9616 -72.865 Oil       1969.699300699301 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25025 2017 3.0660000000000003 0.633 2.024 5.268 0.72 U.S. Energy Information Administration  
31713 31713 USA United States of America South Hampton USA0002519 11.5 40.9 -72.382 Oil       1963.0 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25023 2017 1.744 0.022000000000000002 0.6930000000000001 1.634 0.951 U.S. Energy Information Administration  
31751 31751 USA United States of America Southold USA0002520 14.0 41.1059 -72.3761 Oil       1964.0 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25026 2017 1.624 0.151 0.6729999999999999 0.669 0.141 U.S. Energy Information Administration  
32679 32679 USA United States of America Wading River USA0007146 238.5 40.9569 -72.8774 Oil       1989.0 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 42.982 30.715 16.323 22.971999999999998 5.721 U.S. Energy Information Administration  
32863 32863 USA United States of America West Babylon USA0002521 52.4 40.6955 -73.3486 Oil       1971.0 National Grid Generation LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 25028 2017 2.254 2.143 0.765 4.154 0.732 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");