Cook County

Close
Author
Cook County Open Data
Description
Employee payroll data for all Cook County employees excluding Forest Preserves, indicating amount of base salary paid to an employee during the County fiscal quarter. Salaries are paid to employees on a bi-weekly basis. Any pay period that extended between quarters will be reported to the quarter of the Pay Period End Date. (e.g. If a Pay Period runs 02/21-03/05, that pay period would be reported in the Q2 period, as the end of the pay period falls in March - Q2) The county fiscal quarters are: Q1: December - February Q2: March - May Q3: June - August Q4: September - November The Employee Unique Identifier field is a unique number assigned to each employee for the purpose of this data set, that is not their internal employee ID number, and allows an employee to be identified in the data set over time, in case of a name change or other change. This number will be consistent within the data set, but we reserve the right to regenerate this number over time across the data set. KNOWN ISSUE: Several records are missing Bureau and Office information. We are working on correcting this and will update the dataset when this issue has been resolved. For data prior to Fiscal Year 2016, see datasets at https://datacatalog.cookcountyil.gov/browse?tags=payroll
Category
Finance & Administration
Tags
payroll, salaries, salary
Rating
Current value: 0 out of 5
Data Provided By
Cook County Comptroller
Source Link
https://www.cookcountyil.gov/agency/comptroller
License
Public Domain
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:

Fiscal Year
fiscal_year
Fiscal Quarter
fiscal_quarter
Fiscal Period
fiscal_period
First Name
first_name
Last Name
last_name
Middle Init
middle_init
Bureau
bureau
Office
office
Office Name
office_name
Job Code
job_code
Job Title
job_title
Base Pay
base_pay
Position ID
position_id
Employee Identifier
employee_identifier
Original Hire Date
original_hire_date

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.