OpenFEMA Dataset: Public Assistance Grant Award Activities - v1
| Entity Name | PublicAssistanceGrantAwardActivities |
|---|---|
| API Endpoint | https://www.fema.gov/api/open/v1/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 dataset represents project obligations within a seven-day period prior to the listed date but does not include 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 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 | 563 | tiny (< 10MB) |
| json | Link to json | 563 | tiny (< 10MB) |
| jsona | Link to jsona | 563 | tiny (< 10MB) |
| jsonl | Link to jsonl | 563 | tiny (< 10MB) |
Data Fields
| Name | Title | Type | Description | Is Searchable |
|---|---|---|---|---|
| region | Region |
smallint
|
Number (1-10) used to represent the Region | 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, hhttps://www.fema.gov/disaster | yes |
| sandyDisaster | Sandy Disaster |
boolean
|
Yes/No indicator that identifies if the disaster areas were affected by Hurricane Sandy. Yes is indicated with either a 'true' or '1'. No is indicated with either a 'false' or '0' | yes |
| disasterType | Disaster Type |
text
|
Two character code that defines if this is a major disaster (DR), fire management (FM) 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 a U.S. county, parish, borough, independent city or other political subdivision of a U.S. state, local, tribal or territorial government | yes |
| applicantName | Applicant Name |
text
|
Name of the entity 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 category code of the damaged location. Emergency work damage 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 during this seven-day reporting period for the subgrantees approved Project Worksheet (PW). Due to the seven-day reporting period for this report, 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 obligated | yes |
| pwNumber | Project Worksheet (PW) Number |
integer
|
Number given to the project to uniquely identify it | 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 the version of the project. Starting with 0 and iIncreases in increments of 1 as a new version of the project is created | 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: