K-12 School Shooting
Database
David Riedman
Regional Healthcare Preparedness Symposium
Naval Postgraduate School
Center for Homeland Defense and Security
chds.us/ssdb – Follow @k12ssdb 1
chds.us/ssdb – Follow @k12ssdb 2
•What is a school shooting?
Research
•How many school
Questions shootings have occurred?
•Are school shootings a
growing trend?
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 3
Who is counting?
chds.us/ssdb – Follow @k12ssdb 4
•+1,400 incidents
K-12 School
•1970 – present
Shooting •Continuously updated
Database •Raw data and graphics
published on:
www.chds.us/ssdb
•Follow: @k12ssdb
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 5
Is this a school shooting?
chds.us/ssdb – Follow @k12ssdb
6
1. Two gunmen fire shots at the crowd
of students inside the school gym
during a pep rally
chds.us/ssdb – Follow @k12ssdb
7
2. Student shot while riding on the
school bus
chds.us/ssdb – Follow @k12ssdb
8
3. High school baseball coach shot in
the head on the school athletic field
during practice
chds.us/ssdb – Follow @k12ssdb
9
4. Students shot during lunch at the
fast food restaurant across the street
from the school.
Injured students run into the school
for assistance.
chds.us/ssdb – Follow @k12ssdb
10
5. Teacher shot in classroom after
school has dismissed by a parent
during a parent/teacher conference
chds.us/ssdb – Follow @k12ssdb
11
6. Student commits suicide with gun
on stage during graduation
chds.us/ssdb – Follow @k12ssdb
12
7. School Resource Officer discharges
a round in his office that travels
through the wall into a classroom and
injures a student.
chds.us/ssdb – Follow @k12ssdb
13
8. Two gang members fire shots at
each other across the street from the
school.
A round that misses the intended
target strikes a student on the school
playground.
chds.us/ssdb – Follow @k12ssdb
14
9. Father shoots ex-wife on school
property while she is dropping their
kids off at the school.
chds.us/ssdb – Follow @k12ssdb
15
10. Student pulls out gun and orders
classmates to get on the ground.
Student then holds gun to teacher’s
head and pulls the trigger, but the
safety is on.
chds.us/ssdb – Follow @k12ssdb
16
chds.us/ssdb – Follow @k12ssdb
17
chds.us/ssdb – Follow @k12ssdb
18
chds.us/ssdb – Follow @k12ssdb
19
•Not on School Property
Common •Gang-related
•Domestic Violence
Exclusion •Accidental
Criteria •Suicide
•Officer Involved
•Property Damage
•After School Hours
•BB/Pellet Guns
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 20
Anytime a gun was
brandished, fired, or a
Definition bullet hits school property
for any reason, regardless
of the number of victims,
time of day, or day of the
week.
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 21
chds.us/ssdb – Follow @k12ssdb
22
“How many times per year does a gun go
off in an American school? We should
know, but we don’t.”
- NPR Morning Edition (Sept. 2018)
chds.us/ssdb – Follow @k12ssdb
23
•What is a school shooting?
Research
•How many school
Questions shootings have occurred?
•Are school shootings a
growing trend?
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 24
chds.us/ssdb – Follow @k12ssdb 25
Healthcare Role in School
Shooting Response
chds.us/ssdb – Follow @k12ssdb 26
chds.us/ssdb
chds.us/ssdb –– Follow
Follow @k12ssdb
@k12ssdb 27
School
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 28
Emergency
Services
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 29
Students
&
Staff
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 30
Incident
Management
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 31
Healthcare
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 32
Media
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 33
Analyzing Data on School
Shooting
CHDS K-12 School Shooting Database
chds.us/ssdb – Follow @k12ssdb 34
1.Identify existing datasets (25
different sources)
2.Combine and cross reference
Process data
3.Internet searches
4.Newspaper archives
5.Official records
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 35
https://www.chds.us/ssdb/dataset/
chds.us/ssdb – Follow @k12ssdb 36
Brief History of School
Shootings
1970-Present
chds.us/ssdb – Follow @k12ssdb 37
February 1971
chds.us/ssdb – Follow @k12ssdb 38
September 1973
chds.us/ssdb – Follow @k12ssdb 39
1984
chds.us/ssdb – Follow @k12ssdb 40
December 1985
chds.us/ssdb – Follow @k12ssdb 41
1988
chds.us/ssdb – Follow @k12ssdb 42
April 1989
chds.us/ssdb – Follow @k12ssdb 43
September 1993
chds.us/ssdb – Follow @k12ssdb 44
2001
chds.us/ssdb – Follow @k12ssdb 45
March 2005
chds.us/ssdb – Follow @k12ssdb 46
October 2006
chds.us/ssdb – Follow @k12ssdb 47
October 2007
chds.us/ssdb – Follow @k12ssdb 48
February 2012
chds.us/ssdb – Follow @k12ssdb 49
May 2019
chds.us/ssdb – Follow @k12ssdb 50
Visualizing the Data
https://www.chds.us/ssdb/category/graphs/
http://arcg.is/0q98fX0
chds.us/ssdb – Follow @k12ssdb 51
chds.us/ssdb – Follow @k12ssdb 52
Incidents by Year
chds.us/ssdb – Follow @k12ssdb
53
Number Killed by Year
chds.us/ssdb – Follow @k12ssdb
54
FBI Definition: An
active shooter is an
individual actively
engaged in killing or
attempting to kill
people in a
populated area.
chds.us/ssdb – Follow @k12ssdb
55
Active Shooter Incidents per Year
chds.us/ssdb – Follow @k12ssdb
56
Active Shooter Injuries/Fatalities
chds.us/ssdb – Follow @k12ssdb
57
Assignment of Categories
● Gang-related ● Indiscriminate Shooting
● Domestic w/ Targeted ● Mental Health
Victim ● Anger Over Grade,
● Murder-Suicide Suspension, or Discipline
● Suicide ● Racial
● Attempted Suicide ● Self Defense
● Escalation of Dispute ● Illegal Drug Related
● Bullying ● Officer Involved Shooting
● Robbery ● Hostage Standoff
● Accidental
chds.us/ssdb – Follow @k12ssdb
Incidents by Category
chds.us/ssdb – Follow @k12ssdb
chds.us/ssdb – Follow @k12ssdb
60
Shooter’s Affiliation with School
chds.us/ssdb – Follow @k12ssdb
61
chds.us/ssdb – Follow @k12ssdb 62
Incidents by Age of Shooter
chds.us/ssdb – Follow @k12ssdb
63
Active Shooter by Age
chds.us/ssdb – Follow @k12ssdb 64
Incidents by Location
chds.us/ssdb – Follow @k12ssdb
65
Incidents by Location
(active shooter)
chds.us/ssdb – Follow @k12ssdb
66
Incidents by Location
2010-present
chds.us/ssdb – Follow @k12ssdb
67
Incidents by School Time Period
chds.us/ssdb – Follow @k12ssdb
68
How Incident Ended UNK Barricaded
Suicide
Subdued
Fled
Police Officer
Surrendered
chds.us/ssdb – Follow @k12ssdb
69
chds.us/ssdb – Follow @k12ssdb 70
Day of Week
chds.us/ssdb – Follow @k12ssdb
71
chds.us/ssdb – Follow @k12ssdb
72
Month of Year
chds.us/ssdb – Follow @k12ssdb
73
chds.us/ssdb – Follow @k12ssdb
74
Per Capita
Income
chds.us/ssdb – Follow @k12ssdb
75
Population
Density
chds.us/ssdb – Follow @k12ssdb
76
Diversity
Index
chds.us/ssdb – Follow @k12ssdb
77
chds.us/ssdb – Follow @k12ssdb 78
chds.us/ssdb – Follow @k12ssdb 79
chds.us/ssdb – Follow @k12ssdb 80
Website:
www.chds.us/ssdb
Contact Us
Twitter/Instagram:
@k12ssdb
Questions:
driedman@hawaii.edu
k12ssdb@chds.us
chds.us/ssdb
chds.us/ssdb––Follow
Follow@k12ssdb
@k12ssdb 81
