Hazard Plain national table storm_history, release 2026-10 (as of 2026-09-30)
B1-d Storm Events history per county area (the XLSX history sheet for every county).
Files: storm_history.csv and storm_history.parquet (1,929,668 rows). The Parquet file carries this text as key-value metadata (keys hazard_plain.*).

Hazard Plain is an independent product built from public federal data. It is not a FEMA document and is not reviewed or endorsed by FEMA or any state agency.

Reuse and citation: Hazard Plain text and tables are licensed under Creative Commons Attribution 4.0 International (CC BY 4.0, https://creativecommons.org/licenses/by/4.0/); credit Hazard Plain and the release. The underlying federal data are public domain; OpenFEMA data are also subject to the OpenFEMA terms and conditions.
Corrections: to report an error, name the packet, the table and what your records show. Contact: contact@hazardplain.org

Columns: stcofips, prefix, event_id, episode_id, date, end_date, type, magnitude, magnitude_type, tor_f_scale, tor_length, tor_width, category, magnitude_text, damage_property_usd, damage_crops_usd, damage_text, deaths, injuries, level, zone_key, location, former_county_label, n_units, place_mentions, new_since_plan, in_review_window, within_5y

Sources:
  NOAA NCEI, NOAA NCEI Storm Events Database, details files (csvfiles v1.0), version c20260918, pulled 2026-09-30, https://www.ncei.noaa.gov/pub/data/swdi/stormevents/csvfiles/
  NOAA National Weather Service, NWS county-public forecast zones correlation file, version bp03mr20 to bp16ap26 (11 files; newest bp16ap26), pulled 2026-09-30, https://www.weather.gov/gis/ZoneCounty
  FEMA, OpenFEMA HazardMitigationPlanStatuses v1, version 2026-09-29T134039Z, pulled 2026-09-30, https://www.fema.gov/api/open/v1/HazardMitigationPlanStatuses

NWS zone-county (bp) files used to place zone records (file, effective date, records placed with it):
  bp03mr20 (effective 2020-03-03): 483,246 records
  bp10nv20 (effective 2020-11-10): 16,985 records
  bp30mr21 (effective 2021-03-30): 6,357 records
  bp08se21 (effective 2021-09-08): 18,769 records
  bp22mr22 (effective 2022-03-22): 11,306 records
  bp13se22 (effective 2022-09-13): 19,977 records
  bp08mr23 (effective 2023-03-08): 15,505 records
  bp19se23 (effective 2023-09-19): 15,387 records
  bp05mr24 (effective 2024-03-05): 29,883 records
  bp18mr25 (effective 2025-03-18): 29,863 records
  bp16ap26 (effective 2026-04-16): 3,112 records

Reviewed crosswalks (pipeline/crosswalks) that decide Storm Events placement before or beside the bp join:
  pacific_zones.csv: Pacific territory Storm Events areas placed by name (A-1, A-32) (SHA-256 31a413113d6fa14f99836b6118640f7f74308a5e01acbf156598b733e013cbfe)
  legacy_zones.csv: renumbered and multi-county legacy zone names placed by name (A-2, A-33) (SHA-256 ad709aeb919bef95685a8414259f20a042c27b38bf71ac293067176da2df0bc5)
  zone_county_patches.csv: bp zone-county rows corrected (A-3, A-34) (SHA-256 aa38deb05710d4378dfc3867a1dc33375e72c592c0336f462b4265275191cd52)

OpenFEMA disclaimer:
This product uses the Federal Emergency Management Agency's OpenFEMA API, but is not endorsed by FEMA. The Federal Government or FEMA cannot vouch for the data or analyses derived from these data after the data have been retrieved from the Agency's website(s).