curran/README.md

## README.md

      
    Raw
  

              README.md
            
          
    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


## data.csv

          
            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

## data.json
{
  "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" }
  ]
}

## index.html
<!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>

## thumbnail.png

      
    Raw
  

              thumbnail.png
	{
	"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>