global-power-plants

Table actions

11 rows where country_long = "Italy" 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

  • Oil · 11 ✖

country_long 1

  • Italy · 11 ✖
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
16080 16080 ITA Italy ASSEMINI WRI1002848 177.0 39.2269 8.9972 Oil       1992.0 Italy Ministry of Economy and Finance ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Dassemini-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757474&ssbinary=true CARMA 1015929               283.943389173944
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
16232 16232 ITA Italy LAMARMORA WRI1002898 116.7 45.5248 10.2273 Oil           A2A http://www.a2a.eu/en/plants_networks/cogeneration/lamarmora.html CARMA 1010422       142.856 160.014 108.947 JRC-PPDB-OPEN 187.21013286214284
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
16360 16360 ITA Italy ROSSANO TE WRI1002939 1200.0 39.6218 16.6084 Oil           ENEL https://www.futur-e.enel.it/cs/Satellite?blobcol=urldata&blobheader=application%2Fpdf&blobheadername1=Content-Disposition&blobheadername2=MDT-Type&blobheadervalue1=inline%3B+filename%3Drossano-eng.pdf&blobheadervalue2=abinary%3B+charset%3DUTF-8&blobkey=id&blobtable=MungoBlobs&blobwhere=1445864757481&ssbinary=true GEODB         0.0 3.2880000000000003 4.584 JRC-PPDB-OPEN 1925.0399266030106
16367 16367 ITA Italy SAN FILIPPO DEL MELA WRI1002947 866.0 38.2049 15.2818 Oil         Edipower Edipower https://web.archive.org/web/20150316075708/http://www.edipower.it/centrale_di_sanfilippo.htm GEODB 1016154       2181.092 1247.744 1300.073 JRC-PPDB-OPEN 1389.2371470318392
16431 16431 ITA Italy TURBIGO WRI1002973 1569.0 45.5201 8.7422 Oil         Edipower Edipower https://web.archive.org/web/20110909235851/http://www.edipower.org/centrali/turbigo.asp GEODB         1617.0710000000001 1944.406 1271.599 JRC-PPDB-OPEN 2516.9897040334367

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