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.
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
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
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
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
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
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 30Everything at one station
Every weather event at Denver International this year.
EVENTS * IN (DENVER) SINCE 2026-01-01
Run it on your own question
Sign in and press Try it on any step, or ask for a short demo on your data.
More weather use cases
- Climate trends and recordsClimate-risk, ESG and sustainability analysts
- Weather desk basicsAnyone starting with the Weather database: analysts, meteorology-curious traders, data teams
- World citiesGlobal macro, commodity and international teams
- Weather for energy and powerNatural gas, power and utilities desks
- Natural gas: winter demandNatural gas traders, utilities and demand planners
- Texas power: heat and freezePower traders, generators and utility analysts covering Texas