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 = "2013.0" and country_long = "China"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, source, url, geolocation_source, wepp_id, 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
- Hebei Construction Energy Investment Co Ltd 2
- Shenhua Guoneng Energy Group 2
- Anhui Bengbu Power Station 1
- Beijing Jingxi Gas-fired Thermal Power Co Ltd 1
- Beijing Sanjili Energy Co Ltd 1
- China Guodian Corp 1
- China Guodian Group Corporation 1
- China Huadian Group Corporation 1
- China Huaneng Group Corporation (CHNG) 1
- China Resources Power Holdings Co Ltd 1
- Chiping Xinyuan Aluminum Co Ltd 1
- Chongqing Qineng Elec & Alumn 1
- Datang 803 Power Plant 1
- Datang International Power Generation 1
- Datang Xinjiang Power Generation Co Ltd 1
- Gepic Jinchang Power Co Ltd 1
- Huadian Power International Company Limited 1
- Huadian Xinzhou Guangyu Power Station 1
- Jiaozuo Wanfang Aluminum Co Ltd 1
- Mengdong Energy Group Co Ltd 1
- Ningdong Younglight Power Station 1
- Ningxia Yinglight Chemical Co. 1
- Nongyishi Electric Power Company 1
- Rizhao Steel Holding Group 1
- SDIC Huajing Power Holdings Ltd 1
- Shaanxi Non-Ferrous Metals Holding Group Co. 1
- Shandong Huatai Paper Co Ltd 1
- Shenhua Anqing Power Station 1
- Shenhua Guoneng Energy Group Corp Ltd 1
- Tbea Xinjiang Silicon Indust 1
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5105 | 5105 | CHN | China | Anhui Bengbu power station | WRI1070400 | 2520.0 | 32.7845 | 117.115 | Coal | 2013.0 | Anhui Bengbu Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1070479 | 12279.18 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5128 | 5128 | CHN | China | Aral Xinhu Cogen power station | WRI1070220 | 800.0 | 40.5897 | 81.1955 | Coal | 2013.0 | Nongyishi Electric Power Company | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1094642 | 3898.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5222 | 5222 | CHN | China | Beijing - Northwest | WRI1070846 | 2100.0 | 39.9417 | 116.1257 | Gas | 2013.0 | Beijing Jingxi Gas-fired Thermal Power Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33242-beijing-northwest-gas-power-plant | Industry About | 1091634 | 6364.27 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5251 | 5251 | CHN | China | Bulian power station | WRI1070035 | 1320.0 | 39.3012 | 109.9682 | Coal | 2013.0 | China Guodian Group Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1083665 | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5271 | 5271 | CHN | China | CPI Chifeng Daban power station | WRI1070040 | 1200.0 | 43.5893 | 118.7119 | Coal | 2013.0 | Mengdong Energy Group Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087934 | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5407 | 5407 | CHN | China | Chiping Haoji power station | WRI1070058 | 1400.0 | 36.4865 | 116.3336 | Coal | 2013.0 | Chiping Xinyuan Aluminum Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087421 | 6821.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5425 | 5425 | CHN | China | Chongqing Qineng power station | WRI1075591 | 660.0 | 29.0043 | 106.5688 | Coal | 2013.0 | Chongqing Qineng Elec & Alumn | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5501 | 5501 | CHN | China | Datang 803 power station | WRI1070612 | 600.0 | 40.2089 | 97.359 | Coal | 2013.0 | Datang 803 Power Plant | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1053870 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5528 | 5528 | CHN | China | Datang Hutubi power station | WRI1070113 | 600.0 | 44.1508 | 86.8229 | Coal | 2013.0 | Datang Xinjiang Power Generation Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1084224 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
5875 | 5875 | CHN | China | Ganquanbao TBEA power station | WRI1075604 | 700.0 | 44.1247 | 87.7707 | Coal | 2013.0 | Tbea Xinjiang Silicon Indust | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6025 | 6025 | CHN | China | Guandi | WRI1000470 | 2400.0 | 27.82 | 101.88 | Hydro | 2013.0 | Ertan Hydropower Development Company | https://web.archive.org/web/20101206021333/http://www.ehdc.com.cn/newsite/en/gd.aspx | 1042964 | 6920.5 | 8340.97 | 8058.73 | 9840.7 | 8472.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6129 | 6129 | CHN | China | Guodian Guangdong Zhaoqing Dawang power station | WRI1075609 | 700.0 | 23.3006 | 112.8563 | Coal | 2013.0 | China Guodian Corp | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6504 | 6504 | CHN | China | Huadian Luan power station | WRI1070769 | 1320.0 | 31.6561 | 116.4914 | Coal | 2013.0 | Huadian Power International Company Limited | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1078467 | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6531 | 6531 | CHN | China | Huadian Xinzhou Guangyu power station | WRI1070350 | 970.0 | 38.4595 | 112.7516 | Coal | 2013.0 | Huadian Xinzhou Guangyu Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 4726.5 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6547 | 6547 | CHN | China | Huaibei Hushan power station | WRI1070534 | 1320.0 | 33.8678 | 116.8598 | Coal | 2013.0 | Datang International Power Generation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1086782 | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6576 | 6576 | CHN | China | Huaneng Daqing power station | WRI1070237 | 700.0 | 46.7046 | 124.847 | Coal | 2013.0 | China Huaneng Group Corporation (CHNG) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1084125 | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
6751 | 6751 | CHN | China | Huinong - Yinglite Coal | WRI1070813 | 660.0 | 39.3075 | 106.7298 | Coal | 2013.0 | Ningdong Younglight Power Station | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33415-huinong-yinglite-coal-power-plant | Industry About | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7005 | 7005 | CHN | China | Jiaozuo - Wanfang 5-6 Coal | WRI1070062 | 700.0 | 35.2502 | 113.3677 | Coal | 2013.0 | Jiaozuo Wanfang Aluminum Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33184-jiaozuo-wanfang-5-6-coal-power-plant | Industry About | 1011848 | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7006 | 7006 | CHN | China | Jiaozuo Boai power station | WRI1070437 | 1320.0 | 35.221 | 113.1022 | Coal | 2013.0 | China Resources Power Holdings Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1011848 | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7040 | 7040 | CHN | China | Jilebulake | WRI1000541 | 160.0 | 48.26 | 86.399 | Hydro | 2013.0 | China Energy News | http://feature.mei.net.cn/dg12q1/news/20120322/421269.html | 423.65 | 530.68 | 529.06 | 607.35 | 529.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7078 | 7078 | CHN | China | Jinchang - Gepic Coal | WRI1070140 | 660.0 | 38.5013 | 102.2715 | Coal | 2013.0 | Gepic Jinchang Power Co Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/33389-jinchang-gepic-coal-power-plant | Industry About | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7439 | 7439 | CHN | China | Longkaikou | WRI1000473 | 1900.0 | 26.53 | 100.42 | Hydro | 2013.0 | Wilson Center | https://www.wilsoncenter.org/publication/interactive-mapping-chinas-dam-rush | 1072950 | 4467.05 | 7792.83 | 5695.61 | 6338.57 | 6250.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7598 | 7598 | CHN | China | Neijiang Baima 2 Coal | WRI1070790 | 600.0 | 29.5253 | 105.0136 | Coal | 2013.0 | Shenhua Guoneng Energy Group Corp Ltd | Industry About | https://industryabout.com/country-territories-3/1705-china/fossil-fuels-energy/25484-neijiang-baima-2-coal-power-plant | Industry About | 1044608 | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7621 | 7621 | CHN | China | Ningdong Younglight power station | WRI1075689 | 660.0 | 38.192 | 106.6813 | Coal | 2013.0 | Ningxia Yinglight Chemical Co. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7698 | 7698 | CHN | China | Pangduo | WRI1000565 | 160.0 | 30.18 | 91.352 | Hydro | 2013.0 | China Tibet Online | http://chinatibet.people.com.cn/6720326.html | 1096359 | 465.0 | 550.45 | 558.44 | 639.53 | 551.68 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7864 | 7864 | CHN | China | Renqiu power station | WRI1070842 | 700.0 | 38.7453 | 116.1533 | Coal | 2013.0 | Hebei Construction Energy Investment Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087780 | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7873 | 7873 | CHN | China | Rizhao Iron and Steel Cogen power station | WRI1075705 | 660.0 | 35.1562 | 119.3666 | Coal | 2013.0 | Rizhao Steel Holding Group | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7895 | 7895 | CHN | China | SDIC Qinzhou power station | WRI1070777 | 3360.0 | 21.7012 | 108.625 | Coal | 2013.0 | SDIC Huajing Power Holdings Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1018744 | 16372.24 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7976 | 7976 | CHN | China | Shaanxi Youser Yulin power station | WRI1075709 | 1650.0 | 38.2158 | 109.7282 | Coal | 2013.0 | Shaanxi Non-Ferrous Metals Holding Group Co. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 8039.93 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7981 | 7981 | CHN | China | Shahe power station | WRI1070840 | 1200.0 | 36.8535 | 114.3243 | Coal | 2013.0 | Hebei Construction Energy Investment Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087260 | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
7993 | 7993 | CHN | China | Shandong Huatai power station | WRI1075712 | 270.0 | 37.0091 | 118.4905 | Coal | 2013.0 | Shandong Huatai Paper Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1315.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8092 | 8092 | CHN | China | Shaoxing Binhai power station | WRI1070518 | 800.0 | 30.2269 | 120.7176 | Coal | 2013.0 | Zhejiang Zheneng Electric Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1077115 | 3898.15 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8114 | 8114 | CHN | China | Shenhua Anqing power station | WRI1070404 | 2640.0 | 30.5411 | 117.1717 | Coal | 2013.0 | Shenhua Anqing Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1048292 | 12863.9 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8125 | 8125 | CHN | China | Shenhua Shenmu power station | WRI1070430 | 1530.0 | 38.9662 | 110.4584 | Coal | 2013.0 | Shenhua Guoneng Energy Group | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1050806 | 7455.21 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8132 | 8132 | CHN | China | Shenhuo Zhundong power station | WRI1070343 | 1400.0 | 44.081 | 88.5887 | Coal | 2013.0 | Shenhua Guoneng Energy Group | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087419 | 6821.76 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8482 | 8482 | CHN | China | Tianlong Mining Fukang Smelting power station | WRI1070109 | 400.0 | 44.0992 | 88.3733 | Coal | 2013.0 | Tianlong Mining Fukang Smelting Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1949.07 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8531 | 8531 | CHN | China | Tongzi power station | WRI1070215 | 1200.0 | 28.1297 | 106.8464 | Coal | 2013.0 | China Huadian Group Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1072779 | 5847.22 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8614 | 8614 | CHN | China | Weiqiao Town Public Heating power station | WRI1070572 | 1320.0 | 37.0255 | 117.4838 | Coal | 2013.0 | Weiqiao Huimin New Material Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8620 | 8620 | CHN | China | Weiqiao Zouping-7 power station | WRI1070717 | 2640.0 | 36.8972 | 117.8613 | Coal | 2013.0 | Weiqiao Textile Limited | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 12863.9 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8651 | 8651 | CHN | China | Wujiaqu power station | WRI1070286 | 3640.0 | 44.2686 | 87.6881 | Coal | 2013.0 | Xinjiang Nongliushi Coal & Electricity Company | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1087420 | 17736.59 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
8721 | 8721 | CHN | China | Xianyou | WRI1000532 | 1200.0 | 25.53 | 118.53 | Hydro | 2013.0 | Large Dam Safety Supervision Center | http://www.dam.com.cn/damView/list.jsp | 1074074 | 2052.35 | 2847.85 | 3169.82 | 4326.95 | 3258.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8756 | 8756 | CHN | China | Xiluodu | WRI1000453 | 12600.0 | 28.26 | 103.65 | Hydro | 2013.0 | Chinese National Committee on Large Dams | http://www.chincold.org.cn/dams/rootfiles/2010/07/20/1279253974175246-1279253974178251.pdf | 1033728 | 46996.61 | 56454.54 | 55143.92 | 58761.11 | 56454.54 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8836 | 8836 | CHN | China | Xishan Gujiao power station | WRI1070200 | 2460.0 | 37.8915 | 112.0886 | Coal | 2013.0 | Xishan Coal and Eletricity Power Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1042254 | 11986.81 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
9189 | 9189 | CHN | China | Zhangjiagang Shazhou power station | WRI1070234 | 3260.0 | 31.989 | 120.6884 | Coal | 2013.0 | Beijing Sanjili Energy Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1073472 | 15884.97 | 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");