EquationDB

Severe weather and records

For risk, insurance and operations teams

Ten weather event types, each judged against that station's own thresholds for the time of year and scored for rarity in that season: records, heat waves, cold snaps, heavy rain and snow, freezes, gusts and big swings.

  • Weather
  • 7 steps
  • Runs on live data

How EquationDB answers it

Each step is one query on live data. Run them in order, or open any one and adapt it: change the symbol, the station, the dates or the filter.

  1. The rarest weather of the week

    Every weather event of the last seven days, rarest for its station and month first.

    EVENTS * IN weather.us LAST 7d SORT rarity DESC LIMIT 20
    Try it →
  2. Record highs this month

    Days that beat every earlier year on that date, by the margin.

    EVENTS record_high IN weather.us LAST 30d SORT magnitude DESC LIMIT 25
    Try it →
  3. A foot of snow in a day

    Single-day snowfalls of 12 inches or more since 2020.

    EVENTS heavy_snow IN weather.us SINCE 2020-01-01 WHERE magnitude >= 12 SORT magnitude DESC LIMIT 20
    Try it →
  4. Damaging gusts

    Two-minute winds of 58 mph or more, the severe-storm threshold.

    EVENTS damaging_gust IN weather.us SINCE 2024-01-01 SORT magnitude DESC LIMIT 15
    Try it →
  5. Hard freezes where they are rare

    20 °F or below at stations where that happens in fewer than one season in five: Texas, February 2021.

    EVENTS hard_freeze IN weather.us SINCE 2020-01-01 SORT magnitude DESC LIMIT 20
    Try it →
  6. Cold snaps in the big heating states

    Last winter's cold snaps in the states that burn the most gas for heat.

    EVENTS cold_snap IN weather.us FROM 2025-11-01 TO 2026-03-31 WHERE state IN ('IL', 'NY', 'PA', 'OH', 'MI', 'MA') SORT magnitude DESC LIMIT 30
    Try it →
  7. Everything at one station

    Every weather event at Denver International this year.

    EVENTS * IN (DENVER) SINCE 2026-01-01
    Try it →

Run it on your own question

Sign in and press Try it on any step, or ask for a short demo on your data.

Request a trial

More weather use cases