Dark Mode
City of Angels Payroll History Data
Data Science and Analytics
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Provides detailed payment records for Los Angeles employees, tracking regular pay, overtime earnings, and various other payments, such as bonuses and lump sum payouts. The context spans from January 2013 to June 2022, enabling longitudinal analysis of staffing and salary movements across city departments. Its significance lies in supporting transparency and providing a foundation for economic modelling of large public sector workforces.
Columns
- Record_NBR: A unique numerical identifier for each employee record.
- Pay_Year: The specific tax year in which the employee received payment (note: this is not the Fiscal Year).
- Department_NO: The unique department number used within the City Payroll System.
- Department_Title: The official title of the City Department (e.g., Police or Water and Power).
- Job_Class_PGrade: A combined field indicating the Job Class and associated Pay Grade.
- Job_Title: The specific title held by the employee.
- Employment_Type: Describes the nature of the employment (e.g., Full Time, Part Time, or Per Event).
- Job_Status: The employee's status at the point of data upload (either ACTIVE or NOT_ACTIVE).
- MOU: The identifier for the Memorandum of Understanding related to the position.
- MOU_Title: The full title of the Memorandum of Understanding.
- Regular_Pay: Payment allocated for standard work hours.
- Overtime_Pay: Payments received for hours worked beyond the standard regular schedule.
- All_Other_Pay: Includes payments outside of regular and overtime wages, such as various bonuses, adjustments, and significant one-time lump sum payouts (e.g., retirement settlements).
- Total_Pay: The aggregate of regular pay, overtime pay, and all other payments.
- City_Retirement_Contributions: Estimated payments made by the City toward the employee's retirement fund.
- Benefit_Pay: City contributions for employee benefits, including health care, dental care, vision care, and life insurance.
- Gender: Gender as self-reported by the employee.
- Ethnicity: Ethnicity as self-reported by the employee.
Distribution
The core data structure is tabular, provided in CSV format. The dataset includes 685,000 records and features 18 distinct columns detailing employee compensation. The data spans tax years 2013 through 2022. For instance, roughly 80% of employees are designated as FULL_TIME, and the Department of Police accounts for the highest percentage of departmental entries.
Usage
Ideal for econometric studies focusing on public sector wage structures and inflation impacts over time. It can be used for forensic auditing of public payroll records and identifying departmental spending patterns. The inclusion of demographic variables allows for robust salary equity analysis based on gender and ethnicity. Furthermore, it is suitable for creating predictive models related to employment costs and departmental budgeting.
Coverage
The geographic scope is limited strictly to Los Angeles, California, USA. The temporal coverage ranges from January 2013 to June 2022. Demographically, the records include self-reported gender (with 66% Male and 33% Female) and ethnicity data (with Hispanic being the most frequent category at 38%, followed by Caucasian at 26%). The data encompasses various employment types, including full-time and part-time staff.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
- Academic Researchers and Economists: To study public wage dynamics, compensation inequality, and economic trends.
- Civic Technology Developers: For building transparency platforms that visualise public expenditure.
- Journalists and Investigative Reporters: To uncover and report on potential discrepancies or trends in public sector pay.
- Municipal Consultants: To benchmark city payroll structures against other public entities.
Dataset Name Suggestions
- Los Angeles City Employee Pay Records 2013-2022
- LA Public Worker Compensation Archive
- City of Angels Payroll History Data
Attributes
Original Data Source: City of Angels Payroll History Data
QUALITYLoading...