Database: U.S. school shootings since December 2012

There has been nearly one school shooting every week since the December 2012 massacre at Sandy Hook Elementary School in Newtown, Connecticut in which 20 children and six adults were fatally shot, with schools in more than 30 states experiencing some kind of firearm-related incident on campus over the past year and a half.

The Desk has compiled a list of 80 campus-related shootings since the Newtown massacre. The data is compiled from various sources, including local and national media reports as well as a list maintained by the advocacy website Everytown.org. The database is searchable and can be sorted by date, city state, number of casualties/fatalities and type of school involved. Click here for an explanation of listed events and terms used.

DateCityStateSchoolCasualtiesFatalitiesSchool TypeGunmenSources
2013-01-08Fort MyersFloridaApostolic Revival Center
Christian School
01Elementary SchoolUnknown[ 1 , 2 ]
2013-01-10TaftCaliforniaTaft Union
High School
10High SchoolBryan Oliver[ 1 ]
2013-01-15St. LouisMissouriStevens Institute of
Business & Arts
10College /
University
Sean Johnson[ 1, 2 ]
2013-01-15HazardKentuckyHazard Community and
Technical College
03College /
University
Dalton Stidham[ 1 ]
2013-01-16ChicagoIllinoisChicago State
University
01College /
University
Michael McNabb &
Stephen Gilbert
[ 1 , 2 ]
2013-01-22HoustonTexasLone Star College
North Harris Campus
30College /
University
Carlton Berry
(charges dismissed)
[ 1 , 2 ]
2013-01-31AtlantaGeorgiaPrice
Middle School
20Middle SchoolUnidentified[ 1 , 2 ]
2013-02-01AtlantaGeorgiaMorehouse
College
10College /
University
Amir Obafemi[ 1 , 2 ]
2013-02-07Fort PierceFloridaIndian River
State College
10College /
University
Nkosi McClain[ 1 , 2 ]
2013-02-13San LeandroCaliforniaHillside
Elementary School
01Elementary SchoolTaheer Randall[ 1 , 2 ]
2013-02-27AtlantaGeorgiaHenry W. Grady
High School
10High SchoolMorgan Tukes[ 1 ]
2013-03-18OrlandoFloridaUniversity of
Central Florida
01College /
University
James Seevakumaran[ 1 , 2 ]
2013-03-21SouthgateMichiganDavidson
Middle School
01Middle SchoolTyler Nichols[ 1 , 2 ]
2013-04-12ChristianburgVirginiaNew River
Community College
20College /
University
Neil Allen
MacInnis
[ 1 ]
2013-04-13Elizabeth CityNorth CarolinaElizabeth City
State University
10College /
University
Unknown[ 1 , 2 ]
2013-04-15GramblingLouisianaGrambling
State University
30College /
University
Unknown[ 1 , 2 ]
2013-04-16TempleTexasTemple
High School
01High SchoolSolomon Harris[ 1 ]
2013-04-16TuscaloosaAlabamaStillman
College
10College /
University
Elgerondo Williams[ 1 ]
2013-04-18BostonMassachusettsMassachusetts Institute
of Technology
01College /
University
Djohar Tsarnaev &
Tamerlan Tsarnaev
[ 1 , 2 , 3 ]
2013-04-29CincinnattiOhioLa Salle
High School
10High SchoolJoseph Poynter[ 1 , 2 ]
2013-05-14BirminghamAlabamaOssie Ware Mitchell
Middle School
00Middle SchoolCassandra Abrams[ 1 ]
2013-06-07Santa MonicaCaliforniaSanta Monica
College
46College /
University
John Zawahri[ 1 , 2 , 3 ,
4 , 5 , 6 ]
2013-06-19West Palm BeachFloridaAlexander W. Dreyfoos
School of the Arts
02High SchoolJavier Burgos[ 1 , 2 ]
2013-08-15ClarksvilleTennesseeNorthwest
High School
01High SchoolUnknown[ 1 , 2 ]
2013-08-20DecaturGeorgiaRonald E. McNair
Discovery Learning Academy
00Elementary SchoolMichael Brandon Hill[ 1 , 2 ]
2013-08-22MemphisTennesseeWestside
Elementary School
00Elementary SchoolUnidentified[ 1 ]
2013-08-23SardisMississippiNorth Panola
High School
21High SchoolQuintarius Mabry,
Darius McNeil
& John Haynes
[ 1 ]
2013-08-30Winston-SalemNorth CarolinaCarver
High School
10High SchoolChristopher Richardson[ 1 , 2 ]
2013-09-21SavannahGeorgiaSavannah State
University
01College /
University
Unknown[ 1 ]
2013-09-28GrayMaineNew Gloucester
High School
01High SchoolGaige McGue[ 1 ]
2013-10-04Pine HillsFloridaAgape
Christian Academy
20High SchoolUnidentified[ 1 , 2 ]
2013-10-15AustinTexasLanier
High School
01High SchoolAdrian Alvaresz[ 1 ]
2013-10-21SparksNevadaSparks
Middle School
22Middle SchoolJose Reyes[ 1 , 2 , 3 ]
2013-11-01AlgonaIowaAlgona
Middle School
01Middle SchoolShane Ballenger[ 1 , 2 ]
2013-11-02GreensboroNorth CarolinaNorth Carolina A&T
State University
10College /
University
Unknown[ 1 , 2 ]
2013-11-03LithoniaGeorgiaStephenson
High School
20High SchoolUnknown[ 1 ]
2013-11-13PittsburghPennsylvaniaBrashear
High School
30High SchoolAnjohnito Willet[ 1 , 2 ]
2013-11-21Rapid CitySouth DakotaSouth Dakota School of
Mines & Technology
01College /
University
Alberto Lemut[ 1 ]
2013-12-04Winter GardenFloridaWest Orange
High School
10High SchoolJ'Morian Bell[ 1 , 2 ]
2013-12-13CentennialColoradoArapahoe
High School
02High SchoolKarl Pierson[ 1 , 2 ]
2013-12-19FresnoCaliforniaEdison
High School
10High SchoolUnidentified[ 1 , 2 ]
2014-01-19JacksonTennesseeLiberty Technology
Magnet High School
10High SchoolUnidentified[ 1 ]
2014-01-13New HavenConnecticutHillhouse
High School
10High SchoolUnidentified[ 1 ]
2014-01-14RoswellNew MexicoBerrendo
Middle School
30Middle SchoolMason Campbell[ 1 , 2 , 3 ]
2014-01-15LancasterPennsylvaniaMartin Luther King
Elementary School
00Elementary SchoolUnknown[ 1 ]
2014-01-17PhiladelphiaPennsylvaniaDelaware Valley
Charter High
20High SchoolRaisheem Rochwell[ 1 , 2 ]
2014-01-20ChesterPennsylvaniaWidener
University
10College /
University
Unknown[ 1 ]
2014-01-21West LafayetteIndianaPurdue
University
01College /
University
Cody Cousins[ 1 ]
2014-01-24OrangeburgSouth CarolinaSouth Carolina
State University
01College /
University
Justin Singleton[ 1 , 2 ]
2014-01-25Los AngelesCaliforniaLos Angeles
Valley College
01College /
University
Raheen Taylor
& Derrick Wilson
[ 1 ]
2014-01-27CarbondaleIllinoisRebound
High School
10High SchoolOmari Tinsley[ 1 ]
2014-01-28NashvilleTennesseeTennessee State
University
10College /
University
Unknown[ 1 ]
2014-01-28HonoluluHawaiiRoosevelt
High School
10High SchoolUnidentified[ 1 , 2 ]
2014-01-30Palm BayFloridaEastern Florida
State College
10College /
University
Landrick Hamilton[ 1 ]
2014-01-31PhoenixArizonaCesar Chavez
High School
00High SchoolDeric McWilliams,
Daryl Fulbright,
Jontrell Wooten &
Jordan Norman
[ 1 ]
2014-01-31Des MoinesIowaNorth
High School
10High SchoolUnknown[ 1 ]
2014-02-07BendOregonBend
High School
01High SchoolZachary Leyes[ 1 , 2 ]
2014-02-10SalisburyNorth CarolinaSalisbury
High School
10High SchoolDaJuan Russell[ 1 ]
2014-02-11LyndhurstOhioBrush
High School
00High SchoolUnidentified[ 1 , 2 ]
2014-02-12JacksonTennesseeUnion
University
01College /
University
Charles Pittman[ 1 ]
2014-02-12Los AngelesCaliforniaUniversity of
Southern California
10College /
University
Unknown[ 1 ]
2014-02-20RaytownMissouriRaytown Success
Academy
01High SchoolFalanzo Davis[ 1 ]
2014-03-08OshkoshWisconsinUniversity of
Wisconsin at
Oshkosh
00College /
University
Unknown[ 1 , 2 ]
2014-03-25College ParkGeorgiaBenjamin Banneker
High School
00High SchoolUnidentified[ 1 ]
2014-03-30SavannahGeorgiaSavannah State
University
00College /
University
Unknown[ 1 ]
2014-04-03KentOhioKent State
University
10College /
University
Quavaugntay Tyler[ 1 ]
2014-04-07RoswellNew MexicoEastern New Mexico
University
01College /
University
Unidentified[ 1 ]
2014-04-09GreenvilleNorth CarolinaD. H. Conley
High School
00High SchoolUnknown[ 1 ]
2014-04-11DetroitMichiganEast English Village
Prep Academy
01High SchoolUnidentified[ 1 ]
2014-04-21GriffithIndianaSaint Mary
Catholic School
02Elementary SchoolRemanard Castro[ 1 ]
2014-04-21ProvoUtahProvo
High School
10High SchoolUnidentified[ 1 ]
2014-05-03EverettWashingtonEverett
Elementary
10Elementary SchoolUnknown[ 1 , 2 ]
2014-05-04AugustaGeorgiaPaine College 10College /
University
Unknown[ 1 ]
2014-05-05AugustaGeorgiaPaine College 10College /
University
Xavier Cooper[ 1 ]
2014-05-08GeorgetownKentuckyGeorgetown
College
10College /
University
Terrence Boyd[ 1 ]
2014-05-08LawrencevilleGeorgiaGeorgia
Gwinnett College
10College /
University
Unknown[ 1 ]
2014-05-21MilwaukeeWisconsinClark Street
School
10Elementary SchoolUnknown[ 1 ]
2014-06-05SeattleWashingtonSeattle Pacific
University
31College /
University
Aaron Ybarra[ 1 , 2 ]
2014-06-10TroutdaleOregonReynolds
High School
12High SchoolJared Padgett[ 1 , 2 ]
2014-10-24MarysvilleWashingtonMarysville Pilchuck
High School
15High SchoolJaylen Fryberg[ 1 , 2 , 3 ]
2014-11-20TallahasseeForidaFlorida State
University
31College /
University
Unidentified[ 1 , 2 ]

Explanation of terms used • “Casualties” refers to number of individuals who were injured in the incident, including suspected or confirmed shooters • “Fatalities” refers to the number of individuals fatally shot as a result of a campus shooting, including suspected or confirmed shooters • “Unknown” refers to a suspected or confirmed shooter who has not been identified or apprehended by police • “Unidentified” refers to a suspected or confirmed shooter who was in the custody of police, but whose identity was not released to the public.

Explanation of events listed • Incidents are listed in this database when a firearm is discharged on the campus of an college, university, elementary, middle or high school, including public, private and alternative schools • A “campus-related shooting” includes an event in which a firearm is discharged on the main grounds of a school, adjacent on-campus faculty, administrative or student buildings, gymnasiums, recreational facilities, dormitories or parking lots • Incidents include activities that would warrant a police response, such as a domestic disturbances, assaults, actual or attempted suicides, homicides/murders or accidental shootings • Incidents that involve the discharge of a firearm adjacent to or otherwise off school grounds, including incidents that occur on board school buses as they are en route to or from a campus, are not included.

This database was last updated on 27 October 2014.