Vendor Payments
Listing of payments made to vendors. Includes Paid Date, Payee, 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 vendor payments for the City of Mesa. The data as represented is unaudited and may contain omissions. For audited financial statements please reference the Comprehensive Annual Financial Report (CAFR). Certain Mesa vendor names have been redacted for confidentiality and safety issues; therefore not all vendor names are represented. Any payments referenced as Personal Services are benefits relevant to payroll but are not specific to employee wages. Prior to May 1, 2014, debt service payments were not recorded as a check payments and are not represented in this data. ASRS and Utility payments are not recorded as check payments and are not represented in this data. Information of a sensitive or secure nature has been flagged as “Redacted”.
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/vendor-payments-j7s9-qiuq\".\"vendor_payments\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.