About this Dataset

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).
Organization: State of Iowa
Last updated: 2023-01-19T23:52:34.703978
Tags: cares-act, covid-19, pandemic, recovery, vendor-payments

Tables

Table 1

@usgov.state_of_iowa_iowa_pandemic_recovery_reporting_payment_a4d36320.table_1

4.41 MB
160,239 rows
25 columns

CREATE TABLE table_1 (
  "record_id" VARCHAR,
  "payment_issue_date" TIMESTAMP,
  "budget_fy" BIGINT,
  "fiscal_period" BIGINT,
  "federal_department" VARCHAR,
  "federal_agency" VARCHAR,
  "federal_program_title" VARCHAR,
  "state_department_number" VARCHAR,
  "state_department" VARCHAR,
  "unit" VARCHAR,
  "unit_name" VARCHAR,
  "fund_code" VARCHAR,
  "fund" VARCHAR,
  "object_class" BIGINT,
  "object_class_name" VARCHAR,
  "letter_of_credit" VARCHAR,
  "vendor_number" VARCHAR,
  "legal_name" VARCHAR,
  "doing_business_as" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "payment" DOUBLE,
  "vendor_id" VARCHAR,
  "location" VARCHAR
);