mydata-iowa-gov/iowa-pandemic-recovery-reporting-state-68ay-29f3

  • cares act
  • coronavirus
  • covid-19
  • pandemic
  • recovery
  • + 1

Iowa Pandemic Recovery Reporting: State Expenditures

Iowa Pandemic Recovery Reporting: State Expenditures

This dataset provides information on all expenditures made by the State of Iowa associated with Federal awards 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

NameSocrata field nameColumn name in sgr mountData typeDescription
AmountamountamountNumberAggregate total for the budget fy, fiscal period, department number, unit, fund code, line of credit, and object class.
FundfundfundTextThe name of the fund where expenses were paid from
Letter of Creditletter_of_creditletter_of_creditTextThis is the Letter of Credit value associated with the PPC code in the state accounting system that is unique to the federal award.
Unit Nameunit_nameunit_nameTextThe name of the organizational unit within the department who paid the expense
Federal Program Titlefederal_program_titlefederal_program_titleTextName of the Federal program providing the funds associated with the expenditure.
Object Class Nameobject_class_nameobject_class_nameTextA description of the type of expenditure
State Departmentstate_departmentstate_departmentTextThe name of the State Department associated with the expenditure.
State Department Numberstate_dept_nostate_dept_noTextThe three digit code used to designate the department who paid the expense.
Fiscal Periodfiscal_periodfiscal_periodNumberTwo digit fiscal period the expenditure was made (e.g., 01-15).
Object Classobject_classobject_classTextThe three digit code used to designate the type of expenditure
Fund Codefund_codefund_codeTextThe four digit code designating the fund expenses were paid from
Record Daterecord_daterecord_dateCalendar dateEnding date for the reported period.
Federal Departmentfederal_departmentfederal_departmentTextName of the Federal Department awarding the federal funds associated with the expenditure.
UnitunitunitTextThe four digit code used to designate the organizational unit within the department who paid the expense
Federal Agencyfederal_agencyfederal_agencyTextName of the Federal Agency responsible for overseeing the federal funds associated with the expenditure.
Record IDrecord_idrecord_idTextUnique identifier for the record; concatenation of budget fy, fiscal period, department number, unit, fund code, letter of credit, object class, and record date YYYYMMDD format) with a dash (“-”) in between.
Budget FYbudget_fybudget_fyNumberThe four digit budget fiscal year (July 1 - June 30 + holdover) the expenditure was made.

Upstream Metadata