CJTC certification database

cjtcdf <- read.socrata("https://data.wa.gov/resource/r5ki-dmfz.csv")

cjtc <- cjtcdf %>%
  mutate(yr.r = lubridate::year(date_received),
         yr.c = lubridate::year(date_closed),
         case.duration = as.numeric(difftime(date_closed, date_received, units="weeks")),
         case.age = as.numeric(difftime(Sys.Date(), date_received, units="weeks")),
         case.length = ifelse(!is.na(case.duration), case.duration, case.age),
         
         case.duration.mo = round(case.duration/4),
         case.age.mo = round(case.duration/4),
         case.length.mo = round(case.length/4),
         
         case.duration.yr = round(case.duration/52),
         case.age.yr = round(case.duration/52),
         case.length.yr = round(case.length/52),
         
         status = factor(status, 
                         levels = c("Investigation", "Statement of Charges", 
                                    "Hearing", "Closed")),
         status2 = factor(ifelse(status=="Closed", "Closed", "Open"), 
                          levels = c("Open", "Closed")),
         
         period = case_when(
           date_received < as.Date("2021-06-20") ~ "pre.5051",
           date_received > as.Date("2022-06-30") ~ "current",
           TRUE ~ "interim"),
         period = factor(period, levels = c("pre.5051", "interim", "current")),
         length = ifelse(
           case.length.yr > 5, 6, case.length.yr)
  )

Introduction

This report scrapes the data from the CJTC “Certification” database and presents some basic descriptive statistics.

For some of the tables and plots we split the data into 3 periods:

• pre-5051 (before July 2021),
  
• “interim” (July 2021 - June 2022, a period when the new system was being set up), and
  
• “current” (after June 2022, when the system was fully functional)

In other places, we combine the second two periods into “post-5051”.

This is a first draft, and comments/suggestions would be much appreciated.

---

Year opened and closed

Opened (all cases)

p <- cjtc %>%
  group_by(yr.r) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%

  ggplot(aes(x = yr.r, y = Number, text = scales::percent(Percent, acc=1))) +
  geom_bar(stat="identity", fill="blue", alpha=0.7) +
  
  scale_x_continuous(breaks = unique(cjtc$yr.r),
                     labels = unique(cjtc$yr.r)) +
  
  theme(axis.text.x = element_text(size=7)) +
  
  labs(title = "Cases received by year",
       x = "Year received")
  
ggplotly(p, tooltip = "text")  

Closed (all cases)

p <- cjtc %>%
  group_by(yr.c) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%

  ggplot(aes(x = yr.c, y = Number, text = scales::percent(Percent, acc=1))) +
  geom_bar(stat="identity", fill="blue", alpha=0.7) +
  
  scale_x_continuous(breaks = unique(cjtc$yr.c),
                     labels = unique(cjtc$yr.c)) +
  
  theme(axis.text.x = element_text(size=7)) +
  
  labs(title = "Cases closed by year",
       x = "Year closed")
  
ggplotly(p, tooltip = "text")  

Percent Closed (all cases)

By year

df <- cjtc %>%
  mutate(year = ifelse(date_received < as.Date("2021-07-25"),
                       2020,
                       yr.r)) %>%
  group_by(year) %>%
  summarise(
    num = n(),
    open = sum(status2 == "Open"),
    closed = sum(status2 == "Closed")
  ) %>%
  mutate(pct.closed = closed/num)

brks <- unique(df$year)
labs <- c("pre.5051", sort(unique(df$year))[-1])
  
p <- ggplot(df, aes(x = year, y = pct.closed)) +
  
  geom_line(col="blue", alpha=0.7) +
  geom_point(alpha=0.5) +
  
  scale_y_continuous(labels = scales::percent_format(acc=1)) +
  scale_x_continuous(breaks = brks,
                   labels = labs) +
  
  labs(title = "Percent of cases closed by year received",
       x = "Year",
       y = "Percent closed")
  

ggplotly(p)

By period

df <- cjtc %>%

  group_by(period) %>%
  summarise(
    num = n(),
    open = sum(status2 == "Open"),
    closed = sum(status2 == "Closed")
  ) %>%
  mutate(pct.closed = closed/num)

# brks <- unique(df$period)
# labs <- c("pre.5051", sort(unique(df$year))[-1])
  
p <- ggplot(df, aes(x = period, y = pct.closed)) +
  
  # geom_line(col="blue", alpha=0.7) +
  # geom_point(alpha=0.5) +
  
  geom_bar(stat="identity", fill="blue", alpha=0.6) +
  
  scale_y_continuous(labels = scales::percent_format(acc=1),
                     limits = c(0,1)) +
  
  labs(title = "Percent of cases closed by period received",
       x = "Period",
       y = "Percent closed")
  

ggplotly(p)

---

Status

Overall

cjtc %>%
  group_by(status) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%

  bind_rows(data.frame(status ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent)) %>%
  
  kbl(caption = "Case status",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(4, bold=T)

Case status

status	Number	Percent
Investigation	230	25%
Statement of Charges	21	2%
Closed	653	72%
Total	904	100%

By period

p <- ggplot(cjtc, 
          aes(x=period, group=desc(status), 
              fill=status)) + 
  
  geom_bar(alpha = 0.7, color="grey") +
  
  scale_fill_brewer(palette = "Spectral") +
  
  labs(title = "Case status by Period",
       x = "Period",
       y = "Number of cases",
       fill = "Status")

ggplotly(p) %>% reverse_legend_labels()

---

Outcomes

Overall

cjtc %>%
  mutate(outcome = ifelse(status2=="Open", "Still Open", case_determination),
         outcome = fct_relevel(outcome, "Still Open", after = Inf)
         ) %>%
  group_by(period, outcome) %>%
  summarize(num = n()) %>%
  pivot_wider(names_from = period,
              values_from = num) %>%
  
  bind_rows(data.frame(outcome ="Total",
           pre.5051 = sum(cjtc$period == "pre.5051"),
           interim = sum(cjtc$period == "interim"),
           current = sum(cjtc$period == "current"))) %>%
  
  kable(caption = "Outcomes by period") %>%
  kable_styling(bootstrap_options = c("striped","hover")) %>%
  
  row_spec(length(unique(cjtc$case_determination)), italic=T) %>%
  row_spec(length(unique(cjtc$case_determination))+1, bold=T)

Outcomes by period

outcome	pre.5051	interim	current
Administrative Closure	7	14	20
Certification Expired	12
Certification Revoked	298	16	4
Charge(s) Dismissed	21
Cleared	146	26	47
Denied Certification	14		1
Denied Reinstatement	2
Eligibility Reinstated	8
Surrendered	8	2	7
Still Open	25	39	187
Total	541	97	266

Post 5051

tab <- cjtc %>%
  filter(period != "pre.5051") %>%
  
  mutate(outcome = ifelse(status2=="Open", "Still Open", case_determination),
         outcome = fct_relevel(outcome, "Still Open", after = Inf)
         ) %>%
  group_by(outcome) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%

  bind_rows(data.frame(outcome ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent))

  
tab %>% kable(caption = "Outcomes by period",
              digits = c(0,0,1),
              align = "lrr") %>%
  kable_styling(bootstrap_options = c("striped","hover")) %>%
  
  row_spec(nrow(tab)-1, italic=T) %>%
  row_spec(nrow(tab), bold=T)

Outcomes by period

outcome	Number	Percent
Administrative Closure	34	9.4%
Certification Revoked	20	5.5%
Cleared	73	20.1%
Denied Certification	1	0.3%
Surrendered	9	2.5%
Still Open	226	62.3%
Total	363	100.0%

---

Processing time

Open cases (time to date)

ggplot(cjtc %>% filter(status != "Closed"), 
       aes(x = period, y = case.length.mo)) +
  
  geom_dotplot(binaxis = "y", stackdir = "center", position = "dodge",
               stackratio = 0.3, dotsize = 0.5, fill = "blue", alpha=0.1) +
  
  stat_summary(fun=mean, geom="point", shape=21,
               fill="red", size=4) +
  
  labs(title = "Open case length in months by period (red dot = mean)",
       x = "Period",
       y = "Months")

Closed cases

ggplot(cjtc %>% filter(status == "Closed"), 
       aes(x = period, y = case.length.mo)) +
  
  geom_dotplot(binaxis = "y", stackdir = "center", position = "dodge",
               stackratio = 0.3, dotsize = 0.5, fill = "blue", alpha=0.1) +
  
  stat_summary(fun=mean, geom="point", shape=21,
               fill="red", size=4) +
  
  labs(title = "Closed case length in months by period (red dot = mean)",
       x = "Period",
       y = "Months")

---

Certification type

cjtc %>%
  mutate(certification_type = ifelse(certification_type=="", 
                                     "Missing", certification_type)) %>%
  
  group_by(certification_type) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(certification_type ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent)) %>%
  
  kbl(caption = "Certification Type",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(length(unique(cjtc$certification_type))+1, bold=T)

Certification Type

certification_type	Number	Percent
Peace Officer	854	94.5%
Corrections Officer	31	3.4%
Tribal Police Officer	16	1.8%
Missing	3	0.3%
Total	904	100.0%

---

Source of complaint

Overall

cjtc %>%
  mutate(reason_for_opening_case = ifelse(reason_for_opening_case=="", 
                                          "Missing", reason_for_opening_case)) %>%
  
  group_by(reason_for_opening_case) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(reason_for_opening_case ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1)) %>%
  
  kbl(caption = "Case opened by:",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(length(unique(cjtc$reason_for_opening_case))+1, bold=T)

Case opened by:

reason_for_opening_case	Number	Percent
Agency Report	680	75.2%
Complaint	196	21.7%
Division Initiated	15	1.7%
Request for Reinstatement	10	1.1%
Other	2	0.2%
Missing	1	0.1%
Total	904	100.0%

Post 5051

tab <- cjtc %>%
  filter(period != "pre.5051") %>%
  
  mutate(reason_for_opening_case = ifelse(reason_for_opening_case=="", 
                                          "Missing", reason_for_opening_case)) %>%
  
  group_by(reason_for_opening_case) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(reason_for_opening_case ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1))
  
tab %>%  kbl(caption = "Case opened by:",
             align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(nrow(tab), bold=T)

Case opened by:

reason_for_opening_case	Number	Percent
Complaint	196	54.0%
Agency Report	149	41.0%
Division Initiated	15	4.1%
Other	2	0.6%
Missing	1	0.3%
Total	363	100.0%

---

Conduct investigated

Overall

cjtc %>%
  mutate(conduct_investigated = ifelse(conduct_investigated=="", 
                                          "Missing", conduct_investigated)) %>%
  
  group_by(conduct_investigated) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(conduct_investigated ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1)) %>%
  
  kbl(caption = "Conduct investigated",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(length(unique(cjtc$conduct_investigated))+1, bold=T)

Conduct investigated

conduct_investigated	Number	Percent
Missing	239	26.4%
RCW 43.101.105(2)(d)	230	25.4%
Other	109	12.1%
RCW 43.101.105(2)(a)	76	8.4%
RCW 43.101.105(3)(e)	42	4.6%
RCW 43.101.105(2)(e)	38	4.2%
RCW 43.101.105(3)(j)(iv)	28	3.1%
RCW 43.101.105(3)(k)	28	3.1%
RCW 9A.80.010	28	3.1%
RCW 42.20.100	19	2.1%
RCW 43.101.105(3)(h)	12	1.3%
RCW 43.101.105(3)(l)	10	1.1%
RCW 43.101.105(3)(a)	8	0.9%
RCW 43.101.105(3)(i)	8	0.9%
RCW 43.101.105(3)(f)	7	0.8%
RCW 43.101.105(3)(g)	7	0.8%
RCW 43.101.105(3)(j)(i)	4	0.4%
RCW 43.101.105(3)(j)(iii)	4	0.4%
RCW 43.101.105(3)(j)(ii)	2	0.2%
43.101.105(3)(e)	1	0.1%
43.101.105(3)(g)	1	0.1%
RCW 43.101.105(3)(b)	1	0.1%
RCW 43.101.105(3)(c)	1	0.1%
RCW 9A.76.175	1	0.1%
Total	904	100.0%

Post 5051

tab <- cjtc %>%
  filter(period != "pre.5051") %>%
  
  mutate(conduct_investigated = ifelse(conduct_investigated=="", 
                                          "Missing", conduct_investigated)) %>%
  
  group_by(conduct_investigated) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(conduct_investigated ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1))
  

tab %>% kbl(caption = "Conduct investigated",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(nrow(tab), bold=T)

Conduct investigated

conduct_investigated	Number	Percent
Missing	141	38.8%
Other	79	21.8%
RCW 43.101.105(2)(d)	32	8.8%
RCW 43.101.105(3)(e)	32	8.8%
RCW 43.101.105(3)(j)(iv)	19	5.2%
RCW 43.101.105(3)(h)	10	2.8%
RCW 43.101.105(3)(i)	8	2.2%
RCW 43.101.105(3)(f)	6	1.7%
RCW 43.101.105(2)(a)	5	1.4%
RCW 42.20.100	4	1.1%
RCW 43.101.105(3)(j)(i)	4	1.1%
RCW 43.101.105(3)(j)(iii)	4	1.1%
RCW 43.101.105(2)(e)	3	0.8%
RCW 43.101.105(3)(k)	3	0.8%
RCW 43.101.105(3)(l)	3	0.8%
RCW 43.101.105(3)(g)	2	0.6%
RCW 43.101.105(3)(j)(ii)	2	0.6%
RCW 9A.80.010	2	0.6%
43.101.105(3)(e)	1	0.3%
43.101.105(3)(g)	1	0.3%
RCW 43.101.105(3)(a)	1	0.3%
RCW 43.101.105(3)(c)	1	0.3%
Total	363	100.0%

---

Documents

Overall

All cases

tab <- cjtc %>%

  mutate(documents = ifelse(documents_link=="", "No", "Yes")) %>%
  
  group_by(documents) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(documents ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1)) 
  
tab %>% kbl(caption = "Documents available?",
            align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(nrow(tab), bold=T)

Documents available?

documents	Number	Percent
Yes	638	70.6%
No	266	29.4%
Total	904	100.0%

By status

p <- ggplot(cjtc %>%
              mutate(documents = ifelse(documents_link=="", "No", "Yes")), 
          aes(x=status, group=desc(documents), 
              fill=documents)) + 
  
  geom_bar(alpha = 0.7, color="grey") +
  
  scale_fill_brewer(palette = "Spectral") +
  
  labs(title = "Documents by Status",
       x = "Status",
       y = "Number of cases",
       fill = "Documents")

ggplotly(p) %>% reverse_legend_labels()

Post-5051

All cases

tab <- cjtc %>%
  filter(period != "pre.5051") %>%
  
  mutate(documents = ifelse(documents_link=="", "No", "Yes")) %>%
  
  group_by(documents) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(documents ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent, acc=.1)) 
  
tab %>% kbl(caption = "Documents available?",
            align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(nrow(tab), bold=T)

Documents available?

documents	Number	Percent
No	239	65.8%
Yes	124	34.2%
Total	363	100.0%

By status

p <- ggplot(cjtc %>%
              filter(period != "pre.5051") %>%
              mutate(documents = ifelse(documents_link=="", "No", "Yes")), 
          aes(x=status, group=desc(documents), 
              fill=documents)) + 
  
  geom_bar(alpha = 0.7, color="grey") +
  
  scale_fill_brewer(palette = "Spectral") +
  
  labs(title = "Documents by Status: Post-5051",
       x = "Status",
       y = "Number of cases",
       fill = "Documents")

ggplotly(p) %>% reverse_legend_labels()

---

Employers

Agency type

Overall

cjtc %>%
  mutate(agency_type = ifelse(agency_type=="", "Missing", agency_type)) %>%
  
  group_by(agency_type) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(agency_type ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent)) %>%
  
  kbl(caption = "Case Determination",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(length(unique(cjtc$agency_type))+1, bold=T)

Case Determination

agency_type	Number	Percent
PD	504	55.75%
Sheriff	288	31.86%
State	45	4.98%
Corrections	29	3.21%
Tribal	24	2.65%
Missing	14	1.55%
Total	904	100.00%

Post 5051

cjtc %>%
  filter(period != "pre.5051") %>%
  
  mutate(agency_type = ifelse(agency_type=="", "Missing", agency_type)) %>%
  
  group_by(agency_type) %>%
  summarize(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(desc(Number)) %>%

  bind_rows(data.frame(agency_type ="Total",
                       Number = sum(.$Number),
                       Percent = sum(.$Percent))) %>%
  mutate(Percent = scales::percent(Percent)) %>%
  
  kbl(caption = "Case Determination",
      align = "lrr") %>%
  kable_styling(bootstrap_options = "striped") %>%
  row_spec(length(unique(cjtc$agency_type))+1, bold=T)

Case Determination

agency_type	Number	Percent
PD	193	53.17%
Sheriff	117	32.23%
Corrections	29	7.99%
State	17	4.68%
Missing	4	1.10%
Tribal	3	0.83%
Total	363	100.00%

Agency Name

Overall

tbl <- cjtc  %>%
  mutate(employer = ifelse(employer=="", "Missing", employer),
         employer = gsub("County Sheriff's Office", "Cnty SO", employer)
         ) %>%
  
  group_by(employer) %>%
  summarise(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(Number) %>%
  filter(Number > 4)

ggplot(tbl,
       aes(x = reorder(employer, Percent), y = Percent, 
           label = Number)) +
  geom_text(aes(y = Percent), size = 3, nudge_y = .003) +
  geom_bar(stat="identity", fill="blue", alpha=.5) +
  labs(title = "Cases by Employer: Agencies with 5 or more cases",
       caption = "CJTC certification database",
       x = "",
       y = "Percent of Total") +
  
  theme(axis.text.y = element_text(size=7)) +
  
  scale_y_continuous(labels = scales::percent_format(acc=1)) +
  coord_flip()

Post-5051

tbl <- cjtc  %>%
  filter(period != "pre.5051") %>%
  
  mutate(employer = ifelse(employer=="", "Missing", employer),
         employer = gsub("County Sheriff's Office", "Cnty SO", employer)
         ) %>%
  
  group_by(employer) %>%
  summarise(Number = n()) %>%
  mutate(Percent = Number/sum(Number)) %>%
  arrange(Number) %>%
  filter(Number > 4)

ggplot(tbl,
       aes(x = reorder(employer, Percent), y = Percent, 
           label = Number)) +
  geom_text(aes(y = Percent), size = 3, nudge_y = .003) +
  geom_bar(stat="identity", fill="blue", alpha=.5) +
  labs(title = "Cases by Employer: Agencies with 5 or more cases",
       caption = "CJTC certification database",
       x = "",
       y = "Percent of Total") +
  
  scale_y_continuous(labels = scales::percent_format(acc=1)) +
  coord_flip()

---

Officers

All years, multiple records

Here we pull out officers with more than one record in the database.

cjtc %>%
  arrange(date_received) %>%
  group_by(name = officer_name) %>%
  summarize(num = n(),
            first.yr = first(yr.r),
            first.emp = first(employer),
            first.source = first(reason_for_opening_case),
            first.outcome = first(case_determination),
            last.yr = last(yr.r),
            last.emp = last(employer),
            last.source = last(reason_for_opening_case),
            last.outcome = last(case_determination)) %>%
  filter(num > 1) %>%
  arrange(desc(num)) %>%
  #select(-num) %>%
  
  kable(caption = "Officers with more than one record in the database") %>%
  kable_styling(bootstrap_options = "striped")

Officers with more than one record in the database

name	num	first.yr	first.emp	first.source	first.outcome	last.yr	last.emp	last.source	last.outcome
Taylor, Ryan	5	2022	Skamania County Sheriff’s Office	Complaint		2023	Skamania County Sheriff’s Office	Complaint	Administrative Closure
Avey, Aaron	4	2022	Kittitas County Sheriff’s Department	Complaint		2023	Kittitas County Sheriff’s Department	Complaint
Conahan, Riley	4	2021	Columbia County Sheriff’s Office	Complaint		2021	Columbia County Sheriff’s Office	Complaint	Administrative Closure
Fitzgerald, Ashley	4	2022	Seattle PD	Complaint	Administrative Closure	2022	Seattle PD	Complaint	Administrative Closure
Sparks, Thomas	4	2022	Clarkston PD	Complaint	Cleared	2022	Clarkston PD	Complaint	Cleared
Croskrey, Thomas	3	2022	Benton County Sheriff’s Office	Complaint		2023	Benton County Sheriff’s Office	Complaint
Denham, Stacy	3	2021	Centralia PD	Complaint	Cleared	2023	Centralia PD	Complaint
Do, Loc	3	2019	WA Dept. of Fish & Wildlife	Agency Report	Certification Revoked	2023	WA Dept. of Fish & Wildlife	Complaint
Helm, Joseph	3	2021	Columbia County Sheriff’s Office	Complaint		2022	Columbia County Sheriff’s Office	Complaint
Magers, Wade	3	2021	Lincoln County Sheriff’s Office	Complaint	Administrative Closure	2022	Lincoln County Sheriff’s Office	Complaint	Administrative Closure
Morningstar, Roger	3	2023	Morton PD	Complaint	Cleared	2023	Morton PD	Complaint	Certification Revoked
Osmer, Cameron	3	2023	WA State Patrol	Agency Report		2023	WA State Patrol	Complaint
Patterson, Robbie	3	2022	Columbia County Sheriff’s Office	Complaint	Cleared	2023	Columbia County Sheriff’s Office	Complaint
Snaza, Robert	3	2021	Lewis County Sheriff’s Office	Complaint	Cleared	2023	Lewis County Sheriff’s Office	Complaint
Walling, David	3	2022	Columbia County Sheriff’s Office	Complaint		2022	Columbia County Sheriff’s Office	Complaint
Alvarez, George	2	2021	King County Sheriff’s Office	Agency Report	Cleared	2023	King County Sheriff’s Office	Complaint
Arredondo, John	2	2017	Spokane PD	Agency Report	Administrative Closure	2018	Spokane PD	Agency Report	Certification Revoked
Babino, Michael	2	2022	Asotin County Sheriff’s Office	Agency Report		2022	Asotin County Sheriff’s Office	Complaint	Cleared
Batiste, John	2	2021	WA State Patrol	Complaint		2022	WA State Patrol	Complaint	Administrative Closure
Bottemiller, Tracy	2	2022	Cowlitz County Corrections	Agency Report	Administrative Closure	2022	Cowlitz County Corrections	Agency Report	Certification Revoked
Clary, John	2	2023	Toppenish PD	Complaint	Surrendered	2023	Toppenish PD	Complaint	Administrative Closure
Cox, Claude L.	2	2015	Sauk-Suiattle Tribal PD	Agency Report	Charge(s) Dismissed	2016	Mabton PD	Agency Report	Denied Certification
Davis, Ryan	2	2022	Issaquah PD	Complaint		2022	Issaquah PD	Complaint
Eastep, Chad	2	2022	Cheney PD	Complaint	Administrative Closure	2022	Cheney PD	Agency Report	Surrendered
Eastham, Jesse	2	2022	Pacific County Sheriff’s Office	Agency Report		2023	Pacific County Sheriff’s Office	Complaint
Evans Jr., Charles	2	2008	Kirkland PD	Agency Report	Certification Revoked	2015		Request for Reinstatement	Eligibility Reinstated
Fisher, Micheal	2	2006	Kettle Falls PD	Agency Report	Certification Revoked	2014		Request for Reinstatement	Eligibility Reinstated
French, Daniel, R	2	2007	Oak Harbor PD	Agency Report	Certification Revoked	2014		Request for Reinstatement	Eligibility Reinstated
Gentry, Michael J.	2	2018	Forks PD	Agency Report	Cleared	2022	Forks PD	Division Initiated	Certification Revoked
Grant, Perry C.	2	2003	Pierce County Sheriff’s Office	Agency Report	Certification Revoked	2009		Request for Reinstatement	Eligibility Reinstated
Hainline, William R.	2	2006	Ridgefield PD	Agency Report	Certification Revoked	2012		Request for Reinstatement	Denied Reinstatement
Handley, Joseph	2	2023	Palouse PD	Complaint		2023	Garfield Marshal’s Office	Complaint
Hick, David W.	2	2002	King County Sheriff’s Office	Agency Report	Certification Revoked	2006		Request for Reinstatement	Eligibility Reinstated
Jones, Shane	2	2006	Okanogan County Sheriff’s Office	Agency Report	Cleared	2021	Soap Lake PD	Agency Report	Certification Revoked
Kammerzell, Derek	2	2022	Kent PD	Complaint	Administrative Closure	2022	Kent PD	Complaint	Surrendered
Keck, Dean	2	2004	Roy PD	Agency Report	Certification Revoked	2018		Request for Reinstatement	Denied Reinstatement
Maras, Kelly	2	2022	Bonney Lake PD	Agency Report	Surrendered	2022	Bonney Lake PD	Agency Report	Administrative Closure
Michel, Natalie	2	2023	Monroe PD	Complaint		2023	Monroe PD	Complaint	Administrative Closure
Nieder, John	2	2014	Island County Sheriff’s Office	Agency Report	Cleared	2022	Island County Sheriff’s Office	Complaint
Price, Michael S	2	2004	Skagit County Sheriff’s Office	Agency Report	Certification Revoked	2011		Request for Reinstatement	Eligibility Reinstated
Queener, Ryley	2	2022	Pacific County Sheriff’s Office	Complaint		2023	Pacific County Sheriff’s Office	Complaint
Raymond, James	2	2022	Franklin CO	Complaint		2022	Franklin CO	Complaint
Reynolds, Phillip	2	2022	Centralia PD	Agency Report	Certification Revoked	2022	Centralia PD	Complaint	Administrative Closure
Reynolds, Renardo	2	2022	Vancouver PD	Complaint		2022	Clark County Sheriff’s Office	Complaint	Cleared
Rios, Anthony J.	2	2003	Olympia PD	Agency Report	Charge(s) Dismissed	2009	Elma PD	Agency Report	Certification Revoked
Sholtys, Chad	2	2007	Yakima County Sheriff’s Office	Agency Report	Certification Revoked	2016		Request for Reinstatement	Eligibility Reinstated
Tuggle, Kevin R.	2	2013	Elma PD	Agency Report	Charge(s) Dismissed	2017	Elma PD	Agency Report	Charge(s) Dismissed
Valvick, Craig	2	2023	Lake Stevens PD	Complaint		2023	Lake Stevens PD	Complaint
Vergara, Jose A.	2	2007	Pasco PD	Agency Report	Denied Certification	2014		Request for Reinstatement	Eligibility Reinstated
Whelan, Lawrence	2	2023	Steilacoom Department of Public Safety	Complaint		2023	Steilacoom Department of Public Safety	Complaint

Post 5051

Here we pull out all officers for whom a record was added to the database post 5051.

cjtc %>%
  filter(period != "pre.5051") %>%
  
  arrange(date_received) %>%
  group_by(name = officer_name) %>%
  summarize(num = n(),
            first.yr = first(yr.r),
            first.emp = first(employer),
            first.source = first(reason_for_opening_case),
            first.outcome = first(case_determination),
            last.yr = last(yr.r),
            last.emp = last(employer),
            last.source = last(reason_for_opening_case),
            last.outcome = last(case_determination)) %>%

  arrange(desc(num)) %>%
  #select(-num) %>%
  
  kable(caption = "Officers added post 5051") %>%
  kable_styling(bootstrap_options = "striped")

Officers added post 5051

name	num	first.yr	first.emp	first.source	first.outcome	last.yr	last.emp	last.source	last.outcome
Taylor, Ryan	5	2022	Skamania County Sheriff’s Office	Complaint		2023	Skamania County Sheriff’s Office	Complaint	Administrative Closure
Avey, Aaron	4	2022	Kittitas County Sheriff’s Department	Complaint		2023	Kittitas County Sheriff’s Department	Complaint
Conahan, Riley	4	2021	Columbia County Sheriff’s Office	Complaint		2021	Columbia County Sheriff’s Office	Complaint	Administrative Closure
Fitzgerald, Ashley	4	2022	Seattle PD	Complaint	Administrative Closure	2022	Seattle PD	Complaint	Administrative Closure
Sparks, Thomas	4	2022	Clarkston PD	Complaint	Cleared	2022	Clarkston PD	Complaint	Cleared
Croskrey, Thomas	3	2022	Benton County Sheriff’s Office	Complaint		2023	Benton County Sheriff’s Office	Complaint
Denham, Stacy	3	2021	Centralia PD	Complaint	Cleared	2023	Centralia PD	Complaint
Helm, Joseph	3	2021	Columbia County Sheriff’s Office	Complaint		2022	Columbia County Sheriff’s Office	Complaint
Magers, Wade	3	2021	Lincoln County Sheriff’s Office	Complaint	Administrative Closure	2022	Lincoln County Sheriff’s Office	Complaint	Administrative Closure
Morningstar, Roger	3	2023	Morton PD	Complaint	Cleared	2023	Morton PD	Complaint	Certification Revoked
Osmer, Cameron	3	2023	WA State Patrol	Agency Report		2023	WA State Patrol	Complaint
Patterson, Robbie	3	2022	Columbia County Sheriff’s Office	Complaint	Cleared	2023	Columbia County Sheriff’s Office	Complaint
Snaza, Robert	3	2021	Lewis County Sheriff’s Office	Complaint	Cleared	2023	Lewis County Sheriff’s Office	Complaint
Walling, David	3	2022	Columbia County Sheriff’s Office	Complaint		2022	Columbia County Sheriff’s Office	Complaint
Babino, Michael	2	2022	Asotin County Sheriff’s Office	Agency Report		2022	Asotin County Sheriff’s Office	Complaint	Cleared
Batiste, John	2	2021	WA State Patrol	Complaint		2022	WA State Patrol	Complaint	Administrative Closure
Bottemiller, Tracy	2	2022	Cowlitz County Corrections	Agency Report	Administrative Closure	2022	Cowlitz County Corrections	Agency Report	Certification Revoked
Clary, John	2	2023	Toppenish PD	Complaint	Surrendered	2023	Toppenish PD	Complaint	Administrative Closure
Davis, Ryan	2	2022	Issaquah PD	Complaint		2022	Issaquah PD	Complaint
Do, Loc	2	2023	WA Dept. of Fish & Wildlife	Complaint	Administrative Closure	2023	WA Dept. of Fish & Wildlife	Complaint
Eastep, Chad	2	2022	Cheney PD	Complaint	Administrative Closure	2022	Cheney PD	Agency Report	Surrendered
Eastham, Jesse	2	2022	Pacific County Sheriff’s Office	Agency Report		2023	Pacific County Sheriff’s Office	Complaint
Handley, Joseph	2	2023	Palouse PD	Complaint		2023	Garfield Marshal’s Office	Complaint
Kammerzell, Derek	2	2022	Kent PD	Complaint	Administrative Closure	2022	Kent PD	Complaint	Surrendered
Maras, Kelly	2	2022	Bonney Lake PD	Agency Report	Surrendered	2022	Bonney Lake PD	Agency Report	Administrative Closure
Michel, Natalie	2	2023	Monroe PD	Complaint		2023	Monroe PD	Complaint	Administrative Closure
Queener, Ryley	2	2022	Pacific County Sheriff’s Office	Complaint		2023	Pacific County Sheriff’s Office	Complaint
Raymond, James	2	2022	Franklin CO	Complaint		2022	Franklin CO	Complaint
Reynolds, Phillip	2	2022	Centralia PD	Agency Report	Certification Revoked	2022	Centralia PD	Complaint	Administrative Closure
Reynolds, Renardo	2	2022	Vancouver PD	Complaint		2022	Clark County Sheriff’s Office	Complaint	Cleared
Valvick, Craig	2	2023	Lake Stevens PD	Complaint		2023	Lake Stevens PD	Complaint
Whelan, Lawrence	2	2023	Steilacoom Department of Public Safety	Complaint		2023	Steilacoom Department of Public Safety	Complaint
Aase, Bryson	1	2022	Whitman County Sheriff’s Office	Complaint	Cleared	2022	Whitman County Sheriff’s Office	Complaint	Cleared
Abbott, Ryan	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Adams, Raul	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Al-Salehi, Jafar	1	2023	Seattle PD	Agency Report		2023	Seattle PD	Agency Report
Allen, Leland	1	2023	Port of Seattle PD	Division Initiated		2023	Port of Seattle PD	Division Initiated
Allen, Michael	1	2022	King County Department of Adult & Juvenile Detention	Complaint		2022	King County Department of Adult & Juvenile Detention	Complaint
Almer, Donald	1	2023	Bellingham PD	Complaint		2023	Bellingham PD	Complaint
Alvarez, George	1	2023	King County Sheriff’s Office	Complaint		2023	King County Sheriff’s Office	Complaint
Ambrose, Stephanie	1	2022	Arlington PD	Complaint		2022	Arlington PD	Complaint
Amichia, Niamkey	1	2023	Puyallup PD	Division Initiated		2023	Puyallup PD	Division Initiated
Anderson, Chase	1	2021	Hamilton PD	Agency Report	Surrendered	2021	Hamilton PD	Agency Report	Surrendered
Anderson, Michael	1	2023	Snohomish County Sheriff’s Office	Complaint	Administrative Closure	2023	Snohomish County Sheriff’s Office	Complaint	Administrative Closure
Araiza, Francisco	1	2023	Mattawa PD	Agency Report	Cleared	2023	Mattawa PD	Agency Report	Cleared
Arnold, James	1	2023	WA State Patrol	Agency Report		2023	WA State Patrol	Agency Report
Aston, Jesse	1	2023	Kalispel Tribal Public Safety	Agency Report		2023	Kalispel Tribal Public Safety	Agency Report
Atkins, Chuck	1	2022	Clark County Sheriff’s Office	Complaint		2022	Clark County Sheriff’s Office	Complaint
Auderer, Daniel	1	2023	Seattle PD	Division Initiated		2023	Seattle PD	Division Initiated
Backus, Christopher	1	2023	Tenino PD	Division Initiated		2023	Tenino PD	Division Initiated
Bailey, Jessy	1	2021	King County Sheriff’s Office	Agency Report	Cleared	2021	King County Sheriff’s Office	Agency Report	Cleared
Bair, Austin	1	2023	WA Parks and Recreation	Complaint		2023	WA Parks and Recreation	Complaint
Balam, Rick	1	2023	Okanogan County Sheriff’s Office	Agency Report	Cleared	2023	Okanogan County Sheriff’s Office	Agency Report	Cleared
Banks, Breauna	1	2023	Pullman PD	Agency Report		2023	Pullman PD	Agency Report
Barrow, Lee	1	2022	Franklin CO	Complaint		2022	Franklin CO	Complaint
Beasley, Jarod	1	2023	Spokane PD	Agency Report		2023	Spokane PD	Agency Report
Beck, Justin	1	2021	Walla Walla County Corrections	Agency Report	Certification Revoked	2021	Walla Walla County Corrections	Agency Report	Certification Revoked
Beckman, Michael	1	2021	Kalispel Tribal Public Safety	Agency Report	Certification Revoked	2021	Kalispel Tribal Public Safety	Agency Report	Certification Revoked
Bell, Connor	1	2023		Complaint		2023		Complaint
Bennett, Anthony	1	2022	Clarkston PD	Complaint	Cleared	2022	Clarkston PD	Complaint	Cleared
Bentley, Christopher	1	2023	University of Washington PD	Complaint		2023	University of Washington PD	Complaint
Berg, John	1	2021	Puyallup PD	Agency Report	Certification Revoked	2021	Puyallup PD	Agency Report	Certification Revoked
Blundred, David	1	2022	Hoquiam PD	Agency Report		2022	Hoquiam PD	Agency Report
Boggs, Christopher	1	2022	Shoalwater Bay PD	Agency Report	Administrative Closure	2022	Shoalwater Bay PD	Agency Report	Administrative Closure
Boyd, Darin	1	2022	Clarkston PD	Complaint	Cleared	2022	Clarkston PD	Complaint	Cleared
Brazas, Robert	1	2023	WA State Patrol	Agency Report	Surrendered	2023	WA State Patrol	Agency Report	Surrendered
Breen, Dustin	1	2023	Lewis County Sheriff’s Office	Complaint	Cleared	2023	Lewis County Sheriff’s Office	Complaint	Cleared
Brent, Ernest	1	2022	King County Sheriff’s Office	Agency Report		2022	King County Sheriff’s Office	Agency Report
Brummett, Tim	1	2022	Walla Walla County Corrections	Agency Report		2022	Walla Walla County Corrections	Agency Report
Buescher, Joshua	1	2023	Moses Lake PD	Complaint	Cleared	2023	Moses Lake PD	Complaint	Cleared
Burbank, Christopher	1	2023	Tacoma PD	Division Initiated		2023	Tacoma PD	Division Initiated
Burbridge, Nicole	1	2021	Spokane County Sheriff’s Office	Agency Report		2021	Spokane County Sheriff’s Office	Agency Report
Burgess, MacKenzie	1	2022	Franklin County Corrections Division	Other	Cleared	2022	Franklin County Corrections Division	Other	Cleared
Burress, Thomas	1	2022	WA State Patrol	Agency Report		2022	WA State Patrol	Agency Report
Butts, Kyle	1	2022	Federal Way PD	Complaint		2022	Federal Way PD	Complaint
Camden, Kelly	1	2022	Yakima County Department of Corrections	Agency Report		2022	Yakima County Department of Corrections	Agency Report
Campbell Joseph	1	2022	Yakima County Department of Corrections	Complaint		2022	Yakima County Department of Corrections	Complaint
Campbell, Edmund	1	2022	Yakima County Department of Corrections	Complaint		2022	Yakima County Department of Corrections	Complaint
Cantu, Leandro	1	2023	Benton County Sheriff’s Office	Complaint		2023	Benton County Sheriff’s Office	Complaint
Case, Austin	1	2023	Whatcom County Sheriff’s Office	Division Initiated		2023	Whatcom County Sheriff’s Office	Division Initiated
Celestine, Micheal	1	2023	Snohomish County Sheriff’s Office	Complaint		2023	Snohomish County Sheriff’s Office	Complaint
Chandler, James	1	2023	WA Dept. of Fish & Wildlife	Agency Report		2023	WA Dept. of Fish & Wildlife	Agency Report
Chavez, Gregory	1	2023	Kitsap County Sheriff’s Office	Agency Report		2023	Kitsap County Sheriff’s Office	Agency Report
Chavez, Jason	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Clary, Brigit	1	2023	Richland PD	Complaint	Surrendered	2023	Richland PD	Complaint	Surrendered
Clary, David	1	2023	Centralia PD	Complaint	Cleared	2023	Centralia PD	Complaint	Cleared
Collins, Matthew	1	2023	Tacoma PD	Division Initiated		2023	Tacoma PD	Division Initiated
Constantin, Andrei	1	2022	Seattle PD	Agency Report		2022	Seattle PD	Agency Report
Cooke, Michael R.	1	2021	Pierce County Sheriff’s Office	Complaint	Cleared	2021	Pierce County Sheriff’s Office	Complaint	Cleared
Corier, Jabe	1	2022	Walla Walla County Corrections	Agency Report		2022	Walla Walla County Corrections	Agency Report
Coronado, Adolfo	1	2022	Adams County Sheriff’s Office	Complaint		2022	Adams County Sheriff’s Office	Complaint
Covey, Rodney	1	2021	Port of Seattle PD	Agency Report	Cleared	2021	Port of Seattle PD	Agency Report	Cleared
Cox, Ryan	1	2023	Soap Lake PD	Complaint	Cleared	2023	Soap Lake PD	Complaint	Cleared
Cozzitorto, Peter	1	2023	WA State Patrol	Agency Report		2023	WA State Patrol	Agency Report
Cram, Scott	1	2022	Franklin County Corrections Division	Other	Cleared	2022	Franklin County Corrections Division	Other	Cleared
Culp, Aaron	1	2022	Okanogan County Sheriff’s Office	Complaint	Cleared	2022	Okanogan County Sheriff’s Office	Complaint	Cleared
David Adams	1	2023	Seattle PD	Complaint		2023	Seattle PD	Complaint
Davidson, Trevor	1	2022	Renton PD	Complaint	Cleared	2022	Renton PD	Complaint	Cleared
Davis, Eugene	1	2022	Okanogan County Sheriff’s Office	Complaint	Cleared	2022	Okanogan County Sheriff’s Office	Complaint	Cleared
Davis, Joshua	1	2021	King County Sheriff’s Office	Agency Report		2021	King County Sheriff’s Office	Agency Report
Davis, Lucas	1	2023	Kitsap County Sheriff’s Office	Agency Report		2023	Kitsap County Sheriff’s Office	Agency Report
Doonan, Joshua	1	2023	Everett PD	Complaint		2023	Everett PD	Complaint
Dorff, John	1	2021	Centralia PD	Agency Report	Certification Revoked	2021	Centralia PD	Agency Report	Certification Revoked
Dowsing, William	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Duffy, Jeremie	1	2023	Pierce County Sheriff’s Office	Agency Report		2023	Pierce County Sheriff’s Office	Agency Report
Dunn, Dustin	1	2023	Yakima County Sheriff’s Office	Complaint		2023	Yakima County Sheriff’s Office	Complaint
Dyment, Adam	1	2022	Goldendale PD	Agency Report	Cleared	2022	Goldendale PD	Agency Report	Cleared
Ejde, Jordan	1	2023	Bremerton PD	Complaint	Cleared	2023	Bremerton PD	Complaint	Cleared
Elkins, Sidney	1	2022	Federal Way PD	Complaint		2022	Federal Way PD	Complaint
Everett, Alexander	1	2021	Seattle PD	Agency Report		2021	Seattle PD	Agency Report
Everett, Caitlin	1	2021	Seattle PD	Agency Report		2021	Seattle PD	Agency Report
Faaumu, Sekonaia	1	2022	King County Department of Adult & Juvenile Detention	Agency Report		2022	King County Department of Adult & Juvenile Detention	Agency Report
Farrer, Jacob	1	2021	Blaine PD	Agency Report	Cleared	2021	Blaine PD	Agency Report	Cleared
Fioretti, Brett	1	2022	Ocean Shores PD	Agency Report	Cleared	2022	Ocean Shores PD	Agency Report	Cleared
Flack, Michael	1	2023	Snohomish County Sheriff’s Office	Complaint		2023	Snohomish County Sheriff’s Office	Complaint
Foley, Austin	1	2022	Vancouver PD	Agency Report	Cleared	2022	Vancouver PD	Agency Report	Cleared
Forbes, Jon	1	2023	Benton County Sheriff’s Office	Agency Report		2023	Benton County Sheriff’s Office	Agency Report
Fowler, Rich	1	2023	Yakima PD	Complaint		2023	Yakima PD	Complaint
Francis, Richard	1	2021	Moses Lake PD	Agency Report	Certification Revoked	2021	Moses Lake PD	Agency Report	Certification Revoked
French, Jamie	1	2021	Everett PD	Complaint	Cleared	2021	Everett PD	Complaint	Cleared
Fritz, Martin	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Gallardo, Julio	1	2023		Complaint		2023		Complaint
Gandy, Brandon	1	2023	Seattle PD	Complaint		2023	Seattle PD	Complaint
Gann, Jeffery	1	2021	Castle Rock PD	Complaint		2021	Castle Rock PD	Complaint
Garcia, Adrian	1	2023	Yakima County Sheriff’s Office	Complaint	Cleared	2023	Yakima County Sheriff’s Office	Complaint	Cleared
Garcia, Daniel	1	2023	Pacific County Sheriff’s Office	Division Initiated		2023	Pacific County Sheriff’s Office	Division Initiated
Garcia, Eduardo	1	2023	Mabton PD	Complaint		2023	Mabton PD	Complaint
Gates, Eric	1	2022	Steilacoom Department of Public Safety	Agency Report	Cleared	2022	Steilacoom Department of Public Safety	Agency Report	Cleared
Gavin, Jerod	1	2021	Omak PD	Agency Report	Certification Revoked	2021	Omak PD	Agency Report	Certification Revoked
Gentry, Michael J.	1	2022	Forks PD	Division Initiated	Certification Revoked	2022	Forks PD	Division Initiated	Certification Revoked
Gettys, Michael	1	2023	Kettle Falls PD	Complaint		2023	Kettle Falls PD	Complaint
Giammalva, Jocelyn	1	2021	Centralia PD	Agency Report	Certification Revoked	2021	Centralia PD	Agency Report	Certification Revoked
Gibson, James	1	2022	Asotin County Sheriff’s Office	Complaint	Cleared	2022	Asotin County Sheriff’s Office	Complaint	Cleared
Gilbert, Matthew	1	2023	Grand Coulee PD	Complaint		2023	Grand Coulee PD	Complaint
Glover, James	1	2022	Chewelah PD	Agency Report		2022	Chewelah PD	Agency Report
Gomez-Armitage, Sonia	1	2022	Roy PD	Agency Report		2022	Roy PD	Agency Report
Good, Matthew	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Guerrero, Edmund	1	2022	Moses Lake PD	Complaint		2022	Moses Lake PD	Complaint
Guerrero, Lee	1	2023	Pasco PD	Agency Report		2023	Pasco PD	Agency Report
Haglin, Phineas	1	2021	Kalispel Tribal Public Safety	Agency Report	Surrendered	2021	Kalispel Tribal Public Safety	Agency Report	Surrendered
Hammond, Jonathan	1	2023	Pierce County Sheriff’s Office	Agency Report		2023	Pierce County Sheriff’s Office	Agency Report
Hancock, Robert	1	2022	Bremerton PD	Agency Report	Administrative Closure	2022	Bremerton PD	Agency Report	Administrative Closure
Hansen, Kurt	1	2021	King County Department of Adult & Juvenile Detention	Agency Report	Administrative Closure	2021	King County Department of Adult & Juvenile Detention	Agency Report	Administrative Closure
Harding, Ronald	1	2023	Poulsbo PD	Complaint		2023	Poulsbo PD	Complaint
Hatcher, Jerry	1	2021	Benton County Sheriff’s Office	Agency Report		2021	Benton County Sheriff’s Office	Agency Report
Hattaway, Jamey	1	2023	Orting PD	Complaint		2023	Orting PD	Complaint
Hawley, Anthony	1	2023	Okanogan County Sheriff’s Office	Complaint		2023	Okanogan County Sheriff’s Office	Complaint
Heath, Woody	1	2022	WA State Patrol	Agency Report		2022	WA State Patrol	Agency Report
Helton, William	1	2023	Skamania County Sheriff’s Office	Complaint	Cleared	2023	Skamania County Sheriff’s Office	Complaint	Cleared
Herrera, Rafael	1	2022	Kalama PD	Complaint		2022	Kalama PD	Complaint
Herrmann, George	1	2023	Spokane County Detention Services	Agency Report		2023	Spokane County Detention Services	Agency Report
Hilton, Clay Vaughn	1	2023	Spokane County Sheriff’s Office	Agency Report		2023	Spokane County Sheriff’s Office	Agency Report
Hintz, Aaron	1	2022	Moses Lake PD	Complaint		2022	Moses Lake PD	Complaint
Holt, Joshua	1	2023	San Juan County Sheriff’s Office	Complaint		2023	San Juan County Sheriff’s Office	Complaint
Horch, John	1	2022	Clark County Sheriff’s Office	Complaint		2022	Clark County Sheriff’s Office	Complaint
Howell, Cameron	1	2023	Goldendale PD	Agency Report	Denied Certification	2023	Goldendale PD	Agency Report	Denied Certification
Huft, Tina M.	1	2023	Cowlitz County Corrections	Agency Report		2023	Cowlitz County Corrections	Agency Report
Huizar, Elias	1	2024	Yakima PD	Division Initiated		2024	Yakima PD	Division Initiated
Humphrey, Jeffrey	1	2023	Lewis County Sheriff’s Office	Complaint		2023	Lewis County Sheriff’s Office	Complaint
Jarrett, Job	1	2022	King County Sheriff’s Office	Agency Report		2022	King County Sheriff’s Office	Agency Report
Jarvis, Sean	1	2023	Raymond PD	Complaint		2023	Raymond PD	Complaint
Jensen, Seth	1	2023	Thurston County Sheriff’s Office	Agency Report	Cleared	2023	Thurston County Sheriff’s Office	Agency Report	Cleared
Jenson, Kelly	1	2022	Liberty Lake PD	Agency Report		2022	Liberty Lake PD	Agency Report
Johnson, Caleb	1	2023	Yakima County Sheriff’s Office	Complaint	Cleared	2023	Yakima County Sheriff’s Office	Complaint	Cleared
Johnson, Christopher	1	2022	Roy PD	Complaint		2022	Roy PD	Complaint
Johnson, David	1	2022	Toppenish PD	Complaint	Cleared	2022	Toppenish PD	Complaint	Cleared
Johnson, Michael	1	2022	Port Angeles PD	Agency Report		2022	Port Angeles PD	Agency Report
Johnson, Scott	1	2023	Pacific County Sheriff’s Office	Complaint	Cleared	2023	Pacific County Sheriff’s Office	Complaint	Cleared
Johnson, Thomas	1	2023	Grand Coulee PD	Agency Report		2023	Grand Coulee PD	Agency Report
Kane, Didy	1	2023	Snohomish County Sheriff’s Office	Complaint		2023	Snohomish County Sheriff’s Office	Complaint
Kaylor Jr., John	1	2023	Sumner PD	Agency Report		2023	Sumner PD	Agency Report
Keller, Craig	1	2022	Poulsbo PD	Complaint		2022	Poulsbo PD	Complaint
Kim, Hyun	1	2023	Lacey PD	Agency Report		2023	Lacey PD	Agency Report
Kimball, Anthony	1	2023	Pacific County Sheriff’s Office	Complaint		2023	Pacific County Sheriff’s Office	Complaint
Kioroglo, Boris	1	2021	Vancouver PD	Agency Report	Cleared	2021	Vancouver PD	Agency Report	Cleared
Kirby, Joann	1	2023	Spokane County Detention Services	Agency Report		2023	Spokane County Detention Services	Agency Report
Kitchens, Seiya	1	2022	Marysville PD	Complaint	Cleared	2022	Marysville PD	Complaint	Cleared
Klein, Richard	1	2022	Federal Way PD	Division Initiated		2022	Federal Way PD	Division Initiated
Langton, Michael	1	2022	Ferndale PD	Agency Report	Certification Revoked	2022	Ferndale PD	Agency Report	Certification Revoked
Law, Jon	1	2023	Benton County Sheriff’s Office	Complaint		2023	Benton County Sheriff’s Office	Complaint
LeQuire, Christopher	1	2023	Spokane PD	Complaint		2023	Spokane PD	Complaint
Leach, Mckenzy	1	2023	WA State Patrol	Agency Report		2023	WA State Patrol	Agency Report
Leddy, Martin L.	1	2022	Federal Way PD	Complaint		2022	Federal Way PD	Complaint
Lewis, Mark	1	2022	WA State Patrol	Division Initiated		2022	WA State Patrol	Division Initiated
Lopez, Raul	1	2022	Newport PD	Agency Report	Certification Revoked	2022	Newport PD	Agency Report	Certification Revoked
Luttrull, Brian	1	2023	Lakewood PD	Complaint	Cleared	2023	Lakewood PD	Complaint	Cleared
Luvaas, Natalie	1	2022	SCORE	Agency Report	Cleared	2022	SCORE	Agency Report	Cleared
Lyle, Christian	1	2023	Skamania County Sheriff’s Office	Agency Report		2023	Skamania County Sheriff’s Office	Agency Report
Lyman, Kenneth	1	2022	Auburn PD	Complaint	Cleared	2022	Auburn PD	Complaint	Cleared
Lynch, Nathan	1	2022	Port Orchard PD	Agency Report		2022	Port Orchard PD	Agency Report
Malloy, Daniel	1	2021	King County Sheriff’s Office	Agency Report		2021	King County Sheriff’s Office	Agency Report
Marble, Gaven	1	2022	Klickitat County Sheriff’s Office	Agency Report	Cleared	2022	Klickitat County Sheriff’s Office	Agency Report	Cleared
Marroquin, Michael	1	2022	Liberty Lake PD	Agency Report		2022	Liberty Lake PD	Agency Report
McCormack, Molly	1	2023	Bellevue PD	Agency Report		2023	Bellevue PD	Agency Report
McGinty, Adam	1	2023	Bellingham PD	Agency Report		2023	Bellingham PD	Agency Report
McGinty, Jamey	1	2023	Lewis County Sheriff’s Office	Complaint	Cleared	2023	Lewis County Sheriff’s Office	Complaint	Cleared
McGuigan, William	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Mckellips, Andrew	1	2021	Hamilton PD	Agency Report	Certification Revoked	2021	Hamilton PD	Agency Report	Certification Revoked
Meador, Loren	1	2021	Renton PD	Agency Report	Certification Revoked	2021	Renton PD	Agency Report	Certification Revoked
Medelez, Vicente	1	2022	Granger PD	Agency Report		2022	Granger PD	Agency Report
Mendoza, Andrea	1	2023	Vancouver PD	Agency Report		2023	Vancouver PD	Agency Report
Menges, Lewis	1	2023	Richland PD	Agency Report		2023	Richland PD	Agency Report
Miller, Matthew	1	2021	Clark County Sheriff’s Office - Corrections	Agency Report	Administrative Closure	2021	Clark County Sheriff’s Office - Corrections	Agency Report	Administrative Closure
Mills, Jason	1	2023	Vancouver PD	Complaint	Cleared	2023	Vancouver PD	Complaint	Cleared
Miner, James	1	2023	Snohomish County Sheriff’s Office	Agency Report		2023	Snohomish County Sheriff’s Office	Agency Report
Molett, Brandon	1	2022	Cowlitz Indian Tribal Public Safety Department	Agency Report	Administrative Closure	2022	Cowlitz Indian Tribal Public Safety Department	Agency Report	Administrative Closure
Morfoot, Michael	1	2023	Kent PD	Agency Report		2023	Kent PD	Agency Report
Morse, Matthew	1	2023	Tacoma PD	Agency Report		2023	Tacoma PD	Agency Report
Musser, Arthur	1	2022	Asotin County Sheriff’s Office	Agency Report		2022	Asotin County Sheriff’s Office	Agency Report
Negrete, Mark	1	2021	Selah PD	Agency Report		2021	Selah PD	Agency Report
Nelson, Jeff	1	2022	Auburn PD	Complaint	Administrative Closure	2022	Auburn PD	Complaint	Administrative Closure
Nelson, Jeffrey	1	2022	Auburn PD	Division Initiated		2022	Auburn PD	Division Initiated
Neumann, Jerry	1	2022	Palouse PD	Complaint		2022	Palouse PD	Complaint
Nguyen, Quan	1	2021	Renton PD	Agency Report	Certification Revoked	2021	Renton PD	Agency Report	Certification Revoked
Nichols, Taylor	1	2021	Lewis County Sheriff’s Office	Agency Report	Cleared	2021	Lewis County Sheriff’s Office	Agency Report	Cleared
Nieder, John	1	2022	Island County Sheriff’s Office	Complaint		2022	Island County Sheriff’s Office	Complaint
Noble, Douglas	1	2022	Lynnwood PD	Agency Report		2022	Lynnwood PD	Agency Report
Noble, Shawn	1	2022	Lakewood PD	Agency Report	Cleared	2022	Lakewood PD	Agency Report	Cleared
Nolan, Chad	1	2023	Vancouver PD	Complaint	Cleared	2023	Vancouver PD	Complaint	Cleared
Noren, Leif	1	2021	Richland PD	Agency Report	Certification Revoked	2021	Richland PD	Agency Report	Certification Revoked
Nulph, Spencer	1	2022	Soap Lake PD	Agency Report	Cleared	2022	Soap Lake PD	Agency Report	Cleared
Odenborg, Brian	1	2022	Clarkston PD	Complaint	Cleared	2022	Clarkston PD	Complaint	Cleared
Ojeda Lopez, Rosa	1	2023	Seattle PD	Division Initiated		2023	Seattle PD	Division Initiated
Okeefe, Brady	1	2023	Seattle PD	Agency Report		2023	Seattle PD	Agency Report
Olivas, Jacob	1	2023	Zillah PD	Complaint		2023	Zillah PD	Complaint
Olvera, Victor	1	2023	Kitsap County Sheriff’s Office	Agency Report		2023	Kitsap County Sheriff’s Office	Agency Report
Ostergard, Andrew	1	2021	Mason County Sheriff’s Office - Corrections	Agency Report	Administrative Closure	2021	Mason County Sheriff’s Office - Corrections	Agency Report	Administrative Closure
Palaita, Emmanuel	1	2023	King County Department of Adult & Juvenile Detention	Agency Report		2023	King County Department of Adult & Juvenile Detention	Agency Report
Palombi, Joe	1	2023	Orting PD	Complaint	Administrative Closure	2023	Orting PD	Complaint	Administrative Closure
Parker, Alan	1	2023	Kittitas PD	Complaint		2023	Kittitas PD	Complaint
Patsey, Derek	1	2023	Port Gamble S’Kllallam Tribe PD	Agency Report		2023	Port Gamble S’Kllallam Tribe PD	Agency Report
Peacey, Robin	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Perez Puga, Daniel	1	2023	Seattle PD	Agency Report		2023	Seattle PD	Agency Report
Peters, Brad	1	2022	Asotin County Sheriff’s Office	Complaint	Cleared	2022	Asotin County Sheriff’s Office	Complaint	Cleared
Peterschick, Chad	1	2022	Yakima County Sheriff’s Office	Complaint	Cleared	2022	Yakima County Sheriff’s Office	Complaint	Cleared
Pettit, Kyle	1	2023	Raymond PD	Complaint		2023	Raymond PD	Complaint
Phillips, Ryan	1	2022	Snohomish County Sheriff’s Office	Agency Report		2022	Snohomish County Sheriff’s Office	Agency Report
Phipps, Michael	1	2022	Pierce County Sheriff’s Office	Agency Report		2022	Pierce County Sheriff’s Office	Agency Report
Pilcher, Carl	1	2021	Swinomish PD	Complaint	Administrative Closure	2021	Swinomish PD	Complaint	Administrative Closure
Polonsky, Steven	1	2023	Bremerton PD	Agency Report		2023	Bremerton PD	Agency Report
Poteet, Keith	1	2021	Stillaguamish PD	Agency Report		2021	Stillaguamish PD	Agency Report
Prentice-Wattson, Craig	1	2023	Ridgefield PD	Complaint		2023	Ridgefield PD	Complaint
Price, Brian	1	2022	Longview PD	Complaint		2022	Longview PD	Complaint
Price, Colton	1	2023	Vancouver PD	Agency Report		2023	Vancouver PD	Agency Report
Prim, Micah	1	2022	Spokane PD	Complaint	Cleared	2022	Spokane PD	Complaint	Cleared
Ramos, Moses	1	2023	King County Department of Adult & Juvenile Detention	Agency Report		2023	King County Department of Adult & Juvenile Detention	Agency Report
Rankin, Brandon	1	2022	Spokane PD	Complaint		2022	Spokane PD	Complaint
Rankine, Timothy	1	2023	Tacoma PD	Division Initiated		2023	Tacoma PD	Division Initiated
Raysbrook, Mark	1	2022	Snohomish County Sheriff’s Office	Agency Report		2022	Snohomish County Sheriff’s Office	Agency Report
Reece, Terry	1	2023	Longview PD	Complaint		2023	Longview PD	Complaint
Richmond, Andrew	1	2023	Spokane PD	Agency Report		2023	Spokane PD	Agency Report
Riedel, Brandon	1	2023	Vancouver PD	Agency Report		2023	Vancouver PD	Agency Report
Riess, Ryan	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Riley, Joshua	1	2023	Kennewick PD	Agency Report		2023	Kennewick PD	Agency Report
Riordan, Daniel	1	2021	Lewis County Sheriff’s Office	Complaint	Cleared	2021	Lewis County Sheriff’s Office	Complaint	Cleared
Rittgarn, Zachary	1	2021	Lynnwood PD - Corrections	Agency Report	Administrative Closure	2021	Lynnwood PD - Corrections	Agency Report	Administrative Closure
Robillard, Jeffrey	1	2022	Tacoma PD	Agency Report	Certification Revoked	2022	Tacoma PD	Agency Report	Certification Revoked
Robinson, Cleades	1	2023	Seattle PD	Agency Report	Surrendered	2023	Seattle PD	Agency Report	Surrendered
Roche, Nicolas	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Rogers, Trevor	1	2023	Ellensburg PD	Complaint	Cleared	2023	Ellensburg PD	Complaint	Cleared
Rojas, Patricia	1	2023	Pacific County Sheriff’s Office	Complaint		2023	Pacific County Sheriff’s Office	Complaint
Salinas, Robert	1	2022	Mattawa PD	Complaint	Cleared	2022	Mattawa PD	Complaint	Cleared
Sanders, Derek	1	2023	Thurston County Sheriff’s Office	Complaint	Cleared	2023	Thurston County Sheriff’s Office	Complaint	Cleared
Scheyer, Summer	1	2023	Skamania County Sheriff’s Office	Complaint		2023	Skamania County Sheriff’s Office	Complaint
Seifert, Neil	1	2023	Battle Ground PD	Complaint	Cleared	2023	Battle Ground PD	Complaint	Cleared
Seiffert, Drew	1	2023	Spokane County Detention Services	Agency Report		2023	Spokane County Detention Services	Agency Report
Serrano, Jimmy	1	2023	King County Department of Adult & Juvenile Detention			2023	King County Department of Adult & Juvenile Detention
Seth, Jarrod	1	2023	Everett PD	Agency Report		2023	Everett PD	Agency Report
Shephard, Travis	1	2023	Yakima PD	Agency Report		2023	Yakima PD	Agency Report
Sheppard, Aaron	1	2022	Richland PD	Agency Report		2022	Richland PD	Agency Report
Shovlin, Michael	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Smerer, Michael	1	2021	Centralia PD	Agency Report	Certification Revoked	2021	Centralia PD	Agency Report	Certification Revoked
Smith, Michael	1	2022	Auburn PD	Agency Report	Certification Revoked	2022	Auburn PD	Agency Report	Certification Revoked
Songer, Bob	1	2022	Klickitat County Sheriff’s Office	Complaint	Cleared	2022	Klickitat County Sheriff’s Office	Complaint	Cleared
Sparaza, Arturo	1	2021	SCORE	Agency Report		2021	SCORE	Agency Report
Stewart, Kevin	1	2023	Pacific County Sheriff’s Office	Complaint		2023	Pacific County Sheriff’s Office	Complaint
Story Jr., Chris	1	2022	Ridgefield PD	Agency Report	Administrative Closure	2022	Ridgefield PD	Agency Report	Administrative Closure
Strieck, Jerry	1	2023	Everett PD	Agency Report		2023	Everett PD	Agency Report
Swartz, Andrew	1	2023	Seattle PD	Agency Report		2023	Seattle PD	Agency Report
Szalda, Nathan	1	2022	Lynnwood PD	Agency Report		2022	Lynnwood PD	Agency Report
Tapia, Jessie	1	2023	Okanogan County Sheriff’s Office	Complaint		2023	Okanogan County Sheriff’s Office	Complaint
Taxter, Cliff	1	2022	Kalispel Tribal Public Safety	Agency Report		2022	Kalispel Tribal Public Safety	Agency Report
Tilton, Andrew	1	2021	King County Sheriff’s Office	Agency Report	Cleared	2021	King County Sheriff’s Office	Agency Report	Cleared
Trejo, Glen	1	2023	Granger PD	Complaint		2023	Granger PD	Complaint
Troyer, Edward	1	2022	Pierce County Sheriff’s Office	Complaint		2022	Pierce County Sheriff’s Office	Complaint
Turner, Kevin	1	2023	Ferndale PD	Complaint	Cleared	2023	Ferndale PD	Complaint	Cleared
Tyler, Seth	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Volk, Michel	1	2023	King County Sheriff’s Office	Agency Report		2023	King County Sheriff’s Office	Agency Report
Wagner, Dale	1	2022	Adams County Sheriff’s Office	Complaint		2022	Adams County Sheriff’s Office	Complaint
Wallin, Arthur	1	2022	Snohomish County Sheriff’s Office	Complaint	Cleared	2022	Snohomish County Sheriff’s Office	Complaint	Cleared
Walwark, Daniel	1	2022	Thurston County Sheriff’s Office	Agency Report		2022	Thurston County Sheriff’s Office	Agency Report
Watkins, Joshua	1	2023	Coulee Dam PD	Complaint		2023	Coulee Dam PD	Complaint
Watkins, Kelly	1	2021	Lincoln County Sheriff’s Office	Complaint	Cleared	2021	Lincoln County Sheriff’s Office	Complaint	Cleared
Waymire, David	1	2022	Skamania County Sheriff’s Office	Complaint	Cleared	2022	Skamania County Sheriff’s Office	Complaint	Cleared
Whales, Timothy	1	2023	WA State Patrol	Complaint	Cleared	2023	WA State Patrol	Complaint	Cleared
White, Scott	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Wier, Gerald	1	2023	Eastern WA University PD	Agency Report		2023	Eastern WA University PD	Agency Report
Wiley, Michael	1	2023	Lakewood PD	Complaint		2023	Lakewood PD	Complaint
Willey, Erin	1	2022	Lewis County Sheriff’s Office	Complaint		2022	Lewis County Sheriff’s Office	Complaint
Williams, Michael	1	2022	Moses Lake PD	Complaint		2022	Moses Lake PD	Complaint
Williams, Timosha	1	2022	Tukwila PD	Agency Report	Administrative Closure	2022	Tukwila PD	Agency Report	Administrative Closure
Wilson, Raymond	1	2022	University of Washington PD	Agency Report	Cleared	2022	University of Washington PD	Agency Report	Cleared
Winegar, Tyler W.	1	2023	Clark County Sheriff’s Office	Agency Report		2023	Clark County Sheriff’s Office	Agency Report
Wold, Zachery	1	2023	Everett PD	Complaint		2023	Everett PD	Complaint
Wright, Laura	1	2022	Okanogan County Sheriff’s Office	Complaint	Cleared	2022	Okanogan County Sheriff’s Office	Complaint	Cleared
Wyche, Christopher	1	2022	Bellevue PD	Complaint		2022	Bellevue PD	Complaint
Wylie, Philip	1	2022	Pierce County Sheriff’s Office	Agency Report		2022	Pierce County Sheriff’s Office	Agency Report
Yabe, Tom	1	2023	Steilacoom Department of Public Safety	Complaint		2023	Steilacoom Department of Public Safety	Complaint
Yoder, Aaron	1	2023	Vancouver PD	Agency Report		2023	Vancouver PD	Agency Report
Youmans, Steve	1	2022	Grays Harbor County Sheriff’s Office	Complaint	Cleared	2022	Grays Harbor County Sheriff’s Office	Complaint	Cleared
then format	1	2023	Skamania County Sheriff’s Office	Complaint		2023	Skamania County Sheriff’s Office	Complaint