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

  • How Composable Security Technologies Fortify Campus Safety

    Campus security teams have faced myriad risks threatening the safety and well-being of students and faculty this semester. Leaders have made tough tradeoffs about where to focus and how to channel limited resources to best protect their communities — but they now have a much-needed lift to their toolkit. Read Now

  • How Emerging Technologies are Transforming the School Security Landscape

    Students can't focus on learning when they're worried about their safety. As education systems nationwide face evolving security challenges with limited resources, a new generation of integrated technology solutions is helping schools create safer environments while maximizing staff efficiency. Read Now

  • How to Harness ALPR for Greater Security Efficiency and Collaboration

    Within higher education campus environments, the demand for greater security, efficiency, and resources is ever-present. Many higher education teams are adopting advanced technologies to secure their campus, streamline operations, and continue to best serve their students and faculty. Automatic license plate recognition (ALPR) technology stands out for its ability to meet a wide range of campus objectives. Read Now

  • Using Emerging Technologies to Address Healthcare Staffing, Workplace Violence Issues

    The healthcare industry consistently adopts new technology to address challenges across all of its sectors. Many of the emerging technologies that are available today are being applied to optimize workflow. To enhance their operational efficiency, hospitals and other healthcare providers typically embrace emergent technologies to streamline tasks in patient care, administration, and, of course, security. Read Now