Open Checkbook Ledger | Last Updated 1 Jul 2019

This dataset has the following 10 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
YearyearnumberYear for which the value is relevant. Present year will be year-to-date amount.
PeriodperiodnumberMost recent month for this record. Completed previous years will show as "12"
Department_Descriptiondepartment_descriptiontextText description of Department.
Account_Descriptionaccount_descriptiontextText description of account.
Fund_Descriptionfund_descriptiontextText description of fund.
Vendor Namepayment_alternate_nametext
Journal Datejournal_datecalendar_date
ServiceservicetextGeneral category of this expense. Used at the highest level of the OpenCheckbookCOS visualization, not in City accounting.
DivisiondivisiontextHierarchy division related to City org chart. See for complete org chart.