OpenFEMA Dataset: Public Assistance Grant Award Activities - v2
| Key | Value |
|---|---|
| Entity Name | PublicAssistanceGrantAwardActivities |
| API Endpoint | https://www.fema.gov/api/open/v2/PublicAssistanceGrantAwardActivities |
| Update Frequency | R/P1D |
| Program URL | https://www.fema.gov/assistance/public |
| Category | Public Assistance |
| Keywords | public assistance |
Description
This dataset contains data on Public Assistance project awards (obligations), including the project obligation date(s); dollar amount of Federal Share Obligated for each project and its obligation date(s); FEMA Region; State; Disaster Declaration Number; descriptive cause of the declaration (Incident Type); Entity requesting public assistance (Applicant Name); and distinct name for the repair, replacement or mitigation work listed for assistance (Project Title).
As part of disaster declarations, the President can make federal funding (Public Assistance) available through FEMA to eligible state, local and tribal governments and certain private nonprofit organizations. This is done on a cost-sharing basis for emergency work and the repair, replacement, or mitigation work for facilities damaged by the disaster event.
As part of Congressional bill HR 152 - the Sandy Recovery Improvement Act of 2013, FEMA is providing the following information for our stakeholders: Region, Disaster Declaration Number, Disaster Type, State, Applicant, County, Damage Category Code, Federal Share Obligated, and Date Obligated.
Note: FEMA obligates funding for a project directly to the Recipient (State or Tribe). It is the Recipient's responsibility to ensure that the eligible subrecipient (listed in the dataset as Applicant Name) receives the award funding.
This dataset lists details about project versions (occurring when the scope/cost changes for a project). Versions adjust the cost of the project with positive additions called obligations and subtractions called deobligations. Combined, they reconcile to reflect the Total Federal Share Obligation, but reconciliation occurs over the life of the project - sometimes years after the declaration date. The prior version of this dataset included project obligations within a seven-day period prior to the listed date. This version includes obligations from 1998 to present, excluding obligations uploaded on the same day as the publication. Open projects still under pre-obligation processing are not represented. For more information on the Public Assistance process see: https://www.fema.gov/assistance/public/process
This is raw, unedited data from FEMA's Emergency Management Mission Integrated Environment (EMMIE) system 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 how business rules are applied, this financial information may differ slightly from official publication on public websites such as usaspending.gov. This dataset is not intended to be used for any official federal financial reporting.
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 | 952108 | medium (50MB - 500MB) |
| json | Link to json | 952108 | medium (50MB - 500MB) |
| jsona | Link to jsona | 952108 | medium (50MB - 500MB) |
| jsonl | Link to jsonl | 952108 | medium (50MB - 500MB) |
Data Fields
| Name | Title | Type | Description | Is Searchable |
|---|---|---|---|---|
| region | Region |
smallint
|
Number (1-10) used to represent a defined group of state/territories administered by separate FEMA regions | yes |
| 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, https://www.fema.gov/disaster | yes |
| sriaDisaster | Sandy Disaster |
boolean
|
Yes/No indicator that identifies declarations declared after SRIA (01/29/13). Yes is indicated with either a 'true' or '1'. No is indicated with either a 'false' or '0' | yes |
| declarationTitle | Disaster Declaration Title |
text
|
Title for the disaster, if it exists in the source system. | yes |
| disasterType | Disaster Type |
text
|
Two character code that identifies the declaration as a major disaster (DR), or emergency declaration (EM). For more information on the disaster process, please visit: https://www.fema.gov | yes |
| incidentType | Incident Type |
text
|
The incident type is a description of the cause of the damage or reason for the declaration such as fire, flood | yes |
| declarationDate | Declaration Date |
date
|
Date the disaster was declared for Public Assistance | yes |
| stateAbbreviation | State Abbreviation |
text
|
Two letter abbreviation of the state (e.g., VA) | yes |
| state | State |
text
|
The name or phrase describing the U.S. state, district, or territory | yes |
| county | County |
text
|
The name of the applicant county, parish, borough, independent city or other political subdivision of a U.S. state, local, tribal or territorial government | yes |
| applicantId | Applicant Identifier |
text
|
Unique Public Assistance applicant identification number | yes |
| applicantName | Applicant Name |
text
|
Name of the state, local, tribe, territory or private non-profit requesting Public Assistance Grant funding. (Eligible Public Assistance applicants are subgrantees) | yes |
| pnpStatus | PNP Status |
boolean
|
Indicates whether the applicant is a Private Non-Profit (NPN) applicant. Yes is indicated with either a 'true' or '1'. No is indicated with either a 'false' or '0' | no |
| damageCategoryCode | Damage Category Code |
text
|
The code that specifies the overall category of facilities or work completed for a project. Emergency work category codes: Category A: Debris Removal - Clearance of trees and woody debris; certain building wreckage; damaged/destroyed building contents; sand, mud, silt, and gravel; vehicles; and other disaster-related material deposited on public and, in very limited cases, private property .Category B: Emergency Protective Measures - Measures taken before, during, and after a disaster to eliminate/reduce an immediate threat to life, public health, or safety - or to eliminate/reduce an immediate threat of significant damage to improved public and private property through cost-effective measures. Permanent work damage category Codes: Category C - Roads and Bridges Repair of roads, bridges, and associated features, such as shoulders, ditches, culverts, lighting, and signs. Category D - Water Control Facilities Repair - Repair of drainage channels, pumping facilities, and some irrigation facilities. Repair of levees, dams, and flood control channels Category E - Buildings and Equipment Repair - Replacement of buildings, including their contents and systems; heavy equipment; and vehicles. Category F - Utilities Repair - Repair of water treatment and delivery systems; power generation facilities and distribution facilities; sewage collection and treatment facilities; and communications. Category G - Parks, Recreational Facilities, and Other Facilities Repair - Repair and restoration of parks, playgrounds, pools, cemeteries, mass transit facilities, and beaches. This category also is used for any work or facility that cannot be characterized adequately by Categories A-F | yes |
| federalShareObligated | Federal Share Obligated |
decimal
|
The Public Assistance Grant award amount obligated for the subgrantees approved Project Worksheet (PW). The Federal Share Obligated amount may represent only a portion of the Total Federal Share Obligated amount for the PW. This amount does not reflect previous or subsequent obligations. The Federal Share Obligated may contain De-Obligations which are negative adjustments to the Total Federal Share Obligated. | yes |
| dateObligated | Date Obligated |
date
|
Date the grant was provided to the recipient | yes |
| pwNumber | Project Worksheet (PW) Number |
integer
|
Number given to the project to uniquely identify it within a declaration | yes |
| projectTitle | Project Title |
text
|
Brief description of the project used as a naming convention of the project | yes |
| versionNumber | Version Number |
smallint
|
Natural ordinal number signifying revisions to the project scope or cost. The first version is 0 and successive versions are numbered in increments of 1. | yes |
| eligibilityStatus | Eligibility Status |
text
|
Status of the project-version reflecting project eligibility requirements. E - Eligible; P - Pending; I - Ineligible; V - Voided | yes |
| fundingStatus | Funding Status |
text
|
Obligation status of the project-version. O - Obligated; N - Not Obligated | yes |
| paCloseoutStatus | PA Closeout Status |
text
|
Indicates if the project has been closed out. This helps identify projects that are still ongoing. O - Open; C - Closed | yes |
| id | ID |
uuid
|
Unique ID assigned to the record that does not persist between data set refreshes | yes |
See Also
Access the metadata API calls for additional information: