About this Dataset

Employee Indebtedness To The City Of Chicago

Number of employees in each department or sister agency who owe funds to the City. For each department, the dataset provides the following as of the date noted: total number of individuals employed by the department or agency, number of individuals that owe funds to the City in the department; and the total amount of debt owed by those employees. Data Owner: Revenue. Time Period: mid-October 2011 to present. Frequency: Data is updated weekly.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:13.759060
Tags: debt, personnel

Tables

Table 1

@usgov.city_of_chicago_employee_indebtedness_to_the_city_of_chicago.table_1

226.84 kB
23,946 rows
7 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "department_or_agency_name" VARCHAR,
  "arms_department_id" VARCHAR,
  "total_of_employees" DOUBLE  -- Total # Of Employees,
  "n__of_employees_with_debt" DOUBLE  -- # Of Employees With Debt,
  "n__employees_with_debt" DOUBLE  -- % Employees With Debt,
  "total_amount_due" DOUBLE
);