Denver City Government Payment and Procurement Transactions

Daily updated accounts payable and procurement card transactions for the City and County of Denver, covering the current year to date and previous years. The data is published by data.colorado.gov and refreshed each business day. A system change in August 2017 altered expense categories and requires consulting multiple files for a complete view of that year.

Use Cases

• Analyze spending trends over time by aggregating Transaction_Amount by Year, Month from Transaction_Date, and Program_Area.
• Identify primary vendors and their geographic distribution by counting transactions per Merchant and summarizing Merchant_State.
• Categorize expenditures by type and department using Purchase_Type, Program_Area, and Item_Description columns.

Strengths

• Daily refresh schedule provides near real-time transaction data
• Includes 12 distinct columns detailing transaction metadata, vendor, and categorization

Limitations

• Confidential transactions are excluded, potentially creating a biased view of total spending
• Data for 2017 is split across files due to a system change, complicating analysis for that period
• Data is unaudited and for informational purposes only, as stated in the disclaimer

Provenance

Source

City and County of Denver financial systems, published via data.colorado.gov on the Socrata platform

Collection Method

Extracted from city accounts payable and procurement card systems

Time Range

Current year to date and previous years, with daily updates

Freshness

Refreshed daily with the previous business day's transactions

Geography

City and County of Denver, Colorado, USA