CalPERS Supplement - Contracting Agencies' Benefits for Fiscal Years 2002-03 to 2021-22

This dataset compares selected benefits of all the local public agencies that contracted with CalPERS. Agencies are listed alphabetically and include the plan types (miscellaneous or safety) and a five-digit code used for identification by CalPERS of the various benefit formulas.

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/calpers-supplement-contracting-agencies-benefits-ew9v-kudu\".\"calpers_supplement_contracting_agencies_benefits\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.