US city daily weather panel, 20 metros

Commercial use OKAging

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Daily observed weather for 20 US metro airport stations (New York, Los Angeles, Chicago, Houston, Phoenix, Seattle, Miami, Boston, Atlanta, Dallas, San Francisco, Washington, Denver, Minneapolis, Detroit, Philadelphia, St. Louis, Nashville, Portland, Las Vegas) from NOAA GHCN-Daily (keyless .dly files, public domain). Trailing 370 days, updated daily: max/min temperature (degC), precipitation (mm), snowfall and snow depth (cm), heating/cooling degree days (base 18 degC, computed from the daily mean) plus ML-ready flags — heatwave (tmax>=32), deep freeze (tmin<=-15), heavy precipitation (>=25mm). GHCN -9999 (missing) becomes NULL, never imputed.

Source: North America city weather panel (daily)
Rows: 7,376
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	snow_on_ground_cm	cdd_18	heatwave_flag	deep_freeze_flag	heavy_precip_flag	data_source
2025-09-20T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	32.8	20.6	26.7	0	—	8.7	true	false	false	NOAA GHCN-Daily
2025-09-21T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	31.1	20	25.55	0	0	7.55	false	false	false	NOAA GHCN-Daily
2025-09-22T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	30.6	20	25.3	0	0	7.3	false	false	false	NOAA GHCN-Daily
2025-09-23T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	32.2	20	26.1	0	0	8.1	true	false	false	NOAA GHCN-Daily
2025-09-24T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	33.9	21.7	27.8	2.5	—	9.8	true	false	false	NOAA GHCN-Daily
2025-09-25T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	30.6	22.2	26.4	0.3	0	8.4	false	false	false	NOAA GHCN-Daily
2025-09-26T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	27.8	21.7	24.75	0	0	6.75	false	false	false	NOAA GHCN-Daily
2025-09-27T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	31.7	20	25.85	0.8	0	7.85	false	false	false	NOAA GHCN-Daily
2025-09-28T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	31.1	20	25.55	0	0	7.55	false	false	false	NOAA GHCN-Daily
2025-09-29T00:00:00	Atlanta	GA	United States	USA	33.63	-84.442	USW00013874	ATLANTA HARTSFIELD-JACKSON INT	27.2	20.6	23.9	0	0	5.9	false	false	false	NOAA GHCN-Daily

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/na_city_weather/us_city_weather_daily" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/na_city_weather/us_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/us_city_weather_daily

Tip: fetch /llms.txt for the full machine-readable catalog.

Cite this snapshot

Pinned to snapshot 20260929T042514Z-c90885f76cb6 and its content hash, so readers get exactly the data you used.

APA

North America city weather panel (daily). (2026). US city daily weather panel, 20 metros [Data set, snapshot 20260929T042514Z-c90885f76cb6, sha256 c90885f76cb6]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/na_city_weather/us_city_weather_daily?snapshot=20260929T042514Z-c90885f76cb6

BibTeX

@misc{dz_na_city_weather_us_city_weather_daily_c90885f7,
  title        = {{US city daily weather panel, 20 metros}},
  author       = {{North America city weather panel (daily)}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/na_city_weather/us_city_weather_daily?snapshot=20260929T042514Z-c90885f76cb6}},
  note         = {Snapshot 20260929T042514Z-c90885f76cb6, sha256 c90885f76cb6eb9d522e2ad265d269cb7292e661885ede1c9ad9e8848635bbed; 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.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=na_city_weather%2Fus_city_weather_daily&lang=en&theme=auto&snapshot=20260929T042514Z-c90885f76cb6&x=date&y=lat&agg=avg" title="US city daily weather panel, 20 metros" width="100%" height="380" style="border:0" loading="lazy"></iframe>

US city daily weather panel, 20 metros

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key