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 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

Field	Type	Required	Description
record_id	string	Yes	Unique FEMA UUID for the exact declaration and designated-area record.
fema_declaration_string	string	Yes	FEMA declaration identifier combining type, number, and state code.
disaster_number	integer	Yes	FEMA sequential disaster number.
declaration_type	string	Yes	FEMA declaration code: DR, EM, FM, or historical FS.
declaration_title	string	Yes	Official FEMA declaration title.
incident_type	string	Yes	Primary official FEMA incident type.
state_code	string	Yes	FEMA state, district, territory, or Tribal Nation context code.
declared_area	string	Yes	Official FEMA designated geographic area text.
place_code	string	Yes	FEMA internal location code preserved as fixed-width text.
fips_state_code	string	Yes	Two-character state or territory FIPS code when supplied.
fips_county_code	string	Yes	Three-character county or county-equivalent FIPS code when supplied; 000 represents statewide designation.
county_fips	string	No	Derived five-character state+county FIPS only when FEMA supplies a nonzero county code and placeCode agrees with documented county semantics.
geographic_classification	string	Yes	Oddity classification distinguishing county-equivalent, statewide, tribal, special/non-county, and historical geography unavailable.
declaration_date	string	Yes	Official declaration timestamp normalized to ISO date.
incident_begin_date	string	Yes	Incident begin date.
incident_end_date	string	No	Incident end date, nullable for open or incomplete records.
disaster_closeout_date	string	No	Disaster closeout date, nullable.
fiscal_year_declared	integer	Yes	FEMA fiscal year declared.
individual_assistance_declared	boolean	Yes	FEMA IA program boolean.
individuals_and_households_program_declared	boolean	Yes	FEMA Individuals and Households program boolean.
public_assistance_declared	boolean	Yes	FEMA PA program boolean.
hazard_mitigation_declared	boolean	Yes	FEMA HM program boolean.
tribal_request	boolean	Yes	Whether a Tribal Nation submitted the declaration request directly to the President.
declaration_request_number	string	Yes	FEMA declaration request number.
declaration_request_date	string	No	Declaration request date.
last_individual_assistance_filing_date	string	No	Last IA filing date, generally available after 1998.
incident_id	string	Yes	FEMA incident identifier.
fema_region	integer	Yes	FEMA region number.
designated_incident_types	string	No	Source-preserved comma-separated designated incident type codes.
source_last_refresh	string	Yes	FEMA record last-refresh timestamp, never replaced with build time.
source_record_hash	string	Yes	FEMA-provided record hash preserved exactly.

Release at a glance

What is inside this database

Validated release statistics.

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: 0.0%

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.0%

disaster_closeout_dateDisaster closeout date, nullable.

Distinct: 2,008
Missing: 0.0%

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: 0.0%

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: 0.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%

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.

This is NOT an email marketing list