I have been full of grief and sadness and some anger in the wake of yet more videos going viral in the past couple days showing black men being killed by police officers. I am not an expert on what it means to be a person of color in the United States or what is or isn’t wrong with policing today here, but it sure feels like something is deeply broken. I was reminded today that the Washington Post is compiling a database of every fatal shooting in the United States by a police officer in the line of duty since January 1, 2015 and has made that database publicly available on GitHub.

This is your regular reminder that we have the last 18 months of fatal police shooting data on Github: https://t.co/O6zP2JG7Ae

As I note there in the sidebar, these numbers are presented without any adjustment for demographics here in the U.S. If you look at the bar graph showing which states have the most fatal police shootings, those tend to be the highest population states. I have not yet done any analysis looking at, for example, which states have a disproportionate number of fatal police shootings or anything like that. Also, it isn’t entirely clear yet if there are issues with underreporting that might bias these results. Is a shooting of a certain kind less likely to be reported in this data set? But for all those caveats, it is a start, and certainly we want to know where we are to move forward to a more just and peaceful world.

The code for the flexdashboard is here at this Gist. I am happy to hear feedback or questions on it!