FEMA Disaster Declarations and Declared Areas Database

A developer-ready historical reference to official FEMA disaster declarations and every designated geographic area published with them. The release preserves FEMA re...

Choose your licenseFree with a confirmed account. Download securely.
Secure checkout
Combined multi-format protected ZIP UTF-8 CSVJSONSQLiteREADMESchemaLicenseSigned manifest
FEMA Disaster Declarations and Declared Areas Database List

FEMA Disaster Declarations and Declared Areas Database v.1.0.0

70,272 Database Records

FEMA Disaster Declarations and Declared Areas Database catalog icon FEMA Disaster Declarations and Declared Areas Database Download
A developer-ready historical reference to official FEMA disaster declarations and every designated geographic area published with them. The release preserves FEMA record identity, declaration and incident details, recovery-program flags, state and territory context, request metadata, source refresh evidence, and geographic distinctions that keep county-equivalents, statewide designations, Tribal Nations, and special areas honest.
70,272 Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO

Table Schema Database Field Statistics

Release structure

FEMA Disaster Declarations and Declared Areas Database

Review the published tables, record coverage, and field names included with release 1.0.0.

Database
#803
Version
1.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
FieldTypeRequiredDescription
record_idstringYesUnique FEMA UUID for the exact declaration and designated-area record.
fema_declaration_stringstringYesFEMA declaration identifier combining type, number, and state code.
disaster_numberintegerYesFEMA sequential disaster number.
declaration_typestringYesFEMA declaration code: DR, EM, FM, or historical FS.
declaration_titlestringYesOfficial FEMA declaration title.
incident_typestringYesPrimary official FEMA incident type.
state_codestringYesFEMA state, district, territory, or Tribal Nation context code.
declared_areastringYesOfficial FEMA designated geographic area text.
place_codestringYesFEMA internal location code preserved as fixed-width text.
fips_state_codestringYesTwo-character state or territory FIPS code when supplied.
fips_county_codestringYesThree-character county or county-equivalent FIPS code when supplied; 000 represents statewide designation.
county_fipsstringNoDerived five-character state+county FIPS only when FEMA supplies a nonzero county code and placeCode agrees with documented county semantics.
geographic_classificationstringYesOddity classification distinguishing county-equivalent, statewide, tribal, special/non-county, and historical geography unavailable.
declaration_datestringYesOfficial declaration timestamp normalized to ISO date.
incident_begin_datestringYesIncident begin date.
incident_end_datestringNoIncident end date, nullable for open or incomplete records.
disaster_closeout_datestringNoDisaster closeout date, nullable.
fiscal_year_declaredintegerYesFEMA fiscal year declared.
individual_assistance_declaredbooleanYesFEMA IA program boolean.
individuals_and_households_program_declaredbooleanYesFEMA Individuals and Households program boolean.
public_assistance_declaredbooleanYesFEMA PA program boolean.
hazard_mitigation_declaredbooleanYesFEMA HM program boolean.
tribal_requestbooleanYesWhether a Tribal Nation submitted the declaration request directly to the President.
declaration_request_numberstringYesFEMA declaration request number.
declaration_request_datestringNoDeclaration request date.
last_individual_assistance_filing_datestringNoLast IA filing date, generally available after 1998.
incident_idstringYesFEMA incident identifier.
fema_regionintegerYesFEMA region number.
designated_incident_typesstringNoSource-preserved comma-separated designated incident type codes.
source_last_refreshstringYesFEMA record last-refresh timestamp, never replaced with build time.
source_record_hashstringYesFEMA-provided record hash preserved exactly.

Release at a glance

What is inside this database

Review verified record totals, geographic coverage, classifications, and field completeness for FEMA Disaster Declarations and Declared Areas Database.

70,272Records in this release
31Fields per record
0Duplicate records
0Rejected source rows
record_idUnique FEMA UUID for the exact declaration and designated-area record.
Distinct
70,272
Missing
0.0%
fema_declaration_stringFEMA declaration identifier combining type, number, and state code.
Distinct
5,252
Missing
0.0%
disaster_numberFEMA sequential disaster number.
Distinct
5,252
Missing
0.0%
declaration_typeFEMA declaration code: DR, EM, FM, or historical FS.
Distinct
3
Missing
0.0%
declaration_titleOfficial FEMA declaration title.
Distinct
2,487
Missing
0.0%
incident_typePrimary official FEMA incident type.
Distinct
27
Missing
0.0%
state_codeFEMA state, district, territory, or Tribal Nation context code.
Distinct
59
Missing
0.0%
declared_areaOfficial FEMA designated geographic area text.
Distinct
2,962
Missing
0.0%
place_codeFEMA internal location code preserved as fixed-width text.
Distinct
1,311
Missing
0.0%
fips_state_codeTwo-character state or territory FIPS code when supplied.
Distinct
59
Missing
0.0%
fips_county_codeThree-character county or county-equivalent FIPS code when supplied; 000 represents statewide designation.
Distinct
347
Missing
0.0%
county_fipsDerived five-character state+county FIPS only when FEMA supplies a nonzero county code and placeCode agrees with documented county semantics.
Distinct
3,223
Missing
4.6%
geographic_classificationOddity classification distinguishing county-equivalent, statewide, tribal, special/non-county, and historical geography unavailable.
Distinct
4
Missing
0.0%
declaration_dateOfficial declaration timestamp normalized to ISO date.
Distinct
3,626
Missing
0.0%
incident_begin_dateIncident begin date.
Distinct
3,351
Missing
0.0%
incident_end_dateIncident end date, nullable for open or incomplete records.
Distinct
3,384
Missing
0.9%
disaster_closeout_dateDisaster closeout date, nullable.
Distinct
2,008
Missing
25.2%
fiscal_year_declaredFEMA fiscal year declared.
Distinct
74
Missing
0.0%
individual_assistance_declaredFEMA IA program boolean.
Distinct
2
Missing
0.0%
individuals_and_households_program_declaredFEMA Individuals and Households program boolean.
Distinct
2
Missing
0.0%
public_assistance_declaredFEMA PA program boolean.
Distinct
2
Missing
0.0%
hazard_mitigation_declaredFEMA HM program boolean.
Distinct
2
Missing
0.0%
tribal_requestWhether a Tribal Nation submitted the declaration request directly to the President.
Distinct
2
Missing
0.0%
declaration_request_numberFEMA declaration request number.
Distinct
5,252
Missing
0.0%
declaration_request_dateDeclaration request date.
Distinct
3,803
Missing
0.0%
last_individual_assistance_filing_dateLast IA filing date, generally available after 1998.
Distinct
566
Missing
71.9%
incident_idFEMA incident identifier.
Distinct
4,488
Missing
0.0%
fema_regionFEMA region number.
Distinct
10
Missing
0.0%
designated_incident_typesSource-preserved comma-separated designated incident type codes.
Distinct
113
Missing
68.0%
source_last_refreshFEMA record last-refresh timestamp, never replaced with build time.
Distinct
9
Missing
0.0%
source_record_hashFEMA-provided record hash preserved exactly.
Distinct
70,272
Missing
0.0%

Declaration Type

  • DR46,546
  • EM21,567
  • FM2,159

Geographic Classification

  • County Equivalent67,019
  • Special Or Non County1,622
  • Tribal932
  • Statewide699

Incident Type

Showing the 12 largest groups from 27 represented values.

  • Severe Storm19,380
  • Hurricane13,726
  • Flood11,458
  • Biological7,857
  • Fire3,946
  • Snowstorm3,707
  • Severe Ice Storm2,956
  • Tornado1,623
  • Winter Storm1,378
  • Drought1,292
  • Tropical Storm1,088
  • Coastal Storm637

Null

Showing the 12 largest groups from 31 represented values.

  • Last Individual Assistance Filing Date50,492
  • Designated Incident Types47,812
  • Disaster Closeout Date17,711
  • County Fips3,253
  • Incident End Date648
  • Declaration Request Date10
  • State Code0
  • Source Record Hash0
  • Source Last Refresh0
  • Record Id0
  • Public Assistance Declared0
  • Place Code0

Program True

  • Public Assistance Declared65,747
  • Hazard Mitigation Declared30,021
  • Individual Assistance Declared16,568
  • Individuals And Households Program Declared11,823

Source Hash Length

  • 4070,272

State Territory

Showing the 12 largest groups from 59 represented values.

  • TX5,425
  • KY3,376
  • MO2,874
  • FL2,794
  • GA2,768
  • VA2,756
  • LA2,680
  • OK2,595
  • NC2,431
  • MS2,142
  • PR2,116
  • TN2,038

Year

Showing the 12 largest groups from 74 represented values.

  • 20209,712
  • 20054,736
  • 20112,690
  • 20242,364
  • 20082,300
  • 20211,962
  • 20041,853
  • 20261,723
  • 19931,712
  • 19961,695
  • 20171,668
  • 20191,666

Records Information

Each of the 70,272 records represents one exact OpenFEMA declaration record plus one designated area. Disaster numbers repeat because a declaration can include many geographic areas. FEMA UUID record_id is the primary key. Coverage begins in 1953 and continues through the source cutoff.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Build a broader dataset

Extend this dataset around your project

Combine this database with compatible business, location, or specialty records. Oddity can also scope a custom package by geography, fields, format, and intended use.

Related datasetsField selectionCustom geography
Explore compatible data Discuss a custom package

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details