Site Link for SDA Analysis: Shooting Incidents in Educational Settings
Site Link for Tableau Analysis:
- US School Shooting Fatalities and Area IncomeU.S. School Shooting Fatalities and Area Per Capita Income
- U.S. School Shootings by Incident Type
Source: Laura E. Agnich
Dataset Description: The Shooting Incidents in Educational Settings Database includes 294 identified cases of “school shooting” incidents in 38 countries between 1764 through 2009. A shooting incident is defined as an actual or attempted first-degree multiple homicide incident involving two or more victims in a school or on school grounds, including murder-suicides and hostage situations. The database does not include single homicides, off-campus homicides, killings caused by government actions, militaries, terrorists or militants. Only cases that have been reported in major newspapers were identified. The data were drawn from news reports, published interviews, and online databases and published research, including information about the incident, victims, perpetrators and school contexts.
In the future, this database will be augmented with data from the Government Finance Officers’ Association (GFOA) from 1995-2007, to include detailed financial information about school districts. Additional variables and cases will be identified and added to the database as well.
Dataset Fields: The dataset fields include general information about the incidents and information about victims, perpetrators and school contexts.
Incident information includes: the type of incident (completed or attempted mass shooting, completed or attempted mass killing without the use of firearms, murder-suicide or hostage situation); the location of the incident (city, country, and U.S. state); the date of the incident (month, day and year); whether the homicides occurred entirely on school grounds, or both on and off campus; the number and types of weapons used (including items not commonly used as lethal weapons, such as cars, swords/knives, pistols/handguns, rifles/shotguns or explosives); whether the incident was foiled by police in advance; and when applicable, the common name of the incident reported most often in newspapers (e.g. “Columbine High School Massacre”).
Information about victims includes the number of fatalities and number of wounded. Information on perpetrators includes: the number of perpetrators; their age; race; gender; name; how they were apprehended (arrested by police, killed by police, suicide, killed by another perpetrator or killed by local residents); whether bullying was considered a preemptive factor in the shooting incident; and when applicable, the perpetrator’s college major or area of study in a university setting.
Information about the school context includes: the surrounding community context (rural, suburban or urban); the name of each school as well as its’ grade level (elementary, middle, high school, college/university and other types); whether the campus is open or closed; if the campus had security staff on campus; the number of security staff; whether campus security was armed or not; the type of security (police or non-police); the gender make-up of the security force; and the school population. An additional variable identifies whether the state had gun-control policies in place at the time of the incident.