School shootings in the US compared with the rest of the world

The US has had 57 times as many school shootings as the other major industrialized nations combined

Updated 5:08 PM ET, Mon May 21, 2018
 (CNN)School shootings are a reality in America, an average of one a week just this year alone.

But how does the US compare with other countries in the world?

That's difficult to ascertain because very little research exists to quantify that.

For the purposes of this analysis, we followed the criteria below -

The scope: First, we looked at the G7 countries -- the countries with the largest advanced economies in the world.

The countries are Canada, the US, Japan, Germany, Italy, France, the UK.

The time period: From January 1, 2009 to May 21, 2018.

The definition: The parameters we followed in this count are -
  • Shooting must involve at least one person being shot (not including the shooter)
  • Shooting must occur on school grounds
  • We included gang violence, fights and domestic violence (but our count is NOT limited to those categories)
  • We included grades Kindergarten through college/university level as well as vocational schools
  • We included accidental discharge of a firearm as long as the first two parameters are met
The analysis: For US stats, CNN reviewed media reports and a variety of databases including those from the Gun Violence Archive and Northwestern Institute on Complex Systems. For international stats, we looked at local and national media reports.

The caveat: Reporting on non-fatal school shootings is not always available. There may be additional school shootings with injuries that did not make it into the newspaper or digital publications, and therefore aren't counted in databases that rely on media reports. This is true for shootings in the US and elsewhere.

What we found:
There have been at least 288 school shootings in the United States since January 1, 2009.
That's 57 times as many shootings as the other six G7 countries combined.

Broadening out the list

    Next, we wanted to broaden our list out to include some countries that were mentioned in a few of the viral posts that were going around this weekend.

    In some of the incidents, the casualty count is very high (the Peshawar siege; the Kenya attack). But when it comes to the frequency of attacks, the US still leads by a wide margin.



    Number of school shootings in the US compared with select countries

    When compared with countries that were mentioned in a few viral social media posts, the US still leads in frequency of school shootings since January 1, 2009.

    Country
    Shooting incidents
    United States 288
    Mexico 8
    South Africa 6
    India 5
    Pakistan 4
    Nigeria 4
    Afghanistan 3
    France 2
    Canada 2
    Brazil 2
    Greece 1
    China 1
    Kenya 1
    Azerbaijan 1
    Germany 1
    Russia 1
    Estonia 1
    Turkey 1
    Hungary 1
    Spain None identified
    Australia None identified
    Switzerland None identified
    Italy None identified
    Japan None identified
    Netherlands None identified
    Argentina None identified
    United Kingdom None identified