Chicago

Close
Author
sarahmacaraeg
Description
The Annual Appropriation Ordinance is the final City operating budget as approved by the City Council. It reflects the City’s operating budget at the beginning of the fiscal year on January 1, 2015.This dataset displays the positions and related salaries detailed in the budget as of January 1. It is extracted from the personnel portion of the Appropriation Ordinance. The dataset presents the position titles (without names) and salaries described in the budget, but does not provide a reflection of the current city workforce with full names and salaries. Disclaimer: the “Total Budgeted Units” 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 information on the current city workforce, with names, positions and salaries, visit the "Current Employee Names, Salaries, and Position Titles" dataset: https://data.cityofchicago.org/id/xzkq-xp2w.
Category
Administration & Finance
Tags
budget, 2015
Rating
Current value: 0 out of 5
Data Provided By
City of Chicago
Source Link
http://www.cityofchicago.org/city/en/depts/obm/provdrs/city_budg/svcs/budget_documents.html
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

TOTAL BUDGETED AMOUNT
total_budgeted_amount
DEPARTMENT DESCRIPTION
department_description
SECTION DESCRIPTION
section_description
SUB-SECTION DESCRIPTION
sub_section_description
TITLE DESCRIPTION
title_description
BUDGETED UNIT
budgeted_unit
TOTAL BUDGETED UNIT
total_budgeted_unit
POSITION CONTROL
position_control
BUDGETED PAY RATE
budgeted_pay_rate
DEPARTMENT CODE
department_code
FUND CODE
fund_code
FUND DESCRIPTION
fund_description
ORGANIZATION CODE
organization_code
ORGANIZATION DESCRIPTION
organization_description
DIVISION CODE
division_code
DIVISION DESCRIPTION
division_description
SECTION CODE
section_code
SUB-SECTION CODE
sub_section_code
SCHEDULE / GRADE
schedule_grade
BARGAINING UNIT
bargaining_unit
TITLE CODE
title_code

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.