citydata-mesaaz-gov/city-revenues-ntuh-v7ru
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"citydata-mesaaz-gov/city-revenues-ntuh-v7ru\".\"city_revenues\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • city_revenues
     
     
     
     
     
Upstream Metadata