About this Dataset

Workforce Vacancies

Personnel occupancy and vacancy by position.

About the Dataset:
The data have been extracted from the City of Chicago's Chicago Integrated Personnel and Payroll System (CHIPPS).
CHIPPS is comprised of human resources and payroll modules that serve as the backbone for maintaining employee records and payroll processing.

Data Disclaimer:
The following data disclaimer governs your use of the dataset extracted from the vacancy data of the City of Chicago's Chicago Integrated Personnel and Payroll System (CHIPPS).

Data Subject to Change:
The dataset represents a point-in-time extract from the CHIPPS vacancy and occupancy data and may not reflect real-time or up-to-date data. The dataset is updated on a monthly basis and published on the first business day of each month.

This dataset is subject to updates and modifications due to the course of business, including grant position changes. This dataset does not include open line positions. Open line positions represent a position that is budgeted based on the number of hours or months of work needed.
Organization: City of Chicago
Last updated: 2025-03-14T23:57:36.051669
Tags: personnel

Tables

Table 1

@usgov.city_of_chicago_workforce_vacancies.table_1

67.44 kB
1,402 rows
17 columns

CREATE TABLE table_1 (
  "department_code" VARCHAR,
  "department" VARCHAR,
  "fund_type" VARCHAR,
  "fund_code" VARCHAR,
  "fund" VARCHAR,
  "division_code" VARCHAR,
  "division" VARCHAR,
  "section_code" VARCHAR,
  "section" VARCHAR,
  "sub_section_code" DOUBLE,
  "sub_section" VARCHAR,
  "title_code" VARCHAR,
  "title" VARCHAR,
  "total_positions" BIGINT,
  "employees_in_position" BIGINT,
  "number_of_vacancies" BIGINT,
  "report_date" VARCHAR
);