Bi-weekly updated payroll records for all Los Angeles City employees, including those from the Water and Power, Airports, and Harbor departments. The dataset includes compensation details, job classifications, and demographic information managed by the Los Angeles City Controller's Office. Payroll data for the Department of Water and Power employees is updated quarterly.
Use Cases
- Analyze wage disparities by GENDER and ETHNICITY across different DEPARTMENT_TITLE groups.
- Model TOTAL_PAY from base REGULAR_PAY, OVERTIME_PAY, and ALL_OTHER_PAY components for budget forecasting.
- Classify EMPLOYMENT_TYPE (e.g., full-time, part-time) using JOB_STATUS and JOB_TITLE features.
- Track compensation trends over time using the PAY_YEAR field for longitudinal analysis.
Strengths
- Covers all employees of a major U.S. city including three proprietary departments.
- Updated on a bi-weekly basis, providing frequent refreshes for most records.
- Includes 20 columns detailing pay, demographics, department, and job classification.
Limitations
- Exact row count and historical time range are unknown, limiting sample size assessment.
- Geographic scope is limited to the city of Los Angeles, not generalizable to other regions.
- Potential for data staleness for Department of Water and Power records, updated only quarterly.
Provenance
- Source
- Los Angeles City Controller's Office (controllerdata.lacity.org).
- Collection Method
- Administrative payroll records compiled by the city government.
- Time Range
- null
- Freshness
- Updated bi-weekly; last platform update was 2026-03 11.
- Geography
- Los Angeles, California, USA.