FIMA NFIP Redacted Claims Data Set

Description

Identifier: nfip_claims

Claims transactions from the Federal Insurance & Mitigation Administration National Flood Insurance Program (FIMA NFIP). Data is as of 2019-08-31.

Vintages

5e118d5 (current)

Columns

• agriculture_structure_indicator <character> Yes (Y) or No (N) indicator of whether or not a building is reported as being an agricultural structure in the policy application.
• as_of_date <character> The effective date of the data in the file.
• base_flood_elevation <numeric> Base Flood Elevation (BFE) is the elevation at which there is a 1% chance per year of flooding in feet from the elevation certificate.
• reported_city <character> The city of the insured property as reported by Write Your Own (WYO) partners
• policy_count <integer> Insured units in an active status. A policy contract ceases to be in an active status as of the cancellation date or the expiration date. Residential Condominium Building Association Policy (RCBAP) contracts are stored as a single policy contract but insure multiple units and therefore represent multiple policies.
• county_code <character> FIPS code uniquely identifying the primary county (e.g., 011 represents Broward County) associated with the project. Note, the County Code field may not reflect the individual county the property is located as projects can be associated with more than one county.
• community_rating_system_discount <numeric> The Community Rating System (CRS) Classification Credit Percentage used to rate the policy. The insurance premium credit is based on whether a property is in or out of the Special Flood Hazard Area (SFHA) as shown on the community’s Flood Insurance Rate Map.
• date_of_loss <character> Date on which water first entered the insured building.
• elevated_building_indicator <character> Yes (Y) or No (N) indicator of whether or not a building meets the NFIP definition of an elevated building.
• elevation_difference <numeric> Difference in feet between the elevation of the lowest floor used for rating or the floodproofed elevation and the base flood elevation (BFE), or base flood depth, as appropriate from the elevation certificate.
• census_tract <character> US Census Bureau defined census Tracts; statistical subdivisions of a county or equivalent entity that are updated prior to each decennial census. The NFIP relies on our geocoding service to assign census tract code. 11 digit code defining census tract
• flood_zone <character> Flood zone derived from the Flood Insurance Rate Map (FIRM) used to rate the insured property.
• house_worship <character> Yes (Y) or No (N) indicator of whether or not a building is reported as being a house of worship in the policy application.
• latitude <numeric> Approximate latitude of the insured building (to 1 decimal place). This represents the approximate location of the insured property. The precision has been lessened to ensure individual privacy. This may result in a point location that exists in an incorrect county or state. Use the state and county fields for record aggregation for these dimensions.
• location_of_contents <character> Where within the structure the contents are located.
• longitude <numeric> Approximate longitude of the insured building (to 1 decimal place). This represents the approximate location of the insured property. The precision has been lessened to ensure individual privacy. This may result in a point location that exists in an incorrect county or state. Use the state and county fields for record aggregation for these dimensions.
• lowest_adjacent_grade <numeric> Lowest natural grade adjacent to the insured structure prior to excavating or filling. The difference in feet of the lowest natural grade adjacent to the building from the reference level of the building.
• lowest_floor_elevation <numeric> A building’s lowest floor is the floor or level (including basement/enclosure/crawlspace/subgrade crawlspace) that is used as the point of reference when rating a building. This includes the level to which a building is floodproofed. The elevation in feet of the reference level of the building from the elevation certificate.
• non_profit_indicator <character> Yes (Y) or No (N) indicator of whether or not a building is reported as being a non-profit in the policy application.
• obstruction_type <integer> Code that gives the type of obstruction (if any) in the enclosure (if any).
• original_construction_date <character> The original date of the construction of the building.
• original_nb_date <character> The original date of the flood policy.
• amount_paid_on_building_claim <numeric> Dollar amount paid on the building claim. In some instances, a negative amount may appear which occurs when a check issued to a policy holder isn’t cashed and has to be re-issued.
• amount_paid_on_contents_claim <numeric> Dollar amount paid on the contents claim. In some instances, a negative amount may appear, which occurs when a check issued to a policy holder isn’t cashed and has to be re-issued.
• amount_paid_on_increased_cost_of_compliance_claim <numeric> Dollar amount paid on the Increased Cost of Compliance (ICC) claim. Increased Cost of Compliance (ICC) coverage is one of several flood insurances resources for policyholders who need additional help rebuilding after a flood. It provides up to $30,000 to help cover the cost of mitigation measures that will reduce the flood risk.
• post_firm_construction_indicator <character> Yes or No Indicator on whether construction was started before or after publication of the FIRM. For insurance rating purposes, buildings for which the start of construction or substantial improvement was after December 31, 1974, or on or after the effective date of the initial FIRM for the community, whichever is later, are considered Post-FIRM construction.
• small_business_indicator_building <character> Yes (Y) or No (N) indicator of whether or not the insured represents a small business. Small business is defined as a business with fewer than 100 employees in the policy application.
• state <character> State in which the insured property is located.
• total_building_insurance_coverage <numeric> Total insurance amount in dollars on the building.
• total_contents_insurance_coverage <numeric> Total insurance amount in dollars on the contents.
• year_of_loss <integer> Year in which the flood loss occurred.
• reported_zip_code <character> 5 digit Postal Zip Code of the insured property.
• primary_residence <character> Yes (Y) or No (N) indicator of whether or not a building is a primary residence.
• basement_enclosure_crawlspace_type <character> Basement is defined for purposes of the NFIP as any level or story which has its floor subgrade on all sides.
• condominium_indicator <character> Indicator of what type of condominium property is being insured.
• elevation_certificate_indicator <character> Indicates if a policy has been rated with elevation certificate.
• number_of_floors_in_the_insured_building <character> Number of floors in the insured building.
• occupancy_type <character> Use and occupancy type of the insured structure.
• rate_method <character> Policy rating method.

Summary

Variable type: character

Variable type: numeric

Source

Data and column descriptions from FEMA, https://www.fema.gov/media-library/assets/documents/180374