kcmo/vendor-payments-calendar-year-2013-d3c4-b44c
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated almost 7 years ago
Indexed 5 hours ago

Vendor Payments Calendar Year 2013

A data set of all payments made to vendors in 2013. Checkbook level data. When analyzing this data be aware that the sum amount and voucher are unique amounts, the payment amount is the total of a check. A check often includes more than one voucher.

As a result of the Red Flag Commission recommendations, Ordinance 970032 was passed by the City Council Jan. 23, 1997. This ordinance requires the city to publish a report every two weeks listing all city payments.

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 \"kcmo/vendor-payments-calendar-year-2013-d3c4-b44c\".\"vendor_payments_calendar_year_2013\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • vendor_payments_calendar_year_2013