OpenFEMA Dataset: Public Assistance Applicants Program Deliveries - v1
Key | Value |
---|---|
Entity Name | PublicAssistanceApplicantsProgramDeliveries |
API Endpoint | https://www.fema.gov/api/open/v1/PublicAssistanceApplicantsProgramDeliveries |
Update Frequency | R/P1D |
Program URL | https://www.fema.gov/assistance/public |
Category | Public Assistance |
Keywords | public assistance |
Description
FEMA's Public Assistance (PA) Grants Manager database, including the Grant Portal tool (collectively Grants Manager) was developed in 2016 and became the processing system for all new PA grants starting on August 25, 2017. Grants Manager documents PA projects from formulation to grant obligation and finally close-out. Grant formulation is a new process that was not previously captured.
The previous database, the Emergency Management Mission Integration Environment (EMMIE) currently functions as the system for obligations - a few declarations are obligated in Grants Manager as test cases. All remaining EMMIE functions are scheduled to move to Grants Manager soon. This includes the records for EMMIE and the previous database, the National Emergency Management Information System (NEMIS).
The 'Public Assistance Applicants Program Deliveries' dataset was generated from Grants Manager by the PA reporting team to share data on assistance made available to eligible state, local and tribal governments, and certain private nonprofit organizations as part of presidentially declared disasters. This dataset reports on the PA National Delivery Model process with summaries of projects and project statuses for all active applicants (subrecipients). The data reflects time sensitive, current phase information including pre-obligation (project formulation) phases starting in phase 2 through obligation in phase 5.
Short description of the PA Phases:
Phase 1. Applicant Coordination and Evaluation - Identify applicants’ disaster impacts and recovery priorities.
Phase 2. Impacts and Eligibility - Capture and document all incident-related damages.
Phase 3. Scoping and Costing - Further develop PA grant projects for final processing.
Phase 4. Final Reviews - FEMA reviews the project application, applicants review and sign agreement.
Phase 5. Obligation and Recovery Transition - FEMA obligates funds to recipients and schedules Recovery Transition Meeting (RTM).
Phase 6. Post-Award Monitoring and Amendments - Applicant provide updates to FEMA via Recipient, amendments can be submitted for changes to the scope, costs, or time to complete the project.
Phase 7. Final Reconciliation and Closeout - Applicant coordinates with recipient for closeout completed with FEMA.
For more information, please review:
Public Assistance Delivery Model: https://www.fema.gov/sites/default/files/2020-07/fema_pa_delivery-model_factsheet.pdf
Grants Manager/Grants Portal Fact Sheet: https://www.fema.gov/sites/default/files/2020-07/fema_pa_grants-manager-grants-protal-tool_factsheet.pdf
A descriptive list of two of the code fields in the data dictionary are presented here as they are difficult to read if embedded in the field description:
Applicant Status
Eligible - Applicant is eligible to apply for and receive FEMA Public Assistance grants
Ineligible - Applicant has been determined ineligible to apply for and receive FEMA Public Assistance grants
Withdrawn - Applicant has withdrawn eligibility to apply for and receive FEMA Public Assistance grants
Pending Recipient RPA Review - Pending reviews by the Recipient of the Applicant's request for Public Assistance
Pending FEMA RPA Review - Pending reviews by FEMA of the Applicant's request for Public Assistance
Pending Ineligibility Review - Pending final review to determine eligibility of the Applicant
Pending RPA Ineligibility Review - Pending final review to determine eligibility of the Applicant's request for Public Assistance
Pending Applicant Resubmission - Pending resubmittal of a request for Public Assistance
Closed - Eligible - Eligible Applicant has been closed out
Applicant Process Status specifies the process currently pending for the Applicant or their request for Public Assistance. These may include:
Process Discontinued - FEMA processes applicant removal
Pending Applicant Resubmission - Request for Public Assistance (RPA) is pending re-submittal by the applicant
Pending Recipient Review - The RPA is pending review by the Recipient
Pending DIU RPA EMMIE Entry - The RPA is pending entry into the EMMIE system by the Document Integrity Unit
Pending DIU RPA Validation - The RPA is pending validation by the Document Integrity Unit
Pending Field Leadership Review - The RPA is pending review by FEMA leadership in the field or regional office
Pending OCC Review - The RPA is pending review by Office of Chief Counsel
Pending PAGS Review - The RPA is pending review by the PA Group Supervisor
Pending PDMG Assignment - The Applicant is pending assignment of a Program Delivery Manager (PDMG)
Pending Impact Review Completion - The Applicant is pending completion of an Impact Review or Exploratory Call
Pending RSM Completion - The Applicant is pending completion of a Recovery Scoping Meeting
Pending Grant Completion - The Applicant is pending completion of completing PA projects to receive grant obligations
Pending Request to Conduct RTM Approval - The Applicant is requesting a Recovery Transition Meeting (RTM)
Pending FEMA RTM Completion - The Applicant is pending completion of an RTM by FEMA staff
Pending Applicant RTM Approval - The Applicant is pending approval of the transition to the region
RTM Completed - The Applicant has completed transition to the region to be closed out
Pending Close-out Review - The Applicant is pending the performance of close out procedures
Applicant Closed Out - Applicant is closed out of the PA Process
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 | 72987 | small (10MB - 50MB) |
json | Link to json | 72987 | small (10MB - 50MB) |
jsona | Link to jsona | 72987 | small (10MB - 50MB) |
jsonl | Link to jsonl | 72987 | small (10MB - 50MB) |
parquet | Link to parquet | 72987 | small (10MB - 50MB) |
Data Fields
Name | Title | Type | Description | Is Searchable |
---|---|---|---|---|
declarationType | Declaration Type |
text
|
Two character code that defines if this is a major disaster or emergency declaration. For more information on the disaster process, please visit https://www.fema.gov/disasters/how-declared | 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, please visit https://www.fema.gov/disasters/how-declared | yes |
stateCode | State Abbreviation |
text
|
The US Postal abbreviation describing the U.S. state, district, or territory declared. | yes |
stateName | State Name |
text
|
The full name describing the U.S. state, district, or territory declared. | yes |
declarationDate | Declaration Date |
date
|
Date the disaster was declared | yes |
incidentType | Incident Type |
text
|
Type of incident such as fire or flood. For more information on incident types, please visit https://www.fema.gov/disasters/how-declared | yes |
declarationTitle | Declaration Title |
text
|
Title for the disaster, if it exists in the source system | yes |
region | Region Number |
smallint
|
Number (1-10) used to represent the Region associated with the project | yes |
consolidatedResourceCenter | Consolidated Resource Center |
text
|
Consolidated Resource Center (CRC) that is assigned to develop and review Public Assistance projects for the declaration. Includes the following area offices: Atlantic, East, Central, and West | yes |
countyApplicantJurisdiction | County Applicant Jurisdiction |
text
|
The county or other geographical area for which the Applicant has jurisdiction of, or within. State agencies will be listed as 'Statewide' | yes |
utilizingDirectApplication | Utilizing Direct Application |
boolean
|
Yes/No indicator of whether the Applicant is utilizing the direct application process that allows for them to submit project applications directly through the Grants Portal system | yes |
applicantIdGm | Applicant Id - GM |
integer
|
Unique Public Assistance applicant identification number. From the Grants Manager/Portal system | yes |
applicantIdEmmie | Applicant Id - EMMIE |
text
|
Unique Public Assistance applicant identification number. From the EMMIE system | yes |
applicantName | Applicant Name |
text
|
Name of the entity requesting Public Assistance Grant funding. (Eligible Public Assistance applicants are subgrantees) | yes |
applicantType | Applicant Type |
text
|
Specifies the general type of organization the applicant represents. Such as State or Local government or Private Non-Profit | yes |
isPnp | Is PNP |
boolean
|
Yes/No indicator of whether the Applicant is a Private Non-Profit organization | yes |
applicantStatus | Applicant Status |
text
|
Specifies the Eligibility status of the Applicant for their request for public assistance. See the main dataset description for a list of codes. Applicants may be ineligible if they are a for profit entity or if the work reuquested and costs are not eligible. https://www.fema.gov/pdf/government/grant/pa/fema323_app_handbk.pdf | yes |
applicantProcessStatus | Applicant Process Status |
text
|
Specifies the process currently pending for the Applicant or their request for Public Assistance. See the main dataset description for a list of codes | yes |
numberActiveDamages | Number of Active Damages |
smallint
|
Number of currently active (not withdrawn, ineligible, or deleted) damage sites, facilities, or activities for which the applicant is applying for reimbursement of funds | yes |
totalAppDamageCost | Total Applicant Damage Cost |
decimal
|
Total current cost in dollars for the applicant's active damage sites, facilities, or activities. The total may include ineligible damages or damages that are reported at the damage level but not yet associated with any of the applicant's Current Projects | yes |
numberActiveProjects | Number of Active Projects |
smallint
|
Number of currently active (not withdrawn, ineligible, or deleted) Public Assistance projects created in Grants Manager/Portal | yes |
currentProjectCost | Current Project Cost |
decimal
|
Total damage costs in dollars associated with current active projects for an applicant. This represents the cost of the applicants projects before any applicable cost share is taken out. Costs may contain projects not yet obligated | yes |
numberPhase2Projects | Number of Phase 2 Projects |
smallint
|
Number of Projects pending process steps in phase 2 ADD NUMBER of the Public Assistance process, which includes documenting impacts and formulating projects | yes |
phase2ProjectCost | Phase 2 Project Cost |
decimal
|
Total damage costs in dollars currently entered on active PA Projects pending phase 2 (Assessing Impacts & Eligibility) process steps | yes |
numberPhase3Projects | Number of Phase 3 Projects |
smallint
|
Number of Projects pending process steps in phase 3 of the Public Assistance process, which includes developing the scope and costs of projects | yes |
phase3ProjectCost | Phase 3 Project Cost |
decimal
|
Total damage costs in dollars currently entered on active PA Projects pending phase 3 (Scoping & Costing) process steps | yes |
numberPhase4Projects | Number of Phase 4 Projects |
smallint
|
Number of Projects pending process steps in phase 4 of the Public Assistance process, which includes final eligibility and concurrence reviews of projects | yes |
phase4ProjectCost | Phase 4 Project Cost |
decimal
|
Total damage costs in dollars currently entered on active PA Projects pending phase 4 (Final Reviews) process steps | yes |
numberPhase5Projects | Number of Phase 5 Projects |
smallint
|
Number of Projects pending process steps in phase 5 of the Public Assistance process, which includes those pending final obligation, and obligated projects that are not currently pending an amendment in other phases | yes |
phase5ProjectCost | Phase 5 Project Cost |
decimal
|
Total damage costs in dollars currently entered on active PA Projects pending phase 5 (Obligation Process) process steps (includes obligated projects) | yes |
numberObligatedProjects | Number of Obligated Projects |
smallint
|
Number of projects that have been awarded and obligated funding | yes |
federalShareObligated | Federal Share Obligated |
decimal
|
Federal Share in dollars currently awarded by FEMA for the Applicant's projects. This reflects the dollar amount provided to the recipient and is reduced by any cost share set up for the disaster or project | yes |
hash | Hash |
text
|
MD5 hash of fields and values of the record | no |
lastRefresh | Last Refresh |
datetimez
|
Date the record was last updated in the API data store | yes |
id | ID |
uuid
|
Unique ID assigned to the record that does not persist between data set refreshes | yes |
See Also
ReferencesAccess the metadata API calls for additional information: