A little earlier this month, I wrote something about being preoccupied by a small database project on Oakland’s homicides from last year. I should use the word “small” advisedly. Even though homicides represent a small slice of Oakland’s overall crime for 2012–the 500 or so shootings, the 2,200 other assaults, the 214 rapes, the 4,126 robberies, the 12,549 burglaries, the 7,020 stolen vehicles, the 6,006 larcenies–violent death casts a uniquely dark shadow across a community and robs it of any sense of security.
That’s the abstract level. On a more personal level, I wanted to gather as much information as I could on who had died, how they had died, and the aftermath of the deaths. That meant going from the Oakland Police Department’s often incomplete daily spreadsheets, which note times and locations of reported homicides, to media accounts that have the identities of victims. This is far from a novel project, unfortunately; the Oakland Tribune has been doing profiles on all the city’s homicide victims for the last several years (in fact, when I hit a dead end on finding names in several of these case, the Oakland police suggested we check the Trib’s year-end wrap-up, which had yet to be published). Back in the mid-90s, I edited a long series of stories at The San Francisco Examiner in which we tried to do a personal profile of every San Francisco homicide victim for a calendar year (we had reporters chasing after homicide investigators for details in more than 100 cases, I think; I was even less popular than usual among the reporters). Many news organizations have undertaken similar enterprises. The common thread in all of these projects, I think, is an attempt to humanize the people lost in the statistics.
As I wrote earlier, one pattern that emerged pretty early looking at all these cases was how relatively seldom anyone was arrested in the killing (at KQED News, we did a story last week that took a quick look at the most obvious reasons for the low arrest rate: lack of police resources, an underfunded crime lab, and, most important, the fact many people in the neighborhoods suffering the most from the plague of violence simply don’t trust the police).
For that story, we turned my homicide database into a map (below). You can click on the dots for the basic details of every death. Red dots show homicides that have not yet been solved. Green dots show cases that have been “cleared”–which means someone’s been arrested and charged. Yellow dots are cases ruled to be justifiable homicide. The single blue dot is for an officer-involved shooting also ruled to be justifiable homicide.
/p>
You did a lot of work, Dan. It would be good to know that it has some impact on someone, somewhere. I hope.
In some cases, not all, besides not trusting the police, when the witnesses are close friends or relatives, they want to reserve retribution for themselves. This comes to mind because we had at least one such case in the last couple years in my neck of the woods. I’m sure there must be more — most of which we would never know about.
There is also the stigma of the tattletale. It’s never “cool” to be a tattletale.
Hey, Marie and Allie: Thanks. I hadn’t thought of the retribution factor, but I’m sure that’s more common than we think.
Someone alerted me to a more comprehensive map the Washington Post did last year of homicides in D.C. and the outcome of cases: http://apps.washingtonpost.com/investigative/homicides/
It’s one thing to think of these as one-year phenomena. The truth is, the counter doesn’t really reset to zero on January 1. And when this goes on year after year after year–well, in D.C.’s case you’re talking about thousands of killings over the course of a decade.