Loading dataset

Description

Compare airport weather reports with official daily highs and lows in 20 United States cities. Each city has its own table of METAR and SPECI observations since 2020, joined to the National Weather Service daily result for that station's standard-time date. Use it to evaluate daily temperature forecasts or train models from conditions observed so far.

Rows are report-level, usually hourly with extra special reports when conditions change. Mostly Right refreshes observations hourly. Official highs and lows appear only after the NWS publishes them.

Coverage

  • Window: 2020-01-01 to the most recent completed day. Report times are UTC. The climate date is on each station's fixed standard-time offset (no daylight saving).
  • Grain: one row per report, in one table per city. Routine reports are hourly. Special reports arrive when conditions change, so a day holds roughly 24 to 60 rows.
  • Cadence: refreshed hourly at five minutes past the hour (UTC). Official NWS daily highs and lows update as the daily climate reports are published.
  • Cities 1 to 10: Atlanta, Austin, Boston, Chicago, Dallas-Fort Worth, Washington D.C., Denver, Houston, Las Vegas and Los Angeles.
  • Cities 11 to 20: Miami, Minneapolis-Saint Paul, New Orleans, New York City, Oklahoma City, Philadelphia, Phoenix, San Antonio, Seattle and San Francisco.

Columns

  • station, event_time_utc, observation_type: ICAO station, report time in UTC, METAR or SPECI.
  • local_standard_date: the climate date the report belongs to, fixed standard time.
  • temp_f, dewpoint_f, relative_humidity_pct: temperature and dew point in degrees Fahrenheit, humidity in percent.
  • wind_direction_degrees, wind_speed_kt, wind_gust_kt, peak_wind_gust_kt, peak_wind_direction_degrees, peak_wind_time: wind, knots and degrees.
  • altimeter_inhg, sea_level_pressure_hpa: pressure.
  • sky_cover_1 to sky_cover_4, sky_base_1_ft to sky_base_4_ft: cloud layers and their bases in feet.
  • visibility_miles, weather_codes, precipitation_in_1h, snow_depth_inches: visibility, present weather, hourly precipitation in inches, snow depth.
  • raw_metar: the original report text.
  • cli_high_f, cli_low_f: the official NWS daily maximum and minimum for the report's climate date, in degrees Fahrenheit.
  • cli_product, cli_report_type: the source product and whether the product was preliminary, final or corrected.

Missing values

Report fields are null when absent from a report. Official values are null on the few dates with no archived NWS report. Official values are never estimated from observations.

Suitable for

  • Predict the day's official high or low from the reports seen so far.
  • Settle or evaluate daily temperature forecasts and markets.
  • Train on hourly conditions with the official outcome as the label.
  • Build daily aggregates by grouping on local_standard_date.

Source and rights

National Weather Service (NWS) CLI reports and ASOS/METAR observations are US Government works (17 U.S.C. 105), archived and redistributed by the Iowa Environmental Mesonet, which requests attribution. Each city maps to one measurement station, not the metropolitan area. This compilation is released under CC0 1.0.

Tables

  • Table healthLive
    reports_kphlLive
    Table overviewPublished rows75,394Columns33 rows33 columnsUpdated
  • Table healthLive
    reports_khouLive
    Table overviewPublished rows71,779Columns33 rows33 columnsUpdated
  • Table healthLive
    reports_kdcaLive
    Table overviewPublished rows72,753Columns33 rows33 columnsUpdated
  • Table healthLive
    reports_knycLive
    Table overviewPublished rows75,374Columns33 rows33 columnsUpdated
  • Table healthLive
    reports_katlLive
    Table overviewPublished rows69,807Columns33 rows33 columnsUpdated

Sources

Iowa Environmental MesonetIowa Environmental Mesonet of Iowa State University2 endpoints

Iowa Environmental Mesonet of Iowa State University

Usage rights
Public domain asserted.
Collection
21 requests across 2 endpoints

Collected endpoints

/json/cli.py7 requests2020 to 2026
/cgi-bin/request/asos.py14 requests

Details

Contents
20 tables · 1,399,451 rows · 658 columns
Update cadence
Hourly
Updated
Published
Version
2026-10-16
Visibility
Public
Publisher
Mostly Right
Topics
weather · united states · metar +4

Activity

Views5,637+3,018 in the last 30 days
Likes3+0 in the last 30 days
Uses622+26 in the last 30 days