A data set of payments made to vendors in 2019. Checkbook level data. When analyzing this data be aware that the sum amount and voucher are unique amounts, the payment amount is the total of a check. A check often includes more than one voucher. As a result of the Red Flag Commission recommendations, Ordinance 970032 was passed by the City Council Jan. 23, 1997. This ordinance requires the city to publish a report every two weeks listing all city payments.
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Vendor Name | vendor_name | text | NATIONWIDE RETIREMENT SOLUTIONS HEART OF AMERICA UNITED WAGEWORKS INC AMERICAN HERITAGE LIFE INSURANCE CO INC CINTAS CORPORATION NO 2 view top 100 |
| Payment No | payment_no | text | WI2894A WI71069 WI32124 WI2098A WI83515 view top 100 |
| Payment Date | payment_date | calendar_date | 2019-03-22T00:00:00.000 2019-05-03T00:00:00.000 2019-04-19T00:00:00.000 2019-11-01T00:00:00.000 2019-08-23T00:00:00.000 view top 100 |
| Payment Amount | payment_amount | number | 0 50 100 500 150 view top 100 |
| Payment Method | payment_method | text | ACH CHK WIR EFT MAN view top 100 |
| Voucher | voucher | text | H0031505 H0031342 H0031017 H0031598 H0031103 view top 100 |
| Sum Amount | sum_amount | number | 47 50 25 100 0 view top 100 |
| Fund | fund | text | 1000 8010 8110 2030 8300 view top 100 |
| Fund_Descr | fund_descr | text | General Fund Water Sewer Parks and Recreation Aviation view top 100 |
| DeptID | deptid | text | 270000 701901 802130 071910 131522 view top 100 |
| DeptID_Descr | deptid_descr | text | Municipal Court Revenues Stores Purchases Wastewater Treatment - Mainten Fleet Operations Legal - Collections view top 100 |
| Account | account | text | 215300 213490 212500 215350 213420 view top 100 |
| Account_Descr | account_descr | text | Nationwide Def Comp-457b United Way Payable Fsa Deductions Payable Life Ins (Allstate) Payable Garnishment/Child Suprt Payabl view top 100 |