Checkbook L.A. Data

This dataset contains City spending data and is used to power the Controller's Checkbook L.A application. Data since fiscal year 2018.

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 \"controllerdata-lacity/checkbook-la-data-pggv-e4fn\".\"checkbook_la_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.