New Reward: Get Our Data!
Back in June, we published a six-month review of homicides in 2012: Decreases in Gun, Domestic Violence, at Forefront of 6-month Homicide Decline.
The story, which included a map and summation of half a year's stats, took us about four hours to complete. We never had to file a FOIA. We just asked questions and our database started pouring out answers.
- How many murders have happened this year, compared to this time last year?
- Who were the youngest and oldest victims?
- How many cases have at least one suspect under arrest?
- What is the racial and gender makeup of victims (and suspects)?
- Where did most homicides happen?
These are questions every news organization should be able to answer. We collect this information as part of our reporting process and store it in our custom-built database. Now you can use the same data.
For every victim and suspect, we collect a name, age, race and gender. For victims, we also record a date of death, homicide method (shooting, stabbing, etc), place of death (hospital or at the scene) and incident location. For suspects, we record arrest dates and case status.
If you work for a news organization, think about how long it would take to gather all of this information.
We'll export the data at your request, so you can ask in September (when this campaign ends) or in January (if you want two calendar years) or any time later.