global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

8 rows where country_long = "United Kingdom" and primary_fuel = "Coal"

View and edit SQL

Suggested facets: source, url, geolocation_source

primary_fuel

  • Coal · 8

other_fuel1

country_long

  • United Kingdom · 8
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 estimated_generation_gwh
18330 GBR United Kingdom Aberthaw B GBR1000374 1586.0 51.3873 -3.4049 Coal         RWE Npower Plc Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023577             13158.279440468445
18875 GBR United Kingdom Cottam GBR1000142 2008.0 53.304 -0.7815 Coal         EDF Energy Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025710             16659.410540013014
19002 GBR United Kingdom Drax GBR0000174 1980.0 53.7356 -0.9911 Coal Biomass       Drax Power UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1023594             16427.108002602472
19064 GBR United Kingdom Eggborough GBR1000147 1960.0 53.7116 -1.1269 Coal         Eggborough Power Ltd Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1023595             16261.1776187378
19532 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             4314.1899804814575
20195 GBR United Kingdom Ratcliffe GBR1000496 2000.0 52.8653 -1.255 Coal         Uniper UK Limited Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1025731             16593.038386467142
20661 GBR United Kingdom Uskmouth Power GBR2000811 230.0 51.5491 -2.9705 Coal               GEO               1908.1994144437213
20713 GBR United Kingdom West Burton GBR1000143 2012.0 53.3604 -0.8102 Coal         EDF Energy Department for Business Energy & Industrial Strategy https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes GEODB 1013947             16692.596616785948

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,
  "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");
Powered by Datasette · Query took 283.747ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute