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.

  • By Jessica Davis
  • October 11, 2018

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

  • Electrified Latch Retraction Locks Key Benefits for Retrofits

    Building owners and facility managers increasingly rely on electrified hardware to enhance security while meeting accessibility standards. Among these technologies, electrified or motorized latch retraction locks are especially effective for retrofit projects where existing door and frame conditions complicate upgrades. Latch retraction capable locks combine security, accessibility and code compliance benefits, making them ideal for retrofitting fire-rated and non-rated openings in schools, healthcare facilities, commercial buildings and more. 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

  • Rethinking Campus Security From the Inside

    For decades, campus security strategies focused on keeping threats outside school walls. But since the tragedy at Columbine High School, data has shown that many attacks begin inside the building, often in classrooms and corridors. This shift has prompted schools to rethink security from the inside and place greater emphasis on interior elements such as classroom doors. This shift is evidenced by a new generation of classroom door systems engineered to delay inside intruders and an ASTM standard that raises the bar on how these systems must be designed to defend against attack. Read Now

  • 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

Most   Popular