global-power-plants

Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette

58 rows where owner = "Hydro-Québec"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: url, year_of_capacity_data

primary_fuel

owner

  • Hydro-Québec · 58 ✖

country_long

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
3663 3663 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
3664 3664 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
3675 3675 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
3676 3676 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
3718 3718 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
3729 3729 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
3740 3740 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
3759 3759 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
3791 3791 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
3803 3803 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
3804 3804 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
3806 3806 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
3807 3807 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
3875 3875 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
3891 3891 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
3892 3892 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
3979 3979 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
4012 4012 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
4062 4062 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
4105 4105 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
4106 4106 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
4107 4107 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
4108 4108 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
4109 4109 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
4112 4112 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
4115 4115 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
4120 4120 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
4121 4121 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
4140 4140 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
4184 4184 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
4185 4185 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
4186 4186 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
4220 4220 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
4247 4247 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
4248 4248 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
4324 4324 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
4325 4325 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
4326 4326 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
4333 4333 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
4384 4384 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
4393 4393 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
4408 4408 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
4409 4409 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
4410 4410 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
4411 4411 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
4412 4412 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
4414 4414 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
4415 4415 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
4425 4425 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
4435 4435 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
4439 4439 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
4444 4444 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
4466 4466 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
4497 4497 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
4505 4505 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
4506 4506 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
4643 4643 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
4646 4646 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

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");
Powered by Datasette · Query took 52.16ms · Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette