global-power-plants

Table actions

6 rows where owner = "PSEG Fossil LLC"

✎ 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

owner 1

  • PSEG Fossil LLC · 6 ✖

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
25217 25217 USA United States of America Bergen Generating Station USA0002398 1400.8000000000004 40.8375 -74.0244 Gas Oil     1989.7687035979434 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30869 2017 5940.673003 5826.5239820000015 5714.3699560000005 4870.1269969999985 3468.1509769999993 U.S. Energy Information Administration  
30278 30278 USA United States of America PSEG Burlington Generating Station USA0002399 242.0 40.0766 -74.8792 Gas Oil     2000.0 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30872 2017 0.0 0.0 0.0 0.0 15.044 U.S. Energy Information Administration  
30279 30279 USA United States of America PSEG Essex Generating Station USA0002401 93.6 40.7372 -74.1206 Gas Oil     1990.0 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30874 2017 0.0 73.32600000000002 25.589 20.662000000000006 5.925000000000002 U.S. Energy Information Administration  
30282 30282 USA United States of America PSEG Kearny Generating Station USA0002404 605.0 40.7373 -74.0965 Gas Oil     2007.6 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30879 2017 0.0 581.4999959999999 720.1429969999999 557.585999 238.891998 U.S. Energy Information Administration  
30283 30283 USA United States of America PSEG Linden Generating Station USA0002406 1739.9999999999998 40.6217 -74.2072 Gas Oil     2004.1221839080465 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30882 2017 6105.231954 5540.305907 7598.443998000002 6414.47604 4909.400036999999 U.S. Energy Information Administration  
30285 30285 USA United States of America PSEG Sewaren Generating Station USA0002411 452.2 40.5558 -74.2469 Gas Oil     1949.3217602830607 PSEG Fossil LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30890 2017 0.0 0.0 0.0 0.0 16.41 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");