global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
17 rows where capacity_mw = "2.0", primary_fuel = "Hydro" and source = "Natural Resources Canada"
This data as json, CSV (advanced)
Suggested facets: estimated_generation_gwh_2015, estimated_generation_gwh_2017
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3635 | 3635 | CAN | Canada | Auburn | CAN0007633 | 2.0 | 44.3235 | -78.314 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28956 | 2017 | 10.31 | 9.08 | 8.9 | 9.54 | 8.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3751 | 3751 | CAN | Canada | Campbellford | CAN0007723 | 2.0 | 44.3351 | -77.7725 | Hydro | Campbellford-Seymour Electric Generation Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 63908 | 2017 | 10.12 | 8.46 | 8.91 | 8.81 | 10.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3818 | 3818 | CAN | Canada | Clayton Falls | CAN0007773 | 2.0 | 52.3701 | -126.8139 | Hydro | BC Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 14153 | 2015 | 4.83 | 4.83 | 4.83 | 4.84 | 4.83 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3837 | 3837 | CAN | Canada | Crowe Bay | CAN0007789 | 2.0 | 44.3353 | -77.7723 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 15454 | 2000 | 10.12 | 8.46 | 8.91 | 8.81 | 10.17 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3889 | 3889 | CAN | Canada | East Twin | CAN0007832 | 2.0 | 53.4581 | -120.3834 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 18898 | 2017 | 4.05 | 4.05 | 4.05 | 4.06 | 4.05 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3901 | 3901 | CAN | Canada | Elliot Chute | CAN0007842 | 2.0 | 46.0602 | -79.3894 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28983 | 2017 | 8.6 | 7.47 | 7.23 | 7.39 | 7.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4015 | 4015 | CAN | Canada | Hauer Creek | CAN0008604 | 2.0 | 52.9342 | -119.4562 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 70495 | 2017 | 7.13 | 7.31 | 7.19 | 7.17 | 7.86 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4127 | 4127 | CAN | Canada | Lakefield | CAN0008033 | 2.0 | 44.421 | -78.2722 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29005 | 2017 | 10.31 | 9.08 | 8.9 | 9.54 | 8.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4224 | 4224 | CAN | Canada | Merrickville | CAN0008116 | 2.0 | 44.9178 | -75.8373 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29012 | 2017 | 8.48 | 8.16 | 8.03 | 8.14 | 8.31 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4285 | 4285 | CAN | Canada | Nipissing | CAN0008166 | 2.0 | 46.0967 | -79.4796 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29016 | 2017 | 8.6 | 7.47 | 7.23 | 7.39 | 7.69 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4345 | 4345 | CAN | Canada | Pentecôte | CAN0008222 | 2.0 | 49.7858 | -67.157 | Hydro | Pouvoir Riverin Inc (Société en Commandite) /Algonquin Power Fund (Canada) Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 20409 | 2017 | 7.53 | 7.53 | 7.53 | 7.51 | 7.72 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4430 | 4430 | CAN | Canada | Rideau Falls | CAN0008289 | 2.0 | 45.4422 | -75.6959 | Hydro | Fortis Generation East LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 9.64 | 9.64 | 9.36 | 9.65 | 9.64 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4448 | 4448 | CAN | Canada | Roseway | CAN0008306 | 2.0 | 43.7823 | -65.3439 | Hydro | Nova Scotia Power Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28508 | 2016 | 6.11 | 6.54 | 6.11 | 6.31 | 6.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4516 | 4516 | CAN | Canada | Sills Island | CAN0008362 | 2.0 | 44.21 | -77.5975 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29037 | 2017 | 10.39 | 8.38 | 8.94 | 8.78 | 10.17 | 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 | ||||||||||||
4650 | 4650 | CAN | Canada | Trethewey Falls | CAN0008485 | 2.0 | 44.9884 | -79.2714 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 29048 | 2017 | 8.34 | 8.83 | 6.83 | 7.72 | 8.18 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4672 | 4672 | CAN | Canada | Upper St Croix | CAN0008502 | 2.0 | 44.9267 | -64.0394 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2000 | 6.01 | 6.4 | 6.32 | 6.26 | 6.24 | 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");