FEMA
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 |
| History | Disasters - 1953 |
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.
Cybersyn Products
Tables above are available in the following Cybersyn data product:
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 snowflake-public-data@snowflake.com for questions.