citydata-mesaaz-gov/business-services-purchases-u5x3-dvhs
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

Business Services - Purchases

This dataset has document information for purchases made in the City of Mesa financial system (Advantage-FIN). Warehouse adjustments and Engineering procurement types are excluded. (Code 800 and 810 as those are Warehouse inventory adjustments; Filter out DO’s made from Master Agreements with Procurement type 11, 12, 13 or 16, Engineering Procurement Types.

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/business-services-purchases-u5x3-dvhs\".\"business_services_purchases\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • business_services_purchases
     
     
     
     
     
Upstream Metadata