global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where country_long = "United Kingdom" and estimated_generation_gwh_2017 = "7.74"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, source, url, geolocation_source, estimated_generation_gwh_2013, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, 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 4
- Trina Solar 2
- Veolia 2
- BE Renewables 1
- Blackwell Grange Solar Farm Ltd (Conergy) 1
- British Solar Renewables 1
- ENERGY DEVELOPMENTS (UK) LTD 1
- Elgar Middleton 1
- Equitix Fund IV 1
- Foresight Group (TGC Renewables) 1
- Global Renewable Construction 1
- Green Energy UK Direct 1
- Greencoat Capital 1
- INRG 1
- Kingspan 1
- Littlewood Renewables 1
- MES Environmental (CNIM Group) 1
- Mr Martyn Llewelyn 1
- NESF (formerly INRG Solar) 1
- New Energy for the World 1
- OST Energy 1
- PV Sunpower Ltd 1
- Push Energy Ltd PEW Milner HA Milner & PE Milner/ NESF 1
- Stretton Solar 1
- Sun Farming 1
- Sun Farming UK 1
- Suncredit UK/ Vogt solar 1
- Viridor (GMWDA) 1
- Vogt Solar 1
- Zaravolt Development 1
country_long 1
- United Kingdom · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22068 | 22068 | GBR | United Kingdom | Averhill Farm | GBR0005287 | 5.0 | 53.1481 | -1.387 | 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.14 | 7.6 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22077 | 22077 | GBR | United Kingdom | Awre | WKS0068743 | 5.0 | 51.77 | -2.447 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 7.29 | 7.48 | 7.65 | 7.66 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
22132 | 22132 | GBR | United Kingdom | Basin Bridge Farm | GBR0005643 | 5.0 | 52.5614 | -1.4184 | Solar | Sun Farming UK | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.22 | 7.47 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22137 | 22137 | GBR | United Kingdom | Battlefield EfW | GBR0000910 | 8.0 | 52.7426 | -2.7272 | Waste | Veolia | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1102895 | 7.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22222 | 22222 | GBR | United Kingdom | Blackwell Grange Solar Farm | GBR0001968 | 5.0 | 52.0879 | -1.6673 | Solar | Blackwell Grange Solar Farm Ltd (Conergy) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1113394 | 7.25 | 7.48 | 7.65 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
22248 | 22248 | GBR | United Kingdom | Bolsovermoor Quarry | GBR0005404 | 4.9979 | 53.2398 | -1.2544 | 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.14 | 7.6 | 7.64 | 7.63 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22249 | 22249 | GBR | United Kingdom | Bolton EfW | GBR0000898 | 8.0 | 53.567 | -2.4076 | Waste | Viridor (GMWDA) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1048249 | 7.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22477 | 22477 | GBR | United Kingdom | Cherry Tree Farm | GBR0002184 | 5.0 | 53.2373 | -1.3425 | Solar | Trina Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1114846 | 7.14 | 7.6 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
22482 | 22482 | GBR | United Kingdom | Chineham ERF | GBR0000834 | 8.0 | 51.292 | -1.0377 | Waste | Veolia | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1058086 | 7.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22555 | 22555 | GBR | United Kingdom | Cooper House Farm | GBR0005321 | 5.0 | 53.7664 | -2.8762 | Solar | Suncredit UK/ Vogt solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.25 | 7.55 | 7.64 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22618 | 22618 | GBR | United Kingdom | Crossways Solar Park | GBR0001567 | 4.997 | 50.7 | -2.3243 | Solar | Vogt Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1096728 | 7.6 | 7.85 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
22683 | 22683 | GBR | United Kingdom | Desford Solar Farm | GBR0001885 | 5.0 | 52.64 | -1.2586 | Solar | Trina Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.22 | 7.47 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22769 | 22769 | GBR | United Kingdom | Ebnal Lodge (resubmission) | GBR0005834 | 5.0 | 52.9001 | -3.0152 | Solar | Greencoat Capital | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.12 | 7.65 | 7.5 | 7.55 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
22855 | 22855 | GBR | United Kingdom | Ffos Las | GBR0001161 | 4.9968 | 51.725 | -4.2386 | Solar | Mr Martyn Llewelyn | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1096713 | 7.48 | 7.58 | 7.47 | 7.48 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
22868 | 22868 | GBR | United Kingdom | Flixborough Industrial Estate | GBR0005204 | 5.0 | 53.6201 | -0.6947 | Solar | NESF (formerly INRG Solar) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.22 | 7.47 | 7.5 | 7.52 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23049 | 23049 | GBR | United Kingdom | Gypsom Solar Farm | GBR0001811 | 5.0 | 52.7397 | -1.1161 | Solar | BE Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.22 | 7.47 | 7.63 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23067 | 23067 | GBR | United Kingdom | Hall Farm Solar Farm (Newbold Verdon) | GBR0001991 | 5.0 | 52.6303 | -1.3482 | Solar | Push Energy Ltd PEW Milner HA Milner & PE Milner/ NESF | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1108931 | 7.26 | 7.47 | 7.63 | 7.52 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
23336 | 23336 | GBR | United Kingdom | Lains Farm | GBR0001840 | 5.0 | 51.1987 | -1.6116 | Solar | INRG | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.6 | 7.57 | 7.46 | 7.5 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23353 | 23353 | GBR | United Kingdom | Land At Debdale Lane | GBR0005401 | 5.0 | 53.1602 | -1.2161 | Solar | Equitix Fund IV | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.14 | 7.6 | 7.64 | 7.66 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23369 | 23369 | GBR | United Kingdom | Land North of the Wood at Averill Farm | GBR0005554 | 5.0 | 53.1469 | -1.3955 | Solar | Stretton Solar | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.14 | 7.6 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23373 | 23373 | GBR | United Kingdom | Land Opposite Tyn Y Pistyll | GBR0005026 | 5.0 | 52.9874 | -3.0704 | 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.12 | 7.63 | 7.5 | 7.55 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23410 | 23410 | GBR | United Kingdom | Land at Meadow Farm | GBR0005385 | 5.0 | 52.5173 | -0.9199 | Solar | Lightsource Renewable Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1113780 | 7.25 | 7.48 | 7.64 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
23414 | 23414 | GBR | United Kingdom | Land at Oldstone Farm | GBR0005588 | 5.0 | 50.3515 | -3.6621 | Solar | British Solar Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.6 | 7.62 | 7.55 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23491 | 23491 | GBR | United Kingdom | Lindridge Farm | GBR0004996 | 5.0 | 52.6427 | -1.3116 | Solar | Sun Farming | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.26 | 7.47 | 7.63 | 7.58 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23507 | 23507 | GBR | United Kingdom | Littlewood Lane Solar | GBR0005687 | 5.0 | 53.1812 | -1.2038 | Solar | Littlewood Renewables | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.14 | 7.6 | 7.64 | 7.66 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23578 | 23578 | GBR | United Kingdom | Lower Venn Farm | GBR0005686 | 5.0 | 52.1386 | -2.6694 | Solar | New Energy for the World | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.22 | 7.57 | 7.63 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23874 | 23874 | GBR | United Kingdom | Padleywood Farm | GBR0005165 | 5.0 | 53.1481 | -1.387 | Solar | OST Energy | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.14 | 7.6 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
23931 | 23931 | GBR | United Kingdom | Peterlee Solar Farm | GBR0005694 | 5.0 | 54.7752 | -1.3655 | Solar | Zaravolt Development | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 1113312 | 7.22 | 7.6 | 7.53 | 7.66 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
24179 | 24179 | GBR | United Kingdom | Shelford Generation Plant II | GBR0000583 | 8.0 | 51.2994 | 1.0999 | Waste | ENERGY DEVELOPMENTS (UK) LTD | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24183 | 24183 | GBR | United Kingdom | Sherburn | GBR0006485 | 5.0 | 54.1793 | -0.525 | Solar | Kingspan | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.25 | 7.55 | 7.47 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24234 | 24234 | GBR | United Kingdom | Solar Farm at Fields Farm (Phase 1) | GBR0005244 | 5.0 | 52.2449 | -1.4102 | Solar | Foresight Group (TGC Renewables) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.25 | 7.48 | 7.63 | 7.65 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24312 | 24312 | GBR | United Kingdom | Stoneshill Farm (resubmission) | GBR0004794 | 5.0 | 50.8783 | -3.3846 | Solar | Green Energy UK Direct | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.49 | 7.57 | 7.46 | 7.48 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24436 | 24436 | GBR | United Kingdom | Tower Hayes Farm | GBR0005168 | 5.0 | 52.6852 | -1.3175 | Solar | Elgar Middleton | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.26 | 7.55 | 7.63 | 7.48 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24488 | 24488 | GBR | United Kingdom | Twin Yards Solar Farm | GBR0005415 | 5.0 | 53.1188 | -1.3214 | Solar | Global Renewable Construction | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.14 | 7.6 | 7.64 | 7.64 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24568 | 24568 | GBR | United Kingdom | West Ditchen Farm (resubmission) | GBR0002102 | 5.0 | 50.7238 | -4.4054 | Solar | PV Sunpower Ltd | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.62 | 7.62 | 7.55 | 7.66 | 7.74 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
24678 | 24678 | GBR | United Kingdom | Wolverhampton EfW | GBR0000814 | 8.0 | 52.5969 | -2.125 | Waste | MES Environmental (CNIM Group) | UK Renewable Energy Planning Database | https://www.gov.uk/government/collections/renewable-energy-planning-data | UK Renewable Energy Planning Database | 7.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");