← 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.: 44ef9310-ee21-410b-8fab-843908012345; 8d3e1ec2-b126-4b54-8ca2-b1db82fd563a; 3ebd9719-d67a-4cf6-b387-ad8bbd4815be
- date_of_loss | date | 5000/537 | e.g.: 2008-09-13; 2017-08-27; 2017-08-26
- year_of_loss | integer | 5000/48 | e.g.: 2017; 2008; 2001
- county_fips | text | 5000/8 | values: 48201; 48167; 48039; 48339; 48157; 48291; 48071; 48473
- census_tract | text | 4915/1020 | e.g.: 48167726100; 48167723900; 48167723800
- zip | text | 5000/236 | e.g.: 77539; 77550; 77089
- city | text | 5000/1 | values: Currently Unavailable
- rated_flood_zone | text | 4860/40 | e.g.: X; AE; C
- flood_zone_current | text | 1888/16 | e.g.: X; AE; VE
- occupancy_type | integer | 5000/12 | values: 1; 11; 4; 3; 2; 18; 6; 13; 16; 15; 12; 14
- primary_residence | boolean | 5000/2 | values: true; false
- paid_building | double precision | 4089/3752 | e.g.: 0; 250000; 50000
- paid_contents | double precision | 4089/2046 | e.g.: 0; 100000; 10000
- building_damage | double precision | 4046/3769 | e.g.: 0; 2000; 1000
- contents_damage | double precision | 2591/2326 | e.g.: 0; 7000; 2000
- water_depth_in | double precision | 4704/86 | e.g.: 0; 1; 2
- flood_event | text | 4332/33 | e.g.: Hurricane Harvey; Flooding; Hurricane Ike
- floors | integer | 4963/6 | values: 1; 2; 3; 5; 4; 6
- original_construction_date | date | 5000/1216 | e.g.: 1492-10-12; 1974-07-01; 1974-12-31
- post_firm | boolean | 5000/2 | values: false; true
- elevated_building | boolean | 5000/2 | values: false; true
- cause_of_damage | text | 4911/6 | values: 4; 1; 2; 0; 3; A