FEMA Disaster Declaration Index
Snowflake table name : CYBERSYN.FEMA_DISASTER_DECLARATION_INDEX
Last updated
Snowflake table name : CYBERSYN.FEMA_DISASTER_DECLARATION_INDEX
Last updated
Copyright © 2024 Cybersyn
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