About this Dataset

Budget - 2017 Budget Recommendations - Positions And Salaries

This dataset includes recommended positions and salaries for 2017 by title (without names) and salary. The dataset is excerpted from the 2017 Budget Recommendations, which is the line-item budget proposed by the Mayor to the City Council for approval. Disclaimer: the “Total Budgeted Unit” column displays either A) the number of employees AND vacancies associated with a given position, or B) the number of budgeted units (ie. hours/months) for that position. “Position Control” determines whether Total Budgeted Units column will count employees and vacancies or hours/months. If a Position Control is 1, then employees and vacancies are displayed; if a Position Control is 0, then the total number of hours/months recorded is displayed. Owner: Budget and Management. Frequency: Data are updated annually. For more information about the budget process, visit the Budget Documents page: http://j.mp/lPotWf.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:38.708296
Tags: 2017, budget

Tables

Table 1

@usgov.city_of_chicago_budget_2017_budget_recommendations_pos_f084ee87.table_1

153.21 kB
7,164 rows
22 columns

CREATE TABLE table_1 (
  "fund_type" VARCHAR,
  "department_code" BIGINT,
  "department_description" VARCHAR,
  "fund_code" VARCHAR,
  "fund_description" VARCHAR,
  "organization_code" BIGINT,
  "organization_description" VARCHAR,
  "division_code" DOUBLE,
  "division_description" VARCHAR,
  "section_code" DOUBLE,
  "section_description" VARCHAR,
  "subsection_code" BIGINT,
  "sub_section_description" VARCHAR,
  "schedule_grade" VARCHAR  -- SCHEDULE / GRADE,
  "bargaining_unit" BIGINT,
  "title_code" VARCHAR,
  "title_description" VARCHAR,
  "budgeted_unit" VARCHAR,
  "total_budgeted_unit" BIGINT,
  "position_control" BIGINT,
  "budgeted_pay_rate" DOUBLE,
  "total_budgeted_amount" DOUBLE
);