global-power-plants

Table actions

4 rows where owner = "Island Green Power"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, estimated_generation_gwh

primary_fuel 1

owner 1

  • Island Green Power · 4 ✖

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
22095 22095 GBR United Kingdom Ballyboley Solar (Carrowdore) GBR0004724 6.0 54.5716 -5.5692 Solar         Island Green Power UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.8158575255260545
23054 23054 GBR United Kingdom High Dyke (Mill Farm) GBR0005581 5.0 52.8826 -0.5994 Solar         Island Green Power UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379
23275 23275 GBR United Kingdom Land East of White Horse Lane GBR0004885 5.0 52.6051 1.3064 Solar         Island Green Power UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379
23995 23995 GBR United Kingdom Salhouse Solar Farm GBR0002050 5.0 52.6887 1.4 Solar         Island Green Power UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379

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