global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
46 rows where capacity_mw = "10.0", primary_fuel = "Hydro" and source = "UNFCCC CDM Registry"
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5359 | 5359 | CHN | China | Changshatou | WRI1071072 | 10.0 | 30.63 | 110.53 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1962 | UNFCCC CDM Registry | 25.89 | 37.87 | 36.49 | 38.27 | 38.68 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
5414 | 5414 | CHN | China | Chongqing Chengkou Baiguoping | WRI1071716 | 10.0 | 32.1136 | 108.4286 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4913 | UNFCCC CDM Registry | 1106280 | 27.9 | 34.96 | 36.54 | 37.49 | 37.22 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
5896 | 5896 | CHN | China | Gansu Liujialang Expanded | WRI1071467 | 10.0 | 34.4669 | 103.8311 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3990 | UNFCCC CDM Registry | 1117271 | 37.51 | 44.21 | 41.07 | 43.14 | 41.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
5913 | 5913 | CHN | China | Gansu Xinmintan Expanded | WRI1071542 | 10.0 | 35.5278 | 103.8203 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4248 | UNFCCC CDM Registry | 38.31 | 44.18 | 43.9 | 43.07 | 42.63 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6058 | 6058 | CHN | China | Guangxi Jindong | WRI1072270 | 10.0 | 25.5761 | 108.7564 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6722 | UNFCCC CDM Registry | 22.16 | 30.05 | 30.05 | 34.86 | 30.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6068 | 6068 | CHN | China | Guangxi Xinglong Small | WRI1071329 | 10.0 | 25.8788 | 110.1155 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3478 | UNFCCC CDM Registry | 35.75 | 41.84 | 41.11 | 43.12 | 40.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6452 | 6452 | CHN | China | Hongyuan Small | WRI1071003 | 10.0 | 34.22 | 103.53 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1127 | UNFCCC CDM Registry | 22.89 | 30.78 | 30.78 | 35.58 | 30.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6723 | 6723 | CHN | China | Hubei Chibi Lushuihe Jiedi Small | WRI1072492 | 10.0 | 29.8206 | 113.7139 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7345 | UNFCCC CDM Registry | 1100696 | 34.87 | 41.33 | 42.29 | 44.91 | 41.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
6724 | 6724 | CHN | China | Hubei Dahebian | WRI1071108 | 10.0 | 29.724 | 109.0675 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2531 | UNFCCC CDM Registry | 33.41 | 41.44 | 39.49 | 43.66 | 43.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6735 | 6735 | CHN | China | Hubei Province Fang County Fanjiaya | WRI1072191 | 10.0 | 32.4361 | 110.7569 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6452 | UNFCCC CDM Registry | 22.89 | 30.78 | 31.05 | 35.31 | 32.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6796 | 6796 | CHN | China | Hunan Taoliao Small | WRI1071358 | 10.0 | 26.075 | 113.729 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3583 | UNFCCC CDM Registry | 22.11 | 30.0 | 30.0 | 34.81 | 30.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
6805 | 6805 | CHN | China | Hunan Xupu Zhuxijiang Hydro | WRI1071880 | 10.0 | 27.9119 | 110.7919 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5543 | UNFCCC CDM Registry | 34.44 | 38.89 | 40.5 | 40.42 | 39.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7113 | 7113 | CHN | China | Jinghong Mengsong | WRI1072401 | 10.0 | 22.2003 | 100.8678 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7102 | UNFCCC CDM Registry | 1033716 | 22.16 | 30.05 | 30.05 | 34.86 | 30.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7154 | 7154 | CHN | China | Jinping Maguo River | WRI1071477 | 10.0 | 22.825 | 103.4953 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4036 | UNFCCC CDM Registry | 22.16 | 30.05 | 30.05 | 34.86 | 30.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7187 | 7187 | CHN | China | Jiulong County Rekuhe Stage 2 | WRI1071254 | 10.0 | 29.044 | 101.576 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3235 | UNFCCC CDM Registry | 1088723 | 22.89 | 30.78 | 30.78 | 35.58 | 30.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7245 | 7245 | CHN | China | Kuitun River Laolongkou | WRI1071290 | 10.0 | 44.3558 | 84.7817 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3348 | UNFCCC CDM Registry | 28.2 | 32.7 | 34.05 | 35.27 | 34.44 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7278 | 7278 | CHN | China | Laowuhe Erji | WRI1071073 | 10.0 | 26.6514 | 98.8975 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1978 | UNFCCC CDM Registry | 33.73 | 40.49 | 35.0 | 40.98 | 39.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7293 | 7293 | CHN | China | Li County Suoluogou 1st Stage | WRI1072536 | 10.0 | 31.4138 | 102.9807 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7506 | UNFCCC CDM Registry | 1105527 | 34.44 | 40.14 | 40.45 | 45.33 | 40.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7362 | 7362 | CHN | China | Lincang Mangnuohe Small | WRI1071897 | 10.0 | 23.4186 | 100.0739 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5608 | UNFCCC CDM Registry | 35.29 | 38.64 | 40.56 | 42.11 | 35.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7478 | 7478 | CHN | China | Luodu Small | WRI1071134 | 10.0 | 28.0994 | 104.8403 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2788 | UNFCCC CDM Registry | 30.67 | 35.55 | 37.13 | 42.16 | 37.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7479 | 7479 | CHN | China | Luogu | WRI1071551 | 10.0 | 28.3458 | 103.1406 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4287 | UNFCCC CDM Registry | 28.55 | 34.51 | 35.46 | 37.54 | 35.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7484 | 7484 | CHN | China | Luoning Yumenhechina | WRI1071634 | 10.0 | 34.3083 | 111.4063 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4688 | UNFCCC CDM Registry | 27.88 | 29.7 | 29.79 | 38.81 | 32.3 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7511 | 7511 | CHN | China | Malong River 3# | WRI1071874 | 10.0 | 24.1564 | 99.5444 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5508 | UNFCCC CDM Registry | 30.02 | 36.39 | 36.14 | 38.95 | 36.14 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7529 | 7529 | CHN | China | Mayang County Jiangkou Smallscale | WRI1071256 | 10.0 | 27.7017 | 109.7333 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3240 | UNFCCC CDM Registry | 41.78 | 46.35 | 46.35 | 48.26 | 48.13 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7537 | 7537 | CHN | China | Mengshan Xingupai Hydro | WRI1071195 | 10.0 | 24.23 | 110.48 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3076 | UNFCCC CDM Registry | 22.85 | 30.74 | 30.74 | 35.55 | 30.74 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7765 | 7765 | CHN | China | Qiaohe Second | WRI1071863 | 10.0 | 30.4331 | 110.3069 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5451 | UNFCCC CDM Registry | 39.39 | 59.34 | 48.22 | 47.93 | 45.87 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7822 | 7822 | CHN | China | Qinghai Qingshizui Small | WRI1071284 | 10.0 | 37.4939 | 101.3392 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3319 | UNFCCC CDM Registry | 1087146 | 35.3 | 41.75 | 40.61 | 43.71 | 41.24 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
7954 | 7954 | CHN | China | Second Hetao Irrigation District Inner Mongolia | WRI1071724 | 10.0 | 40.6681 | 107.2681 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4931 | UNFCCC CDM Registry | 22.16 | 30.05 | 30.05 | 34.86 | 30.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
7973 | 7973 | CHN | China | Shaanxi Tiefo Guanyuanchina | WRI1071324 | 10.0 | 32.3236 | 108.7744 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3448 | UNFCCC CDM Registry | 22.16 | 30.05 | 30.05 | 34.86 | 30.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8037 | 8037 | CHN | China | Shanmugou Small | WRI1071021 | 10.0 | 28.49 | 102.59 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1231 | UNFCCC CDM Registry | 19.76 | 28.06 | 33.53 | 38.34 | 33.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8255 | 8255 | CHN | China | Sichuan Jiuzhaigou County Songbai | WRI1072338 | 10.0 | 33.1706 | 104.2592 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6902 | UNFCCC CDM Registry | 1105012 | 36.25 | 41.17 | 41.06 | 42.96 | 41.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8302 | 8302 | CHN | China | Sichuan Toudaoqiao | WRI1071996 | 10.0 | 30.8122 | 102.695 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=5896 | UNFCCC CDM Registry | 31.64 | 36.11 | 39.78 | 38.59 | 38.42 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8325 | 8325 | CHN | China | Simeigou | WRI1071541 | 10.0 | 32.0572 | 103.0156 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4244 | UNFCCC CDM Registry | 33.59 | 37.08 | 35.54 | 39.19 | 32.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8629 | 8629 | CHN | China | Wenshan Panlong River Weilong | WRI1071159 | 10.0 | 23.1083 | 104.5217 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2942 | UNFCCC CDM Registry | 1071605 | 28.62 | 34.13 | 34.28 | 37.66 | 36.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8694 | 8694 | CHN | China | Wuyahe Small | WRI1071392 | 10.0 | 29.6044 | 109.7042 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3696 | UNFCCC CDM Registry | 22.11 | 30.0 | 30.0 | 34.81 | 30.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8714 | 8714 | CHN | China | Xiangshui River First Stage Runofriver | WRI1071564 | 10.0 | 28.6519 | 102.6532 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4374 | UNFCCC CDM Registry | 24.52 | 31.18 | 34.36 | 35.78 | 32.88 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8718 | 8718 | CHN | China | Xiangtang Xia The Peoples Republic | WRI1071350 | 10.0 | 36.37 | 102.83 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3548 | UNFCCC CDM Registry | 36.15 | 44.29 | 44.36 | 44.62 | 43.98 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8720 | 8720 | CHN | China | Xiannvhu Enshi City | WRI1071228 | 10.0 | 30.1288 | 109.8705 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3158 | UNFCCC CDM Registry | 1089191 | 30.53 | 36.29 | 34.05 | 36.7 | 35.75 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||||
8847 | 8847 | CHN | China | Xixiang County Qujiangdong | WRI1072476 | 10.0 | 32.6139 | 107.4692 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=7306 | UNFCCC CDM Registry | 24.04 | 40.5 | 40.5 | 36.85 | 39.57 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
8879 | 8879 | CHN | China | Yangdun Small | WRI1071029 | 10.0 | 27.1944 | 118.1844 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=1276 | UNFCCC CDM Registry | 29.4 | 35.74 | 40.22 | 43.35 | 33.06 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9012 | 9012 | CHN | China | Yuanyang County Yangxi River 3rd Cascade | WRI1072305 | 10.0 | 23.1356 | 102.9503 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6824 | UNFCCC CDM Registry | 41.73 | 46.96 | 46.96 | 51.94 | 50.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9075 | 9075 | CHN | China | Yunnan Eryuan Misha River Longdi | WRI1071653 | 10.0 | 26.1206 | 99.4336 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4745 | UNFCCC CDM Registry | 29.01 | 32.88 | 29.61 | 34.57 | 34.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9088 | 9088 | CHN | China | Yunnan Kegonghe | WRI1071179 | 10.0 | 27.32 | 99.17 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=3015 | UNFCCC CDM Registry | 31.36 | 35.6 | 33.53 | 37.17 | 37.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9127 | 9127 | CHN | China | Yunnan Tengchong Xiaotianhe Small | WRI1072251 | 10.0 | 24.9985 | 98.3599 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=6649 | UNFCCC CDM Registry | 22.11 | 30.0 | 30.0 | 34.81 | 30.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9134 | 9134 | CHN | China | Yunnan Xinya River 3rd Level | WRI1071094 | 10.0 | 23.2803 | 99.1403 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=2429 | UNFCCC CDM Registry | 30.2 | 38.1 | 36.11 | 44.61 | 36.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||||
9285 | 9285 | CHN | China | Zhoutian | WRI1071732 | 10.0 | 24.947 | 113.781 | Hydro | UNFCCC CDM Registry | https://cdm.unfccc.int/Projects/redirector?ref=4961 | UNFCCC CDM Registry | 1100702 | 36.83 | 37.99 | 41.16 | 49.47 | 37.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-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");