A data set of payments made to vendors in 2017. Updated weekly. 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 AMERIPRIDE SERVICES INC. view top 100 |
| Payment No | payment_no | text | WI34846 WI86024 WI67363 WI49027 WI0026496 view top 100 |
| Payment Date | payment_date | calendar_date | 2017-09-08T00:00:00.000 2017-07-14T00:00:00.000 2017-06-16T00:00:00.000 2017-01-27T00:00:00.000 2017-08-11T00:00:00.000 view top 100 |
| Payment Amount | payment_amount | number | 50.00 150.00 100.00 0.00 500.00 view top 100 |
| Payment Method | payment_method | text | ACH CHK WIR EFT MAN view top 100 |
| Voucher | voucher | text | H0026570 H0026906 H0026810 H0026648 H0026740 view top 100 |
| Sum Amount | sum_amount | number | 50.00 43.00 25.00 100.00 0.00 view top 100 |
| Fund | fund | number | 1000 2030 8010 8110 8300 view top 100 |
| Fund_Descr | fund_descr | text | General Fund Parks and Recreation Water Sewer KC Airports view top 100 |
| DeptID | deptid | number | 270000 802130 71910 231405 621012 view top 100 |
| DeptID_Descr | deptid_descr | text | Municipal Court Revenues Wastewater Treatment - Mainten Fleet Operations Logistics Central Warehouse view top 100 |
| Account | account | number | 215300 213490 212500 616160 215350 view top 100 |
| Account_Descr | account_descr | text | Nationwide Def Comp-457b United Way Payable Fsa Deductions Payable Laundry & Oth Sanitation Servi Life Ins (Allstate) Payable view top 100 |