Employee Payroll

Cook County of Illinois

@usgov.cook_county_of_illinois_employee_payroll

Table List

1 table(5.67 MB)

Table 1

@usgov.cook_county_of_illinois_employee_payroll.table_1

5.67 MB
234299 rows
15 columns

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	position_id Position ID	employee_identifier Employee Identifier	original_hire_date Original Hire Date
2016	1	2016Q1	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	2	2016Q2	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	3	2016Q3	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	4	2016Q4	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2017	1	2017Q1	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2017	2	2017Q2	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2017	3	2017Q3	AMRITH	AAKRE	K	State's Attorney	1250	STATES ATTORNEY	1172	Assistant State's Attorney	9510200	6ac7ba3e-d286-44f5-87a0-191dc415e23c	Mon May 16 2005 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	1	2016Q1	DAVID	AARONS		Assessor	1040	COUNTY ASSESSOR	5049	Residential Model Sr Anal III	9500731	f313b1c3-1b1a-4b07-bb75-a8c850a91bac	Mon Sep 28 1998 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	2	2016Q2	DAVID	AARONS		Assessor	1040	COUNTY ASSESSOR	5049	Residential Model Sr Anal III	9500731	f313b1c3-1b1a-4b07-bb75-a8c850a91bac	Mon Sep 28 1998 00:00:00 GMT+0000 (Coordinated Universal Time)
2016	3	2016Q3	DAVID	AARONS		Assessor	1040	COUNTY ASSESSOR	5049	Residential Model Sr Anal III	9500731	f313b1c3-1b1a-4b07-bb75-a8c850a91bac	Mon Sep 28 1998 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE table_1 (
  "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
);