global-power-plants

Table actions

18 rows where country_long = "United Kingdom", owner = "Hive Energy" and primary_fuel = "Solar"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, latitude, longitude, estimated_generation_gwh

primary_fuel 1

  • Solar · 18 ✖

owner 1

  • Hive Energy · 18 ✖

country_long 1

  • United Kingdom · 18 ✖
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
22162 22162 GBR United Kingdom Bentham Farm GBR0002344 8.0 51.6055 -1.8987 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1117088               3.754476700701407
22406 22406 GBR United Kingdom Castle Eaton Farm GBR0001945 17.8 51.6491 -1.7907 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 8.35371065906063
22813 22813 GBR United Kingdom Folly Farm GBR0002217 13.1 51.8395 -0.7395 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107382               6.1479555973985525
22956 22956 GBR United Kingdom Green Farm (resubmission) GBR0005089 5.0 51.9119 1.1535 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107648               2.346547937938379
23061 23061 GBR United Kingdom High Penn Solar Park GBR0001998 9.6 51.4512 -1.986 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101055               4.505372040841689
23067 23067 GBR United Kingdom Higher Hatherleigh Solar Farm GBR0001586 3.5 51.0437 -2.4272 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 1.6425835565568652
23075 23075 GBR United Kingdom Highfields Farm (Braintree) GBR0001999 2.8 51.8248 0.7195 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 1.3140668452454922
23076 23076 GBR United Kingdom Highfields Farm (Colchester) GBR0002000 12.2 51.8248 0.7195 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 5.7255769685696425
23236 23236 GBR United Kingdom Knockworthy Farm Solar Park GBR0001416 4.6452 50.9853 -4.1224 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101575               2.180036896262272
23443 23443 GBR United Kingdom Lodge Farm (Poulshot) GBR0002351 14.5 51.6176 -2.0531 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1104714               6.804989020021298
23828 23828 GBR United Kingdom Pitworthy Farm Solar Park GBR0002013 18.0 50.8214 -4.4275 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107384               8.447572576578164
23878 23878 GBR United Kingdom Raglington Farm Solar Park GBR0001418 4.6452 50.9179 -1.2323 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101571               2.180036896262272
23961 23961 GBR United Kingdom Roundponds Farm Solar Park GBR0002023 13.5 51.3801 -2.1627 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107383               6.335679432433622
24170 24170 GBR United Kingdom Steventon GBR0001817 10.03917 51.6334 -1.3613 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 4.711478732422567
24232 24232 GBR United Kingdom Tavells Lane Solar Farm GBR0001086 5.3 50.8941 -1.4585 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1106911               2.4873408142146816
24328 24328 GBR United Kingdom Troughton Farm GBR0002080 30.0 51.9592 -2.1215 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 14.079287627630274
24496 24496 GBR United Kingdom Wilbees Farm (resubmission) GBR0002258 5.0 50.8404 0.1907 Solar         Hive Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database                 2.346547937938379
24513 24513 GBR United Kingdom Winham Farm - resubmission GBR0002095 5.0 50.8245 -3.3974 Solar         Hive Energy 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");