Spreadsheet: 6dd3e6cd-de79-47ad-b47f-8f8cbc16c57d
Sheet: US mass shootings

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
Washington Navy Yard shooting | Washington, D.C. | 2013-09-16 00:00:00 | 2013 | [NAME], 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 | Other | 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 | 2013-07-26 00:00:00 | 2013 | [NAME], 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 | [NAME]    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.2914626814829 | Mass
Santa Monica rampage | Santa Monica, California | 2013-06-07 00:00:00 | 2013 | [NAME], 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.494754033795 | Spree
Pinewood Village Apartment shooting | Federal Way, Washington | 2013-04-21 00:00:00 | 2013 | [NAME], 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 | 2013-03-13 00:00:00 | 2013 | [NAME], 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 | [NAME]'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.257206 | -74.850712 | Spree
Newtown school shooting | Newtown, Connecticut | 2012-12-14 00:00:00 | 2012 | [NAME], 20, shot his mother dead at their home then drove to [NAME] school. He forced his way inside and opened fire, killing 20 children and six adults before committing suicide. | 28 | 2 | 30 | School | Unclear | His older brother told authorities [NAME] had a history of mental problems. One neighbor recalled that he took some kind of medication. | No | Stolen from mother | Two semiautomatic handguns, one rifle (assault), one shotgun (assault) | 10mm Glock, 9mm SIG [NAME] 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; [NAME] | http://usnews.nbcnews.com/_news/2012/12/14/15911025-authorities-id-gunman-who-killed-27-in-elementary-school-massacre?lite; [NAME] | 41.4123225 | -73.3114235802945 | Mass
Accent Signage Systems shooting | Minneapolis, Minnesota | 2012-09-27 00:00:00 | 2012 | [NAME], 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 | 2012-08-05 00:00:00 | 2012 | U.S. Army veteran [NAME], 40, opened fire in a [NAME] 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
[NAME] theater shooting | [NAME], Colorado | 2012-07-20 00:00:00 | 2012 | [NAME], 24, opened fire in a movie theater during the opening night of "The Dark Night 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.70689 | -104.820735 | Mass
Seattle cafe shooting | Seattle, Washington | 2012-05-20 00:00:00 | 2012 | [NAME], 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 | 2012-04-02 00:00:00 | 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
[NAME] shooting | Norcross, Georgia | 2012-02-22 00:00:00 | 2012 | [NAME], 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 | 2011-10-14 00:00:00 | 2011 | [NAME], 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; [NAME] | http://laist.com/2011/10/13/seal_beach_shooter_suffered_from_ptsd.php | 33.741176 | -118.1046356 | Mass
IHOP shooting | Carson City, Nevada | 2011-09-06 00:00:00 | 2011 | [NAME], 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 | [NAME] Arms variant, [NAME] variant automatic rifles; .38-caliber Colt revolver | Latino | Male | http://www.huffingtonpost.com/2011/11/03/eduardo-sencion-ihop-shooter_n_1073677.html; [NAME]; http://www.lasvegassun.com/news/2011/oct/23/nv-gun-laws-rampage-2nd-ld-writethru/ | [NAME] | 39.1637984 | -119.7674034 | Mass
Tucson shooting | Tucson, Arizona | 2011-01-08 00:00:00 | 2011 | [NAME], 22, opened fire outside a Safeway during a constituent meeting with Congresswoman [NAME] (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 | 2010-08-03 00:00:00 | 2010 | [NAME], 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 | 2009-11-29 00:00:00 | 2009 | [NAME], 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 [NAME]. | 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 | 2009-11-05 00:00:00 | 2009 | Army psychiatrist [NAME], 39, opened fire on an Army base in an attack linked to Islamist extremism. [NAME] was injured during the attack and later arrested. | 13 | 30 | 43 | Other | 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 [NAME]'s aloof and erratic behavior and extremist Islamic views. | Yes | [NAME] in Kileen, Texas | One semiautomatic handgun | FN Five-seveN semiautomatic handgun | white | 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.771569956927 | Mass
[NAME] shootings | Binghamton, New York | 2009-04-03 00:00:00 | 2009 | [NAME], 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 | 2009-03-29 00:00:00 | 2009 | [NAME], 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 | 2008-06-25 00:00:00 | 2008 | Disgruntled employee [NAME], 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 | 2008-02-14 00:00:00 | 2008 | [NAME], 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 [NAME] SIG [NAME] 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 | 2008-02-07 00:00:00 | 2008 | [NAME]" [NAME], 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 | [NAME]; 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 | [NAME] | 38.5833862 | -90.406785 | Mass
Westroads Mall shooting | Omaha, Nebraska | 2007-12-05 00:00:00 | 2007 | [NAME], 19, opened fire inside [NAME] 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 | 2007-10-07 00:00:00 | 2007 | Off-duty sheriff's deputy [NAME], 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 | [NAME]; [NAME] | [NAME] | 45.5719072 | -88.9028922 | Mass
[NAME] massacre | Blacksburg, Virginia | 2007-04-16 00:00:00 | 2007 | [NAME] student [NAME], 23, opened fire on his school's campus before committing suicide. | 33 | 23 | 56 | School | Yes | A district court ruled [NAME] was "an imminent danger" to himself and others as a result of mental illness two years earlier, and directed [NAME] 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; [NAME]; 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 | 2007-02-12 00:00:00 | 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 [NAME]'s Fast Cash in West Valley City, Utah and individuals | One revolver, one shotgun | [NAME] 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 | 2006-10-02 00:00:00 | 2006 | [NAME], 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, [NAME]. | 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 | [NAME] | 40.01846345 | -76.2336528617194 | Mass
Capitol Hill massacre | Seattle, Washington | 2006-03-25 00:00:00 | 2006 | [NAME], 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.6038321 | -122.3300624 | Mass
Goleta postal shootings | Goleta, California | 2006-01-30 00:00:00 | 2006 | Former postal worker [NAME], 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.871440559809 | Spree
Red Lake massacre | Red Lake, Minnesota | 2005-03-21 00:00:00 | 2005 | [NAME], 16, murdered his grandfather, who was a police officer, and grandfather's girlfriend. [NAME] 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 [NAME]. | 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; [NAME]; [NAME]; 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 | 2005-03-12 00:00:00 | 2005 | Living Church of God member [NAME], 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; [NAME]; 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
[NAME] show shooting | Columbus, Ohio | 2004-12-08 00:00:00 | 2004 | [NAME], 25, possibly upset about the breakup of Pantera, gunned down former Pantera guitarist [NAME] and three others at a [NAME] 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 | 2003-07-08 00:00:00 | 2003 | Assembly line worker [NAME], 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 [NAME] 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; [NAME]; 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.6897800234601 | Mass
[NAME] shooting | Melrose Park, Illinois | 2001-02-05 00:00:00 | 2001 | Fired employee [NAME], 66, opened fire at his former [NAME] 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 | 2000-12-26 00:00:00 | 2000 | [NAME], 42, opened fire on co-workers at Edgewater Technology and was later arrested. | 7 | 0 | 7 | Workplace | Yes | Psychiatrist guessed he had schizophrenia, but [NAME] 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; [NAME] | 42.506484 | -71.0728306 | Mass
Hotel shooting | Tampa, Florida | 1999-12-30 00:00:00 | 1999 | Hotel employee [NAME], 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 | 1999-11-02 00:00:00 | 1999 | [NAME], 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 | [NAME]; http://www.vpc.org/studies/wgun991102.htm | [NAME] | 21.3255125 | -157.847305493679 | Mass
Wedgwood Baptist Church shooting | Fort Worth, Texas | 1999-09-15 00:00:00 | 1999 | [NAME], 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; [NAME]; http://www.vpc.org/studies/wgun990915.htm | [NAME] | 32.693397 | -97.4706709166667 | Mass
Atlanta day trading spree killings | Atlanta, Georgia | 1999-07-29 00:00:00 | 1999 | Day trader [NAME], 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 [NAME] 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; [NAME]; 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 | 1999-04-20 00:00:00 | 1999 | [NAME], 18, and [NAME], 17, opened fire throughout Columbine High School before committing suicide. | 15 | 24 | 39 | School | Yes | [NAME] was an alleged psychopath; [NAME] 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 | [NAME]; 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.987727336286 | Mass
Thurston High School shooting | Springfield, Oregon | 1998-05-21 00:00:00 | 1998 | After he was expelled for having a gun in his locker, [NAME], 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; [NAME]; http://www.oregonlive.com/special/index.ssf/2008/05/the_suspect_kipland_kinkels_da.html; [NAME] | 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 | 1998-03-24 00:00:00 | 1998 | Mitchell [NAME], 13, and [NAME], 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.66826059874 | Mass
Connecticut Lottery shooting | Newington, Connecticut | 1998-03-06 00:00:00 | 1998 | Lottery worker [NAME], 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 | 9[NAME] 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.7298382724899 | Mass
Caltrans maintenance yard shooting | Orange, California | 1997-12-18 00:00:00 | 1997 | Former Caltrans employee [NAME], 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 | 1997-09-15 00:00:00 | 1997 | Ex-con [NAME], 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 | 9[NAME] semiautomatic handgun | black | Male | http://www.vpc.org/studies/wgun970915.htm; [NAME] | http://chronicle.augusta.com/stories/1997/09/18/met_214833.shtml | 33.5598586 | -81.721952 | Mass
Fort Lauderdale revenge shooting | Fort Lauderdale, Florida | 1996-02-09 00:00:00 | 1996 | Fired city park employee [NAME], 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 | 1995-04-03 00:00:00 | 1995 | Disgruntled former metallurgist [NAME], 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 | [NAME] | [NAME] | 27.823713 | -97.4173979435294 | Mass
Air Force base shooting | [NAME], Washington | 1994-06-20 00:00:00 | 1994 | Former airman [NAME], 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 | Other | 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.618644861959 | -117.648358734953 | Mass
[NAME] killings | [NAME], Colorado | 1993-12-14 00:00:00 | 1993 | [NAME], 19, a recently fired [NAME] 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 [NAME] 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 | 1993-12-07 00:00:00 | 1993 | [NAME], 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 [NAME] in Signal Hill, Calif. | One semiautomatic handgun | 9mm Ruger [NAME] 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 | [NAME] | 40.7267682 | -73.6342955 | Mass
Luigi's shooting | Fayetteville, North Carolina | 1993-08-06 00:00:00 | 1993 | Army Sgt. [NAME], 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 | 1993-07-01 00:00:00 | 1993 | Failed businessman [NAME], 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
[NAME] killings | [NAME], New York | 1992-10-15 00:00:00 | 1992 | [NAME], 50, killed four child-support workers in a county office building before turning the gun on himself.  [NAME] 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 | 1992-05-01 00:00:00 | 1992 | Former Lindhurst High School student [NAME], 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; [NAME]; 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.078687605881 | -121.547576173493 | Mass
Royal Oak postal shootings | [NAME], Michigan | 1991-11-14 00:00:00 | 1991 | Laid-off postal worker [NAME], 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 | 1991-11-01 00:00:00 | 1991 | Former graduate student [NAME], 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/; [NAME] | [NAME] | 41.6606893 | -91.5302214 | Mass
[NAME]'s massacre | Killeen, Texas | 1991-10-16 00:00:00 | 1991 | [NAME], 35, drove his pickup truck into a [NAME]'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 | [NAME]'s Gun Shop in Henderson, Nev. | Two semiautomatic handguns | 9mm Glock 17, 9mm Ruger [NAME] semiautomatic handguns | white | Male | http://www.nytimes.com/1991/10/18/us/portrait-of-texas-killer-impatient-and-troubled.html?pagewanted=all&src=pm; [NAME]; 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; [NAME] | 31.1171194 | -97.7277959 | Mass
GMAC massacre | Jacksonville, Florida | 1990-06-18 00:00:00 | 1990 | [NAME], 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; [NAME]; 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 | 1989-09-14 00:00:00 | 1989 | [NAME], 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 | [NAME] 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 [NAME] semiautomatic handguns; [NAME] 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; [NAME] | http://www.nytimes.com/1989/09/16/us/disturbed-past-of-killer-of-7-is-unraveled.html | 38.2542376 | -85.759407 | Mass
[NAME] schoolyard shooting | Stockton, California | 1989-01-17 00:00:00 | 1989 | [NAME], 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; [NAME] 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 | 1988-02-16 00:00:00 | 1988 | Former ESL Incorporated employee [NAME], 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 [NAME] 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 [NAME], 9mm Smith & Wesson semiautomatic handguns; Ruger [NAME]250 bolt-action rifle with scope; [NAME] 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 | 1987-04-23 00:00:00 | 1987 | Retired librarian [NAME], 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 | 1986-08-20 00:00:00 | 1986 | Postal worker [NAME], 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 [NAME] 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.4293703650031 | Mass
[NAME] McDonald's massacre | San Ysidro, California | 1984-07-18 00:00:00 | 1984 | [NAME], 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 | 1984-06-29 00:00:00 | 1984 | [NAME], 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 | 1982-08-20 00:00:00 | 1982 | Junior high school teacher [NAME], 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 | [NAME] in Hialeah, Fla. | One shotgun | [NAME] 500 [NAME] pump-action shotgun with pistol grip | white | Male | http://www.nytimes.com/1982/08/21/us/gunman-in-miami-kills-8-in-rampage.html; [NAME]; 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