Payroll information for all Los Angeles City Departments since 2013. Data for calendar years, updated on a quarterly basis by the Los Angeles City Controller's Office.
This dataset has the following 34 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Year | year | number | Calendar Year | 2018 2016 2017 2015 2014 view top 100 |
Department Title | department_title | text | Title of City Department | Zoo view top 100 |
Payroll Department | payroll_department | text | Department Number in City Payroll System | 8701 8702 view top 100 |
Record Number | record_number | text | 2191621089 1602687383 944688572 2839811085 4193374051 view top 100 | |
Job Class Title | job_class_title | text | Animal Keeper Senior Animal Keeper Principal Animal Keeper view top 100 | |
Employment Type | employment_type | text | Employment Type - Full Time, Part Time, or Per Event | Full Time Part Time view top 100 |
Hourly or Event Rate | hourly_or_event_rate | number | Hourly Earnings Rate or Per Event Rate based on Projected Annual Salary | 28.99 22.7 32.08 30.54 30.6 view top 100 |
Projected Annual Salary | projected_annual_salary | number | Budgeted pay amount. Used for pension contribution calculations | 47397.6 60522.25 66983.04 63762.04 63892.8 view top 100 |
Q1 Payments | q1_payments | number | Payments for the first quarter of the year from January 1 to March 31 | 0 13971.48 18272.2 14967.96 17566.6 view top 100 |
Q2 Payments | q2_payments | number | Payments for the second quarter of the year from April 1 to June 30 | 0 14902.8 15608.4 16125.06 17311 view top 100 |
Q3 Payments | q3_payments | number | Payments for the third quarter of the year from July 1 to September 30 | 0 14807.94 17386.6 17679.4 17311 view top 100 |
Q4 Payments | q4_payments | number | Payments for the fourth quarter of the year from October 1 to December 31 | 0 14838 15195.6 14902.8 17275.93 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 | 75 800 1544.76 150 2398.33 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.0002 0.0004 0.0003 0.0005 view top 100 |
Total Payments | total_payments | number | Total earnings for the year | 100 60522.41 64427.96 60526.44 65364.4 view top 100 |
Base Pay | base_pay | number | Base compensation for hours worked | 0 64254.4 62883.2 63668.8 66588.8 view top 100 |
Permanent Bonus Pay | permanent_bonus_pay | number | Payments attributable to permanent bonuses; typically pensionable | 0 3484.49 3499.52 3533.96 3501.68 view top 100 |
Longevity Bonus Pay | longevity_bonus_pay | number | Payments attributable to years of service; typically pensionable | 0 744.76 4713.97 1598.33 1598.44 view top 100 |
Temporary Bonus Pay | temporary_bonus_pay | number | Payments attributable to temporary bonuses; typically not pensionable | 800 1110 1090 0 905 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 1465.79 1597.77 1469.28 1601.28 view top 100 |
Overtime Pay | overtime_pay | number | Payments attributable to hours worked beyond regular work schedule | 0 120.24 45.81 32.91 43.48 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 1200 60 -1367.15 61.36 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 | 1110 800 1090 1544.76 100 view top 100 |
MOU | mou | text | Memorandum of Understanding | 4 04 12 view top 100 |
MOU Title | mou_title | text | Title of Memorandum of Understanding | Equip.Oper. & Labor EQUIP.OPER. & LABOR EQUIP.OPERATION & LABOR Equip.Operation & Labor SUPV BLUE COLLAR view top 100 |
FMS Department | fms_department | text | Department number in City Financial Management System | 87 view top 100 |
Job Class | job_class | text | 4304 4305 4312 view top 100 | |
Pay Grade | pay_grade | text | Pay Grade for the Job Class | 0 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 11012.4 11000.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 411.36 409.68 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 | 11.4 0 11.45 10.32 5.28 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 11421.48 11435.16 11126.88 view top 100 |
Benefits Plan | benefits_plan | text | City 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/4304.pdf"} {"url":"http://per.lacity.org/perspecs/4305.pdf"} {"url":"http://per.lacity.org/perspecs/4312.pdf"} {"url":"https://per.lacity.org/perspecs/4304.pdf"} {"url":"https://per.lacity.org/perspecs/4305.pdf"} view top 100 |