This dataset provides records from the General Ledger, which includes individual expense records associated with the City of Fort Collins City Council. Each year"s data are appended annually within two months of the year end. To review all City business expenses, please visit https://openbook.fcgov.com
This dataset has the following 9 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Year | year | number | 2019 2018 2016 2017 2015 view top 100 | |
Date | date | calendar_date | Transaction date. | 2019-03-29T00:00:00.000 2019-04-30T00:00:00.000 2016-07-31T00:00:00.000 2019-12-31T00:00:00.000 2019-05-31T00:00:00.000 view top 100 |
Object & Description | object_description | text | 'Object Code' in the City's accounting system, followed by the description associated with that code. | 559040 - City and Community Programs 544020 - Conference and Travel 559020 - Food & Related Supplies 549010 - Copy & Reproduction Services 559010 - Meals - Business, Non Travel view top 100 |
Subsidiary & Description | subsidiary_description | text | 'Subsidiary Code' in the City's accounting system, followed by the Councilmember associated with that code. | 433 - Cunniff, Ross view top 100 |
Explanation/Remark | explanation_remark | text | The basic description of the transaction. | UMB Card Services - GAN*COLORADOAN-CCC SMITH, STEPHEN GRANT - GAN*COLORADOAN-CCC KANE, SARAH E - GAN*COLORADOAN-CCC COLORADOAN - CUNNIFF-LISTENING SESSIONS CUNNIFF, ROSS A - RENAISSANCE DC DNTOWN view top 100 |
Description | description | text | The extended description of the transaction, including what's published in OpenBook. | Purchase GAN*COLORADOAN-C Council Listening Session Cunniff-NLC Conf Cunniff-CML Conf Coloradoan Ads view top 100 |
Amount | amount | number | The amount of the transaction. | 419.98 250.87 410.0 360.0 540.0 view top 100 |
meta_row_index | meta_row_index | number | Metadata field for a suggested sort order. Sort this column in ascending order to order the dataset the way it was intended from the source system. | 250 327 390 491 528 view top 100 |
meta_row_id | meta_row_id | text | Metadata field for record hash. This field is a SHA-1 hash of all other fields in the record, used for validation of record uniqueness. | 05c887a91246dc11428c082c468cfa92883b287c 05fe8cf509892aa8de7faeb3be53303c657669cc 19b21eb64b86237f296ced45f19bd07c08b699df 1ae04888213ea2eeeefade7200db8e4820b9601f 1c17684190c7edace177dfcb82def6fe6e22b1c4 view top 100 |