Skip to content

Instantly share code, notes, and snippets.

@curran
Last active January 31, 2023 11:10
Show Gist options
  • Save curran/430efaf8f592d018bd3e to your computer and use it in GitHub Desktop.
Save curran/430efaf8f592d018bd3e to your computer and use it in GitHub Desktop.
Mother Jones Gun Violence Dataset

This is a dataset on gun violence.

Originally published in US Mass Shootings, 1982-2015: Data From Mother Jones' Investigation. Downloaded in CSV format from https://github.com/hepplerj/gun-violence/blob/master/data/motherjones.csv. Column types were manually annotated in data.json for use with the automatic type parsing library dsv-dataset

This example page provides the basic code required to load the data and display it on the page (as JSON) using D3.js.

Built with blockbuilder.org

forked from curran's block: The Iris Dataset

web counter
Case Location Date Year Summary Fatalities Injured Total victims Venue Prior signs of possible mental illness Mental Health Weapons obtained legally Where obtained Type of weapons Weapon details Race Gender Sources Mental Health Sources latitude longitude Type
Chattanooga military recruitment center Chattanooga, TN 7/16/15 2015 Kuwaiti-born Mohammod Youssuf Abdulazeez, 24, a naturalized US citizen, opened fire at a Naval reserve center, and then drove to a military recruitment office where he shot and killed four Marines and a Navy service member, and wounded a police officer and another military service member. He was then fatally shot in an exchange of gunfire with law enforcement officers responding to the attack. 5 2 7 Military Unclear Abdulazeez "had suffered for years from depression and possibly from bipolar disorder," according to a representative of the family. (NYT, July 20 2015) Both On the internet, via Armslist.com 2 assault rifles; semiautomatic handgun AK-47, AR-15, and 30-round magazines; 9mm handgun Other Male http://www.reuters.com/article/2015/07/16/us-usa-shooting-tennessee-idUSKCN0PQ1WY20150716; http://www.nytimes.com/2015/07/18/us/chattanooga-gunmans-past-scoured-for-extremist-ties.html; http://www.wsj.com/articles/chattanooga-shooting-highlights-online-gun-sales-1437435518http://www.nytimes.com/2015/07/19/us/chattanooga-attacks-claim-a-5th-military-service-members-life.html; http://www.cnn.com/2015/07/17/us/tennessee-naval-reserve-shooting/; https://twitter.com/markfollman/status/622105627473477632; http://www.nytimes.com/2015/07/21/us/chattanooga-gunman-wrote-of-suicide-and-martyrdom-official-says.html 35.047157 -85.311819 Mass
Charleston Church Shooting Charleston, SC 6/17/15 2015 Dylann Storm Roof, 21, shot and killed 9 people after opening fire at the Emanuel AME Church in Charleston, South Carolina. According to a roommate, he had allegedly been ���planning something like that for six months." 9 1 10 Religious Unknown Yes Shooter's Choice gun store in West Columbia, South Carolina Handgun .45-caliber Glock (model 41, with 13-round capacity magazine) white Male http://www.motherjones.com/politics/2015/06/dylann-roofs-attorney; http://www.newsweek.com/report-nine-shot-charleston-south-carolina-church-shooting-344235; http://www.cnn.com/2015/06/19/us/charleston-church-shooting-suspect/; http://www.motherjones.com/politics/2015/06/9-people-dead-mass-shooting-south-carolina-church; http://www.nbcnews.com/storyline/charleston-church-shooting/fbi-says-dyann-roof-should-not-have-been-sold-gun-n390056 32.788387 -79.933143 Mass
Marysville-Pilchuck High Schoolshooting Marysville, WA 10/24/14 2014 Jaylen Fryberg, 15, using a .40-caliber Berretta, shot five students at Marysville High School, including two of his cousins and three friends, killing all but one. Fryberg arranged to meet them for lunch in the school cafeteria by text. Fryberg was reportedly well-liked at the school and there was not believed to be any ill-will between him and his victims. He committed suicide at the scene. 5 1 6 School Unclear Fryberg was well-liked and allegedly happy, but was also upset about a girl and had posted emotional social media messages. No definitive signs of mental health problems. No Gun was his father's. Handgun Beretta .40-caliber handgun native american Male http://www.seattletimes.com/seattle-news/fourth-marysville-shooting-victim-dies-as-another-is-laid-to-rest/ http://www.mercurynews.com/crime-courts/ci_26814211/jaylen-fryberg-included-tributes-washington-school-shooting-victims http://www.newyorker.com/science/maria-konnikova/almost-link-mental-health-gun-violence 48.050824 -122.176918 Mass
Alturas tribal shooting Alturas, CA 2/20/14 2014 Cherie Lash Rhoades, 44, opened fire at the Cedarville Rancheria Tribal Office and Community Center, killing four and wounding two. After running out of ammunition, Rhoades grabbed a butcher knife and stabbed another person. 4 2 6 Other Unknown Unknown Two handguns and a butcher knife 9mm semi-automatic handgun native american Female http://www.sacbee.com/news/local/crime/article2603350.html; http://www.csmonitor.com/USA/2014/0223/Alturas-tribal-shooting-Was-embezzlement-eviction-behind-family-revenge-video; http://www.cbsnews.com/news/4-dead-2-injured-at-american-indian-tribal-office-in-northern-california/; http://nativenewsonline.net/currents/former-tribal-chairperson-custody-mass-murder-cedarville-rancheria-tribal-headquarters/ 41.487104 -120.542237 Mass
Washington Navy Yard shooting Washington, D.C. 9/16/13 2013 Aaron Alexis, 34, a military veteran and contractor from Texas, opened fire in the Navy installation, killing 12 people and wounding 8 before being shot dead by police. 13 8 21 Military Yes Had told Rhode Island police the prior month that he'd "heard voices"; had been undergoing mental health treatment with Veterans Affairs since August 2013. Yes Sharpshooters Small Arms Range Sawed-off shotgun, 2 boxes of shells; also a .45-caliber handgun taken from a security guard he shot at the scene. Remington 870 Express 12-gauge shotgun; Beretta handgun black Male http://www.nytimes.com/2013/09/18/us/state-law-stopped-gunman-from-buying-rifle-officials-say.html; http://edition.cnn.com/2013/09/17/us/navy-yard-shooting-military-contractors; http://www.fbi.gov/washingtondc/press-releases/2013/law-enforcement-shares-findings-of-the-investigation-into-the-washington-navy-yard-shootings/index.html http://bigstory.ap.org/article/13-killed-washington-navy-yard-shooting-rampage 38.874981 -76.99453 Mass
Hialeah apartment shooting Hialeah, Florida 7/26/13 2013 Pedro Vargas, 42, set fire to his apartment, killed six people in the complex, and held another two hostages at gunpoint before a SWAT team stormed the building and fatally shot him. 7 0 7 Other Unclear His mother told authorities her son had been acting strangely and needed a psychiatric evaluation. Yes Florida Gun Center 9mm semi-automatic handgun Glock 17 latino Male http://www.miamiherald.com/2013/07/27/v-print/3526078/a-look-at-the-victims-in-the-hialeah.html http://www.cbsnews.com/8301-201_162-57595796/pedro-vargas-idd-as-gunman-behind-deadly-rampage-in-hialeah-florida/ http://www.miamiherald.com/2013/07/28/3528362/little-about-pedro-vargas-life.html http://www.miamiherald.com/2013/08/03/v-print/3539629/hialeah-killer-showed-signs-of.html 25.8670105 -80.29146268 Mass
Santa Monica rampage Santa Monica, California 6/7/13 2013 John Zawahri, 23, armed with a homemade assault rifle and high-capacity magazines, killed his brother and father at home and then headed to Santa Monica College, where he was eventually killed by police. 6 3 9 Other Yes He was known as a solitary teen who regularly ditched class and had an interest in assault weapons; he had been admitted to UCLA's psychiatric ward for a brief period. Yes Assembled a rifle out of component parts. Assault rifle, high capacity magazines, antique handgun .223-caliber semi-automatic assault rifle, about 40 high capacity magazines,"black powder" handgun (likely antique) white Male http://www.cbsnews.com/8301-504083_162-57589327-504083/john-zawahri-suspected-gunman-in-deadly-santa-monica-shooting-left-farewell-note-police-say/ http://www.cbsnews.com/8301-504083_162-57589327-504083/john-zawahri-suspected-gunman-in-deadly-santa-monica-shooting-left-farewell-note-police-say/ http://www.latimes.com/news/local/la-me-0611-santa-monica-shooting-20130611,0,1490078.story 34.008617 -118.494754 Spree
Pinewood Village Apartment shooting Federal Way, Washington 4/21/13 2013 Dennis Clark III, 27, shot and killed his girlfriend in their shared apartment, and then shot two witnesses in the building's parking lot and a third victim in another apartment, before being killed by police. 5 0 5 Other No Yes Unknown Semiautomatic handgun, shotgun .40 caliber semi-automatic handgun, pistol grip shotgun black Male http://seattletimes.com/html/localnews/2020836119_federalwayshootingxml.html 47.3129607 -122.3393665 Mass
Mohawk Valley shootings Herkimer County, New York 3/13/13 2013 Kurt Myers, 64, shot six people in neighboring towns, killing two in a barbershop and two at a car care business, before being killed by officers in a shootout after a nearly 19-hour standoff. 5 2 7 Other No Yes Frank's Guns in Marcy, NY Shotgun Unknown white Male https://www.nyspnews.com/article_display.cfm?article_id=29584 http://poststar.com/news/local/state-and-regional/cops-kill-suspect-in-deadly-mohawk-valley-shooting-rampage/article_15260208-8bf5-11e2-b2d9-0019bb2963f4.html 43.045601 -74.984891 Spree
Newtown school shooting Newtown, Connecticut 12/14/12 2012 Adam Lanza, 20, shot his mother dead at their home then drove to Sandy Hook Elementary school. He forced his way inside and opened fire, killing 20 children and six adults before committing suicide. 28 2 30 School Yes Lanza had a history of serious mental health problems that were known to his family and others, as detailed in a post-massacre investigation by Connecticut authorities. No Stolen from mother Two semiautomatic handguns, one rifle (assault), one shotgun (assault) 10mm Glock, 9mm SIG Sauer P226 semiautomatic handguns; .223 Bushmaster XM15-E2S semiautomatic rifle; Izhmash Saiga-12 12-gauge semiautomatic shotgun white Male http://usnews.nbcnews.com/_news/2012/12/14/15911025-authorities-id-gunman-who-killed-27-in-elementary-school-massacre?lite; http://articles.washingtonpost.com/2012-12-14/local/35846977_1_law-enforcement-lanza-brothers-kid http://usnews.nbcnews.com/_news/2012/12/14/15911025-authorities-id-gunman-who-killed-27-in-elementary-school-massacre?lite; http://articles.washingtonpost.com/2012-12-14/local/35846977_1_law-enforcement-lanza-brothers-kid 41.4123225 -73.31142358 Mass
Accent Signage Systems shooting Minneapolis, Minnesota 9/27/12 2012 Andrew Engeldinger, 36, upon learning he was being fired, went on a shooting rampage, killing the business owner, three fellow employees, and a UPS driver. He then killed himself. 7 1 8 Workplace Yes His family worried about his "paranoia and delusions" for at least two years prior, and tried to get him to seek treatment. Yes Unknown One semiautomatic handgun 9mm Glock semiautomatic handgun white Male http://www.startribune.com/local/171774461.html?refer=y http://www.startribune.com/local/171774461.html?refer=y 44.9772995 -93.2654692 Mass
Sikh temple shooting Oak Creek, Wisconsin 8/5/12 2012 U.S. Army veteran Wade Michael Page, 40, opened fire in a Sikh gurdwara before he died from a self-inflicted gunshot would during a shootout with police. 7 3 10 Religious Yes His Army friends once broke into his apartment, fearing he'd commit suicide in the '90s. A psychiatric nurse who lived downstairs from Page said it was "obvious" he had a mental illness. Yes Unknown One semiautomatic handgun 9mm Springfield Armory XDM semiautomatic handgun white Male http://www.jsonline.com/news/milwaukee/friend-of-page-feared-what-he-might-do-426edmg-165668826.html; http://usnews.nbcnews.com/_news/2012/09/10/13785426-officer-arriving-at-sikh-temple-shooting-time-to-use-deadly-force?lite; http://articles.latimes.com/2012/aug/08/nation/la-na-nn-sikh-shooting-guns-20120807; http://www.bbc.co.uk/news/world-us-canada-19183359 http://www.jsonline.com/news/milwaukee/friend-of-page-feared-what-he-might-do-426edmg-165668826.html 42.8858503 -87.8631362 Mass
Aurora theater shooting Aurora, Colorado 7/20/12 2012 James Holmes, 24, opened fire in a movie theater during the opening night of "The Dark Knight Rises" and was later arrested outside. 12 58 70 Other Yes He saw at least three mental health professionals before dropping out of his university. Yes Gander Mountain stores in Thornton and Aurora, Colo.; Bass Pro Shop in Denver, Colo.; BulkAmmo.com Two semiautomatic handguns, one rifle (assault), one shotgun Two .40-caliber Glock semiautomatic handguns; .223-caliber Smith & Wesson M&P15 semiautomatic rifle; 12-gauge Remington 870 pump-action shotgun white Male http://www.cbsnews.com/8301-201_162-57497820/james-holmes-saw-three-mental-health-professionals-before-shooting/; http://www.9news.com/news/article/283503/188/Aurora-shooting-prompts-gun-bills-in-big-states-; http://www.nytimes.com/2012/07/21/us/shooting-at-colorado-theater-showing-batman-movie.html; http://www.motherjones.com/politics/2012/07/batman-theater-shooting-updates-dark-knight-rises http://www.cbsnews.com/8301-201_162-57497820/james-holmes-saw-three-mental-health-professionals-before-shooting/ 39.709283 -104.823488 Mass
Seattle cafe shooting Seattle, Washington 5/20/12 2012 Ian Stawicki, 40, gunned down four patrons at a cafe, and another person during a carjacking nearby, then shot himself as police closed in. (He died later that day in a Seattle hospital.) 6 1 7 Other Yes His family said he was mentally ill Yes Bull's Eye Shooter Supply in Tacoma, Wash. Two semiautomatic handguns Two .45-caliber semiautomatic handguns white Male http://usnews.nbcnews.com/_news/2012/05/30/11959312-six-killed-in-seattle-shootings-including-suspect?lite; http://www.cbsnews.com/8301-201_162-57445177/seattle-shooting-hero-hurled-stools-at-gunman-ian-stawicki-saved-three-lives/?pageNum=2&tag=contentMain;contentBody; http://content.usatoday.com/communities/ondeadline/post/2012/05/seattle-killer-had-concealed-carry-permit-owned-6-guns/1#.UFI9shhgspQ http://usnews.nbcnews.com/_news/2012/05/30/11959312-six-killed-in-seattle-shootings-including-suspect?lite 47.6038321 -122.3300624 Spree
Oikos University killings Oakland, California 4/2/12 2012 One L. Goh, 43, a former student, opened fire in a nursing classroom. He fled the scene by car and was arrested nearby a few hours later. 7 3 10 School Yes A former instructor at Oikos described him as "mentally unstable" and "paranoid." Yes Bullseye in Castro Valley, Calif. One semiautomatic handgun .45-caliber semiautomatic handgun Asian Male http://blog.sfgate.com/eguillermo/2012/04/05/something-still-doesnt-compute-in-the-one-goh-nightmare/; http://www.mercurynews.com/top-stories/ci_20308252/police-respond-shooting-east-oakland; http://www.cbsnews.com/8301-504083_162-57408732-504083/gun-used-in-oikos-university-shooting-rampage-was-bought-legally-police-say/; http://berkeley.patch.com/articles/one-l-goh-showed-violent-tendencies-before-the-oikos-university-shooting-oikos-university-shooting http://berkeley.patch.com/articles/one-l-goh-showed-violent-tendencies-before-the-oikos-university-shooting-oikos-university-shooting; http://blog.sfgate.com/eguillermo/2012/04/05/something-still-doesnt-compute-in-the-one-goh-nightmare/ 37.8043808 -122.2708166 Mass
Su Jung Health Sauna shooting Norcross, Georgia 2/22/12 2012 Jeong Soo Paek, 59, returned to a Korean spa from which he'd been kicked out after an altercation. He gunned down two of his sisters and their husbands before committing suicide. 5 0 5 Other Yes His sister worried about his homicidal tendencies; she said his mental health had been deteriorating and that he had threatened to commit suicide with his gun. Yes Unknown One semiautomatic handgun .45-caliber semiautomatic handgun Asian Male http://www.gwinnettdailypost.com/news/2012/feb/23/police-id-4-victims-shooter-in-spa-killing/; http://www.cbsnews.com/8301-504083_162-57479989-504083/shooting-sprees-in-2012-crimesider-reports-on-some-of-the-countrys-worst-public-shootings-this-year/; http://chronicle.augusta.com/news/metro/2012-02-22/victims-korean-spa-shooting-near-atlanta-were-2-married-couples-gunman-was; http://onlineathens.com/local-news/2012-02-23/mass-shooting-spa-shocks-ga-korean-community http://www.gwinnettdailypost.com/news/2012/feb/23/police-id-4-victims-shooter-in-spa-killing/ 33.9412127 -84.2135309 Mass
Seal Beach shooting Seal Beach, California 10/14/11 2011 Scott Evans Dekraai, 42, opened fire inside a hair salon and was later arrested. 8 1 9 Other Yes He suffered from bipolar disorder, mood swings, and PTSD. Yes Unknown Two semiautomatic handguns, one revolver .45-caliber Heckler & Koch, 9mm Springfield semiautomatic handguns; .44 Magnum Smith & Wesson revolver white Male http://laist.com/2011/10/13/seal_beach_shooter_suffered_from_ptsd.php; http://blogs.ocweekly.com/navelgazing/2011/10/hair_salon_seal_beach_shooting.php; http://latimesblogs.latimes.com/lanow/2011/10/seal-beach-shooting-suspect-had-been-ordered-not-to-carry-guns-.html http://laist.com/2011/10/13/seal_beach_shooter_suffered_from_ptsd.php 33.741176 -118.1046356 Mass
IHOP shooting Carson City, Nevada 9/6/11 2011 Eduardo Sencion, 32, opened fire at an International House of Pancakes restaurant and later died from a self-inflicted gunshot wound. 5 7 12 Other Yes He was diagnosed with paranoid schizophrenia as a teenager and feared demons were out to get him. Yes Purchased from an individual Two rifles (both assault), one revolver AK-47 Norinco Arms variant, AK-47 Romarm Cugir variant automatic rifles; .38-caliber Colt revolver latino Male http://www.huffingtonpost.com/2011/11/03/eduardo-sencion-ihop-shooter_n_1073677.html; http://www.lasvegassun.com/news/2011/sep/06/report-seven-shot-inside-carson-city-ihop/; http://www.lasvegassun.com/news/2011/oct/23/nv-gun-laws-rampage-2nd-ld-writethru/ http://www.huffingtonpost.com/2011/11/03/eduardo-sencion-ihop-shooter_n_1073677.html 39.1637984 -119.7674034 Mass
Tucson shooting Tucson, Arizona 1/8/11 2011 Jared Loughner, 22, opened fire outside a Safeway during a constituent meeting with Congresswoman Gabrielle Giffords (D-Ariz.) before he was subdued by bystanders and arrested. 6 13 19 Other Yes His symptoms pointed to various possible mental illness diagnoses, such as schizophrenia and delusional disorder. He also experimented with pot and hallucinogens. Yes Sportsmen's Warehouse in Tucson, Ariz. One semiautomatic handgun 9mm Glock 19 semiautomatic handgun white Male http://www.time.com/time/magazine/article/0,9171,2042358,00.html; http://www.csmonitor.com/USA/Politics/2011/0110/Why-Jared-Loughner-was-allowed-to-buy-a-gun; http://www.nytimes.com/2011/01/09/us/politics/09giffords.html?ref=jaredleeloughner http://www.time.com/time/magazine/article/0,9171,2042358,00.html 32.2217429 -110.926479 Mass
Hartford Beer Distributor shooting Manchester, Connecticut 8/3/10 2010 Omar S. Thornton, 34, shot up his Hartford Beer Distributor workplace after facing disciplinary issues, then committed suicide. 9 2 11 Workplace No He apparently was driven over the edge by unaddressed, ongoing racism against him at work Yes Gun dealer in East Windsor, Conn. Two semiautomatic handguns Two 9mm Ruger SR9 semiautomatic handguns black Male http://www.cbsnews.com/8301-504083_162-20012557-504083.html; http://www.msnbc.msn.com/id/38535909/ns/us_news-crime_and_courts/t/dead-shooting-conn-beer-distributor/#.UFGJAqRrND4; http://www.foxnews.com/us/2010/08/03/dead-wounded-conn-workplace-shooting/ http://www.cbsnews.com/8301-504083_162-20012557-504083.html 41.7759324 -72.5214755 Mass
Coffee shop police killings Parkland, Washington 11/29/09 2009 Maurice Clemmons, 37, a felon who was out on bail for child-rape charges, entered a coffee shop on a Sunday morning and shot four police officers who had gone there to use their laptops before their shifts. Clemmons, who was wounded fleeing the scene, was later shot dead by a police officer in Seattle after a two-day manhunt. 4 1 5 Other Yes He had a history of erratic, bizarre behavior. He once asked his family to get naked for 5 minutes on Sunday; he said he thought the world would end and that he was Jesus. No Stolen from an individual in Seattle. One semiautomatic handgun 9mm Glock 17 semiautomatic handgun; .38-caliber Smith & Wesson revolver black Male http://seattletimes.com/html/localnews/2010385617_webmansought29.html; http://www.nytimes.com/2009/11/30/us/30tacoma.html?_r=1; http://seattletimes.com/html/localnews/2014155225_clemmons08m.html http://seattletimes.com/html/localnews/2010385617_webmansought29.html 47.155846 -122.437031 Mass
Fort Hood massacre Fort Hood, Texas 11/5/09 2009 Army psychiatrist Nidal Malik Hasan, 39, opened fire on an Army base in an attack linked to Islamist extremism. Hasan was injured during the attack and later arrested. 13 30 43 Military Unclear Medical officials at Walter Reed Army Medical Center and the Uniformed Services University of the Health Sciences raised concerns prior to the shooting regarding Hasan's aloof and erratic behavior and extremist Islamic views. Yes Guns Galore in Kileen, Texas One semiautomatic handgun FN Five-seveN semiautomatic handgun Other Male http://seattletimes.com/html/nationworld/2010232219_apusforthoodshooting.html; http://articles.latimes.com/2010/oct/21/nation/la-na-fort-hood-20101022; http://thelede.blogs.nytimes.com/2009/11/05/reports-of-mass-shooting-at-fort-hood/; http://www.usatoday.com/news/military/story/2012-08-14/fort-hood-rampage-trial/57050394/1 http://www.npr.org/templates/story/story.php?storyId=120313570 31.2011305 -97.77156996 Mass
Binghamton shootings Binghamton, New York 4/3/09 2009 Jiverly Wong, 41, opened fire at an American Civic Association center for immigrants before committing suicide. 14 4 18 Other Yes He apparently harbored growing paranoia toward cops. He also sent a delusional letter to a local TV station right before the shooting. Yes Gander Mountain in Johnson City, N.Y. Two semiautomatic handguns 9mm Beretta, .45-caliber Springfield semiautomatic handguns Asian Male http://www.nytimes.com/2009/04/12/nyregion/12binghamton.html?pagewanted=all&_r=0; http://www.nytimes.com/2009/04/04/nyregion/04hostage.html?pagewanted=all http://www.nytimes.com/2009/04/12/nyregion/12binghamton.html?pagewanted=all&_r=1& 42.0986867 -75.9179738 Mass
Carthage nursing home shooting Carthage, North Carolina 3/29/09 2009 Robert Stewart, 45, opened fire at a nursing home where his estranged wife worked before he was shot and arrested by a police officer. 8 3 11 Other Yes His estranged wife told her workplace that her husband had an "unstable mental state or (was) mentally ill." Yes Local sporting goods stores and individuals One revolver, one shotgun Winchester 1300 pump-action shotgun; .357 Magnum revolver white Male http://www.wral.com/news/local/story/9845639/; http://www.wral.com/news/local/story/4837676/ http://www.wral.com/news/local/story/9845639/ 35.345802 -79.4170543 Mass
Atlantis Plastics shooting Henderson, Kentucky 6/25/08 2008 Disgruntled employee Wesley Neal Higdon, 25, shot up an Atlantis Plastics factory after he was escorted out of his workplace for an argument with a supervisor. Higdon shot the supervisor outside the factory before opening fire on coworkers inside. He then committed suicide. 6 1 7 Workplace No He called his girlfriend two hours before the shooting to say he was going to kill his boss. Yes Unknown One semiautomatic handgun .45-caliber Hi-Point semiautomatic handgun white Male http://www.foxnews.com/story/0,2933,371242,00.html; http://www.msnbc.msn.com/id/25393695/ns/us_news-crime_and_courts/t/witnesses-describe-chaotic-scene-ky-plant/#.UFEbHhhgspQ http://www.foxnews.com/story/0,2933,371242,00.html 37.76721 -87.5573742 Mass
Northern Illinois University shooting DeKalb, Illinois 2/14/08 2008 Steven Kazmierczak, 27, opened fire in a lecture hall, then shot and killed himself before police arrived. 6 21 27 School Yes After high school, his parents placed him at a psychiatric treatment center. He told friends he left the Army after six months due to a psychological discharge. Yes Online and gun retailers in Champaign, Ill. Three semiautomatic handguns, one shotgun 9mm Glock 19, Hi-Point CF380, 9mm Kurz SIG Sauer P232 semiautomatic handguns; 12-gauge Remington Sportsman 48 sawed-off shotgun white Male http://www.huffingtonpost.com/jonathan-fast/steve-kazmierczak-the-sec_b_87031.html; http://www.msnbc.msn.com/id/23171567/ns/us_news-crime_and_courts/t/college-shooters-deadly-rampage-baffles-friends/#.UFEZnhhgspQ; http://www.nytimes.com/slideshow/2008/02/14/us/0214-SHOOTING_index.html?ref=schoolshooting&gwh=B62598A5487B946A532C5846B4A85156; www.niu.edu/feb14report/Feb14report.pdf http://www.cbsnews.com/stories/2008/02/16/national/main3840072.shtml 41.9294736 -88.7503647 Mass
Kirkwood City Council shooting Kirkwood, Missouri 2/7/08 2008 Charles "Cookie" Lee Thornton, 52, went on a rampage at the city hall before being shot and killed by police. 6 2 8 Other No He was known for histrionics and disruptions at city council meetings. His mounting debt was a stressor. No Taken in burglary and from fallen police officer One semiautomatic handgun, one revolver .40-caliber Smith & Wesson semiautomatic handgun; .44 Magnum Smith & Wesson Model 29 revolver black Male http://www.stltoday.com/news/local/crime-and-courts/charles-lee-cookie-thornton-behind-the-smile/article_be96f13c-78b9-11df-bfdc-0017a4a78c22.html; http://www.nytimes.com/2008/02/08/us/08missouri.html; http://nl.newsbank.com/nl-search/we/Archives?p_product=SL&p_theme=sl&p_action=search&p_maxdocs=200&p_topdoc=1&p_text_direct-0=11F1CADA291472F0&p_field_direct-0=document_id&p_perpage=10&p_sort=YMD_date:D&s_trackval=GooglePM http://www.stltoday.com/news/local/crime-and-courts/charles-lee-cookie-thornton-behind-the-smile/article_be96f13c-78b9-11df-bfdc-0017a4a78c22.html 38.5833862 -90.406785 Mass
Westroads Mall shooting Omaha, Nebraska 12/5/07 2007 Robert A. Hawkins, 19, opened fire inside Westroads Mall before committing suicide. 9 4 13 Other Yes He had been treated in the past for depression and ADHD. No Stolen from grandfather One rifle (assault) WASR-10 Century Arms semiautomatic rifle white Male http://www.guardian.co.uk/world/2007/dec/06/usa.usgunviolence2; http://www.npr.org/templates/story/story.php?storyId=16962485; http://www.independentmail.com/news/2007/dec/08/officials-say-assault-rifles-cause-roughly-same-am/; http://www.latimes.com/news/nationworld/nation/la-na-mall7dec07,0,882178.story http://www.guardian.co.uk/world/2007/dec/06/usa.usgunviolence2 41.2587317 -95.9378732 Mass
Crandon shooting Crandon, Wisconsin 10/7/07 2007 Off-duty sheriff's deputy Tyler Peterson, 20, opened fire inside an apartment after an argument at a homecoming party. He fled the scene and later committed suicide. 6 1 7 Other Unclear The families of victims filed a wrongful death lawsuit against the county arguing that the police department should have evaluated the gunman's mental health before hiring him. Yes Issued by Forest County Sheriff's Department One rifle (assault) AR-15 SWAT semiautomatic rifle white Male http://www.rivernewsonline.com/main.asp?SectionID=6&SubSectionID=47&ArticleID=368; http://news.google.com/newspapers?id=O-MqAAAAIBAJ&sjid=u0UEAAAAIBAJ&pg=6724,5434155&dq=crandon+shooting&hl=en http://www.rivernewsonline.com/main.asp?SectionID=6&SubSectionID=47&ArticleID=368 45.5719072 -88.9028922 Mass
Virginia Tech massacre Blacksburg, Virginia 4/16/07 2007 Virginia Tech student Seung-Hui Cho, 23, opened fire on his school's campus before committing suicide. 33 23 56 School Yes A district court ruled Cho was "an imminent danger" to himself and others as a result of mental illness two years earlier, and directed Cho to seek treatment. Yes Purchased variously online and from Roanoke Firearms in Roanoke, Va. Two semiautomatic handguns 9mm Glock 19, .22-caliber Walther P22 semiautomatic handguns Asian Male http://www.nytimes.com/2007/04/24/us/24virginia.html; http://www.thestandard.com.hk/news_detail.asp?we_cat=9&art_id=42489&sid=13196711&con_type=1&d_str=20070419&fc=10; http://smartgunlaws.org/mental-health-reporting-policy-summary/ http://abcnews.go.com/US/story?id=3052278&page=1 37.2295733 -80.4139393 Mass
Trolley Square shooting Salt Lake City, Utah 2/12/07 2007 Sulejman Talovi����, 18, rampaged through the shopping center until he was shot dead by police. 6 4 10 Other Unclear According to one relative, he was violent and had the mental capacity of a child. (But accounts from others did not indicate this about the shooter.) No Purchased variously from Sportsman's Fast Cash in West Valley City, Utah and individuals One revolver, one shotgun Mossberg Maverick 88 Field shotgun; .38-caliber Smith & Wesson M36 revolver white Male http://www.deseretnews.com/article/660205647/Ex-relative-calls-Talovic-vicious-troubled.html?pg=all; http://www.cbsnews.com/stories/2007/02/15/national/main2480419.shtml; http://www.cbsnews.com/8301-201_162-2823327.html http://www.deseretnews.com/article/660205647/Ex-relative-calls-Talovic-vicious-troubled.html?pg=all 40.7606467 -111.89109 Mass
Amish school shooting Lancaster County, Pennsylvania 10/2/06 2006 Charles Carl Roberts, 32, shot 10 young girls in a one-room schoolhouse in Bart Township, killing 5, before taking his own life. 6 5 11 School No He told his wife that he'd molested two young relatives 20 years ago. Yes Local stores in Nickel Mines, Penn. One semiautomatic handgun, one rifle, one shotgun Springfield semiautomatic handgun; .30-06 Ruger bolt-action rifle; 12-gauge Browning pump-action shotgun white Male http://news.google.com/newspapers?id=O8oyAAAAIBAJ&sjid=YSUEAAAAIBAJ&pg=6143,1260138&dq=charles+carl+roberts+mentally+ill&hl=en;http://www.msnbc.msn.com/id/15105305/ns/us_news-crime_and_courts/t/th-girl-dies-after-amish-schoolhouse-shooting/#.UFD4SxhgspQ; http://www.foxnews.com/story/0,2933,217170,00.html http://www.cnn.com/2006/US/10/03/amish.shooting/index.html 39.9589 -76.0806 Mass
Capitol Hill massacre Seattle, Washington 3/25/06 2006 Kyle Aaron Huff, 28, opened fire at a rave afterparty in the Capitol Hill neighborhood of Seattle before committing suicide. 7 2 9 Other No Police were unable to find any record that he had been treated for mental illness or was on psychiatric medication. Yes Various sporting goods stores in Kalispell, Mont. Two semiautomatic handguns, one rifle (assault), one shotgun .40-caliber Ruger, one other semiautomatic handgun; Bushmaster XM15 E2S semiautomatic rifle; 12-gauge Winchester Defender pump-action shotgun with extended tube and pistol grip white Male http://seattletimes.com/html/localnews/2002892043_shooter27m.html; http://seattletimes.com/html/localnews/2002898900_huff30m.html http://seattletimes.com/html/localnews/2002898900_huff30m.html 47.6229 -122.3165 Mass
Goleta postal shootings Goleta, California 1/30/06 2006 Former postal worker Jennifer Sanmarco, 44, shot dead a former neighbor then drove to the mail processing plant where she used to work. Inside, she opened fire, killing six employees before committing suicide. 8 0 8 Workplace Yes She was placed on retirement disability for psychological reasons. Fellow employees described her behavior as increasingly bizarre. She believed the Postal Service employees were conspiring against her. Yes Pawn shops in Grants and Gallup, N.M. One semiautomatic handgun 9mm Smith & Wesson 915 semiautomatic handgun white Female http://www.msnbc.msn.com/id/11167920/ns/us_news-crime_and_courts/t/postal-killer-believed-she-was-target-plot/#.UIxy7kzLwTE; http://www.cbsnews.com/stories/2006/02/02/national/main1272077.shtml; http://www.msnbc.msn.com/id/11167920/ns/us_news-crime_and_courts/t/postal-killer-believed-she-was-target-plot/#.UNyN5cXhe75 34.436283 -119.8714406 Spree
Red Lake massacre Red Lake, Minnesota 3/21/05 2005 Jeffrey Weise, 16, murdered his grandfather, who was a police officer, and grandfather's girlfriend. Weise then drove his grandfather's squad car to Red Lake Senior High School and opened fire on the reservation campus, killing another seven people before committing suicide. 10 5 15 School Yes He voluntarily visited a a psychiatric ward. He was hospitalized at least once for suicidal tendencies and was taking Prozac. No Glock and Remington stolen from grandfather Two semiautomatic handguns, one shotgun .40-caliber Glock 23, .22-caliber Ruger semiautomatic handguns; 12-gauge Remington 870 shotgun native american Male http://news.google.com/newspapers?id=c4dIAAAAIBAJ&sjid=_XEDAAAAIBAJ&pg=5163,1527281&dq=jeffrey+weise+mental+ill&hl=en; http://www.cbsnews.com/stories/2005/03/24/national/main682915.shtml?source=search_story; http://www.usnews.com/usnews/news/articles/050404/4redlake.htm; http://www.foxnews.com/story/0,2933,151116,00.html http://www.cbsnews.com/stories/2005/03/24/national/main682915.shtml?source=search_story 47.876346 -95.0169401 Spree
Living Church of God shooting Brookfield, Wisconsin 3/12/05 2005 Living Church of God member Terry Michael Ratzmann, 44, opened fire at a church meeting at a Sheraton hotel before committing suicide. 7 4 11 Religious Yes Neighbors said he suffered from depression and had a drinking problem. Yes Gun dealer in Waukesha, Wis. One semiautomatic handgun 9mm Beretta semiautomatic handgun white Male http://www.cbsnews.com/2100-201_162-679761.html; http://www.foxnews.com/story/0,2933,150255,00.html; http://www.msnbc.msn.com/id/7167861/ns/us_news-crime_and_courts/t/relatives-struggle-answers-after-shooting/#.UN3Scko6JT4 http://www.cbsnews.com/2100-201_162-679761.html 43.0605671 -88.1064787 Mass
Damageplan show shooting Columbus, Ohio 12/8/04 2004 Nathan Gale, 25, possibly upset about the breakup of Pantera, gunned down former Pantera guitarist Dimebag Darrell and three others at a Damageplan show before a police officer fatally shot Gale. 5 7 12 Other Yes He was discharged from the military because he was a paranoid schizophrenic. Yes Received as a gift from mother One semiautomatic handgun 9mm Beretta 92FS semiautomatic handgun white Male http://www.cbsnews.com/2100-201_162-659983.html; http://www.knac.com/article.asp?ArticleID=3417; http://www.blabbermouth.net/news.aspx?mode=Article&newsitemID=86362 http://www.cbsnews.com/2100-201_162-659983.html 39.9622601 -83.0007065 Mass
Lockheed Martin shooting Meridian, Mississippi 7/8/03 2003 Assembly line worker Douglas Williams, 48, opened fire at his Lockheed Martin workplace in a racially motivated attack before committing suicide. 7 8 15 Workplace Yes His cousin said he was depressed and "going through a lot of things." Yes Purchased from an individual One semiautomatic handgun, two rifles, one derringer, one shotgun .45-caliber Ruger P90 semiautomatic handgun; .22-caliber rifle with scope, .223-caliber Ruger Mini-14 rifle; 12-gauge Winchester 1300 shotgun; .22 Magnum derringer white Male http://usatoday30.usatoday.com/news/nation/2003-07-08-miss-shooting-main_x.htm; http://www.nytimes.com/2003/07/09/us/man-kills-5-co-workers-at-plant-and-himself.html; http://www.nytimes.com/2003/07/16/us/national-briefing-south-mississippi-death-toll-rises-in-plant-shooting.html http://usatoday30.usatoday.com/news/nation/2003-07-08-miss-shooting-main_x.htm 32.376081 -88.68978002 Mass
Navistar shooting Melrose Park, Illinois 2/5/01 2001 Fired employee William D. Baker, 66, opened fire at his former Navistar workplace before committing suicide. 5 4 9 Workplace No He had a criminal past, including a sexual assault conviction. Yes Some purchased from Pepper Sports in Glen Ellyn, Ill. Two rifles, one revolver, one shotgun SKS 1954R, .30-caliber Winchester rifles; 12-gauge Remington pump-action shotgun; .38-caliber revolver black Male http://articles.chicagotribune.com/2001-02-07/news/0102070122_1_navistar-gun-law-hunting-rifle; http://www.vpc.org/studies/wgun010205.htm http://articles.chicagotribune.com/2001-02-07/news/0102070122_1_navistar-gun-law-hunting-rifle 41.9005865 -87.8567277 Mass
Wakefield massacre Wakefield, Massachusetts 12/26/00 2000 Michael McDermott, 42, opened fire on co-workers at Edgewater Technology and was later arrested. 7 0 7 Workplace Yes Psychiatrist guessed he had schizophrenia, but McDermott had researched how to fake a mental illness on the internet. Defense lawyer described history of suicide attempts and mental illness dating back to teen years. Jury rejected his insanity defense. Yes Unknown One semiautomatic handgun, one rifle (assault), one shotgun .32-caliber Retolaza semiautomatic handgun; AK-47 variant semiautomatic rifle; 12-gauge Winchester 1300 pump-action shotgun white Male http://www.time.com/time/magazine/article/0,9171,93313,00.html; http://articles.cnn.com/2002-04-22/justice/ctv.mcdermott.trial_1_michael-mcdermott-jury-deliberates-fate-mental-illness?_s=PM:LAW; http://www.nytimes.com/2000/12/27/us/7-die-in-rampage-at-company-co-worker-of-victims-arrested.html; http://www.vpc.org/studies/wgun001226.htm http://articles.cnn.com/2002-04-22/justice/ctv.mcdermott.trial_1_michael-mcdermott-jury-deliberates-fate-mental-illness?_s=PM:LAW; http://www.boston.com/news/daily/24/mcdermott_verdict.htm 42.506484 -71.0728306 Mass
Hotel shooting Tampa, Florida 12/30/99 1999 Hotel employee Silvio Leyva, 36, gunned down four coworkers at the Radisson Bay Harbor Inn before killing a woman outside who refused to give him her car. He was arrested shortly after the shootings. 5 3 8 Workplace Yes His brother called him "unbalanced" and mentally ill. Yes One purchased from Big E's in Tampa, Fla. One semiautomatic handgun, one revolver 9mm Lorcin semiautomatic handgun; .38-caliber Charter Arms revolver latino Male http://www.sptimes.com/News/123000/news_pf/TampaBay/A_year_later__the_str.shtml; http://www.vpc.org/studies/wgun991230.htm; http://news.google.com/newspapers?id=CSUdAAAAIBAJ&sjid=ZaYEAAAAIBAJ&pg=2043,2634069&dq=silvio+leyva+shooting&hl=en http://www.sptimes.com/News/123000/news_pf/TampaBay/A_year_later__the_str.shtml 27.9477595 -82.458444 Mass
Xerox killings Honolulu, Hawaii 11/2/99 1999 Byran Koji Uyesugi, 40, a Xerox service technician, opened fire inside the building with a 9mm Glock. He fled and was later apprehended by police. 7 0 7 Workplace Yes A psychiatrist, testifying for the prosecution,said he suffered from schizophrenia. Yes Hunting Supplies of Hawaii (The Armory) in Honolulu, Hawaii One semiautomatic handgun 9mm Glock 17 semiautomatic handgun Asian Male http://archives.starbulletin.com/2000/06/02/news/story2.html; http://www.vpc.org/studies/wgun991102.htm http://archives.starbulletin.com/2000/06/02/news/story2.html 21.3255125 -157.8473055 Mass
Wedgwood Baptist Church shooting Fort Worth, Texas 9/15/99 1999 Larry Gene Ashbrook, 47, opened fire inside the Wedgwood Baptist Church during a prayer rally before committing suicide. 8 7 15 Religious Yes His siblings decribed him as a paranoid schizophrenic. Yes Trader's Village flea market in Grand Prairie, Texas Two semiautomatic handguns .380-caliber, 9mm Ruger P85 semiautomatic handguns white Male http://www.nytimes.com/1999/09/20/us/fort-worth-remembers-those-killed-at-church.html?pagewanted=all&src=pm; http://www.nytimes.com/1999/09/18/us/death-in-a-church-the-overview-with-question-of-why-unanswered-fort-worth-mourns.html; http://www.vpc.org/studies/wgun990915.htm http://www.nytimes.com/1999/09/18/us/death-in-a-church-the-overview-with-question-of-why-unanswered-fort-worth-mourns.html 32.693397 -97.47067092 Mass
Atlanta day trading spree killings Atlanta, Georgia 7/29/99 1999 Day trader Mark O. Barton, 44, who had recently lost a substantial sum of money, went on a shooting spree through two day-trading firms. He started at the All-Tech Investment Group, where he worked, then went on to Momentum Securities. He fled and hours later, after being cornered by police outside a gas station, committed suicide. (Two days before the spree, he killed his wife and two children with a hammer.) 9 13 22 Workplace Yes In letters, he details his deep depression and downward spiral. Yes Glock purchased from gun store in Warner Robins, Ga. Three semiautomatic handguns, one revolver .45-caliber Colt 1911-A1, 9mm Glock 17, .25-caliber Raven Arms MP-25 semiautomatic handguns; .22-caliber Harrington & Richardson revolver white Male http://www.independent.co.uk/news/i-dont-plan-to-live-much-longer-just-long-enough-to-kill-the-people-that-greedily-sought-my-destruction-1109610.html; http://articles.cnn.com/1999-07-30/us/9907_30_atlanta.shooting.06_1_gladys-barton-debra-spivey-barton-note?_s=PM:US; http://www.vpc.org/studies/wgun990729.htm http://www.independent.co.uk/news/i-dont-plan-to-live-much-longer-just-long-enough-to-kill-the-people-that-greedily-sought-my-destruction-1109610.html 33.7490987 -84.3901849 Spree
Columbine High School massacre Littleton, Colorado 4/20/99 1999 Eric Harris, 18, and Dylan Klebold, 17, opened fire throughout Columbine High School before committing suicide. 15 24 39 School Yes Harris was an alleged psychopath; Klebold was depressed and suicidal. No Purchased variously at Tanner Gun Show in Denver, Colo. and from an individual One semiautomatic handgun (assault), one rifle (assault), two shotguns 9mm Intratec DC-9 semiautomatic handgun; 9mm Hi-Point 995 carbine rifle; 12-gauge sawed-off Savage Stevens 311D, 12-gauge sawed-off Savage Springfield 67H pump-action shotguns white Male http://www.usatoday.com/news/nation/2009-04-13-columbine-myths_N.htm; http://www.vpc.org/studies/wgun990420.htm; http://www.slate.com/articles/news_and_politics/assessment/2004/04/the_depressive_and_the_psychopath.html http://www.slate.com/articles/news_and_politics/assessment/2004/04/the_depressive_and_the_psychopath.html 39.6021065 -104.9877273 Mass
Thurston High School shooting Springfield, Oregon 5/21/98 1998 After he was expelled for having a gun in his locker, Kipland P. Kinkel, 15, a freshman at Thurston High, went on a shooting spree, killing his parents at home and two students at school. Five classmates wrestled Kipland to the ground before he was arrested. 4 25 29 School Yes Doctors testified that he was a paranoid schizophrenic who suffered from hallucinations No Purchased variously from friend and father, and stolen from father Two semiautomatic handguns, one rifle 9mm Glock, .22-caliber Ruger semiautomatic handguns, .22-caliber Ruger rifle white Male http://www.katu.com/news/local/8082147.html; http://www.pbs.org/wgbh/pages/frontline/shows/kinkel/kip/cron.html; http://www.oregonlive.com/special/index.ssf/2008/05/the_suspect_kipland_kinkels_da.html; http://articles.cnn.com/2000-01-21/us/kinkel.revisited_1_kip-kinkel-thurston-high-school-oregon-school-shooting?_s=PM:US http://articles.cnn.com/2000-01-21/us/kinkel.revisited_1_kip-kinkel-thurston-high-school-oregon-school-shooting?_s=PM:US 44.0462362 -123.0220289 Spree
Westside Middle School killings Jonesboro, Arkansas 3/24/98 1998 Mitchell Scott Johnson, 13, and Andrew Douglas Golden, 11, two juveniles, ambushed students and teachers as they left the school; they were apprehended by police at the scene. 5 10 15 School No Boys displayed unruly and aggressive behavior. They picked on kids and made threats about killing people. No Stolen from grandfather and father Two semiautomatic handguns, two rifles, three revolvers, two derringers FIE 380, .380-caliber Star semiautomatic handguns; .44 Magnum Ruger, .30-06 Remington 742, .30-caliber Universal M-1 carbine replica rifles; .38-caliber Charter Arms, .357-caliber Ruger Security Six, .38-caliber Smith & Wesson revolvers; .22-caliber Double Deuce Buddie two-shot, .38-caliber Davis Industries two-shot derringers white Male http://www.vpc.org/studies/wgun980324.htm http://www.nytimes.com/1998/03/29/us/from-wild-talk-and-friendship-to-five-deaths-in-a-schoolyard.html?sec=&spon=&pagewanted=all 35.8209895 -90.6682606 Mass
Connecticut Lottery shooting Newington, Connecticut 3/6/98 1998 Lottery worker Matthew Beck, 35, gunned down four bosses over a salary dispute before committing suicide. 5 1 6 Workplace Yes He had been hospitalized for psychiatric reasons and had a history of depression Yes Unknown One semiautomatic handgun 9mm semiautomatic handgun white Male http://www.nytimes.com/1998/03/07/nyregion/rampage-connecticut-overview-connecticut-lottery-worker-kills-4-bosses-then.html?pagewanted=all&src=pm; http://www.nytimes.com/2000/04/11/us/hole-in-gun-control-law-lets-mentally-ill-through.html?pagewanted=all&src=pm http://www.nytimes.com/2000/04/11/us/hole-in-gun-control-law-lets-mentally-ill-through.html?pagewanted=all&src=pm 41.6856325 -72.72983827 Mass
Caltrans maintenance yard shooting Orange, California 12/18/97 1997 Former Caltrans employee Arturo Reyes Torres, 41, opened fire at a maintenance yard after he was fired for allegedly selling government materials he'd stolen from work. He was shot dead by police. 5 2 7 Workplace No He was disgruntled after being fired. Yes B&B Gun Sales in Orange County, Calif. One rifle (assault) 7.62mm AK-47 Chinese variant semiautomatic rifle latino Male http://articles.latimes.com/1997/dec/20/news/mn-431; http://articles.latimes.com/1997/dec/22/local/me-1156; http://www.vpc.org/studies/wgun971218.htm; http://news.google.com/newspapers?id=DitZAAAAIBAJ&sjid=LEcNAAAAIBAJ&pg=6705,2243998&dq=arturo+reyes+torres+caltrans&hl=en http://articles.latimes.com/1997/dec/20/news/mn-431 33.7877944 -117.8531119 Mass
R.E. Phelon Company shooting Aiken, South Carolina 9/15/97 1997 Ex-con Hastings Arthur Wise, 43, opened fire at the R.E. Phelon Company in retaliation for being fired after an argument with a supervisor. He attempted suicide by ingesting insecticide, failed, and was executed by the state of South Carolina eight years later. 4 3 7 Workplace No An ex-con, he had been freed from prison, although he displayed violent tendencies. No Unknown One semiautomatic handgun 9mm semiautomatic handgun black Male http://www.vpc.org/studies/wgun970915.htm; http://chronicle.augusta.com/stories/1997/09/18/met_214833.shtml http://chronicle.augusta.com/stories/1997/09/18/met_214833.shtml 33.5598586 -81.721952 Mass
Fort Lauderdale revenge shooting Fort Lauderdale, Florida 2/9/96 1996 Fired city park employee Clifton McCree, 41, opened fire on former coworkers he called "racist devils" inside their municipal trailer in an act of revenge after failing a drug test. He then committed suicide. 6 1 7 Workplace Yes Co-workers complained about his threats and verbal abuse. His supervisors asked him to get a psychiatric evaluation. He lost his job, which relatives said drove his depression. Yes Unknown One semiautomatic handgun, one revolver 9mm Glock semiautomatic handgun; .32-caliber revolver black Male http://www.nytimes.com/1996/02/11/us/florida-killer-said-victims-were-racists-police-say.html; http://articles.sun-sentinel.com/1996-02-10/news/9602090635_1_million-firearms-multiple-guns-reloading http://articles.sun-sentinel.com/1996-02-11/news/9602110026_1_beach-crew-maintenance-fort-lauderdale 26.1223084 -80.1433786 Mass
Walter Rossler Company massacre Corpus Christi, Texas 4/3/95 1995 Disgruntled former metallurgist James Daniel Simpson, 28, opened fire throughout the Walter Rossler Company where he had worked before exiting the building and committing suicide. 6 0 6 Workplace No He was likely angry because he was given an assignment at work he didn't like. But acquaintances didn't know why he'd come back and kill. Yes Unknown One semiautomatic handgun, one revolver 9mm Ruger semiautomatic handgun; .32-caliber revolver Unknown Male http://web.caller.com/2000/april/03/today/local_ne/4127.html http://web.caller.com/2000/april/03/today/local_ne/4127.html 27.823713 -97.41739794 Mass
Air Force base shooting Fairchild Air Force Base, Washington 6/20/94 1994 Former airman Dean Allen Mellberg, 20, opened fire inside a hospital at the Fairchild Air Force Base before he was shot dead by a military police officer outside. 5 23 28 Military Yes He was repeatedly diagnosed with emotional problems during his two years of service. Yes Gun dealer in Spokane, Wash. One rifle (assault) MAK-90 semiautomatic rifle white Male http://articles.latimes.com/1994-06-22/news/mn-7137_1_air-force; http://www.nytimes.com/1994/06/22/us/an-airman-s-revenge-5-minutes-of-terror.html http://articles.latimes.com/1994-06-22/news/mn-7137_1_air-force 47.61864486 -117.6483587 Mass
Chuck E. Cheese's killings Aurora, Colorado 12/14/93 1993 Nathan Dunlap, 19, a recently fired Chuck E. Cheese's employee, went on a rampage through his former workplace and was arrested the following day. He now awaits execution on death row. 4 1 5 Workplace Unclear While he was in prison awaiting trial, he started acting bizarre by stripping naked and playing with his feces, apparently to avoid the death penalty. A state doctor testified that Dunlap was was faking his mental illness. Unknown Unknown One semiautomatic handgun .25-caliber semiautomatic handgun black Male http://www.denverpost.com/news/ci_20218952/aurora-chuck-e-cheese-killers-appeal-cites-mental; http://abcnews.go.com/US/auroras-massacre-victims-20-year-wait-justice/story?id=16847013; http://www.5280.com/magazine/2008/12/politics-killing?page=0,6 http://www.5280.com/magazine/2008/12/politics-killing?page=0,6 39.754713 -104.835869 Mass
Long Island Rail Road massacre Garden City, New York 12/7/93 1993 Colin Ferguson, 35, opened fire on an eastbound Long Island Rail Road train as it approached a Garden City station. He was later arrested. 6 19 25 Other Yes Psychiatrists and others said he suffered from racial paranoia and was obsessed with nonexistent conspiracies. His landlord said he had "delusions of grandeur." Yes Turner's Outdoorsman in Signal Hill, Calif. One semiautomatic handgun 9mm Ruger P89 semiautomatic handgun black Male http://www.nytimes.com/1993/12/12/nyregion/tormented-life-special-report-long-slide-privilege-ends-slaughter-train.html; http://www.vpc.org/studies/wgun931207.htm http://www.nytimes.com/1993/12/12/nyregion/tormented-life-special-report-long-slide-privilege-ends-slaughter-train.html 40.7267682 -73.6342955 Mass
Luigi's shooting Fayetteville, North Carolina 8/6/93 1993 Army Sgt. Kenneth Junior French, 22, opened fire inside Luigi's Italian restaurant while ranting about gays in the military before he was shot and arrested by police. 4 8 12 Other No He had an abusive father, who committed suicide. Yes Unknown One rifle, two shotguns .22-caliber rifle; two 12-gauge shotguns white Male http://articles.latimes.com/1993-08-08/news/mn-21847_1_kills-army-french; http://news.google.com/newspapers?id=0AhPAAAAIBAJ&sjid=jhUEAAAAIBAJ&pg=6505,2482529&dq=kenneth+junior+french&hl=en http://news.google.com/newspapers?id=0AhPAAAAIBAJ&sjid=jhUEAAAAIBAJ&pg=6505,2482529&dq=kenneth+junior+french&hl=en 35.0529931 -78.8787058 Mass
101 California Street shootings San Francisco, California 7/1/93 1993 Failed businessman Gian Luigi Ferri, 55, opened fire throughout an office building before he committed suicide inside as police pursued him. 9 6 15 Other No He was down on his luck because of failed business decisions. One acquaintance said,"He was the least likely guy you can imagine doing something like that." His ex-wife said he "hated violence." No Super Pawn and Pacific Tactical Weapons, both in Las Vegas, Nev. Three semiautomatic handguns (two assault) Two Intratec DC-9, .45-caliber Colt semiautomatic handguns white Male http://articles.latimes.com/1993-07-03/news/mn-10731_1_mortgage-business/2; http://www.motherjones.com/print/16316; http://www.vpc.org/studies/wgun930701.htm http://articles.latimes.com/1993-07-03/news/mn-10731_1_mortgage-business 37.7789601 -122.419199 Mass
Watkins Glen killings Watkins Glen, New York 10/15/92 1992 John T. Miller, 50, killed four child-support workers in a county office building before turning the gun on himself. Miller was upset about a court order garnishing his paycheck to cover overdue child-support payments. 5 0 5 Other Yes The day before the shooting, he told child-support collection office workers that he was considering suicide. He had been convicted of felonious assault for pointing a revolver at police officers responding to a domestic violence report at this girlfriend's apartment. Yes Mumford Sports in Litchfield, Ohio One semiautomatic handgun 9mm Llama semiautomatic handgun white Male http://www.nytimes.com/1992/10/17/nyregion/shooting-followed-tougher-efforts-to-collect-child-support.html?pagewanted=2&src=pm; http://www.nytimes.com/1992/10/16/nyregion/gunman-kills-4-who-collected-child-payments.html?pagewanted=all&src=pm; http://www.nytimes.com/1992/10/24/nyregion/watkins-glen-killings-called-planned.html http://www.nytimes.com/1992/10/24/nyregion/watkins-glen-killings-called-planned.html 42.3810555 -76.8705777 Mass
Lindhurst High School shooting Olivehurst, California 5/1/92 1992 Former Lindhurst High School student Eric Houston, 20, angry about various personal failings, killed three students and a teacher at the school before surrendering to police after an eight-hour standoff. He was later sentenced to death. 4 10 14 School No He suffered violent physical abuse as a child. He claimed a teacher had sexually abused him, but the truth of that allegation was contested. Yes Local gun retailer One rifle, one shotgun .22-caliber sawed-off rifle; 12-gauge pump-action shotgun white Male http://www.schoolshooters.info/PL/Subject-Houston_files/Nine%20Brief%20Sketches.pdf; http://www.appeal-democrat.com/news/school-47104-shooting-eckardt.html; http://nl.newsbank.com/nl-search/we/Archives?p_product=SB&p_theme=sb&p_action=search&p_maxdocs=200&p_topdoc=1&p_text_direct-0=0EB0D9D91FC593A0&p_field_direct-0=document_id&p_perpage=10&p_sort=YMD_date:D&s_trackval=GooglePM; http://www.sfgate.com/crime/article/Death-verdict-OKd-for-school-slaughter-3758444.php http://www.schoolshooters.info/PL/Subject-Houston_files/Nine%20Brief%20Sketches.pdf 39.07868761 -121.5475762 Mass
Royal Oak postal shootings Royal Oak, Michigan 11/14/91 1991 Laid-off postal worker Thomas McIlvane, 31, opened fire at his former workplace before committing suicide. 5 5 10 Workplace Yes Police revoked his CCW permit after determining he was mentally unstable. Yes Local gun store One rifle .22-caliber Ruger sawed-off semiautomatic rifle white Male http://www.nytimes.com/1991/11/15/us/ex-postal-worker-kills-3-and-wounds-6-in-michigan.html; http://www.mlive.com/news/detroit/index.ssf/2011/11/monday_ceremony_marks_20_years.html http://www.nytimes.com/1991/11/15/us/ex-postal-worker-kills-3-and-wounds-6-in-michigan.html 42.4894801 -83.1446485 Mass
University of Iowa shooting Iowa City, Iowa 11/1/91 1991 Former graduate student Gang Lu, 28, went on a rampage on campus and then committed suicide at the scene. 6 1 7 School Unclear He was described as darkly disturbed and isolated. Yes Fin & Feather in Iowa City, Iowa One revolver .38-caliber Taurus revolver Asian Male http://www.nytimes.com/1991/11/03/us/gunman-in-iowa-wrote-of-plans-in-five-letters.html?pagewanted=all&src=pm; http://thegazette.com/2011/11/01/gang-lu-shootings-at-ui-remembered-20-years-later/; http://www.nytimes.com/1991/11/04/us/iowa-gunman-was-torn-by-academic-challenge.html?pagewanted=2&src=pm http://www.nytimes.com/1991/11/03/us/gunman-in-iowa-wrote-of-plans-in-five-letters.html?pagewanted=all&src=pm 41.6606893 -91.5302214 Mass
Luby's massacre Killeen, Texas 10/16/91 1991 George Hennard, 35, drove his pickup truck into a Luby's cafeteria and opened fire before committing suicide. 24 20 44 Other No Acquaintances described him as troubled, unstable, combative, and misogynistic. He made convenience store employees "nervous." Yes Mike's Gun Shop in Henderson, Nev. Two semiautomatic handguns 9mm Glock 17, 9mm Ruger P89 semiautomatic handguns white Male http://www.nytimes.com/1991/10/18/us/portrait-of-texas-killer-impatient-and-troubled.html?pagewanted=all&src=pm; http://www.kwtx.com/home/headlines/7048182.html; http://www.nytimes.com/1991/10/20/weekinreview/dead-23-texans-and-1-anti-gun-measure.html; http://www.vpc.org/studies/wgun911016.htm http://www.nytimes.com/1991/10/20/weekinreview/dead-23-texans-and-1-anti-gun-measure.html; http://www.nytimes.com/1991/10/18/us/portrait-of-texas-killer-impatient-and-troubled.html?pagewanted=all&src=pm 31.1171194 -97.7277959 Mass
GMAC massacre Jacksonville, Florida 6/18/90 1990 James Edward Pough, 42, opened fire at a General Motors Acceptance Corporation office before committing suicide. (The day prior, Pough killed a pimp and prostitute and injured two others. Those victims are not included in the mass murder count.) 10 4 14 Other No Police speculated he had a "grudge" against the people he killed. Yes Unknown One rifle, one revolver .30-caliber Universal M1 carbine rifle; .38-caliber revolver black Male http://www.nytimes.com/1990/06/19/us/florida-gunman-kills-8-and-wounds-6-in-office.html; http://www.nytimes.com/1990/06/20/us/hazy-records-helped-florida-gunman-buy-arms.html; http://www.vpc.org/studies/wgun900618.htm; http://www.nytimes.com/1990/06/19/us/florida-gunman-kills-8-and-wounds-6-in-office.html?pagewanted=all&src=pm http://www.nytimes.com/1990/06/20/us/hazy-records-helped-florida-gunman-buy-arms.html 30.3321838 -81.655651 Mass
Standard Gravure shooting Louisville, Kentucky 9/14/89 1989 Joseph T. Wesbecker, 47, gunned down eight people at his former workplace before committing suicide. 9 12 21 Workplace Yes Prior to the shooting, he had voluntarily checked into hospitals for mental problems at least twice and attempted suicide three times. Yes AK-47 purchased from Tilford's Gun Sales in Louisville, Ky. Three semiautomatic handguns (two assault), one rifle (assault), one revolver Two Intratec MAC-11, 9mm SIG Sauer semiautomatic handguns; AK-47 Chinese variant semiautomatic rifle; .38-caliber revolver white Male http://nl.newsbank.com/nl-search/we/Archives?p_product=LH&s_site=kentucky&p_multi=LH&p_theme=realcities&p_action=search&p_maxdocs=200&p_topdoc=1&p_text_direct-0=0EB73C025033DC82&p_field_direct-0=document_id&p_perpage=10&p_sort=YMD_date:D&s_trackval=GooglePM; http://www.nytimes.com/1989/09/16/us/disturbed-past-of-killer-of-7-is-unraveled.html?pagewanted=all&src=pm http://www.nytimes.com/1989/09/16/us/disturbed-past-of-killer-of-7-is-unraveled.html 38.2542376 -85.759407 Mass
Stockton schoolyard shooting Stockton, California 1/17/89 1989 Patrick Purdy, 26, an alcoholic with a police record, launched an assault at Cleveland Elementary School, where many young Southeast Asian immigrants were enrolled. Purdy killed himself with a shot to the head. 6 29 35 School Yes He told a mental health professional he was "struggling to resist actions on thoughts which are destructive in nature." He also suffered from alcoholism. Yes Sandy Trading Post in Sandy, Ore.; Hunter Loan and Jewelry Co. in Stockton, Calif. One semiautomatic handgun, one rifle (assault) 9mm Taurus semiautomatic handgun; AK-47 Chinese variant semiautomatic rifle white Male http://www.recordnet.com/apps/pbcs.dll/article?AID=/20090118/A_NEWS/901170304; http://news.google.com/newspapers?id=N8IzAAAAIBAJ&sjid=kDIHAAAAIBAJ&pg=6930,6475926&dq=patrick+purdy&hl=en; http://www.time.com/time/magazine/article/0,9171,151105,00.html http://www.recordnet.com/apps/pbcs.dll/article?AID=/20090118/A_NEWS/901170304 37.9577016 -121.2907796 Mass
ESL shooting Sunnyvale, California 2/16/88 1988 Former ESL Incorporated employee Richard Farley, 39, gunned down seven people at his former workplace. He was later arrested and now sits on death row at San Quentin. 7 4 11 Workplace Yes He stalked and harassed his colleague Laura Black for four years until she was granted a temporary restraining order aginst him. Before he was fired for his bizarre behavior, he was ordered to undergo psychological counseling. Yes Various sporting goods and gun stores in Northern California Two semiautomatic handguns, one rifle, two revolvers, two shotguns .380 ACP Browning, 9mm Smith & Wesson semiautomatic handguns; Ruger M-77 .22-250 bolt-action rifle with scope; Mossberg 12-gauge pump-action, 12-gauge Benelli semiautomatic shotguns; .357 Magnum Smith & Wesson, .22 Sentinel WMR revolvers white Male http://articles.latimes.com/1988-02-18/news/mn-43514_1_mr-farley-richard-farley-sunnyvale-public-safety-department; http://news.google.com/newspapers?id=uqxAAAAAIBAJ&sjid=sDIHAAAAIBAJ&pg=2425,5898911&dq=richard+farley+shooting&hl=en; http://news.google.com/newspapers?id=FmYzAAAAIBAJ&sjid=WzIHAAAAIBAJ&pg=7028,576811&dq=richard+farley+shooting&hl=en http://books.google.com/books?id=JiQUkwBnzgYC&pg=PA44&lpg=PA44&dq=richard+farley+ESL+psychological&source=bl&ots=PqxDlDtznK&sig=K-p8vEN7M2AEdRC0KpxVHjXZN7M&hl=en#v=onepage&q=richard%20farley%20ESL%20psychological&f=false; http://caselaw.findlaw.com/ca-supreme-court/1295931.html 37.3688301 -122.0363496 Mass
Shopping centers spree killings Palm Bay, Florida 4/23/87 1987 Retired librarian William Cruse, 59, was paranoid neighbors gossiped that he was gay. He drove to a Publix supermarket, killing two Florida Tech students en route before opening fire outside and killing a woman. He then drove to a Winn-Dixie supermarket and killed three more, including two police officers. Cruse was arrested after taking a hostage and died on death row in 2009. 6 14 20 Other Yes He suffered from paranoid delusions. A judge found that he suffered from "extreme mental illness." Yes Gun store in Norwood, Ohio; The Oaks Trading Post in Melbourne, Fla. One rifle, one revolver, one shotgun Sturm, Ruger Mini-14 semiautomatic rifle; 20-gauge Winchester pump-action shotgun; .357 Ruger Blackhawk revolver white Male http://articles.latimes.com/1987-04-25/news/mn-990_1_palm-bay-police (Supreme Court of Florida Document) http://www.murderpedia.org/male.C/images/cruse_william_b/op-74656.pdf 28.0331886 -80.6429695 Spree
United States Postal Service shooting Edmond, Oklahoma 8/20/86 1986 Postal worker Patrick Sherrill, 44, opened fire at a post office before committing suicide. 15 6 21 Workplace Unclear He was worried he had inherited mental problems and rebuffed a pastor's suggestion he seek psychiatric counseling. His family members denied he had a history of mental illness. Yes Issued by Oklahoma National Guard, where Sherrill served, for target competition Three semiautomatic handguns .22-caliber, two .45-caliber Colt Model 1911-A1 semiautomatic handguns white Male http://news.google.com/newspapers?id=dm8aAAAAIBAJ&sjid=pyoEAAAAIBAJ&pg=2297,4870051&dq=patrick+sherrill&hl=en http://newsok.com/sherrill-feared-mental-illness-rejected/article/2177416 35.6672015 -97.42937037 Mass
San Ysidro McDonald's massacre San Ysidro, California 7/18/84 1984 James Oliver Huberty, 41, opened fire in a McDonald's restaurant before he was shot dead by a police officer. 22 19 41 Other Yes The day before the shooting, he tried to make an appointment at a mental health clinic. Yes Unknown One semiautomatic handgun, one rifle (assault), one shotgun 9mm Browning P35 Hi-Power semiautomatic handgun; 9mm Israeli Military Industries Uzi Model A carbine semiautomatic rifle; 12-gauge Winchester 1200 pump-action shotgun white Male http://www.utsandiego.com/san-ysidro-massacre/; http://www.vpc.org/studies/wgun840718.htm http://www.nctimes.com/news/local/article_2ba4343e-7009-54ce-98df-79a23ff8d0d7.html 32.5520013 -117.0430813 Mass
Dallas nightclub shooting Dallas, Texas 6/29/84 1984 Abdelkrim Belachheb, 39, opened fire at an upscale nightclub after a woman rejected his advances. He was later arrested. 6 1 7 Other Yes During his last meal with his wife, he confessed he was depressed and had visited psychiatric hospitals in Belgium. No Hines Boulevard Pawn Shop in Dallas, Texas One semiautomatic handgun 9mm Smith & Wesson 459 semiautomatic handgun white Male http://books.google.com/books?id=Hr3OBwP-lbUC&pg=PA38&lpg=PA38&dq=Abdelkrim+Belachheb+mental&source=bl&ots=D56pgdNnnl&sig=grAT08P9HLfPoHVgwlXt8RfPHz0&hl=en&; http://www.nytimes.com/1984/06/30/us/6-die-in-dallas-club-as-enraged-man-fires-wildly.html; http://news.google.com/newspapers?id=gKQyAAAAIBAJ&sjid=WO8FAAAAIBAJ&pg=1236,2915759&dq=abdelkrim+belachheb&hl=en; http://books.google.com/books?id=Hr3OBwP-lbUC&pg=PA67&lpg=PA67&dq=%22hine+pawnshop%22+gun&source=bl&ots=D55vgfTsnk&sig=zDxr5nohKnNQWvLrUFmZGYQ5ar4&hl=en&sa=X&ei=9WZSUN2FN-XZigKN-oGoCA&ved=0CDcQ6AEwAA#v=onepage&q=%22hine%20pawnshop%22%20gun&f=false http://books.google.com/books?id=Hr3OBwP-lbUC&pg=PA67&lpg=PA67&dq=%22hine+pawnshop%22+gun&source=bl&ots=D55vgfTsnk&sig=zDxr5nohKnNQWvLrUFmZGYQ5ar4&hl=en&sa=X&ei=9WZSUN2FN-XZigKN-oGoCA&ved=0CDcQ6AEwAA#v=onepage&q=%22hine%20pawnshop%22%20gun&f=false 32.7801052 -96.8000082 Mass
Welding shop shooting Miami, Florida 8/20/82 1982 Junior high school teacher Carl Robert Brown, 51, opened fire inside a welding shop and was later shot dead by a witness as he fled the scene. 8 3 11 Other Yes His second wife left him because he refused to seek psychological help. He had become increasingly isolated. One former student said he was "off his rocker." Yes Garcia Gun Center in Hialeah, Fla. One shotgun Mossberg 500 Persuader pump-action shotgun with pistol grip white Male http://www.nytimes.com/1982/08/21/us/gunman-in-miami-kills-8-in-rampage.html; http://www.nytimes.com/1982/08/24/us/no-charges-planned-against-miami-man-who-shot-gunman.html; http://www.nytimes.com/1982/10/14/us/florida-city-rescinds-law-on-buying-guns.html http://news.google.com/newspapers?id=uuYLAAAAIBAJ&sjid=C1kDAAAAIBAJ&pg=4879,1435085&dq=carl+robert+brown 25.796491 -80.226683 Mass
Umpqua Community College shooting Roseburg, Oregon 10/1/15 2015 10 7 17 School Unclear Unknown white Male 43.291111 -123.334722 Mass
{
"columns":[
{ "name": "Case", "type": "string" },
{ "name": "Location", "type": "string" },
{ "name": "Date", "type": "date", "format": "%m/%d/%y" },
{ "name": "Year", "type": "date", "format": "%Y" },
{ "name": "Summary", "type": "string" },
{ "name": "Fatalities", "type": "number" },
{ "name": "Injured", "type": "number" },
{ "name": "Total victims", "type": "number" },
{ "name": "Venue", "type": "string" },
{ "name": "Prior signs of possible mental illness", "type": "string" },
{ "name": "Mental Health", "type": "string" },
{ "name": "Weapons obtained legally", "type": "string" }, { "name": "Where obtained", "type": "string" },
{ "name": "Type of weapons", "type": "string" },
{ "name": "Weapon details", "type": "string" },
{ "name": "Race", "type": "string" }, { "name": "Gender", "type": "string" },
{ "name": "Sources", "type": "string" },
{ "name": "Mental Health Sources", "type": "string" },
{ "name": "latitude", "type": "number", "geo": "latitude" },
{ "name": "longitude", "type": "number", "geo": "longitude" },
{ "name": "Type", "type": "string" }
]
}
<!DOCTYPE html>
<head>
<meta charset="utf-8">
<script src="//cdnjs.cloudflare.com/ajax/libs/d3/3.5.9/d3.min.js"></script>
<script src="//curran.github.io/dsv-dataset/dsv-dataset-v0.2.1.js"></script>
</head>
<body>
<script>
function render(data){
d3.select("body")
.append("pre")
.text(JSON.stringify(data, null, 2));
}
d3.csv("data.csv", function(data){
d3.json("data.json", function(metadata){
var dataset = dsvDataset.parse({ data: data, metadata: metadata });
render(dataset.data);
});
});
</script>
</body>
@curran
Copy link
Author

curran commented Jan 15, 2023

Looks like there's an updated version of the data from Mother Jones!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment