global-power-plants
Data license: CC Attribution 4.0 License · Data source: World Resources Institute · About: global-power-plants-datasette
12 rows where country_long = "Canada" and estimated_generation_gwh_2013 = "13.24"
This data as json, CSV (advanced)
Suggested facets: year_of_capacity_data, estimated_generation_gwh_2014, estimated_generation_gwh_2015, estimated_generation_gwh_2016, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3866 | 3866 | CAN | Canada | Discoverylight | CAN0007811 | 10.0 | 44.4384 | -79.0681 | Solar | Axium Discovery Light LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 68409 | 2017 | 13.24 | 15.19 | 14.8 | 14.42 | 13.33 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
3961 | 3961 | CAN | Canada | Glenarm | CAN0007891 | 10.0 | 44.4633 | -78.9662 | Solar | Csi Glenarm LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 68873 | 2017 | 13.24 | 15.19 | 14.58 | 14.44 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
3966 | 3966 | CAN | Canada | Goodlight | CAN0007896 | 10.0 | 44.5117 | -78.992 | Solar | Goodlight LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 68404 | 2017 | 13.24 | 15.19 | 14.73 | 14.32 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
4144 | 4144 | CAN | Canada | Lily Lake | CAN0008047 | 10.0 | 44.3136 | -78.3926 | Solar | Peterborough Utilities Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 63905 | 2015 | 13.24 | 14.79 | 14.24 | 14.46 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
4346 | 4346 | CAN | Canada | Perpetual Cleanpower Lindsay | CAN0008224 | 10.0 | 44.4307 | -78.694 | Solar | Lindsay Solar LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 15.1 | 14.08 | 14.32 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4347 | 4347 | CAN | Canada | Perpetual Cleanpower Oro 4 Line | CAN0008225 | 10.0 | 44.5006 | -79.6133 | Solar | Oro-Medonte Solar Farm Inc | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 15.2 | 14.97 | 14.29 | 13.36 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4421 | 4421 | CAN | Canada | Raylight | CAN0008280 | 10.0 | 44.6982 | -79.8423 | Solar | Concord Raylight Partnership | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 68415 | 2017 | 13.24 | 15.2 | 14.57 | 14.3 | 12.98 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
4519 | 4519 | CAN | Canada | Simcoe Solar Energy Centre I | CAN0008365 | 10.0 | 44.4761 | -78.9752 | Solar | Terraform Ontario Solar LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 15.19 | 14.58 | 14.44 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4520 | 4520 | CAN | Canada | Simcoe Solar Energy Centre III | CAN0008366 | 10.0 | 44.4166 | -78.8859 | Solar | Terraform Ontario Solar LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 15.19 | 14.45 | 14.44 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4565 | 4565 | CAN | Canada | Sparklelight | CAN0008407 | 10.0 | 44.4631 | -79.0662 | Solar | Sparklelight LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 68403 | 2017 | 13.24 | 15.19 | 14.8 | 14.42 | 13.22 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | ||||||||||||
4609 | 4609 | CAN | Canada | Sune Newboro 4 | CAN0008447 | 10.0 | 44.649 | -76.3555 | Solar | Sune Newboro 4 LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 14.27 | 14.75 | 13.97 | 12.82 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | |||||||||||||
4705 | 4705 | CAN | Canada | Waubaushene 3 | CAN0008530 | 10.0 | 44.6575 | -79.8048 | Solar | Aurora Waubaushene 3 LP | Natural Resources Canada | ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx | Natural Resources Canada | 2017 | 13.24 | 15.2 | 14.57 | 14.3 | 12.95 | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE | SOLAR-V1-NO-AGE |
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");