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 | 5-1015466626ctFu 5-1022432110ctFu 5-1030053897ctFu 5-1038353053ctFu 5-1038430887ctFu view top 100 |
| Year | year | number | Calendar Year | 2015 view top 100 |
| Department Title | department_title | text | Title of City Department | Transportation (LADOT) view top 100 |
| Payroll Department | payroll_department | text | Department Number in City Payroll System | 8501 view top 100 |
| Record Number | record_number | text | 1015466626 1022432110 1030053897 1038353053 1038430887 view top 100 | |
| Job Class Title | job_class_title | text | Traffic Officer II Traffic Officer I view top 100 | |
| Employment Type | employment_type | text | Employment Type - Full Time, Part Time, or Per Event | 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 | 30.54 32.22 28.92 22.66 25.25 view top 100 |
| Projected Annual Salary | projected_annual_salary | number | Budgeted pay amount. Used for pension contribution calculations | 63767.52 67274.84 60384.96 47314.08 52722 view top 100 |
| Q1 Payments | q1_payments | number | Payments for the first quarter of the year from January 1 to March 31 | 15057.56 0 8999 15862.64 15423.23 view top 100 |
| Q2 Payments | q2_payments | number | Payments for the second quarter of the year from April 1 to June 30 | 17417.4 0 17783.88 18358.06 18744.7 view top 100 |
| Q3 Payments | q3_payments | number | Payments for the third quarter of the year from July 1 to September 30 | 17417.4 0 18358.06 17783.88 16510.2 view top 100 |
| Q4 Payments | q4_payments | number | Payments for the fourth quarter of the year from October 1 to December 31 | 14929.2 0 15295.68 15735.48 15020.82 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 | 2063.16 2200.59 2428.83 2429.64 1320 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.0004 0.0005 0.0003 0.0007 0.0006 view top 100 |
| Total Payments | total_payments | number | Total earnings for the year | 64821.56 65187.23 3684.07 4590.76 4815.88 view top 100 |
| Base Pay | base_pay | number | Base compensation for hours worked | 62758.4 59599.2 51243.2 0 44176 view top 100 |
| Permanent Bonus Pay | permanent_bonus_pay | number | Payments attributable to permanent bonuses; typically pensionable | 0 3492.68 1301.15 2719.85 2963.65 view top 100 |
| Longevity Bonus Pay | longevity_bonus_pay | number | Payments attributable to years of service; typically pensionable | 743.16 0 371.58 744.13 738.51 view top 100 |
| Temporary Bonus Pay | temporary_bonus_pay | number | Payments attributable to temporary bonuses; typically not pensionable | 1320 1275 870 555 1230 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 853.23 1462.67 1097.01 609.45 view top 100 |
| Overtime Pay | overtime_pay | number | Payments attributable to hours worked beyond regular work schedule | 0 366.48 91.62 732.96 365.67 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 4 3 6 12 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 | 2063.16 1320 5555.84 2067.16 2123.16 view top 100 |
| MOU | mou | text | Memorandum of Understanding | 18 view top 100 |
| MOU Title | mou_title | text | Title of Memorandum of Understanding | SAFETY / SECURITY view top 100 |
| FMS Department | fms_department | text | Department number in City Financial Management System | 94 view top 100 |
| Job Class | job_class | text | 3214 view top 100 | |
| Pay Grade | pay_grade | text | Pay Grade for the Job Class | 2 1 view top 100 |
| Average Health Cost | average_health_cost | number | Average cost to the City to provide health care to the employee | 11012.4 view top 100 |
| Average Dental Cost | average_dental_cost | number | Average cost to the City to provide dental care to the employee | 411.36 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 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 | 11435.16 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/3214.pdf"} view top 100 |