global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
36 rows where geolocation_source = "WRI" and url = "http://www.spcg.co.th/index.php/en/about"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, estimated_generation_gwh_2014
owner >30
- AJ Technology Company Limited (AJ) 1
- Solar Power (Bureerum 1) Company Limited 1
- Solar Power (Bureerum 2) Company Limited 1
- Solar Power (Bureerum 3) Company Limited 1
- Solar Power (Khon Kaen 1) Company Limited 1
- Solar Power (Khon Kaen 10) Company Limited 1
- Solar Power (Khon Kaen 2) Company Limited 1
- Solar Power (Khon Kaen 3) Company Limited 1
- Solar Power (Khon Kaen 4) Company Limited 1
- Solar Power (Khon Kaen 5) Company Limited 1
- Solar Power (Khon Kaen 6) Company Limited 1
- Solar Power (Khon Kaen 7) Company Limited 1
- Solar Power (Khon Kaen 8) Company Limited 1
- Solar Power (Khon Kaen 9) Company Limited 1
- Solar Power (Korat 1) Company Limited 1
- Solar Power (Korat 2) Company Limited 1
- Solar Power (Korat 3) Company Limited 1
- Solar Power (Korat 4) Company Limited 1
- Solar Power (Korat 5) Company Limited 1
- Solar Power (Korat 6) Company Limited 1
- Solar Power (Korat 7) Company Limited 1
- Solar Power (Korat 8) Company Limited 1
- Solar Power (Korat 9) Company Limited 1
- Solar Power (Loei 1) Company Limited 1
- Solar Power (Loei 2) Company Limited 1
- Solar Power (Nakhon Phanom 1) Company Limited 1
- Solar Power (Nakhon Phanom 2) Company Limited 1
- Solar Power (Nakhon Phanom 3) Company Limited 1
- Solar Power (Nong Khai 1) Company Limited 1
- Solar Power (Sakon Nakhon 1) Company Limited 1
- …
primary_fuel 1
- Solar 36
country_long 1
- Thailand 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21472 | 21472 | THA | Thailand | Buri Ram 1 Solar Power Plant | WRI1026231 | 7.4 | 14.6592 | 102.6147 | Solar | Solar Power (Bureerum 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.85 | 13.83 | 13.8 | 13.72 | 12.69 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21473 | 21473 | THA | Thailand | Buri Ram 2 Solar Power Plant | WRI1026232 | 7.4 | 14.6996 | 102.4787 | Solar | Solar Power (Bureerum 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.89 | 13.83 | 13.86 | 13.72 | 12.71 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21474 | 21474 | THA | Thailand | Buri Ram 3 Solar Power Plant | WRI1026233 | 7.4 | 14.7615 | 103.0633 | Solar | Solar Power (Bureerum 3) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.84 | 13.31 | 14.2 | 13.73 | 12.59 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21507 | 21507 | THA | Thailand | Khon Kaen 1 Solar Power Plant | WRI1026254 | 6.1 | 16.5117 | 102.7942 | Solar | Solar Power (Khon Kaen 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.53 | 11.41 | 11.8 | 11.34 | 10.29 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21508 | 21508 | THA | Thailand | Khon Kaen 10 Solar Power Plant | WRI1026255 | 7.4 | 16.5293 | 102.2753 | Solar | Solar Power (Khon Kaen 10) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.96 | 13.84 | 14.26 | 13.68 | 12.94 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21509 | 21509 | THA | Thailand | Khon Kaen 2 Solar Power Plant | WRI1026256 | 7.4 | 16.8286 | 102.8352 | Solar | Solar Power (Khon Kaen 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.91 | 13.21 | 14.28 | 13.7 | 12.55 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21510 | 21510 | THA | Thailand | Khon Kaen 3 Solar Power Plant | WRI1026257 | 7.4 | 16.7595 | 102.8063 | Solar | Solar Power (Khon Kaen 3) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.91 | 13.53 | 14.27 | 13.75 | 12.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21511 | 21511 | THA | Thailand | Khon Kaen 4 Solar Power Plant | WRI1026258 | 7.4 | 16.6063 | 102.1118 | Solar | Solar Power (Khon Kaen 4) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.92 | 13.93 | 14.28 | 13.65 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21512 | 21512 | THA | Thailand | Khon Kaen 5 Solar Power Plant | WRI1026259 | 7.4 | 16.2873 | 102.7906 | Solar | Solar Power (Khon Kaen 5) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.98 | 13.83 | 14.31 | 13.77 | 12.55 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21513 | 21513 | THA | Thailand | Khon Kaen 6 Solar Power Plant | WRI1026260 | 7.4 | 16.4802 | 102.507 | Solar | Solar Power (Khon Kaen 6) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.91 | 13.84 | 14.26 | 13.74 | 12.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21514 | 21514 | THA | Thailand | Khon Kaen 7 Solar Power Plant | WRI1026261 | 7.4 | 16.4999 | 102.3242 | Solar | Solar Power (Khon Kaen 7) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.96 | 13.84 | 14.26 | 13.68 | 12.94 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21515 | 21515 | THA | Thailand | Khon Kaen 8 Solar Power Plant | WRI1026262 | 7.4 | 16.114 | 102.7499 | Solar | Solar Power (Khon Kaen 8) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.95 | 13.83 | 14.29 | 13.75 | 12.55 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21516 | 21516 | THA | Thailand | Khon Kaen 9 Solar Power Plant | WRI1026263 | 7.4 | 16.5783 | 102.0029 | Solar | Solar Power (Khon Kaen 9) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.97 | 13.93 | 14.26 | 13.65 | 12.97 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21520 | 21520 | THA | Thailand | Korat 1 Solar Power Plant | WRI1026264 | 6.1 | 15.191 | 102.345 | Solar | Solar Power (Korat 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.49 | 11.41 | 11.7 | 11.32 | 10.64 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21521 | 21521 | THA | Thailand | Korat 2 Solar Power Plant | WRI1026265 | 6.1 | 15.1945 | 102.3426 | Solar | Solar Power (Korat 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.49 | 11.41 | 11.7 | 11.32 | 10.64 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21522 | 21522 | THA | Thailand | Korat 3 Solar Power Plant | WRI1026266 | 6.1 | 15.6043 | 102.5591 | Solar | Solar Power (Korat 3) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.49 | 11.41 | 11.76 | 11.32 | 10.57 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21523 | 21523 | THA | Thailand | Korat 4 Solar Power Plant | WRI1026267 | 6.1 | 14.8181 | 102.1619 | Solar | Solar Power (Korat 4) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.45 | 11.5 | 12.23 | 11.28 | 10.66 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21524 | 21524 | THA | Thailand | Korat 5 Solar Power Plant | WRI1026268 | 7.4 | 15.554 | 102.5163 | Solar | Solar Power (Korat 5) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.88 | 13.84 | 14.25 | 13.75 | 12.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21525 | 21525 | THA | Thailand | Korat 6 Solar Power Plant | WRI1026269 | 7.4 | 14.9991 | 102.495 | Solar | Solar Power (Korat 6) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.88 | 13.84 | 14.39 | 13.72 | 12.85 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21526 | 21526 | THA | Thailand | Korat 7 Solar Power Plant | WRI1026270 | 6.1 | 15.1082 | 101.8871 | Solar | Solar Power (Korat 7) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.47 | 11.5 | 11.36 | 11.28 | 10.66 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21527 | 21527 | THA | Thailand | Korat 8 Solar Power Plant | WRI1026271 | 7.4 | 15.5538 | 102.5198 | Solar | Solar Power (Korat 8) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.88 | 13.84 | 14.25 | 13.75 | 12.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21528 | 21528 | THA | Thailand | Korat 9 Solar Power Plant | WRI1026272 | 7.4 | 14.8742 | 101.8093 | Solar | Solar Power (Korat 9) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.91 | 13.91 | 15.03 | 13.7 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21536 | 21536 | THA | Thailand | Loei 1 Solar Power Plant | WRI1026275 | 6.1 | 17.304 | 101.8491 | Solar | Solar Power (Loei 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.44 | 11.4 | 11.8 | 11.36 | 10.54 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21537 | 21537 | THA | Thailand | Loei 2 Solar Power Plant | WRI1026276 | 7.4 | 17.1992 | 101.8184 | Solar | Solar Power (Loei 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.83 | 13.87 | 14.31 | 13.79 | 12.91 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21538 | 21538 | THA | Thailand | Lopburi - AJ Solar Power Plant | WRI1026278 | 3.7 | 15.0851 | 101.0676 | Solar | AJ Technology Company Limited (AJ) | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 6.55 | 6.56 | 7.04 | 6.48 | 6.09 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21546 | 21546 | THA | Thailand | Lopburi - TP Solar Power Plant | WRI1026285 | 3.7 | 15.0851 | 101.0702 | Solar | Tipayanarai Company Limited (TP) | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 6.55 | 6.56 | 7.04 | 6.48 | 6.08 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21553 | 21553 | THA | Thailand | Nakhon Phanom 1 Solar Power Plant | WRI1026286 | 6.1 | 17.2988 | 104.4477 | Solar | Solar Power (Nakhon Phanom 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.43 | 11.4 | 11.77 | 11.3 | 10.71 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21554 | 21554 | THA | Thailand | Nakhon Phanom 2 Solar Power Plant | WRI1026287 | 7.4 | 17.298 | 104.4499 | Solar | Solar Power (Nakhon Phanom 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.86 | 13.82 | 14.27 | 13.73 | 13.03 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21555 | 21555 | THA | Thailand | Nakhon Phanom 3 Solar Power Plant | WRI1026288 | 7.4 | 16.8941 | 104.683 | Solar | Solar Power (Nakhon Phanom 3) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.91 | 13.84 | 14.31 | 13.75 | 12.92 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21563 | 21563 | THA | Thailand | Nong Khai 1 Solar Power Plant | WRI1026292 | 7.4 | 17.9447 | 104.0059 | Solar | Solar Power (Nong Khai 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.96 | 13.84 | 14.26 | 13.72 | 13.21 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21600 | 21600 | THA | Thailand | Sakon Nakhon 1 Solar Power Plant | WRI1026311 | 6.1 | 17.5326 | 103.4932 | Solar | Solar Power (Sakon Nakhon 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 11.53 | 10.86 | 11.75 | 11.43 | 10.65 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21601 | 21601 | THA | Thailand | Sakon Nakhon 2 Solar Power Plant | WRI1026312 | 7.6 | 17.4343 | 103.7255 | Solar | Solar Power (Sakon Nakhon 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 14.23 | 13.61 | 14.49 | 13.94 | 13.17 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21618 | 21618 | THA | Thailand | Surin 1 Solar Power Plant | WRI1026317 | 7.4 | 15.078 | 103.8864 | Solar | Solar Power (Surin 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.18 | 12.88 | 14.42 | 13.18 | 12.6 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21619 | 21619 | THA | Thailand | Surin 2 Solar Power Plant | WRI1026318 | 7.4 | 14.6283 | 103.8105 | Solar | Solar Power (Surin 2) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.51 | 12.94 | 14.2 | 13.31 | 12.6 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21620 | 21620 | THA | Thailand | Surin 3 Solar Power Plant | WRI1026319 | 7.4 | 15.3723 | 103.69 | Solar | Solar Power (Surin 3) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.19 | 12.88 | 14.16 | 13.07 | 12.6 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21638 | 21638 | THA | Thailand | Udon Thani - SPCG Solar Power Plant | WRI1026333 | 7.4 | 17.6954 | 102.4976 | Solar | Solar Power (Udon Thani 1) Company Limited | SPCG Public Company Limited | http://www.spcg.co.th/index.php/en/about | WRI | 13.94 | 13.14 | 14.31 | 13.65 | 12.94 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE |
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");