global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
121 rows where country_long = "United Kingdom" and owner = "Lightsource Renewable Energy" sorted by generation_gwh_2013
This data as json, CSV (advanced)
primary_fuel 1
- Solar 21
owner 1
- Lightsource Renewable Energy · 21 ✖
country_long 1
- United Kingdom · 21 ✖
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_gwh_2018 | generation_gwh_2019 | generation_data_source | estimated_generation_gwh_2013 | estimated_generation_gwh_2014 | estimated_generation_gwh_2015 | estimated_generation_gwh_2016 | estimated_generation_gwh_2017 | estimated_generation_note_2013 | estimated_generation_note_2014 | estimated_generation_note_2015 | estimated_generation_note_2016 | estimated_generation_note_2017 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
24288 | 24288 | GBR | United Kingdom | Stables | GBR0001421 | 1.966 | 50.6971 | -1.422 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.85 | 2.9 | 2.77 | 2.81 | 2.85 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24291 | 24291 | GBR | United Kingdom | Staining Wood Farm | GBR0005328 | 4.9 | 53.7805 | -2.9599 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1114844 | 6.95 | 7.16 | 7.27 | 7.3 | 7.33 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24322 | 24322 | GBR | United Kingdom | Stragglethorpe | GBR0005654 | 4.99928 | 52.9264 | -1.0508 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.3 | 7.6 | 7.64 | 7.66 | 7.73 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24345 | 24345 | GBR | United Kingdom | Sutton Mawr Farm | GBR0001823 | 7.5 | 51.4186 | -3.327 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 11.27 | 11.08 | 11.06 | 11.24 | 11.26 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24382 | 24382 | GBR | United Kingdom | The Breck | GBR0005520 | 5.0 | 53.2813 | -1.3619 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.11 | 7.65 | 7.5 | 7.52 | 7.76 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24403 | 24403 | GBR | United Kingdom | Thorne Farm | GBR0002073 | 6.2 | 51.3386 | 1.3476 | 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.14 | 9.65 | 9.29 | 9.37 | 9.43 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24429 | 24429 | GBR | United Kingdom | Tooleys Farm | GBR0004859 | 5.3 | 51.885 | 0.3944 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.1 | 8.08 | 7.93 | 7.96 | 8.06 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24445 | 24445 | GBR | United Kingdom | Tredown Solar Farm | GBR0001435 | 1.2 | 50.6102 | -4.2707 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.75 | 1.72 | 1.74 | 1.74 | 1.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24449 | 24449 | GBR | United Kingdom | Treguff | GBR0002137 | 3.736465 | 51.4308 | -3.4073 | 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.56 | 5.48 | 5.47 | 5.52 | 5.49 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24452 | 24452 | GBR | United Kingdom | Trench Farm | GBR0002079 | 7.2 | 52.9454 | -2.9179 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 10.15 | 10.87 | 10.63 | 10.71 | 11.01 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24482 | 24482 | GBR | United Kingdom | Turves/Burtnhouse Solar Farm extension | GBR0002171 | 4.7 | 52.5295 | -0.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 | 7.49 | 7.38 | 7.44 | 7.46 | 7.5 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24501 | 24501 | GBR | United Kingdom | Upper Clayhill | GBR0001198 | 4.7492 | 50.9159 | 0.0554 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1111282 | 7.48 | 7.47 | 7.57 | 7.57 | 7.69 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24521 | 24521 | GBR | United Kingdom | Walland Farm | GBR0002336 | 5.0 | 50.9758 | -4.3468 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.46 | 7.63 | 7.6 | 7.57 | 7.69 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24546 | 24546 | 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 | 22.26 | 21.87 | 21.9 | 22.16 | 22.45 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24562 | 24562 | GBR | United Kingdom | West Bradley | GBR0001445 | 1.029 | 50.9163 | -3.5707 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1096723 | 1.48 | 1.55 | 1.53 | 1.53 | 1.56 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24590 | 24590 | 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 | 18.37 | 18.81 | 19.13 | 19.17 | 19.46 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24604 | 24604 | GBR | United Kingdom | Westwood | GBR0001818 | 9.181 | 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 | 13.23 | 13.7 | 13.95 | 14.0 | 14.12 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24612 | 24612 | GBR | United Kingdom | Whiddon Farm | GBR0001446 | 1.0 | 50.7524 | -4.2773 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.49 | 1.5 | 1.51 | 1.51 | 1.5 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24636 | 24636 | GBR | United Kingdom | Wiggin Hill Solar Farm - Phase 1 | GBR0001865 | 6.8 | 52.3557 | -0.0774 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 10.09 | 9.96 | 10.11 | 10.14 | 10.16 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24637 | 24637 | GBR | United Kingdom | Wiggin Hill Solar Farm - Phase 2 | GBR0001315 | 4.1 | 52.356 | -0.0785 | 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.05 | 5.97 | 6.03 | 6.04 | 6.02 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24683 | 24683 | 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 | 14.84 | 15.7 | 15.1 | 15.3 | 15.37 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE |
Advanced export
JSON shape: default, array, newline-delimited
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_gwh_2018" REAL, "generation_gwh_2019" REAL, "generation_data_source" TEXT, "estimated_generation_gwh_2013" REAL, "estimated_generation_gwh_2014" REAL, "estimated_generation_gwh_2015" REAL, "estimated_generation_gwh_2016" REAL, "estimated_generation_gwh_2017" REAL, "estimated_generation_note_2013" TEXT, "estimated_generation_note_2014" TEXT, "estimated_generation_note_2015" TEXT, "estimated_generation_note_2016" TEXT, "estimated_generation_note_2017" TEXT ); CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long"); CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");