Employee salaries

Show:

Click on a table cell below to display more information about its column.

gender	department	department_name	division	assignment_category	employee_position_title	date_first_hired	year_first_hired
F	POL	Department of Police	MSB Information Mgmt and Tech Division Records Management Section	Fulltime-Regular	Office Services Coordinator	09/22/1986	1986
M	POL	Department of Police	ISB Major Crimes Division Fugitive Section	Fulltime-Regular	Master Police Officer	09/12/1988	1988
F	HHS	Department of Health and Human Services	Adult Protective and Case Management Services	Fulltime-Regular	Social Worker IV	11/19/1989	1989
M	COR	Correction and Rehabilitation	PRRS Facility and Security	Fulltime-Regular	Resident Supervisor II	05/05/2014	2014
M	HCA	Department of Housing and Community Affairs	Affordable Housing Programs	Fulltime-Regular	Planning Specialist III	03/05/2007	2007
⋮	⋮	⋮	⋮	⋮	⋮	⋮	⋮
F	HHS	Department of Health and Human Services	School Based Health Centers	Fulltime-Regular	Community Health Nurse II	11/03/2015	2015
F	FRS	Fire and Rescue Services	Human Resources Division	Fulltime-Regular	Fire/Rescue Division Chief	11/28/1988	1988
M	HHS	Department of Health and Human Services	Child and Adolescent Mental Health Clinic Services	Parttime-Regular	Medical Doctor IV - Psychiatrist	04/30/2001	2001
M	CCL	County Council	Council Central Staff	Fulltime-Regular	Manager II	09/05/2006	2006
M	DLC	Department of Liquor Control	Licensure, Regulation and Education	Fulltime-Regular	Alcohol/Tobacco Enforcement Specialist II	01/30/2012	2012

9228 rows ✕ 8 columns.

`gender`

ObjectDType

Null values: 17 (0.2%)
Unique values: 2 (< 0.1%)

Most frequent values

List:

['M', 'F']

`department`

ObjectDType

Null values: 0 (0.0%)
Unique values: 37 (0.4%)

Most frequent values

POL

HHS

FRS

DOT

COR

DLC

DGS

LIB

DPS

SHF

List:

['POL', 'HHS', 'FRS', 'DOT', 'COR', 'DLC', 'DGS', 'LIB', 'DPS', 'SHF']

`department_name`

ObjectDType

Null values: 0 (0.0%)
Unique values: 37 (0.4%)

Most frequent values

Department of Police

Department of Health and Human Services

Fire and Rescue Services

Department of Transportation

Correction and Rehabilitation

Department of Liquor Control

Department of General Services

Department of Public Libraries

Department of Permitting Services

Sheriff's Office

List:

['Department of Police', 'Department of Health and Human Services', 'Fire and Rescue Services', 'Department of Transportation', 'Correction and Rehabilitation', 'Department of Liquor Control', 'Department of General Services', 'Department of Public Libraries', 'Department of Permitting Services', "Sheriff's Office"]

`division`

ObjectDType

Null values: 0 (0.0%)
Unique values: 694 (7.5%)

Most frequent values

School Health Services

Transit Silver Spring Ride On

Transit Gaithersburg Ride On

Highway Services

Child Welfare Services

FSB Traffic Division School Safety Section

Income Supports

PSB 3rd District Patrol

PSB 4th District Patrol

Transit Nicholson Ride On

List:

['School Health Services', 'Transit Silver Spring Ride On', 'Transit Gaithersburg Ride On', 'Highway Services', 'Child Welfare Services', 'FSB Traffic Division School Safety Section', 'Income Supports', 'PSB 3rd District Patrol', 'PSB 4th District Patrol', 'Transit Nicholson Ride On']

`assignment_category`

ObjectDType

Null values: 0 (0.0%)
Unique values: 2 (< 0.1%)

Most frequent values

Fulltime-Regular

Parttime-Regular

List:

['Fulltime-Regular', 'Parttime-Regular']

`employee_position_title`

ObjectDType

Null values: 0 (0.0%)
Unique values: 443 (4.8%)

Most frequent values

Bus Operator

Police Officer III

Firefighter/Rescuer III

Manager III

Firefighter/Rescuer II

Master Firefighter/Rescuer

Office Services Coordinator

School Health Room Technician I

Police Officer II

Community Health Nurse II

List:

['Bus Operator', 'Police Officer III', 'Firefighter/Rescuer III', 'Manager III', 'Firefighter/Rescuer II', 'Master Firefighter/Rescuer', 'Office Services Coordinator', 'School Health Room Technician I', 'Police Officer II', 'Community Health Nurse II']

`date_first_hired`

ObjectDType

Null values: 0 (0.0%)
Unique values: 2264 (24.5%)

Most frequent values

12/12/2016

01/14/2013

02/24/2014

03/10/2014

08/12/2013

09/22/2014

10/06/2014

03/19/2007

07/29/2013

07/16/2012

List:

['12/12/2016', '01/14/2013', '02/24/2014', '03/10/2014', '08/12/2013', '09/22/2014', '10/06/2014', '03/19/2007', '07/29/2013', '07/16/2012']

`year_first_hired`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 2.00e+03 ± 9.33
Median ± IQR: 2005 ± 14
Min ; Max: 1965 ; 2016

No columns match the selected filter: . You can change the column filter in the dropdown menu above.

`gender`

ObjectDType

Null values: 17 (0.2%)
Unique values: 2 (< 0.1%)

Most frequent values

List:

['M', 'F']

`department`

ObjectDType

Null values: 0 (0.0%)
Unique values: 37 (0.4%)

Most frequent values

POL

HHS

FRS

DOT

COR

DLC

DGS

LIB

DPS

SHF

List:

['POL', 'HHS', 'FRS', 'DOT', 'COR', 'DLC', 'DGS', 'LIB', 'DPS', 'SHF']

`department_name`

ObjectDType

Null values: 0 (0.0%)
Unique values: 37 (0.4%)

Most frequent values

Department of Police

Department of Health and Human Services

Fire and Rescue Services

Department of Transportation

Correction and Rehabilitation

Department of Liquor Control

Department of General Services

Department of Public Libraries

Department of Permitting Services

Sheriff's Office

List:

['Department of Police', 'Department of Health and Human Services', 'Fire and Rescue Services', 'Department of Transportation', 'Correction and Rehabilitation', 'Department of Liquor Control', 'Department of General Services', 'Department of Public Libraries', 'Department of Permitting Services', "Sheriff's Office"]

`division`

ObjectDType

Null values: 0 (0.0%)
Unique values: 694 (7.5%)

Most frequent values

School Health Services

Transit Silver Spring Ride On

Transit Gaithersburg Ride On

Highway Services

Child Welfare Services

FSB Traffic Division School Safety Section

Income Supports

PSB 3rd District Patrol

PSB 4th District Patrol

Transit Nicholson Ride On

List:

['School Health Services', 'Transit Silver Spring Ride On', 'Transit Gaithersburg Ride On', 'Highway Services', 'Child Welfare Services', 'FSB Traffic Division School Safety Section', 'Income Supports', 'PSB 3rd District Patrol', 'PSB 4th District Patrol', 'Transit Nicholson Ride On']

`assignment_category`

ObjectDType

Null values: 0 (0.0%)
Unique values: 2 (< 0.1%)

Most frequent values

Fulltime-Regular

Parttime-Regular

List:

['Fulltime-Regular', 'Parttime-Regular']

`employee_position_title`

ObjectDType

Null values: 0 (0.0%)
Unique values: 443 (4.8%)

Most frequent values

Bus Operator

Police Officer III

Firefighter/Rescuer III

Manager III

Firefighter/Rescuer II

Master Firefighter/Rescuer

Office Services Coordinator

School Health Room Technician I

Police Officer II

Community Health Nurse II

List:

['Bus Operator', 'Police Officer III', 'Firefighter/Rescuer III', 'Manager III', 'Firefighter/Rescuer II', 'Master Firefighter/Rescuer', 'Office Services Coordinator', 'School Health Room Technician I', 'Police Officer II', 'Community Health Nurse II']

`date_first_hired`

ObjectDType

Null values: 0 (0.0%)
Unique values: 2264 (24.5%)

Most frequent values

12/12/2016

01/14/2013

02/24/2014

03/10/2014

08/12/2013

09/22/2014

10/06/2014

03/19/2007

07/29/2013

07/16/2012

List:

['12/12/2016', '01/14/2013', '02/24/2014', '03/10/2014', '08/12/2013', '09/22/2014', '10/06/2014', '03/19/2007', '07/29/2013', '07/16/2012']

`year_first_hired`

Int64DType

Null values: 0 (0.0%)
Mean ± Std: 2.00e+03 ± 9.33
Median ± IQR: 2005 ± 14
Min ; Max: 1965 ; 2016

No columns match the selected filter: . You can change the column filter in the dropdown menu above.

The table below shows the strength of association between the most similar columns in the dataframe. Cramér's V statistic is a number between 0 and 1. When it is close to 1 the columns are strongly associated — they contain similar information. In this case, one of them may be redundant and for some models (such as linear models) it might be beneficial to remove it.

Column 1	Column 2	Cramér's V
department	department_name	1.00
division	assignment_category	0.589
assignment_category	employee_position_title	0.488
division	employee_position_title	0.434
department_name	employee_position_title	0.416
department	employee_position_title	0.416
department	assignment_category	0.410
department_name	assignment_category	0.410
department	division	0.375
department_name	division	0.375
gender	department	0.373
gender	department_name	0.373
gender	employee_position_title	0.288
employee_position_title	date_first_hired	0.271
gender	assignment_category	0.263
gender	division	0.255