Delaware gun violence database

Delaware Online

Published Aug. 16, 2021

In 2017, Delaware Online/The News Journal began to log every shooting that is reported in the state, as there was and continues to be no public database of these acts of violence

database design

data visualization

React

Highlights

Caspio database to handle data entry, generate internal reports, and publish data to the public application
React app with queryable database, summary graphics and incident map

Awards

Best of Gannett

Note: Unfortunately, Gannett discontinued the system used to host this story, so I've archived a static version on my personal GitHub Pages.