Net Position by Category

CAFR Pages 330-331.

Net Position is the difference between the City’s assets and liabilities, including deferred outflows/inflows of resources. This data summarizes Net Position by Activity Types, Asset Type Groups, and Asset Types. This data is based on the following parameters: Accrual Basis of Accounting, Last Ten Fiscal Years and (amounts expressed in thousands).

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/net-position-by-category-87im-rub8\".\"net_position_by_category\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.