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

  • Securing Higher Education: Combating Enrollment Fraud and Empowering Student Financial Success

    Higher education institutions are facing a costly and growing crisis: enrollment fraud. Between 2020 and 2022, the cost[1] of acquiring a new student surged by up to 32%, straining already tight budgets. At the same time, “ghost students” using stolen identities to enroll fraudulently put institutions at even greater financial risk. Read Now

  • 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