Changes in Net Position

CAFR Pages 332-335.

Net Position is the difference between the City’s assets and liabilities, including deferred outflows/inflows of resources. This data summarizes the change in Net Position by Change Types, Asset Types, and Activities. 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/changes-in-net-position-b9gd-twyi\".\"changes_in_net_position\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.