Current Employee Names, Salaries, and Position Titles

data.cityofchicago.org | Last Updated 24 Oct 2019

This dataset is a listing of all current City of Chicago employees, complete with full names, departments, positions, employment status (part-time or full-time), frequency of hourly employee –where applicable—and annual salaries or hourly rate. For hourly employees, the City is providing the hourly rate and frequency of hourly employees (40, 35, 20 and 10) to allow dataset users to estimate annual wages for hourly employees. Please note that annual wages will vary by employee, depending on number of hours worked and seasonal status. For information on the positions and related salaries detailed in the annual budgets, see https://www.cityofchicago.org/city/en/depts/obm.html

Tags: personnel

This dataset has the following 8 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
NamenametextName of employee
Job Titlesjob_titlestextTitle of employee at the time when the data was updated.
DepartmentdepartmenttextDepartment where employee worked.
Full or Part-Timefull_or_part_timetextWhether the employee was employed full- (F) or part-time (P).
Salary or Hourlysalary_or_hourlytextDefines whether an employee is paid on an hourly basis or salary basis. Hourly employees are further defined by the number of hours they work in a week. See the "Frequency Description" column.
Typical Hourstypical_hoursnumberDescribes the typical amount of work for hourly employees. This data does not apply to salary employees. 40 - Employee paid on an hourly basis; works an 8 hour day; can be either full-time permanent (FT/P) or full-time temporary (FT-T) which is a seasonal employee; 35 - Employee paid on an hourly basis; works a 7 hour day; can be either full-time permanent (FT/P) or full-time temporary (FT-T) which is a seasonal employee; 20 - Employee paid on a part-time, hourly basis; typically works a 4 hour day, 5 days a week; 10 - Employee paid on a part-time, hourly basis; works 10 hours or less in a week.
Annual Salaryannual_salarynumberAnnual salary rates. Only applies for employees whose pay frequency is "Salary". Hourly employees rates are only shown in "Hourly Rates" column.
Hourly Ratehourly_ratenumberThe hourly salary rates for individuals whose pay frequency is "hourly". Hourly employees have varying hours worked throughout the week, which is described in the "Frequency Description" column.