DataShield Ontology
SOCRATAAdministration & FinanceofficialSee Terms of Use

Current Employee Names, Salaries, and Position Titles

Attribution: City of Chicago · source

This dataset is a listing of all active 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. Please note that "active" has a specific meaning for Human Resources purposes and will sometimes exclude employees on certain types of temporary leave. 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 Data Disclosure Exemptions: Information disclosed in this dataset is subject to FOIA Exemption Act, 5 ILCS 140/7 (Link:https://www.ilga.gov/legislation/ilcs/documents/000501400K7.htm)

personnel
← Back to browse📊 Open in D3 Studio

Dataset Profile

31.8K
Total records
8
Columns
table
Type
Full dataset analyzed
ID: xzkq-xp2w

Popularity

2.2M
Views
14.2M
Downloads
~31.8K rows · 8 columns

Freshness & Tracking

Rows updated4 months ago · 5/12/2026
View modified11 months ago
Created on source9/27/2011
Published1/30/2018
Discovered3/11/2026, 8:37:21 AM
Last checked5/13/2026, 11:34:10 PM
Last changed3/11/2026, 8:37:21 AM
Reads5
Search hits27
View raw source ↗

File Details

Filenamedownload_2026-03-29.csv
Size2788.9 KB
Typetext/csv; charset=utf-8
Rows analyzed32.1K
Columns8
📊

download_2026-03-29.csv

2.7 MB · text/csv; charset=utf-8 · Uploaded 3/29/2026

70.4% Fair
2.7 MB
Size
32.1K
Rows
8
Columns
5
Analyses

Achievements

3/8
🔍Located
📤Uploaded
⬇️Downloaded
🗄️Query Layer
🔬Analyzed
📸Snapshot
🛡️Privacy
High Quality
30d agotoday
Scheduledconduit_analysis
8/23/2026
Scheduledconduit_analysis
8/23/2026
Scheduledconduit_analysis
8/17/2026
Scheduledconduit_analysis
3/29/2026
Manualconduit_analysis
3/29/2026

Owner & Attribution

Ownercocadmin
Authorcocadmin
PublisherCity of Chicago

Metadata

FrequencyData are updated daily
Data OwnerHuman Resources
Time PeriodCurrent

Schema (8 columns)

Column metadata from the source provider's own profiling

ColumnTypeCardinalityNullsTop ValuesRange
Name
Name of employee
text31.8K0
HERNANDEZ, JUAN CHERNANDEZ, DANIELGONZALEZ, RICARDO
AARON, JEFFE … ZYSKOWSKI, D
Job Titles
Title of employee at the time when the data were updated.
text31.8K0
POLICE OFFICERFIREFIGHTER-EMTSERGEANT
ACCESSIBILIT … ZONING INVES
Department
Department where employee worked.
text31.8K0
CHICAGO POLICE DEPARCHICAGO FIRE DEPARTMDEPARTMENT OF WATER
BOARD OF ELE … OFFICE OF TH
Full or Part-Time
Whether the employee was employed full- (F) or part-time (P).
text31.8K0
FP
F … P
Salary or Hourly
Defines 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.
text31.8K0
SALARYHOURLY
HOURLY … SALARY
Typical Hours
Describes 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.
number31.8K24.9K
402035
10 … 40
Annual Salary
Annual salary rates. Only applies for employees whose pay frequency is "Salary". Hourly employees rates are only shown in "Hourly Rates" column.
number31.8K6.9K
111252115158127146
40560 … 350000.04
Hourly Rate
The 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.
number31.8K24.9K
48.7351.447.79
4 … 70.87

Profiled Fields (8)

Field-level metadata from analytics imports.

FieldTechnicalSemanticBusiness
Annual SalarynumbercurrencyAnnual Salary
DepartmentstringcategoryDepartment
Full or Part-TimestringcategoryFull Or Part Time
Hourly RatenumbernumericHourly Rate
Job TitlesstringcategoryJob Titles
Namestringperson_nameName
Salary or HourlystringcurrencySalary Or Hourly
Typical HoursnumbernumericTypical Hours

Send Feedback