Ted Mellnik and Steven Rich are database editor at The Washington Post.
Ted Mellnik and Steven Rich are database editor at The Washington Post.

314. Data reporting fuels Washington Post’s massive homicide project

Depending on who’s talking, the homicide rate in the U.S. is either skyrocketing in some cities or has been brought under control. Obviously both can’t be true – or can they?

As part of a larger project looking at homicide rates in 50 cities across the country, and the rate at which those cases are closed, Washington Post database editors Steven Rich and Ted Mellnik set out to collect information on murders to see what patterns they could find.

Mellnik now has 50 different paper maps of municipalities on the walls near his desk. Some are “speckled,” while others have clear areas indicating a high rate of homicide and low rates of closure, or cities where most cases are solved or closed in some way.

“Government records have a lot to do with journalism,” Mellnik said. “It used to be, the business was going through filing cabinets and looking for reports and forms, but now all that’s kept on computers and databases. If you’re going to do reporting these days, in some kind of depth, a lot of times instead of asking for paper records, we’re asking for data files.”

That also means it’s crucial to be able to analyze those files and find the real nuggets of truth that indicate patterns and outliers. But requesting data from 50 different departments often meant getting data sets that could not be easily compared: they first had to develop a system in which information could be uniformly categorized and analyzed.

With this particular project into homicide events and closure rates, they wanted to take a deeper look not just into the cities they were studying, but where within those cities rates were going up and down and whether cases were being closed.

“A couple of years ago, a few of us did a rudimentary version of this in Chicago,” Rich said. “We mapped points to figure out which neighborhoods (homicides) were in and figured out which neighborhoods had the lowest arrest rates. We did a story about the neighborhoods in Chicago where murder was effectively legal because they were not arresting anybody for it. Out of that, the question sprang out: what would this look like in other cities?”

With a clearance rate of 20 percent, meaning killers are seldom brought to justice in Chicago. In other cities, like Richmond, Virginia, the closure rate is much higher.

They also looked at the racial disparity among both homicides and case closures, finding irregularities in some cities where certain parts have high closure rates while others, not too far away, have lower rates. “It’s the same city, the same police force, the same budget, the same detective,” Mellnik said.

They’re hoping people who take the time to review the maps will be able to fill in the gaps, identifying whether there’s a certain point in a neighborhood with a high homicide rate and low closure rate where “people with weapons tend to gather,” information that might not come from the data provided by police departments, Mellnik said.

More Episodes

Kathleen Miles

482. Noema aims to help academics, policy makers think differently

Kathleen Miles is the executive editor of Noema, a cross-disciplinary academic  magazine from the Berggruen Institute. She talks with It’s All Journalism host Michael O’Connell about the importance of breaking out of the 24-hour news cycle to give writers the room to investigate deeper topics to help decision-makers approach policy discussions. 

Listen »

Subscribe To Our Newsletter

To get all the the latest news about our podcast, including guests and special events, fill out the form below to subscribe to our weekly email newsletter.