global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
44 rows where country_long = "United Kingdom", estimated_generation_note_2017 = "CAPACITY-FACTOR-V1", primary_fuel = "Gas" and url = "https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes"
This data as json, CSV (advanced)
Suggested facets: geolocation_source, wepp_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21977 | 21977 | GBR | United Kingdom | Aberthaw GT | GBR1000375 | 51.0 | 51.3875 | -3.4068 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 236.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22089 | 22089 | GBR | United Kingdom | Baglan Bay CCGT | GBR1000312 | 520.0 | 51.6145 | -3.8352 | Gas | MPF Operations Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 2412.83 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22090 | 22090 | GBR | United Kingdom | Baglan Bay OCGT | GBR1000314 | 32.3 | 51.5924 | -3.7802 | Gas | MPF Operations Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 149.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22105 | 22105 | GBR | United Kingdom | Ballylumford B | GBR1000003 | 540.0 | 54.845 | -5.787 | Gas | AES | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1011302 | 210.957 | 176.789 | JRC-PPDB-OPEN | 2505.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||
22106 | 22106 | GBR | United Kingdom | Ballylumford B OCGT | GBR1000004 | 116.0 | 54.845 | -5.787 | Gas | AES | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1011302 | 808.166 | JRC-PPDB-OPEN | 538.24 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
22107 | 22107 | GBR | United Kingdom | Ballylumford C | GBR1000001 | 616.0 | 54.8428 | -5.7853 | Gas | AES | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1011302 | 2858.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22218 | 22218 | GBR | United Kingdom | Blackburn | GBR1000464 | 59.0 | 53.75 | -2.4833 | Gas | Scottish Power: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1048233 | 273.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22434 | 22434 | GBR | United Kingdom | Castleford | GBR1000113 | 56.0 | 53.7259 | -1.3626 | Gas | E.On UK | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1038549 | 259.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22484 | 22484 | GBR | United Kingdom | Chippenham | GBR1000440 | 10.0 | 51.46 | -2.1247 | Gas | Scottish and Southern: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1053649 | 46.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22547 | 22547 | GBR | United Kingdom | Connahs Quay | GBR1000492 | 1380.0 | 53.2317 | -3.0815 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1025709 | 6403.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22551 | 22551 | GBR | United Kingdom | Coolkeeragh | GBR1000075 | 408.0 | 55.0437 | -7.2487 | Gas | Coolkeeragh ESB Ltd | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1013277 | 4.505 | JRC-PPDB-OPEN | 1893.14 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
22552 | 22552 | GBR | United Kingdom | Coolkeeragh OCGT | GBR1000076 | 53.0 | 55.0437 | -7.2487 | Gas | Coolkeeragh ESB Ltd | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1263.904 | 1199.935 | JRC-PPDB-OPEN | 245.92 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||
22557 | 22557 | GBR | United Kingdom | Corby | GBR1000077 | 401.0 | 52.5104 | -0.6814 | Gas | Corby Power Ltd | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1013306 | 1860.66 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22565 | 22565 | GBR | United Kingdom | Coryton | GBR1000211 | 800.0 | 51.5119 | 0.5079 | Gas | Intergen | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1013356|1022996 | 3712.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22571 | 22571 | GBR | United Kingdom | Cottam Development Centre | GBR1000493 | 395.0 | 53.3051 | -0.7858 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1064726 | 1832.82 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22581 | 22581 | GBR | United Kingdom | Cowes | GBR1000376 | 140.0 | 50.7469 | -1.2862 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1023587 | 649.6 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22652 | 22652 | GBR | United Kingdom | Damhead Creek | GBR1000465 | 805.0 | 51.4249 | 0.6014 | Gas | Scottish Power: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1038550 | 3735.24 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22688 | 22688 | GBR | United Kingdom | Didcot B | GBR1000369 | 1470.0 | 51.6246 | -1.2683 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1023591 | 6820.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22689 | 22689 | GBR | United Kingdom | Didcot GT | GBR1000377 | 100.0 | 51.6246 | -1.2683 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 464.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22713 | 22713 | GBR | United Kingdom | Drax GT | GBR1000112 | 75.0 | 53.7364 | -0.9981 | Gas | Drax Power Ltd | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 348.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
22800 | 22800 | GBR | United Kingdom | Enfield | GBR1000494 | 408.0 | 51.6625 | -0.0225 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1019434 | 1893.14 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
22987 | 22987 | GBR | United Kingdom | Grain GT | GBR1000497 | 56.0 | 51.4444 | 0.7114 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1025719 | 259.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23015 | 23015 | GBR | United Kingdom | Great Yarmouth | GBR1000370 | 420.0 | 52.5839 | 1.7338 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1010122 | 1948.82 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23268 | 23268 | GBR | United Kingdom | Keadby GT | GBR1000443 | 25.0 | 53.5944 | -0.7504 | Gas | Scottish and Southern: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 116.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23293 | 23293 | GBR | United Kingdom | Killingholme | GBR1000500 | 600.0 | 53.6535 | -0.2556 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 2784.03 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23298 | 23298 | GBR | United Kingdom | Kilroot OCGT | GBR1000005 | 142.0 | 54.7251 | -5.7643 | Gas | AES | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1023937 | 658.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23445 | 23445 | GBR | United Kingdom | Langage | GBR1000073 | 905.0 | 50.3882 | -4.0118 | Gas | Centrica | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1050394 | 4199.25 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23494 | 23494 | GBR | United Kingdom | Little Barford | GBR1000371 | 720.0 | 52.2046 | -0.2693 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1023602 | 3340.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23495 | 23495 | GBR | United Kingdom | Little Barford GT | GBR1000378 | 17.0 | 52.2046 | -0.2693 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 78.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
23624 | 23624 | GBR | United Kingdom | Marchwood | GBR1000311 | 842.0 | 50.8998 | -1.4384 | Gas | Marchwood Power Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1052944 | 3906.92 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23653 | 23653 | GBR | United Kingdom | Medway | GBR1000437 | 700.0 | 51.4396 | 0.6894 | Gas | Scottish and Southern: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1022461 | 3248.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
23908 | 23908 | GBR | United Kingdom | Pembroke | GBR1000372 | 2180.0 | 51.685 | -4.99 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1023612 | 10115.32 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24012 | 24012 | GBR | United Kingdom | Ratcliffe GT | GBR1000498 | 34.0 | 52.8653 | -1.255 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 157.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24064 | 24064 | GBR | United Kingdom | Rocksavage | GBR1000212 | 810.0 | 53.3147 | -2.7232 | Gas | Intergen | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1019722 | 3758.44 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24106 | 24106 | GBR | United Kingdom | Rye House | GBR1000466 | 715.0 | 51.7626 | 0.0094 | Gas | Scottish Power: Thermal | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1025737 | 3317.64 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24128 | 24128 | GBR | United Kingdom | Sandbach | GBR1000114 | 56.0 | 53.1623 | -2.4037 | Gas | E.On UK | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1038548 | 259.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24153 | 24153 | GBR | United Kingdom | Seabank 2 | GBR1000480 | 410.0 | 51.5392 | -2.67 | Gas | Seabank Power Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1028387 | 1902.42 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24165 | 24165 | GBR | United Kingdom | Severn Power | GBR1000313 | 850.0 | 51.5475 | -2.975 | Gas | MPF Operations Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1063557 | 3944.04 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24244 | 24244 | GBR | United Kingdom | South Humber Bank | GBR1000074 | 1310.0 | 53.6008 | -0.1446 | Gas | Centrica | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1018950 | 6078.47 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24301 | 24301 | GBR | United Kingdom | Staythorpe C | GBR1000373 | 1772.0 | 53.073 | -0.8585 | Gas | RWE Npower Plc | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 1064569 | 8222.18 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24366 | 24366 | GBR | United Kingdom | Taylor's Lane GT | GBR1000499 | 144.0 | 51.5459 | -0.2575 | Gas | Uniper UK Limited | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 668.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24404 | 24404 | GBR | United Kingdom | Thornhill | GBR1000115 | 50.0 | 53.6908 | -1.6291 | Gas | E.On UK | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | CARMA | 1033670 | 232.0 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
24565 | 24565 | GBR | United Kingdom | West Burton CCGT | GBR1000141 | 1332.0 | 53.3631 | -0.7976 | Gas | EDF Energy | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 6180.55 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
24566 | 24566 | GBR | United Kingdom | West Burton GT | GBR1000146 | 40.0 | 53.3631 | -0.7976 | Gas | EDF Energy | Department for Business Energy & Industrial Strategy | https://www.gov.uk/government/collections/digest-of-uk-energy-statistics-dukes | GEODB | 185.6 | 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");