As of June 19, 116 school shooting incidents were recorded in K-12 schools in the United States in 2025. Within the provided time period, the greatest number of K-12 school shootings was recorded in 2023, at 350. The source defines a school shooting as every time a gun is brandished, fired, or a bullet hits school property for any reason, regardless of the number of victims (including zero), time, day or the week, or reason, including gang shootings, domestic violence, shootings at sports games and after hours school events, suicides, fights that escalate into shootings, and accidents.

THIS DATASET WAS LAST UPDATED AT 8:11 AM EASTERN ON SEPT. 22

OVERVIEW

2019 had the most mass killings since at least the 1970s, according to the Associated Press/USA TODAY/Northeastern University Mass Killings Database.

In all, there were 45 mass killings, defined as when four or more people are killed excluding the perpetrator. Of those, 33 were mass shootings . This summer was especially violent, with three high-profile public mass shootings occurring in the span of just four weeks, leaving 38 killed and 66 injured.

A total of 229 people died in mass killings in 2019.

The AP's analysis found that more than 50% of the incidents were family annihilations, which is similar to prior years. Although they are far less common, the 9 public mass shootings during the year were the most deadly type of mass murder, resulting in 73 people's deaths, not including the assailants.

One-third of the offenders died at the scene of the killing or soon after, half from suicides.

About this Dataset

The Associated Press/USA TODAY/Northeastern University Mass Killings database tracks all U.S. homicides since 2006 involving four or more people killed (not including the offender) over a short period of time (24 hours) regardless of weapon, location, victim-offender relationship or motive. The database includes information on these and other characteristics concerning the incidents, offenders, and victims.

The AP/USA TODAY/Northeastern database represents the most complete tracking of mass murders by the above definition currently available. Other efforts, such as the Gun Violence Archive or Everytown for Gun Safety may include events that do not meet our criteria, but a review of these sites and others indicates that this database contains every event that matches the definition, including some not tracked by other organizations.

This data will be updated periodically and can be used as an ongoing resource to help cover these events.

Using this Dataset

To get basic counts of incidents of mass killings and mass shootings by year nationwide, use these queries:

Mass killings by year

Mass shootings by year

To get these counts just for your state:

Filter killings by state

Definition of "mass murder"

Mass murder is defined as the intentional killing of four or more victims by any means within a 24-hour period, excluding the deaths of unborn children and the offender(s). The standard of four or more dead was initially set by the FBI.

This definition does not exclude cases based on method (e.g., shootings only), type or motivation (e.g., public only), victim-offender relationship (e.g., strangers only), or number of locations (e.g., one). The time frame of 24 hours was chosen to eliminate conflation with spree killers, who kill multiple victims in quick succession in different locations or incidents, and to satisfy the traditional requirement of occurring in a “single incident.”

Offenders who commit mass murder during a spree (before or after committing additional homicides) are included in the database, and all victims within seven days of the mass murder are included in the victim count. Negligent homicides related to driving under the influence or accidental fires are excluded due to the lack of offender intent. Only incidents occurring within the 50 states and Washington D.C. are considered.

Methodology

Project researchers first identified potential incidents using the Federal Bureau of Investigation’s Supplementary Homicide Reports (SHR). Homicide incidents in the SHR were flagged as potential mass murder cases if four or more victims were reported on the same record, and the type of death was murder or non-negligent manslaughter.

Cases were subsequently verified utilizing media accounts, court documents, academic journal articles, books, and local law enforcement records obtained through Freedom of Information Act (FOIA) requests. Each data point was corroborated by multiple sources, which were compiled into a single document to assess the quality of information.

In case(s) of contradiction among sources, official law enforcement or court records were used, when available, followed by the most recent media or academic source.

Case information was subsequently compared with every other known mass murder database to ensure reliability and validity. Incidents listed in the SHR that could not be independently verified were excluded from the database.

Project researchers also conducted extensive searches for incidents not reported in the SHR during the time period, utilizing internet search engines, Lexis-Nexis, and Newspapers.com. Search terms include: [number] dead, [number] killed, [number] slain, [number] murdered, [number] homicide, mass murder, mass shooting, massacre, rampage, family killing, familicide, and arson murder. Offender, victim, and location names were also directly searched when available.

This project started at USA TODAY in 2012.

Contacts

Contact AP Data Editor Justin Myers with questions, suggestions or comments about this dataset at jmyers@ap.org. The Northeastern University researcher working with AP and USA TODAY is Professor James Alan Fox, who can be reached at j.fox@northeastern.edu or 617-416-4400.

This dataset lists the number of well known school shootings by state. Some states have had more incidents than others. School shooting is a term popularized in American and Canadian media to describe gun violence at educational institutions, especially the mass murder or spree killing of people connected with an institution. A school shooting can be perpetrated by one or more students, expelled students, alumni, faculty members, or outsiders. Unlike acts of revenge against specific people, school shootings usually involve multiple intended or actual victims, often randomly targeted. Source: Wikipedia section on school shootings http://en.wikipedia.org/wiki/School_shootings#List_of_school_shootings

Context

To better understand the facts around school shootings a few years ago I went looking for data and found it difficult to come by - often embedded in other datasets or fragmented and unusable. I decided to create my own compilation based on a mashup of the Pah/Amaral/Hagan research on school shootings with the Wikipedia article from 1990 to present.

Content

pah_wikp file: A list of all school shooting incidents from 1990 to present.

Fields:

• Date: date of incident
• City: location of incident
• State: location of incident
• Area Type: urban or suburban (only in Pah dataset)
• School: C = college, HS = high school, MS = middle school, ES = elementary school, - = unknown
• Fatalities: # killed
• Wounded: # wounded (only in Wikipedia dataset)
• Dupe: whether this incident appears in both datasets. Note: only the "Pah" version of the incident is marked.
• Source: Pah or Wikp
• Desc: text description of incident (only in Wikipedia dataset)

cps file: US census data on school populations. Fields should be fairly self explanatory.

Acknowledgements

Thanks to the authors referenced above as well as the Wikipedia contributors!

Inspiration

• Why are school shootings (and death counts) increasing over time?
• How does the risk of being killed in a school shooting compare with other risks?
• Are some schools / cities / states at higher risk?
• Is there a correlation between countermeasures and a decrease in fatalities?
• What else correlates with school shooting risks? In addition to firearms and the people who wield them, is there any clear causality?

github version

Note: the master version of these datasets can be found at https://github.com/ecodan/school-shooting-data.git and is open for community contributions. I'll try to keep this data up-to-date with the github version on at least a monthly basis.

Context

From GitHub: "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."

Acknowledgements

This data was posted by CNN on GitHub. Read the full story. Image from StockSnap.io. Per GitHub, this data is licensed under the MIT license.

This study provides an evidence-based understanding on etiological issues related to school shootings and rampage shootings. It created a national, open-source database that includes all publicly known shootings that resulted in at least one injury that occurred on K-12 school grounds between 1990 and 2016. The investigators sought to better understand the nature of the problem and clarify the types of shooting incidents occurring in schools, provide information on the characteristics of school shooters, and compare fatal shooting incidents to events where only injuries resulted to identify intervention points that could be exploited to reduce the harm caused by shootings. To accomplish these objectives, the investigators used quantitative multivariate and qualitative case studies research methods to document where and when school violence occurs, and highlight key incident and perpetrator level characteristics to help law enforcement and school administrators differentiate between the kinds of school shootings that exist, to further policy responses that are appropriate for individuals and communities.

The Washington Post spent a year determining how many children have been affected by school shootings, beyond just those killed or injured. To do that, reporters attempted to identify every act of gunfire at a primary or secondary school during school hours since the Columbine High massacre on April 20, 1999. Using Nexis, news articles, open-source databases, law enforcement reports, information from school websites, and calls to schools and police departments, The Post reviewed more than 1,000 alleged incidents, but counted only those that happened on campuses immediately before, during or just after classes. Shootings at after-hours events, accidental discharges that caused no injuries to anyone other than the person handling the gun, and suicides that occurred privately or posed no threat to other children were excluded. Gunfire at colleges and universities, which affects young adults rather than kids, also was not counted. After finding more than 200 incidents of gun violence that met The Post’s criteria, reporters organized them in a database for analysis. Because the federal government does not track school shootings, it’s possible that the database does not contain every incident that would qualify. To calculate how many children were exposed to gunfire in each school shooting, The Post relied on enrollment figures and demographic information from the U.S. Education Department, including the Common Core of Data and the Private School Universe Survey. The analysis used attendance figures from the year of the shooting for the vast majority of the schools. Credits: Research and Reporting: John Woodrow Cox, Steven Rich and Allyson Chiu Production and Presentation: John Muyskens and Monica Ulmanu Per the terms of the Creative Commons license, CISER notes that: 1. the license for this dataset is attached as the files license.htm and license.pdf. A brief version of the Creative Commons license is also included but users should familiarize themselves with the full license before using. 2. the licensed material is located at https://github.com/washingtonpost/data-school-shootings 3. Several of the files have been modified from the format presented at the above url including creating pdf versions of the documentation files and adding SAS, Stata, and SPSS versions through the use of StatTransfer 13. 4. These adapted versions of the original files are also released through the same Creative Commons license as the original with the same license elements.

This dataset displays all the hazardous waste sites in the United States and it's Territories as of 5.08. The data comes from the Agency for Toxic Substances and Disease Registry(ATSDR). The dataset contains information about the site: Site ID Site Name CERCLIS # Address City State County Latitude Longitude Population Region # Congressional Districts Federal Facility National Priorities List Status Ownership Status Classification For more information go to the Agency for Toxic Substances and Disease Registry(ATSDR)website at http://www.atsdr.cdc.gov

This dataset was found online at the Association of Religious Data Archives (ARDA) website. http://www.thearda.com/ . This data set shows information on religous groups throughout the United States. All data was uploaded as a polypoint centroids per county in the United States, in shapefile format. This Data set shows the Total congregations, Total Adherents, and Rate of Adherence per 1000 population for All religions in the United States and for the Mainline Religions.

This dataset was created from the CDC's National Vital Statistics Reports Volume 56, Number 6. The dataset includes all data available from this report by state level and includes births by race and Hispanic origin, births to unmarried women, rates of cesarean delivery, and twin and multiple birth rates. The data are final for 2005. No value is represented by a -1. "Descriptive tabulations of data reported on the birth certificates of the 4.1 million births that occurred in 2005 are presented. Denominators for population-based rates are postcensal estimates derived from the U.S. 2000 census".

This dataset was retrieved from the U.S. Department of Justice Federal Bureau of Investigation Criminal Justice Information Services Division website on February 29, 2008. "This table provides the estimated number of offenses and the actual number of offenses reported in the Metropolitan Statistical Areas (MSA), cities outside metropolitan areas, and nonmetropolitan counties, and the rate (per 100,000 inhabitants) for each grouping, and the estimated population for each state" however to simplify the dataset, I only included the state total and the rate for each state. Data for Puerto Rico was not included. "The FBI collects these data through the Uniform Crime Reporting (UCR) Program". Please see the Data Declaration for further information on the data set. Values of -1 represent no value.

This dataset includes births, deaths and the ratio of births to deaths by metropolitan area for the years 2000-2006. The actual births and deaths for 2000 and estimates were taken from the U.S. Census Components of Population Change. Ratios were calculated based on that data.

This dataset displays the Real GDP by metropolitan area for the years 2001-2005. For each of the posted metropolitan areas Millions of chained dollars and the percentage change from the previous year is posted. This data was geocoded according to city and state locations. During the geocoding process 233/363 records from the original dataset were successfully geocoded. The reason for this is that during the process is that the dataset often groups cities together into one metropolitan area, which were unable to be properly coded. This data was collected from the Bureau of Economic analysis at their web page at: http://www.bea.gov/newsreleases/regional/gdp_metro/gdp_metro_newsrelease.htm Access Date: October 29, 2007

This dataset has been migrated from our Geocommons platform, and lacks a description from the original posting user. This is not a Fortiusone provided dataset. Please keep this in mind, and make of the dataset what you will. Thank you for visiting Finder!

This dataset was compiled from the ATF 2007 report on firearms trace data. The numbers provided represent numbers of firearms from each state (when they are in the top 15 source states) to other states. Other statistics are also calculated.

This is the monthly data for U.S. employment and unemployment by state including some numbers for Puerto Rico. This dataset was accessed on April 7th 2008. The data for February 2008 are preliminary. The data presented are seasonally adjusted although the unadjusted numbers are also available. Unavailable data are represented as -1. The dataset is taken from Tables 3 and 5 from the United States Department of Labor, Bureau of Labor Statistics. It includes the civilian labor force, the unemployed in numbers and percentages, and employment by industry. Data from table 3 "refer to place of residence. Data for Puerto Rico are derived from a monthly household survey similar to the Current Population Survey. Area definitions are based on Office of Management and Budget Bulletin No. 08-01, dated November 20, 2007, and are available at http://www.bls.gov/lau/lausmsa.htm. Estimates for the latest month are subject to revision the following month". Data from table 5 "are counts of jobs by place of work. Estimates are currently projected from 2007 benchmark levels. Estimates subsequent to the current benchmarks are provisional and will be revised when new information becomes available. Data reflect the conversion to the 2007 version of the North American Industry Classification System (NAICS) as the basis for the assignment and tabulation of economic data by industry, replacing NAICS 2002. For more details, see http://www.bls.gov/sae/saenaics07.htm.

All the data for this dataset is provided from CARMA: Data from CARMA (www.carma.org) This dataset provides information about Power Plant emissions in the USA. Power Plant emissions from all power plants in the United Staes were obtained by CARMA for the past (2000 Annual Report), the present (2007 data), and the future. CARMA determine data presented for the future to reflect planned plant construction, expansion, and retirement. The dataset provides the name, company, parent company, city, state, zip, county, metro area, lat/lon, and plant id for each individual power plant. The dataset reports for the three time periods: Intensity: Pounds of CO2 emitted per megawatt-hour of electricity produced. Energy: Annual megawatt-hours of electricity produced. Carbon: Annual carbon dioxide (CO2) emissions. The units are short or U.S. tons. Multiply by 0.907 to get metric tons. Carbon Monitoring for Action (CARMA) is a massive database containing information on the carbon emissions of over 50,000 power plants and 4,000 power companies worldwide. Power generation accounts for 40% of all carbon emissions in the United States and about one-quarter of global emissions. CARMA is the first global inventory of a major, sector of the economy. The objective of CARMA.org is to equip individuals with the information they need to forge a cleaner, low-carbon future. By providing complete information for both clean and dirty power producers, CARMA hopes to influence the opinions and decisions of consumers, investors, shareholders, managers, workers, activists, and policymakers. CARMA builds on experience with public information disclosure techniques that have proven successful in reducing traditional pollutants. Please see carma.org for more information http://carma.org/region/detail/202

The United States MSA Boundaries data set contains the boundaries for metropolitan statistical areas in the United States. The data set contains information on location, identification, and size. The database includes metropolitan boundaries within all 50 states, the District of Columbia, and Puerto Rico. The general concept of a metropolitan area (MA) is one of a large population nucleus, together with adjacent communities that have a high degree of economic and social integration with that nucleus. Some MAs are defined around two or more nuclei. Each MA must contain either a place with a minimum population of 50,000 or a U.S. Census Bureau-defined urbanized area and a total MA population of at least 100,000 (75,000 in New England). An MA contains one or more central counties. An MA also may include one or more outlying counties that have close economic and social relationships with the central county. An outlying county must have a specified level of commuting to the central counties and also must meet certain standards regarding metropolitan character, such as population density, urban population, and population growth. In New England, MAs consist of groupings of cities and towns rather than whole counties. The territory, population, and housing units in MAs are referred to as "metropolitan." The metropolitan category is subdivided into "inside central city" and "outside central city." The territory, population, and housing units located outside territory designated "metropolitan" are referred to as "non-metropolitan." The metropolitan and non-metropolitan classification cuts across the other hierarchies; for example, generally there are both urban and rural territory within both metropolitan and non-metropolitan areas.

This dataset shows airports in the United States, Puerto Rico and the U.S. Virgin Islands. The data were derived from an extract of The Public- Use Airports database of the National Transportation Atlas Databases-2001 (NTAD-2001), published by the Bureau of Transportation Statistics, Department of Transportation. This dataset was released in October 2001 and was found on-line at the National Atlas, www.nationalatlas.gov in Shape file format. This point data is intended for use within the United States, including Puerto Rico and the U.S. Virgin Islands. This data may be used for geographic display and analysis at the national level, and for large regional areas. Metadata: http://www.nationalatlas.gov/metadata/airprtx020.faq.html Online: www.nationalatlas.gov

This dataset displays the number of television receivers by country for the time period covering 1990 through 1997. Covered throughout this dataset is 150+ countries, This dataset was gathered from the United Nations Statistics Division. http://unstats.un.org/unsd/databases.htm Access Date: October 31, 2007