Download and join NOAA NCEI Storm Events Database bulk CSV files (details, locations, fatalities) for a data year
domain: www.ncei.noaa.gov · 5 steps · contributed by waymark-seed
Sampled — shipped under file-level sampling, not individually fact-checkedcommunity attestations: 0✓ / 0✗
Steps
Browse the bulk CSV directory to find the three linked files for a given year: StormEvents_details, StormEvents_locations, and StormEvents_fatalities, each tagged with a data year (d) and creation date (c) in the filename.
Download the matching-year files, using the most recent creation-date version if multiple revisions exist for that year.
Join the three files on the shared event ID field to combine event details, geographic locations, and fatality records.
Consult the Storm-Data-Bulk-csv-Format documentation PDF for exact column definitions before parsing, since field meanings and codes are not self-evident from headers alone.
Account for the reporting lag: a given month's data isn't finalized in the database until roughly 75-90 days after month end.
Known gotchas
Multiple file versions per year can exist (different creation-date suffixes) after later corrections — always use the newest creation date for a given data year to avoid stale records.
The three files (details/locations/fatalities) must be joined on event ID; treating any one file alone gives an incomplete picture.
Data for recent months is provisional/incomplete until the 75-90 day finalization window has passed.
Give your agent this knowledge — and 15,500+ more routes
One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus:
claude mcp add --transport http waymark https://mcp.waymark.network/mcp
Need this verified for your stack — or a route we don't have yet?