Sign in to view source links and access this dataset
Description
City of Chicago publishes a listing of all its active employees, including names, departments, job titles, and compensation details. The dataset contains fields for employment status, annual salary, hourly rate, and typical work hours. It is maintained by the City of Chicago, with a last recorded update in March 2026.
Use Cases
Analyzing departmental salary distributions and headcounts using the 'Department', 'Annual Salary', and 'Full or Part-Time' columns.
Estimating annual wages for hourly employees by combining the 'Hourly Rate' and 'Typical Hours' fields.
Profiling municipal workforce composition by examining 'Job Titles', 'Salary or Hourly' status, and 'Full or Part-Time' classifications.
Strengths
Includes granular compensation data with separate fields for 'Annual Salary' and 'Hourly Rate'.
Provides explicit definitions for 'active' employee status and hourly wage estimation logic.
Contains specific personnel details like 'Name', 'Department', and 'Job Titles'.
Limitations
Cross-source conflict: The 'last updated' date (March 2026) is in the future, indicating potential metadata inaccuracy.
Employee count and total row count are unknown from the provided sources.
The dataset excludes employees on certain types of temporary leave, which may undercount the total workforce.
Provenance
Source
City of Chicago
Collection Method
Official administrative records of active city employees.
Time Range
Current (as of the last update)
Freshness
2026-03-22 (Note: This future date suggests a metadata error)
Geography
City of Chicago, Illinois, USA
Data is subject to FOIA Exemption Act 5 ILCS 140/7. 'Active' status has a specific HR definition that excludes some employees on leave. Annual wages for hourly employees are estimates based on 'Hourly Rate' and 'Typical Hours' and will vary.