Seattle Data Desk

About Seattle Data Desk

What this is

Seattle Data Desk is an independent, public-interest project built around the City of Seattle’s own open data. Each site under it covers one area of city government and shows, in plain language, how things have actually changed over time, with the underlying charts always visible alongside the numbers. Police Response Tracker, covering how SPD responds to calls for service since 2009, is live today; a daily court-cases tracker and a restaurant health-inspection grades site are both in progress and will join it here.

Seattle Data Desk was built by Seattle residents of more than 20 years who care about the city’s safety and quality of life and wanted the city’s own public data to be easier for residents to find and understand, rather than something buried in a government portal. We used AI to help build it. We encourage Seattle residents to use this data to form their own view of how city services have changed over time, and to bring that understanding into whatever conversations about city policy matter to them.

Data sources

Right now, every chart on Police Response Tracker is built from two public Seattle Open Data datasets: SPD Call Data, which records every call for service and every event an officer logs themselves, and SPD Crime Data, used where noted for comparison. Records are deduplicated by event number, and response time is measured from when a call was queued to when the first unit arrived on scene. Response times cover only events called in by the public and dispatched to an officer; events officers log themselves (“on view”) have no wait, so they are counted in call volume and outcomes but left out of every response-time figure. Each site’s own “Data last updated” date reflects when that site’s data was last pulled from its sources. As the court-cases and restaurant health-inspection sites go live, their source datasets will be added here too.

Why two readings

On Police Response Tracker, for the categories that get a full write-up, you’ll see two short essays side by side — “a conservative read” and “a liberal read.” Both are written from exactly the same chart data above them; neither invents numbers the other doesn’t use. The goal is to show that reasonable people looking at the same evidence can draw different conclusions about what it means and what should be done — not to tell you which conclusion is correct.

Limitations worth knowing

Police Response Tracker’s numbers come from dispatch data, not a complete record of crime or of every contact between a resident and police. A change in how a call gets classified, reported, or triaged can move these numbers independently of whatever is actually happening in the city. Categories with a small number of calls in a given year should be read with extra caution — a single unusual case can swing a percentage a lot. Where a category is mostly officer-initiated (the officer logs the event themselves, rather than responding to a call), few or no events have a response time, and the page says so.

Independence

Seattle Data Desk and every site under it are an independent project. None of them are affiliated with, operated by, or endorsed by the City of Seattle or any of its departments, or by any political party or candidate.