Students Create Database of Every K-12 School Shooting

Students Create Database of Every K-12 School Shooting

The database records any time a gun has gone off in or around a school campus, including incidents of suicide. The data is also searchable by 16 different categories.

A new database with information on every shooting at a school in the last 50 years is now available publicly online. The database was created by David Riedman, a former student at the Naval Post Graduate School while working on a project for the Center for Homeland Security.

Riedman and Desmond O’Neill created the database after trying to research school shootings and discovering how difficult it was to find detailed information.

"We wanted to record every single time that a gun has been brandished, fired or a bullet hits school property for any reason regardless of the time of day or day of the week,” Riedman said. "When we got online, and we were looking for information and looking through official databases. We couldn't find a single source that provided us really comprehensive information about school shootings."

The database records any time a gun has gone off in or around a school campus, including incidents of suicide. The data is also searchable by 16 different categories.

The website allows you to download the full data set collected by Riedman and O’Neill, which includes the date, school, location, number of killed and wounded, information on the shooter and a number of other details about each incident. There are also infographics that visualize the data, including Incidents by State, Number of Killed by Year and Incidents by Firearm Type.

“What we found is that the majority of school shootings happen during disputes that escalate into a shooting,” Riedman said.

Riedman believes the site would be useful for school administrators working on budgets and plans for school security.

"If you look at school shootings and you see that many of them occur outside of the school building that might make you think twice about fortifying classrooms, so we just want people to have an information source to weigh their decisions against,” Riedman said.

The database is located here.

About the Author

Jessica Davis is the Associate Content Editor for 1105 Media.

Featured

  • AI in Security: Advancing Campus Safety and Considerations for Implementing

    Artificial intelligence (AI) continues to capture attention across every sector, and the physical security industry is no exception. Once seen as experimental, AI-enabled analytics now underpin how organizations monitor environments, detect threats, and make decisions. What was once futuristic is now a practical necessity for safety professionals managing growing volumes of data, tighter resources, and increasing expectations for faster, more accurate responses. Read Now

  • How Cloud Security Solutions Are Transforming Campus Safety

    Campus administrators today face a challenging mandate: deliver stronger security across their facilities while working within tighter budget constraints. From school districts focused on student safety to hospitals protecting patients and staff, the question remains the same: how do you build security infrastructure that evolves with your needs without requiring massive capital investments? Read Now

  • 77% of Americans Support Gun Detection Technology in Schools, Workplaces, and Houses of Worship

    More than three-quarters of Americans (77.4%) believe gun detection technology should be deployed in schools, workplaces, and other public spaces, according to new survey data released recently. The national survey shows strong support for incorporating camera-based gun detection into existing video surveillance systems. Read Now

  • Eagle Eye Networks Launches AI Camera Gun Detection

    Eagle Eye Networks, a provider of cloud video surveillance, recently introduced Eagle Eye Gun Detection, a new layer of protection for schools and businesses that works with existing security cameras and infrastructure. Eagle Eye Networks is the first to build gun detection into its platform. Read Now