global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
18 rows where owner = "Hydro-Québec" and url = "ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx" sorted by estimated_generation_gwh_2014
This data as json, CSV (advanced)
Suggested facets: capacity_mw, year_of_capacity_data, estimated_generation_gwh_2016, estimated_generation_gwh_2017
url 1 ✖
- ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx · 18 ✖
primary_fuel 1
- Hydro 18
owner 1
- Hydro-Québec · 18 ✖
country_long 1
- Canada 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3807 | 3807 | 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 | 3.4 | 3.4 | 3.4 | 3.41 | 3.4 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4249 | 4249 | 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 | 15.91 | 15.2 | 15.4 | 16.28 | 16.37 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4248 | 4248 | 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 | 24.12 | 23.13 | 23.32 | 24.68 | 24.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3805 | 3805 | 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 | 51.53 | 50.39 | 40.4 | 45.61 | 44.28 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3876 | 3876 | 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 | 83.19 | 64.06 | 65.48 | 64.24 | 83.65 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4467 | 4467 | 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 | 68.45 | 68.63 | 71.76 | 68.01 | 70.95 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4116 | 4116 | 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 | 87.7 | 79.91 | 81.85 | 78.33 | 87.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4498 | 4498 | 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 | 77.65 | 80.27 | 74.85 | 80.68 | 80.92 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3808 | 3808 | 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 | 130.97 | 104.07 | 106.65 | 104.36 | 131.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4436 | 4436 | 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 | 141.19 | 141.19 | 141.19 | 141.58 | 141.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3730 | 3730 | 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 | 133.01 | 150.03 | 118.72 | 146.8 | 133.9 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4013 | 4013 | 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 | 178.29 | 190.73 | 189.28 | 191.99 | 194.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4221 | 4221 | 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 | 277.91 | 295.68 | 267.07 | 291.57 | 283.46 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3804 | 3804 | 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 | 302.16 | 302.16 | 295.75 | 304.97 | 302.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4409 | 4409 | 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 | 309.91 | 311.43 | 265.55 | 269.04 | 311.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4410 | 4410 | 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 | 311.43 | 314.61 | 250.04 | 269.04 | 311.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3980 | 3980 | 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 | 316.19 | 316.19 | 311.23 | 317.86 | 316.19 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4412 | 4412 | 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 | 370.4 | 370.43 | 362.53 | 373.83 | 368.09 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 |
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");