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

THIS DATASET WAS LAST UPDATED AT 8:11 PM EASTERN ON SEPT. 10

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.

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 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.

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.

The dataset contains detailed information on mass shooting attacks that took place in the United States of America in 1966 - 2017.

Source: https://www.kaggle.com/zusmani/us-mass-shootings-last-50-years/version/4#Mass%20Shootings%20Dataset%20Ver%205.csv

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 shows the comparison between the amount of spending that was spent on higher education and corrections by each state in the United States from 1987 to 2007. This data was brought to our attention by the Pew Charitable Trusts in their report titled, "One in 100: Behind Bars in America 2008." The main emphasis of the article emphasizes the point that in 2007 1 in every 100 Americans were in prison. To note: Many states have not completed their data verification process. Final published figures may differ slightly. The District of Columbia is not included. D.C. prisoners were transferred to federal custody in 2001

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

This dataset was compiled from the ATF 2007 report on firearms trace data. The numbers provided represent the top 15 source states of firearms for each state. The number and percentage of out of state guns are also calculated.

This Dataset Tally's up the number of Olympic Gold medal winners per state. if an athlete has earned multiple medals, they only count as one. Its just the way it works out. anyways, this was pulled from Wikipedia.org, and is incomplete, these aren't total counts, these are just counts that i could find data for. If you'd like to try to do better, feel free. Source URL: http://en.wikipedia.org/wiki/Category:Olympic_gold_medalists_for_the_United_States

This dataset shows the amount of money that each state spent on their Corrections program both in percentage of the Overall amount of money spent in the State and as a total amount of money. This data was brought to our attention by the Pew Charitable Trusts in their report titled, One in 100: Behind Bars in America 2008. The main emphasis of the article emphasizes the point that in 2007 1 in every 100 Americans were in prison. To note: The District of Columbia is not included. D.C. prisoners were transferred to federal custody in 2001.

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 arrest data for 29 separate UCR offenses for each state for 2006". The table provides data for total arrests by class of crime. "The FBI collects these data through the Uniform Crime Reporting (UCR) Program". Estimated population was added for each state for 2006 that appeared on Table 5 of the data from 2006. Please see the Data Declaration for further information on the data set. Values of -1 represent no value.

This dataset displays the number of casualties and injuries on a state level. For each state in the United States statistics are given for both Operation Enduring Freedom, and Operation Iraqi Freedom. These figures are current as of April 26, 2008. These statistics are given for both hostile and non hostile instances. As well as figures for death and (WIA) - Wounded in action. H=Hostile; NH=Non-hostile * WIA (est) = Additional estimated WIA for the state based on reported losses (not all WIA records have home of record detail) * WIA (act) = Actual Wounded in Action (WIA) with home of record for the specified state

This dataset explores Early Care and Education Funding: Head Start Allocation and State-Funded Prekindergarten Participation. This data is state level and expresses the participation per state. Head Start and Early Head Start are comprehensive child development programs that serve children from birth to age 5, their families, and pregnant women. The overall goal of these programs is to increase the school readiness of young children in families earning low incomes. The Head Start program delivers comprehensive services including: education, health, nutrition, screening for developmental delays, and a variety of social services, if the family needs them. The program is designed to meet the social, emotional, physical and cognitive development of children. This data is from Latest Data: Fiscal Year 2004 (Head Start) and School Year 2002-2003 (State Funded Prekindergarten). This data is from National Child Care Information Center. Refer to NCCIC Child Care Database for detailed state information (http://nccic.org/IMS/Results.asp). Compiled by: National Association of Child Care Resources and Referral Agencies (http://www.naccrra.org/randd/head_start/expenditure.php)

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 displays the current-dollar GDP by US state. The period covered includes 2003-2006. Posted for each state and year is the state GDP in millions of dollars and the percent of US total GDP. This data was collected from the Bureau of Economic Analysis at their web page at: http://www.bea.gov/newsreleases/regional/gdp_state/gsp_newsrelease.htm Access Date: October 29, 2007

This dataset displays the locations of the top public high schools in the USA in 2005 according to Newsweek. The location of the high schools were determined by finding the lat/lon of the city and state of the high school. Public schools are ranked according to a ratio devised by Jay Mathews: the number of Advanced Placement, Intl. Baccalaureate and/or Cambridge tests taken by all students at a school in 2004 divided by the number of graduating seniors. All of the schools on the list have an index of at least 1.000; they are in the top 5 percent of public schools measured this way. If you have 2004 data showing that your school should be on this list, please contact Mathews at challenge@washpost.com. Note: Subs. Lunch % is the percentage of students receiving federally subsidized meals. E and E % stands for equity and excellence percentage: the portion of all graduating seniors at a school that had at least one passing grade on one AP or IB test.

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.

This data set represents the aggregate total occupational earnings by state. This includes the mean and median hourly wage, as well as the mean annual salary for each state. http://www.bls.gov/OES/