OpenFEMA Dataset: Public Assistance Funded Projects Details - v2
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: