Datasets / fema-nfip-claims-county
FEMA NFIP Redacted Claims — County Aggregates
OpenFEMA NfipClaims v3 full history aggregated as of download 2026-10-15 CT
Cleaned panel with documented schema, transform steps, and checksums—ready to load into analysis tools.
Full file (304.3 KB, 2,945 rows) unlocks after Stripe Checkout. Test mode only — card 4242….
- Rows
- 2,945
- Size
- 304.3 KB
- Format
- CSV
- SHA-256
- 5ff4d5fe47a09dcc50f9792699b02266902674a417847ab0f98261669d26a7a0
Schema
| Column | Type | Description |
|---|---|---|
| county_fips | string | 5-digit county FIPS from countyCode |
| state_abbr | string | State abbreviation |
| county_name | string | County name from Census Gazetteer |
| claim_count | integer | Number of redacted claim records |
| paid_building_usd | number | Sum of amountPaidOnBuildingClaim |
| paid_contents_usd | number | Sum of amountPaidOnContentsClaim |
| paid_total_usd | number | Building + contents + ICC paid |
| year_of_loss_min | integer | Earliest yearOfLoss in county |
| year_of_loss_max | integer | Latest yearOfLoss in county |
| years_with_claims | integer | Distinct years with ≥1 claim |
| distinct_rated_zones | integer | Distinct ratedFloodZone values |
How we prepare this file
- Downloaded OpenFEMA NfipClaimsV3.parquet
- Aggregated claim counts and paid amounts by countyCode + state
- Joined county names from Census 2023 County Gazetteer
- Wrote UTF-8 CSV sorted by county_fips
Refresh cadence: Monthly OpenFEMA refreshes (re-aggregate on refresh)
Preview
| county_fips | state_abbr | county_name | claim_count | paid_building_usd | paid_contents_usd |
|---|---|---|---|---|---|
| 01001 | AL | Autauga County | 77 | 1162621.56 | 205584.8 |
| 01003 | AL | Baldwin County | 19745 | 564430820.44 | 88111950.82 |
| 01005 | AL | Barbour County | 34 | 540607.13 | 154243.6 |
| 01007 | AL | Bibb County | 12 | 30485.45 | 2500.0 |
| 01009 | AL | Blount County | 27 | 132966.96 | 680773.43 |
| 01011 | AL | Bullock County | 3 | 41265.12 | 20849.52 |
| 01013 | AL | Butler County | 3 | 4900.0 | 5000.0 |
| 01015 | AL | Calhoun County | 129 | 569820.1 | 136438.26 |
Sources
OpenFEMA NFIP Redacted Claims v3
Source: FEMA OpenFEMA Dataset NFIP Redacted Claims v3. This product is not endorsed by FEMA.
OpenFEMA secondary use OK with citation and non-endorsement; do not re-identify individuals.
See also the sitewide license & terms.