Icon for Socrata external plugin
Open repository in Console
Updated 1 month ago
Indexed 4 hours ago

City Revenues

Listing of all City revenues per department. This data includes transactions received by check and cash. Includes record date, customer, amount and the accounting string that describes which fund and organizational department benefited from the transaction. The data contained on this website is for informational purposes only and represents revenue transactions of the City of Mesa. The data includes transactions received by check and cash. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa customer names have been redacted for confidentiality and safety issues; therefore not all customer names are represented. 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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/city-revenues-ntuh-v7ru\".\"city_revenues\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • city_revenues
Upstream Metadata