keyan pishdadian

Visualizing Seattle Police Department use-of-force data

10 13 2019

Using the Seattle Open Data Portal I collected and analyzed Seattle PD use-of-force data collected over the last 5 years. I wanted to answer:

  1. Are there geographic areas that have a disproportionate number of use-of-force incidents?
  2. Are there some police officers that are involved in more incidents than others?

Seattle, being progressive, has its own dashboard for visualizing this data, but the maps provided are more difficult to visually inspect and there is no analysis of per-officer aggregated data.


All the code and post-processed data are available in the GitHub repo, spd_force, where there are more technical details regarding data retrieval and processing.


The spatial visualization is interesting to inspect for those who are familiar with Seattle neighborhoods. Unsurprisingly there are more incidents in the busier downtown area and historically diverse and poorer South End, but ultimately without additional data layers it isn't easy to draw many conclusions.

When I grouped use-of-force incidents (after removing duplicates) by officer, I noticed that relatively few officers accounted for the majority of cases. Over a total of 10,290 incidents there were 1,144 officers involved, but the top 200 (~17.4%) most frequently involved officers were responsible for just over half (~50.14%) of all incidents.

When visualizing the number of incidents per officer we see that most officers are involved in just one incident, while a few officers are involved in 40+ incidents. One officer was even involved in 92 incidents! I did consider that officer tenure may be skewing this data, but I couldn't control for that because "years of service" information was not included.


There is a continued need to provide public access to this and other SPD statistics in order to ensure visibility into the police force and equity in treatment of citizens. While SPD has been progressive in its data policies, there is a need for increased openness regarding officer specific data. Unfortunately, the "officer id" information in this dataset is simply an internal identifier and not a badge number or other publicly available identifier. The disproportionate involvement of some officers must be investigated further.

This entry was tagged as spd seattle civic data d3 dataviz leaflet