Hi Adam,
My app can be found at https://spdcalldashboard.onrender.com. It’s deployed on render, I hope that’s not a dealbreaker. The dashboard condenses and visualizes information from 3 different datasets from the City of Seattle that are regularly updated (most are updated daily). Put simply the dashboard gives users access to the latest information on crime, police response times, and police use of force in the City of Seattle.
Concise information on the app:
End of TLDR
Full Background:
The public perception around policing in Seattle is generally categorized by distrust and disapproval. The SPD is considered to be both ineffective and over-reaching by most people I have spoken to who are residents. And while the City of Seattle maintains basic dashboards showing the counts of crimes, information on use of force, and some other resources most people do not have the time to do a rigorous and meaningful analysis of these dashboards.
My dashboard features: Citywide Crime Count, Overall Citywide Crime Rate / 100k Residents, Crime Counts by Category of Offense, a Choropleth/Point Map (with controls to switch between crime rates and raw counts), a Line Chart for Count of Offenses over time, Median Qualified Response time (with controls to filter for specific priority of calls), Count of Use of Force Incidents, Count of Officer Involved Shooting Incidents, and finally a table that displays neighborhoods ranked by response time, call volume, or crime volume (controlled by the user).
All figures (excluding the Use of Force and Officer Involved Shooting figures) can be controlled by the global controls at the top of the dashboard. The global controls feature an explicit date range selector, a crime type selector, crime subcategory selector, and a neighborhood selector. In addition to these options, users can also use the plotly figures themselves (the map and time series figures) to manipulate the global control state. The time series range selector is tied to the global controls date range, and neighborhoods in the map are tied to the global control’s neighborhood selector.
One interesting insight is the clear anomalous downturn in reported crimes. In the past 2 months the City of Seattle has faced an uptick in homicide, since July 21, 2026 there have been 9 reported homicides (up 125% from the preceding 2 months). This pattern coincided with the Bite of Seattle shooting which left 3 dead, 4 injured. In the fallout of the shooting the Seattle Police Department failed to inform the public about the situation for several hours and public backlash led to the resignation of the SPD Police Chief. Since this period there has been a stark decline in reported crimes in the City of Seattle, a 15.1% decrease that is unlike any seasonal effects seen in historical data. This pattern points to severe disfunction in the Seattle Police Department during a period of time where we have seen elevated risks to public safety.
If you’ve made it this far in the message thank you for reading.
Cheers,
Ben