global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
14 rows where capacity_mw = "6.0", primary_fuel = "Hydro" and source = "Natural Resources Canada"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_gwh_2014, estimated_generation_gwh_2016
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3752 | 3752 | CAN | Canada | Canoe Creek Hydro | CAN0008582 | 6.0 | 49.1769 | -125.3956 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 62820 | 2017 | 11.76 | 11.76 | 11.76 | 11.79 | 11.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3766 | 3766 | CAN | Canada | Castle Creek | CAN0008583 | 6.0 | 53.1092 | -120.1942 | Hydro | Castle Mountain Hydro Ltd | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 69332 | 2017 | 18.69 | 18.69 | 18.69 | 18.23 | 18.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3874 | 3874 | CAN | Canada | Doran Taylor | CAN0008595 | 6.0 | 49.2964 | -125.2755 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 33893 | 2017 | 11.8 | 11.8 | 11.8 | 11.83 | 11.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3911 | 3911 | CAN | Canada | Eugenia | CAN0007850 | 6.0 | 44.3398 | -80.537 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28982 | 2017 | 22.39 | 22.7 | 15.81 | 21.14 | 18.53 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4001 | 4001 | CAN | Canada | Haa-ak-suuk Creek Hydro | CAN0008602 | 6.0 | 49.2479 | -125.3837 | Hydro | Haa-ak-suuk Creek Hydro LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 65544 | 2017 | 11.76 | 11.76 | 11.76 | 11.79 | 11.76 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4045 | 4045 | CAN | Canada | Hystad | CAN0007962 | 6.0 | 52.8413 | -119.3524 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 54236 | 2017 | 11.8 | 11.8 | 11.8 | 11.83 | 11.8 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4086 | 4086 | CAN | Canada | Kenora | CAN0007996 | 6.0 | 49.7725 | -94.5035 | Hydro | H2O Power LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 14720 | 2017 | 33.02 | 32.92 | 33.02 | 33.08 | 32.92 | 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 | ||||||||||||
4261 | 4261 | CAN | Canada | Moresby Lake | CAN0008145 | 6.0 | 52.9345 | -132.1282 | Hydro | Atlantic Power Corp | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 63996 | 2017 | 17.87 | 20.94 | 21.25 | 21.31 | 21.25 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4447 | 4447 | CAN | Canada | Rose Blanche | CAN0008305 | 6.0 | 47.6519 | -58.713 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 27721 | 2014 | 21.2 | 21.42 | 20.8 | 21.22 | 20.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4476 | 4476 | CAN | Canada | Sakwi Creek | CAN0008627 | 6.0 | 49.3326 | -121.8801 | Hydro | Sakwi Creek Hydro LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 56158 | 2017 | 23.4 | 26.67 | 26.05 | 26.1 | 23.35 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4479 | 4479 | CAN | Canada | Sandy Falls | CAN0008333 | 6.0 | 48.5113 | -81.4434 | Hydro | Umh Energy Partnership An Ontario General Partnership of Ontario Power Generation Inc and Umh Energy Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29034 | 2017 | 28.61 | 28.76 | 26.82 | 26.74 | 27.52 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4504 | 4504 | CAN | Canada | Seymour | CAN0008354 | 6.0 | 44.3215 | -77.782 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 66387 | 2017 | 32.36 | 27.18 | 27.28 | 27.28 | 32.5 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4514 | 4514 | CAN | Canada | Shuswap Falls | CAN0008360 | 6.0 | 50.296 | -118.8133 | Hydro | BC Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 14185 | 2015 | 17.29 | 16.44 | 19.31 | 17.08 | 19.77 | 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");