Checkbook - Fiscal YTD

Details of expenses (Accounts Payable) from the beginning of the most recent Fiscal Year, 2020. Includes vendor, checks, and amounts to Jun 30, 2020.

See also dataset Checkbook, which contains historical data starting in Fiscal Year 2014 (July 1, 2013) though Fiscal 2019.

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 \"framinghamma-gov/checkbook-fiscal-ytd-erww-baxn\".\"checkbook_fiscal_ytd\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.