global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
44 rows where commissioning_year = "2004.0", country_long = "China" and primary_fuel = "Coal"
This data as json, CSV (advanced)
Suggested facets: source, url, geolocation_source
owner >30
- China Power Investment Corporation (CPI) 3
- China Resources Power Holdings Co Ltd 3
- Datang Gansu Power Generation Co Ltd 3
- China Guodian Group Corporation 2
- Guangdong Electric Power Development Co Ltd 2
- Huadian Power International Company Limited 2
- Asia Pulp & Paper China 1
- CPI Northeast Power Co Ltd 1
- China Huadian Group Corporation 1
- China Huaneng Group Corporation (CHNG) 1
- Datang Guizhou Power Generation Corporation 1
- Datang Hunan Huayin Electric Power 1
- Dongguan Dongtang Industry Co 1
- Emeishan Aluminum (Group) Co 1
- Formosa Kunshan Cogen Co 1
- GD Power Development Co Ltd 1
- Haimen Xinyuan Environmental Thermal Power Co Ltd 1
- Henan Investment Group Co Ltd 1
- Huaneng Shandong Power Co Ltd 1
- Huayu Aluminum Co 1
- Jiangmen Xinhui Renke Power Co Ltd 1
- Jiangsu Shagang - Zhangjiagang Works 1
- Jisco 1 Power Station 1
- Luoyang Longyu Group 1
- Rudong GCL Thermal Power Co Ltd 1
- SDIC Huajing Power Holdings Ltd Electric Power Co Ltd 1
- Shaanxi Huadian Pucheng Co Ltd 1
- Shaanxi Yinhe Yulin Power Generation 1
- Shanghai Electric Group Company Limited 1
- Shanxi Datang International Power Generation Co Ltd 1
- …
primary_fuel 1
- Coal · 44 ✖
country_long 1
- China · 44 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5219 | 5219 | CHN | China | Beihai Bebuwan power station | WRI1070616 | 640.0 | 21.5821 | 109.581 | Coal | 2004.0 | SDIC Huajing Power Holdings Ltd Electric Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1062675 | 3118.52 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5413 | 5413 | CHN | China | Chongqing Baihe power station | WRI1070692 | 600.0 | 31.2691 | 108.4561 | Coal | 2004.0 | China Power Investment Corporation (CPI) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1058771 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5538 | 5538 | CHN | China | Datang Liancheng-2 power station | WRI1070360 | 600.0 | 36.5195 | 102.8682 | Coal | 2004.0 | Datang Gansu Power Generation Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1059414 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5572 | 5572 | CHN | China | Datang Xigu power station | WRI1070366 | 990.0 | 36.1289 | 103.6228 | Coal | 2004.0 | Datang Gansu Power Generation Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1024485 | 4823.96 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5688 | 5688 | CHN | China | Dongtang Plant power station | WRI1075597 | 285.0 | 23.08 | 113.6292 | Coal | 2004.0 | Dongguan Dongtang Industry Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1388.71 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5716 | 5716 | CHN | China | Erdaojiang power station | WRI1070364 | 600.0 | 41.7797 | 126.0148 | Coal | 2004.0 | China Power Investment Corporation (CPI) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1052745 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5846 | 5846 | CHN | China | Fushun CPI power station | WRI1070266 | 600.0 | 41.8897 | 123.9342 | Coal | 2004.0 | CPI Northeast Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1065822 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6026 | 6026 | CHN | China | Guangan power station | WRI1070064 | 2400.0 | 30.5288 | 106.8256 | Coal | 2004.0 | China Huadian Group Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1044616 | 11694.45 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6100 | 6100 | CHN | China | Guixi power station | WRI1070093 | 1880.0 | 28.2891 | 117.2231 | Coal | 2004.0 | China Power Investment Corporation (CPI) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1049242 | 9160.65 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6163 | 6163 | CHN | China | Guodian Shizuishan-2 power station | WRI1070807 | 2020.0 | 39.2848 | 106.788 | Coal | 2004.0 | GD Power Development Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1059294 | 9842.83 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6174 | 6174 | CHN | China | Guodian Yongfu power station | WRI1070776 | 600.0 | 25.1013 | 110.069 | Coal | 2004.0 | China Guodian Group Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1069921 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6485 | 6485 | CHN | China | Huadian Harbin-1 power station | WRI1070241 | 950.0 | 45.7099 | 126.6955 | Coal | 2004.0 | Huadian Power International Company Limited | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1058783 | 4629.05 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6523 | 6523 | CHN | China | Huadian Wangting power station | WRI1070283 | 1920.0 | 31.4444 | 120.4364 | Coal | 2004.0 | Huadian Power International Company Limited | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 9355.56 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6648 | 6648 | CHN | China | Huaneng Taicang power station | WRI1070273 | 1900.0 | 31.6566 | 121.1799 | Coal | 2004.0 | China Huaneng Group Corporation (CHNG) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1028434 | 9258.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6951 | 6951 | CHN | China | Jiangsu Zhenjiang power station | WRI1070548 | 1820.0 | 32.1852 | 119.2709 | Coal | 2004.0 | China Resources Power Holdings Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1055234 | 8868.29 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7012 | 7012 | CHN | China | Jiayuguan - Datang Coal | WRI1070605 | 1200.0 | 39.7951 | 98.3084 | Coal | 2004.0 | Datang Gansu Power Generation Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33388-jiayuguan-datang-coal-power-plant | Industry About | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7138 | 7138 | CHN | China | Jinhai Mill power station | WRI1075658 | 300.0 | 19.7726 | 109.1841 | Coal | 2004.0 | Asia Pulp & Paper China | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1461.8 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7175 | 7175 | CHN | China | Jisco-1 power station | WRI1070606 | 850.0 | 39.7938 | 98.3089 | Coal | 2004.0 | Jisco 1 Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 4141.78 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7383 | 7383 | CHN | China | Linyi Huasheng power station | WRI1075669 | 405.0 | 34.957 | 118.3057 | Coal | 2004.0 | Huayu Aluminum Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1973.43 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7477 | 7477 | CHN | China | Luoding power station | WRI1070026 | 270.0 | 22.8043 | 111.6189 | Coal | 2004.0 | Guangdong Electric Power Development Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1073063 | 1315.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7486 | 7486 | CHN | China | Luoyang Longyu Hongguang Power Station | WRI1075676 | 165.0 | 34.549 | 112.1958 | Coal | 2004.0 | Luoyang Longyu Group | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 803.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7488 | 7488 | CHN | China | Luoyang Shoulong power station | WRI1070442 | 110.0 | 34.7425 | 112.7729 | Coal | 2004.0 | China Resources Power Holdings Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1059306 | 535.99 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7593 | 7593 | CHN | China | Nanya Cogen power station | WRI1075686 | 148.0 | 31.333 | 120.9784 | Coal | 2004.0 | Formosa Kunshan Cogen Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 721.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7594 | 7594 | CHN | China | Nanyang Yahekou power station | WRI1070073 | 1900.0 | 33.3082 | 112.6451 | Coal | 2004.0 | Henan Investment Group Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1011864 | 9258.11 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7596 | 7596 | CHN | China | Nayong-1 power station | WRI1070099 | 1200.0 | 26.6527 | 105.1822 | Coal | 2004.0 | Datang Guizhou Power Generation Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1055567 | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7740 | 7740 | CHN | China | Pucheng power station | WRI1070668 | 2580.0 | 34.9783 | 109.8 | Coal | 2004.0 | Shaanxi Huadian Pucheng Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1024478 | 12571.54 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7881 | 7881 | CHN | China | Rudong Coal | WRI1070391 | 45.0 | 32.3069 | 121.1443 | Coal | 2004.0 | Rudong GCL Thermal Power Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33023-rudong-coal-power-plant | Industry About | 219.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8112 | 8112 | CHN | China | Shengli Dongying power station | WRI1070314 | 1700.0 | 37.4013 | 118.5243 | Coal | 2004.0 | Shengli Petrolium Administration | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1028542 | 8283.57 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8227 | 8227 | CHN | China | Sichuan Emeishan power station | WRI1075728 | 270.0 | 29.4815 | 103.5875 | Coal | 2004.0 | Emeishan Aluminum (Group) Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1315.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8364 | 8364 | CHN | China | Suzhou Dongwu Cogen power station | WRI1070389 | 50.0 | 31.2551 | 120.7633 | Coal | 2004.0 | Suzhou Dongwu Cogeneration Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 243.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8395 | 8395 | CHN | China | Taicanggang power station | WRI1070627 | 1300.0 | 31.5877 | 121.2566 | Coal | 2004.0 | Taicang GCL Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1074888 | 6334.49 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8582 | 8582 | CHN | China | Waigaoqiao power station | WRI1070165 | 5240.0 | 31.3536 | 121.6003 | Coal | 2004.0 | Shanghai Electric Group Company Limited | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1028560 | 25532.89 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8716 | 8716 | CHN | China | Xiangtan power station | WRI1070321 | 1800.0 | 27.8287 | 112.9961 | Coal | 2004.0 | Datang Hunan Huayin Electric Power | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1018965 | 8770.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8780 | 8780 | CHN | China | Xinhui Shuangshui power station-2 | WRI1070086 | 300.0 | 22.446 | 113.0 | Coal | 2004.0 | Jiangmen Xinhui Renke Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1055572 | 1461.8 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8831 | 8831 | CHN | China | Xinyuan Coal | WRI1070005 | 30.0 | 31.893 | 121.2093 | Coal | 2004.0 | Haimen Xinyuan Environmental Thermal Power Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33042-xinyuan-coal-power-plant | Industry About | 1062213 | 146.18 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8878 | 8878 | CHN | China | Yangcheng power station | WRI1070345 | 3300.0 | 35.467 | 112.5739 | Coal | 2004.0 | Shanxi Datang International Power Generation Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1033605 | 16079.87 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8914 | 8914 | CHN | China | Yangzonghai power station | WRI1070456 | 1000.0 | 24.9622 | 103.0277 | Coal | 2004.0 | China Guodian Group Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1044001 | 4872.69 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8978 | 8978 | CHN | China | Yixing Cogen power station | WRI1070230 | 120.0 | 31.3701 | 119.7727 | Coal | 2004.0 | China Resources Power Holdings Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1062423 | 584.72 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9040 | 9040 | CHN | China | Yulin Shanghe power station | WRI1070495 | 280.0 | 38.4284 | 109.7414 | Coal | 2004.0 | Shaanxi Yinhe Yulin Power Generation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1077087 | 1364.35 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9052 | 9052 | CHN | China | Yunfu power station | WRI1070297 | 1120.0 | 22.9838 | 112.1005 | Coal | 2004.0 | Guangdong Electric Power Development Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | Industry About | 1029586 | 5457.41 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9054 | 9054 | CHN | China | Yunhe power station | WRI1070287 | 1240.0 | 35.4867 | 116.4769 | Coal | 2004.0 | Huaneng Shandong Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1055235 | 6042.13 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9188 | 9188 | CHN | China | Zhangjiagang Shagang power station | WRI1070023 | 200.0 | 31.9789 | 120.6334 | Coal | 2004.0 | Jiangsu Shagang - Zhangjiagang Works | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1061482 | 974.53 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9229 | 9229 | CHN | China | Zheneng Changxing power station | WRI1070510 | 1200.0 | 30.9919 | 119.9293 | Coal | 2004.0 | Zhejiang Zheneng Electric Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1098364 | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9305 | 9305 | CHN | China | Zibo Hongda power station | WRI1075796 | 140.0 | 36.7833 | 118.05 | Coal | 2004.0 | Zibo Hongda Thermal Power | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 682.17 | 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");