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.