global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
12 rows where country_long = "United Kingdom", estimated_generation_note_2017 = "CAPACITY-FACTOR-V1", owner = "Ecotricity" and url = "https://www.gov.uk/government/collections/renewable-energy-planning-data"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, estimated_generation_gwh_2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22018 | 22018 | GBR | United Kingdom | Alveston Wind Park | GBR0004335 | 6.9 | 51.5723 | -2.4999 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 17.39 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22111 | 22111 | GBR | United Kingdom | Bambers Farm | GBR0003157 | 9.6 | 53.3213 | 0.2384 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1054051 | 24.2 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22647 | 22647 | GBR | United Kingdom | Dagenham | GBR0003158 | 2.3 | 51.5187 | 0.1508 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1068154 | 5.79 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22648 | 22648 | GBR | United Kingdom | Dalby | GBR0003764 | 9.2 | 52.8065 | -1.0343 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1107559 | 23.19 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22729 | 22729 | GBR | United Kingdom | Dundee | GBR0004681 | 4.0 | 56.4836 | -2.8938 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1068156 | 10.08 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22842 | 22842 | GBR | United Kingdom | Fen Farm | GBR0003449 | 16.0 | 53.4233 | 0.069 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1056287 | 40.33 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22912 | 22912 | GBR | United Kingdom | Galsworthy | GBR0004624 | 9.2 | 50.9187 | -4.2715 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1104773 | 23.19 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24190 | 24190 | GBR | United Kingdom | Shooters | GBR0003161 | 2.0 | 51.2544 | -2.5834 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1068157 | 5.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24238 | 24238 | GBR | United Kingdom | Somerton | GBR0002555 | 1.8 | 52.7099 | 1.6545 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1049120 | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24347 | 24347 | GBR | United Kingdom | Swaffham II | GBR0003159 | 1.8 | 52.6577 | 0.7007 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24391 | 24391 | GBR | United Kingdom | The Michelin Tyre Factory - Ballymena | GBR0003680 | 4.6 | 54.8728 | -6.1986 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1106009 | 11.59 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24690 | 24690 | GBR | United Kingdom | Worksopp | GBR0003510 | 2.0 | 53.2998 | -1.0757 | Wind | Ecotricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1076805 | 5.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 |
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");