lacity/lacers-key-facts-and-figures-from-year-end-63we-p3wv
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 1 month ago

LACERS Key Facts and Figures from Year End Financial Reports

This is a collection of data reported in LACERS Annual Financial Report since Fiscal Year End 1990, which includes selective data from the yearly Actuarial Valuation, Audited Financial Statement, and Investments Reporting generated after the end of each Fiscal Year. Average Healthcare Subsidies data are the exception and are pulled from Health division dashboards at fiscal year end. Yearly and multi-year investment return averages are based on time-weighted reporting. Some figures are rounded, as reported in the documents referenced above. Actuarial Valuations and Annual Financial Report documents, in electronic form, can be found on the LACERS.org website at https://www.lacers.org/reports-and-statistics.

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 \"lacity/lacers-key-facts-and-figures-from-year-end-63we-p3wv\".\"lacers_key_facts_and_figures_from_year_end\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • lacers_key_facts_and_figures_from_year_end
     
     
     
     
     
Upstream Metadata