Updated dataset for the "Gun Deaths in America" project https://fivethirtyeight.com/features/gun-deaths/, documenting firearm usage fatalities.

The R code for processing the raw data is taken from https://github.com/fivethirtyeight/guns-data

I will be progressively adding the years before 2006, but the data format changed several times, so it is not as fast as I would like :-/ User guide for processing: https://www.cdc.gov/nchs/nvss/mortality_public_use_data.htm

The dataset is sourced and edited from
data.world

Description is given as below:

Centers for Disease Control and Prevention, National Center for Health Statistics. Multiple Cause of Death with U.S. - Mexico Border Regions 1999-2019 on CDC WONDER Online Database, released in 2020. Data are from the Multiple Cause of Death Files, 1999-2019, as compiled from data provided by the 57 vital statistics jurisdictions through the Vital Statistics Cooperative Program. U.S. - Mexico border counties has been demarcated as the 44 counties that are located within 100 kilometers (62 miles) defined under the 1983 La Paz Agreement. Accessed at http://wonder.cdc.gov/ucd-border.html on Nov 6, 2021 12:22:30 AM

Query Parameters: Title: Gun Deaths by County MCD - ICD-10 Codes: W32 (Handgun discharge); W33 (Rifle, shotgun and larger firearm discharge); W34 (Discharge from other and unspecified firearms); X72 (Intentional self-harm by handgun discharge); X73 (Intentional self-harm by rifle, shotgun and larger firearm discharge); X74 (Intentional self-harm by other and unspecified firearm discharge); X93 (Assault by handgun discharge); X94 (Assault by rifle, shotgun and larger firearm discharge); X95 (Assault by other and unspecified firearm discharge); Y22 (Handgun discharge, undetermined intent); Y23 (Rifle, shotgun and larger firearm discharge, undetermined intent); Y24 (Other and unspecified firearm discharge, undetermined intent); Y35.0 (Legal intervention involving firearm discharge)

Group By: Year; County Show Totals: True Show Zero Values: False Show Suppressed: False Standard Population: 2000 U.S. Std. Population Calculate Rates Per: 100,000 Rate Options: Default intercensal populations for years 2001-2009 (except Infant Age Groups)

picture sourced from peterplit

Number and percentage of homicide victims, by type of firearm used to commit the homicide (total firearms; handgun; rifle or shotgun; fully automatic firearm; sawed-off rifle or shotgun; firearm-like weapons; other firearms, type unknown), Canada, 1974 to 2018.

THIS DATASET WAS LAST UPDATED AT 7:11 AM EASTERN ON DEC. 1

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.

Mortality rate from firearms includes homicides, suicides, accidental deaths, deaths by law enforcement, and deaths for which intent was undetermined. Mortality rate is based on the location of residence and has been age-adjusted to the 2000 U.S. standard population. ICD 10 codes used to identify firearm deaths are W32-W34, X72-X74, X93-X95, Y22-Y24, Y35.0, and U01.4. Single-year data are only available for Los Angeles County overall, Service Planning Areas, Supervisorial Districts, City of Los Angeles overall, and City of Los Angeles Council Districts.Violence is a public health crisis in the US, with gun violence being a major driver. In the US, the age-adjusted homicide rate from firearms is more than 20 times higher than in the European Union or in Australia. Significant disparities by age, sex, and race and ethnicity exist, with young adults (ages 15-34 years), males, and Black individuals most disproportionately impacted. Firearm-related suicides disproportionately impact older, White men. Comprehensive prevention strategies should work to address underlying physical, social, economic, and structural conditions known to increase risk.For more information about the Community Health Profiles Data Initiative, please see the initiative homepage.

Description:

This comprehensive dataset offers an in-depth look at gun-related deaths in the United States from 2012 to 2014, as reported by the Centers for Disease Control and Prevention (CDC). It provides a rich source of information for public health research, policy development, and sociological studies, offering a nuanced understanding of the dynamics and demographics of gun-related fatalities.

Features:

• Year: The year when the death occurred, providing a temporal context.
• Month: The month of the incident, adding more granularity to the timeline.
• Intent: Categorizes the death by intent, such as suicide or homicide, essential for understanding the circumstances.
• Police: Indicates whether a police officer was involved in the death.
• Sex: The gender of the deceased, crucial for demographic analysis.
• Age: The age of the deceased, providing insights into age-related trends.
• Race: The race of the deceased, essential for understanding racial disparities.
• Place: The location of the incident, such as home or street, which can influence the context of the death.
• Education: Educational background of the deceased, offering a socio-economic dimension.

Use Case:

This dataset is highly valuable for tasks such as public health research, policy formulation in gun control, and sociological studies. It can be employed to analyze trends and patterns in gun-related deaths, assist in crafting informed laws and public safety measures, and provide a foundation for educational and awareness initiatives about gun violence and its impact on different demographic groups.

Note: - Entries are organized chronologically, capturing each recorded incident in detail. - The dataset is especially significant for examining year-on-year trends and demographic variances in gun-related fatalities, serving as a critical resource for comprehensive analysis and research.

In recent years, gun violence in the United States has become an alarmingly common occurrence. From 2016, there has been over ****** homicides by firearm in the U.S. each year and firearms have been found to make up the majority of murder weapons in the country by far, demonstrating increasing rates of gun violence occurring throughout the nation. As of 2025, Mississippi was the state with the highest gun violence rate per 100,000 residents in the United States, at **** percent, followed by Louisiana, at **** percent. In comparison, Massachusetts had a gun violence rate of *** percent, the lowest out of all the states. The importance of gun laws Gun laws in the United States vary from state to state, which has been found to affect the differing rates of gun violence throughout the country. Fewer people die by gun violence in states where gun safety laws have been passed, while gun violence rates remain high in states where gun usage is easily permitted and even encouraged. In addition, some states suffer from high rates of gun violence despite having strong gun safety laws due to gun trafficking, as traffickers can distribute firearms illegally past state lines. The right to bear arms Despite evidence from other countries demonstrating that strict gun control measures reduce rates of gun violence, the United States has remained reluctant to enact gun control laws. This can largely be attributed to the Second Amendment of the Constitution, which states that citizens have the right to bear arms. Consequently, gun control has become a highly partisan issue in the U.S., with ** percent of Democrats believing that it was more important to limit gun ownership while ** percent of Republicans felt that it was more important to protect the right of Americans to own guns.

Context

The Gun Violence Archive is an online archive of gun violence incidents collected from over 2,000 media, law enforcement, government and commercial sources daily in an effort to provide near-real time data about the results of gun violence. GVA in an independent data collection and research group with no affiliation with any advocacy organization.

Content

This dataset includes files that separate gun violence incidents by category, including deaths and injuries of children and teens, and a collection of mass shootings.

Inspiration

• What has been the trend of gun violence in the past few years?
• What states have the highest incidents per capita per year? How has this metric changed over time?
• Are officer involved shootings on the rise? Where are they most concentrated? Do they correlate with the rates of accidental deaths and mass shootings?

Acknowledgements

This dataset is owned by the Gun Violence Archive, and can be accessed in its original form here.

Context

This dataset includes information about gun-death in the US in the years 2012-2014.

Content

The data includes data regarding the victim's age, sex, race, education, intent, time (month and year) and place of death, and whether or not police was at the place of death.

Acknowledgements

I came across this thanks to FiveThirtyEight's Gun Deaths in America project. The data originated from the CDC, and can be found here.

Number of homicide victims, by method used to commit the homicide (total methods used; shooting; stabbing; beating; strangulation; fire (burns or suffocation); other methods used; methods used unknown), Canada, 1974 to 2024.

Context

Mass Shootings in the United States of America (1966-2017) The US has witnessed 398 mass shootings in last 50 years that resulted in 1,996 deaths and 2,488 injured. The latest and the worst mass shooting of October 2, 2017 killed 58 and injured 515 so far. The number of people injured in this attack is more than the number of people injured in all mass shootings of 2015 and 2016 combined. The average number of mass shootings per year is 7 for the last 50 years that would claim 39 lives and 48 injured per year.

Content

Geography: United States of America

Time period: 1966-2017

Unit of analysis: Mass Shooting Attack

Dataset: The dataset contains detailed information of 398 mass shootings in the United States of America that killed 1996 and injured 2488 people.

Variables: The dataset contains Serial No, Title, Location, Date, Summary, Fatalities, Injured, Total Victims, Mental Health Issue, Race, Gender, and Lat-Long information.

Acknowledgements

I’ve consulted several public datasets and web pages to compile this data. Some of the major data sources include Wikipedia, Mother Jones, Stanford, USA Today and other web sources.

Inspiration

With a broken heart, I like to call the attention of my fellow Kagglers to use Machine Learning and Data Sciences to help me explore these ideas:

• How many people got killed and injured per year?

• Visualize mass shootings on the U.S map

• Is there any correlation between shooter and his/her race, gender

• Any correlation with calendar dates? Do we have more deadly days, weeks or months on average

• What cities and states are more prone to such attacks

• Can you find and combine any other external datasets to enrich the analysis, for example, gun ownership by state

• Any other pattern you see that can help in prediction, crowd safety or in-depth analysis of the event

• How many shooters have some kind of mental health problem? Can we compare that shooter with general population with same condition

Mass Shootings Dataset Ver 3

This is the new Version of Mass Shootings Dataset. I've added eight new variables:

1. Incident Area (where the incident took place),
2. Open/Close Location (Inside a building or open space)
3. Target (possible target audience or company),
4. Cause (Terrorism, Hate Crime, Fun (for no obvious reason etc.)
5. Policeman Killed (how many on duty officers got killed)
6. Age (age of the shooter)
7. Employed (Y/N)
8. Employed at (Employer Name)

Age, Employed and Employed at (3 variables) contain shooter details

Mass Shootings Dataset Ver 4

Quite a few missing values have been added

Mass Shootings Dataset Ver 5

Three more recent mass shootings have been added including the Texas Church shooting of November 5, 2017

I hope it will help create more visualization and extract patterns.

Keep Coding!

This dataset includes the number and rate of firearm-related deaths among Virginia residents by patient health district over 5 combined years. Virginia Department of Health (VDH) health districts are assigned based on the residence of the patient at the time of death, not where the death occurred. Data include Virginia residents only, whether or not they died in Virginia. Data set includes deaths from 2018 through 2022.

The VDH Office of Vital Records tracks causes of death among Virginia residents using death certificates. Codes on the death certificate indicate underlying and contributing causes of death. Deaths are classified as firearm-related using the definition from the Centers for Disease Control and Prevention State Injury Indicators Report

BackgroundGun violence has shortened the average life expectancy of Americans, and better knowledge about the root causes of gun violence is crucial to its prevention. While some empirical evidence exists regarding the impacts of social and economic factors on violence and firearm homicide rates, to the author’s knowledge, there has yet to be a comprehensive and comparative lagged, multilevel investigation of major social determinants of health in relation to firearm homicides and mass shootings.Methods and findingsThis study used negative binomial regression models and geolocated gun homicide incident data from January 1, 2015, to December 31, 2015, to explore and compare the independent associations of key state-, county-, and neighborhood-level social determinants of health—social mobility, social capital, income inequality, racial and economic segregation, and social spending—with neighborhood firearm-related homicides and mass shootings in the United States, accounting for relevant state firearm laws and a variety of state, county, and neighborhood (census tract [CT]) characteristics. Latitude and longitude coordinates on firearm-related deaths were previously collected by the Gun Violence Archive, and then linked by the British newspaper The Guardian to CTs according to 2010 Census geographies. The study population consisted of all 74,134 CTs as defined for the 2010 Census in the 48 states of the contiguous US. The final sample spanned 70,579 CTs, containing an estimated 314,247,908 individuals, or 98% of the total US population in 2015. The analyses were based on 13,060 firearm-related deaths in 2015, with 11,244 non-mass shootings taking place in 8,673 CTs and 141 mass shootings occurring in 138 CTs. For area-level social determinants, lag periods of 3 to 17 years were examined based on existing theory, empirical evidence, and data availability. County-level institutional social capital (levels of trust in institutions), social mobility, income inequality, and public welfare spending exhibited robust relationships with CT-level gun homicide rates and the total numbers of combined non-mass and mass shooting homicide incidents and non-mass shooting homicide incidents alone. A 1–standard deviation (SD) increase in institutional social capital was linked to a 19% reduction in the homicide rate (incidence rate ratio [IRR] = 0.81, 95% CI 0.73–0.91, p < 0.001) and a 17% decrease in the number of firearm homicide incidents (IRR = 0.83, 95% CI 0.73–0.95, p = 0.01). Upward social mobility was related to a 25% reduction in the gun homicide rate (IRR = 0.75, 95% CI 0.66–0.86, p < 0.001) and a 24% decrease in the number of homicide incidents (IRR = 0.76, 95% CI 0.67–0.87, p < 0.001). Meanwhile, 1-SD increases in the neighborhood percentages of residents in poverty and males living alone were associated with 26%–27% and 12% higher homicide rates, respectively. Study limitations include possible residual confounding by factors at the individual/household level, and lack of disaggregation of gun homicide data by gender and race/ethnicity.ConclusionsThis study finds that the rich–poor gap, level of citizens’ trust in institutions, economic opportunity, and public welfare spending are all related to firearm homicide rates in the US. Further establishing the causal nature of these associations and modifying these social determinants may help to address the growing gun violence epidemic and reverse recent life expectancy declines among Americans.

Context

1 in 4 mass shooting victims were children and teens. In the years between 2009 and 2020, the horrific scenes of mass shootings have haunted the nation’s collective conscience.US states with weaker gun laws and higher gun ownership rates have higher rates of mass shootings. Mass shooting is defined as any incident in which four or more people are shot and killed, excluding the shooter. The number of mass shootings that plague this country is far too high, and the counts are just a small fraction of the lives left forever changed after the tragedy of a mass shooting. So here is the data for list of mass shootings in United States from 2018 - 2022.

Content

This dataset has five csv files of years 2018 - 2022. Each data contains following attributes - Date : The date on which the mass shooting incident happened - State : The state where the incident took place - Dead : total number of people died in mass shooting - Injured: total number of people who got injured in mass shooting- - Total : total of dead and injured people - Description : description/short report of the incident which may include information like gender/place etc. Data for 2022 Mass shootings will be updated every 15 days!

Acknowledgements

This data was scraped from https://en.wikipedia.org/wiki/List_of_mass_shootings_in_the_United_States using BeautifulSoup.

Image banner by Wall Street Journal

Inspiration

• EDA and Viz.
• Which state has highest number of mass shootings
• Contextual analysis of the description column
• Trend of mass shooting in past years
• Number of people killed/injured on an average in a month.

Check out my other works

• Datasets
• Notebooks

The Division of Criminal Justice Services (DCJS) collects crime reports from more than 500 New York State police and sheriffs’ departments. DCJS compiles these reports as New York’s official crime statistics and submits them to the FBI under the National Uniform Crime Reporting (UCR) Program. UCR uses standard offense definitions to count crime in localities across America regardless of variations in crime laws from state to state. In New York State, law enforcement agencies use the UCR system to report their monthly crime totals to DCJS. The UCR reporting system collects information on seven crimes classified as Index offenses which are most commonly used to gauge overall crime volume. These include the violent crimes of murder/non-negligent manslaughter, forcible rape, robbery, and aggravated assault; and the property crimes of burglary, larceny, and motor vehicle theft. Firearm counts are derived from taking the number of violent crimes which involve a firearm. Population data are provided every year by the FBI, based on US Census information. Police agencies may experience reporting problems that preclude accurate or complete reporting. The counts represent only crimes reported to the police but not total crimes that occurred. DCJS posts preliminary data in the spring and final data in the fall.

The data on mass shootings is from https://www.gunviolencearchive.org/ . This dataset on mass shootings for the period 2014-2023 was provided on Feb 19, 2024 by the Data Manager (Ms. Sharon Williams) at the Gun Violence Archive (https://www.gunviolencearchive.org/) on a data request. Minimal curation was done on this data – the date variable was split into year, month and day. See the codebook for full details.A mass shooting is defined as four or more people injured or killed, because of firearms, excluding the shooter.The curated datasets are included here along with a research question and guiding questions.For information of how this data is collected, go to: https://www.gunviolencearchive.org/explainerDefinition for mass shooting and mass murder from the above website is given verbatim below:Mass Shooting Methodology and Reasoning: Mass Shootings are, for the most part an American phenomenon. While they are generally grouped together as one type of incident they are several different types including public shootings, bar/club incidents, family annihilations, drive-by, workplace and those which defy description but with the established foundation definition being that they have a minimum of four victims shot, either injured or killed, not including any shooter who may also have been killed or injured in the incident. GVA also presents the count of Mass Murder which, like the FBI's definition is four or more victims, killed, not including the shooter. Mass Murder by gun is a subset of the Mass Shooting count.

The share of American households owning at least one firearm has remained relatively steady since 1972, hovering between ** percent and ** percent. In 2024, about ** percent of U.S. households had at least one gun in their possession. Additional information on firearms in the United States Firearms command a higher degree of cultural significance in the United States than any other country in the world. Since the inclusion of the right to bear arms in the Second Amendment to the Constitution of the United States, firearms have held symbolic power beyond their already obvious material power. Despite many Americans being proud gun-owners, a large movement exists within the country in opposition to the freedom afforded to those in possession of these potentially deadly weapons. Those opposed to current gun regulation have sourced their anger from the large number of deaths due to firearms in the country, as well as the high frequency of gun violence apparent in comparison to other developed countries. Furthermore, the United States has fallen victim to a number of mass shootings in the last two decades, most of which have raised questions over the ease at which a person can obtain a firearm. Although this movement holds a significant position in the public political discourse of the United States, meaningful change regarding the legislation dictating the ownership of firearms has not occurred. Critics have pointed to the influence possessed by the National Rifle Association through their lobbying of public officials. The National Rifle Association also lobbies for the interests of firearm manufacturing in the United States, which has continued to rise since a fall in the early 2000s.

This dataset includes the number and rate of firearm-related deaths among Virginia residents by patient health district and Sex over 5 combined years. Virginia Department of Health (VDH) health districts are assigned based on the residence of the patient at the time of death, not where the death occurred. Data include Virginia residents only, whether or not they died in Virginia. Data set includes deaths from 2018 through 2022.

The VDH Office of Vital Records tracks causes of death among Virginia residents using death certificates. Codes on the death certificate indicate underlying and contributing causes of death. Deaths are classified as firearm-related using the definition from the Centers for Disease Control and Prevention State Injury Indicators Report

Years of potential life lost under 75 (YPLL-75) and percent (%) change by firearm homicide and suicide deaths, 1981 to 2020 by 10-year interval periods.

Sadly, the trend of fatal police shootings in the United States seems to only be increasing, with a total 1,173 civilians having been shot, 248 of whom were Black, as of December 2024. In 2023, there were 1,164 fatal police shootings. Additionally, the rate of fatal police shootings among Black Americans was much higher than that for any other ethnicity, standing at 6.1 fatal shootings per million of the population per year between 2015 and 2024. Police brutality in the U.S. In recent years, particularly since the fatal shooting of Michael Brown in Ferguson, Missouri in 2014, police brutality has become a hot button issue in the United States. The number of homicides committed by police in the United States is often compared to those in countries such as England, where the number is significantly lower. Black Lives Matter The Black Lives Matter Movement, formed in 2013, has been a vocal part of the movement against police brutality in the U.S. by organizing “die-ins”, marches, and demonstrations in response to the killings of black men and women by police. While Black Lives Matter has become a controversial movement within the U.S., it has brought more attention to the number and frequency of police shootings of civilians.