global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute

120 rows where owner = "Lightsource Renewable Energy" sorted by estimated_generation_gwh

View and edit SQL

primary_fuel

owner

  • Lightsource Renewable Energy · 20

country_long

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 estimated_generation_gwh ▼
20751 GBR United Kingdom Westwood GBR0001818 9.181000000000001 53.2228 -0.9266 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1106203             4.589877827894137
19667 GBR United Kingdom Lands West of Belfast Road GBR0005435 10.0 54.6356 -6.1148 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               4.999322326428642
20824 GBR United Kingdom Woodlands Farm Solar Park GBR0001516 10.0 51.3252 1.124 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               4.999322326428642
20130 GBR United Kingdom Pitchford GBR0002211 10.2 52.6223 -2.7131 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               5.099308772957214
18671 GBR United Kingdom Burntstalk Solar Park GBR0001713 11.5 52.6732 0.6271 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101552             5.749220675392937
19031 GBR United Kingdom Eakring Solar Farm GBR0002320 11.9 53.1547 -1.014 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1114374             5.9491935684500845
18541 GBR United Kingdom Bishops Sutton GBR0001282 12.0 51.0827 -1.1511 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               5.999186791714371
19721 GBR United Kingdom Littleton GBR0004840 12.1 50.8449 -2.1671 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               6.049180014978657
18779 GBR United Kingdom Chediston Hall Solar Park GBR0001717 12.3 52.3522 1.4737 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1101551             6.149166461507231
18850 GBR United Kingdom Condover Airfield GBR0002212 12.3 52.6327 -2.7301 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107425|1100757             6.149166461507231
19757 GBR United Kingdom Lodge Farm - Orston GBR0001498 12.4 52.966 -0.8324 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               6.199159684771518
20737 GBR United Kingdom Westerfield Farm - resubmission GBR0002089 12.5 51.7854 -1.6082 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               6.249152908035803
19717 GBR United Kingdom Little Morton Solar Farm GBR0001497 14.3 53.3039 -0.9932 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1106586             7.149030926792959
18777 GBR United Kingdom Charity Farm - CfD GBR0002108 14.402485 52.8244 -2.8096 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1112392             7.200266481655363
20697 GBR United Kingdom Waterloo solar park GBR0001769 14.6 52.1493 -0.2563 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1107481             7.299010596585817
20373 GBR United Kingdom Six Hills Solar Farm GBR0002057 18.7 52.7806 -1.0262 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1114695             9.348732750421561
19960 GBR United Kingdom Netherfield Lane GBR0002271 19.7 53.2311 -1.0914 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               9.848664983064424
19418 GBR United Kingdom Hillside Solar Farm GBR0005443 25.2 54.5601 -6.1807 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               12.598292262600179
19931 GBR United Kingdom Munceys Farm GBR0002249 31.6 52.0649 0.011 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database 1106549             15.797858551514508
18550 GBR United Kingdom Black Peak Farm GBR0002219 31.8 52.0782 0.0489 Solar         Lightsource Renewable Energy UK Renewable Energy Planning Database https://www.gov.uk/government/collections/renewable-energy-planning-data UK Renewable Energy Planning Database               15.897844998043087

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,
  "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");
Powered by Datasette · Query took 10.2ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute