global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
46 rows where commissioning_year = "2017.0" and primary_fuel = "Coal"
This data as json, CSV (advanced)
Suggested facets: country, geolocation_source, estimated_generation_gwh_2017, estimated_generation_note_2017
owner >30
- Cenal Elektrik 1
- China Power Investment and Ningxia Power Generation Co. 1
- Electricity of Vietnam 1
- Elektrownia Wytwarzanie S.A. 1
- Enea Wytwarzanie 1
- Fatima Group 1
- Fauji Fertilizer Bin Qasim Limited 1
- GS E&R Korea East-West Power Co Samtan 1
- Gansu Power Investment Co Ltd 1
- Gongzhuling Shenglong Cogen Power Company 1
- Guangdong Yuehua Power Co 1
- Henan Investment Group Co Ltd 1
- Huadian Hubei Co 1
- Huaneng Shandong Power Co Ltd Shandong Ruyi Group 1
- Inner Mongolia Chuangyuan Metal Co 1
- Jingneng Power 1
- Kansai Electric Power Co 1
- Korea Midland Power 1
- Linyi Xincheng Jinluo Cogen Company 1
- Long Chen Paper (China) Co 1
- Maple Leaf Power 1
- Meixin Industry Investment Co. 1
- Mengdong Energy Group 1
- Minergy Coal Corporation 1
- Mitsubishi Corporation 1
- Ningxia Energy Group Co 1
- Osaka Gas 1
- Osaki CoolGen Corp. 1
- PT Cikarang Listrindo 1
- PT Gahapi Nisco Steel 1
- …
country_long 11
primary_fuel 1
- Coal · 46 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5172 | 5172 | CHN | China | Baoding Northwest Suberb power station | WRI1075572 | 350.0 | 38.9618 | 115.3672 | Coal | 2017.0 | Shenzhen Energy | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1705.44 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5272 | 5272 | CHN | China | CPI Chifeng New City Region power station | WRI1075580 | 600.0 | 42.2934 | 118.9133 | Coal | 2017.0 | Mengdong Energy Group | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5277 | 5277 | CHN | China | CPI Ningxia Zaoquan power station | WRI1075581 | 1320.0 | 38.0462 | 106.6058 | Coal | 2017.0 | China Power Investment and Ningxia Power Generation Co. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
5433 | 5433 | CHN | China | Chuangyuan Smelter power station | WRI1075592 | 990.0 | 45.4373 | 119.4275 | Coal | 2017.0 | Inner Mongolia Chuangyuan Metal Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 4823.96 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6378 | 6378 | CHN | China | Henglian Wucaiwan power station | WRI1075623 | 1320.0 | 44.7896 | 89.1977 | Coal | 2017.0 | Xinjiang Henglian Energy Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6453 | 6453 | CHN | China | Hongyuan Waste Coal Cogen power station | WRI1075626 | 60.0 | 44.4196 | 126.9663 | Coal | 2017.0 | Shulan Hongyuan Waste Coal Cogen Power Company | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 292.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
6494 | 6494 | CHN | China | Huadian Jiangling power station | WRI1075628 | 660.0 | 30.0912 | 112.3106 | Coal | 2017.0 | Huadian Hubei Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3215.97 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7125 | 7125 | CHN | China | Jingneng Zhuozhou power station | WRI1075656 | 350.0 | 39.5633 | 115.9992 | Coal | 2017.0 | Jingneng Power | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1705.44 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7384 | 7384 | CHN | China | Linyi Xincheng Jinluo Cogen power station | WRI1075670 | 50.0 | 35.2487 | 118.2952 | Coal | 2017.0 | Linyi Xincheng Jinluo Cogen Company | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 243.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7430 | 7430 | CHN | China | Long Chen Paper Jingzhou captive power station | WRI1075671 | 105.0 | 30.2609 | 111.5907 | Coal | 2017.0 | Long Chen Paper (China) Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 511.63 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7444 | 7444 | CHN | China | Longsheng Cogen power station | WRI1075674 | 60.0 | 43.5175 | 124.86 | Coal | 2017.0 | Gongzhuling Shenglong Cogen Power Company | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 292.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7533 | 7533 | CHN | China | Meixin captive power station | WRI1075679 | 700.0 | 34.9653 | 108.9758 | Coal | 2017.0 | Meixin Industry Investment Co. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
7751 | 7751 | CHN | China | Puyang Longfeng power station | WRI1075699 | 600.0 | 35.7695 | 115.2547 | Coal | 2017.0 | Henan Investment Group Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 2923.61 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8091 | 8091 | CHN | China | Shaoguan Wastecoal power station | WRI1075718 | 700.0 | 24.9354 | 113.5526 | Coal | 2017.0 | Guangdong Yuehua Power Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8136 | 8136 | CHN | China | Shenneng Korla power station | WRI1075725 | 700.0 | 41.6642 | 86.2632 | Coal | 2017.0 | Shenneng Korla Power Co. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8459 | 8459 | CHN | China | Tianchi Changji Cogen power station | WRI1075736 | 700.0 | 44.0044 | 87.172 | Coal | 2017.0 | Xinjiang Tianchi Energy Sources & Datang Xinjiang | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8462 | 8462 | CHN | China | Tianfu North power station | WRI1070709 | 1320.0 | 44.4404 | 86.094 | Coal | 2017.0 | Tianfu North Power Station | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8687 | 8687 | CHN | China | Wuwei Cogen power station | WRI1075755 | 700.0 | 37.9011 | 102.6859 | Coal | 2017.0 | Gansu Power Investment Co Ltd | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3410.88 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
8972 | 8972 | CHN | China | Yinxing power station | WRI1075777 | 1320.0 | 37.7274 | 106.7409 | Coal | 2017.0 | Ningxia Energy Group Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 6431.95 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
14075 | 14075 | IND | India | AVANTHA BHANDAR TPP | IND0000017 | 600.0 | 21.7438 | 83.2741 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1077485 | 2019 | 0.0 | 986.24735 | 283.2 | 540.29 | 0.0 | Central Electricity Authority | 3160.77 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||
14176 | 14176 | IND | India | BINJKOTE | IND0000527 | 600.0 | 22.0103 | 83.2058 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 2019 | 546.795 | 1294.854 | Central Electricity Authority | 3160.77 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
14181 | 14181 | IND | India | BONGAIGAON TPP | IND0000066 | 750.0 | 26.5145 | 90.5287 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1064211 | 2019 | 106.5792 | 1511.0 | 1545.0 | 2574.062 | Central Electricity Authority | 3950.96 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
14604 | 14604 | IND | India | INDIA POWER TPP(HALDIA HIRANMAYE ) | IND0000529 | 300.0 | 22.0774 | 88.0995 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 2019 | 25.2816 | 72.75 | Central Electricity Authority | 1580.38 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||
14717 | 14717 | IND | India | KUDGI | IND0000519 | 2400.0 | 16.4994 | 75.8349 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 2019 | 24.151775 | 3249.0 | 6970.0 | Central Electricity Authority | 12643.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
15015 | 15015 | IND | India | NABI NAGAR TPP | IND0000287 | 750.0 | 24.7754 | 84.1588 | Coal | Oil | 2017.0 | Central Electricity Authority | http://www.cea.nic.in/ | WRI | 1061866 | 2019 | 0.1183 | 73.131513 | 916.48 | 2542.9 | Central Electricity Authority | 3950.96 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||
15648 | 15648 | IDN | Indonesia | Banten Serang power station | WRI1075800 | 660.0 | -5.883 | 106.0459 | Coal | 2017.0 | PT Lestari Baten Energi (LBE) | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 3591.7 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
15656 | 15656 | IDN | Indonesia | Cikarang Babelan power station | WRI1075803 | 280.0 | -6.1161 | 107.052 | Coal | 2017.0 | PT Cikarang Listrindo | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1523.75 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
15687 | 15687 | IDN | Indonesia | Medan Steel Mill Power Plant | WRI1075810 | 60.0 | 3.6676 | 98.6654 | Coal | 2017.0 | PT Gahapi Nisco Steel | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 326.51 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
16621 | 16621 | JPN | Japan | Kansai Sendai power station | WRI1061348 | 112.0 | 38.2681 | 141.0092 | Coal | 2017.0 | Kansai Electric Power Co | GCPT | https://endcoal.org/global-coal-plant-tracker/ | WRI | 735.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
16720 | 16720 | JPN | Japan | Mizushima Energy Center | WRI1061346 | 112.0 | 34.5099 | 133.7458 | Coal | 2017.0 | Mitsubishi Corporation | Japan Coal Plant Tracker | http://sekitan.jp/plant-map/en/v2/table_en | WRI | 1012406 | 735.84 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
16731 | 16731 | JPN | Japan | Nagoya Power Plant 2 | WRI1020155 | 110.0 | 35.0659 | 136.8778 | Coal | 2017.0 | Osaka Gas | Japan Coal Plant Tracker | http://sekitan.jp/plant-map/en/v2/table_en | WRI | 1056399 | 722.7 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
16796 | 16796 | JPN | Japan | Osaki CoolGen Project | WRI1061347 | 166.0 | 34.2591 | 132.8723 | Coal | 2017.0 | Osaki CoolGen Corp. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 1012416 | 1090.62 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
17635 | 17635 | MMR | Myanmar | Malamyine | WRI1061380 | 45.0 | 16.5 | 97.662 | Coal | 2017.0 | Pacific Link Cement | Global Cement | http://www.globalcement.com/news/item/6452-mawlamyine-plant-may-not-have-proper-power-plant-permission | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
18198 | 18198 | PAK | Pakistan | Fauji Fertilizer Power Plant | WRI1030456 | 118.0 | 24.8339 | 67.4179 | Coal | 2017.0 | Fauji Fertilizer Bin Qasim Limited | The Express Tribune | https://tribune.com.pk/story/1318678/fauji-fertilizers-118mw-coal-fired-power-plant-comes-online/ | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
18218 | 18218 | PAK | Pakistan | Maple Leaf power station | WRI1030458 | 40.0 | 32.9052 | 71.6119 | Coal | 2017.0 | Maple Leaf Power | GCPT | https://endcoal.org/global-coal-plant-tracker/ | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
18220 | 18220 | PAK | Pakistan | Muzaffargarh Sugar Mill | WRI1030459 | 120.0 | 30.2934 | 70.9672 | Coal | 2017.0 | Fatima Group | The Express Tribune | https://tribune.com.pk/story/1391202/govt-contest-tariff-case-filed-fatima-energy/ | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
18235 | 18235 | PAK | Pakistan | Sahiwal | WRI1030457 | 1320.0 | 30.7135 | 73.2432 | Coal | 2017.0 | Huaneng Shandong Power Co Ltd Shandong Ruyi Group | China Pakistan Economic Corridor | http://www.cpec.gov.pk/project-details/2 | WRI | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
18331 | 18331 | PHL | Philippines | Balingasag power station | WRI1030489 | 165.0 | 8.7662 | 124.7685 | Coal | 2017.0 | Minergy Coal Corporation | GCPT | https://endcoal.org/global-coal-plant-tracker/ | WRI | 1039.74 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
18354 | 18354 | PHL | Philippines | Davao San Miguel power station | WRI1029969 | 300.0 | 6.3943 | 125.6173 | Coal | 2017.0 | SMC Global Power Holdings | GCPT | https://endcoal.org/global-coal-plant-tracker/ | WRI | 1890.45 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
18408 | 18408 | PHL | Philippines | SCPC U1 | WRI1030470 | 300.0 | 14.5247 | 120.5964 | Coal | 2017.0 | San Miguel Consolidated Power Corporation | Philippines Department of Energy | https://www.doe.gov.ph/list-existing-power-plants | WRI | 1890.45 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
18580 | 18580 | POL | Poland | Kozienice | WRI1075563 | 1075.0 | 51.5829 | 21.5478 | Coal | 2017.0 | Elektrownia Wytwarzanie S.A. | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 4465.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
18582 | 18582 | POL | Poland | Kozienice II | WRI1019040 | 1075.0 | 51.6668 | 21.4614 | Coal | 2017.0 | Enea Wytwarzanie | ENTSOE | https://transparency.entsoe.eu/generation/r2/installedCapacityPerProductionUnit/show | University of Dąbrowa Górnicza | 1015575 | 4764.358 | 4750.88 | 3752.808 | JRC-PPDB-OPEN | 4465.4 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||
20018 | 20018 | KOR | South Korea | Bukpyung power station | WRI1075819 | 1190.0 | 37.4805 | 129.1433 | Coal | 2017.0 | GS E&R Korea East-West Power Co Samtan | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 9003.16 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
20100 | 20100 | KOR | South Korea | Shin Boryeong power station | WRI1075823 | 2000.0 | 36.3846 | 126.4862 | Coal | 2017.0 | Korea Midland Power | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 15131.36 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
21723 | 21723 | TUR | Turkey | Cenal power station | WRI1075555 | 1320.0 | 40.4167 | 27.3183 | Coal | 2017.0 | Cenal Elektrik | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 7393.09 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | |||||||||||||||||
34892 | 34892 | VNM | Vietnam | Thai Binh Power Center | WRI1075848 | 600.0 | 20.481 | 106.5605 | Coal | 2017.0 | Electricity of Vietnam | GCPT | https://endcoal.org/global-coal-plant-tracker/ | GCPT | 2987.85 | 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");