citydata-mesaaz-gov/open-budget-expenses-29q3-4ewh
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 5 hours ago

Open Budget Expenses

Listing of the adopted budget, amended budget, and City expenditures tied to budgetary accounts. 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, amended budget, expenditures, 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-expenses-29q3-4ewh\".\"open_budget_expenses\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • open_budget_expenses
     
     
     
     
     
Upstream Metadata