global-power-plants

Table actions

9 rows where owner = "AES"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: country, latitude, longitude, source, url, geolocation_source, wepp_id

primary_fuel 4

country_long 4

owner 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
3516 3516 BGR Bulgaria AES Galabovo WRI1075858 670.0 42.1573 25.9084 Coal       2011.0 AES GCPT https://endcoal.org/global-coal-plant-tracker/ GCPT                 2937.7135213006786
14054 14054 IND India AES Saurashtra Windfarms WRI1026669 39.2 21.9038 69.3732 Wind         AES CDM https://cdm.unfccc.int/Projects/DB/DNV-CUK1328700673.83/view WRI 1099756               399.3463389221721
17060 17060 KAZ Kazakhstan Shulbinskaya HPP WRI1000295 720.0 50.399 81.069 Hydro       1987.0 AES AES Group http://aes-group.kz/eng/about/business/7735/ GEODB 1020654               2846.5837320574165
17062 17062 KAZ Kazakhstan Ust-Kamenogorsk HPP WRI1000298 331.0 49.9012 82.7183 Hydro       1952.0 AES Samruk Energy http://www.samruk-energy.kz/en/group/jsc-ust-kamenogorsk-hpp GEODB 1020660               1308.6377990430624
22097 22097 GBR United Kingdom Ballylumford B GBR1000003 540.0 54.845 -5.787 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302       210.957 176.78900000000002   JRC-PPDB-OPEN 1817.1297921200146
22098 22098 GBR United Kingdom Ballylumford B OCGT GBR1000004 116.0 54.845 -5.787 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302         808.166   JRC-PPDB-OPEN 390.34639978874395
22099 22099 GBR United Kingdom Ballylumford C GBR1000001 616.0 54.8428 -5.7853 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1011302               2072.873985085054
23215 23215 GBR United Kingdom Kilroot GBR1000002 520.0 54.7255 -5.7653 Coal         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023937         1000.5830000000001   JRC-PPDB-OPEN 4314.1899804814575
23216 23216 GBR United Kingdom Kilroot OCGT GBR1000005 142.0 54.7251 -5.7643 Gas         AES Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023937               477.83783422415206

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