Empirical Databases of Shootings at U.S. Schools

Quote from the First Documented Shooting at a U.S. School

     "We had hoped that crime had never found a resting place within these calm retreats, 'whose threshold the distracting cares of the world, or it's beguiling pleasures, never cross'- it was but a sweet self delusion".

       -Quote from the first school shooting at the University of Virginia in Charlottesville, VA where Joseph Semmes shot and killed Professor John Davis during the exercise of "calathumping" (or shooting pistols wildly) on the 4th anniverary of the Student Revolt of 1836. ('Death of Professor Davis' -The Wetumpka Argus on December 2, 1840)

This dataset is of All Types of On-Campus Shootings at U.S. Schools. This is the master (or key) database that has all the different types of shootings at America's schools. It covers any shooting that has occurred on-campus or at school-sponsored events no matter what time of day.

Updated 10-14-2018 Click Below to Access to View Comprehensive Database of All Types of American School Shootings (1840-present day) LAST UPDATED 10-14-2018
Excel spreadsheet with 60 columns that documents over 1,650 on-campus shootings (includes 3 bombings) at U.S. schools in American history dating back to 1840. Active shooter/mass shooting attacks are marked the color orange. The are 123 active shooter/mass shootings since 1891 which have killed 348 victims and injured another 676.
SSS-School Shooting Database.xlsx
Microsoft Excel sheet [1.1 MB]

This section (below) has datasets that covers the different types of definitions that I have came across while doing this research that are used for mass shootings at U.S. schools

Mass School Shootings (4 or more killed)

Mass School Shootings (MSS-D1)
Mass School Shooting-Definition 1
This dataset covers 23 mass school shootings using the definition or four or more killed. Two of the entries are bombings.
SSS- Mass School Shootings (4 or more ki[...]
xlsb File [141.5 KB]

Mass School Shootings (3 or more killed)

Mass School Shootings (MSS-D2)
This datasets covers mass shooting attacks using three or more injured and/or killed. Two of the entries are bombings.
SSS- Mass School Shootings (3 or more ki[...]
xlsb File [147.5 KB]

Mass School Shootings (4 or More Injured and/or Killed)

Mass School Shootings (MSS-D3)
Mass School Shooting-Definition 3
This database covers mass shooting attacks using the definition of 4 or more injured and/or killed. Three entries are bombings.
SSS- Mass Shooting Attacks (4 or more in[...]
xlsb File [172.0 KB]

Mass School Shootings (3 or more injured and/or killed)

Mass School Shootings (MSS-D4)
This datasets covers mass shooting attacks when using the definition of three or more injured and/or killed). Three entries are bombings.
AAA-Mass Shooting Attacks (3 or more inj[...]
xlsb File [184.8 KB]

Active Shooter/Mass Shooting Attacks (2 or more injured and/or killed)

Active Shooter/Mass Shooting Attacks at Schools
This datasets covers active shooter and mass shooting attacks using the definition of 2 or more injured and/or killed
Active Shooter-Mass Shooting Attacks (2 [...]
xlsb File [214.0 KB]

Potential Active Shooter Events (PASE)

The spreadsheet below is shootings that I believe should be noted because there were warning signs and factors where the shooting could have became an active shooter event or mass shooting attack but did not occur because the shooter committed suicide before the attack was about to be carried out, students or others who knew about the potential shooting alerted school officials, the shooter was talked out of doing it by teachers and/or school administrators, or police intervention.

Potential Active Shooter Events (PASE)
This datasets covers what I term Potential Active Shooter Events because the potential and warning signs for an active shooter/mass attacks is there but the the attack did not occur because the shooter committed suicide before the attack was about to be carried out, students or others who knew about the potential shooting alerted school officials, the shooter was talked out of doing it by teachers and/or school administrators, or police intervention.
ASE- Potential Active Shooter Events 9-2[...]
xlsb File [142.8 KB]

Number of Shootings at America's School through American History

As you will see by exploring the spreadsheet and charts below in 'Number of Shootings at America's Schools Through American History' whatever definition one uses to define a mass school shooting the numbers go up at a very similar rate. I will be adding different types of shootings (accidental, gang related, etc..) at America's schools in the chart below as I get the work completed.

Number of Shootings at U.S Schools Per Year, Decade, & Century
This chart covers the number of school shootings since 1840. There are six sections. The first section covers all types of shootings at US schools. The second section is for Mass School Shootings (4 or more killed) . The third section is for Mass School shootings using the definition of 4 or more injured and/or killed. The fourth section covers the active shooter/mass shooting attacks combined (2 or more injured and/or killed). As you will see by looking at the charts in the enclosed document that no matter what definition one uses shootings at U.S schools go up at a very similar rate. I will be adding to this document as I get the work completed. 10-17-2018
AAA-School Shootings by Year, Decade, C[...]
xlsb File [55.5 KB]

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 firearmsat schools, & shootings that happen just off campus or down the street from the school are included as if they are actual school shootings. 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 (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 occurring off campus it is first marked (see above) and then removed from the database after confirmation it is not a on-campus shooting or at a school-sponsored event, (or the firearm was a pellet gun) and then it is placed in the correct database here to ensure the honesty and integrity of the data.

BB gun School Shootings
BB GUN SCHOOL SHOOTINGS ONLY 3 BINARY.xl[...]
xlsb File [80.5 KB]
No Shots Fired Incidents Involving Firearms at America's schools
NO SHOTS FIRED INCIDENTS INVOLVING GUNS [...]
xlsb File [85.5 KB]
Off Campus (or near) Shootings by America's Schools
OFF CAMPUS SHOOTINGS by Schools BINARY.[...]
xlsb File [86.7 KB]

Everything below is outdated and needs updated

Various Charts & Documents

5 Charts
Charts include: Public or Private High Schools, Public or Private Institutions (all types of shootings included), Shootings Per Type of Public Institution, Mass (or attempted mass) School shootings, & Shootings at Public High Schools Per Fluoridation Chemical Used or Natural Water
Chart- Various Charts.xlsx
Microsoft Excel sheet [27.0 KB]
Comparing African American School Shooters to Caucasian School Shooters
In this chart, you will see how silicofluorides (SiF's) of water fluoridation have an greater effect on African Americans. Fluorosilicic acid (H2SiF6) and sodium fluorosilicate (Na2siF6), jointly called slicofluorides, are two neurotoxic chemicals which have never been tested for safety. See work from Masters & Coplan below about increased uptake of lead from environmental sources.
CHART-Comparing African American Caucas[...]
Microsoft Word document [18.0 KB]
Silicofluorides Are Harmful Toxins (Masters & Coplan)
The neurotoxicity of slicofluorides effect on the violent crime rate
IMPORTANT-coplan-SILICOFLUORIDES-ARE-HAR[...]
Microsoft Word document [40.0 KB]
Powerpoint of Different Types of School Shooting Per Fluoridation Chemical Or Natural Water (needs updated)
CHART-Per Fluoride Chemical Used or Natu[...]
Microsoft Power Point presentation [168.3 KB]
Chart of School Shootings Per Year, Decade, & Century (needs updated)
Includes all types of school shootings
CHART-School Shootings Per Year Chart BI[...]
xlsb File [17.0 KB]
Chart of Mass (or attempted mass) School Shootings Per Race of Shooter (needs updated)
Chart-Mass (or attempted mass) School Sh[...]
Microsoft Excel sheet [11.9 KB]

Artwork done by Mark Panzarino (picture above)

Print Print | Sitemap
© 2018 All Rights Reserved Eric Laurine www.schoolshootingdatabase.com; ericlaurine5181@gmail.com Brilliant, OH