New Open Source Database to Track School Shootings

A new open source database at John Jay College of Criminal Justice, being developed in partnership with the University of Texas at Dallas and Michigan State University, will track shootings at K–12 schools and analyze the factors involved in such attacks. The project is supported by a grant from the National Institute of Justice's Comprehensive School Safety Initiative, a research effort focused on identifying the root causes of school violence as well as developing and evaluating strategies for boosting school safety.
 
The data collected will span "all publicly known school shootings that resulted in at least one injury from 1990 to Dec. 31, 2016," according to a news announcement. That includes cases that resulted in injuries but no deaths; shootings on school grounds linked to domestic violence or workplace violence; and suicides involving a firearm. The project's main goals:

  • To "document the nature of the problem and clarify the types of shooting incidents occurring in schools";
  • To "provide a comprehensive understanding of the perpetrators of school shootings and test causal factors to assess if mass and non-mass shootings are comparable"; and
  • To "compare fatal shooting incidents to events where only nonfatal injuries resulted to identify intervention points that could be used to reduce the harm caused by shootings."

"Researchers will use quantitative, multivariate analyses and qualitative case studies to document where and when school violence occurs," the announcement explained. "They will highlight key incident and perpetrator characteristics to help law enforcement and school administrators differentiate between the kinds of school shootings that exist to aid in the development of prevention strategies and policy initiatives at local and federal levels."

"At this crucial time in our national discussion on school violence, John Jay College is proud to be at the forefront of academic research that will support local, state and national efforts to tackle this problem with evidence-based policies and interventions," said Karol Mason, president of John Jay College of Criminal Justice, in a statement.

"The dearth of empirical data on school violence in the United States and the almost complete absence of quantitative data on perpetrators and incidents will be remedied by the production of this database and the analysis of data on the risk factors of school shootings," commented Joshua Freilich, a professor in the Department of Criminal Justice at John Jay College and principal investigator of the database project.

The researchers expect to complete the database in spring 2019. Future plans include the addition of data on "foiled plots" (planned shootings that were thwarted by police) as well as attacks on college campuses.

About the Author

Rhea Kelly is editor in chief for Campus Technology, THE Journal, and Spaces4Learning. She can be reached at [email protected].

Featured

  • horizontal stack of U.S. dollar bills breaking in half

    ED Abruptly Cancels ESSER Funding Extensions

    The Department of Education has moved to close the door on COVID relief funding for schools, declaring that "extending deadlines for COVID-related grants, which are in fact taxpayer funds, years after the COVID pandemic ended is not consistent with the Department’s priorities and thus not a worthwhile exercise of its discretion."

  • illustration of a human head with a glowing neural network in the brain, connected to tech icons on a cool blue-gray background

    Meta Introduces Stand-Alone AI App

    Meta Platforms has launched a stand-alone artificial intelligence app built on its proprietary Llama 4 model, intensifying the competitive race in generative AI alongside OpenAI, Google, Anthropic, and xAI.

  • The AI Show

    Register for Free to Attend the World's Greatest Show for All Things AI in EDU

    The AI Show @ ASU+GSV, held April 5–7, 2025, at the San Diego Convention Center, is a free event designed to help educators, students, and parents navigate AI's role in education. Featuring hands-on workshops, AI-powered networking, live demos from 125+ EdTech exhibitors, and keynote speakers like Colin Kaepernick and Stevie Van Zandt, the event offers practical insights into AI-driven teaching, learning, and career opportunities. Attendees will gain actionable strategies to integrate AI into classrooms while exploring innovations that promote equity, accessibility, and student success.

  • robot waving

    Copilot Updates Aim to Personalize AI

    Microsoft has introduced a range of updates to its Copilot platform, marking a new phase in its effort to deliver what it calls a "true AI companion" that adapts to individual users' needs, preferences and routines.