This dataset contains payment transactions recorded in the State’s central accounting system for the Executive Branch. Please visit Iowa's Open Checkbook at http://checkbook.iowa.gov to explore this dataset more extensively.
This dataset has the following 22 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Record Number | rec_no | text | This is the journal record number which is a unique ID for the record. | 235627386 192610374 267831864 202555706 239990700 view top 100 |
| Fiscal Year | fiscal_year | number | Identifies the fiscal year (July 1 - June 30, numbered for the calendar year it ends) the payment was assigned. The fiscal year includes a hold-over period for payments made after year end for good and services received on or before June 30. | 2016 2015 2014 2017 2018 view top 100 |
| Fiscal Year Period | fiscal_year_period | number | Reflects twelve periods with July being period 1 and June being period 12. Hold-over payments are reflected in period 12. | 5 2 3 4 6 view top 100 |
| Accounting Period | accounting_period | text | Accounting periods as reflected in the State's accounting system. Reflects hold-over periods for payments made after year end. | NOVEMBER SEPTEMBER OCTOBER DECEMBER MARCH view top 100 |
| Service | service | text | Service reference functions in the state budget, which represent groups of agencies that make expenditures for similar programs and purposes. | ADMINISTRATION AND REGULATION TRANSPORTATION JUSTICE SYSTEM EDUCATION AGRICULTURE AND NATURAL RESOURCES view top 100 |
| Department | department | text | Name of department, institution or agency making the payment | REVENUE TREASURER OF STATE TRANSPORTATION, DEPT OF ALCOHOLIC BEVERAGES EDUCATION, DEPT OF view top 100 |
| Fund Code | fund_code | text | The code designating the source of funds used to make the payment | 0815 0001 0812 0631 0137 view top 100 |
| Fund Name | fund_name | text | The source of funds used to make the payment | LOCAL SALES & SERV TAX FUND GENERAL FUND STREET CONSTR FUND CITIES LIQUOR CONTROL ACT FUND PRIMARY ROAD FUND view top 100 |
| Appropriation Code | appropriation_code | text | The code designating the legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation. | I98 Q44 Q60 WZ2 31S view top 100 |
| Appropriation Name | appropriation_name | text | The legislative authorization for the payment. Some payments are authorized by Iowa Code and do not require an appropriation. | ENRICH IOWA LIBRARIES INDIGENT DEFENSE APPROPRIATION PUBLIC DEFENDER PUBLIC SAFETY ADMINISTRATION GENERAL AVIATION AIRPORTS view top 100 |
| Program | program | text | The organizational unit or program within a department associated with the payment | SAVE-LOCAL OPTION SALES TAX-CITIES & COUNTIES STREET CONSTR. FUND CITIES LICENSE OPERATIONS PRIMARY ROAD ROAD FUND DISTRICT 1 CURRENT view top 100 |
| Expense Category | expense_category | text | Expense category assigned to the payment | STATE AID REFUNDS-LOCAL OPTION REFUNDS-OTHER UTILITIES OUTSIDE SERVICES view top 100 |
| Vendor | vendor | text | Name of vendor receiving the payment. Some data will be noted as "RESTRICTED" if removed from data for confidentiality purposes. | VINTON, CITY OF VINTON POLICE DEPT VINTON PUBLIC LIBRARY VINTON MUNICIAL view top 100 |
| Vendor Number | vendor_id | text | Lists number assigned to vendor. Data removed for confidentiality purposes will be noted as "RESTRICTED" and the vendor number for state employees have been altered to remove the portion of the vendor number based on their Social Security Number. | 00002130718 00002130720 00002130719 00002130721 view top 100 |
| Payment Number | payment_id | text | Unique code for the payment based on a concatenation of the doc code, dept number, doc ID, vendor line number and commodity line number from the accounting system | GAX-428-428C2220338080001-1-0 GAX-428-428BC104140200-11-0 GAX-645-6452017038727293-1-0 GAX-428-428C0870755430005-4-0 GAX-583-15583093005-7-0 view top 100 |
| Payment Issue Date | payment_date | calendar_date | Date payment was made to the vendor | 2016-08-12T00:00:00.000 2014-04-15T00:00:00.000 2015-08-26T00:00:00.000 2014-01-16T00:00:00.000 2017-03-28T00:00:00.000 view top 100 |
| Invoice Number | invoice_id | text | Invoice number provided by the vendor where available. If invoice is not available, same as payment number. | GAX-428-428C2220338080001-1-0 GAX-428-428BC104140200-11-0 GAX-428-428C0870755430005-4-0 GAX-583-15583071005-3-0 GAX-645-6452017038727293-1-0 view top 100 |
| Invoice Line Number | invoice_line | number | Placeholder number | 1 2 3 4 5 view top 100 |
| Invoice Line Distribution Number | invoice_distribution_line | number | Placeholder number | 1 view top 100 |
| Invoice Date | invoice_date | calendar_date | Date of invoice where available, otherwise same as payment date. | 2016-08-12T00:00:00.000 2014-04-15T00:00:00.000 2014-01-16T00:00:00.000 2015-08-26T00:00:00.000 2017-03-28T00:00:00.000 view top 100 |
| Amount | amount | number | Amount of payment to the vendor | 15 617.5 692.5 917.5 45 view top 100 |
| Description | description | text | A description of the type of expenditure such as travel, supplies, utilities, equipment, etc | REFUND - LOCAL OPTION SLS TAX REFUND STATE AID CITIES-LIQUOR SALES DIST. ELECTRICITY view top 100 |