Operating Indicators

For an interactive view of this data, visit cafr.controlpanel.la This dataset includes metrics collected by the Controller's office as part of the Comprehensive Annual Financial Report (CAFR). Metrics are provided by the various departments and each department is responsible for the accuracy of their individual metrics.

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/operating-indicators-ienq-vvtk\".\"operating_indicators\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.