global-power-plants

Table actions

6 rows where owner = "ENEL" and primary_fuel = "Oil"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, geolocation_source, generation_gwh_2015, generation_data_source

primary_fuel 1

owner 1

  • ENEL · 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
16081 16081 ITA Italy AUGUSTA C.LE WRI1002849 210.0 37.2083 15.1778 Oil       1959.0 ENEL ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Daugusta-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757502&ssbinary=true CARMA 1015930               336.8819871555268
16239 16239 ITA Italy LIVORNO MARZOCCO WRI1002906 310.0 43.5673 10.31 Oil       1965.0 ENEL ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Dlivorno-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757397&ssbinary=true GEODB 1016051       457.298 603.866 679.742 JRC-PPDB-OPEN 497.3019810391111
16324 16324 ITA Italy PIOMBINO TERMICA WRI1002920 1280.0 42.9565 10.6034 Oil         ENEL ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Dpiombino-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757443&ssbinary=true GEODB                 2053.3759217098777
16330 16330 ITA Italy PORTO EMPEDOCLE C.LE WRI1002925 140.0 37.3123 13.5071 Oil         ENEL Power Plants at Risk of Shutting Down http://www.italy24.ilsole24ore.com/pdf2010/Editrice/ILSOLE24ORE/QUOTIDIANO_INSIDE_ITALY/Online/_Oggetti_Correlati/Documenti/2014/10/23/20141023_Power.pdf CARMA 1016115       0.0     ENTSOE 224.5879914370179
16331 16331 ITA Italy PORTO TOLLE WRI1002927 2640.0 44.9569 12.4883 Oil         ENEL Reuters http://uk.reuters.com/article/enel-portotolle-conversion-idUKLDE7661B620110707 GEODB 1015944               4235.087838526621
16349 16349 ITA Italy Portoscuso WRI1002926 320.0 39.2047 8.3789 Oil       1973.0 ENEL ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Dportoscuso-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757450&ssbinary=true CARMA 1016058       0.0     ENTSOE 513.3439804274694

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");