Exploration to Understand Data

Avg Pay for Police and Fire by Compensation Category

This is not everyone – there’s an estimated 117,600 full time law enforcement officers in California (but that includes state and counties, whereas this is just for cities) according to PPIC.

Track Officers Over Time

Number of people in dataset who appear for at least 4 years with one agency

## # A tibble: 1 × 1
##       n
##   <int>
## 1 39455

Assign seniority status: bottom 25% in agency’s first year of appearnce in dataset = Junior, top 25% = Senior.

## # A tibble: 3 × 2
##   status       n
##   <chr>    <int>
## 1 Junior   36451
## 2 Neither  86178
## 3 Senior  108391
## # A tibble: 10 × 2
##    agency_first_year      n
##                <dbl>  <int>
##  1              2013  44258
##  2              2014 149957
##  3              2015  23383
##  4              2016   3552
##  5              2017    654
##  6              2018   7754
##  7              2019   1188
##  8              2020    211
##  9              2021     60
## 10              2022      3