global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
20 rows where estimated_generation_note_2015 = "HYDRO-V1", geolocation_source = "Natural Resources Canada" and owner = "TransAlta (100%)"
This data as json, CSV (advanced)
Suggested facets: capacity_mw, url
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3606 | 3606 | CAN | Canada | Akolkolex | CAN0007606 | 10.0 | 50.8227 | -118.0295 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 15478 | 2017 | 32.05 | 32.13 | 32.13 | 32.14 | 32.04 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3652 | 3652 | CAN | Canada | Barrier | CAN0007645 | 13.0 | 51.0342 | -115.0409 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34855 | 2017 | 45.62 | 43.4 | 39.6 | 42.05 | 41.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3663 | 3663 | CAN | Canada | Bearspaw | CAN0007654 | 17.0 | 51.1012 | -114.2823 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34857 | 2017 | 76.82 | 66.69 | 60.8 | 67.59 | 65.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3673 | 3673 | CAN | Canada | Belly River | CAN0007663 | 3.0 | 49.315 | -113.5743 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 15479 | 2017 | 10.98 | 10.67 | 10.4 | 12.2 | 8.91 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3684 | 3684 | CAN | Canada | Bighorn | CAN0002111 | 120.0 | 52.3081 | -116.3245 | Hydro | TransAlta (100%) | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34856 | 2017 | 363.17 | 363.39 | 363.82 | 364.16 | 365.56 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3696 | 3696 | CAN | Canada | Bone Creek | CAN0007687 | 19.0 | 52.2553 | -119.1808 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 56120 | 2017 | 42.94 | 42.94 | 42.94 | 43.05 | 42.94 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3711 | 3711 | CAN | Canada | Brazeau | CAN0002113 | 355.0 | 52.9101 | -115.3754 | Hydro | TransAlta (100%) | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34858 | 2017 | 1144.01 | 898.79 | 898.79 | 1144.8 | 903.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3764 | 3764 | CAN | Canada | Cascade | CAN0007732 | 36.0 | 51.2002 | -115.5021 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 124.08 | 119.24 | 96.35 | 106.86 | 105.89 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3952 | 3952 | CAN | Canada | Ghost | CAN0007882 | 51.0 | 51.2188 | -114.7078 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34860 | 2017 | 133.61 | 114.29 | 108.4 | 108.69 | 123.29 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4037 | 4037 | CAN | Canada | Horseshoe | CAN0007953 | 14.0 | 51.118 | -115.0343 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34861 | 2017 | 54.22 | 55.51 | 50.74 | 51.97 | 52.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4050 | 4050 | CAN | Canada | Interlakes | CAN0007967 | 5.0 | 50.6335 | -115.1392 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34862 | 2017 | 14.94 | 15.06 | 13.7 | 15.1 | 15.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4078 | 4078 | CAN | Canada | Kananaskis | CAN0007990 | 19.0 | 51.0969 | -115.0582 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34863 | 2017 | 73.59 | 75.34 | 68.86 | 70.54 | 71.71 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4244 | 4244 | CAN | Canada | Misema | CAN0008133 | 3.0 | 47.8996 | -79.8759 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 51201 | 2017 | 12.59 | 12.53 | 12.23 | 12.15 | 12.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4362 | 4362 | CAN | Canada | Pocaterra | CAN0008236 | 15.0 | 50.6993 | -115.1194 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34866 | 2017 | 45.69 | 46.03 | 41.96 | 46.15 | 47.78 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4450 | 4450 | CAN | Canada | Rundle | CAN0008310 | 50.0 | 51.0887 | -115.3736 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34867 | 2017 | 175.4 | 163.88 | 165.86 | 168.21 | 165.47 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4567 | 4567 | CAN | Canada | Spray | CAN0002244 | 112.0 | 51.0745 | -115.4024 | Hydro | TransAlta (100%) | Natural Resources Canada | http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34868 | 2017 | 395.89 | 370.73 | 372.19 | 377.46 | 371.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4584 | 4584 | CAN | Canada | St. Mary | CAN0008424 | 2.0 | 49.3665 | -113.1087 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 15481 | 2017 | 5.9 | 6.42 | 6.08 | 5.94 | 7.21 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4632 | 4632 | CAN | Canada | Three Sisters | CAN0008469 | 3.0 | 50.9985 | -115.3746 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 34870 | 2017 | 5.68 | 5.68 | 5.68 | 5.69 | 5.68 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4670 | 4670 | CAN | Canada | Upper Mamquam | CAN0008500 | 25.0 | 49.7178 | -123.0546 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 50976 | 2017 | 99.53 | 85.09 | 79.25 | 85.54 | 80.55 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4701 | 4701 | CAN | Canada | Waterton Hydro | CAN0008526 | 3.0 | 49.3291 | -113.6732 | Hydro | TransAlta (100%) | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 15482 | 2017 | 10.57 | 10.29 | 10.02 | 10.72 | 10.46 | 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");