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" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"kcmo/vendor-payments-calendar-year-2020-ump5-5ufb\".\"vendor_payments_calendar_year_2020\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.