global-power-plants

Table actions

1 row where country_long = "United Kingdom", owner = "EcoGen Projects Limited for Fenpower Limited 30 Fore Street Chasewater Cornwall TR4 8PT" and primary_fuel = "Wind"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

  • Wind · 1 ✖

owner 1

  • EcoGen Projects Limited for Fenpower Limited 30 Fore Street Chasewater Cornwall TR4 8PT · 1 ✖

country_long 1

  • United Kingdom · 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
23888 23888 GBR United Kingdom Ranson Moor Wind Farm (Phase 2) GBR0002953 4.0 52.5106 0.0373 Wind         EcoGen Projects Limited for Fenpower Limited 30 Fore Street Chasewater Cornwall TR4 8PT UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 7.258204680295099

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