FEMA

Federal Emergency Management Agency

Overview

The Federal Emergency Management Agency (FEMA) provides data on federally-declared disasters in the United States, disaster recovery public assistance funding, and policies and claims from the National Flood Insurance Program (NFIP).

Example topics covered:

• Name, type, date, public assistance funding for each federally-declared disaster

• Geographic entities impacted by federally-declared disasters

• Mission assignments or "work orders" issued by FEMA to other government agencies

• NFIP policies and claims (e.g. rates, policy duration, building/contents covered)

• FEMA region names

Key Attributes

Geographic Coverage	United States
Entity Level	Geography, FEMA Regions, FEMA Disaster Declarations, FEMA Mission Assignments, FEMA NFIP Policies, FEMA NFIP Claims
Time Granularity	Daily, between 4-5am ET
Release Frequency	Disasters and Mission Assignments - Daily NFIP Policies and Claims - Monthly Region Index - Ad hoc
History	Disasters - 1953 Mission Assignments - 2012 NFIP Claims - 1978 NFIP Policies - 2009

As with all Public Domain datasets, Cybersyn aims to release data on Snowflake Marketplace as soon as the underlying source releases new data. We check periodically for changes to the underlying source and, upon detecting a change, propagate the data to Snowflake Marketplace immediately. See our release process for more details.

Notes

The Federal Emergency Management Agency (FEMA) provides data on federally-declared disasters (e.g. hurricanes, droughts, terrorist attacks, release of toxic substances), disaster recovery public programs, and policies and claims from the National Flood Insurance Program (NFIP) — an insurance program managed by FEMA that provides flood insurance to the public through a network of 50+ insurance companies. Disaster declaration details include name, type, date, public assistance funding, impacted geographies, and work orders issued by FEMA to other government agencies for emergency response support. Flood policies and claims from the NFIP include features of the covered property, flood event, cost of damage, insurance payouts, building and contents insurance coverage, and policy deductibles, rates and duration.

EAV Model: All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company) that Cybersyn provides data on. Index tables contain all entities of a certain type. Timeseries tables contain all timeseries' dates and values that refer to an entity type. Additional tables, such as the relationships table and attributes table, are used to describe the entities and timeseries. Data is joinable across all Cybersyn products that have a GEO_ID. Refer to Cybersyn Concepts for more details.

Tables & Sources

Tables	Sources
FEMA_DISASTER_DECLARATION_AREAS_INDEX FEMA_DISASTER_DECLARATION_INDEX	FEMA Disaster Declarations
FEMA_REGION_INDEX	FEMA Regions
FEMA_MISSION_ASSIGNMENT_INDEX	FEMA Mission Assignments
FEMA_NATIONAL_FLOOD_INSURANCE_PROGRAM_POLICY_INDEX	FEMA NFIP Policies
FEMA_NATIONAL_FLOOD_INSURANCE_PROGRAM_CLAIM_INDEX	FEMA NFIP Claims

Cybersyn Products

Tables above are available in the following Cybersyn data product:

• Weather & Environment

• Enterprise

Examples & Sample Queries

Volume of insurance policy claims in a specific region

Evaluate the trend of flood-related insurance claims in New York over the last 10 years.

SELECT 
    YEAR(claims.date_of_loss) 	      AS year_of_loss,
    claims.nfip_community_name,
    SUM(claims.building_damage_amount) AS total_building_damage_amount,
    SUM(claims.contents_damage_amount) AS total_contents_damage_amount
FROM cybersyn.fema_national_flood_insurance_program_claim_index claims
LEFT JOIN cybersyn.geography_index geo
  ON claims.state_geo_id = geo.geo_id
WHERE geo.geo_name = 'New York' 
    AND claims.nfip_community_name = 'City Of New York' 
    AND year_of_loss >= YEAR(DATEADD(YEAR, -10, CURRENT_DATE()))
GROUP BY year_of_loss, claims.nfip_community_name
ORDER BY year_of_loss, claims.nfip_community_name;

Disclaimers

The data in this product is sourced from the Federal Emergency Management Agency (FEMA).

This product uses the Federal Emergency Management Agency’s OpenFEMA API, but is not endorsed by FEMA. The Federal Government or FEMA cannot vouch for the data or analyses derived from these data after the data have been retrieved from the Agency's website(s).

Cybersyn is not endorsed by or affiliated with any of these providers. Contact [e-mail] for questions.