OpenFEMA Dataset: Public Assistance Funded Projects Details - v1
| Key | Value |
|---|---|
| Entity Name | PublicAssistanceFundedProjectsDetails |
| API Endpoint | https://www.fema.gov/api/open/v1/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 encourages protection of these damaged facilities from future events by providing assistance for hazard mitigation measures during the recovery process (see FEMA Hazard Mitigation Grants Sections 404 and 406: https://www.fema.gov/press-release/20230426/fema-hazard-mitigation-grants-404-and-406).
This is raw, unedited data from FEMA's Emergency Management Mission Integrated Environment (EMMIE) and as such is subject to a small percentage of human error. The financial information is derived from EMMIE 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 News Desk at FEMA-News-Desk@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 | 799764 | medium (50MB - 500MB) |
| json | Link to json | 799764 | large (500MB - 10GB) |
| jsona | Link to jsona | 799764 | large (500MB - 10GB) |
| jsonl | Link to jsonl | 799764 | large (500MB - 10GB) |
| parquet | Link to parquet | 799764 | 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 |
smallint
|
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 |
| 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 of a U.S. state or territory | 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 |
| state | State |
text
|
The name of a U.S. state or territory | yes |
| stateCode | State Code |
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 |
| obligatedDate | Obligated Date |
date
|
Date the grant was obligated | yes |
| dcc | Damage Category Code |
text
|
Damage category code | yes |
| damageCategory | Damage Category |
text
|
The category code of the damage location | 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 |
| id | ID |
uuid
|
Unique ID assigned to the record | yes |
See Also
Access the metadata API calls for additional information: