🧑‍💼 Employees' Payroll in Los Angeles 🧑‍💼

 

Payroll of 685,000 Employees in Los Angeles (01-2013 to 06-2022)

---

🔐 Dataset File 🔐

payroll.csv

 

❓ Description ❓

This dataset contains information about 685,000 Los Angeles's employees .

The data was extracted between January 1th 2013 and June 317th in 2022.

 

📝 Variables 📝

The file payroll.csv contains a huge table of Los Angeles's employees' information in the following columns:

 

• Record_NBR: unique number to identify an employee;
• Pay_Year: tax year employee was paid. This is not Fiscal Year;
• Department_NO: department Number in City Payroll System;
• Department_Title: title of City Department;
• Job_Class_PGrade: Job Class and Pay Grade;
• Job_Title: Job Title;
• Employment_Type: employment type - Full Time, Part Time, or Per Event;
• Job_Status: employee's job status at the time the data was uploaded;
• MOU: Memorandum of Understanding;
• MOU_Title: title of Memorandum of Understanding;
• Regular_Pay: regular work hours payment;
• Overtime_Pay: payments attributable to hours worked beyond regular work schedule;
• All_Other_Pay: any payments other than Regular and Overtime. This includes bonuses, adjustments, and lump sum payouts. Examples of bonuses include Permanent, Longevity, and Temporary Bonuses. Lump Sum Pay includes significant one-time payouts due to retirement, lawsuit settlements, or other adjustments;
• Total_Pay: sum of regular, overtime and all other payments;
• City_Retirement_Contributions: estimated payments made by the City towards employee's retirement;
• Benefit_Pay: city contribution for the employee's health care, dental care, vision care, and life insurance;
• Gender: gender as self-reported by employee;
• Ethnicity: ethnicity as self-reported by employee.

---

🔐 Dataset File 🔐

processed-payroll.csv

 

❓ Description ❓

This dataset consists in the payroll.csv without rows with Null values (all columns) and negative values (REGULAR_PAY, OVERTIME_PAY, ALL_OTHER_PAY, TOTAL_PAY, CITY_RETIREMENT_CONTRIBUTIONS and BENEFIT_PAY columns).

 

📝 Variables 📝

The file processed-payroll.csv contains the same variables of the payroll.csv file.

---

🔐 Dataset File 🔐

train-test-payroll.csv

 

❓ Description ❓

This dataset consists in the processed-payroll.csv containing just Active and Full-Time Employees, Labelled Categorical Variables and with a few less columns.

 

📝 Variables 📝

• Regular_Pay: regular work hours payment;
• Pay_Year: tax year employee was paid. This is not Fiscal Year;
• Department_NO: department Number in City Payroll System;
• Job_Class_PGrade: Job Class and Pay Grade;
• Job_Title: Job Title;
• Overtime_Pay: payments attributable to hours worked beyond regular work schedule;
• All_Other_Pay: any payments other than Regular and Overtime. This includes bonuses, adjustments, and lump sum payouts. Examples of bonuses include Permanent, Longevity, and Temporary Bonuses. Lump Sum Pay includes significant one-time payouts due to retirement, lawsuit settlements, or other adjustments;
• City_Retirement_Contributions: estimated payments made by the City towards employee's retirement;
• Benefit_Pay: city contribution for the employee's health care, dental care, vision care, and life insurance;
• Gender: gender as self-reported by employee;
• Ethnicity: ethnicity as self-reported by employee.