CIP Budget

Listing of all financially active City project budgets and expenses from FIN’s budget structure 37 data. This data includes transactions paid by check as well as payroll transactions and transactions paid by wire or electronic draft, and the total project budget associated with projects. The dataset will be pulled once a month for Socrata, and the dataset will represent a point in time as the budget structure will be a live data set.

The data contained on this website is for informational purposes only and represents budget and expenditure transactions of the City of Mesa. The data includes check payments as well as payroll transactions and transactions paid by wire or electronic draft. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Payments that are voided in a subsequent Fiscal Year may appear as a negative amount. Certain Activity assignments may change mid-year. This year-to-date information is updated monthly and represents the most current activity assignment regardless of the assignment at the time of the transaction.

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 \"citydata-mesaaz-gov/cip-budget-9bk7-3e9s\".\"cip_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.