Canada Weather

Data about weather in winter, summers and throughout the year

@kaggle.hemil26_canada_weather

Table List

1 table(14.14 KB)

Canada Weather

@kaggle.hemil26_canada_weather.canada_weather

14.14 KB
43 rows
10 columns

community Community	weather_station Weather Station	location Location	elevation Elevation	january_avg_high_c_f January(Avg. High °C (°F))	january_avg_low_c_f January(Avg. Low °C (°F))	july_avg_high_c_f July(Avg. High °C (°F))	july_avg_low_c_f July(Avg. Low °C (°F))	annual_avg_high_c_f Annual(Avg. High °C (°F))	annual_avg_low_c_f Annual(Avg. Low °C (°F))
Alberton, PE	nan	46°51′00″N 064°01′00″W / 46.85000°N 64.01667°W / 46.85000; -64.01667 (Alberton)	3m (9.8ft)	−3.9 (25.0)	−12.5 (9.5)	23.2 (73.8)	14.1 (57.4)	9.6 (49.3)	1.3 (34.3)
Baker Lake, NU	YBK	64°17′56″N 096°04′40″W / 64.29889°N 96.07778°W / 64.29889; -96.07778 (Baker Lake Airport)	18.6m (61ft)	−27.7 (−17.9)	−34.8 (−30.6)	17.0 (62.6)	6.1 (43.0)	−7.3 (18.9)	−15.2 (4.6)
Baie-Comeau, QC	YBC	49°08′00″N 068°12′00″W / 49.13333°N 68.20000°W / 49.13333; -68.20000 (Baie-Comeau)	22m (72ft)	−8.7 (16.3)	−19.9 (−3.8)	20.9 (69.6)	10.3 (50.5)	6.6 (43.9)	−3.3 (26.1)
Calgary, AB	YYC	51°06′50″N 114°01′13″W / 51.11389°N 114.02028°W / 51.11389; -114.02028 (Calgary)	1,084m (3,556ft)	−0.9 (30.4)	−13.2 (8.2)	23.2 (73.8)	9.8 (49.6)	10.8 (51.4)	−1.9 (28.6)
Charlottetown, PE	YYG	46°17′19″N 063°07′43″W / 46.28861°N 63.12861°W / 46.28861; -63.12861 (Charlottetown)	49m (161ft)	−3.4 (25.9)	−12.1 (10.2)	23.3 (73.9)	14.1 (57.4)	9.9 (49.8)	1.3 (34.3)
Churchill, MB	YYQ	58°44′21″N 094°03′59″W / 58.73917°N 94.06639°W / 58.73917; -94.06639 (Churchill)	29m (95ft)	−21.9 (−7.4)	−30.1 (−22.2)	18.0 (64.4)	7.3 (45.1)	−2.3 (27.9)	−10.7 (12.7)
Corner Brook, NL	nan	48°57′00″N 057°57′00″W / 48.95000°N 57.95000°W / 48.95000; -57.95000 (Corner Brook)	5m (16ft)	−2.7 (27.1)	−9.6 (14.7)	22.0 (71.6)	12.6 (54.7)	9.0 (48.2)	1.3 (34.3)
Dawson City, YT	YDA	64°02′35″N 139°07′40″W / 64.04306°N 139.12778°W / 64.04306; -139.12778 (Dawson City)	370m (1,210ft)	−21.8 (−7.2)	−30.1 (−22.2)	23.1 (73.6)	8.2 (46.8)	2.1 (35.8)	−10.3 (13.5)
Edmonton, AB	YXD	53°34′24″N 113°31′06″W / 53.57333°N 113.51833°W / 53.57333; -113.51833 (Edmonton)	671m (2,201ft)	−6.0 (21.2)	−14.8 (5.4)	23.1 (73.6)	12.3 (54.1)	9.3 (48.7)	−1.0 (30.2)
Edmundston, NB	nan	47°20′47″N 068°11′16″W / 47.34639°N 68.18778°W / 47.34639; -68.18778 (Edmundston)	163m (535ft)	−7.1 (19.2)	−18.5 (−1.3)	24.7 (76.5)	11.5 (52.7)	9.5 (49.1)	−2.3 (27.9)


CREATE TABLE canada_weather (
  "community" VARCHAR,
  "weather_station" VARCHAR,
  "location" VARCHAR,
  "elevation" VARCHAR,
  "january_avg_high_c_f" VARCHAR,
  "january_avg_low_c_f" VARCHAR,
  "july_avg_high_c_f" VARCHAR,
  "july_avg_low_c_f" VARCHAR,
  "annual_avg_high_c_f" VARCHAR,
  "annual_avg_low_c_f" VARCHAR
);