City of Chicago Workforce Vacancies and Occupancy, Monthly Updates

Personnel occupancy and vacancy data extracted from the City of Chicago's Chicago Integrated Personnel and Payroll System (CHIPPS). The dataset is updated monthly and published on the first business day of each month, representing a point-in-time extract. It does not include open line positions, which are budgeted based on hours or months of work needed.

Use Cases

• Analyze municipal staffing levels based on personnel occupancy and vacancy data.
• Monitor workforce composition changes over time based on monthly update cycles.
• Study the impact of grant position changes on city departments based on the data's inclusion of such positions.

Strengths

• Data is updated on a monthly basis, providing regular snapshots.
• Extracted from the authoritative Chicago Integrated Personnel and Payroll System (CHIPPS).
• Explicitly documents the exclusion of open line positions, clarifying scope.

Limitations

• Row count is unknown, which may limit suitability assessment.
• Column-level documentation is absent; field semantics must be inferred after download.
• Data is a point-in-time extract and may not reflect real-time information.

Provenance

Source

City of Chicago

Collection Method

Extracted from the Chicago Integrated Personnel and Payroll System (CHIPPS).

Freshness

Monthly updates; last metadata update was 2026-03-08.

Geography

City of Chicago