bythenumbers-sco-ca-gov/cities-net-pension-asset-and-liability-for-fiscal-iud7-8e6p
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 2 years ago
Indexed 1 month ago

Cities' Net Pension Asset and Liability for Fiscal Years 2016-17 to 2019-20

Net Pension Asset (NPA) is the amount in excess of the amount owed to a defined benefit pension plan based on the actuarial present value of projected benefit payments for plan members and their beneficiaries less the plan’s net position. Net Pension Liability (NPL) is the amount owed to a defined benefit pension plan based on the actuarial present value of projected benefit payments for plan members and their beneficiaries less the plan’s net position.

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 \"bythenumbers-sco-ca-gov/cities-net-pension-asset-and-liability-for-fiscal-iud7-8e6p\".\"cities_net_pension_asset_and_liability_for_fiscal\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • cities_net_pension_asset_and_liability_for_fiscal