OpenFEMA Dataset: Public Assistance Funded Projects Details - v1

Version: 1
Last Data Refresh: 03-17-2024
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 807182 medium (50MB - 500MB)
json Link to json 807182 large (500MB - 10GB)
jsona Link to jsona 807182 large (500MB - 10GB)
jsonl Link to jsonl 807182 large (500MB - 10GB)

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:

Last updated