Iowa Pandemic Recovery Reporting: Federal Funds Awarded
This dataset provides information on Federal funds awarded to the State of Iowa Executive Branch agencies that are considered covered funds under Section 15011 of the Coronavirus Aid, Relief, and Economic Security (CARES) Act. Covered funds are federal funds appropriated through one of the following: The Coronavirus Preparedness and Response Supplemental Appropriations Act, 2020 (Public Law 116-123); The Families First Coronavirus Response Act (Public Law 116-127); The Coronavirus Aid, Relief, and Economic Security Act (Public Law 116-136); The Paycheck Protection Program and Health Care Enhancement Act (Public Law 116-139); The Consolidated Appropriations Act, 2021 (Public Law 116-260); or The American Rescue Plan Act, 2021 (Public Law 117-2).
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Performance End | performance_end | performance_end | Calendar date | The date on which effort related to the award ends or is completed, or, if applicable, when the emergency declaration ended. |
| Performance Start | performance_start | performance_start | Calendar date | The date on which effort begins or the award is otherwise effective, or, if applicable, when the emergency declaration began |
| State Department | state_department | state_department | Text | Name of the State department awarded the federal funds. |
| State Department Number | state_dept_no | state_dept_no | Text | The three digit code used in the State Accounting System for the department who is the prime recipient of the award |
| Federal Agency | federal_agency | federal_agency | Text | The name of the office, administration or service within the federal department responsible for the award. If not specifically defined, same as the federal department. |
| Federal Department | federal_department | federal_department | Text | The name of the federal department responsible for the federal award. |
| Federal Award Number | federal_award_number | federal_award_number | Text | The unique identifier of the specific award being reported. Federal Award Identification Number (FAIN) for federal assistance or the Procurement Instrument Identifier (PIID) for procurement. |
| Fiscal Year | fiscal_year | fiscal_year | Number | The state fiscal year the federal funds were awarded. |
| Record ID | record_id | record_id | Text | Unique identifier for the record; concatenation of federal_award_number and, if applicable, award_amend with a dash (“-”) in between. |
| DUNS Number | duns_number | duns_number | Text | The unique 9-digit number assigned by Dun and Bradstreet (D&B) referred to as the DUNS® used in the Federal System for Award Management for the state agency on the award received. |
| Award Amendment Number | award_amend | award_amend | Text | The Federal identifier for subsequent change or supplement to the initial award, assigned by awarding federal agency. |
| Award Date | award_date | award_date | Calendar date | The date of the initial federal award or subsequent amendment |
| Award Description | award_description | award_description | Text | A brief description of the purpose of the award. |
| Federal Program | federal_program | federal_program | Text | The number assigned to the federal assistance listing (formerly known as CFDA) |
| Award Amount | award_amount | award_amount | Number | The total amount of the initial award or subsequent amendment, or, if applicable, the estimate associated with federal match increase during emergency declaration. |
| Federal Program Title | federal_program_title | federal_program_title | Text | Name of the federal program through which the award was made. |