mydata-iowa-gov/iowa-pandemic-recovery-reporting-payments-to-cgm6-jbzf

  • cares act
  • covid-19
  • pandemic
  • recovery
  • vendor payments

Iowa Pandemic Recovery Reporting: Payments to Non-State Organizations

Iowa Pandemic Recovery Reporting: Payments to Non-State Organizations

This dataset provides information on payments to non-state organizations made by the State of Iowa using funds from 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
Cityvendor_cityvendor_cityTextCity associated with the physical address of the organization.
Doing Business Asvendor_dbavendor_dbaTextName organization is doing business as.
Legal Namevendor_legalvendor_legalTextLegal name for the organization.
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.
FundfundfundTextThe name of the fund where payment was made.
Unit Nameunit_nameunit_nameTextThe name of the organizational unit within the department associated with the payment.
State Departmentstate_departmentstate_departmentTextName of the State Department making the payment.
Federal Program Titlefederal_program_titlefederal_program_titleTextName of the Federal program that provided the federal funds that supported the payment.
Federal Agencyfederal_agencyfederal_agencyTextName of the Federal Agency responsible for overseeing the Federal funds associated with this payment.
Payment Issue Datepayment_issue_datepayment_issue_dateCalendar dateDate payment was made.
Record IDrecord_idrecord_idTextJournal record number from the State Accounting System, or other unique identifier created for the record.
Zipvendor_zipvendor_zipTextZip code associated with the physical address of the organization.
Object Class Nameobject_class_nameobject_class_nameTextA description of the type of expenditure.
Fund Codefund_codefund_codeTextThe four digit code designating the fund expenses were paid from.
State Department Numberstate_dept_nostate_dept_noTextThe three digit code used to designate the department associated with the payment (e.g., 413).
Statevendor_statevendor_stateTextState associated with the physical address of the organization.
Federal Departmentfederal_departmentfederal_departmentTextName of the Federal Department who awarded the federal funds associated with the payment.
Locationgeocoded_columngeocoded_columnPointGeocoded location is based on the city, state and zip.
Budget FYbudget_fybudget_fyNumberThe four digit budget fiscal year (July 1 - June 30 + holdover) associated with the payment.
PaymentamountamountNumberAmount paid to the organization.
Vendor IDvendor_idvendor_idTextField is a concatenation of the vendor number and vendor legal name without spaces.
Vendor Numbervendor_numbervendor_numberTextUnique identifier used in the State Accounting System for the vendor.
Object Classobject_classobject_classTextThe three digit code used in the state accounting system to designate the type of expenditure.
UnitunitunitTextThe four digit code used to designate the organizational unit within the department associated with the payment.
Fiscal Periodfiscal_periodfiscal_periodNumberTwo digit fiscal period associated with the payment (i.e., 1-15).
Iowa Regional Zip Codes:@computed_region_g8ff_h7ce:@computed_region_g8ff_h7ceNumber
County Boundaries of Iowa:@computed_region_y683_txed:@computed_region_y683_txedNumber
Rating Areas for Iowa Individual Affordable Care Act Premiums:@computed_region_hhz5_dst4:@computed_region_hhz5_dst4Number

Upstream Metadata