Compensation over time by type (Base, Overtime, Total (Base + Overtime) vs. Pension) and by category

Most common positions and their average pay:

dept Job_Title avg_base_pay n
Police Police Officer 80431 162735
Police Police Officer II 83657 30464
Police Police Sergeant 110617 30440
Fire Fire Captain 100426 23726
Fire Fire Engineer 87913 21027
Fire Firefighter 77116 18677
Police Police Officer III 96404 15824
Police Police Officer Ii 92206 15371
Fire Firefighter III 88059 12385
Fire Fire Fighter 78212 9991

Created “Position Types” from job titles:

  • Officer-Firefighters: Police Officer, Firefighter, Police Cadet, Recruits

  • Detective-Fire Engineer: Fire Engineer, Police Detective

  • Manager-Level: Sergeants, Captains, Lieutenants, Corporals, Battalion Chiefs, Commanders, Chiefs

  • Other: All else (but must still contain the word “Police” or “Fire” to distinguish from other city departments)

Most common items in the Other category:

dept Job_Title avg_base_pay n
Police Police Dispatcher 49872 3579
Police Police Service Representative II 69447 2682
Police Police Records Specialist 47175 2238
Police Police Records Technician 40348 1607
Police Police Services Officer 49062 1266
Fire Fire Inspector I 103491 1203
Police Police Service Representative Ii 71834 1163
Police Police Service Representative III 83843 1094
Police Police Records Clerk 37471 1002
Police Police Records Supervisor 65626 929
Police Police Dispatcher II 49722 845
Police Police Communications Dispatcher 66149 836
Police Police Assistant 22680 819
Police Police Service Officer 47258 799
Police Community Police Services Aide 75784 760
Police Crime Analyst 68708 746
Police Police Service Representative I 34707 735
Police Police Investigator 80394 704
Police Police Dispatcher Ii 61778 677
Police Police Agent 89903 654

Fire and Police Together

Fire and Police Separate

dept position compensation_type avg_comp pct_change_from_2019
Fire Manager-Level pension 24248 25.815
Fire Detective-Fire Engineer pension 19191 0.662
Fire Other Role pension 9094 62.824
Fire Officer-Firefighters pension 8372 14.272
Police Manager-Level pension 25849 55.080
Police Detective-Fire Engineer pension 11381 1419.028
Police Other Role pension 6177 33.200
Police Officer-Firefighters pension 14221 73.668
dept position compensation_type avg_comp pct_change_from_2011
Fire Manager-Level Overtime_Pay 66421 152.3
Fire Detective-Fire Engineer Overtime_Pay 56145 134.0
Fire Other Role Overtime_Pay 36978 142.7
Fire Officer-Firefighters Overtime_Pay 38406 82.7
Police Manager-Level Overtime_Pay 25380 217.1
Police Detective-Fire Engineer Overtime_Pay 21702 517.2
Police Other Role Overtime_Pay 8370 158.4
Police Officer-Firefighters Overtime_Pay 19876 214.7

Scatterplots of Salary Percentiles vs. City Characteristics

Salary = Base Pay + Overtime (unless specifically designated as just overtime)

All datapoints are a five-year average across 2013-2017

## [[1]]

## 
## [[2]]

## 
## [[3]]

## 
## [[4]]

## 
## [[5]]

## 
## [[6]]

## 
## [[7]]

## 
## [[8]]

## 
## [[9]]

## 
## [[10]]

Scatterplots of Salary by Position Type vs. City Characteristics

Salary = Base Pay + Overtime

All datapoints are a five-year average across 2013-2017

## [[1]]

## 
## [[2]]

## 
## [[3]]

## 
## [[4]]

## 
## [[5]]

## 
## [[6]]

## 
## [[7]]

## 
## [[8]]

## 
## [[9]]

Correlation Matrix of City Covariates