global-power-plants

Table actions

32 rows where owner = "BC Hydro"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: capacity_mw, source, url, geolocation_source, year_of_capacity_data

primary_fuel 2

owner 1

  • BC Hydro · 32 ✖

country_long 1

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_data_source estimated_generation_gwh
3595 3595 CAN Canada Aberfeldie CAN0007597 24.0 49.4933 -115.3624 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14141 2017             113.80062714574316
3629 3629 CAN Canada Ash River CAN0007628 28.0 49.3734 -125.1506 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14143 2017             132.76739833670035
3713 3713 CAN Canada Bridge River 1 CAN0002114 180.0 50.7299 -122.24 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14151 2017             853.5047035930736
3736 3736 CAN Canada Burrard CAN0002033 950.0 49.2988 -122.8906 Gas         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14149 2017             2945.823899243925
3789 3789 CAN Canada Cheakamus CAN0002125 158.0 49.9337 -123.291 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14154 2017             749.1874620428091
3817 3817 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             9.483385595478595
3822 3822 CAN Canada Clowhom CAN0007777 33.0 49.7109 -123.5321 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14155 2015             156.47586232539683
3898 3898 CAN Canada Elko CAN0007841 12.0 49.2901 -115.1046 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14158 2017             56.90031357287158
3912 3912 CAN Canada Falls River CAN0007852 7.0 53.9835 -129.7342 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada   2015             33.19184958417509
3940 3940 CAN Canada G.M. Shrum CAN0002146 2730.0 56.0148 -122.1957 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14162 2017             12944.821337828284
4069 4069 CAN Canada John Hart CAN0002163 126.0 50.044 -125.3109 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14166 2017             597.4532925151515
4073 4073 CAN Canada Jordan River CAN0002164 170.0 48.4297 -124.0523 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14169 2017             806.0877756156807
4101 4101 CAN Canada Kootenay Canal CAN0002171 570.0 49.4533 -117.5179 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14168 2017             2702.7648947114003
4118 4118 CAN Canada Ladore Falls CAN0008026 47.0 50.0173 -125.393 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14167 2017             222.85956149374704
4122 4122 CAN Canada Lajoie CAN0008030 25.0 50.8397 -122.8559 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14170 2017             118.54231994348244
4123 4123 CAN Canada Lake Buntzen 1 CAN0008031 59.0 49.3706 -122.8736 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14165 2017             279.7598750666186
4124 4124 CAN Canada Lake Buntzen 2 CAN0008032 17.8 49.3757 -122.8684 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14163 2017             84.40213179975952
4227 4227 CAN Canada Mica CAN0002196 2746.0 52.0759 -118.5705 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14174 2017             13020.688422592111
4334 4334 CAN Canada Peace Canyon CAN0002206 694.0 55.9826 -121.995 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14176 2017             3290.734801631073
4392 4392 CAN Canada Puntledge CAN0008258 24.0 49.665 -125.0939 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14178 2017             113.80062714574316
4426 4426 CAN Canada Revelstoke CAN0002219 2480.0 51.0486 -118.1939 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14180 2017             11759.398138393459
4450 4450 CAN Canada Ruskin CAN0002227 105.0 49.195 -122.4083 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14179 2017             497.8777437626263
4499 4499 CAN Canada Seton CAN0008351 48.0 50.6727 -121.9241 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14183 2017             227.60125429148633
4501 4501 CAN Canada Seven Mile CAN0002232 805.0 49.0302 -117.5041 Hydro         BC Hydro Natural Resources Canada http://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsAllGE100MW_NorthAmerica_201708.xlsx Natural Resources Canada 14181 2017             3817.0627021801347
4513 4513 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             28.45015678643579
4565 4565 CAN Canada Spillimacheen CAN0008408 4.0 50.9034 -116.4089 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14184 2017             18.966771190957196
4589 4589 CAN Canada Stave Falls CAN0008430 91.0 49.2288 -122.3561 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14189 2017             431.49404459427615
4596 4596 CAN Canada Strathcona CAN0008436 64.0 49.9981 -125.5856 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14187 2017             303.46833905531514
4686 4686 CAN Canada Wahleach CAN0008513 65.0 49.2366 -121.6807 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14192 2017             308.2100318530544
4692 4692 CAN Canada Walter Hardman CAN0008519 8.0 50.8139 -118.06 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14193 2015             37.93354238191439
4726 4726 CAN Canada Whatshan CAN0008551 54.0 49.9106 -118.0718 Hydro         BC Hydro Natural Resources Canada ftp://ftp.maps.canada.ca/pub/nacei_cnaie/energy_infrastructure/PowerPlantsRenewGE1MW_NorthAmerica_201708.xlsx Natural Resources Canada 14194 2015             256.05141107792207
4728 4728 CAN Canada Whitby CAN1031067 50.0 43.8594 -78.9033 Gas       1998.0 BC Hydro Canadian Power Plant Database http://www.cbc.ca/news2/interactives/database-cdnpowerplants/?appSession=37157089528396396394056638291117802843348425060575648208153793135366829336033758248443548607051384464831349653596564231536607108 GEODB                 155.0433631181013

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");