Dataset: Employee Payroll In Cook County Illinois

About this Dataset

Employee Payroll In Cook County Illinois

Employee payroll data for all Cook County, Illinois 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

Tabular data includes:

Fiscal Year
Fiscal Quarter
Fiscal Period
First Name
Last Name
Middle Init
Bureau
Office
Office Name
Jobe Code
Job Title
Base Pay
Position ID
Employee Identifier
Original Hire Date

Tables

Employee Payroll

@kaggle.mattop_employee_payroll_in_cook_county_illinois.employee_payroll

6.67 MB
234299 rows
15 columns


CREATE TABLE employee_payroll (
  "fiscal_year" BIGINT,
  "fiscal_quarter" BIGINT,
  "fiscal_period" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "middle_init" VARCHAR,
  "bureau" VARCHAR,
  "office" DOUBLE,
  "office_name" VARCHAR,
  "job_code" BIGINT,
  "job_title" VARCHAR,
  "base_pay" DOUBLE,
  "position_id" BIGINT,
  "employee_identifier" VARCHAR,
  "original_hire_date" TIMESTAMP
);