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

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.

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

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.

This dataset contains all gun death incidents between 2012 and 2014 in the US collected by the CDC.

Thanks to FiveThirtyEight for creating the GitHub repository.

Acknowlegement

Foto von Mitya Ivanov auf Unsplash

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.

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.

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.

Gun Violence Dataset Overview (Mass Shootings in 2024)

This dataset provides an in-depth look at mass shootings across the United States in 2024, up until October 20th, sourced from the Gun Violence Archive. It captures essential details such as incident ID, date, state, city, victims (killed and injured), and suspects involved. Additionally, geographical coordinates are included to allow for spatial analysis of gun violence trends.

Key Features of the Dataset

• Incident IDs: A unique identifier for each incident, categorized and grouped based on their range.
• Incident Date: Captures the time period over which the incidents occurred, broken down into monthly intervals.
• State and City/County: A breakdown of incidents across various states and cities, identifying regions with the most gun violence activity.
• Victims Killed and Injured: Provides a count of victims in each incident, allowing for the analysis of both fatal and non-fatal outcomes.
• Suspects Killed, Injured, and Arrested: Captures data related to suspects involved in the incidents, including their status post-incident (e.g., killed, injured, or arrested).
• Latitude and Longitude: Geographical coordinates for the locations of the incidents, enabling mapping and geospatial analysis.
• Coordinates Found: Indicates whether valid geographical coordinates were found for each incident.

This dataset is a comprehensive collection of gun violence incidents, offering insights into both the human toll and geographical spread of mass shootings in 2024. The goal of the analysis is to identify patterns, trends, and areas of concern that can inform public safety measures and policy interventions.

This study was undertaken to obtain information on the characteristics of gun ownership, gun-carrying practices, and weapons-related incidents in the United States -- specifically, gun use and other weapons used in self-defense against humans and animals. Data were gathered using a national random-digit-dial telephone survey. The respondents were comprised of 1,905 randomly-selected adults aged 18 and older living in the 50 United States. All interviews were completed between May 28 and July 2, 1996. The sample was designed to be a representative sample of households, not of individuals, so researchers did not interview more than one adult from each household. To start the interview, six qualifying questions were asked, dealing with (1) gun ownership, (2) gun-carrying practices, (3) gun display against the respondent, (4) gun use in self-defense against animals, (5) gun use in self-defense against people, and (6) other weapons used in self-defense. A "yes" response to a qualifying question led to a series of additional questions on the same topic as the qualifying question. Part 1, Survey Data, contains the coded data obtained during the interviews, and Part 2, Open-Ended-Verbatim Responses, consists of the answers to open-ended questions provided by the respondents. Information collected for Part 1 covers how many firearms were owned by household members, types of firearms owned (handguns, revolvers, pistols, fully automatic weapons, and assault weapons), whether the respondent personally owned a gun, reasons for owning a gun, type of gun carried, whether the gun was ever kept loaded, kept concealed, used for personal protection, or used for work, and whether the respondent had a permit to carry the gun. Additional questions focused on incidents in which a gun was displayed in a hostile manner against the respondent, including the number of times such an incident took place, the location of the event in which the gun was displayed against the respondent, whether the police were contacted, whether the individual displaying the gun was known to the respondent, whether the incident was a burglary, robbery, or other planned assault, and the number of shots fired during the incident. Variables concerning gun use by the respondent in self-defense against an animal include the number of times the respondent used a gun in this manner and whether the respondent was hunting at the time of the incident. Other variables in Part 1 deal with gun use in self-defense against people, such as the location of the event, if the other individual knew the respondent had a gun, the type of gun used, any injuries to the respondent or to the individual that required medical attention or hospitalization, whether the incident was reported to the police, whether there were any arrests, whether other weapons were used in self-defense, the type of other weapon used, location of the incident in which the other weapon was used, and whether the respondent was working as a police officer or security guard or was in the military at the time of the event. Demographic variables in Part 1 include the gender, race, age, household income, and type of community (city, suburb, or rural) in which the respondent lived. Open-ended questions asked during the interview comprise the variables in Part 2. Responses include descriptions of where the respondent was when he or she displayed a gun (in self-defense or otherwise), specific reasons why the respondent displayed a gun, how the other individual reacted when the respondent displayed the gun, how the individual knew the respondent had a gun, whether the police were contacted for specific self-defense events, and if not, why not.

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.

A mass shooting is defined as four or more people injured or killed, because of firearms, excluding the shooter. The data on mass shootings is from https://www.gunviolencearchive.org/ .The curated datasets are included here along with a research question and guiding questions.See the codebook for full details.

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.

Data tables relating to offences involving weapons as recorded by police and hospital episode statistics.

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!

Number, percentage and rate (per 100,000 population) of homicide victims, by racialized identity group (total, by racialized identity group; racialized identity group; South Asian; Chinese; Black; Filipino; Arab; Latin American; Southeast Asian; West Asian; Korean; Japanese; other racialized identity group; multiple racialized identity; racialized identity, but racialized identity group is unknown; rest of the population; unknown racialized identity group), gender (all genders; male; female; gender unknown) and region (Canada; Atlantic region; Quebec; Ontario; Prairies region; British Columbia; territories), 2019 to 2024.

Firearms background checks for the USA for 2012 (Jan-Nov) and since 1999.These statistics represent the number of firearm background checks initiated through the NICS. They do not represent the number of firearms sold. NICS is used by Federal Firearms Licensees (FFLs) to instantly determine whether a prospective buyer is eligible to buy firearms or explosives. Before ringing up the sale, cashiers call in a check to the FBI or to other designated agencies to ensure that each customer does not have a criminal record or isn't otherwise ineligible to make a purchase. More than 100 million such checks have been made in the last decade, leading to more than 700,000 denials. More information on NICS - http://www.fbi.gov/about-us/cjis/nics Some really useful informations such as the rate of checks per 1000 people. All data is provided by state. Downloaded from the Guardian Datablog - http://www.guardian.co.uk/news/datablog/2012/dec/17/how-many-guns-us and then joined to USA States data http://geocommons.com/overlays/21424. Gun data originally from FBI http://www.fbi.gov/about-us/cjis/nics. GIS vector data. This dataset was first accessioned in the EDINA ShareGeo Open repository on 2012-12-17 and migrated to Edinburgh DataShare on 2017-02-21.

Dataset

This dataset was created by Ifabiyi Mayowa

Contents

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

This nationally representative, anonymous, household telephone survey was conducted to explore the distribution of privately owned firearms in the United States, as well as firearm acquisition, disposal, and storage in households with guns. The study updates an earlier (1994) study by Cook and Ludwig that examined household firearm ownership in the United States (Cook P.J., Ludwig J. Guns in America: Results of a comprehensive national survey of firearms ownership and use. Washington DC: Police Foundation 1997.) Other domains of the survey included (1) past year firearm use both by respondents with firearms in their households and those without (e.g., "In the past 12 months, have you handled any gun"); (2) guns and youth (e.g., "In the last 12 months, have you ever asked another parent whether their home contains guns?"); (3) awareness of and opinions regarding state and federal firearm laws (e.g., "To the best of your knowledge, does your state have a law that holds adults liable for misuse of their guns by children or minors"; "Do you favor or oppose the sale of military style firearms?"); (4) depression and suicide (e.g., "If the Golden Gate Bridge had a barrier to prevent suicide, about how many of the 1,000 jumpers (who have committed suicide by jumping off the bridge since 1937) do you think would have found some other way to kill themselves?") and (5) aggressive driving (e.g., "In the past 12 months, have you made obscene or rude gestures at another motorist"). The survey also included extensive demographic information about the respondent and his or her family. The demographic information that was collected includes respondents' sex, age, race, education level, household income, criminal arrest history, armed forces membership status, type of residential area (e.g., urban or rural), and political philosophy.