Canadian city daily weather panel, 18 metros
Daily observed weather for 18 Canadian metro stations (Toronto, Montreal, Vancouver, Calgary, Ottawa, Edmonton, Winnipeg, Quebec City, Hamilton, Kitchener, London, Victoria, Halifax, Saskatoon, Regina, St. John's, Kelowna, Moncton) from ECCC climate-daily observations (MSC GeoMet OGC API, keyless). Trailing 370 days, updated daily: max/min temperature (degC), precipitation (mm), snowfall and snow depth (cm), heating/cooling degree days (base 18 degC, ECCC published) plus ML-ready flags — heatwave (tmax>=32), deep freeze (tmin<=-15), heavy precipitation (>=25mm). ECCC 'M' (missing) flags become NULL, never imputed.
- Rows
- 6,660
- Columns
- 21
- Source cadence
- Daily
- Last refreshed
- Sep 29, 2026
- Theme
- environment
| Column | Type | Description |
|---|---|---|
| date | date | Date of observation (station local date). (unit: date) |
| city | string | Metro city label (curated station city). |
| region | string | Province/territory (CA) or state (US) code. |
| country | string | Country name (Canada or United States). |
| country_code | string | ISO 3166-1 alpha-3 country code (CAN or USA). |
| lat | float | Station latitude, decimal degrees. (unit: degrees) |
| lon | float | Station longitude, decimal degrees. (unit: degrees) |
| station_id | string | Upstream station identifier: ECCC CLIMATE_IDENTIFIER (CA) or GHCN-Daily station ID (US). |
| station_name | string | Upstream station name, verbatim. |
| temp_max_c | float | Daily maximum temperature, degrees Celsius. (unit: °C) |
| temp_min_c | float | Daily minimum temperature, degrees Celsius. (unit: °C) |
| temp_mean_c | float | Derived: daily mean temperature = (temp_max_c + temp_min_c) / 2, degrees Celsius. NULL when either bound is missing. (unit: °C) |
| precip_mm | float | Total daily precipitation, millimetres. (unit: mm) |
| snowfall_cm | float | Total daily snowfall, centimetres. (unit: cm) |
| snow_on_ground_cm | float | Snow depth on the ground, centimetres. (unit: cm) |
| hdd_18 | float | Heating degree days, base 18 degC. ECCC-published for the Canadian panel; computed from temp_mean_c for the US panel (max(0, 18 - mean)). (unit: degree days) |
| cdd_18 | float | Cooling degree days, base 18 degC. ECCC-published for the Canadian panel; computed from temp_mean_c for the US panel (max(0, mean - 18)). (unit: degree days) |
| heatwave_flag | boolean | Derived: temp_max_c >= 32.0 degC. Connector-defined transformation. |
| deep_freeze_flag | boolean | Derived: temp_min_c <= -15.0 degC. Connector-defined transformation. |
| heavy_precip_flag | boolean | Derived: precip_mm >= 25.0 mm. Connector-defined transformation. |
| data_source | string | Upstream source label for the row. |
First 10 sample rows — a preview, not the complete dataset.
| date | city | region | country | country_code | lat | lon | station_id | station_name | temp_max_c | temp_min_c | temp_mean_c | precip_mm | snowfall_cm | snow_on_ground_cm | hdd_18 | cdd_18 | heatwave_flag | deep_freeze_flag | heavy_precip_flag | data_source |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-09-20T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 28 | 8.8 | 18.4 | 0 | 0 | — | 0 | 0.4 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-21T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 25.3 | 11.1 | 18.2 | 0 | 0 | — | 0 | 0.2 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-22T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 20.5 | 8.6 | 14.55 | 0 | 0 | — | 3.4 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-23T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 27.4 | 11.2 | 19.3 | 0 | 0 | — | 0 | 1.3 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-24T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 21.2 | 7.6 | 14.4 | 0 | 0 | — | 3.6 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-25T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 24 | 5 | 14.5 | 0 | 0 | — | 3.5 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-26T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 18.7 | 7.1 | 12.9 | 0 | 0 | — | 5.1 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-27T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 23.5 | 7.2 | 15.35 | 0 | 0 | — | 2.6 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-28T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 15.9 | 4.9 | 10.4 | 0 | 0 | — | 7.6 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
| 2025-09-29T00:00:00 | Calgary | AB | Canada | CAN | 51.123 | -114.013 | 3031092 | CALGARY INTL A | 26.8 | 7.2 | 17 | 0 | 0 | — | 1 | 0 | false | false | false | ECCC climate-daily (MSC GeoMet OGC API) |
- Current
20260929T042356Z-7327df1e9aa3 · sha256 7327df1e9aa3…
6,660 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/na_city_weather/ca_city_weather_daily" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/na_city_weather/ca_city_weather_daily").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/na_city_weather/ca_city_weather_daily
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20260929T042356Z-7327df1e9aa3 and its content hash, so readers get exactly the data you used.
North America city weather panel (daily). (2026). Canadian city daily weather panel, 18 metros [Data set, snapshot 20260929T042356Z-7327df1e9aa3, sha256 7327df1e9aa3]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/na_city_weather/ca_city_weather_daily?snapshot=20260929T042356Z-7327df1e9aa3
@misc{dz_na_city_weather_ca_city_weather_daily_7327df1e,
title = {{Canadian city daily weather panel, 18 metros}},
author = {{North America city weather panel (daily)}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/na_city_weather/ca_city_weather_daily?snapshot=20260929T042356Z-7327df1e9aa3}},
note = {Snapshot 20260929T042356Z-7327df1e9aa3, sha256 7327df1e9aa3a3174182c351a46c1e57447aad8bc37b32704582dd6cfb5906e1; accessed 2026-09-30}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
<iframe src="https://datazimuts.com/embed/chart?dataset=na_city_weather%2Fca_city_weather_daily&lang=en&theme=auto&snapshot=20260929T042356Z-7327df1e9aa3&x=date&y=lat&agg=avg" title="Canadian city daily weather panel, 18 metros" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.