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 35 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row ID | row_id | text | Unique Identifier for each row | 3-1008225206ctPa 3-1009299705ctPa 3-101789139ctPa 3-1023870469ctPa 3-1026190628ctPa view top 100 |
Year | year | number | Calendar Year | 2013 2015 2017 2014 2016 view top 100 |
Department Title | department_title | text | Title of City Department | City Clerk Water And Power (DWP) Neighborhood Empowerment (DONE) Neighborhood Empowerment view top 100 |
Payroll Department | payroll_department | text | Department Number in City Payroll System | 1653 1651 4702 4701 view top 100 |
Record Number | record_number | text | 3332642933 2717950416 1722912903 334108380 2450665536 view top 100 | |
Job Class Title | job_class_title | text | Election Assistant I Senior Election Clerk Intermediate Election Clerk Assistant Air Pollution Specialist Principal Election Clerk view top 100 | |
Employment Type | employment_type | text | Employment Type - Full Time, Part Time, or Per Event | Part Time Full 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 | 13 11.65 16.72 14.54 19.7 view top 100 |
Projected Annual Salary | projected_annual_salary | number | Budgeted pay amount. Used for pension contribution calculations | 27144 24325.2 34911.36 30359.52 107448.48 view top 100 |
Q1 Payments | q1_payments | number | Payments for the first quarter of the year from January 1 to March 31 | 0 388.52 371.7 207.02 237.93 view top 100 |
Q2 Payments | q2_payments | number | Payments for the second quarter of the year from April 1 to June 30 | 0 669.2 28917.6 50 237.93 view top 100 |
Q3 Payments | q3_payments | number | Payments for the third quarter of the year from July 1 to September 30 | 0 50 24750.8 1203.84 1337.6 view top 100 |
Q4 Payments | q4_payments | number | Payments for the fourth quarter of the year from October 1 to December 31 | 0 24750.8 1576 28917.6 1533.6 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 50 100 10 5 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.0005 0.0001 0.0004 view top 100 |
Total Payments | total_payments | number | Total earnings for the year | 68.3 216.3 50 449.34 206.28 view top 100 |
Base Pay | base_pay | number | Base compensation for hours worked | 0 107036.8 115689.6 119325.6 107448.8 view top 100 |
Permanent Bonus Pay | permanent_bonus_pay | number | Payments attributable to permanent bonuses; typically pensionable | 0 view top 100 |
Longevity Bonus Pay | longevity_bonus_pay | number | Payments attributable to years of service; typically pensionable | 0 18.96 39.2 109.77 164.62 view top 100 |
Temporary Bonus Pay | temporary_bonus_pay | number | Payments attributable to temporary bonuses; typically not pensionable | 0 75 125.09 250 1800 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 32.72 0.9 333.56 260.04 view top 100 |
Overtime Pay | overtime_pay | number | Payments attributable to hours worked beyond regular work schedule | 0 158 100.32 535.04 539.22 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 50 100 10 5 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 50 100 10 5 view top 100 |
MOU | mou | text | Memorandum of Understanding | 0 00 3 view top 100 |
MOU Title | mou_title | text | Title of Memorandum of Understanding | NON-REPRESENTED Non-Represented NON-REPRESENTED EMPLOYEES Non-Represented Employees PROFESSIONAL UNIT view top 100 |
FMS Department | fms_department | text | Department number in City Financial Management System | 14 98 47 view top 100 |
Job Class | job_class | text | 728 0728 725 7310 723 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 18144.43 19964.75 16842.08 15860.53 view top 100 |
Average Dental Cost | average_dental_cost | number | Average cost to the City to provide dental care to the employee | 0 1248.19 1199.89 1282.61 1250.49 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 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 19392.62 21164.64 18124.69 17111.02 view top 100 |
Benefits Plan | benefits_plan | text | DWP 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/0728.pdf"} {"url":"http://per.lacity.org/perspecs/0721.pdf"} {"url":"http://per.lacity.org/perspecs/0723.pdf"} {"url":"http://per.lacity.org/perspecs/0725.pdf"} {"url":"http://per.lacity.org/perspecs/0729.pdf"} view top 100 |