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 = "1.0" and country_long = "Canada"
This data as json, CSV (advanced)
Suggested facets: year_of_capacity_data, 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
owner 13
- 2397995 Ontario Inc 1
- 2405489 Ontario Inc 1
- Ayers Limitée 1
- City of Kimberley 1
- Grimsby Energy Inc 1
- Harvest 1
- Highmark Renewables 1
- Hydro Canomore Inc 1
- La Société d'Énergie Belle-Rivière Inc 1
- Shaman Power Corp 1
- Snowshoe Power Ltd 1
- St. Catharines Hydro Generation Inc / Glenridge Gas Utilization Inc 1
- Woodfibre LNG Ltd 1
country_long 1
- Canada · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3643 | 3643 | CAN | Canada | Ayers-2 | CAN0007638 | 1.0 | 45.6436 | -74.3539 | Hydro | Ayers Limitée | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 3.99 | 3.99 | 3.98 | 4.02 | 4.51 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3669 | 3669 | CAN | Canada | Belle-Rivière | CAN0007660 | 1.0 | 48.4417 | -71.7389 | Hydro | La Société d'Énergie Belle-Rivière Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 32897 | 2017 | 2.83 | 3.5 | 2.68 | 3.5 | 3.43 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3685 | 3685 | CAN | Canada | Bingham Chute | CAN0007676 | 1.0 | 46.0761 | -79.3968 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28960 | 2017 | 4.46 | 3.86 | 3.64 | 3.72 | 4.01 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
3689 | 3689 | CAN | Canada | Black Bay 2 | CAN0007680 | 1.0 | 48.9428 | -88.3141 | Solar | 2397995 Ontario Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 1.31 | 1.39 | 1.39 | 1.31 | 1.31 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
3886 | 3886 | CAN | Canada | East LFG | CAN0007830 | 1.0 | 43.1216 | -79.1739 | Biomass | St. Catharines Hydro Generation Inc / Glenridge Gas Utilization Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2016 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
3903 | 3903 | CAN | Canada | Elora | CAN0008597 | 1.0 | 43.6809 | -80.4329 | Hydro | 2405489 Ontario Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 67432 | 2017 | 3.22 | 3.6 | 2.79 | 3.74 | 3.23 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
3936 | 3936 | CAN | Canada | Fraser Richmond Soil & Fiber | CAN0007869 | 1.0 | 49.1597 | -123.0378 | Biomass | Harvest | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 65469 | 2017 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | |||||||||||||||||
3993 | 3993 | CAN | Canada | Grimsby Bioreactor | CAN0007919 | 1.0 | 43.1474 | -79.5389 | Biomass | Grimsby Energy Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | ||||||||||||||||||
4006 | 4006 | CAN | Canada | Hanna Chute | CAN0007927 | 1.0 | 45.0008 | -79.2977 | Hydro | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 28988 | 2017 | 4.33 | 4.57 | 3.44 | 3.93 | 4.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4092 | 4092 | CAN | Canada | Kimberley | CAN0008001 | 1.0 | 49.669 | -115.9476 | Solar | City of Kimberley | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 1.31 | 1.39 | 1.39 | 1.31 | 1.31 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4138 | 4138 | CAN | Canada | Lebreux | CAN0008042 | 1.0 | 48.1545 | -65.3474 | Hydro | Hydro Canomore Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 2.36 | 2.36 | 2.27 | 2.36 | 2.36 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4193 | 4193 | CAN | Canada | Marmora | CAN0008090 | 1.0 | 44.4851 | -77.6876 | Hydro | Shaman Power Corp | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 55360 | 2017 | 4.35 | 4.23 | 3.74 | 3.87 | 4.26 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | ||||||||||||
4206 | 4206 | CAN | Canada | McIntosh Creek | CAN0008612 | 1.0 | 53.3687 | -120.3754 | Hydro | Snowshoe Power Ltd | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 2.85 | 3.41 | 3.41 | 4.11 | 3.41 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4318 | 4318 | CAN | Canada | Optimist | CAN0008197 | 1.0 | 49.5312 | -114.0538 | Wind | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2016 | 2.32 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | CAPACITY-FACTOR-V1 | ||||||||||||||||||
4550 | 4550 | CAN | Canada | Solar Concentrating Steam Power Plant | CAN0008394 | 1.0 | 50.0378 | -110.7199 | Solar | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2016 | 1.31 | 1.39 | 1.26 | 1.18 | 1.27 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||||
4572 | 4572 | CAN | Canada | Squamish Power Project | CAN0008635 | 1.0 | 49.6761 | -123.2614 | Hydro | Woodfibre LNG Ltd | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 3.8 | 3.18 | 4.05 | 3.19 | 3.62 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | HYDRO-V1 | |||||||||||||
4680 | 4680 | CAN | Canada | Vegreville Biodigester | CAN0008509 | 1.0 | 53.6934 | -111.9786 | Biomass | Highmark Renewables | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 56575 | 2017 | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION | NO-ESTIMATION |
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");