Empirical Databases of School Shootings

    My heart is with all affected by the Robb Elementary School massacre and the community of Uvalde. When will will get serious about the slaughter of America's youth? Please use this database to understand the issue. The database here is free to download and I give permission to anyone that is serious about reducing the school gun violence epidemic to utilize and use the database to come up with solutions.. If you are only discussing or calling for action on only one factor, like gun control to solve the problem you are not serious about solving the school gun violence epidemic and are part of the problem. How exactly does addressing a multi-facted issue with a singular-minded solution help? The same debate and calls for action for gun control that happens every time after a mass school shooting occurs has solved nothing and has only prolonged the suffering and death of American children. Until we get serious about addressing the school gun violence epidemic and start viewing the problem thru a multi-facted lense and have a plan of action the slaughter of America's youth will continue.

Over the last 13+ years, I have constructed an Excel spreadsheet with now 125 columns that documents 1,800+ on-campus shootings or at school-sponsored events at American schools and colleges including 101 active shooter (when using the definition of 3 or less injured and/or killed) and 20 mass school shootings (four or more killed). When I learned that there wasn’t a comprehensive empirical database of school shootings when I was a junior in high school during coverage of the Columbine massacre, the stunning fact sparked my interest to construct the badly-needed database one day. Around 11 years after my junior year in high school, in August of 2009, is when I started my work. To facilitate verification of the information in the database a huge bibliography of thousands of sources is also within the database which is by far the largest bibliography of any school shooting database project. I have recently added titles/headings for all the columns to make the database easier to read and to understand. I have also added new columns about the SRO/police response, whether the shooting occurred at a sporting event, or if a hostage situation happened and if the shooter/assailant(s) was a veteran.


To get a description of the database you can visit the American Thinker who published 'A Database to Prevent Gun Violence' on June 18th,2022 which showcases the database available here or click the link below. Here is an except from the article: "The database has over 30 duplicate columns that offer a chance to tally statistics from the prespective columns. Not only that,  but the duplicat columns offer context and detailed information about each column's subject. Columns offering context and specific details include the shooter's criminal history, how the shooter obtained the gun, if he was influenced by previous shooters, and whether he had a fascination with firearms and violence."


  The database below covers all classifications of shootings that have occurred on-campus (or at school-sponsored events) at America's schools and includes all levels and types of education institutions. If it is a learning environment in America it is included. The database includes shootings at K-12 schools, colleges and universities, community colleges, specialty and vocational schools, military schools, bible and theological schools, preschools and even daycare centers (very few). There are 101 active shooter events in the database and 20 mass school shootings (4 or more killed). These are the shootings that grab the headlines and are what is considered and thought of when you hear the term "school shooting."


The database includes fights (spontaneous and feuds) that resulted in a shooting, accidental shootings, suicides, gang-related disputes, police shootings, shootings that have nothing to do with the school other than the location, shootings arising from behavorial problems, drug-related diputes, terrorist acts, domestic disputes, stemming from rejection (or divorce), and many other types of shootings at America's schools. All the way to the right on the spreadsheet is a bibliography of an estimated 50,000 sources (links) which is, by far, the largest bibliography of any school shooting database project. 


  When comparing the databases at www.schoolshootingdatabase.com to that of gun control groups like Everytown's Gunfire on School Grounds data, the government's K-12 School Shooting Database, gunviolencearchive.org, or from other database campaigns, such as the Washington Post database, Education Week's School Shooting Tracker, the National School Safety and Security Services' School Associated Violent Deaths and School Shootings (1999-2010), the National School Safety Center's Report on School-Associated Violent Deaths (1992-93 through 2009-10 school year) and columbine-angels.com, you will notice that the database here is the only database of shootings at U.S. schools which gives context and detailed information about the shootings. Several of the databases mentioned above served to be a foundational starting point and great stepping stones to create the database here, especially columbine-angels.com.


      I've been through all other school shooting database projects mentioned above and they all conflate on-campus shooting incidents with shootings that happen off campus (sometimes more than a block away with one gun control advocacy group including a shooting occurring 13 blocks away from the school where the shooting supposedly happened in their database), BB gun incidents or add incidents where a gun was only brandished and not fired. If a gun was not fired and only brandished it shouldn't be classified as a shooting. Doing so is very misleading and is partly responsible for the confusion about the subject of school gun violence shootings.

I hope that this information makes a positive difference and adds to the growing field of knowledge and research about shootings occurring at American education institutions by providing accurate empirical data to confront, combat and understand the gun violence happening at U.S. schools. I am concerned about ONE THING! The kids and young adults affected by our ineptitude into understanding and solving the problem. We are talking about kids here and they deserve the best out of all of us. But that is not what they are getting considering the partisan nature of the gun debate to nowhere and the lackadaisical, neglectful and anti-science academic approach from many academic researchers and especially activists regarding documenting school gun violence (in all of its forms). Both sides in the gun debate are frankly self-serving and explotative and the same can be said activist groups and most gun violence researchers. The gun debate has been going on for several decades now with no end in sight as both sides profit off the violence due to fundraising, the selling T-shirts, the writing of books, etc... while the root causes of the shootings are ignored and the violence at American schools worsens.

          I have no issue if a book or whatever is fact-based and truthful but most books about school shootings or school gun violence are not. See the 2-14-1883 shooting entry in the database here at the Ponca Creek School House in Florence, NE (in the Notes column) to see where a supposed school shooting "experts" incorrectly claim that an accidental shooting at a school in 1883 was a mass school shooting, "killing three." The shooting involved a snowball fight and a very dumb (but not malicious) choice by Lem Harbuagh to brandish and point a needlegun to scare the kids who he was engaged in the snowball fight with. No one died that day, as the article  "Criminally Careless,"  which the authors themselves cite in their book, 'Mass Shootings: Media, Myths, and Realities,' clearly states but there were 3 students that were injured (with two having less serious wounds). The very detailed article 'Criminally Careless' gave the names of the injured students and even the path of the lone bullet fired that day. Harbaugh later apologized and felt awful about it, To my knowledge a correction has never been made by the authors to correct the error. 


Please excuse incomplete or missing data. I am the sole researcher of this project and the database is obviously very large. This work is NOT done in haste because I am very concerned about the information in the database being accurate so I take my time and to confirm the information is correct. I recently took a break from documenting school gun violence shooting incidents so 2020 thru the 2021-22 school year have very limited shootings incidents documented. I am still busy vetting shootings for the years 2020 thru 2021-22. l will have the database for those years updated soon.

It is important and vital that School Shooting Database is only used for the purpose to better understand or hopefully prevent shootings at schools. By downloading the database you agree to the following terms: 
-All information must be acknowledged and cited appropriately.
-Users agree not to sell, license, sub-license or otherwise distribute the database
-Users agree to not use School Shooting Database for commercial purposes.
Thank you for downloading School Shooting Database. Hopefully, this information assists in understanding all types of shootings occurring at American schools and colleges and makes a positive difference to prevent gun violence and other senseless violence.

If you do use School Shooting Database please give credit where credit is due. The sole and principal investigator/researcher of School Shooting Database is Eric Laurine

School Shooting Database is updated, modified and improved constantly as new information becomes available. Please contact me at ericlaurine5181@gmail.com or 740-317-2406 if a mistake is found, so it can be checked out and corrected.


I always appreciate critiques and criticisms of the database. You can contact me at ericlaurine5181@gmail.com or 740-317-2406    

School Shooting Chart:

1840-Present Day

(Last Updated 1-14-2021)

Year Number of All Types of Shootings at U.S. Schools (includes the active shooter & mass killings) Number Killed (all types)


Injured (all types)

Number of Mass School Shootings

(4 or more killed)

Number Killed (mass shootings) Number Injured (mass shootings)

Number of Active Shooter/Mass School Shootings

(2 or more injured and/or killed)

Number Killed (active/mass


Number Injured (active/mass


1840-1944 (104 years) 145 130 144 1 5 1 4 6 22+
1945-1989 (45 years) 337 208 451 4 32 65 29 60


1990-Present Day

(29 years)

1, 323 569 1,140 15 153 137 89 234 355
Totals 1,794 907 1,735 20 190 203 119 300 540

'Why We Must Keep School Resource Officers'

Article can be found at the American Thinker or by clicking the following link: 


Database of All Types of Shootings at America's Schools and Colleges                                              

Click Below to Access to View Comprehensive Database of All Types of American School Shootings (1840-present day) LAST UPDATED 6-19-2022
The database is an Excel spreadsheet with 125 columns that documents over 1,840 on-campus shootings, (or at school-sponsored events, like the prom) including 3 bombings, at U.S. schools and colleges in American history dating back to 1840. I have several tabs back at the bottom of the spreadsheet, including, mass shootings (4 or more killed), active shooter incidents (3 or less killed and/or injured), single-victim school shootings, and shootings at schools with no gunshot victims (but does include shootings where the shooter either commits or attempts suicide or hurts (or kills) themselves accidentally. These are the types of shootings I have updated so far. More types of shootings will be added soon. I am reformatting the database. Also, the shootings for the years 2020 thru 2002 are not
SSS-School Shooting Database update for [...]
xlsb File [7.0 MB]

You may come across a broken link in the bibliography. I do my best to remove and replace them. 

   Database of Active Shooter and Mass School Shootings at K-12 Schools (1956-2019) Comparing the Effect of Gun-Free Zones Before and After the Gun-Free Schools Zones Act was Passed in 1990 (this dataset will be updated soon)

73 Active Shooter Events at K-12 Schools from 1956-2019
This spreadsheet is of 73 active shooter and mass school shootings (9) at K-12 schools from 1956-2019. This database documents how active shooter events have nearly tripled and how student deaths have increased more than 9 times since gun-free zones legislation was passed in 1990.
SSS-School Shooting Database K-12 School[...]
xlsb File [431.4 KB]

Students' Deaths in Active Shooter Situations More than Nine Times as Likely Since Gun-Free Zones' Chart (chart and article below comes from the database above of 73 Active Shooter Events at K12 Schools from 1956-2019)

Victims Killed and Injured in Active Shooter Events at K-12 Schools Before and After Gun-Free Zones

Date Number of Shootings Students Killed Students Injured Educators Killed Educators Injured

Other School

Employees Killed

(includes SRO's)


Employees Injured (includes SRO's)

Other Victims Killed Other Victims Injured

Before Gun-Free Zones


(33 years)

11 19 76 8 13 4 3 4 13

After Gun-Free Zones


(29 years)

54 102 216 27 20 3 1 1 4



73 113 292 35 33 7 4 5 17

Spreadsheets of Off campus (or near school) Shootings, No Shots Fired (NSF) Incidents Involving Guns at Schools, & BB Gun Shootings

 Note:  Too often in other research projects BB gun school shootings, incidents where no shots were fired but involve firearms at schools, & shootings that happen just off campus or down the street from the school are included as if they are actual shootings that occurred at a school. The spreadsheets below were constructed to address the misrepresentations and claims of them being misconstrued as actual shootings at schools. Considering these shooting incidents as on-campus shootings effects the honesty and integrity of any research project and causes confusion on a topic that is already extremely complex and difficult to understand. I agree that they should be researched and studied but it should be done separately to ensure the quality of the data. How are to reduce America's school shooting epidemic and help and protect American students by using flawed research methods and biased data? If a shooting is identified as not happening on a school campus, using a bb gun, or where no gun was fired in this research project here (schoolshootingdatabase.com) it is looked into and researched further to confirm its validity. If a shooting in the master database above is identified and confirmed as a bb gun shooting, an incident that a firearm was NOT discharged (or only brandished), or occurred off campus it is first marked and then removed from the database after confirmation it is not a on-campus shooting or happened at a school-sponsored event, (or the firearm was a pellet gun) and then it is placed in the correct database.

NOTE: Due the large volume of shootings in the on-campus database above I no longer add entries in these databases but I do still keep records of off campus incidents, bb gun shootings, etc... when I come across them and if someone is interested in researching these incidents let me know and I wil gladly share them with you.

BB gun School Shootings
xlsb File [80.5 KB]
No Shots Fired Incidents Involving Firearms at America's schools
xlsb File [85.5 KB]
Off Campus (or near) Shootings by America's Schools
xlsb File [86.7 KB]

      Sandy Hook Never Forget artwork done by Mark Panzarino                                      

Print Print | Sitemap
© 2018 Eric Laurine All Rights Reserved ericlaurine5181@gmail.com