Data license: CC Attribution 4.0 License · Data source: World Resources Institute
This data as json, CSV (advanced)
Suggested facets: url, year_of_capacity_data
| 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 | estimated_generation_gwh |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3508 | 3508 | CAN | Canada | Beauharnois | CAN0002106 | 1877.0 | 45.3141 | -73.9088 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22599 | 2017 | 8900.157381356663 | |||||||||
| 3509 | 3509 | CAN | Canada | Beaumont | CAN0002107 | 270.0 | 47.5561 | -72.8362 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22598 | 2017 | 1280.2570553896105 | |||||||||
| 3520 | 3520 | CAN | Canada | Bersimis-1 | CAN0002109 | 1178.0 | 49.2947 | -69.5514 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22600 | 2017 | 5585.714115736893 | |||||||||
| 3521 | 3521 | CAN | Canada | Bersimis-2 | CAN0002110 | 869.0 | 49.1754 | -69.2263 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 4120.53104123545 | ||||||||||
| 3563 | 3563 | CAN | Canada | Brisay | CAN0002118 | 469.0 | 54.4491 | -70.5121 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22604 | 2017 | 2223.8539221397314 | |||||||||
| 3573 | 3573 | CAN | Canada | Bryson | CAN0007710 | 56.0 | 45.6611 | -76.6318 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22603 | 2017 | 265.5347966734007 | |||||||||
| 3584 | 3584 | CAN | Canada | Bécancour (HQ) | CAN0002025 | 411.0 | 46.3919 | -72.3523 | Gas | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 1274.4564448307926 | ||||||||||
| 3603 | 3603 | CAN | Canada | Carillon | CAN0002119 | 753.0 | 45.5687 | -74.383 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22606 | 2017 | 3570.4946766976923 | |||||||||
| 3635 | 3635 | CAN | Canada | Chelsea | CAN0002126 | 152.0 | 45.5125 | -75.7775 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22613 | 2017 | 720.7373052563732 | |||||||||
| 3647 | 3647 | CAN | Canada | Chute-Allard | CAN0007761 | 62.0 | 47.8929 | -73.7183 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 54301 | 2017 | 293.9849534598365 | |||||||||
| 3648 | 3648 | CAN | Canada | Chute-Bell | CAN0007763 | 10.0 | 45.774 | -74.6844 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22607 | 2017 | 47.41692797739298 | |||||||||
| 3650 | 3650 | CAN | Canada | Chute-Burroughs | CAN0007765 | 1.6 | 45.1463 | -72.0186 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22608 | 2016 | 7.586708476382878 | |||||||||
| 3651 | 3651 | CAN | Canada | Chute-Hemmings | CAN0007768 | 29.0 | 45.8632 | -72.4502 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22611 | 2017 | 137.50909113443964 | |||||||||
| 3719 | 3719 | CAN | Canada | Drummondville | CAN0007820 | 16.0 | 45.8869 | -72.4841 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22615 | 2017 | 75.86708476382876 | |||||||||
| 3735 | 3735 | CAN | Canada | Eastmain-1 | CAN0002143 | 480.0 | 52.1818 | -76.051 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22616 | 2017 | 2276.012542914863 | |||||||||
| 3736 | 3736 | CAN | Canada | Eastmain-1-A | CAN0002144 | 768.0 | 52.1793 | -76.0418 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 54303 | 2017 | 3641.6200686637812 | |||||||||
| 3823 | 3823 | CAN | Canada | Grand-Mère | CAN0007911 | 67.0 | 46.6152 | -72.6793 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22620 | 2017 | 317.69341744853295 | |||||||||
| 3856 | 3856 | CAN | Canada | Hart-Jaune | CAN0007932 | 51.0 | 51.7849 | -67.9119 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22621 | 2017 | 241.82633268470417 | |||||||||
| 3906 | 3906 | CAN | Canada | Jean-Lesage (Manic-2) | CAN0002160 | 1229.0 | 49.3213 | -68.3467 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22650 | 2017 | 5827.540448421598 | |||||||||
| 3949 | 3949 | CAN | Canada | La Gabelle | CAN0002172 | 131.0 | 46.4491 | -72.7393 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22631 | 2017 | 621.1617565038481 | |||||||||
| 3950 | 3950 | CAN | Canada | La Grande-1 | CAN0002173 | 1436.0 | 53.7323 | -78.5712 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22638 | 2017 | 6809.070857553632 | |||||||||
| 3951 | 3951 | CAN | Canada | La Grande-2-A | CAN0002174 | 2106.0 | 53.7808 | -77.5483 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22635 | 2017 | 9986.005032038962 | |||||||||
| 3952 | 3952 | CAN | Canada | La Grande-3 | CAN0002175 | 2417.0 | 53.7274 | -75.9874 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 11460.671492135883 | ||||||||||
| 3953 | 3953 | CAN | Canada | La Grande-4 | CAN0002176 | 2779.0 | 53.8864 | -73.466 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22633 | 2017 | 13177.16428491751 | |||||||||
| 3956 | 3956 | CAN | Canada | La Tuque | CAN0002177 | 294.0 | 47.4446 | -72.7987 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22632 | 2017 | 1394.0576825353535 | |||||||||
| 3959 | 3959 | CAN | Canada | Lac-Robertson | CAN0008025 | 22.0 | 50.9989 | -59.0621 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22637 | 2017 | 104.31724155026457 | |||||||||
| 3964 | 3964 | CAN | Canada | Laforge-1 | CAN0002179 | 878.0 | 54.1693 | -72.6146 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22640 | 2017 | 4163.206276415104 | |||||||||
| 3965 | 3965 | CAN | Canada | Laforge-2 | CAN0002180 | 319.0 | 54.5909 | -71.2787 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 1512.6000024788361 | ||||||||||
| 3984 | 3984 | CAN | Canada | Les Cèdres | CAN0002182 | 113.0 | 45.3089 | -74.0273 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22648 | 2017 | 535.8112861445408 | |||||||||
| 4027 | 4027 | CAN | Canada | Manic-1 | CAN0002188 | 184.0 | 49.1913 | -68.3294 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 872.4714747840309 | ||||||||||
| 4028 | 4028 | CAN | Canada | Manic-5 | CAN0002189 | 1596.0 | 50.6398 | -68.7267 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22652 | 2017 | 7567.741705191919 | |||||||||
| 4029 | 4029 | CAN | Canada | Manic-5-PA | CAN0002190 | 1064.0 | 50.6467 | -68.7395 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22652 | 2017 | 5045.161136794613 | |||||||||
| 4063 | 4063 | CAN | Canada | Mercier | CAN0008114 | 55.0 | 46.7173 | -75.9825 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 53524 | 2017 | 260.7931038756614 | |||||||||
| 4089 | 4089 | CAN | Canada | Mitis-1 | CAN0008136 | 6.0 | 48.6036 | -68.1376 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22656 | 2017 | 28.45015678643579 | |||||||||
| 4090 | 4090 | CAN | Canada | Mitis-2 | CAN0008137 | 4.0 | 48.6219 | -68.1378 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 18.966771190957196 | ||||||||||
| 4165 | 4165 | CAN | Canada | Outardes-2 | CAN0002202 | 523.0 | 49.1448 | -68.3894 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22658 | 2017 | 2479.9053332176527 | |||||||||
| 4166 | 4166 | CAN | Canada | Outardes-3 | CAN0002203 | 1026.0 | 49.5576 | -68.7256 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22662 | 2017 | 4864.97681048052 | |||||||||
| 4167 | 4167 | CAN | Canada | Outardes-4 | CAN0002204 | 785.0 | 49.7037 | -68.9038 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22660 | 2017 | 3722.228846225349 | |||||||||
| 4174 | 4174 | CAN | Canada | Paugan | CAN0002205 | 226.0 | 45.8097 | -75.9309 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22659 | 2017 | 1071.6225722890815 | |||||||||
| 4225 | 4225 | CAN | Canada | Première-Chute | CAN0002211 | 131.0 | 47.6007 | -79.4524 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22664 | 2017 | 621.1617565038481 | |||||||||
| 4234 | 4234 | CAN | Canada | Péribonka | CAN0002207 | 385.0 | 49.5077 | -71.1824 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 1825.5517271296296 | ||||||||||
| 4249 | 4249 | CAN | Canada | Rapide-2 | CAN0008268 | 67.0 | 47.9336 | -78.5761 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 317.69341744853295 | ||||||||||
| 4250 | 4250 | CAN | Canada | Rapide-7 | CAN0008269 | 67.0 | 47.7685 | -78.3102 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22675 | 2017 | 317.69341744853295 | |||||||||
| 4251 | 4251 | CAN | Canada | Rapide-Blanc | CAN0002214 | 204.0 | 47.7964 | -72.9735 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22670 | 2017 | 967.3053307388167 | |||||||||
| 4252 | 4252 | CAN | Canada | Rapide-des-Cœurs | CAN0008271 | 76.0 | 47.7866 | -73.3753 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 54302 | 2017 | 360.3686526281866 | |||||||||
| 4253 | 4253 | CAN | Canada | Rapides-Farmer | CAN0002217 | 104.0 | 45.4989 | -75.7632 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22673 | 2017 | 493.13605096488703 | |||||||||
| 4255 | 4255 | CAN | Canada | Rapides-des-Quinze | CAN0002216 | 103.0 | 47.5906 | -79.2944 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22669 | 2017 | 488.3943581671477 | |||||||||
| 4256 | 4256 | CAN | Canada | Rapides-des-Îles | CAN0002215 | 176.0 | 47.5768 | -79.3546 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22672 | 2017 | 834.5379324021167 | |||||||||
| 4266 | 4266 | CAN | Canada | René-Lévesque (Manic-3) | CAN0002218 | 1326.0 | 49.7408 | -68.5945 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 6287.48464980231 | ||||||||||
| 4276 | 4276 | CAN | Canada | Rivière-des-Prairies | CAN0008295 | 54.0 | 45.5895 | -73.6572 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22671 | 2017 | 256.05141107792207 | |||||||||
| 4280 | 4280 | CAN | Canada | Robert-Bourassa | CAN0002223 | 5616.0 | 53.7818 | -77.5305 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22636 | 2017 | 26629.34675210389 | |||||||||
| 4285 | 4285 | CAN | Canada | Romaine-2 | CAN0002226 | 640.0 | 50.6246 | -63.1941 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 55841 | 2017 | 3034.683390553151 | |||||||||
| 4307 | 4307 | CAN | Canada | Saint-Narcisse | CAN0008327 | 15.0 | 46.5484 | -72.4102 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 38120 | 2017 | 71.12539196608947 | |||||||||
| 4338 | 4338 | CAN | Canada | Sept-Chutes | CAN0008349 | 22.0 | 47.1227 | -70.8286 | Hydro | Hydro-Québec | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22679 | 2017 | 104.31724155026457 | |||||||||
| 4346 | 4346 | CAN | Canada | Shawinigan-2 | CAN0002234 | 200.0 | 46.5359 | -72.7673 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22681 | 2017 | 948.3385595478596 | |||||||||
| 4347 | 4347 | CAN | Canada | Shawinigan-3 | CAN0002235 | 194.0 | 46.5338 | -72.7656 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22683 | 2017 | 919.8884027614238 | |||||||||
| 4483 | 4483 | CAN | Canada | Toulnustouc | CAN0002250 | 526.0 | 49.9705 | -68.1591 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 45849 | 2017 | 2494.130411610871 | |||||||||
| 4486 | 4486 | CAN | Canada | Trenche | CAN0002251 | 302.0 | 47.7521 | -72.8783 | Hydro | Hydro-Québec | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 22688 | 2017 | 1431.991224917268 |
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,
"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");