Washington State Criminal Justice Training Commission Officer Certification Cases

As a condition of employment, all Washington peace and corrections officers are required to obtain certification. The commission may deny, suspend, or revoke the certification of an officer who has been found of misconduct outlined in RCW 43.101.105.

Reports of misconduct come to the attention of commission. The certification division reviews the case, conducts an investigation, and if the alleged misconduct meets the burden of proof, the commission shall provide the officer with written notice and a hearing.

Outcomes of all cases are presented here as mandated by RCW 43.101.400 (4). The dataset is searchable, machine readable and exportable. Supporting documents are viewable for each closed case.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"wa-gov/washington-state-criminal-justice-training-r5ki-dmfz\".\"washington_state_criminal_justice_training\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.