Coming Soon! Summer Gun Violence Trends: 2015-2023

Thanks for bearing with my while I cleaned up this enormous trove of data!

Hi everyone, you’ve probably noticed radio silence from me over the past few months. Thanks for keeping your subscription active. I plan to make it worth your while! I now have summer firearm homicide and injury data for over 1300 cities from 2015-2023 to share. Cleaning up this data is laborious, but now that I have it organized I will begin reporting on trends including: where violence increased, decreased, or remained stable in 2023 compared to previous summers, firearm homicide and injury rates for each city, and the ratio of firearm fatalities to injuries, which sheds light on the prevalence of firearm violence beyond homicide rates alone, since ER doctors are getting extremely good at treating gunshot wounds.

I’ll be posting weekly with various deep dives. In the meantime, below are the cities that you can expect to learn more about in subsequent posts, starting tomorrow. For more about why I selected Memorial Day as the starting point for this data analysis see: “Memorial Day is a Peak Gun Violence Holiday,” for an explanation of my data source, validity, and methodology, see “Gun Violence Data and Methodology,” and for my case selection rationale, see “Why these 1300ish Cities?”

Here they are! Use the interactive Link. (Obviously I don’t expect anyone to scroll through 66 pages of city names, but you get the gist. My analysis includes all large cities with 50k or more residents, plus roughly 600 smaller cities. I’ll slice and dice this data up in various ways to provide the most comprehensive, fine-grained, up-to-date analysis of gun violence trends available anywhere in the upcoming weeks and months.