FEMA National Flood Insurance Program
Flood insurance claims & policies
Every flood insurance claim and policy (no names or addresses), policies by county and year, which communities take part, and their discount class.
Published by FEMA National Flood Insurance Program
Finest detail county
Tables 6
Policies by county and year
Sample of 25 rows out of about 812,851
· 16 columns
| row_id | county_fips | state | policy_year | occupancy_type | rated_flood_zone | records | policies | total_building_coverage | total_contents_coverage | total_premium | total_policy_cost | total_full_risk_premium | records_with_full_risk_premium | snapshot | loaded_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 33009 | NH | 2021 | 14 | A | 1 | 1 | 105000 | 0 | 466 | 622 | 453 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 2 | 17179 | IL | 2021 | 1 | A | 16 | 16 | 2165100 | 260100 | 22279 | 27715 | 25153 | 13 | 2026-09-09 | 2026-10-08 23:39:44 |
| 3 | 39095 | OH | 2021 | 1 | A05 | 2 | 2 | 291000 | 40200 | 684 | 957 | No data | 0 | 2026-09-09 | 2026-10-08 23:39:44 |
| 4 | 12103 | FL | 2021 | 3 | A16 | 2 | 16 | 2073600 | 0 | 4940 | 7130 | No data | 0 | 2026-09-09 | 2026-10-08 23:39:44 |
| 5 | 25001 | MA | 2021 | 6 | V13 | 3 | 3 | 1000000 | 1000000 | 21553 | 26333 | 7114 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 6 | 48141 | TX | 2021 | 18 | A02 | 2 | 2 | 910000 | 0 | 2609 | 3672 | 2373 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
| 7 | 12011 | FL | 2021 | 18 | VE | 1 | 1 | 418000 | 100000 | 4307 | 5379 | 4307 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 8 | 28163 | MS | 2021 | 4 | A | 1 | 1 | 43300 | 0 | 1050 | 1539 | 317 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 9 | 48319 | TX | 2021 | 3 | No data | 1 | 1 | 22000 | 0 | 286 | 637 | 1360 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 10 | 51810 | VA | 2021 | 1 | AO | 4 | 4 | 1000000 | 147200 | 3555 | 5169 | 6460 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
| 11 | 22035 | LA | 2021 | 1 | X | 4 | 4 | 750000 | 380000 | 1579 | 2065 | 1315 | 3 | 2026-09-09 | 2026-10-08 23:39:44 |
| 12 | 31019 | NE | 2021 | 4 | AE | 4 | 4 | 251400 | 0 | 1554 | 3035 | 1176 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
| 13 | 27059 | MN | 2021 | 1 | AE | 27 | 27 | 5481300 | 115500 | 53179 | 66127 | 29541 | 21 | 2026-09-09 | 2026-10-08 23:39:44 |
| 14 | 08055 | CO | 2021 | 1 | AE | 19 | 19 | 2217500 | 317300 | 24237 | 30701 | 27076 | 11 | 2026-09-09 | 2026-10-08 23:39:44 |
| 15 | 55045 | WI | 2021 | 2 | X | 1 | 1 | 150000 | 60000 | 375 | 718 | 251 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 16 | 29071 | MO | 2021 | 18 | C | 1 | 1 | 0 | 150000 | 1985 | 2639 | 1985 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 17 | 48469 | TX | 2021 | 2 | X | 9 | 9 | 2150000 | 488300 | 23994 | 30691 | 5115 | 7 | 2026-09-09 | 2026-10-08 23:39:44 |
| 18 | 45015 | SC | 2021 | 1 | B | 11 | 11 | 2370500 | 880000 | 5003 | 6505 | 9185 | 9 | 2026-09-09 | 2026-10-08 23:39:44 |
| 19 | 50019 | VT | 2021 | 11 | A | 2 | 2 | 187000 | 0 | 3411 | 4394 | 3504 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
| 20 | 41057 | OR | 2021 | 1 | C | 7 | 7 | 1475000 | 590000 | 3041 | 5139 | 4502 | 3 | 2026-09-09 | 2026-10-08 23:39:44 |
| 21 | 42099 | PA | 2021 | 2 | AE | 12 | 12 | 943400 | 32700 | 13004 | 18269 | 15361 | 7 | 2026-09-09 | 2026-10-08 23:39:44 |
| 22 | 54051 | WV | 2021 | 11 | AE | 3 | 3 | 233000 | 30000 | 6545 | 7939 | 6648 | 3 | 2026-09-09 | 2026-10-08 23:39:44 |
| 23 | 55101 | WI | 2021 | 3 | AE | 1 | 1 | 500000 | 8000 | 707 | 1134 | 4430 | 1 | 2026-09-09 | 2026-10-08 23:39:44 |
| 24 | 48463 | TX | 2021 | 11 | X | 2 | 2 | 337000 | 160000 | 697 | 967 | 719 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
| 25 | No data | LA | 2021 | 3 | X | 11 | 11 | 2105000 | 388000 | 3656 | 6664 | 529 | 2 | 2026-09-09 | 2026-10-08 23:39:44 |
Need the whole thing? Spreadsheet links, downloads, and AI access come with Level 3.
See pricing