America's Epidemic of Shootings at U.S. Schools

Excel Spreadsheets with 56 Columns of Shootings at America's Schools

    Utilizing an Excel spreadsheet with 56 columns has made it possible to document over 1,600 on-campus shootings (or school-sponsored events, like the Prom or sporting events) at U.S. schools from 1840 to present day with over 1,350 of the shootings occurring since 1945. If a firearm was discharged on school property (on a bus or at school-sponsored events, like the prom) it is included i the database no matter the cause. This may seem too broad of a scope for some but the detailed and transparent nature of the spreadsheet makes it easy to determine the different forms of firearm violence at America's schools and the facts of each shooting. Using an Excel spreadsheet to document school shootings allows researchers to easily define the shootings based on the criteria they want to study simply by saving the spreadsheet under a different name and deleting the shootings that do not match the selected criteria. The data covers all types of shootings at America's schools. It's important to study all types of shootings at U.S. schools. when a school shooting happens, no matter why or where, there is a mass exodus to the school by parents and loved ones to check on the welfare of their childThe database is over 90% completed. If anybody knows of an on-campus shooting at America's schools that is not in the database please email me @ so I can add it.    All the information in the databases is verified by a extensive bibliography of thousands of articles, court documents, police records, official reports, books on the subject, etc.... This research project was started in 2009 with the intention to construct a credible and reliable database about shootings at America's schools. The fact that a quality empirical database was not already completed on shootings at U.S. schools is unacceptable and frankly embarrassing and shameful. Surely there has been enough time over the last 20 years to conduct open-minded research on school shootings, but obviously not the political will . With the dramatic increase in shootings at America's schools since the 1960's our kids deserve better that the shameless angling and profiteering from, both, gun control advocates, gun-rights supporters, those in the American media, school administrators, the FBI, or anyone else that would manipulate and/or neglect children's safety and use it as political leverage to get what they want. Facts from a credible database and the pursuit of understanding the root causes of the violence should drive the narrative, not self-serving special interests groups, pastisan politicians, and the mass media uninterested in scientific studies of problematic behavior. My hope is that this extensive resource be used by researchers, both, amateur and professional, as a foundation to conduct further research about school shootings. I welcome anybody to fact check the information in the dataset. 

Parameters of Research & How I Obtain My Data:

   - a shooting must occur on-campus or at a school sponsored event (like the prom)

   - shootings NEAR schools are not included. I also have constructed additional spreadsheets for off-campus (or near) school shootings, no shots fired incidents involving firearms that occur on school grounds, and bb gun school shootings that too often get mixed in with on-campus shootings in other school violence research projects. 

   - includes shootings on school buses but NOT at bus stops

   -mass shooting (or attempted mass) attacks are defined as 3 or more victims injured and or killed

   -includes all levels of education 

    -includes shootings inside & outside of the school

   -shootings where the shooter is off campus shooting at the school (are included (ex. Brenda Spencer-1979 shooting at Grover Cleveland Elementary School in San Diego, Ca that killed two and wounded 9)

    -includes shootings that happen after school hours 

    -includes suicides & accidental shootings


    Newspaper achives are a very effective tool to understand the epidemic of firearm violence that has invaded our education system. They are a treasure trove of facts and information on school shootings and so much more!

       - is by far the BEST SOURCE (must have paid subscription). I have recently employed a new data gathering tactic using . I type the year "1978" and the term "school shooting" into their search engine. Using this new tactic I have found nearly 50 shootings. I have only done seven years so far. I have been stunned of the amount of school shootings I have found! What a great site! Another great resource is It is a summary based list of school violence around the world. (must have paid subscription)

        -High Beam Research (paid subscription)




        -NY Times archive (paid subscription)

        -Police reports (free)

        - I DO NOT trust Wikipedia because it is very UNRELIEABLE and it is NOT USED!

        -more info coming soon

Database of All Types of On-Campus Shootings at U.S. Schools.

Updated 6-17-2018 Click Below to Access to View Comprehensive Database of All Types of American School Shootings (1840-present day) LAST UPDATED 6-17-2018
Excel spreadsheet with 56 columns that documents over 1,530 on-campus shootings (includes 3 bombings at U.S. schools in American history.
Mass (or attempted mass) Shooting Attacks are marked the color light green. Other Shootings with four or more injured and/or killed that are not considered "mass shootings" are marked the color dark green.
SSS-Binary website 6-17-2018.xlsb
xlsb File [780.8 KB]

For Threat Assessmemt Professionals

This Copy of the database is for Threat Assessment Professionals. It aligns better with another database from Psycho Social Dynamics

Database & Summary of Statistics for  90 Active Shooter/Mass Attacks (includes 3 bombings) -3 or more injured and/or killed (1880-2018) 

Excel Spreadsheet with 50 columns documenting the Highly Publicized Mass or Attempted Mass School Shootings
90 Mass (or Attempted) Mass School Shootings at America's Schools in U.S. History
259 People Killed
554 People Injured
SSS-Mass Shooting Attacks Updated 3-3-20[...]
xlsb File [167.3 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]

Database of Suicide Shootings at U.S Schools

133 Suicide School Shootings in American History (includes suicide attempts and suicide-by-cop incidents)
SSS-Suicide School Shootings 12-20-2017 [...]
xlsb File [158.3 KB]

Database of Accidental Shootings at U.S. Schools

Database of 136 Accidental Shootings at U.S. Schools (1867-present day) UPDATED 12-20-2017
149 Accidental Shootings at America's Schools in U.S. History
SSS-Accidental School Shootings 12-20-20[...]
xlsb File [166.2 KB]

Database of 98 Gang Related Shootings at U.S. Schools

98 Gang Related Shootings at U.S. Schools
SSS-Gang Related Updated 8-28-2017.xlsb
xlsb File [134.9 KB]

Shootings at Four Year Colleges & Universities

224 Shootings at Four Year Colleges
1840-2017: 224 Shootings- 189 Killed & 285 Injured
1840-1944: 10 Shootings- 5 Killed & 4 Injured
1945-2017: 214 Shootings- 184 Killed & 281 Injured
SSS-Four Year College School Shootings 1[...]
xlsb File [203.2 KB]

Shootings at Historically Black Colleges & Universities (HBCU's)

62 Shootings at Historically Black Colleges & Universities in American History (1945-2017)
From 1945-2017, 62 of 214 (29%) Shootings at Four Year Colleges are at HBCU's.
From 2009-2017, 50 of 104 (48%) Shootings at Four Year Colleges are at HBCU's.
SSS-HBCU Shootings 12-20-2017 BINARY.xls[...]
xlsb File [137.4 KB]

Shootings at High Schools

689 Shootings at High Schools 1945-2017
High School Shootings- 261 Killed: 621 Injured

Public School-647
Private School-24
SSS-High School Shootings 1-12-2018 (194[...]
xlsb File [328.4 KB]

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
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]

More Spreadsheets & Information Coming Soon. Please help raise awareness by sharing & discussing the databases above. I would like to hear from you! I am happy to answer any and all questions. Email me at or call 740-317-7893. Go out a Make a Positive Difference in Somebody's Life Today!

Artwork done by Mark Panzarino (picture above)

Print Print | Sitemap
© 2018 Eric Laurine; Brilliant, OH