About this Dataset

Payments To School Districts By State Of Iowa

This dataset provides payment transactions to Iowa School Districts recorded in the State of Iowa’s central accounting system for the Executive Branch. Data has been enhanced by the Iowa Department of Management to only return records associated with school districts by joining the State of Iowa Checkbook data to a crosswalk dataset that relates vendor numbers to district numbers assigned by the Iowa Department of Education. It also highlights payments related to the Local Option Sales Tax that are corrected to be attributed to the prior fiscal year.
Organization: State of Iowa
Last updated: 2023-01-19T23:53:11.849386
Tags: checkbook, expenditures, payments, school-districts

Tables

Table 1

@usgov.state_of_iowa_payments_to_school_districts_by_state_of_iowa.table_1

2.91 MB
186290 rows
10 columns


CREATE TABLE table_1 (
  "record_number" BIGINT,
  "fiscal_year" BIGINT,
  "department" VARCHAR,
  "program" VARCHAR,
  "expense_category" VARCHAR,
  "district" BIGINT,
  "district_name" VARCHAR,
  "payment_date" TIMESTAMP,
  "amount" DOUBLE,
  "corrected_record" VARCHAR
);