data.iowa.gov

Close
Author
Scott Vander Hart
Description
This dataset contains payment transactions recorded in the State’s central accounting system. Please visit Iowa's Open Checkbook at http://checkbook.iowa.gov to explore this dataset more extensively.
Category
State Government Finance
Tags
checkbook, expenditures, payments, vendors
Rating
Current value: 0 out of 5
Data Provided By
Iowa Department of Administrative Services, State Accounting Enterprise
License
1.0 Universal (Public Domain Dedication)
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Record Number
rec_no
Fiscal Year
fiscal_year
Fiscal Year Period
fiscal_year_period
Accounting Period
accounting_period
Service
service
Department
department
Fund Code
fund_code
Fund Name
fund_name
Appropriation Code
appropriation_code
Appropriation Name
appropriation_name
Program
program
Expense Category
expense_category
Vendor
vendor
Vendor Number
vendor_id
Payment Number
payment_id
Payment Issue Date
payment_date
Invoice Number
invoice_id
Invoice Line Number
invoice_line
Invoice Line Distribution Number
invoice_distribution_line
Invoice Date
invoice_date
Amount
amount
Description
description

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.