Datasetpublic

sweetapricity/bridgedeck-noaa

Bridgedeck — NOAA Storm Events (2000–2023) Part of the bridgedeck dataset collection for US bridge deck deterioration research. Overview County-level severe weather event counts and damage totals for all US counties, 2000–2023. Derived from the NOAA National Centers for Environmental Information (NCEI) Storm Events Database. Events are grouped into 5 categories relevant to bridge deterioration: flood, wind, hail, winter storms, and tornadoes. Includes single-year… See the full description on the dataset page: https://huggingface.co/datasets/sweetapricity/bridgedeck-noaa.

sourceHugging Facecc-by-4.0updated 4mo agoView on Hugging Face

0likes20downloads

Dataset Card

Bridgedeck — NOAA Storm Events (2000–2023)

Part of the bridgedeck dataset collection for US bridge deck deterioration research.

Overview

County-level severe weather event counts and damage totals for all US counties, 2000–2023. Derived from the NOAA National Centers for Environmental Information (NCEI) Storm Events Database.

Events are grouped into 5 categories relevant to bridge deterioration: flood, wind, hail, winter storms, and tornadoes. Includes single-year counts and 5-year rolling sums to capture cumulative storm exposure.

Source

Source: NOAA NCEI Storm Events Database

Downloaded files: Annual CSV.gz files, 2000–2023 (StormEvents_details-ftp_v1.0_d{YEAR}_*.csv.gz)

Schema

One row per (county_fips, year). Primary key: (county_fips, year).

Column	Type	Description
`county_fips`	str	5-digit FIPS county code (`state_fips + county_fips`)
`year`	int	Year (2000–2023)
`flood_count`	float	Flood, Flash Flood, Heavy Rain, Storm Surge events
`wind_count`	float	Thunderstorm Wind, High Wind, Hurricane events
`hail_count`	float	Hail events
`winter_count`	float	Ice Storm, Blizzard, Winter Storm, Heavy Snow events
`tornado_count`	float	Tornado, Waterspout events
`storm_damage_total_usd`	float	Total property damage from all storm events (USD)
`storm_damage_max_usd`	float	Maximum single-event property damage (USD)
`flood_count_5yr_sum`	float	5-year rolling sum of flood events
`wind_count_5yr_sum`	float	5-year rolling sum of wind events
`hail_count_5yr_sum`	float	5-year rolling sum of hail events
`winter_count_5yr_sum`	float	5-year rolling sum of winter storm events
`tornado_count_5yr_sum`	float	5-year rolling sum of tornado events
`storm_damage_total_usd_5yr_sum`	float	5-year rolling sum of total damage (USD)
`storm_damage_max_usd_5yr_sum`	float	5-year rolling sum of max single-event damage (USD)

Join Key

Join to NBI bridge data on county_fips = state_code.zfill(2) + county_code.zfill(3).

Processing Notes

—County-level events (CZ_TYPE='C') are joined directly via FIPS code.
—Winter storm events are almost exclusively reported at NWS forecast zone level (CZ_TYPE='Z'). These are expanded to counties using the NWS Zone-County Correlation File (nws_zone_county.dbx), downloaded automatically during ETL.
—5-year rolling sums use min_periods=3 (NaN for years 2000–2001).
—Property damage strings (e.g. "1.5K", "2M") are parsed to USD floats.

Related Datasets

Repo	Description
`sweetapricity/bridgedeck-nbi`	National Bridge Inventory — structural features, 2000–2023
`sweetapricity/bridgedeck-prism`	PRISM climate features at bridge locations, 2000–2023
`sweetapricity/bridgedeck-noaa`	This dataset — NOAA storm event counts by county, 2000–2023
`sweetapricity/bridgedeck-nshm`	USGS seismic hazard at bridge locations (static)
`sweetapricity/bridgedeck-nfhl`	FEMA flood zone classification at bridge locations (static)
`sweetapricity/bridgedeck-salt`	USGS road salt tiers by state (static)

Paper

Ibrahim, A., Abdelkhalek, S., Zayed, T., Qureshi, A. H., & Mohammed Abdelkader, E. (2024). A comprehensive review of the key deterioration factors of concrete bridge decks. Buildings, 14(11), 3425.