global-power-plants

Table actions

18 rows where owner = "Scottish Power Renewables"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, wepp_id, estimated_generation_gwh

primary_fuel 1

owner 1

  • Scottish Power Renewables · 18 ✖

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
22028 22028 GBR United Kingdom Arecleoch GBR0003258 120.0 55.0688 -4.7971 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1078882               217.746140408853
22150 22150 GBR United Kingdom Beinn an Tuirc 2 GBR0004525 43.7 55.5732 -5.5874 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1042263               79.29588613222397
22199 22199 GBR United Kingdom Black Law GBR0003116 124.2 55.7622 -3.7626 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1051674               225.36725532316288
22200 22200 GBR United Kingdom Black Law 2 GBR0004253 55.42 55.7622 -3.7626 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1051674               100.56242584548862
22201 22201 GBR United Kingdom Black Law Extension - 1b GBR0004580 15.0 55.7622 -3.7626 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1051674               27.218267551106624
22383 22383 GBR United Kingdom Carland Cross RP GBR0003976 20.0 50.3509 -5.0306 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1027327               36.291023401475506
22584 22584 GBR United Kingdom Cruach Mhor GBR0003585 29.75 56.039 -5.1559 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1054273               53.98289730969481
22640 22640 GBR United Kingdom Dersalloch GBR0004269 69.0 55.3043 -4.4882 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1104427               125.20403073509048
22757 22757 GBR United Kingdom Ewe Hill I GBR0004015 13.8 55.1071 -3.3339 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1028362               25.040806147018102
22758 22758 GBR United Kingdom Ewe Hill II GBR0003627 20.7 55.1071 -3.3339 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 37.56120922052715
22887 22887 GBR United Kingdom Glen App GBR0004593 22.0 55.0007 -4.9897 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 39.920125741623046
22995 22995 GBR United Kingdom Hagshaw Hill 2 GBR0003220 26.0 55.5666 -3.9203 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1028372               47.17833042191815
23016 23016 GBR United Kingdom Hare Hill GBR0002711 13.2 55.3628 -4.1263 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1049518               23.952075444973826
23018 23018 GBR United Kingdom Hare Hill 2 GBR0004157 16.15 55.3628 -4.1263 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 29.305001396691466
23020 23020 GBR United Kingdom Harestanes GBR0004119 136.0 55.239 -3.5742 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1056621               246.77895913003343
23485 23485 GBR United Kingdom Lynemouth GBR0003752 26.0 55.2016 -1.5396 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1081188               47.17833042191815
23570 23570 GBR United Kingdom Middleton GBR0003702 12.0 55.7751 -4.3426 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1094640               21.7746140408853
24476 24476 GBR United Kingdom Whitelee 2 GBR0003981 217.02 55.6772 -4.2868 Wind         Scottish Power Renewables UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1051566               393.7938949294106

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