Spreadsheet: f1a551f5-3f2f-4653-814d-58cd0c0acd37
Sheet: Weapon categories

Incident | Date | Type of weapons (all) | Semiauto handguns | Rifles | Revolvers | Shotguns
Hialeah apartment shooting | 2013-07-26 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Santa Monica rampage | 2013-06-07 00:00:00 | One rifle (assault), one handgun | 0 | 1 | 1 | 0
Pinewood Village Apartment shooting | 2013-04-21 00:00:00 | One semiautomatic handgun, one shotgun | 1 | 0 | 0 | 1
Mohawk Valley shootings | 2013-03-13 00:00:00 | One shotgun | 0 | 0 | 0 | 1
Newtown school shooting | 2012-12-14 00:00:00 | Two semiautomatic handguns, one rifle (assault), one shotgun (assault) | 2 | 1 | 0 | 1
Accent Signage Systems shooting | 2012-09-27 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Sikh temple shooting | 2012-08-05 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
[NAME] theater shooting | 2012-07-20 00:00:00 | Two semiautomatic handguns, one rifle (assault), one shotgun | 2 | 1 | 0 | 1
Seattle cafe shooting | 2012-05-20 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
Oikos University killings | 2012-04-02 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
[NAME] shooting | 2012-02-22 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Seal Beach shooting | 2011-10-14 00:00:00 | Two semiautomatic handguns, one revolver | 2 | 0 | 1 | 0
IHOP shooting | 2011-09-06 00:00:00 | Two rifles (both assault), one revolver | 0 | 2 | 1 | 0
Tucson shooting | 2011-01-08 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Hartford Beer Distributor shooting | 2010-08-03 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
Coffee shop police killings | 2009-11-29 00:00:00 | One semiautomatic handgun | 1 | 0 | 1 | 0
Fort Hood massacre | 2009-11-05 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
[NAME] shootings | 2009-04-03 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
Carthage nursing home shooting | 2009-03-29 00:00:00 | One revolver, one shotgun | 0 | 0 | 1 | 1
Atlantis Plastics shooting | 2008-06-25 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Northern Illinois University shooting | 2008-02-14 00:00:00 | Three semiautomatic handguns, one shotgun | 3 | 0 | 0 | 1
Kirkwood City Council shooting | 2008-02-07 00:00:00 | One semiautomatic handgun, one revolver | 1 | 0 | 1 | 0
Westroads Mall shooting | 2007-12-05 00:00:00 | One rifle (assault) | 0 | 1 | 0 | 0
Crandon shooting | 2007-10-07 00:00:00 | One rifle (assault) | 0 | 1 | 0 | 0
[NAME] massacre | 2007-04-16 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
Trolley Square shooting | 2007-02-12 00:00:00 | One revolver, one shotgun | 0 | 0 | 1 | 1
Amish school shooting | 2006-10-02 00:00:00 | One semiautomatic handgun, one rifle, one shotgun | 1 | 1 | 0 | 1
Capitol Hill massacre | 2006-03-25 00:00:00 | Two semiautomatic handguns, one rifle (assault), one shotgun | 2 | 1 | 0 | 1
Goleta postal shootings | 2006-01-30 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Red Lake massacre | 2005-03-21 00:00:00 | Two semiautomatic handguns, one shotgun | 2 | 0 | 0 | 1
Living Church of God shooting | 2005-03-12 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
[NAME] show shooting | 2004-12-08 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Lockheed Martin shooting | 2003-07-08 00:00:00 | One semiautomatic handgun, two rifles, one derringer, one shotgun | 1 | 2 | 1 | 1
[NAME] shooting | 2001-02-05 00:00:00 | Two rifles, one revolver, one shotgun | 0 | 2 | 1 | 1
Wakefield massacre | 2000-12-26 00:00:00 | One semiautomatic handgun, one rifle (assault), one shotgun | 1 | 1 | 0 | 1
Hotel shooting | 1999-12-30 00:00:00 | One semiautomatic handgun, one revolver | 1 | 0 | 1 | 0
Xerox killings | 1999-11-02 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Wedgwood Baptist Church shooting | 1999-09-15 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
Atlanta day trading spree killings | 1999-07-29 00:00:00 | Three semiautomatic handguns, one revolver | 3 | 0 | 1 | 0
Columbine High School massacre | 1999-04-20 00:00:00 | One semiautomatic handgun (assault), one rifle (assault), two shotguns | 1 | 1 | 0 | 2
Thurston High School shooting | 1998-05-21 00:00:00 | Two semiautomatic handguns, one rifle | 2 | 1 | 0 | 0
Westside Middle School killings | 1998-03-24 00:00:00 | Two semiautomatic handguns, two rifles, three revolvers, two derringers | 2 | 2 | 5 | 0
Connecticut Lottery shooting | 1998-03-06 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Caltrans maintenance yard shooting | 1997-12-18 00:00:00 | One rifle (assault) | 0 | 1 | 0 | 0
R.E. Phelon Company shooting | 1997-09-15 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Fort Lauderdale revenge shooting | 1996-02-09 00:00:00 | One semiautomatic handgun, one revolver | 1 | 0 | 1 | 0
Walter Rossler Company massacre | 1995-04-03 00:00:00 | One semiautomatic handgun, one revolver | 1 | 0 | 1 | 0
Air Force base shooting | 1994-06-20 00:00:00 | One rifle (assault) | 0 | 1 | 0 | 0
[NAME] killings | 1993-12-14 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Long Island Rail Road massacre | 1993-12-07 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Luigi's shooting | 1993-08-06 00:00:00 | One rifle, two shotguns | 0 | 1 | 0 | 2
101 California Street shootings | 1993-07-01 00:00:00 | Three semiautomatic handguns (two assault) | 3 | 0 | 0 | 0
[NAME] killings | 1992-10-15 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Lindhurst High School shooting | 1992-05-01 00:00:00 | One rifle, one shotgun | 0 | 1 | 0 | 1
Royal Oak postal shootings | 1991-11-14 00:00:00 | One rifle | 0 | 1 | 0 | 0
University of Iowa shooting | 1991-11-01 00:00:00 | One revolver | 0 | 0 | 1 | 0
[NAME]'s massacre | 1991-10-16 00:00:00 | Two semiautomatic handguns | 2 | 0 | 0 | 0
GMAC massacre | 1990-06-18 00:00:00 | One rifle, one revolver | 0 | 1 | 1 | 0
Standard Gravure shooting | 1989-09-14 00:00:00 | Three semiautomatic handguns (two assault), one rifle (assault), one revolver | 3 | 1 | 1 | 0
[NAME] schoolyard shooting | 1989-01-17 00:00:00 | One semiautomatic handgun, one rifle (assault) | 1 | 1 | 0 | 0
ESL shooting | 1988-02-16 00:00:00 | Two semiautomatic handguns, one rifle, two revolvers, two shotguns | 2 | 1 | 2 | 2
Shopping centers spree killings | 1987-04-23 00:00:00 | One rifle, one revolver, one shotgun | 0 | 1 | 1 | 1
United States Postal Service shooting | 1986-08-20 00:00:00 | Three semiautomatic handguns | 3 | 0 | 0 | 0
[NAME] McDonald's massacre | 1984-07-18 00:00:00 | One semiautomatic handgun, one rifle (assault), one shotgun | 1 | 1 | 0 | 1
Dallas nightclub shooting | 1984-06-29 00:00:00 | One semiautomatic handgun | 1 | 0 | 0 | 0
Welding shop shooting | 1982-08-20 00:00:00 | One shotgun | 0 | 0 | 0 | 1
 |  |  | #VALUE!:blankIndicator: | #VALUE!:blankIndicator: | #VALUE!:blankIndicator: