City of Denver Checkbook

These datasets include accounts payable payments and procurement card transactions made to vendors by the City and County of Denver for the current year to date and previous years. The datasets are refreshed each day with the previous business day's transactions. New travel datasets cannot be provided from August 2017 due to confidentiality concerns however, historic travel datasets will be maintained.

Notice: In August 2017, the city implemented a new financial system which created new Expense categories and prompted some expenses to roll in to different or new categories. When viewing 2017 data you may have to look at several Expense categories for a complete picture. Procurement data from August 2017 to December 2017 are in a separate file. When viewing 2017 procurement data, you will need two files.

Disclaimer: The City and County of Denver is committed to the highest levels of data security and privacy, therefore not all payment transactions will be displayed. Payment transactions that are confidential are excluded from the data. Protected information such as social security numbers, banking information, and personal data are excluded from payment transaction details. Payments to retirement and health care providers include employee contributions. The data contained on this website is unaudited and is for informational purposes only. It is not the intent of the site to provide information that may be used to determine or influence the financial decisions of any website user.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"colorado-gov/city-of-denver-checkbook-wnau-xrqi\".\"city_of_denver_checkbook\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.