Note this dataset is no longer being updated. Please use the updated payroll dataset with current pay year information: https://controllerdata.lacity.org/Payroll/City-Employee-Payroll-Current-/g9h8-fvhu. Payroll information for all Los Angeles City Employees including the City's three proprietary departments: Water and Power, Airports and Harbor. Data is updated on a quarterly basis by the Los Angeles City Controller's Office. Payroll information for employees of the Department of Water and Power is provided by the Department.
This dataset has the following 35 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row ID | row_id | text | Unique Identifier for each row | 3-1000155488ctFu 3-1000194958ctFu 3-1000198958ctFu 3-1000232317ctFu 3-1000329284ctFu view top 100 |
Year | year | number | Calendar Year | 2018 2017 2016 2015 2013 view top 100 |
Department Title | department_title | text | Title of City Department | Water And Power (DWP) Police (LAPD) Recreation And Parks Airports (LAWA) Public Works - Sanitation view top 100 |
Payroll Department | payroll_department | text | Department Number in City Payroll System | 4301 7903 3001 4302 101 view top 100 |
Record Number | record_number | text | 1793593909 307004764 4248536150 315959136 170811557 view top 100 | |
Job Class Title | job_class_title | text | Police Officer II Recreation Assistant Police Officer III Firefighter III Administrative Clerk view top 100 | |
Employment Type | employment_type | text | Employment Type - Full Time, Part Time, or Per Event | Full Time Part Time Per Event view top 100 |
Hourly or Event Rate | hourly_or_event_rate | number | Hourly Earnings Rate or Per Event Rate based on Projected Annual Salary | 15.06 14.39 17.29 16.5 16.83 view top 100 |
Projected Annual Salary | projected_annual_salary | number | Budgeted pay amount. Used for pension contribution calculations | 31445.28 30046.32 36101.52 34452 70386.48 view top 100 |
Q1 Payments | q1_payments | number | Payments for the first quarter of the year from January 1 to March 31 | 0 4316.8 17354.4 13844.1 14056 view top 100 |
Q2 Payments | q2_payments | number | Payments for the second quarter of the year from April 1 to June 30 | 0 3614.4 14875.2 16151.45 24427.2 view top 100 |
Q3 Payments | q3_payments | number | Payments for the third quarter of the year from July 1 to September 30 | 0 4216.8 61.36 14045.5 14839.8 view top 100 |
Q4 Payments | q4_payments | number | Payments for the fourth quarter of the year from October 1 to December 31 | 0 3614.4 16433.41 17313.1 23368.8 view top 100 |
Payments Over Base Pay | payments_over_base_pay | number | Payments in excess of Base Pay which may include bonuses and other payouts | 0 600 1200 50 75 view top 100 |
% Over Base Pay | percent_over_base_pay | number | Percentage of payment in excess of Base Pay which may include bonuses and other payouts | 0 0.0003 0.0001 0.0004 0.0008 view top 100 |
Total Payments | total_payments | number | Total earnings for the year | 61.36 60474.46 108.47 48973.22 87801.6 view top 100 |
Base Pay | base_pay | number | Base compensation for hours worked | 0 92377.6 87158.4 88358.4 95971.2 view top 100 |
Permanent Bonus Pay | permanent_bonus_pay | number | Payments attributable to permanent bonuses; typically pensionable | 0 2990 3250 2772 5544 view top 100 |
Longevity Bonus Pay | longevity_bonus_pay | number | Payments attributable to years of service; typically pensionable | 0 754 610.64 1618.46 1310.82 view top 100 |
Temporary Bonus Pay | temporary_bonus_pay | number | Payments attributable to temporary bonuses; typically not pensionable | 0 1525 1025 1326 150 view top 100 |
Lump Sum Pay | lump_sum_pay | number | Lump sum payouts for special purposes - retirement payouts, back pay, etc.; typically not pensionable | 0 2650.08 2932.32 3843.48 2628 view top 100 |
Overtime Pay | overtime_pay | number | Payments attributable to hours worked beyond regular work schedule | 0 350.04 364.2 180.72 329.44 view top 100 |
Other Pay & Adjustments | other_pay_adjustments | number | Payments based on other pay codes or adjustments that do not fall into another category | 0 600 1200 132 50 view top 100 |
Other Pay (Payroll Explorer) | pay_other_actual | number | Other Pay 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 | 0 100 600 200 150 view top 100 |
MOU | mou | text | Memorandum of Understanding | 24 3 8 23 4 view top 100 |
MOU Title | mou_title | text | Title of Memorandum of Understanding | Police Officers Unit POLICE OFFICERS UNIT CLERICAL UNIT Clerical Unit OPERATING MAINTENANCE AND SERVICE UNIT view top 100 |
FMS Department | fms_department | text | Department number in City Financial Management System | 70 98 88 38 82 view top 100 |
Job Class | job_class | text | 2214 2498 2112 1358 2223 view top 100 | |
Pay Grade | pay_grade | text | Pay Grade for the Job Class | 0 2 1 3 A view top 100 |
Average Health Cost | average_health_cost | number | Average cost to the City to provide health care to the employee | 0 11470.34 18144.43 11012.4 10710.24 view top 100 |
Average Dental Cost | average_dental_cost | number | Average cost to the City to provide dental care to the employee | 0 412.34 1248.19 411.36 405.24 view top 100 |
Average Basic Life | average_basic_life | number | Average cost to the City to provide basic life insurance to the employee | 0 11.4 11.45 192.74 10.32 view top 100 |
Average Benefit Cost | average_benefit_cost | number | The total average City contribution for the employee's health care, dental care and life insurance | 0 11894.13 19392.62 11435.16 11126.88 view top 100 |
Benefits Plan | benefits_plan | text | City DWP Police Fire view top 100 | |
Job Class Link | job_class_link | url | Click this hyperlink to view the job class description | {"url":"http://per.lacity.org/perspecs/2214.pdf"} {"url":"https://per.lacity.org/perspecs/2214.pdf"} {"url":"https://per.lacity.org/perspecs/2498.pdf"} {"url":"https://per.lacity.org/perspecs/2112.pdf"} {"url":"https://per.lacity.org/perspecs/1358.pdf"} view top 100 |