global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
141 rows where country_long = "Thailand" and primary_fuel = "Solar" sorted by estimated_generation_gwh_2014
This data as json, CSV (advanced)
owner 17
- Solarco Company Limited 3
- Bangchak Solar Energy Company Limited (BSE) 2
- Bangkok Solar Power Company Limited (BSP) 2
- EA Solar Lopburi Company Limited 2
- Gunkul Chubu Powergen Company Limited 2
- Natural Energy Development Co Ltd (NED) 2
- Soleq Private Limited 2
- Ch. Karnchang Public Company Limited 1
- Chiangrai Solar Company Limited 1
- EA Solar Lampang Company Limited 1
- EA Solar Nakornsawan Company Limited 1
- SPP Two Co Ltd (SPP 2) 1
- SSE-PV1 Project 1
- SSE-PV7 Project 1
- SSE-PV8 Project 1
- Siam Solar Generation Company Limited 1
- Solarta Co Ltd 1
primary_fuel 1
- Solar · 41 ✖
country_long 1
- Thailand · 41 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
21495 | 21495 | THA | Thailand | Had Siao | WKS0062083 | 8.0 | 17.509 | 99.795 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.73 | 14.64 | 15.9 | 14.68 | 14.54 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21608 | 21608 | THA | Thailand | Si Maha Phot II | WKS0066095 | 8.0 | 13.925 | 101.52 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.72 | 14.64 | 15.87 | 14.63 | 13.73 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21588 | 21588 | THA | Thailand | Sa Kaeo | WKS0066275 | 8.0 | 13.8 | 102.3 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.59 | 14.66 | 14.56 | 14.64 | 13.33 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21604 | 21604 | THA | Thailand | Saraburi - SPP2 Solar Power Plant | WRI1026314 | 8.0 | 14.8211 | 101.1153 | Solar | SPP Two Co Ltd (SPP 2) | Astroenergy Development | http://www.astronergydevelopment.com/projects1.asp?parid=11&classid=21 | WRI | 14.71 | 14.71 | 15.91 | 14.56 | 13.71 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21612 | 21612 | THA | Thailand | Sri Chula Solar Power Plant | WRI1026316 | 8.0 | 14.0278 | 101.1862 | Solar | Gunkul Chubu Powergen Company Limited | Gunkul Chubu Powergen Company Limited | http://www.gunkul.com | WRI | 1093377 | 14.72 | 14.72 | 15.91 | 14.64 | 13.69 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21648 | 21648 | THA | Thailand | Wichian Buri Solar Power Plant | WRI1026338 | 8.0 | 15.6799 | 101.0486 | Solar | Gunkul Chubu Powergen Company Limited | Gunkul Chubu Powergen Company Limited | http://www.gunkul.com | WRI | 1096511 | 14.71 | 14.73 | 14.32 | 14.59 | 13.66 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21485 | 21485 | THA | Thailand | Di Lang | WKS0062044 | 8.0 | 14.936 | 100.936 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.71 | 14.74 | 15.91 | 14.59 | 13.6 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21539 | 21539 | THA | Thailand | Lopburi - Absolute Energy Solar Power Plant | WRI1026277 | 8.0 | 14.9332 | 100.9352 | Solar | EA Solar Lopburi Company Limited | Energy Absolute | http://www.energyabsolute.co.th/index.php | WRI | 14.71 | 14.74 | 15.91 | 14.59 | 13.6 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21576 | 21576 | THA | Thailand | Phran Kratai I | WKS0065888 | 8.0 | 16.638 | 99.597 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.41 | 14.74 | 16.13 | 14.7 | 14.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21577 | 21577 | THA | Thailand | Phran Kratai II | WKS0065887 | 8.0 | 16.637 | 99.602 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.41 | 14.74 | 16.13 | 14.7 | 14.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21579 | 21579 | THA | Thailand | Phran Kratai IV | WKS0065890 | 8.0 | 16.678 | 99.567 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.21 | 14.74 | 15.84 | 14.7 | 14.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21607 | 21607 | THA | Thailand | Si Maha Phot I | WKS0066094 | 8.0 | 13.815 | 101.605 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.59 | 14.74 | 14.52 | 14.64 | 13.41 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21644 | 21644 | THA | Thailand | Wang Phloeng Solar Power Plant | WRI1026337 | 8.0 | 15.0538 | 100.8859 | Solar | Natural Energy Development Co Ltd (NED) | Natural Energy Development Company | http://www.ned.co.th | WRI | 14.71 | 14.74 | 15.87 | 14.59 | 13.66 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21470 | 21470 | THA | Thailand | Bo-Thong | WKS0062040 | 8.3 | 13.964 | 101.833 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 14.93 | 14.84 | 15.57 | 14.96 | 13.73 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21482 | 21482 | THA | Thailand | Chongdan Solar Power Plant | WRI1026237 | 8.0 | 14.3552 | 99.4692 | Solar | SSE-PV1 Project | Thai Solar Energy Public Company Limited (TSE) | http://www.thaisolarenergy.com/project.php?menu=future_projects | WRI | 14.77 | 15.41 | 15.11 | 14.26 | 15.01 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21625 | 21625 | THA | Thailand | Tha Muang Solar Power Plant | WRI1026323 | 8.0 | 13.8731 | 99.5024 | Solar | SSE-PV7 Project | Thai Solar Energy Public Company Limited (TSE) | http://www.thaisolarenergy.com/project.php?menu=future_projects | WRI | 14.05 | 15.41 | 15.01 | 14.2 | 14.93 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21572 | 21572 | THA | Thailand | Phanom Thuan Solar Power Plant | WRI1026297 | 8.0 | 14.22 | 99.7341 | Solar | SSE-PV8 Project | Thai Solar Energy Public Company Limited (TSE) | http://www.thaisolarenergy.com/project.php?menu=future_projects | WRI | 14.65 | 15.44 | 15.48 | 14.68 | 14.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21605 | 21605 | THA | Thailand | Saraburi SPP2 | WKS0061813 | 9.5 | 14.7771 | 101.0988 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 17.37 | 17.35 | 18.42 | 17.19 | 16.31 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21641 | 21641 | THA | Thailand | Wang Man 1 Solar Power Plant | WRI1026335 | 10.2 | 17.1824 | 99.1278 | Solar | Soleq Private Limited | Thai Solar Energy Public Company Limited (TSE) | http://www.soleq.com | WRI | 18.18 | 17.41 | 17.98 | 17.59 | 17.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21642 | 21642 | THA | Thailand | Wang Man 2 Solar Power Plant | WRI1026336 | 10.2 | 17.18 | 99.1214 | Solar | Soleq Private Limited | Soleq | http://www.soleq.com | WRI | 18.18 | 17.41 | 17.98 | 17.54 | 17.87 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21598 | 21598 | THA | Thailand | Sai Yai - Solarta Solar Power Plant | WRI1026309 | 9.7 | 14.1385 | 100.1506 | Solar | Solarta Co Ltd | Ratchaburi | http://investor.ratch.co.th/factsheet.html | WRI | 17.33 | 17.71 | 17.62 | 17.56 | 16.79 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21505 | 21505 | THA | Thailand | Khao Yao Solar Power Plant | WRI1026252 | 10.0 | 13.2753 | 99.7788 | Solar | Bangkok Solar Power Company Limited (BSP) | Bangkok Solar Power | http://www.bangkoksolarpower.com/en/reference_project | WRI | 17.39 | 18.0 | 17.35 | 18.14 | 17.8 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21530 | 21530 | THA | Thailand | Kui Buri Solar Power Plant | WRI1026273 | 10.0 | 12.0473 | 99.829 | Solar | Bangkok Solar Power Company Limited (BSP) | Bangkok Solar Power | http://www.bangkoksolarpower.com/en/reference_project | WRI | 17.62 | 18.16 | 17.76 | 18.03 | 16.46 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21549 | 21549 | THA | Thailand | Mae Chan | WKS0062076 | 9.5 | 20.225 | 99.975 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 17.84 | 18.17 | 18.47 | 18.11 | 17.04 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21481 | 21481 | THA | Thailand | Chiang Rai Solar Power Plant | WRI1026235 | 9.5 | 20.1684 | 100.0202 | Solar | Chiangrai Solar Company Limited | Sonnedix | http://www.sonnedix.com/power-plants/list-of-plants/operating/ | WRI | 1086241 | 17.93 | 18.19 | 18.41 | 18.07 | 17.36 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21497 | 21497 | THA | Thailand | Horseshoe Point | WKS0061727 | 12.0 | 12.8789 | 100.971 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 23.19 | 23.24 | 27.04 | 22.21 | 22.73 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21590 | 21590 | THA | Thailand | Sai Kyo Solar Power Plant | WRI1026301 | 11.9 | 14.1542 | 100.1377 | Solar | Solarco Company Limited | EGCO | http://www.egco.com/en/corperate_com_press_detail.asp?press_id=206&iYear=2014 | WRI | 23.28 | 24.67 | 26.43 | 22.18 | 23.43 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21506 | 21506 | THA | Thailand | Khok Thai Solar Power Plant | WRI1026253 | 12.7 | 14.7635 | 102.0694 | Solar | Ch. Karnchang Public Company Limited | CH Karnchang | http://www.ch-karnchang.co.th/th/#/project/detail/73/พลังงาน-โครงการผลิตไฟฟ้าจากพลังงานแสงอาทิตย์ในจังหวัดนครราชสีมา | WRI | 24.77 | 24.79 | 28.41 | 23.52 | 24.14 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21459 | 21459 | THA | Thailand | Bamnet Narong - BSE Solar Power Plant | WRI1026224 | 16.0 | 15.4211 | 101.6985 | Solar | Bangchak Solar Energy Company Limited (BSE) | Bangchak Solar Energy Company Limited (BSE) | http://www.bangchak.co.th | WRI | 1090294 | 31.3 | 31.27 | 33.43 | 29.37 | 30.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21468 | 21468 | THA | Thailand | Bangchak Solar Power Plant | WRI1026229 | 16.0 | 14.1691 | 100.5528 | Solar | Bangchak Solar Energy Company Limited (BSE) | Bangchak Solar Energy Company Limited (BSE) | http://www.bangchak.co.th | WRI | 31.36 | 31.42 | 35.75 | 29.38 | 30.34 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21460 | 21460 | THA | Thailand | Bamnet Narong - BSP Solar Power Plant | WRI1026225 | 22.5 | 15.445 | 101.7882 | Solar | Siam Solar Generation Company Limited | Bangkok Solar Power | http://www.bangkoksolarpower.com/en/reference_project | WRI | 1090294 | 43.29 | 42.92 | 46.6 | 40.5 | 41.5 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21467 | 21467 | THA | Thailand | Bangchak III | WKS0063636 | 25.0 | 14.169 | 100.553 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 48.7 | 48.92 | 57.44 | 45.34 | 46.48 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21597 | 21597 | THA | Thailand | Sai Yai - Solarco Solar Power Plant | WRI1026308 | 23.8 | 14.1368 | 100.1432 | Solar | Solarco Company Limited | EGCO | http://www.egco.com/en/corperate_com_press_detail.asp?press_id=206&iYear=2014 | WRI | 1103310 | 46.02 | 49.6 | 53.9 | 43.17 | 45.71 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21455 | 21455 | THA | Thailand | Ang Thong | WKS0067792 | 24.0 | 11.425 | 99.565 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 46.21 | 50.22 | 54.59 | 43.01 | 44.14 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21591 | 21591 | THA | Thailand | Sai Phet Solar Power Plant | WRI1026302 | 35.9 | 14.1078 | 100.1744 | Solar | Solarco Company Limited | EGCO | http://www.egco.com/en/corperate_com_press_detail.asp?press_id=206&iYear=2014 | WRI | 71.98 | 78.03 | 84.56 | 67.11 | 70.99 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21547 | 21547 | THA | Thailand | Lopburi SSP | WKS0063763 | 40.0 | 15.011 | 100.693 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 79.73 | 79.73 | 93.49 | 73.69 | 76.32 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21580 | 21580 | THA | Thailand | Prakhon Chai | WKS0065025 | 50.0 | 14.61 | 103.045 | Solar | Wiki-Solar | https://www.wiki-solar.org | Wiki-Solar | 95.49 | 91.11 | 106.8 | 89.33 | 91.72 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||||
21544 | 21544 | THA | Thailand | Lopburi - NED Solar Power Plant | WRI1026283 | 55.0 | 15.0497 | 100.8976 | Solar | Natural Energy Development Co Ltd (NED) | Natural Energy Development Company | http://www.ned.co.th | WRI | 108.6 | 108.69 | 127.56 | 100.42 | 103.2 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21574 | 21574 | THA | Thailand | Phitsanulok Solar Power Plant | WRI1026299 | 90.0 | 17.0713 | 100.118 | Solar | EA Solar Lopburi Company Limited | Energy Absolute | http://www.energyabsolute.co.th/index.php | WRI | 1106433 | 180.63 | 178.58 | 198.29 | 166.87 | 176.46 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
21557 | 21557 | THA | Thailand | Nakhon Sawan Solar Power Plant | WRI1026290 | 90.0 | 15.3671 | 100.301 | Solar | EA Solar Nakornsawan Company Limited | Energy Absolute | http://www.energyabsolute.co.th/index.php | WRI | 179.43 | 180.76 | 208.18 | 167.34 | 176.02 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
21534 | 21534 | THA | Thailand | Lampang Solar Power Plant | WRI1026274 | 90.0 | 18.3931 | 99.4215 | Solar | EA Solar Lampang Company Limited | Energy Absolute | http://www.energyabsolute.co.th/index.php | WRI | 197.6 | 186.17 | 211.41 | 183.32 | 190.87 | 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");