10 years. 180 school shootings. 356 victims.

Since 2009, at least 177 of America’s schools experienced a shooting. These tragedies are as diverse as our nation, but the depth of trauma is hard to convey. There is no standard definition for what qualifies as a school shooting in the US. Nor is there a universally accepted database. So CNN built our own. We examined 10 years of shootings on K-12 campuses and found two sobering truths: School shootings are increasing, and no type of community is spared.


10 years of school shootings

 Killed        Injured
2009 - 5 killed, 14 injured
JAN. 8 William Penn High School (New Castle, DE) 
 JAN. 9 Dunbar Vocational Career Academy (Chicago, IL) 
 JAN. 23 Cahokia High School (Cahokia, IL) 
 FEB. 11 Zebulon Middle School (Zebulon, NC) 
 FEB. 17 Central High School (Detroit, MI) 
 MAR. 6 Westover High School (Fayetteville, NC) 
 MAY. 13 Chimborazo Elementary School (Richmond, VA) 
 JUN. 9 Leestown Middle School (Lexington, KY) 
 JUN. 24 Aplington-Parkersburg High School (Parkersburg, IA) 
 OCT. 8 Mattituck High School (Mattituck, NY) 
 OCT. 30 Wilson High School (Long Beach, CA) 
 DEC. 2 Brockton High School (Brockton, MA) 
 DEC. 11 Booker T. Washington High School(Shreveport, LA) 
2010 - 4 killed, 7 injured
JAN. 20 Livingston High School (Livingston, AL) 
 FEB. 5 Discovery Middle School (Madison, AL) 
 FEB. 10 Inskip Elementary School(Knoxville, TN) 
 FEB. 23 Deer Creek Middle School (Littleton, CO) 
 FEB. 26 Birney Elementary School (Tacoma, WA) 
 MAY. 18 South Gate High School (South Gate, CA) 
 OCT. 1 Alisal High School (Salinas, CA) 
 OCT. 8 Kelly Elementary School (Carlsbad, CA) 
2011 - 3 killed, 18 injured
JAN. 5 Millard South High School (Omaha, NE) 
 JAN. 18 Gardena High School (Gardena, CA) 
 FEB. 2 Louisiana Schnell Elementary School (Placerville, CA) 
 MAR. 25 Martinsville West Middle School (Martinsville, IN) 
 MAR. 31 Worthing High School(Houston, TX) 
 APR. 13 Sheeler Charter High School (Apopka, FL) 
 APR. 19 Ross Elementary School (Houston, TX) 
 MAY. 23Highlands Intermediate School (Pearl City, HI) 
 MAY. 27 Horizon Elementary School (Everett, WA) 
 AUG. 26 Chandler Park Academy(Harper Woods, MI) 
 OCT. 24 Cape Fear High School (Fayetteville, NC) 
 DEC. 9 Harwell Middle School (Edinburg, TX) 
2012 - 31 killed, 8 injured
JAN. 10 North Forest High School (Houston, TX) 
 FEB. 22 Armin Jahr Elementary (Bremerton, WA) 
 FEB. 27 Chardon High School(Chardon, OH) 
 MAR. 6 Episcopal School of Jacksonville (Jacksonville, FL) 
 MAY. 25 Mary Scroggs Elementary School (Chapel Hill, NC) 
 AUG. 27 Perry Hall High School (Baltimore, MD) 
 DEC. 14 Sandy Hook Elementary (Newtown, CT)
2013 - 6 killed, 11 injured
JAN. 10 Taft High School (Taft, CA) 
 JAN. 31 Price Middle School (Atlanta, GA) 
 FEB. 13 Hillside Elementary School (San Leandro, CA)
 MAY. 24 Redland Middle School (Homestead, FL) 
 JUN. 20 Alexander W. Dreyfoos School of the Arts (West Palm Beach, FL) 
 AUG. 23 North Panola High (Sardis, MS) 
 OCT. 4 Agape Christian Academy (Pine Hills, FL) 
 OCT. 21 Sparks Middle School (Sparks, NV)
 NOV. 3 Stephenson High School (Stone Mountain, GA) 
 DEC. 4 West Orange High School (Winter Garden, FL) 
 DEC. 13 Arapahoe High School (Centennial, CO) 
 DEC. 19 Edison High School (Fresno, CA) 
2014 - 12 killed, 16 injured
JAN. 9 Liberty Technology Magnet High School (Jackson, TN) 
 JAN. 14 Berrendo Middle School (Roswell, NM) 
 JAN. 17 Valley Charter High School (Philadelphia, PA) 
 JAN. 31 North High School (Des Moines, IA) 
 FEB. 10 Salisbury High School (Salisbury, NC) 
FEB. 20 Raytown Success Academy (Raytown, MO) 
 MAR. 7 Madison Parish High School (Tallulah, LA) 
 APR. 11 East English Village Preparatory Academy (Detroit, MI) 
 APR. 21 St. Mary Catholic School (Griffith, IN) 
 APR. 24 Paul Robeson High School (Chicago, IL) 
MAY. 3 Horizon Elementary School (Everett, WA) 
 MAY. 21 Clarke Street Elementary School (Milwaukee, WI) 
 JUN. 10 Reynolds High School (Troutdale, OR) 
 JUN. 23 Kelly High School (Benton, MO) 
 SEP. 9 Stellar Leadership Academy (Miami, FL) 
 SEP. 30 Fern Creek High School (Louisville, KY) 
 SEP. 30 Albemarle High School (Albermarle, NC) 
 OCT. 3 Langston Hughes High School (Fairburn, GA) 
 OCT. 24 Marysville-Pilchuck High School (Marysville, WA) 
 NOV. 20 Miami Carol City High School (Miami Gardens, FL) 
2015 - 3 killed, 22 injured
JAN. 15 Kinston High School (Kinston, NC) 
 JAN. 15 Wisconsin Lutheran High School (Milwaukee, WI) 
 JAN. 16 Williamson High School (Mobile, AL) 
 JAN. 16 Vanguard High School (Ocala, FL) 
 JAN. 27 Norris Middle School (Omaha, NE) 
 FEB. 4 Frederick High School (Frederick, MD) 
 FEB. 15 Tenaya Middle School (Merced, CA) 
 MAR. 5 Judson High School (Converse, TX) 
 MAY. 14 Duval County school bus (Jacksonville, FL) 
 JUL. 24 Elolf Elementary School (Converse, TX) 
 AUG. 25 W.S. Hornsby K-8 School (Augusta, GA) 
 SEP. 4 Dulaney High School (Lutherville Timonium, MD) 
 SEP. 11 Northside High School (Lafayette, LA) 
 SEP. 22 Central Elementary School (Statesville, NC) 
 SEP. 30 Harrisburg High School (Harrisburg, SD) 
 NOV. 6 Excel Southwest High School (Chicago, IL) 
 NOV. 11 Sulphur Rock STEM Magnet elementary school (Sulphur Rock, AR) 
2016 - 5 killed, 46 injured
JAN. 13 Harmony Grove High School (Camden, AR) 
 JAN. 22 Lawrence Central High School (Indianapolis, IN) 
 JAN. 29 Whites Creek High School (Whites Creek, TN) 
 FEB. 9 Muskegon Heights High School (Muskegon (Muskegon Heights), MI) 
 FEB. 12 Independence High School (Glendale, AZ) 
 FEB. 23 Faribault Middle School (Faribault, MN) 
 FEB. 29 Madison Jr/Sr High School (Middletown, OH) 
MAR. 15 Huffman High School (Birmingham, AL) 
 MAY. 4 East High School (Pueblo, CO) 
 MAY. 5 High Point High School (Beltsville, MD)
 MAY. 13 Southside High School (Greenville, SC) 
 MAY. 15 Augusta High School (Augusta, KS) 
 MAY. 21 Thompson K-8 International Academy (Southfield, MI) 
 MAY. 24 Technical High School (Saint Cloud, MN) 
 JUN. 30 Woodrow Wilson Junior High School (Hanford, CA) 
 JUN. 30 Sandusky High School (Sandusky, OH) 
 JUL. 21 Chaffey High School (Ontario, CA) 
 JUL. 25 Ava High School (Ava, MO) 
 AUG. 17 Wedgewood Middle School (Columbus, OH) 
 SEP. 2 McLain High School (Tulsa, OK) 
 SEP. 8 Alpine High School (Alpine, TX) 
 SEP. 8 Kearns High School (Salt Lake City (Kearns), UT) 
 SEP. 9 Smalls Athletic Field (York, PA) 
 SEP. 26 T.A. Wilson Academy (Jackson, MI) 
 SEP. 27 Elder High School (Cincinnati, OH) 
 SEP. 28 Townville Elementary (Townville, SC) 
 OCT. 11Vigor High School (Prichard, AL) 
 OCT. 13 Linden-McKinley STEM Academy (Columbus, OH) 
 OCT. 15 Benjamin E. Mays High School (Atlanta, GA) 
 OCT. 18 June Jordan School for Equity (San Francisco, CA) 
 OCT. 19 Mott Hall Charter School (Bronx, NY) 
OCT. 25 Union Middle School (Sandy, UT) 
 NOV. 7 Houston Can Academy (Houston, TX) 
 NOV. 9 Savannah High School (Savannah, GA) 
 DEC. 9 Bayless High School (Saint Louis, MO) 
2017 - 8 killed, 32 injured
JAN. 20 West Liberty-Salem High School (West Liberty, OH) 
 JAN. 25 Mark Twain Elementary School (Detroit, MI) 
 JAN. 27 Scullen Middle School (Naperville, IL) 
 JAN. 27 South Aiken High School (Aiken, SC) 
 JAN. 30 Palmer Pillans Middle School (Mobile, AL) 
MAR. 16 Lee High School (Montgomery, AL) 
 MAR. 21 King City High School (King City, CA) 
 MAR. 28 Linton Middle School (Pittsburgh (Penn Hills), PA) 
 APR. 10 North Park Elementary School (San Bernardino, CA) 
 APR. 15 Booker T. Washington High School (Tulsa, OK) 
 MAY. 15 Moss Bluff Elementary (Lake Charles (Moss Bluff), LA) 
 MAY. 26 McLain High School (Tulsa, OK) 
 JUN. 16 Warren Elementary School (Chicago, IL) 
 JUN. 22 JFK Stadium (Springfield, MO) 
 SEP. 8 North Little Rock High School (North Little Rock, AR)
 SEP. 13 Freeman High School (Rockford, WA) 
 SEP. 20 Mattoon High School (Mattoon, IL) 
 SEP. 20 Callaway High School(Jackson, MS) 
 SEP. 28 Southern Middle School (Lexington, KY) 
 OCT. 19 Rocky Mount High School (Rocky Mount, NC) 
 NOV. 3Pattengill Academy (Lansing, MI) 
 NOV. 9 Banneker High School (Atlanta, GA) 
 NOV. 14 Rancho Tehama Elementary School(Corning, CA) 
 DEC. 7 Aztec High School (Aztec, NM) 
 DEC. 8 Champaign Central High School (Champaign, IL) 
 DEC. 11 Roosevelt Elementary (Hanford, CA) 
 DEC. 19 Beecher High School (Mount Morris, MI) 
2018 - 37 killed, 68 injured
JAN. 22 Italy High School (Italy, TX) 
 JAN. 23 Marshall County High School (Benton, KY) 
 JAN. 31 Lincoln High School (Philadelphia, PA) 
 FEB. 1 Sal Castro Middle School (Los Angeles, CA) 
 FEB. 5 Oxon Hill High School (Oxon Hill, MD) 
 FEB. 9 Pearl-Cohn Entertainment Magnet High School (Nashville, TN) 
 FEB. 14 Marjory Stoneman Douglas High School (Parkland, FL)
 MAR. 7 Huffman High School (Birmingham, AL) 
 MAR. 20 Great Mills High School (Great Mills, MD)
 APR. 9 Gloversville Middle School (Gloversville, NY) 
 APR. 12 Raytown South Middle School (Raytown, MO) 
 APR. 20 Forest High School (Ocala, FL) 
 MAY. 11 Highland High School (Palmdale, CA) 
 MAY. 18 Mount Zion High School (Jonesboro, GA) 
 MAY. 18 Santa Fe High School (Santa Fe, TX) 
 MAY. 25 Noblesville West Middle School (Noblesville, IN) 
 JUN. 21 Skyline High School (Dallas, TX) 
 AUG. 3 Edgewood High School (Edgewood, MD) 
 AUG. 9 Lakeside Middle School (Millville, NJ) 
 AUG. 11Antioch High School (Antioch, TN) 
 AUG. 17 Palm Beach Central High School (Wellington, FL) 
 AUG. 24 Raines High School(Jacksonville, FL) 
 SEP. 11 Canyon Springs High School (Las Vegas, NV) 
 SEP. 27 Hebron High School (Carrollton, TX) 
 OCT. 3 Denali Elementary School (Anchorage, AK) 
 OCT. 7 Varina High School (Henrico, VA) 
 OCT. 29 Butler High School (Matthews, NC) 
 NOV. 20 Simonsdale Elementary School (Portsmouth, VA) 
 DEC. 11 Cawood Elementary School (Cawood, KY) 

Over the past decade, there were at least 180 shootings at K-12 schools across the US. They happened in big cities and in small towns, at homecoming games and during art classes, as students are leaving campus in the afternoon and during late-night arguments in school parking lots.

And they are happening more often.

CNN analyzed locations, time of day, type of school and student demographics to better understand how this trauma grips the country. While school shootings disproportionately affect urban schools and people of color, mass shootings are more likely to occur at white, suburban schools.

Given what has happened so far this year, the frequency shows no sign of relenting.

With little federal data on school shootings, it’s hard to pinpoint what’s behind the recent increase. But law enforcement experts believe one reason could be diminished coping skills, which can prompt people to lash out in violent ways.

“Today we have kids who are so isolated inside -- playing video games and glued to their (tablets) and everything else -- that they don’t learn those problem-solving skills,” says Mike Clumpner, a sworn police officer who specializes in active shooter training.

“We continually see poor coping skills and poor conflict resolution skills,” agrees former FBI agent Chris Cole, director of threat intervention services at the University of Wisconsin. “And as more of them (shootings) occur, it becomes sort of acceptable as ‘that’s a way I can settle my grievances.’”

Regardless of what’s behind this violence, it touches every aspect of school life.

From school drop-off on Monday morning to a Saturday night basketball game, shootings can happen any time. But more often, they happen on Fridays.

Experts suggest this could be due to tensions that build up over the course of a school week.

“If something has transpired to bring you to the breaking point of committing some type of homicidal action … you may not have had any type of decompression time during the school week,” says Clumpner. “And so that’s kind of five days stacked on top of each other.”

These shootings have tragic effects that ripple beyond the victims and their families. Nearly 200,000 students attended schools where one of these shootings occured.  At predominately black schools, students are more likely to experience a shooting after 4 p.m., typically during an after-school event.

And while black students make up about 15% of the more than 50 million students in the US, they account for about a third of the students who experienced a school shooting since 2009.

Meanwhile, shootings at predominately white schools often happen in the morning, as classes begin, or around dismissal time.

And those shootings tend to claim more victims.

SSome estimates for a school's race composition were made with an adjacent year's data. If a shooting occurred at a school that did not report its racial demographcis it is not shown. Students who are Hispanic and any other race (e.g., “white and Hispanic” or “black and Hispanic”) are included only in the Hispanic count. Not shown: Schools that had a plurality but not a majority of students from one race and Highlands Intermediate School, which has a mostly Asian and Pacific Islander student body.

CNN’s review found that shootings at predominately white schools have an average of three casualties. That's twice the average of the number of shooting victims at predominantly black and Hispanic schools.

Mostly white schools also have more mass shootings, like the ones at Marjory Stoneman Douglas High School and Sandy Hook Elementary, typically carried out by young white males while school is in session.

Experts say that while mass shootings are a concern, it's the day-to-day violence that impacts our schools more.

“Those mass shootings, the headline-grabbing ones, are really, really a small fraction of them," says Cole. "It’s more of the everyday violence, that unfortunately I think we’ve become a bit immune to, that produce the large numbers.”

And this violence reaches across America, touching every kind of community.

From the countryside to big cities, 114 people were killed and 242 were injured in shootings at K-12 schools from 2009 through 2018.

To prevent school shootings, experts agree we need comprehensive and reliable data. Without that research, we’re going blind into a “deadly future,” cautions Mark Rosenberg, who worked at the Centers for Disease Control and Prevention for 20 years and led its gun violence research.

“You need those interventions that reduce gun violence and save lives, but that also protect the rights of law-abiding gun owners,” says Rosenberg. “But we don’t know what works … and we’re not looking. That’s the disgrace.”

Editor's Note: CNN spent more than a year analyzing the rising toll of America’s school shootings. CNN will update its database throughout the school year, with 2019 numbers to come.


Download the data behind the project

CNN reviewed hundreds of reported shootings at K-12 schools from 2009 until 2018. To compile our dataset, we primarily relied on open-source databases, news reports, calls to police departments, information on school websites and 2009-2013 data provided by the Northwestern Institute on Complex Systems (NICO).

Since there is no single definition for what qualifies as a school shooting, our team set the following parameters: The shooting must involve at least one person being shot (not including the shooter); and the shooting must occur on school property, which includes but is not limited to, buildings, athletic fields, parking lots, stadiums and buses. Our count includes accidental discharge of a firearm as long as the first two parameters are met, except in instances where the sole shooter is law enforcement or a security officer. Our count also includes injuries sustained from BB guns, since the Consumer Product Safety Commission has identified them as potentially lethal.

To analyze the breakdown of schools, including student population and demographics, we relied on data from the US Department of Education and US Census.



Please note, comments must be approved before they are published