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 = "1.8" and country_long = "United Kingdom"
This data as json, CSV (advanced)
Suggested facets: 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
- Waste Recycling Group 3
- Biogeneration / Biffa 2
- Ecotricity 2
- Lightsource Renewable Energy 2
- Agri-Gen/Downing 1
- Anesco 1
- Ayre Energy/Aquatera Ltd 1
- Border Wind Farms Ltd /AMEC 1
- Brilliant Harvest Installations 1
- Bristol City Council 1
- Colin Risbridger 1
- Combined Landfill Projects (CLP) 1
- DEVON WASTE MANAGEMENT LTD 1
- Good Energy Generation 1
- Haul Waste Limited 1
- Heathrow Airport 1
- Innogy (previously BELECTRIC Solar) 1
- KL Technologies 1
- KWTN Solar 1
- Kingspan 1
- Larimin 1
- Lark Energy 1
- Lowther Farms 1
- Mackies Of Scotland Ltd 1
- Mercer Farming 1
- Mr Nick Boyle 1
- National Energy Laboratories (NEL) 1
- Organic Recycling 1
- Orta Solar Ltd 1
- REG Windpower 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22026 | 22026 | GBR | United Kingdom | Ardley Fields Farm Landfill Site | GBR0000587 | 1.8 | 51.9433 | -1.2086 | Waste | Haul Waste Limited | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1041726 | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22123 | 22123 | GBR | United Kingdom | Barns of Ayre Wind Turbines (2) | GBR0003902 | 1.8 | 58.9217 | -2.7156 | Wind | Ayre Energy/Aquatera Ltd | 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 | ||||||||||||||||||
22177 | 22177 | GBR | United Kingdom | Bentwaters Park (extension) | GBR0004970 | 1.8 | 52.1253 | 1.4428 | Biomass | Agri-Gen/Downing | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1099966 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
22225 | 22225 | GBR | United Kingdom | Blakenhall Park Solar Farm | GBR0005148 | 1.8 | 52.7604 | -1.7443 | Solar | Mercer Farming | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.35 | 2.48 | 2.46 | 2.46 | 2.47 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22352 | 22352 | GBR | United Kingdom | Burntstump Landfill Scheme | GBR0000532 | 1.8 | 53.0441 | -1.1289 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22372 | 22372 | GBR | United Kingdom | CRAYSMARSH SOLAR FARM | GBR0001619 | 1.8 | 51.3626 | -2.0947 | Solar | Mr Nick Boyle | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.5 | 2.48 | 2.47 | 2.48 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22468 | 22468 | GBR | United Kingdom | Chelson Meadow Gas to Energy Scheme | GBR0000610 | 1.8 | 50.3709 | -4.1161 | Waste | DEVON WASTE MANAGEMENT LTD | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22595 | 22595 | GBR | United Kingdom | Creathorne Farm - Solar Farm | GBR0001614 | 1.8 | 50.7956 | -4.5451 | Solar | Good Energy Generation | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1105899 | 2.51 | 2.45 | 2.49 | 2.49 | 2.5 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
22664 | 22664 | GBR | United Kingdom | Decoy Farm (Farm AD) | GBR0000367 | 1.8 | 52.6969 | -0.1371 | Biomass | Organic Recycling | 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 | |||||||||||||||||||
22697 | 22697 | GBR | United Kingdom | Distington Landfill | GBR0000568 | 1.8 | 54.6044 | -3.5109 | Waste | THOMAS GRAVESON LTD | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22778 | 22778 | GBR | United Kingdom | Edwin Richards Landfill Scheme | GBR0000556 | 1.8 | 52.4899 | -2.0603 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1058916 | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22792 | 22792 | GBR | United Kingdom | Elstow Landfill Site | GBR0000511 | 1.8 | 52.1033 | -0.4713 | Waste | Renewable Power Generation Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1034155 | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22869 | 22869 | GBR | United Kingdom | Flotta | GBR0004678 | 1.8 | 58.8412 | -3.0973 | Wind | Scotwind (Scottish Renewables) | 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 | ||||||||||||||||||
22910 | 22910 | GBR | United Kingdom | Gallowhill | GBR0003693 | 1.8 | 59.2766 | -2.9822 | Wind | Colin Risbridger | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1103434 | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23109 | 23109 | GBR | United Kingdom | Heathrow Airport Biomass CHP | GBR0000129 | 1.8 | 51.4592 | -0.4595 | Biomass | Heathrow Airport | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1070254 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
23286 | 23286 | GBR | United Kingdom | Kia Ora Farm | GBR0001441 | 1.8 | 50.8545 | -3.4082 | 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.48 | 2.5 | 2.47 | 2.47 | 2.52 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23309 | 23309 | GBR | United Kingdom | Kingspan | GBR2001079 | 1.8 | 53.2897 | -3.2008 | Wind | Kingspan | 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 | ||||||||||||||||||
23316 | 23316 | GBR | United Kingdom | Kirkheaton | GBR0002587 | 1.8 | 55.0865 | -1.989 | Wind | Border Wind Farms Ltd /AMEC | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1053093 | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23579 | 23579 | GBR | United Kingdom | Lowther Farms | GBR0001500 | 1.8 | 52.3599 | -1.0243 | Solar | Lowther Farms | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.37 | 2.48 | 2.47 | 2.48 | 2.47 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23595 | 23595 | GBR | United Kingdom | Mackies Dairy PV | GBR0001501 | 1.8 | 57.3779 | -2.3891 | Solar | Mackies Of Scotland Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.27 | 2.37 | 2.33 | 2.35 | 2.39 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23610 | 23610 | GBR | United Kingdom | Manor Farm (Castle Cary) | GBR0002242 | 1.8 | 51.0806 | -2.5102 | Solar | Brilliant Harvest Installations | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.48 | 2.52 | 2.48 | 2.48 | 2.51 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23640 | 23640 | GBR | United Kingdom | Marshwood Farm | GBR0004752 | 1.8 | 50.8394 | -2.937 | Solar | KWTN Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.47 | 2.49 | 2.51 | 2.47 | 2.52 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23706 | 23706 | GBR | United Kingdom | Moorhouse Lane - resubmission | GBR0002040 | 1.8 | 51.5149 | -2.6576 | Solar | Orta Solar Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1107767 | 2.5 | 2.48 | 2.47 | 2.48 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
23737 | 23737 | GBR | United Kingdom | Myres Hill | GBR0003090 | 1.8 | 55.6919 | -4.279 | Wind | National Energy Laboratories (NEL) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1053092 | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23841 | 23841 | GBR | United Kingdom | Ongar Landfill Scheme 2 | GBR0000512 | 1.8 | 51.6977 | 0.2588 | Waste | Waste Recycling Group | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23889 | 23889 | GBR | United Kingdom | ParkerSteel Shoreham Plant | GBR0006055 | 1.8 | 50.8281 | -0.2152 | Solar | Larimin | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.48 | 2.48 | 2.49 | 2.49 | 2.49 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23899 | 23899 | GBR | United Kingdom | Patteson Court Landfill Site | GBR0000724 | 1.8 | 51.2435 | -0.149 | Waste | Biogeneration / Biffa | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23967 | 23967 | GBR | United Kingdom | Portley Ford Landfill Site | GBR0000528 | 1.8 | 52.3871 | -1.0331 | Waste | Biogeneration / Biffa | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1011121 | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23969 | 23969 | GBR | United Kingdom | Porvair International Ltd | GBR0001340 | 1.8 | 52.77 | 0.3876 | Solar | KL Technologies | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.5 | 2.48 | 2.47 | 2.48 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23991 | 23991 | GBR | United Kingdom | Queen's Park Road Energy | GBR0000731 | 1.8 | 53.797 | -2.2278 | Waste | Combined Landfill Projects (CLP) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24006 | 24006 | GBR | United Kingdom | Ramsey | GBR0003155 | 1.8 | 52.4469 | -0.1063 | Wind | REG Windpower | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1044938 | 4.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24069 | 24069 | GBR | United Kingdom | Rolls Royce Filton Campus Building 185 | GBR0006043 | 1.8 | 51.5246 | -2.5713 | Solar | Innogy (previously BELECTRIC Solar) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.47 | 2.48 | 2.47 | 2.48 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24166 | 24166 | GBR | United Kingdom | Severn Road Solar Park | GBR0004899 | 1.8 | 51.5325 | -2.6689 | Solar | Bristol City Council | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.5 | 2.48 | 2.47 | 2.48 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24218 | 24218 | GBR | United Kingdom | Slaughtergate Farm | GBR0001439 | 1.8 | 51.0459 | -2.3119 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1096700 | 2.47 | 2.5 | 2.47 | 2.49 | 2.51 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
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 | ||||||||||||||||||
24396 | 24396 | GBR | United Kingdom | The Stables | GBR0001510 | 1.8 | 52.5766 | -1.4068 | Solar | Anesco | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.37 | 2.47 | 2.48 | 2.45 | 2.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24528 | 24528 | GBR | United Kingdom | Walnut Yard (Phase 1) | GBR0002084 | 1.8 | 52.7997 | -1.3642 | Solar | Lark Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.36 | 2.48 | 2.5 | 2.5 | 2.47 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24531 | 24531 | GBR | United Kingdom | Waltham Point Distribution Centre | GBR0006114 | 1.8 | 51.6794 | -0.0088 | Solar | Sainsbury's | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 2.48 | 2.52 | 2.48 | 2.49 | 2.47 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24613 | 24613 | GBR | United Kingdom | Whinney Hill II Energy | GBR0000574 | 1.8 | 53.7703 | -2.3656 | Waste | SITA UK | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1.74 | 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");