global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
40 rows where capacity_mw = "6.0" and country_long = "United Kingdom"
This data as json, CSV (advanced)
Suggested facets: source, url, geolocation_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
owner >30
- Lightsource Renewable Energy 2
- Scottish and Southern Energy (SSE) 2
- Waste Recycling Group 2
- A7 Energy / Green Energy 1
- Airtricity 1
- Arqiva Ltd 1
- Atlantis Resources 1
- Banks Renewables 1
- Biffa 1
- Bristol Port Authority 1
- Broadview Energy 1
- Canford Renewable Energy Ltd 1
- Cenin Renewables 1
- EDF (purchased from Wind Prospect Developments Ltd in 2012) 1
- Fenpower Limited 1
- Gravis Capital Management 1
- Greencoat UK Wind 1
- Greenspan Electric St Fergus Ltd 1
- Grid Battery Storage (GBSL) 1
- INRG Solar 1
- Island Green Power 1
- J.M. Stratton & Co. 1
- John Laing 1
- Kiwi Power 1
- Mr Larry Mark 1
- Mr Stephen Milburn RWE NPower Renewables Mr Stephen MilburnRWE NPower Renewables Mr Stephen MilburnRWE NPower Renewables 1
- Ms Power Projects Ltd 1
- Northumbrian Water 1
- Renesola 1
- Scottish Power: Hydro schemes - Lanark 1
- …
country_long 1
- United Kingdom · 40 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21966 | 21966 | GBR | United Kingdom | AMBLESTON SOLAR PANELS | GBR0001623 | 6.0 | 51.8992 | -4.8665 | Solar | Arqiva Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.98 | 9.05 | 9.04 | 9.0 | 9.23 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22030 | 22030 | GBR | United Kingdom | Ardrossan Extension | GBR0004668 | 6.0 | 55.6439 | -4.8061 | Wind | Airtricity | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1058899 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22073 | 22073 | GBR | United Kingdom | Avonmouth Port | GBR0003194 | 6.0 | 51.5166 | -2.7027 | Wind | Bristol Port Authority | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22103 | 22103 | GBR | United Kingdom | Ballyboley Solar (Carrowdore) | GBR0004724 | 6.0 | 54.5716 | -5.5692 | Solar | Island Green Power | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 9.01 | 8.84 | 9.02 | 8.86 | 8.99 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22262 | 22262 | GBR | United Kingdom | Boundary Lane | GBR0003674 | 6.0 | 54.8478 | -1.9282 | Wind | EDF (purchased from Wind Prospect Developments Ltd in 2012) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1104756 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22270 | 22270 | GBR | United Kingdom | Bowmore | GBR1000412 | 6.0 | 56.1833 | -2.5667 | Oil | Scottish and Southern: Island Generation | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028285 | 3.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22402 | 22402 | GBR | United Kingdom | Carcant Wind Farm | GBR0003214 | 6.0 | 55.7648 | -3.0176 | Wind | Greencoat UK Wind | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1085979 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22509 | 22509 | GBR | United Kingdom | Cleveland Potash | GBR2001154 | 6.0 | 54.5561 | -0.8216 | Storage | Kiwi Power | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
22621 | 22621 | GBR | United Kingdom | Crown Farm | GBR2001090 | 6.0 | 52.6637 | -1.369 | Solar | Suncredit UK (Sunventures 7) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.56 | 8.92 | 9.01 | 8.83 | 9.14 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22665 | 22665 | GBR | United Kingdom | Decoy Farm House Solar Modules | GBR0001987 | 6.0 | 50.8291 | -0.692 | Solar | Ms Power Projects Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.84 | 9.04 | 9.0 | 9.02 | 9.22 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22706 | 22706 | GBR | United Kingdom | Dorking Battery Energy Storage System | GBR2001157 | 6.0 | 51.2304 | -0.3548 | Storage | Grid Battery Storage (GBSL) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
22711 | 22711 | GBR | United Kingdom | Drapers Farm Solar Park | GBR0001658 | 6.0 | 51.8562 | 0.4983 | 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.01 | 9.04 | 8.84 | 8.85 | 8.97 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22985 | 22985 | GBR | United Kingdom | Gowy Landfill Site Cheshire (Extension) | GBR0000659 | 6.0 | 53.2376 | -2.8315 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 5.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22991 | 22991 | GBR | United Kingdom | Grange Farm | GBR0001931 | 6.0 | 50.7131 | -1.26 | Solar | INRG Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1101501|1109211 | 9.0 | 9.39 | 8.94 | 9.08 | 9.46 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
23072 | 23072 | GBR | United Kingdom | Hameldon Hill Extension | GBR0003761 | 6.0 | 53.771 | -2.3062 | Wind | Mr Stephen Milburn RWE NPower Renewables Mr Stephen MilburnRWE NPower Renewables Mr Stephen MilburnRWE NPower Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1060725 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23105 | 23105 | GBR | United Kingdom | Hazlehead | GBR0003937 | 6.0 | 53.5316 | -1.7312 | Wind | Banks Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1086369 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23182 | 23182 | GBR | United Kingdom | Holwell Hill | GBR0002004 | 6.0 | 51.1983 | -2.384 | 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.98 | 8.91 | 8.83 | 8.85 | 9.13 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23203 | 23203 | GBR | United Kingdom | Howdon STW | GBR0002394 | 6.0 | 55.0074 | -1.4319 | Waste | Northumbrian Water | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 5.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23238 | 23238 | GBR | United Kingdom | Inner Sound Phase 1A (MeyGen) | GBR0002436 | 6.0 | 58.7418 | -3.116 | Wave and Tidal | Atlantis Resources | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
23400 | 23400 | GBR | United Kingdom | Land at East Farm - extension | GBR0001915 | 6.0 | 51.1751 | -2.011 | Solar | J.M. Stratton & Co. | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.98 | 8.99 | 8.82 | 8.86 | 9.17 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23520 | 23520 | GBR | United Kingdom | Llynfi Afan Renewable Energy Park | GBR0004644 | 6.0 | 51.6427 | -3.6147 | Wind | John Laing | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23527 | 23527 | GBR | United Kingdom | Loch Gair | GBR0000395 | 6.0 | 56.0696 | -5.3294 | Hydro | Scottish and Southern Energy (SSE) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1028325 | 18.27 | 12.28 | 20.91 | 15.44 | 15.39 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
23535 | 23535 | GBR | United Kingdom | Lochhead | GBR0003453 | 6.0 | 55.6959 | -3.9823 | Wind | A7 Energy / Green Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1066660 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23743 | 23743 | GBR | United Kingdom | Nancrossa Farm solar park | GBR0002126 | 6.0 | 50.1601 | -5.1833 | Solar | Second Solar Project | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1111942 | 9.41 | 9.38 | 9.34 | 9.34 | 9.42 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
23914 | 23914 | GBR | United Kingdom | Pen-Y-Fan A | WKS0072669 | 6.0 | 51.7008 | -3.1691 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 9.03 | 8.84 | 8.98 | 9.0 | 8.99 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
23960 | 23960 | GBR | United Kingdom | Poplars Anaerobic Digestion Facility (Waste AD) | GBR0000249 | 6.0 | 52.6841 | -2.01 | Biomass | Biffa | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
24009 | 24009 | GBR | United Kingdom | Ranson Moor (phase 1) | GBR0002952 | 6.0 | 52.5127 | 0.0314 | Wind | Fenpower Limited | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24037 | 24037 | GBR | United Kingdom | Rhewl Farm | GBR0005053 | 6.0 | 51.634 | -2.7312 | Solar | Renesola | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1113892 | 9.03 | 8.83 | 8.98 | 9.0 | 8.99 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24041 | 24041 | GBR | United Kingdom | Rhyd-y-Pandy Solar Farm | GBR0002354 | 6.0 | 51.6965 | -3.9394 | Solar | Wessex Solar Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 9.01 | 8.81 | 8.84 | 8.86 | 8.98 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24157 | 24157 | GBR | United Kingdom | Seamer Windfarm - Stockton on Tees | GBR0003984 | 6.0 | 54.4942 | -1.2585 | Wind | Broadview Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24245 | 24245 | GBR | United Kingdom | South Kirkby Business Park (Waste AD) | GBR2001007 | 6.0 | 53.6027 | -1.3407 | Biomass | Shanks Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||||
24276 | 24276 | GBR | United Kingdom | Srondoire Community Wind Farm | GBR0004328 | 6.0 | 55.9341 | -5.4805 | Wind | Srondoire Wind Farmers LLP | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1106736 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24280 | 24280 | GBR | United Kingdom | St Fergus Moss Wind Farm | GBR0002741 | 6.0 | 57.572 | -1.9111 | Wind | Greenspan Electric St Fergus Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24310 | 24310 | GBR | United Kingdom | Stonebyres | GBR1000463 | 6.0 | 55.6667 | -3.85 | Hydro | Scottish Power: Hydro schemes - Lanark | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1028381 | 25.14 | 21.21 | 32.5 | 23.11 | 23.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
24342 | 24342 | GBR | United Kingdom | Sutton Courtney | GBR0000595 | 6.0 | 51.6334 | -1.2544 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 5.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24359 | 24359 | GBR | United Kingdom | Tangy Wind Farm Extension/Tangy 2 | GBR0004024 | 6.0 | 55.4786 | -5.5305 | Wind | Scottish and Southern Energy (SSE) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1053650 | 15.12 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24448 | 24448 | GBR | United Kingdom | Tregassow Farm - Solar Modules | GBR0001353 | 6.0 | 50.3069 | -5.0152 | Solar | Mr Larry Mark | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1101088 | 8.97 | 9.36 | 9.5 | 9.36 | 9.54 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24623 | 24623 | GBR | United Kingdom | Whites Landfill Site (Canford) | GBR0000586 | 6.0 | 50.7681 | -1.9588 | Waste | Canford Renewable Energy Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 5.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24629 | 24629 | GBR | United Kingdom | Whitton Mawr | GBR0002093 | 6.0 | 51.4413 | -3.324 | Solar | Cenin Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 8.99 | 8.84 | 8.82 | 8.97 | 8.99 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24661 | 24661 | GBR | United Kingdom | Winscales Moor | GBR0002986 | 6.0 | 54.6423 | -3.4968 | Wind | Gravis Capital Management | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1067261 | 15.12 | 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");