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

TablesSources

FEMA_DISASTER_DECLARATION_AREAS_INDEX FEMA_DISASTER_DECLARATION_INDEX

FEMA_REGION_INDEX

FEMA_MISSION_ASSIGNMENT_INDEX

FEMA_NATIONAL_FLOOD_INSURANCE_PROGRAM_POLICY_INDEX

FEMA_NATIONAL_FLOOD_INSURANCE_PROGRAM_CLAIM_INDEX

Cybersyn Products

Tables above are available in the following Cybersyn data product:

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 support@cybersyn.com for questions.

Last updated

Copyright Β© 2024 Cybersyn