EquationDB

Insurance: catastrophe watch

For property and casualty insurers, reinsurers and insurance analysts

Storm losses start as weather: extreme rain, damaging winds, and where they hit. List the heaviest rain and strongest gusts along the Gulf Coast, put this year's storms in the context of the last five, and measure how insurers traded after downpours in Miami and Houston.

  • Weather
  • 5 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 heaviest daily rain since 2020

    The largest one-day rain totals at US stations since 2020, each scored for rarity at that station and season: the flood events behind the biggest claims.

    EVENTS heavy_rain IN weather.us SINCE 2020-01-01 SORT magnitude DESC LIMIT 20
    Try it →
  2. Downpours on the Gulf Coast

    Heavy rain in Florida, Texas and Louisiana since the start of 2025, largest first, with the station and date.

    EVENTS heavy_rain IN weather.us SINCE 2025-01-01 WHERE state IN ('FL', 'TX', 'LA') SORT magnitude DESC LIMIT 20
    Try it →
  3. Damaging gusts on the Gulf Coast

    The strongest wind gusts recorded in the three Gulf states since 2024: the wind side of storm exposure.

    EVENTS damaging_gust IN weather.us SINCE 2024-01-01 WHERE state IN ('FL', 'TX', 'LA') SORT magnitude DESC LIMIT 20
    Try it →
  4. Insurers after Miami downpours

    What Chubb, Travelers and Progressive did 5 and 20 sessions after each heavy-rain day at Miami since 2005, from the first session after it, against their normal drift.

    OUTCOMES AFTER weather:KMIA.heavy_rain IN (CB, TRV, PGR) FWD 5d, 20d SINCE 2005-01-01
    Try it →
  5. Insurers after Houston downpours

    The same test for Houston, adding Allstate: whether the market prices storm losses the same way in a second big exposure.

    OUTCOMES AFTER weather:KIAH.heavy_rain IN (CB, TRV, ALL, PGR) FWD 5d, 20d SINCE 2005-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