The Washington Post has been compiling a database of every fatal shooting in the United States by a police officer in the line of duty since 2015. This is version 1 of the database.
Format
A data frame with 17 variables:
- id
- double a unique identifier for each victim 
- name
- character the name of the victim 
- date
- double the date of the fatal shooting in YYYY-MM-DD format 
- manner_of_death
- character manner of death 
- armed
- character indicates that the victim was armed with some sort of implement that a police officer believed could inflict harm 
- age
- double the age of the victim 
- gender
- character the gender of the victim. The Post identifies victims by the gender they identify with if reports indicate that it differs from their biological sex. 
- race
- character race of victim 
- city
- character the municipality where the fatal shooting took place. Note that in some cases this field may contain a county name if a more specific municipality is unavailable or unknown. 
- state
- character two-letter postal code abbreviation 
- signs_of_mental_illness
- logical News reports have indicated the victim had a history of mental health issues, expressed suicidal intentions or was experiencing mental distress at the time of the shooting. 
- threat_level
- character The threat_level column was used to flag incidents for the story by Amy Brittain in October 2015. http://www.washingtonpost.com/sf/investigative/2015/10/24/on-duty-under-fire/ As described in the story, the general criteria for the attack label was that there was the most direct and immediate threat to life. That would include incidents where officers or others were shot at, threatened with a gun, attacked with other weapons or physical force, etc. The attack category is meant to flag the highest level of threat. The other and undetermined categories represent all remaining cases. Other includes many incidents where officers or others faced significant threats. 
- flee
- character News reports have indicated the victim was moving away from officers 
- body_camera
- logical News reports have indicated an officer was wearing a body camera and it may have recorded some portion of the incident. 
- longitude
- double the longitue location of the shooting expressed as WGS84 coordinates, geocoded from addresses. The coordinates are rounded to 3 decimal places, meaning they have a precision of about 80-100 meters within the contiguous U.S. 
- latitude
- double the latitue location of the shooting expressed as WGS84 coordinates, geocoded from addresses. The coordinates are rounded to 3 decimal places, meaning they have a precision of about 80-100 meters within the contiguous U.S. 
- is_geocoding_exact
- logical reflects the accuracy of the coordinates. true means that the coordinates are for the location of the shooting (within approximately 100 meters), while false means that coordinates are for the centroid of a larger region, such as the city or county where the shooting happened 
