global-power-plants

Table actions

11 rows where owner = "Vogt Solar"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, estimated_generation_gwh

primary_fuel 1

owner 1

  • Vogt Solar · 11 ✖

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
22580 22580 GBR United Kingdom Crossways Solar Park GBR0001567 4.997 50.7 -2.3243 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1096728               2.3451400091756156
22588 22588 GBR United Kingdom Crundale / Fenton Home Farm (extension) GBR0004830 5.9 51.8236 -4.9284 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1109319               2.7689265667672873
22927 22927 GBR United Kingdom Grange Farm GBR0001572 5.80219 50.711 -4.4233 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101501               2.7230233960053365
23127 23127 GBR United Kingdom Horam GBR0002169 8.11512 50.9313 0.2377 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1109309               3.8085036204244993
23365 23365 GBR United Kingdom Langunnett GBR0001230 6.1739999999999995 50.3913 -4.596 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101500               2.8975173937663103
23374 23374 GBR United Kingdom Lee Farm GBR0001558 5.0 50.6925 -1.4491 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379
23521 23521 GBR United Kingdom Manston GBR0001232 9.831 51.3519 1.3674 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101496               4.613782555574441
23539 23539 GBR United Kingdom Marshborough Farm solar park (resubmission) GBR0005117 5.0 51.2774 1.3072 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379
23747 23747 GBR United Kingdom Oving Solar Farm GBR0001571 5.0 50.8373 -0.7054 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101503               2.346547937938379
24275 24275 GBR United Kingdom Tiddiecross Solar Farm GBR0004858 10.5 52.7035 -2.5747 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 4.927750669670595
24428 24428 GBR United Kingdom West Farm GBR0001244 7.63 51.6987 -4.9012 Solar         Vogt Solar UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 3.580832153293966

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