FEMA National Risk Index county-hazard intelligence
One row per (U.S. county, NRI hazard family) for the 18 FEMA National Risk Index v1.20 (Dec 2025) hazards: hazard risk score (0–100 national percentile) and rating, expected annual loss (total/buildings/population/agriculture, USD) with each hazard's share of the county's total EAL and rank-in-county, dominant hazard per county + its EAL share, county EAL per capita and as a share of building value, Very-High rating ordinals, a multi-hazard hotspot flag (>=2 Very High hazards), social vulnerability and community resilience scores/ratings, and the hazard's documented period of record. 88 insufficient-data counties are kept as coverage-transparent null rows. Primary key: (county_fips, hazard_code). Join keys: county_fips (5-char GEOID), hazard_code. Cadence: quarterly (version-pinned; re-ingests as a no-op until FEMA publishes a new NRI version). FEMA NRI data is U.S. public domain — commercial_use = yes. Sample use: filter multi_hazard_hotspot and order by county_eal_per_capita_usd desc for the riskiest compound-risk counties per resident.
- Rows
- 58,176
- Columns
- 44
- Source cadence
- Quarterly
- Last refreshed
- Sep 29, 2026
- Theme
- environment
| Column | Type | Description |
|---|---|---|
| as_of | string | Last complete UTC day of the fetch. Fixed per run, so an unchanged NRI release re-ingests as a no-op. (unit: date) |
| nri_version | string | Pinned NRI release version (1.20); the snapshot supersedes only when FEMA publishes a new version. |
| county_fips | string | 5-char county GEOID (STCOFIPS zero-padded). Join key. (unit: id) |
| county_name | string | County/equivalent name from the NRI table. |
| county_type | string | FEMA county-equivalent type (County, Borough, Parish, Municipio, …). |
| state_name | string | State/territory name. |
| state_abbr | string | USPS state/territory abbreviation. (unit: code) |
| country | string | Canonical country name (United States). |
| country_code | string | ISO alpha-3 country code (USA). Join key. (unit: code) |
| hazard_code | string | NRI hazard prefix (AVLN, HRCN, WFIR, …). Join key. (unit: code) |
| hazard_name | string | Hazard family display name. |
| hazard_period_of_record | string | Documented period of record behind this hazard's frequency model (e.g. '1994-2023 (30 years)'). |
| events_per_year | float | Hazard EVNTS / period_years — comparable across hazards with different record lengths. (unit: events/year) |
| annualized_frequency | float | FEMA annualized frequency (AFREQ) for the hazard in this county. (unit: 1/year) |
| exposed_population | float | Population exposed to the hazard (EXPP). (unit: people) |
| exposed_buildings | float | Buildings exposed to the hazard (EXPB). (unit: count) |
| exposed_area_sqkm | float | Area exposed to the hazard (EXP_AREA). (unit: km2) |
| eal_total_usd | float | Hazard expected annual loss, total (EALT), USD. (unit: USD) |
| eal_buildings_usd | float | Hazard EAL, buildings component (EALB), USD. Null where the hazard has no building component by design (e.g. drought). (unit: USD) |
| eal_population_usd | float | Hazard EAL, population component (EALP), USD. Null where not applicable by design. (unit: USD) |
| eal_agriculture_usd | float | Hazard EAL, agriculture component (EALA), USD. Null where not applicable by design. (unit: USD) |
| eal_share_of_county_total | float | This hazard's EALT / the county's total EAL (EAL_VALT). Null when the county EAL is null or zero. (unit: share) |
| hazard_rank_in_county | float | Rank of this hazard's EALT within its county (1 = largest loss driver); ties share the lower rank by code order; null when EALT is null. (unit: rank) |
| risk_score | float | FEMA hazard risk index score: national percentile 0–100 of the risk value. (unit: percentile) |
| risk_rating | string | FEMA categorical rating: Very High … Very Low, plus 'No Rating' / 'Not Applicable' / 'Insufficient Data'. |
| risk_rating_ordinal | float | Rating mapped to 1 (Very Low) … 5 (Very High); null for non-rated categories. (unit: ordinal) |
| risk_value | float | FEMA hazard risk index value (the scored quantity). |
| county_risk_score | float | FEMA composite National Risk Index score (0–100 national percentile), repeated per row. (unit: percentile) |
| county_risk_rating | string | FEMA composite rating, repeated per row. |
| county_eal_total_usd | float | County total expected annual loss (EAL_VALT), USD, repeated per row. (unit: USD) |
| county_eal_per_capita_usd | float | County EAL / population — comparable across counties of different sizes. (unit: USD/person) |
| county_eal_share_of_building_value_pct | float | 100 x county building EAL / total building value: the expected yearly share of the built stock lost. (unit: percent) |
| county_dominant_hazard_code | string | Hazard code with the largest EALT in the county (ties -> alphabetical code). (unit: code) |
| county_dominant_hazard_name | string | Display name of the dominant hazard. |
| county_dominant_hazard_eal_share | float | Dominant hazard's EALT / county total EAL. (unit: share) |
| county_n_very_high_hazards | integer | Count of hazards rated Very High in the county. (unit: count) |
| multi_hazard_hotspot | boolean | True when >= 2 hazards are rated Very High — the compound-risk set. (unit: bool) |
| sovi_score | float | FEMA social-vulnerability score. (unit: score) |
| sovi_rating | string | FEMA social-vulnerability rating. |
| resl_score | float | FEMA community-resilience score. (unit: score) |
| resl_rating | string | FEMA community-resilience rating. |
| resl_value | float | FEMA community-resilience value. |
| source_url | string | Per-row provenance: the exact FEMA bulk-download URL. (unit: url) |
| row_hash | string | SHA-256 (16 hex) over the row's content fields; identical input yields an identical hash, so a re-run on an unchanged NRI release is a no-op. (unit: hash) |
First 10 sample rows — a preview, not the complete dataset.
| as_of | nri_version | county_fips | county_name | county_type | state_name | state_abbr | country | country_code | hazard_code | hazard_name | hazard_period_of_record | events_per_year | annualized_frequency | exposed_population | exposed_buildings | exposed_area_sqkm | eal_total_usd | eal_buildings_usd | eal_population_usd | eal_agriculture_usd | eal_share_of_county_total | hazard_rank_in_county | risk_score | risk_rating | risk_rating_ordinal | risk_value | county_risk_score | county_risk_rating | county_eal_total_usd | county_eal_per_capita_usd | county_eal_share_of_building_value_pct | county_dominant_hazard_code | county_dominant_hazard_name | county_dominant_hazard_eal_share | county_n_very_high_hazards | multi_hazard_hotspot | sovi_score | sovi_rating | resl_score | resl_rating | resl_value | source_url | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | AVLN | Avalanche | 1994-2023 (30 years) | — | — | — | — | — | — | — | — | — | — | — | — | Not Applicable | — | — | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 096d9d54221e2a7d |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | CFLD | Coastal Flooding | Various (see documentation) | — | — | — | — | — | — | — | — | — | — | — | — | Not Applicable | — | — | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 7de9a054012f2d20 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | CWAV | Cold Wave | 2005-2024 (19 years) | 0.368 | 0.368 | 58,764 | 10,241,406,107 | 610.471 | 380,166.587 | 3,053.589 | 0.027 | 13,096.649 | 0.019 | 8 | 28.181 | Relatively Low | 2 | 394,681.8 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | b81baf6cafd88b6d |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | DRGT | Drought | 2000-2025 (25 years) | 31.36 | 25.161 | — | — | 610.471 | 106,181.584 | — | — | 106,181.584 | 0.005 | 10 | 45.642 | Relatively Low | 2 | 110,235.723 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 13210b58710a467d |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | ERQK | Earthquake | 2024 dataset | — | 0.002 | 58,805 | 17,389,364,250.057 | 610.471 | 706,226.423 | 466,855.913 | 0.017 | — | 0.036 | 6 | 67.844 | Relatively Low | 2 | 733,190.99 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 4bced2bf1bda9184 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | HAIL | Hail | 1986-2023 (38 years) | 2.642 | 2.647 | 58,764 | 10,241,406,107 | 610.471 | 212,257.435 | 125,690.006 | 0.006 | 4,931.998 | 0.011 | 9 | 44.307 | Relatively Low | 2 | 220,361.677 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | e4b16a6a49f64fe7 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | HRCN | Hurricane | East 1851-2024 (173 years) / West 1949-2024 (76 years) | — | 0.079 | 58,748.668 | 10,238,974,847.05 | 610.471 | 725,579.283 | 633,591.106 | 0.003 | 52,355.321 | 0.037 | 5 | 72.09 | Relatively Low | 2 | 753,282.765 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | ec29cc725653e3b5 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | HWAV | Heat Wave | 2005-2024 (19 years) | 8.263 | 9.526 | 58,764 | 10,241,406,107 | 610.471 | 2,172,364.54 | 65.906 | 0.158 | 1,958.569 | 0.11 | 3 | 85.902 | Relatively Moderate | 3 | 2,255,308.008 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 485e42b167252790 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | IFLD | Riverine Flooding | 1996-2023 (28 years) | 0.929 | 0.929 | 1,665.095 | 10,232,864,387.585 | 38.444 | 10,969,367.242 | 10,852,415.204 | 0.004 | 61,658.81 | 0.555 | 1 | 65.522 | Relatively Low | 2 | 11,388,190.758 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 5ae8debe63b2ed93 |
| 2026-09-28 | 1.20 | 01001 | Autauga | County | Alabama | AL | United States | USA | ISTM | Ice Storm | 1946-2014 (67 years) | 0.418 | 0.402 | 58,764 | 10,241,406,107 | 610.471 | 61,833.91 | 49,468.681 | 0.001 | — | 0.003 | 11 | 42.986 | Relatively Low | 2 | 64,194.802 | 57.57 | Relatively Low | 19,756,570.051 | 336.202 | 0.135 | IFLD | Riverine Flooding | 0.555 | 0 | false | 38.041 | Relatively Low | 55.121 | Relatively Moderate | 2.495 | https://www.fema.gov/about/reports-and-data/openfema/nri/v120/NRI_Table_Counties.zip | 72e7f8748078ce7a |
- Current
20260929T003308Z-73514488a678 · sha256 73514488a678…
58,176 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/fema_nri_county_hazard/fema_nri_county_hazard_intel" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/fema_nri_county_hazard/fema_nri_county_hazard_intel").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/fema_nri_county_hazard/fema_nri_county_hazard_intel
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20260929T003308Z-73514488a678 and its content hash, so readers get exactly the data you used.
FEMA National Risk Index county-hazard intelligence. (2026). FEMA National Risk Index county-hazard intelligence [Data set, snapshot 20260929T003308Z-73514488a678, sha256 73514488a678]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/fema_nri_county_hazard/fema_nri_county_hazard_intel?snapshot=20260929T003308Z-73514488a678
@misc{dz_fema_nri_county_hazard_fema_nri_county_h_73514488,
title = {{FEMA National Risk Index county-hazard intelligence}},
author = {{FEMA National Risk Index county-hazard intelligence}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/fema_nri_county_hazard/fema_nri_county_hazard_intel?snapshot=20260929T003308Z-73514488a678}},
note = {Snapshot 20260929T003308Z-73514488a678, sha256 73514488a6786b94a2819b3b87b9f5ae7e064efada43b6fb2af748d5b0b48d1d; accessed 2026-09-30}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
<iframe src="https://datazimuts.com/embed/chart?dataset=fema_nri_county_hazard%2Ffema_nri_county_hazard_intel&lang=en&theme=auto&snapshot=20260929T003308Z-73514488a678&x=hazard_period_of_record&y=events_per_year&agg=avg" title="FEMA National Risk Index county-hazard intelligence" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.