global-power-plants

Table actions

2 rows where country_long = "United Kingdom", owner = "Peel Energy" and primary_fuel = "Wind"

✎ View and edit SQL

This data as json, CSV (advanced)

primary_fuel 1

  • Wind · 2 ✖

owner 1

  • Peel Energy · 2 ✖

country_long 1

  • United Kingdom · 2 ✖
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
22839 22839 GBR United Kingdom Frodsham Wind Farm Ltd GBR0003694 50.4 53.3006 -2.7689 Wind         Peel Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1080834               91.45337897171824
23844 23844 GBR United Kingdom Port of Sheerness Wind Farm Ltd GBR0003738 8.2 51.443 0.7479 Wind         Peel Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1110733               14.879319594604954

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