Los Angeles City Employee Payroll and Benefits (2013-2018)

Payroll records for all Los Angeles city employees, including workers from the Water and Power, Airports, and Harbor departments, span from 2013 to 2018. The Los Angeles City Controller's Office compiled this data, which was updated quarterly until its final update in February 2021. It details base pay, overtime, various bonuses, and average benefit costs for health, dental, and life insurance.

Use Cases

• Analyze overtime pay trends by FMS Department and Job Class across fiscal quarters (Q1-Q4 Payments).
• Model the relationship between Base Pay, Projected Annual Salary, and Total Payments including bonuses like Longevity Bonus Pay.
• Compare average benefit costs (Average Health Cost, Average Dental Cost) across different Employee Types and MOU Titles.
• Identify departments with high Payments Over Base Pay percentages to audit compensation practices.

Strengths

• Covers 6 consecutive years of payroll data (2013-2018).
• Includes detailed breakdowns of 30+ compensation and benefit columns per employee record.
• Data was updated quarterly, providing multiple snapshots within each year.

Limitations

• Dataset is deprecated and no longer updated, with the last update being over three years old.
• Unknown row count prevents assessment of sample size and statistical power.
• Lacks sample data to verify data integrity and null value prevalence.

Provenance

Source

Los Angeles City Controller's Office, with Department of Water and Power data provided by the department.

Collection Method

Quarterly updates from official city payroll systems.

Time Range

2013 to 2018

Freshness

Not updated since February 2021; deprecated in favor of a current dataset.

Geography

City of Los Angeles, California, USA