Quote from the First Documented Shooting at a American Insitution of Learning
"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)
The dataset directly below is the master (or key) database that has all the different types of shootings at America's schools. It covers a wide variety of shootings that have occurred on-campus (or at school-sponsored events) at America's institutions of learning. I have recently updated this spreadsheet and it now includes links for sources of information. I am still in the process of working on adding all the sources. There are well over over 30,000 sources in the bibliography. You will need a subscription to newspapers.com to view most of the bibliography. You will also need subscriptions to newspaperarchive.com, questia.com, the NY Times TimesMachine archive, The Washington Post, Chicago Tribune, and many others to view some of the information. Please excuse the entries that are incomplete. I haven't got to them yet because the database is very large.
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.
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, or the shooter was talked out of doing it by teachers and/or school administrators, or police intervention.
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.
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 shooting 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 (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 (only brandished), or to have occurred off campus it is first marked (see above) 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.