Open Budget Revenues

Listing of the adopted revenue budget, actual collected revenue tied to budgetary accounts, and year end estimates. This includes the accounting string that describes which fund, organizational department and the activity rollup of the department for the corresponding adopted budget, amended budget, and actual expenditures.

The data contained on this website is for informational purposes only and represents adopted budget, revenues, and year end estimates of the City of Mesa. The data does not include internal transfers or accounting adjustments. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). 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/open-budget-revenues-69ew-t3nx\".\"open_budget_revenues\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.