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.