Icon for Socrata external plugin
Open repository in Console
Updated over 3 years ago
Indexed 29 minutes ago

Vendor Payments Calendar Year 2020

A data set of payments made to vendors in 2020. 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" \
{"sql": "
    SELECT *
    FROM \"kcmo/vendor-payments-calendar-year-2020-ump5-5ufb\".\"vendor_payments_calendar_year_2020\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • vendor_payments_calendar_year_2020