← All datasets
# curated.hazard_nfip_claim
FEMA flood insurance claims 1978-present, 8 Houston-area counties (279k) (279,507 rows; category: Flooding & hazards; geometry column `geom` (Point, EPSG:4326))
Notes: Location is only published at ~10 km precision, so never map the points or do point-in-polygon: join census_tract to census tract geoid instead. year_of_loss, date_of_loss; paid_building + paid_contents = payout. flood_event names events like 'Hurricane Harvey'. Only insured homes appear.
Fields (expression | type | filled/distinct in a sample | values or examples):
- id | text | 5000/5000 | e.g.: 16aa65d9-4724-4c5c-85e5-d689870348dd; 4d7b37b3-f94b-4f4f-8026-81749cc2bb77; fa66a345-bac6-417b-a4c8-003048e31545
- date_of_loss | date | 5000/523 | e.g.: 2008-09-13; 2017-08-27; 2017-08-26
- year_of_loss | integer | 5000/49 | e.g.: 2017; 2008; 2001
- county_fips | text | 5000/8 | values: 48201; 48167; 48039; 48339; 48157; 48291; 48071; 48473
- census_tract | text | 4892/980 | e.g.: 48167726100; 48167723900; 48167723800
- zip | text | 5000/229 | e.g.: 77539; 77550; 77554
- city | text | 5000/1 | values: Currently Unavailable
- rated_flood_zone | text | 4861/39 | e.g.: X; AE; C
- flood_zone_current | text | 1876/14 | e.g.: AE; X; A
- occupancy_type | integer | 5000/12 | values: 1; 11; 4; 3; 2; 18; 6; 13; 12; 16; 14; 15
- primary_residence | boolean | 5000/2 | values: true; false
- paid_building | double precision | 4160/3791 | e.g.: 0; 250000; 50000
- paid_contents | double precision | 4160/2106 | e.g.: 0; 100000; 10000
- building_damage | double precision | 4113/3842 | e.g.: 0; 2000; 3000
- contents_damage | double precision | 2665/2399 | e.g.: 0; 2000; 11000
- water_depth_in | double precision | 4682/79 | e.g.: 0; 1; 2
- flood_event | text | 4371/31 | e.g.: Hurricane Harvey; Flooding; Hurricane Ike
- floors | integer | 4958/5 | values: 1; 2; 3; 5; 4
- original_construction_date | date | 5000/1221 | e.g.: 1492-10-12; 1974-12-31; 1970-01-01
- post_firm | boolean | 5000/2 | values: false; true
- elevated_building | boolean | 5000/2 | values: false; true
- cause_of_damage | text | 4922/7 | values: 4; 2; 1; 0; 3; A; D