FEMA Disaster Declaration Index

Snowflake table name : CYBERSYN.FEMA_DISASTER_DECLARATION_INDEX

View data source documentation here.

Name	Description	Type	Example
DISASTER_ID	Sequentially FEMA-assigned number used to designate an event or incident declared as a disaster.	VARCHAR	4076
FEMA_DISASTER_DECLARATION_ID	Agency standard method for uniquely identifying Stafford Act declarations, which is a concatenation of declaration type, disaster number and state code	VARCHAR	DR-4076-WI
DISASTER_DECLARATION_REQUEST_ID	Number assigned to the declaration request.	VARCHAR	13003
DISASTER_DECLARATION_NAME	Title for the disaster.	VARCHAR	Severe Storms And Flooding
DISASTER_DECLARATION_TYPE	Identifies the disaster declaration as major disaster, fire management, or emergency declaration.	VARCHAR	Disaster Declaration
DISASTER_DECLARATION_DATE	Date the disaster was declared.	DATE	2024-02-27
DISASTER_TYPE	Type of disaster such as fire or flood.	VARCHAR	Fire
DISASTER_BEGIN_DATE	Date the disaster itself began.	DATE	2013-02-10
DISASTER_END_DATE	Date the disaster itself ended.	DATE	2021-06-10
DECLARED_PROGRAMS	Major programs declared for all geographies impacted by the disaster.	ARRAY	[ "Hazard Mitigation Program", "Public Assistance Program" ]
PUBLIC_ASSISTANCE_UPDATE_DATE	The date the Public Assistance (PA) data was updated by NEMIS.	DATE	2024-05-31
INDIVIDUAL_ASSISTANCE_UPDATE_DATE	The date the Individual Assistance (IA) data was updated by NEMIS.	DATE	2024-05-31
APPROVED_INDIVIDUAL_ASSISTANCE_APPLICATIONS	The number of disaster assistance applications that were approved for Individual Assistance (IA).	NUMBER	2999
APPROVED_INDIVIDUAL_AND_HOUSEHOLDS_PROGRAM_AMOUNT	The total amount approved for the Individual and Households Program (IHP) in dollars.	FLOAT	1149730846.28
APPROVED_HOUSING_ASSISTANCE_AMOUNT	The total amount approved for Housing Assistance (HA) from the Individual and Households Program (IHP) in dollars.	FLOAT	10765588.81
APPROVED_OTHER_NEEDS_ASSISTANCE_AMOUNT	The total amount approved for Other Needs Assistance (ONA) from the Individual and Households Program (IHP) in dollars.	FLOAT	657245.61
STATE_OBLIGATED_PUBLIC_ASSISTANCE_AMOUNT	The Public Assistance grant funding available in dollars to the grantee (State), for sub-grantee approved Project Worksheets.	FLOAT	89556.6
STATE_OBLIGATED_PUBLIC_ASSISTANCE_CATEGORY_A_B_AMOUNT	The Public Assistance grant funding available in dollars to the grantee (State), for sub-grantee approved Project Worksheets in categories A and B, or Emergency Work. Category A is Debris removal; Category B is Emergency protective measures.	FLOAT	890408.77
STATE_OBLIGATED_PUBLIC_ASSISTANCE_CATEGORY_C_TO_G_AMOUNT	The Public Assistance grant funding available in dollars to the grantee (State), for sub-grantee approved Project Worksheets in categories C through G, or Permanent Work. Category C is Roads and bridges; Category D is Water control facilities; Category E is Public buildings and contents; Category F is Public utilities; Category G is Parks, recreational, and other facilities.	FLOAT	6928401.83
STATE_OBLIGATED_HAZARD_MITIGATION_GRANT_PROGRAM_AMOUNT	Total amount obligated under the Hazard Mitigation Grant Program in dollars. The total amount obligated represents the amount obligated for Regular Project Costs, Planning Costs, Initiative Project Costs, Recipient Management Costs, Recipient Admin Costs and Subrecipient Admin Costs.	FLOAT	73741.0