global-power-plants

Table actions

10 rows where owner = "Thames Water Utilities"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, estimated_generation_gwh

primary_fuel 4

owner 1

  • Thames Water Utilities · 10 ✖

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
22125 22125 GBR United Kingdom Basingstoke Sewage Treatment Works GBR0006054 1.2 51.2917 -1.0343 Biomass         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 20.846853977047886
22139 22139 GBR United Kingdom Beckton STW Enhanced Sludge Digestion GBR0006182 5.8 51.5256 0.0799 Waste         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1031283               13.4499511858956
22140 22140 GBR United Kingdom Beckton Sewage Treatment Works GBR0004976 2.2 51.5256 0.0799 Wind         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 3.9920125741623056
22577 22577 GBR United Kingdom Crossness GBR0002385 1.50371 51.508 0.1377 Solar         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1090350               0.7057055199514641
22578 22578 GBR United Kingdom Crossness Sewage Works GBR0006161 5.7 51.5022 0.1421 Waste         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 13.218055475793953
22579 22579 GBR United Kingdom Crossness Sewage Works Turbine GBR0003862 2.5 51.5022 0.1421 Wind         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 4.536377925184438
22626 22626 GBR United Kingdom Deephams Sewerage Treatment Works GBR0006491 3.0 51.6265 -0.0415 Biomass         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 52.117134942619714
23980 23980 GBR United Kingdom Rye Meads Sewerage Treatment Works GBR0006490 2.3 51.7749 0.0171 Biomass         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 39.95647012267512
24095 24095 GBR United Kingdom Slough Sewage Treatment Works GBR0006508 1.2 51.5067 -0.6376 Waste         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.782748521219779
24217 24217 GBR United Kingdom Swindon Sewerage Treatment Works GBR0006489 1.2 51.5679 -1.8085 Biomass         Thames Water Utilities UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 20.846853977047886

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