City of Los Angeles

Close
Author
LACERS Admin
Description
This is a collection of data reported in LACERS Comprehensive Annual Financial Report (CAFR) since Fiscal Year End 2003, including data from the annual Actuarial Valuations generated after the end of each Fiscal Year. Actuarial Valuations and CAFR documents, in electronic form, can be found on the LACERS.org website at https://www.lacers.org/aboutlacers/reports/index.html.
Category
A Well Run City
Tags
lacers, pension, retirement, tier 1, tier 2, tier 3, retirees, opeb, uaal
Rating
Current value: 0 out of 5
Data Provided By
LACERS
Source Link
http://lacers.org/aboutlacers/reports/index.html
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Fiscal Year
fiscal_year
Market Value - Retirement Plan
market_value_retirement_plan
Market Value - Healthcare Plan
market_value_healthcare_plan
Market Value - Total LACERS Plans
market_value_total
Under/(Over) Funded Actuarial Accrued Liability-Retirement Plan (Net Pension Liability)
retirement_uaal
Under/(Over) Funded Actuarial Accrued Liability-Healthcare Plan (Net OPEB Liability)
healthcare_uaal
Under/(Over) Funded Actuarial Accrued Liability-Total LACERS Plan (Net Pension and OPEB Liability)
total_uaal
Funded Ratio - Retirement Plan
funded_ratio_retirement_plan
Funded Ratio - Healthcare Plan
funded_ratio_healthcare_plan
Funded Ratio - Total LACERS Plans
funded_ratio_total
City Contributions - Retirement Plan
city_contributions_retirement
City Contributions - Healthcare Plan
city_contributions_healthcare
City Contributions - Total LACERS Plan
city_contributions_total
Member Contributions - Retirement Plan
member_contributions_retirement
Member Contributions - Healthcare Plan
member_contributions_healthcare
Net Investment Income (Loss) - Retirement Plan
retirement_investment_net
Net Investment Income (Loss) - Healthcare Plan
healthcare_investment_net
Net Investment Income (Loss) - Total LACERS Plan
net_investment_income_loss_total_lacers_plan
1 Yr. Return (Gross of Fees)
yr_return_gross
1 Yr. Return (Net of Fees)
yr_return_net
3 Yr. Return (Gross of Fees)
yr3_return_gross
3 Yr. Return (Net of Fees)
yr3_return_net
5 Yr. Return (Gross of Fees)
yr5_return_gross
5 Yr. Return (Net of Fees)
yr5_return_net
10 Yr. Return (Gross of Fees)
yr10_return_gross_
10 Yr. Return (Net of Fees)
yr10_return_net
15 Yr. Return (Gross of Fees)
yr15_return_gross
15 Yr. Return (Net of Fees)
yr15_return_net
Average Monthly Retirement Allowance (Service Retirees)
monthly_retirement_allowance_service_retiree
Average Monthly Retirement Allowance (Survivor Cont.)
monthly_retirement_allowance_beneficiaries
Average Monthly Retirement Allowance (Disability Retirees)
monthly_retirement_allowance_disability
Average Monthly Retirement Allowance (Weighted Avg.)
monthly_retirement_allowance_all
Annual Retirement Benefits
annual_retirement_benefits
Average Monthly Health Subsidy Over 65 with Medicare A & B
monthly_average_health_subsidy_over_65
Average Monthly Health Subsidy Under 65 Non-Medicare
monthly_average_health_subsidy_under_65_retiree
Average Monthly Survivor Healthcare Subsidy Under 65 non-Medicare
monthly_average_health_subsidy_under_65_survivor
Maximum Monthly Retiree Healthcare Subsidy Under 65 non-Medicare
maximum_monthly_retiree_healthcare_subsidy_under_65_non_medicare
Maximum Monthly Survivor Healthcare Subsidy Under 65 non-Medicare
maximum_monthly_survivor_healthcare_subsidy_under_65_non_medicare
Annual Healthcare Benefits
annual_healthcare_benefits
Active Members - Tier 1
active_tier_1
Active Members - Tier 2
active_tier_2
Active Members - Tier 3
active_tier_3
Active Members (All Tiers)
active_members_all_tiers
Inactive Members - Tier 1
inactive_tier_1
Inactive Members - Tier 2
inactive_tier_2
Inactive Members - Tier 3
inactive_tier_3
Inactive Members - All Tiers
inactive_members_all_tiers
Covered Payroll
covered_payroll
Actuarially Projected Annual Payroll
actuarially_projected_annual_payroll
Number of Service Retirees
service_retirees
Number of Disability Retirees
disability_retirees
Number of Beneficiaries
beneficiaries
Average Retirement Age
average_retirement_age
Average Age of Service Retirees
average_service_retiree_age
Average Age of Beneficiaries
average_beneficiary_age

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.