All City Funds

Current balances of all Funds for the City of Los Angeles. Includes General Fund, Reserve Fund, Budget Stabilization Fund, and Special Funds. Upated daily, Monday through Friday.

For figures pertaining to Fiscal Year 2018, view the "All City Funds - FY18" dataset at https://controllerdata.lacity.org/dataset/All-City-Funds-FY18/9wxw-98tn/data.

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/all-city-funds-ej7u-di9z\".\"all_city_funds\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.