OpenFEMA Dataset: Public Assistance Funded Projects Details - v2

Version: 2
Last Data Refresh: 09-18-2025
Key Value
Entity Name PublicAssistanceFundedProjectsDetails
API Endpoint https://www.fema.gov/api/open/v2/PublicAssistanceFundedProjectsDetails
Update Frequency R/P1D
Program URL https://www.fema.gov/assistance/public
Category Public Assistance
Keywords public

Description

The Public Assistance Funded Projects Details dataset contains obligated (financial obligation to grantee) Public Assistance projects, lists public assistance recipients designated as applicants in the data, and a list of every funded, individual project, called project worksheets. Open projects still under pre-obligation processing are not represented. Applicant details can be obtained by relating this dataset with the OpenFEMA Public Assistance Applicants dataset using the Applicant ID field.

FEMA provides supplemental Federal disaster grant assistance for debris removal, emergency protective measures, and the repair, replacement, or restoration of disaster-damaged, publicly owned facilities and the facilities of certain Private Non-Profit (PNP) organizations through the PA Program (CDFA Number 97.036). The PA Program also provides 406 hazard mitigation funding for damaged facilities during the recovery process to encourage protection from future events. See FEMA PA Hazard Mitigation: https://www.fema.gov/assistance/public/hazard-mitigation

Data comes from FEMA's Applicant Case Tracker (FAC-Trax), which includes the Grants Manager (GM) database. This raw unedited data is subject to a small percentage of human error. The financial information is derived from GM and not FEMA's official financial systems. Due to differences in reporting periods, status of obligations, and application of business rules, this financial information may differ slightly from official publication on public websites such as www.usaspending.gov. This dataset is not intended to be used for any official federal reporting.

The data has been incorporated into a graphic visualization at Public Assistance Program Summary of Obligations: https://www.fema.gov/data-visualization/public-assistance-program-summary-obligations. Questions pertaining to the data visualizations should be addressed to EnterpriseAnalytics@fema.dhs.gov.

FEMA's terms and conditions and citation requirements for datasets (API usage or file downloads) can be found on the OpenFEMA Terms and Conditions page: https://www.fema.gov/about/openfema/terms-conditions

For answers to Frequently Asked Questions (FAQs) about the OpenFEMA program, API, and publicly available datasets, please visit: https://www.fema.gov/about/openfema/faq

If you have media inquiries about this dataset, please email the FEMA Press Office at FEMA-Press-Office@fema.dhs.gov or call (202) 646-3272. For inquiries about FEMA's data and Open Government program, please email the OpenFEMA team at OpenFEMA@fema.dhs.gov.

Full Data

Format Address Record Count Approximate File Size
csv Link to csv 800982 medium (50MB - 500MB)
json Link to json 800982 large (500MB - 10GB)
jsona Link to jsona 800982 large (500MB - 10GB)
jsonl Link to jsonl 800982 large (500MB - 10GB)
parquet Link to parquet 800982 medium (50MB - 500MB)

Data Fields

Name Title Type Description Is Searchable
disasterNumber Disaster Number
smallint
Sequentially assigned number used to designate an event or incident declared as a disaster. For more information on the disaster process visit https://www.fema.gov/disasters/how-declared yes
declarationDate Declaration Date
date
Date the disaster was declared yes
incidentType Incident Type
text
Type of incident such as fire or flood. The incident type will affect the types of assistance available. For more information on incident types, please visit: https://www.fema.gov yes
pwNumber Project Worksheet Number
integer
Sequentially assigned number used to identify a unique project yes
applicationTitle Application Title
text
Standard, non-unique (free form text) application title yes
applicantId Applicant ID
text
Unique Public Assistance applicant identification number yes
damageCategoryCode Damage Category Code
text
Code representing the type of work eligible for reimbursement through a Public Assistance grant; for a full listing of each category please go to https://www.fema.gov/assistance/public/program-overview yes
damageCategoryDescrip Damage Category Description
text
Damage category code related to the Damage Category Description yes
projectStatus Project Status
text
An active or inactive status of the project yes
projectProcessStep Project Process Step
text
The current process location of a project from formulation through closeout including pending stages, discontinuation and obligation. yes
projectSize Project Size
text
Projects are designated as Large or Small, which can affect a number of variables in case management (processing). Project size is determined by the eligible amount as set in the damage survey yes
county County
text
The name of a U.S. county, parish, borough, independent city or other political subdivision specifying the applicant location. Counties may not be available for tribal, territories or applicants lacking specified headquarter locations. yes
countyCode County Code
text
Unique identifier for a U.S. county; typically, this identifier makes up the last three digits of a five digit Federal Information Processing Standard (FIPS) Code yes
stateAbbreviation State Abbreviation
text
Two-character unique identifier for a U.S. state or territory yes
stateNumberCode State Number Code
text
Unique identifier for a U.S. state or territory; this identifier makes up the first two digits of a five digit Federal Information Processing Standard (FIPS) Code yes
projectAmount Project Amount
decimal
The estimated total cost of the Public Assistance grant project in dollars, without administrative costs. This amount is based on the damage survey. yes
federalShareObligated Federal Share Obligated
decimal
The Public Assistance grant funding available to the grantee (State) in dollars, for sub-grantee's approved Project Worksheets yes
totalObligated Total Obligated
decimal
The federal share of the Public Assistance grant eligible project amount in dollars, plus grantee (State) and sub-grantee (applicant) administrative costs. The federal share is typically 75% of the total cost of the project yes
lastObligationDate Last Obligation Date
datetime
Date the grant was last obligated yes
firstObligationDate First Obligation Date
datetime
Date the grant was initially obligated yes
mitigationAmount Mitigation Amount
decimal
Public Assistance proposed amount that applies to 406 mitigation. Note: does not capture some HMP proposals in the cost lines. Some negative values may exist and are due to adjustments between mitigation costs and project costs, deobligations within versions, and incorrectly categorized mitigation cost lines. yes
gmProjectId GM Project Identifier
bigint
The numeric project identification number used in GM for individual projects. yes
gmApplicantId GM Applicant Identifier
bigint
The numeric applicant identification number used in GM that represents an applicant in a declaration. yes
lastRefresh Last Refresh
datetimez
Date the record was last updated in the API data store yes
hash Hash
text
MD5 Hash of the fields and values of the record no

See Also

Access the metadata API calls for additional information:

Last updated