Socrata

Close
Author
Edwin Avanessian
Description
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.
Category
Payroll
Tags
payroll, personnel, bonuses, healthcare, overtime
Rating
Current value: 0 out of 5
Data Provided By
Controller
Source Link
http://controller.lacity.org
License
Attribution 4.0 International
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

Year
year
Department Title
department_title
Payroll Department
payroll_department
Record Number
employee_id
Job Class Title
job_class_title
Employment Type
employment_type
Hourly or Event Rate
hourly_or_event_rate
Projected Annual Salary
projected_annual_salary
Q1 Payments
q1_payments
Q2 Payments
q2_payments
Q3 Payments
q3_payments
Q4 Payments
q4_payments
Payments Over Base Pay
payments_over_base_pay
% Over Base Pay
percent_over_base_pay
Total Payments
total_payments
Base Pay
base_pay
Permanent Bonus Pay
permanent_bonus_pay
Longevity Bonus Pay
longevity_bonus_pay
Temporary Bonus Pay
temporary_bonus_pay
Lump Sum Pay
lump_sum_pay
Overtime Pay
overtime_pay
Other Pay & Adjustments
other_pay_adjustments
Other Pay (Payroll Explorer)
pay_other_actual
MOU
mou
MOU Title
mou_title
FMS Department
fms_department
Job Class
job_class
Pay Grade
pay_grade
Average Health Cost
average_health_cost
Average Dental Cost
average_dental_cost
Average Basic Life
average_basic_life
Average Benefit Cost
average_benefit_cost
Benefits Plan
benefits_plan
Job Class Link
job_class_link

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.