I downloaded their entire database yesterday. It has so much info and details. Everything you ask to be considering factors is there in this goldmine database. I downloaded it into an excel spreadsheet. It goes all the way back to 2013. I’m a little rusty, a lot rusty lol. I’d love to put it on a shared Google Drive file to see what kind of data we sleuthers can dig out but I don’t think Drive is an allowable link.
Filterable identifiers in database:
Victim's name
Victim's age
Victim's gender
Victim's race
URL of image of victim
Date of Incident (month/day/year)
Street Address of Incident
City
State
Zipcode
County
Agency responsible for death
ORI Agency Identifier (if available)
Cause of death
A brief description of the circumstances surrounding the death
Official disposition of death (justified or other)
Criminal Charges?
Link to news article or photo of official document
Symptoms of mental illness?
Armed/Unarmed Status
Alleged Weapon (Source: WaPo and Review of Cases Not Included in WaPo Database)
Alleged Threat Level (Source: WaPo)
Fleeing (Source: WaPo)
Body Camera (Source: WaPo)
WaPo ID (If included in WaPo database)
Off-Duty Killing?
Geography (via Trulia methodology based on zipcode population density:
http://jedkolko.com/wp-content/uploads/2015/05/full-ZCTA-urban-suburban-rural-classification.xlsx )
MPV ID
Fatal Encounters ID
Encounter Type
Initial Reported Reason for Encounter
Names of Officers Involved
Race of Officers Involved
Known Past Shootings of Officer(s)
Call for Service?