global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
236 rows where country_long = "Vietnam" sorted by commissioning_year
This data as json, CSV (advanced)
owner >30
- Vietnam Electricity (EVN) 3
- Hung Hai Lai Chau Construction Co. Ltd 2
- Trung Nam Power 2
- ANPHA Hydro Power JSC 1
- An Khanh Electricity Jsc 1
- Asia Renewable Energy Corporation 1
- Bac Minh Development Investment JSC. 1
- Buon Don Hydro Power JSC. 1
- Central Wind power Joint Stock Company 1
- Colben Energy JSC. 1
- Cong Ly Construction-Trade-Tourism 1
- Dak Lay Hydropower Co. Ltd 1
- Dak Lo- Song Da 3 JSC 1
- Electricity of Vietnam 1
- Ha Song Hydropower JSC 1
- Nam Muc Hydro Power JSC 1
- Northern Electricity development and investment JSC. No.2 1
- Quoc Cuong Gia Lai JSC 1
- Song Giang Hydropower Exploitation JSC 1
- Southern Hydropower JSC. 1
- Ta Niet Hydro Power JSC 1
- Tam Long Hydro Power JSC. 1
- Thac Mo Hydropower JSC. 1
- Truong Thanh Investment Construction and Development JSC 1
- VRG Dak Nong JSC. - Vietnam Rubber Group 1
- VRG Phu Yen JSC. 1
- Viet Nguyen Construction JSC. 1
- Vietnam National Coal - Mineral Industries Group 1
- Vinh Son Hydropower Investment JSC 1
- Vinh Son- Song Hinh Hydropower JSC 1
- …
country_long 1
- Vietnam · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
34746 | 34746 | VNM | Vietnam | Dam'Bri | WRI1030780 | 75.0 | 11.5827 | 107.6726 | Hydro | 2014.0 | Southern Hydropower JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/dataset/da-mbri-hydropower | Open Development Vietnam | 338.0 | Open Development Vietnam | 303.22 | 285.8 | 254.37 | 293.99 | 190.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34770 | 34770 | VNM | Vietnam | Hat Liu | WRI1030901 | 5.0 | 21.5067 | 104.3622 | Hydro | 2014.0 | Yen Bai Electricity Investment and Developmet JSC.(FDI) | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/hat-liu-hydropower | Open Development Vietnam | 15.8 | 14.64 | 12.67 | 15.17 | 8.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
34776 | 34776 | VNM | Vietnam | Hoa Phu | WRI1030940 | 29.0 | 12.6497 | 107.9091 | Hydro | 2014.0 | Tam Long Hydro Power JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/hoa-phu-hydropower | Open Development Vietnam | 1106029 | 132.0 | Open Development Vietnam | 125.93 | 125.93 | 106.44 | 123.47 | 91.11 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34783 | 34783 | VNM | Vietnam | Ia Grai 2 | WRI1030825 | 7.5 | 13.9756 | 107.7928 | Hydro | 2014.0 | Quoc Cuong Gia Lai JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ia-grai-2-hydropower | Open Development Vietnam | 1099083 | 27.62 | 25.68 | 22.93 | 26.69 | 17.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
34806 | 34806 | VNM | Vietnam | Na Tẩu | WRI1030934 | 6.0 | 22.6722 | 106.505 | Hydro | 2014.0 | Bac Minh Development Investment JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/th-y-di-n-na-t-u | Open Development Vietnam | 1106293 | 19.0 | Open Development Vietnam | 19.85 | 18.3 | 16.1 | 19.1 | 11.49 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34819 | 34819 | VNM | Vietnam | Nam Muc | WRI1030908 | 44.0 | 21.7981 | 103.2935 | Hydro | 2014.0 | Nam Muc Hydro Power JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-muc-hydropower | Open Development Vietnam | 1068111 | 176.0 | Open Development Vietnam | 173.88 | 181.17 | 158.48 | 175.24 | 129.7 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34823 | 34823 | VNM | Vietnam | Nam Pong | WRI1030874 | 32.0 | 19.5184 | 105.0377 | Hydro | 2014.0 | Za Hungt JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-pong-hydropower | Open Development Vietnam | 130.0 | Open Development Vietnam | 142.83 | 104.67 | 91.26 | 127.33 | 83.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34827 | 34827 | VNM | Vietnam | Ngoi Hut 2 | WRI1030907 | 48.0 | 21.7938 | 104.3324 | Hydro | 2014.0 | Truong Thanh Investment Construction and Development JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ngoi-hut-2-hydropower | Open Development Vietnam | 1084775 | 209.0 | Open Development Vietnam | 189.35 | 178.21 | 158.09 | 183.43 | 117.34 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34828 | 34828 | VNM | Vietnam | Ngoi Phat | WRI1030933 | 72.0 | 22.5546 | 103.7434 | Hydro | 2014.0 | Northern Electricity development and investment JSC. No.2 | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ngoi-phat-hydropower | Open Development Vietnam | 1071361 | 314.0 | Open Development Vietnam | 294.01 | 271.48 | 250.87 | 282.13 | 193.32 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34869 | 34869 | VNM | Vietnam | Song Giang 2 | WRI1030809 | 37.0 | 12.3729 | 108.8374 | Hydro | 2014.0 | Song Giang Hydropower Exploitation JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/song-giang-2-hydropower | Open Development Vietnam | 1076335 | 141.7 | Open Development Vietnam | 150.51 | 138.26 | 123.66 | 137.83 | 99.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34875 | 34875 | VNM | Vietnam | Sre Pok 4a | WRI1030817 | 64.0 | 12.8935 | 107.8123 | Hydro | 2014.0 | Buon Don Hydro Power JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/srepok-4a-hydropower | Open Development Vietnam | 308.0 | Open Development Vietnam | 253.01 | 238.15 | 211.32 | 245.12 | 157.0 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34885 | 34885 | VNM | Vietnam | Ta Niet | WRI1030882 | 3.6 | 20.8944 | 104.5229 | Hydro | 2014.0 | Ta Niet Hydro Power JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/ta-niet-hydropower | Open Development Vietnam | 18.0 | Open Development Vietnam | 11.75 | 10.87 | 9.58 | 11.3 | 6.81 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34898 | 34898 | VNM | Vietnam | Thuong Kon Tum | WRI1030844 | 220.0 | 14.6941 | 108.2299 | Hydro | 2014.0 | Vinh Son- Song Hinh Hydropower JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/thuong-kon-tum-hydropower | Open Development Vietnam | 1094.0 | Open Development Vietnam | 893.55 | 857.77 | 586.12 | 823.02 | 416.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34906 | 34906 | VNM | Vietnam | Vinh Son 5 | WRI1030836 | 28.0 | 14.3611 | 108.7203 | Hydro | 2014.0 | Vinh Son Hydropower Investment JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/vinh-son-hydropower | Open Development Vietnam | 1099920 | 103.0 | Open Development Vietnam | 112.61 | 106.11 | 94.37 | 109.16 | 70.6 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34679 | 34679 | VNM | Vietnam | An Khanh I | WRI1030773 | 120.0 | 21.5969 | 105.767 | Coal | 2015.0 | An Khanh Electricity Jsc | Vietnam Electricity Annual Report | http://www.evn.com.vn/userfile/files/2017/3/AnnualReport2016.pdf | WRI | 1088944 | 597.57 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||
34719 | 34719 | VNM | Vietnam | Dai Nga | WRI1030779 | 10.0 | 11.4219 | 107.8754 | Hydro | 2015.0 | Thac Mo Hydropower JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dai-nga-hydropower | Open Development Vietnam | 44.0 | Open Development Vietnam | 40.6 | 41.27 | 36.23 | 39.26 | 36.07 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34723 | 34723 | VNM | Vietnam | Dak Lay | WRI1030849 | 3.2 | 14.7979 | 108.0074 | Hydro | 2015.0 | Dak Lay Hydropower Co. Ltd | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dak-lay-hydropower | Open Development Vietnam | 13.0 | Open Development Vietnam | 10.35 | 9.56 | 8.41 | 9.95 | 5.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34740 | 34740 | VNM | Vietnam | Dak Sin 1 | WRI1030789 | 28.0 | 11.8186 | 107.459 | Hydro | 2015.0 | VRG Dak Nong JSC. - Vietnam Rubber Group | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dak-sin-1-hydropower | Open Development Vietnam | 1074394 | 105.0 | Open Development Vietnam | 112.81 | 106.31 | 94.57 | 109.36 | 70.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34749 | 34749 | VNM | Vietnam | Dong Nai 2 | WRI1030782 | 70.0 | 11.7129 | 108.0579 | Hydro | 2015.0 | Trung Nam Power | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dong-nai-2-hydropower | Open Development Vietnam | 1071686 | 264.0 | Open Development Vietnam | 282.15 | 277.27 | 238.7 | 281.11 | 210.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34752 | 34752 | VNM | Vietnam | Dong Nai 5 | WRI1030785 | 150.0 | 11.7927 | 107.5534 | Hydro | 2015.0 | Vietnam National Coal - Mineral Industries Group | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dong-nai-5-hydropower | Open Development Vietnam | 1095571 | 616.0 | Open Development Vietnam | 586.38 | 584.56 | 491.68 | 596.02 | 416.08 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34764 | 34764 | VNM | Vietnam | Ha Song Pha 2 | WRI1030787 | 5.1 | 11.8319 | 108.7073 | Hydro | 2015.0 | Ha Song Hydropower JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/song-pha-2-hydropower | Open Development Vietnam | 1101247 | 30.0 | Open Development Vietnam | 16.12 | 14.8 | 12.93 | 15.48 | 9.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34778 | 34778 | VNM | Vietnam | Huoi Quang | WRI1030905 | 520.0 | 21.6965 | 103.8776 | Hydro | 2015.0 | Vietnam Electricity (EVN) | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/huoi-quang-hydropower | Open Development Vietnam | 1060278 | 1904.0 | Open Development Vietnam | 1965.15 | 1969.62 | 1669.85 | 1851.68 | 1340.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34792 | 34792 | VNM | Vietnam | La Hieng 2 | WRI1030754 | 18.0 | 13.5017 | 108.85 | Hydro | 2015.0 | VRG Phu Yen JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/la-hieng-2-hydropower | Open Development Vietnam | 68.0 | Open Development Vietnam | 75.96 | 63.01 | 57.32 | 73.02 | 50.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34793 | 34793 | VNM | Vietnam | Lai Chau | WRI1030913 | 1200.0 | 22.1379 | 102.9839 | Hydro | 2015.0 | Vietnam Electricity (EVN) | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/lai-chau-hydropower | Open Development Vietnam | 1060280 | 4670.0 | Open Development Vietnam | 4779.8 | 4779.8 | 4293.3 | 4701.28 | 3065.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34812 | 34812 | VNM | Vietnam | Nam Hoa 1 | WRI1030890 | 18.0 | 21.3557 | 103.4076 | Hydro | 2015.0 | ANPHA Hydro Power JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-hoa-1-hydropower | Open Development Vietnam | 70.0 | Open Development Vietnam | 71.26 | 70.88 | 63.89 | 73.5 | 54.66 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34820 | 34820 | VNM | Vietnam | Nam Na 2 | WRI1030928 | 66.0 | 22.4932 | 103.234 | Hydro | 2015.0 | Hung Hai Lai Chau Construction Co. Ltd | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-na-2-hydropower | Open Development Vietnam | 1089734 | 254.0 | Open Development Vietnam | 299.33 | 296.13 | 272.77 | 292.64 | 230.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34821 | 34821 | VNM | Vietnam | Nam Na 3 | WRI1030919 | 84.0 | 22.2985 | 103.1613 | Hydro | 2015.0 | Hung Hai Lai Chau Construction Co. Ltd | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/nam-na-3-hydropower | Open Development Vietnam | 1084776 | 361.0 | Open Development Vietnam | 367.76 | 443.62 | 361.25 | 376.09 | 281.67 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34863 | 34863 | VNM | Vietnam | Song Bung 4 | WRI1030857 | 156.0 | 15.7258 | 107.6512 | Hydro | 2015.0 | Vietnam Electricity (EVN) | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/song-bung-4-hydropower | Open Development Vietnam | 1067975 | 586.0 | Open Development Vietnam | 614.94 | 607.01 | 513.22 | 589.88 | 413.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34685 | 34685 | VNM | Vietnam | Bac Lieu Wind power | WRI1030729 | 99.0 | 9.2351 | 105.8048 | Wind | 2016.0 | Cong Ly Construction-Trade-Tourism | Vietnam Electricity Annual Report | http://www.evn.com.vn/userfile/files/2017/3/AnnualReport2016.pdf | WRI | 1083899 | 259.44 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | WIND-V1 | ||||||||||||||||
34712 | 34712 | VNM | Vietnam | Coc San | WRI1030923 | 30.0 | 22.4144 | 103.9066 | Hydro | 2016.0 | Colben Energy JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/coc-san-hydropower | Open Development Vietnam | 1067301 | 120.0 | Open Development Vietnam | 116.38 | 120.93 | 103.23 | 117.72 | 79.1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||
34724 | 34724 | VNM | Vietnam | Dak Lo | WRI1030776 | 22.0 | 14.7275 | 108.3694 | Hydro | 2016.0 | Dak Lo- Song Da 3 JSC | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dak-lo-hydropower | Open Development Vietnam | 93.2 | Open Development Vietnam | 88.79 | 83.68 | 74.77 | 86.08 | 56.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34729 | 34729 | VNM | Vietnam | Dak Nong 2 | WRI1030796 | 16.0 | 11.9645 | 107.6675 | Hydro | 2016.0 | Viet Nguyen Construction JSC. | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/dak-nong-2-hydropower | Open Development Vietnam | 65.0 | Open Development Vietnam | 57.46 | 53.33 | 47.45 | 55.47 | 35.16 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34790 | 34790 | VNM | Vietnam | Krong No 3 | WRI1030807 | 18.0 | 12.2117 | 108.2847 | Hydro | 2016.0 | Trung Nam Power | Open Development Vietnam | https://data.opendevelopmentmekong.net/vi/library_record/krong-no-3-hydropower | Open Development Vietnam | 63.5 | Open Development Vietnam | 63.87 | 66.76 | 60.81 | 67.62 | 53.93 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||
34847 | 34847 | VNM | Vietnam | Phuong Mai 3 | WRI1030755 | 21.0 | 13.9077 | 109.26 | Wind | 2017.0 | Central Wind power Joint Stock Company | CDM | https://cdm.unfccc.int/Projects/DB/ICONTEC1347544560.36/view | CDM | 1074649 | 27.52 | 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 | |||||||||||||||||
34897 | 34897 | VNM | Vietnam | Thuan Nhien Phong | WRI1030749 | 32.0 | 11.0525 | 108.41 | Wind | 2017.0 | Asia Renewable Energy Corporation | CDM | https://cdm.unfccc.int/Projects/DB/ICONTEC1347549044.44/view | CDM | 1074594 | 41.94 | 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");