FEMA Disaster Declaration Index

Snowflake table name : CYBERSYN.FEMA_DISASTER_DECLARATION_INDEX

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
DISASTER_ID	Sequentially FEMA-assigned number used to designate an event or incident declared as a disaster.	VARCHAR	5390
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	EM-3249-WI
DISASTER_DECLARATION_REQUEST_ID	Number assigned to the declaration request.	VARCHAR	18070
DISASTER_DECLARATION_NAME	Title for the disaster.	VARCHAR	Lind Fire
DISASTER_DECLARATION_TYPE	Identifies the disaster declaration as major disaster, fire management, or emergency declaration.	VARCHAR	Emergency Declaration
DISASTER_DECLARATION_DATE	Date the disaster was declared.	DATE	2009-07-17
DISASTER_TYPE	Type of disaster such as fire or flood.	VARCHAR	Fire
DISASTER_BEGIN_DATE	Date the disaster itself began.	DATE	2005-08-29
DISASTER_END_DATE	Date the disaster itself ended.	DATE	2023-11-20
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-04-11
INDIVIDUAL_ASSISTANCE_UPDATE_DATE	The date the Individual Assistance (IA) data was updated by NEMIS.	DATE	2024-04-11
APPROVED_INDIVIDUAL_ASSISTANCE_APPLICATIONS	The number of disaster assistance applications that were approved for Individual Assistance (IA).	NUMBER	8144
APPROVED_INDIVIDUAL_AND_HOUSEHOLDS_PROGRAM_AMOUNT	The total amount approved for the Individual and Households Program (IHP) in dollars.	FLOAT	164517307.53
APPROVED_HOUSING_ASSISTANCE_AMOUNT	The total amount approved for Housing Assistance (HA) from the Individual and Households Program (IHP) in dollars.	FLOAT	4390958.02
APPROVED_OTHER_NEEDS_ASSISTANCE_AMOUNT	The total amount approved for Other Needs Assistance (ONA) from the Individual and Households Program (IHP) in dollars.	FLOAT	3229489.21
STATE_OBLIGATED_PUBLIC_ASSISTANCE_AMOUNT	The Public Assistance grant funding available in dollars to the grantee (State), for sub-grantee approved Project Worksheets.	FLOAT	15302173.31
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	21740284.62
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	2821849.55
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	1282638.95