global-power-plants

Table actions

2,155 rows where country_long = "France"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, url, geolocation_source

primary_fuel 10

owner 2

country_long 1

  • France · 2,155 ✖
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_data_source estimated_generation_gwh
10290 10290 FRA France ARRIGHI WRI1002687 254.0 48.7872 2.4033 Oil           RTE Transmission Operator http://clients.rte-france.com/lang/an/visiteurs/vie/prod/parc_reference.jsp CARMA 1014623       9.619 6.997999999999999 35.608000000000004 JRC-PPDB-OPEN 104.54056517775751
10291 10291 FRA France ASTON WRI1002688 104.0 42.777 1.677 Hydro           RTE Transmission Operator http://clients.rte-france.com/lang/an/visiteurs/vie/prod/parc_reference.jsp GEODB 1014631               365.89687962181887
10292 10292 FRA France AVIGNON WRI1002689 126.0 43.976 4.817 Hydro           RTE Transmission Operator http://clients.rte-france.com/lang/an/visiteurs/vie/prod/parc_reference.jsp GEODB 1013202               443.29814261874213
10293 10293 FRA France Ablaincourt-Pressoir WRI1024142 14.35 49.8414 2.8247 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 27.31250148963351
10294 10294 FRA France Ablainzevelle WRI1024534 10.0 50.1529 2.741 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1086105               19.033102083368302
10295 10295 FRA France Achiet-le-Grand WRI1024086 18.0 50.1327 2.7791 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 34.259583750062944
10296 10296 FRA France Adriers WRI1024549 10.0 46.2644 0.7899 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1117240               19.033102083368302
10297 10297 FRA France Agde WRI1025639 1.1595600000000001 43.3094 3.4846 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.3953682630212478
10298 10298 FRA France Agenville WRI1024852 6.0 50.1715 2.1079 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1060745               11.41986125002098
10299 10299 FRA France Aghione WRI1024646 8.53314 42.0986 9.4119 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 10.268440391111396
10300 10300 FRA France Aghione 2 WKS0070583 4.0 42.0849 9.3986 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 4.813440487844519
10301 10301 FRA France Aghione 3 WKS0069592 12.0 42.096 9.4 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.44032146353356
10302 10302 FRA France Agos-Vidalos WRI1025409 1.6 43.0398 -0.0753 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1029232               5.629182763412597
10303 10303 FRA France Aigaliers WKS0069049 10.9 44.068 4.307 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 13.116625329376314
10304 10304 FRA France Aigrefeuille-d'Aunis WRI1025241 2.1855599999999997 46.1165 -0.9444 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 2.6300157481533675
10305 10305 FRA France Aiguillon WRI1025631 1.177 44.3009 0.3577 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.140967570335393
10306 10306 FRA France Aiguillon WRI1025153 2.57727 44.3009 0.3577 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 3.1013839415267617
10307 10307 FRA France Airaines WRI1024338 12.0 49.972 1.9449 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1099359               22.83972250004196
10308 10308 FRA France Airan WRI1024699 8.0 49.0948 -0.146 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 15.22648166669464
10309 10309 FRA France Aire-sur-l'Adour WRI1025227 2.23527 43.6991 -0.2643 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 2.6898347798160547
10310 10310 FRA France Aix-en-Provence WRI1024988 4.245 43.5361 5.3984 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 16.677933383800138
10311 10311 FRA France Aix-en-Provence WRI1024662 8.361189999999999 43.5361 5.3984 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 10.061522618140181
10312 10312 FRA France Aizenay WRI1025506 1.36627 46.7385 -1.6268 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.6441148338318332
10313 10313 FRA France Ajaccio WRI1025231 2.20953 41.9349 8.7013 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 2.658860290276776
10314 10314 FRA France Albaret-le-Comtal WRI1024376 11.68 44.8674 3.1442 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 41.093034172911956
10315 10315 FRA France Albas WRI1025341 1.8 44.4614 1.2406 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1033916               6.332830608839173
10316 10316 FRA France Albi WRI1024790 6.70448 43.9257 2.1475 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 8.067903870485956
10317 10317 FRA France Albias WRI1025181 2.41 44.0818 1.4485 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 2.900097893926324
10318 10318 FRA France Allaire WRI1024682 8.2 47.6396 -2.1774 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 15.607143708362004
10319 10319 FRA France Allanche WRI1024004 24.0 45.2312 2.9535 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 45.67944500008392
10320 10320 FRA France Allemant WRI1025560 1.26 49.4624 3.4535 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.950340651021949
10321 10321 FRA France Allement WRI1026697 32.0 46.112 5.422 Hydro       1960.0 EDF EDF https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower GEODB 1014609               112.58365526825196
10322 10322 FRA France Allemond WRI1024888 5.3 45.1704 6.0178 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 18.646667903804232
10323 10323 FRA France Allery WRI1024949 4.6 49.9596 1.8856 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 8.755226958349416
10324 10324 FRA France Allibaudières WRI1023962 35.0 48.6071 4.1483 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 66.61585729178907
10325 10325 FRA France Allondrelle-la-Malmaison WRI1024436 10.76 49.5112 5.5684 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 20.47961784170429
10326 10326 FRA France Allones 1 WKS0069059 4.5 47.945 0.151 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 5.415120548825085
10327 10327 FRA France Allonnes WRI1023946 52.275 48.3407 1.676 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1089247               99.4955411408078
10328 10328 FRA France Alluyes WRI1024260 12.0 48.229 1.3648 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 22.83972250004196
10329 10329 FRA France Ally WRI1023971 31.5 45.1733 3.3009 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 59.95427156261014
10330 10330 FRA France Alès WRI1025057 3.5015 44.1254 4.0888 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.213565467046896
10331 10331 FRA France Aléria WRI1025040 3.6619800000000002 42.1061 9.496 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1096487               4.406680699419219
10332 10332 FRA France Amanty WRI1024201 12.3 48.5156 5.605 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 23.41071556254301
10333 10333 FRA France Amanvillers WRI1025738 1.06 49.1599 6.0462 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.164572293716878
10334 10334 FRA France Ambarès-et-Lagrave WRI1025710 1.08202 44.9438 -0.5008 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.3020597191643821
10335 10335 FRA France Ambon WRI1024484 10.02 47.5576 -2.5395 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 19.071168287535034
10336 10336 FRA France Ambonville WRI1024520 10.0 48.3139 5.0106 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 19.033102083368302
10337 10337 FRA France Ambricourt WRI1025017 4.0 50.4662 2.1709 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 7.61324083334732
10338 10338 FRA France Ambrières-les-Vallées WRI1025492 1.4 48.4228 -0.6245 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.925534917986023
10339 10339 FRA France Amelécourt WRI1024304 12.0 48.8406 6.4881 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1069062               22.83972250004196
10340 10340 FRA France Amiens WRI1025116 2.83 49.9003 2.2907 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 11.118622255866756
10341 10341 FRA France Anetz WRI1025740 1.05656 47.3811 -1.0942 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.2714221704592514
10342 10342 FRA France Angers WRI1025673 1.11625 47.4766 -0.5561 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.3432507361391113
10343 10343 FRA France Anglet WRI1025154 2.57113 43.4912 -1.5157 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 3.0939953103779203
10344 10344 FRA France Angoulême WRI1025736 1.06144 45.6476 0.145 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.277294567854422
10345 10345 FRA France Anost WRI1025313 1.9 47.0767 4.0922 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 6.68465453155246
10346 10346 FRA France Anoux WRI1024466 10.25 49.2733 5.8648 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 19.50892963545251
10347 10347 FRA France Ansauvillers WRI1024395 11.5 49.567 2.3874 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 21.888067395873545
10348 10348 FRA France Anse-Bertrand WRI1025102 3.025 16.4653 -61.4621 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 5.75751338021891
10349 10349 FRA France Antibes WRI1024408 11.44 43.5876 7.1054 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 44.945950037850075
10350 10350 FRA France Antoigné WRI1024711 8.0 47.0785 -0.1322 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1114804               15.22648166669464
10351 10351 FRA France Appietto WRI1024933 4.749280000000001 42.0034 8.7342 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 5.715094160027555
10352 10352 FRA France Apprieu WKS0069114 10.2 45.378 5.485 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 12.274273244003524
10353 10353 FRA France Apremont WRI1025548 1.29408 46.7576 -1.749 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.5572442666274589
10354 10354 FRA France Aragnouet WRI1024461 10.255 42.7845 0.1782 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 36.079543274247634
10355 10355 FRA France Arbéost WRI1025289 2.0 42.9795 -0.2738 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 7.036478454265748
10356 10356 FRA France Arcambal WRI1025185 2.4 44.4548 1.5482 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 8.443774145118898
10357 10357 FRA France Arconcey WRI1024253 12.0 47.216 4.4614 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 22.83972250004196
10358 10358 FRA France Ardeche ULM WKS0069136 12.0 44.545 4.369 Solar           Wiki-Solar https://www.wiki-solar.org Wiki-Solar                 14.44032146353356
10359 10359 FRA France Ardin WRI1024622 9.0 46.4813 -0.555 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1101598               17.129791875031472
10360 10360 FRA France Ardouval WRI1024327 12.0 49.7414 1.2723 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1103899               22.83972250004196
10361 10361 FRA France Arette WRI1025588 1.228 43.0403 -0.7361 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1113550               4.320397770919168
10362 10362 FRA France Arfons WRI1024032 22.0 43.4241 2.1895 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 41.87282458341026
10363 10363 FRA France Argancy WRI1024998 4.1 49.1984 6.2102 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1032284               14.424780831244783
10364 10364 FRA France Argentat WRI1026718 47.5 45.104 1.954 Hydro       1957.0 EDF EDF https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower GEODB 1014617               167.11636328881153
10365 10365 FRA France Argenteuil WRI1024458 10.3 48.9518 2.2406 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 40.467070401211174
10366 10366 FRA France Argentiere-La Bessee WRI1026703 38.0 44.783 6.548 Hydro       1977.0 EDF EDF https://www.edf.fr/en/the-edf-group/industrial-provider/renewable-energies/hydropower GEODB 1014818               133.69309063104922
10367 10367 FRA France Argentine WRI1024814 6.2860000000000005 45.4894 6.3328 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1025347               22.115651781757244
10368 10368 FRA France Arles WRI1024606 9.07405 43.5468 4.6617 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 10.919349914681392
10369 10369 FRA France Arlos WRI1024887 5.3 42.8744 0.6955 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1014619               18.646667903804232
10370 10370 FRA France Arpajon-sur-Cère WRI1024971 4.41 44.8759 2.4647 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 17.326192278576826
10371 10371 FRA France Arpajon-sur-Cère WRI1024413 11.27645 44.8759 2.4647 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 13.569630247288588
10372 10372 FRA France Arques WRI1024626 8.9 50.7409 2.3196 Biomass           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 34.96669190007567
10373 10373 FRA France Arras-sur-Rhône WRI1024989 4.24212 45.1433 4.8038 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 5.1047980405737485
10374 10374 FRA France Arreau WRI1024447 10.495 42.9143 0.3356 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 36.92392068875951
10375 10375 FRA France Arsac WRI1023947 48.23768 44.9837 -0.7447 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1108926               58.047300487921966
10376 10376 FRA France Artemare WRI1024954 4.543 45.8699 5.6901 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1113325               15.983360808864644
10377 10377 FRA France Artemps WRI1024478 10.12 49.7615 3.1974 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 19.26149930836872
10378 10378 FRA France Artouste WRI1026741 88.0 42.887 -0.411 Hydro       1947.0 GDF-SUEZ GDF Suez https://www.google.com/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwjEnZCx08nRAhWg0YMKHTOPA44QFggaMAA&url=https%3A%2F%2Fwww.engie.com%2Fwp-content%2Fuploads%2F2014%2F08%2Fgdf-suez-analyst-pack-h1-2014-vdef.xlsx&usg=AFQjCNGc2ScgE-1yvO4z_L-JlmOchrj8JA&sig2=xPDWHDRk2KIN7MmJspH6Bg&bvm=bv.144224172 d.amc&cad=rja GEODB 1029234               309.6050519876929
10379 10379 FRA France Arudy WRI1025651 1.148 43.1005 -0.4746 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 4.038938632748539
10380 10380 FRA France Arvillard WRI1024651 8.5 45.4095 6.1709 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1021845               29.90503343062943
10381 10381 FRA France Assac WRI1024060 20.0 43.9786 2.4342 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1078785               38.066204166736604
10382 10382 FRA France Assigny WRI1024328 12.0 49.9828 1.287 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1074606               22.83972250004196
10383 10383 FRA France Aste-Béon WRI1025671 1.12 43.0303 -0.3973 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 3.940427934388819
10384 10384 FRA France Aubagne WRI1025163 2.5022 43.2936 5.5633 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1112628               3.0110476971711404
10385 10385 FRA France Aubas WRI1025665 1.126 45.0792 1.1985 Hydro           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data 1056255               3.9615373697516163
10386 10386 FRA France Aubenas WRI1025513 1.3489 44.6103 4.3957 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.6232124685133682
10387 10387 FRA France Aubergenville WRI1024438 10.68047 48.9629 1.8494 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 12.852451681802187
10388 10388 FRA France Aubigny WRI1024443 10.5 48.914 -0.2155 Wind           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 19.984757187536715
10389 10389 FRA France Aubusson WRI1025428 1.5483200000000001 45.9509 2.1665 Solar           Open Power System Data http://data.open-power-system-data.org/renewable_power_plants/2016-10-21/ Open Power System Data                 1.8631865440348565

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");