global-power-plants

Table actions

8 rows where owner = "ESBPG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: latitude, longitude, geolocation_source

primary_fuel 3

owner 1

  • ESBPG · 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
15955 15955 IRL Ireland Aghada WRI1002813 528.0 51.8347 -8.2362 Gas         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef47 GEODB 1015293               1846.6058226134055
15956 15956 IRL Ireland Aghada CCGT WRI1002814 435.0 51.8347 -8.2362 Gas         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef96 GEODB                 1521.3513879485442
15958 15958 IRL Ireland Ardnacrusha WRI1002815 86.0 52.7056 -8.6128 Hydro         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef43 GEODB 1015295               209.79753086419757
15990 15990 IRL Ireland Lee WRI1002829 27.0 51.8833 -8.6333 Hydro         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef58 CARMA                 65.86666666666666
15994 15994 IRL Ireland Marina No ST WRI1002832 88.0 51.9 -8.4458 Gas         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef69 GEODB 1015310               307.7676371022343
16000 16000 IRL Ireland Poolbeg Combined Cycle WRI1002836 480.0 53.3396 -6.1867 Gas         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef72 GEODB 1015316               1678.732566012187
16010 16010 IRL Ireland Turlough Hill WRI1002841 292.0 53.0242 -6.4164 Hydro         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef79 GEODB 1015323               712.3358024691357
16012 16012 IRL Ireland West Offaly Power WRI1002843 137.0 53.2735 -8.0403 Biomass         ESBPG All Island Project http://www.allislandproject.org/en/market_decision_documents.aspx?article=151a9561-cef9-47f2-9f48-21f6c62cef84 GEODB 1061258       967.705     JRC-PPDB-OPEN 467.0

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