Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2019

The Print Procedure

statecode=AK

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AK

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Anchorage, AK 07MAR2019 Dylan Aikey 23 White male gun shoot foot No No
Anchorage, AK 01APR2019 Bishar Hassan 31 Black male replica threat foot Yes No
Anchorage, AK 26AUG2019 Kevin Phoummany 38 Asian male gun shoot not Yes No
Fairbanks, AK 13FEB2019 Garrett James Ebenal 28 White male gun point not No No
Fairbanks, AK 31MAR2019 Kevin Ray McEnulty 25 Native American male gun threat car No No
Fairbanks, AK 16JUN2019 Shawn Ray Wilson 48 White male gun shoot not No No
Juneau, AK 29DEC2019 Kelly Michael Stephens 34 White male other threat not No No

statecode=AL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Birmingham, AL 15JUN2019 Jamarcus Dejun Moore 28 Black male gun shoot car No No
Birmingham, AL 17JUL2019 Roderick Wilson 35 Black male gun shoot foot No No
Eclectic, AL 10JAN2019 Johnny Lee Burney 70 Black male gun threat not No No
Gordo, AL 28AUG2019 Wallace Wilder 62 Black male knife threat   Yes No
Hanceville, AL 04AUG2019 Robert Clay Wilsford Sr. 65 White male gun shoot not Yes No
Huntsville, AL 30MAY2019 Crystal Danielle Ragland 32 Black female gun point not Yes No
Madison, AL 27OCT2019 Dana Sherrod Fletcher 39 Black male gun point not No Yes
Millbrook, AL 03JAN2019 Jae Wesley Hardy 27 Black male gun threat car No No
Ozark, AL 12DEC2019 Bradley Cutchens 23 White male gun shoot not Yes No
Ranburne, AL 22JUL2019 John David Brown Jr. 53 White male gun shoot not Yes No
Semmes, AL 10DEC2019 Terrence Edward White 66 White male gun shoot not Yes No

statecode=AR

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AR

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bentonville, AR 06DEC2019 Dominick Matt 17 Black male gun threat not No No
Blytheville, AR 07APR2019 Marzeus Scott 35 Black male unarmed attack foot Yes Yes
Bryant, AR 23DEC2019 Austin Chase Swindle 24 White male gun shoot not Yes No
Fayetteville, AR 07DEC2019 London T. Phillips 35 White male gun shoot not No No
Formosa, AR 14AUG2019 William Lloyd Jones 49   male gun point not No No
Forrest City, AR 31DEC2019 Michael D. Moore 23   male gun attack   No No
Helena, AR 27AUG2019 Raymond Lewis Williams Jr. 37 Black male gun shoot   No No
Jacksonville, AR 13JUN2019 Tramon Savage 22 Black male vehicle attack car No No
Jacksonville, AR 07JUL2019 Thomas Graham 61 White male knife attack not Yes No
Jonesboro, AR 07MAR2019 Rodney Fisher 47 White male gun threat not No No
Jonesboro, AR 05JUN2019 Jay Clem   White male gun threat not Yes No
Little Rock, AR 22FEB2019 Bradley Blackshire 30 Black male vehicle attack car No Yes
Little Rock, AR 21APR2019 Michael St. Clair 42 White male gun shoot foot No No
Lowell, AR 05AUG2019 Derrick Davidson 56 White male gun undetermined not Yes No
Lowell, AR 23SEP2019 Charles Nation 31 White male unknown threat not No No
Pine Bluff, AR 11OCT2019 Matthew Abrams 40   male gun point foot No No
Shirley, AR 09JUN2019 William James Back 41 White male gun shoot not No No
Stone County, AR 18JUL2019 Samuel Fullerton 39   male gun shoot   No No
Warren, AR 17OCT2019 Christopher DeQuan Crosby 34 Black male gun shoot car No No
West Memphis, AR 16JAN2019 D'Angelo Brown   Black male vehicle threat car No No
West Memphis, AR 16JAN2019 Megan Rivera   White female vehicle threat car No No

statecode=AZ

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AZ

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Ahwatukee, AZ 11APR2019 Theresa Medina-Thomas 29 Hispanic female vehicle flee car No No
Buckeye, AZ 09MAR2019 Jose German 40   male gun shoot car No No
Buckeye, AZ 12APR2019 Juan Torres 39 Hispanic male blunt_object attack not Yes Yes
Buckeye, AZ 13OCT2019 Jose Eduardo Flores 26 Hispanic male gun shoot   No No
Ehrenberg, AZ 24JAN2019 Christian Albarran 26 Hispanic male unarmed move car No No
Flagstaff, AZ 23JAN2019 Preston Oszust 20 White male unarmed undetermined foot No No
Flagstaff, AZ 23JAN2019 Marcus Gishal 20 Hispanic male gun shoot foot No No
Flagstaff, AZ 02FEB2019 Henry Harold Russell 47 White male knife attack not Yes Yes
Glendale, AZ 13OCT2019 Levy Isacc Madueno Santibanez 17 Hispanic male gun shoot not No No
Glendale, AZ 04NOV2019 Matthew Rasmussen 31 White male knife attack not Yes Yes
Globe, AZ 31DEC2019 Eric M. Tellez 28 White male knife threat not No No
Marana, AZ 31MAR2019 Juan Padilla 24 Hispanic male knife attack not No No
Mesa, AZ 06MAY2019 Pedro Colazo-villa 33 Hispanic male gun threat not No No
Mesa, AZ 16NOV2019 Garrett Ryberg 27 White male gun point not No No
Mesa, AZ 02DEC2019 Neil Chiago Jr. 18 Native American male gun point not No No
Parks, AZ 11MAY2019 Paul Mcvicker 43   male gun move car No No
Phoenix, AZ 11JAN2019 Jacob Michael Harris 19 Black male gun threat not No No
Phoenix, AZ 30JAN2019 Michael Joe Jolls 47 White male gun point foot No No
Phoenix, AZ 09MAR2019 Eric Hagstrom 35 White male gun point not No No
Phoenix, AZ 13MAR2019 Henry Wayne Rivera 30 Hispanic male unarmed flee other No No
Phoenix, AZ 28MAR2019 Eugene Horn 43 White male gun point foot No No
Phoenix, AZ 29APR2019 Alejandro Hernandez 26 Hispanic male replica point foot No No
Phoenix, AZ 04MAY2019 Jason Demarcus Larkin 35 White male knife point not No No
Phoenix, AZ 09MAY2019 Hector Lopez 29 Hispanic male gun point not No No
Phoenix, AZ 19MAY2019 Robert Rabago 17 Hispanic male gun shoot foot No No
Phoenix, AZ 09SEP2019 Hector Miranda 47 Hispanic male gun;knife point not No No
Phoenix, AZ 03NOV2019 Michael Austin 32 Black male gun shoot not No No
Phoenix, AZ 23DEC2019 Richard Ruiz 38 Hispanic male gun;vehicle shoot car No No
Tempe, AZ 15JAN2019 Antonio Arce 14 Hispanic male replica threat foot No Yes
Tempe, AZ 20DEC2019 Mohamed Ahemed Al-Hashemi 25 Black male other attack not No No
Tolleson, AZ 30AUG2019 Rene Enrique Ruiz 51 Hispanic male gun;vehicle attack other No No
Tonalea, AZ 18MAY2019 Dion Grey Hat 27 Native American male undetermined undetermined   No No
Tucson, AZ 16JUN2019 Carlos Vale 31 Hispanic male gun attack   No No
Tucson, AZ 11OCT2019 David Doyle 56   male gun shoot not Yes No
Tucson, AZ 14DEC2019 Victor A. Parsons 42 White male gun shoot not No No

statecode=CA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=CA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Adelanto, CA 10JUL2019 Darrell Allen 32 Black male knife attack foot No No
Anaheim, CA 04APR2019 Daniel Robert Ramirez III 30 Hispanic male gun threat not No No
Anaheim, CA 05JUL2019 Hannah Williams 17 White female replica point not Yes Yes
Anaheim, CA 12DEC2019 Taveonte Art Emmanuel 34 Black male gun threat not No Yes
Anderson, CA 01JUN2019 Nikolai Landry 27 White male gun move not No No
Ashland, CA 13MAR2019 Charles Ballard 41 Black male vehicle attack car No Yes
Bakersfield, CA 08FEB2019 Aaron Allen Przekop 25 White male unarmed threat not No No
Bakersfield, CA 05MAR2019 Stephanie Areanda Quiroz 21 Hispanic female unarmed accident car No No
Bakersfield, CA 09JUL2019 Anthony James Gonzales 36 Hispanic male undetermined undetermined not No No
Bakersfield, CA 05AUG2019 Marvin Alexis Urbina 19 Hispanic male vehicle move car No No
Bakersfield, CA 28DEC2019 Heriberto Rodriguez 27 Hispanic male unknown attack not No No
Banning, CA 07FEB2019 Nolan Hurtzig 29 White male undetermined undetermined   No No
Beaumont, CA 09AUG2019     male knife attack not No No
Big Sur, CA 22JUN2019 Kevin Anthony Alaniz 26 Hispanic male gun shoot   No No
Butte County, CA 28JAN2019 Richard Moulton 52   male gun point car No No
Calabasas, CA 13JAN2019 Dimas Diaz Jr. 38 Hispanic male unarmed flee car No No
Carmichael, CA 27OCT2019 Earnest Easterling 25 Black male gun shoot not No No
Carson, CA 22OCT2019 Dominador Araquel Rabot 55 Asian male knife threat not No No
Cathedral City, CA 13JAN2019 Roberto Tapia 28 Hispanic male gun shoot not No No
Chino, CA 03JUL2019 Li Xi Wang 49 Asian male unarmed threat not No Yes
Chino Hills, CA 16JUL2019 Jose Javier Gonzalez 52 Hispanic male knife attack not No No
Citrus Heights, CA 09JUL2019 Grayson Schuessler 26 White male gun shoot   No No
Clearlake Oaks, CA 28DEC2019 Craig Ellis See 34 White male knife attack foot No No
Concord, CA 01DEC2019 Donald James Eversen 60 White male knife attack not Yes Yes
Davis, CA 19DEC2019 Christopher Gray 29 White male knife attack not Yes Yes
Delano, CA 14JUN2019     male undetermined undetermined foot No No
El Centro, CA 29DEC2019 Manuel Gonzales Verdugo 51 Hispanic male knife threat not No No
El Cerrito, CA 24AUG2019 Dennis Carolino 52 Hispanic male blunt_object attack not Yes Yes
El Monte, CA 12OCT2019 Sawandi Asad Toussaint 21 Black male gun point foot No No
Escalon, CA 05JUN2019 Matthew Freeseha Jr. 39 White male gun shoot not No No
Fremont, CA 18APR2019 Michael Allen Felch 30 White male gun shoot not No Yes
Fresno, CA 05JAN2019 Oliver Hernandez 29 Hispanic male blunt_object threat not No No
Fresno, CA 12FEB2019 Johnny Mathis 46 White male gun shoot not No No
Fresno, CA 08JUN2019 Krystal Arvizu 33 Hispanic female blunt_object attack not Yes Yes
Fresno, CA 30OCT2019 Billy Kongphouthakhoun 24 Asian male gun threat not No No
Fullerton, CA 19AUG2019     male vehicle attack car No Yes
Garden Grove, CA 18MAY2019 Andrew Giovanni Meza 20 Hispanic male knife attack not Yes No
Gardena, CA 13MAY2019 Malik Ali Gresham 36 Black male knife attack not No Yes
Glen Valley, CA 06JAN2019     male knife threat not No No
Glendora, CA 06SEP2019 Vondarrow Dewayne Fisher 42 Black male gun move foot No No
Goleta, CA 07MAY2019 Francisco Anthony Alcaraz Jr. 32 Hispanic male gun shoot not No No
Herald, CA 06OCT2019 55   male gun move not No No
Hesperia, CA 10DEC2019 Mauro Carrillo 42 Hispanic male blunt_object attack not No No
Hope Ranch, CA 15OCT2019 Cameron Ely 30 White male unarmed threat not No No
Huron, CA 19MAY2019 Esteban Martinez 59 Hispanic male unknown attack not No No
Imperial County, CA 26OCT2019     male blunt_object threat foot No No
Indio, CA 10APR2019 Anthony Santana 21 Hispanic male gun threat not No No
Inglewood, CA 27MAR2019 Brian Leslie Statler 30 Black male knife threat not No No
La Habra, CA 26SEP2019     male vehicle attack car No No
Lake Elsinore, CA 16NOV2019     male unknown threat not No No
Lancaster, CA 30OCT2019 Ricardo Myers 62 White male blunt_object threat not No No
Lemon Grove, CA 05JAN2019 Adolfo Gonzalez 28 Hispanic male gun threat not No No
Lemoore, CA 25APR2019 Blayne Erwin Morris 23   male gun point car No No
Linda, CA 14JAN2019 Jahmal Derrick Stewart 45 Black male gun attack not No No
Long Beach, CA 19SEP2019 Jordan Michael Griffin 18 Black male replica point not No No
Long Beach, CA 23OCT2019 Delfon Kinney Sr. 44 Black male gun shoot not No Yes
Los Angeles, CA 14FEB2019 Wilfredo Hernandez 47 Hispanic male knife move not No No
Los Angeles, CA 14APR2019 William Crawford 47 White male gun undetermined foot No No
Los Angeles, CA 22APR2019 David Flores Ramos 32 Hispanic male gun shoot   No Yes
Los Angeles, CA 30APR2019 Emilio Robles 48 Hispanic male gun shoot foot No No
Los Angeles, CA 21MAY2019 Juan Antonio Sillas 21 Hispanic male blunt_object threat   No No
Los Angeles, CA 06JUN2019 Ryan Twyman 24 Black male unarmed flee car No No
Los Angeles, CA 06JUN2019 Jose De Santiago Media 41 Hispanic male knife threat not No Yes
Los Angeles, CA 06JUN2019 Edtwon Stamps 27 Black male gun threat not No No
Los Angeles, CA 27JUN2019 Paul David Rea 18 Hispanic male unarmed accident not No No
Los Angeles, CA 01AUG2019 Jamaal Simpson 21 Black male gun shoot foot No No
Los Angeles, CA 18AUG2019 Roberto Rene Gabriel 33 Hispanic male gun shoot foot No Yes
Los Angeles, CA 19AUG2019 Carlos Torres 39 Hispanic male gun shoot foot No No
Los Angeles, CA 23SEP2019 Raymond Hernandez 63 Hispanic male gun threat   No No
Los Angeles, CA 06OCT2019 Antonio Vasquez 37 Hispanic male knife threat not Yes No
Los Angeles, CA 10OCT2019 Michael Uccello 48 White male vehicle threat car No No
Los Angeles, CA 13NOV2019 Omar Enrique Garcia 37 Hispanic male knife threat foot No No
Los Angeles, CA 19NOV2019 Alex Flores 34 Hispanic male knife threat   No No
Los Angeles, CA 20NOV2019 Jessica Ann Beedles 42 White female gun threat not No No
Los Angeles, CA 25NOV2019 Nathaniel Pinnock 22 Black male knife;vehicle attack foot No Yes
Los Angeles, CA 02DEC2019 Dai Phuoc Nguyen 38 Asian male knife threat   No No
Los Angeles, CA 16DEC2019 Jorge Serrano 25 Hispanic male gun shoot foot No No
Madera, CA 07FEB2019 Michael Robert Novak 58 White male knife point not Yes Yes
Menifee, CA 09JUN2019 Ysidro Osornio-Velasquez 32 Hispanic male gun shoot car No No
Modesto, CA 21MAR2019 Daishawn Brown 19 Black male gun undetermined car No No
Modesto, CA 06JUN2019 Jose Jesus Astorga Jr.   Hispanic male gun attack not No No
Modesto, CA 17JUL2019 Stephen Murray 52 Black male replica attack not No Yes
Modesto, CA 29NOV2019 Raymond Lee 54 White male replica point   No Yes
Montebello, CA 09MAY2019 Eddie Herrera 49 Hispanic male gun shoot not No No
Napa Valley, CA 17FEB2019 Javier Hernandez Morales 48 Hispanic male gun shoot not No Yes
Oak View, CA 05JUL2019 Joshua Ortiz 21 White male unarmed attack not No No
Ontario, CA 30MAY2019 Araceli Arias   Hispanic female gun;knife threat not Yes Yes
Orange, CA 12DEC2019 Erik George Lee 43 Asian male knife move not Yes Yes
Palmdale, CA 16MAR2019 Timothy John Beckwith 48 White male gun shoot not No No
Pasadena, CA 17MAY2019 Daniel Warren 36 Black male gun shoot not No Yes
Perris, CA 30APR2019     male knife threat not No No
Porterville, CA 27OCT2019 Arturo Moreno 42 Hispanic male blunt_object attack not Yes No
Rancho Mirage, CA 04MAR2019 Stephen Kaylor 63 White male gun shoot   Yes No
Rancho Mirage, CA 09JUL2019 Jason Harris 36   male knife attack not Yes Yes
Red Bluff, CA 14APR2019 Henry Lane 42 Native American male blunt_object threat foot Yes No
Redding, CA 11FEB2019 Phayvanh Inthavong 32 Asian male gun point foot No No
Redding, CA 10MAR2019 Brandon Robertson 34 Native American male gun shoot foot No No
Redding, CA 02APR2019 Donnell James Lang 48 White male unarmed attack not Yes No
Redding, CA 22DEC2019 Jesse Adams 34 White male gun shoot not No No
Richmond, CA 12APR2019 Luc Ciel 54 Asian male knife attack not No No
Riverside, CA 11JUN2019 Thomas Ray Berry 52   male gun shoot not No No
Riverside, CA 12AUG2019 Aaron Luther 49 White male gun shoot not No No
Roseville, CA 15JAN2019 Stanley Stepanski III 48 White male gun shoot car No No
Sacramento, CA 06OCT2019 Maurice Holley 55 Black male gun threat not No Yes
Salinas, CA 01MAR2019 Brenda Rodriguez Mendoza 20 Hispanic female gun threat   No No
San Bernardino, CA 10MAR2019 Sokhom Hon 31 Asian male unknown point not Yes No
San Bernardino, CA 19NOV2019 Jacob Cato 34 White male gun shoot not No No
San Bernardino, CA 05DEC2019 Chad James Green 41 White male gun flee foot No No
San Bernardino, CA 16DEC2019 Bernie Rascon 28 Hispanic male undetermined undetermined car No No
San Diego, CA 03APR2019 Alfonso Cervantes 50 Hispanic male gun point not Yes Yes
San Gabriel, CA 06JUN2019 Jose Salvador Meza 35 Hispanic male gun shoot not No No
San Jose, CA 14FEB2019 Mark Morasky   White male gun point car No No
San Jose, CA 04MAY2019     male vehicle attack car No Yes
San Jose, CA 30OCT2019 Wilmer Spikes Jr. 67   male knife move not No No
San Jose, CA 31OCT2019 Francis Calonge 33 White male replica point not Yes Yes
San Jose, CA 09NOV2019 Andrew Roberts 29   male gun threat not No No
San Leandro, CA 11JUN2019 Anthony Gomez 56   male replica threat not Yes Yes
San Ysidro, CA 03JUN2019 Travis James Eckstein 23 White male gun shoot car Yes No
Santa Clara, CA 05JAN2019 Shaun Kennedy 55 White male gun shoot not No No
Santa Clarita, CA 12SEP2019 Alvaro Duran Venegas 35 Hispanic male blunt_object attack not Yes No
Sherman Oaks, CA 16OCT2019 Lazzeri James Frazier Jr. 21 Black male gun threat not No No
Stanton, CA 21AUG2019 Luis Hermosillo 57 Hispanic male undetermined undetermined   No No
Stockton, CA 02FEB2019 Isaiah Thomas 40 Black male knife attack not No No
Stockton, CA 04MAY2019 Saoun Pol 35 Asian male blunt_object attack not No No
Stockton, CA 27AUG2019 Bobby Ray Moore 67   male gun point not No No
Tehama County, CA 28JAN2019 Carl Thayer 45 White male knife move other No No
Vacaville, CA 14JAN2019 Nathaniel Holland 38 Black male knife attack foot No No
Vallejo, CA 09FEB2019 Willie Bo McCoy 21 Black male gun move not No Yes
Victorville, CA 23FEB2019 Daniel David Messmer 24 White male gun point not Yes No
Victorville, CA 04SEP2019 Kenneth Lawson 62   male knife move not Yes No
Visalia, CA 03JAN2019 Abiel Innis De Joel Rios 33 Hispanic male gun shoot not Yes No
Walnut Creek, CA 02JUN2019 Miles Hall 23 Black male blunt_object attack not Yes Yes
Westminster, CA 22AUG2019     male undetermined threat car No No
Yucca Valley, CA 27JUN2019 Erik Sandoval 41 Hispanic male gun shoot not No No
Yucca Valley, CA 30SEP2019 Anthony Watkins 36 White male vehicle;gun attack car No No

statecode=CO

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=CO

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Adams County, CO 01NOV2019 Anthony Pena 46 Hispanic male gun point not No No
Aurora, CO 15JAN2019 Dean Heerdt 58 White male gun threat not No No
Aurora, CO 04MAR2019 Shamikle Jackson 22 Black male knife threat not No Yes
Avon, CO 05DEC2019 Alvern Donnell Walker 58 Black male gun point car No No
Colorado Springs, CO 12JAN2019 Bill Akes 48 White male knife threat not No No
Colorado Springs, CO 20APR2019 Sean Michael Collins 29 Hispanic male gun shoot not No Yes
Colorado Springs, CO 24APR2019 Jonathan Patzel 29 White male knife attack not No No
Colorado Springs, CO 23JUL2019 Joshua Vigil 38 Hispanic male gun threat car No No
Colorado Springs, CO 03AUG2019 De'Von Bailey 19 Black male gun flee foot No Yes
Denver, CO 01FEB2019 Robert Martinez 45 Hispanic male vehicle attack car No No
Denver, CO 25FEB2019 David Litton 40 White male gun threat not No No
Denver, CO 26APR2019 Kevin Leroy Beasley Jr. 23 Black male blunt_object attack not Yes No
Denver, CO 01JUL2019 Christopher Barela 22 Hispanic male gun shoot not No No
Denver, CO 15AUG2019 Jamie Fernandez 31 Hispanic female gun shoot foot No No
Denver, CO 31AUG2019 Juan Carlos Macias 37 Hispanic male gun shoot not No No
Denver, CO 21OCT2019 Adam Martinez 36 Hispanic male gun point car No No
Fort Lupton, CO 16JAN2019 Shawn Joseph Billinger 46 White male unarmed undetermined car Yes Yes
Friendly Hills, CO 18JUN2019 Michael Sheridan 34   male gun shoot not No No
LaSalle, CO 06FEB2019 Seth Keo Mallard 20 White male gun point   No No
Lakewood, CO 10MAR2019 Anthony Lee Montoya 51 Hispanic male gun shoot car No No
Lakewood, CO 04JUL2019 Leonel Mendez 34 Hispanic male gun shoot foot No No
Lakewood, CO 20SEP2019 Scott Johnson 57 White male gun point not No No
Lakewood, CO 11NOV2019 John Luce 22 White male gun threat foot No No
Lakewood, CO 19DEC2019 Jason Elliot Waterhouse 47 White male unknown attack not Yes No
Lone Tree, CO 28FEB2019 Kenneth Joseph Sisneros 34 Hispanic male gun move foot No No
Loveland, CO 11NOV2019 Tammy Pierce 59 White female gun shoot not No No
Monument, CO 29SEP2019 David Page 20 White male replica shoot not Yes No
Pueblo, CO 14JAN2019 Amiliano Antonio Apodaca 18 Hispanic male unarmed accident car No No
Pueblo, CO 09APR2019 Michael Wray Hensley 28 White male gun shoot foot No No
Pueblo, CO 28JUN2019 Gene Pool 37 Black male gun threat car No No
Pueblo, CO 18JUL2019 Patrick Martinez 53 Hispanic male knife attack not No No
Pueblo, CO 23NOV2019 Estevon Cruz 24 Hispanic male replica shoot not No No
Rifle, CO 05AUG2019 Allan George 57 White male gun threat foot Yes No
Trinidad, CO 19MAY2019 Lawrence Lee Lovato 46   male gun point car No No
Watkins, CO 29NOV2019 Keith Alan Bruce 40 White male gun shoot car No No
Westminster, CO 06DEC2019 Hunter Steven James Lowry 23 White male gun threat   No No

statecode=CT

statecode=DC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=DC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Washington, DC 16SEP2019 Eric Carter 53 Black male gun shoot not No No

statecode=DE

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=DE

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Lewes, DE 29NOV2019 Shane Scott Swider 46   male gun point not Yes No
Wilmington, DE 30AUG2019 Ricardo Hylton 35   male gun shoot not No No

statecode=FL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=FL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Auburndale, FL 26DEC2019 Juan Rosa 35 Hispanic male gun point not Yes No
Bascom, FL 31OCT2019 Danny James Hall 34 White male gun point car No No
Boynton Beach, FL 03APR2019 Jeffrey Garner 55 Hispanic male gun shoot not No No
Boyton Beach, FL 28JUL2019 Adalberto Wolmar Rodriguez 62 Hispanic male gun point not No No
Bruce, FL 01MAY2019     male knife threat not No No
Clearwater, FL 08JUN2019 Bryan Bernard Wallace 39 Black male gun move not No No
Clermont, FL 17MAR2019 Jorge Luis Rivera-Melendez 33 Hispanic male gun threat   No No
Coleman, FL 13JUL2019 Brian H. Benfield 46 White male gun point not No No
Davie, FL 17MAY2019 Luis Lomante 39 Hispanic male knife threat not No No
Daytona Beach, FL 02DEC2019 Jerric Harris 21 Black male gun shoot foot No Yes
DeLand, FL 11APR2019 Phillip Thomas Marsh 30 White male gun shoot car Yes No
Deltona, FL 24DEC2019 Harvey Cantrell 65 White male gun shoot not Yes Yes
Englewood, FL 24JUN2019 Bradley Rundle 61 Black male gun shoot not No No
Eustis, FL 19DEC2019 Jayson Arron Colvin 38 White male gun shoot foot No No
Fort Lauderdale, FL 24MAY2019 Hamid Ould-Rouis 59 Other male unknown threat other No No
Fort Pierce, FL 01DEC2019 Yemerson Melendez 16 Hispanic male gun;vehicle point other No No
Fort Walton Beach, FL 17DEC2019 Clyde Jacob Sullivan 27 White male gun point car No No
Hollywood, FL 14JUL2019 Blige Sean Christopher Cypress 22 Black male gun shoot car No No
Indialantic, FL 04JUN2019 Erik Gebauer 45 White male gun shoot not No No
Indian River County, FL 24MAY2019 Ryan Brett Thomas 41 White male gun shoot car No No
Jacksonville, FL 05MAR2019 Antonio Joseph Valentine 32 Black male gun threat not No No
Jacksonville, FL 14MAR2019 Jerry Marrero 38 Hispanic male knife threat not Yes No
Jacksonville, FL 11JUL2019 Frankie Feliciano 33 Hispanic male knife attack not No Yes
Jacksonville, FL 04OCT2019 Bruce William Clark 37 White male other attack not Yes No
Jacksonville, FL 14DEC2019 Jamee Christopher Deonte Johnson 22 Black male vehicle;gun attack car No Yes
Lakeland, FL 11NOV2019 Sidney Alexis Renew 20 White female vehicle attack not No No
Lakeland, FL 29NOV2019 Kenneth Layton 60 White male gun point not Yes No
Leesburg, FL 19OCT2019 McLemore Ronald 51 White male blunt_object;knife move not Yes No
Mandarin, FL 13NOV2019 Christopher Blair Ervie 47 White male knife undetermined not Yes Yes
Mexico Beach, FL 10APR2019 John Darlington 57 White male gun threat not No No
Miami, FL 12MAR2019 Latasha Nicole Walton 32 Black female vehicle threat not No No
Miami, FL 30MAR2019 Pierre J. Cher Frere 25 Black male gun point   No No
Miami, FL 01MAY2019 Reinaldo Gonzalez 51 Hispanic male knife threat not No No
Miami, FL 25JUN2019     male knife threat not No No
Miami, FL 29SEP2019 Richard Cabrera 38   male gun shoot   No No
Miami Gardens, FL 19MAY2019 Ronnie Churches 45 Black male gun shoot not No No
Milton, FL 17SEP2019     male vehicle attack car No No
Miramar, FL 05DEC2019 Lamar Alexander 41 Black male gun shoot car No No
Miramar, FL 05DEC2019 Ronnie Jerome Hill 41 Black male gun shoot car No No
Nokomis, FL 07DEC2019 Mark Richard Coleman 65 White male gun point not Yes No
North Escambia, FL 25JAN2019 Robert C. Martin 69   male gun point not Yes No
North Port, FL 12OCT2019 Fernando Mora 57 Hispanic male knife attack not No No
Ocala, FL 25DEC2019 Lori Jean Canada 59 White female replica point not Yes No
Orange Park, FL 03FEB2019 Dylan Joseph-Mark Cross 18 White male gun threat not No No
Orange Park, FL 22MAY2019     male gun point not No No
Orlando, FL 11JUN2019 Eddie Humberto Segura 40 Hispanic male blunt_object attack not Yes No
Orlando, FL 01NOV2019 Luis Morales-Camacho 41 Hispanic male gun attack not No No
Palm Beach Gardens, FL 16MAY2019 Michael Nieto   Hispanic male gun shoot not No No
Pensacola, FL 07JUL2019 Tymar Crawford 28 Black male gun attack car No No
Pinellas Park, FL 10APR2019 David Wittman 47 White male gun shoot not No No
Plant City, FL 01DEC2019 Steven Kerr Jr. 25 White male vehicle attack car No No
Port Saint Joe, FL 24MAR2019 Joseph David Durman 46 White male gun move car No No
Port Saint Lucie, FL 01JUL2019 Ben Fields 67 Black male knife move not No No
Ruskin, FL 05JUL2019 Angel Ramos Otero 37 Hispanic male knife threat not No No
Safety Harbor, FL 03AUG2019 John Clark 35   male gun point car No No
Springfield, FL 27JUN2019 Marvin Green 50 Black male gun point not No No
Tallahassee, FL 18SEP2019 Gabriel Rouse 44 White male gun shoot not No No
Tamarac, FL 15MAY2019 Ronny Rodriguez 43 Hispanic male knife attack   No No
Tampa, FL 19MAR2019 Jesus Calderon 52 Hispanic male knife threat not Yes No
Tampa, FL 01AUG2019 Lenny Blaine Griffin 48 White male knife threat not Yes No
Tampa, FL 28NOV2019 Derrick Everett 30 Black male gun point other No No
Tampa, FL 12DEC2019 Romello Barnes 22 Black male knife point not No No
Vero Beach, FL 02NOV2019 Michael Kifer 29 White male knife attack not No No

statecode=GA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=GA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Athens, GA 08MAR2019 Thomas Wayne Swinford 34 White male replica point   Yes Yes
Athens, GA 20APR2019 Carlton Steve Brooks 63 White male gun point not Yes Yes
Athens, GA 01JUL2019 Aaron Hong 23 Asian male knife attack not Yes Yes
Athens, GA 14OCT2019 Bonny Thomas 54 White female knife attack not No Yes
Athens, GA 26OCT2019 Nan Zhao 45 Asian male gun shoot foot No Yes
Atlanta, GA 15JAN2019 D'ettrick Griffin 18 Black male vehicle move car No No
Atlanta, GA 22JAN2019 Jimmy Atchison 21 Black male unarmed undetermined foot No No
Atlanta, GA 31MAR2019 Oscar Cain 31 Black male gun threat foot No No
Atlanta, GA 25DEC2019 Deangelo Rashad Martin 23 Black male vehicle attack car No No
Augusta, GA 10AUG2019 Freddrick Andrews Hadden Jr. 45 White male gun shoot car No No
Buford, GA 02FEB2019 Johnny Weeks 68 Black male gun point not No No
Carroll County, GA 21DEC2019 Marc Denver Thompson 26 White male blunt_object attack foot No No
Conyers, GA 07NOV2019 Gerald Newton Allen 66 White male gun shoot not No No
Dahlonega, GA 20NOV2019 Paul Cheek 55 White male knife threat not No No
Dalton, GA 25OCT2019 Matthew James Fleming     male unknown move not No No
DeKalb County, GA 05MAR2019 Steven Louis Goins 22   male gun shoot foot No No
Floyd County, GA 23SEP2019 Jeffery Tyler Aycock 28 White male gun shoot foot No No
Gainesville, GA 14JAN2019 Rodney Hamilton 62   male gun move not No No
Gainesville, GA 20SEP2019 Adam Paul English 21 White male gun point not Yes Yes
Gainesville, GA 30SEP2019 Raphael Michael Torres 35 Hispanic male knife threat foot No No
Glennville, GA 22AUG2019 Riley Eugene Peay 39 White male unarmed attack not No No
Glenwood, GA 02MAY2019 David Wayne West 52 White male unarmed attack other No No
Grovetown, GA 03OCT2019 Ronald Audette 61   male gun point not Yes No
Hampton, GA 20NOV2019 William Harris 51 White male gun shoot not No No
LaGrange, GA 05SEP2019 Sam Burt 65   male gun point not No No
Lake Lanier, GA 25OCT2019 Anthony Viadeo 31   male replica point car No No
Loganville, GA 03AUG2019 Aigon Andrew Wallace 25 Black male knife point foot No No
McIntosh County, GA 26FEB2019 Sasha Ann Pishko 20 White female vehicle attack car No No
Morrow, GA 01DEC2019 Jimmie Phillips 68 Black male gun point not No No
Pearson, GA 31OCT2019 Edward Roe 56 White male gun shoot not No No
Porterdale, GA 16JUL2019 Daryl Johannesson 56 White male gun point not No No
Roswell, GA 04JUL2019 Olivio Sandoval Diaz 47 Hispanic male blunt_object attack not No No
Salacoa, GA 12MAR2019 Robert Mark Frady 45 White male gun point not No No
Sandy Springs, GA 21MAR2019 Erick Ramirez 32 Hispanic male knife point not Yes No
Savannah, GA 11MAY2019 Edward Fuller III 49 Black male gun shoot foot No No
Stone Mountain, GA 15OCT2019 Akinyia Malik Jerome Gray 26 Black male gun shoot not No No
Union City, GA 01APR2019 Veltavious Griggs 19 Black male gun shoot   No No

statecode=HI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=HI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Honolulu, HI 18FEB2019 Delmar Espejo 20 Asian male unarmed attack not No No
Honolulu, HI 20FEB2019 Kyle Thomas 26 White male vehicle attack car No No
Honolulu, HI 01MAR2019 Maurice Arrisgado Jr. 47 Asian male unarmed flee foot No No
Honolulu, HI 12NOV2019 Michael Kahalehoe 30 Asian male gun;vehicle threat not No No
Honolulu, HI 17DEC2019 Dana Brown 27 Asian male knife attack   No Yes
Kalihi, HI 29JAN2019 Siatu'u Tauai 51 Asian male vehicle attack car No No
Kalihi, HI 16DEC2019 Dustin Spencer 34 Asian male gun shoot foot No No

statecode=IA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=IA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Burlington, IA 11SEP2019 Caleb Daniel Peterson 20 White male gun shoot foot No No
Council Bluffs, IA 31JUL2019 Troy Petersen 28 White male gun shoot car No No
Des Moines, IA 04MAR2019 Luke Anthony Swann 36 Black male gun shoot foot No No
Fort Madison, IA 10DEC2019 Robert Allen Elfgen 42 White male gun threat   No No
West Des Moines, IA 03JUL2019 Jonathan Pingel 26 White male knife move not Yes No

statecode=ID

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=ID

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boise, ID 20OCT2019 Amber Lea Dewitt 33 White female replica point not Yes Yes
Caldwell, ID 01SEP2019 Sidney J. Holst 49 White male gun point not No No
Coeur d'Alene, ID 04SEP2019 Fares J. Al-Samno 29 White male knife attack not No No
Idaho Falls, ID 18OCT2019 Malachi Crane 29 White male gun shoot not Yes No
Preston, ID 19NOV2019 Raul Antonio Menjivar Saabedra 50 Hispanic male knife threat not Yes No
Rigby, ID 04SEP2019 Michael E. Robbins 53   male gun point not No No
Wendell, ID 15OCT2019 David James Bamber Jr. 28 White male gun flee car No No

statecode=IL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=IL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aurora, IL 15FEB2019 Gary Marin 45 Black male gun shoot not No No
Bloomingdale, IL 05APR2019 Julius Glover 26   male knife move car No No
Bridgeview, IL 01OCT2019 Joseph Jesk 32 White male replica;vehicle attack foot No No
Chicago, IL 16FEB2019 Michael Elam 17 Black male gun threat car No No
Chicago, IL 11MAY2019 Sharell Brown 26 Black male gun point foot No No
Chicago, IL 22MAY2019 Myles Frazier 22 Black male gun shoot not Yes No
Chicago, IL 28MAY2019 Curtis Stagger 21 Black male gun threat not No No
Des Plaines, IL 19NOV2019 Christopher Terrell Willis 32 Black male gun shoot not No No
Joilet, IL 06FEB2019 Bruce Carter Jr. 38 Black male knife attack not No No
Joliet, IL 27MAY2019 Nakia Smith 41 Black male gun shoot not No No
Macoupin County, IL 16MAR2019 Billy L. Walker Jr. 53   male gun shoot other No No
North Aurora, IL 21AUG2019 54   male gun point not Yes No
Waukegan, IL 03FEB2019 Asuncion J. Gomez-Guerrero 35 Hispanic male vehicle attack car No Yes

statecode=IN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=IN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Brownstown, IN 03APR2019 Barry A. Rucker 53 White male gun threat not No No
Clarksville, IN 26APR2019 Max Helton 43 White male gun point not Yes Yes
Dearborn County, IN 12JAN2019 Christopher A. Schmitt 58 White male replica point not Yes No
Evansville, IN 28OCT2019 Terry W. Chanley 25 White male blunt_object attack not No Yes
Evansville, IN 21DEC2019 Brian Lee Mullen 57 White male gun threat not Yes No
Gary, IN 17AUG2019 Rashad Cunningham 25 Black male gun undetermined not No No
Henry County, IN 09APR2019 Michael Gulley 32 White male gun point not No No
Huntington, IN 23OCT2019 Vincent Michael Smith 29 White male gun shoot foot Yes No
Indianapolis, IN 02AUG2019 Deshon Downing 45 Black male gun point not No No
Memphis, IN 16JUL2019 Stephen Fischer 62 White male gun shoot not Yes No
New Albany, IN 06APR2019 Benjamin B. Lucas 36 White male gun shoot not Yes No
Randolph County, IN 20DEC2019 John Resetar 44 White male gun shoot not No No
Salem, IN 03JUL2019 Mark A. Naugle 53 White male blunt_object threat not No No
South Bend, IN 16JUN2019 Eric Jack Logan 53 Black male knife point not No No
South Haven, IN 23JAN2019 Kevin Grant Vawter 46 White male knife attack not Yes Yes
Springville, IN 17AUG2019 Mike Parsley 62 White male gun point not No No

statecode=KS

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=KS

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Chetopa, KS 12AUG2019 Scott Souders 38 White male gun point not No No
Kansas City, KS 10JUL2019 Dennis Edwards 62 White male gun point not No No
Kansas City, KS 13AUG2019 Charles Roy Pearson 51 Black male gun shoot not No No
Salina, KS 28AUG2019 Jeremy Connolly 28 White male knife move not No No
Wichita, KS 10JAN2019 Geoffrey Morris 29 White male gun;vehicle attack car No No
Wichita, KS 28JAN2019 David Michael Bosiljevac 55 White male replica point not No No
Wichita, KS 23MAY2019 Fred Burton 56 White male gun shoot not Yes No
Wichita, KS 27MAY2019 Robert Sabater 49 White male gun shoot foot Yes No
Wichita, KS 30DEC2019 Debra D. Arbuckle 51 White female vehicle attack car No No

statecode=KY

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=KY

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bonnyman, KY 06JUN2019 Zendall Noble 58 White male gun point not No No
Carter County, KY 02MAR2019 Clair Jewell 35 White female undetermined move foot No No
Crestwood, KY 11FEB2019 Ty'rell Pounds 24 Black male gun shoot car No No
Dexter, KY 02NOV2019 John Hale 42 White male undetermined attack   No No
Elkton, KY 01OCT2019 Roy Tucker 75 White male gun shoot not No No
Jackson County, KY 01AUG2019 David Willoughby 54 White male vehicle attack car No No
Leitchfield, KY 08AUG2019 Kevin Jenkins 52   male gun point not Yes No
Louisville, KY 09APR2019 Terry Davis Jr. 33 Black male gun point not No No
Louisville, KY 15MAY2019 Djuantez Anthony Mitchell 30 Black male vehicle attack car No No
Louisville, KY 13AUG2019 Anthony Wayne French Sr.   White male gun point not No No
Louisville, KY 07NOV2019 Shelby Gazaway 32 Black male gun shoot   No Yes
Montgomery Creek, KY 22MAY2019 Christopher L. Brown 32   male vehicle attack car No No
Nicholasville, KY 21AUG2019 James Crowe 27 White male unknown undetermined not No No
Owingsville, KY 24APR2019 Emory Moore 29 White male undetermined attack car No No
Wolfe County, KY 27JUN2019 Stephen D. Sloan 35 White male gun threat not No No

statecode=LA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=LA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bastrop, LA 19MAR2019 Thomas Johnson 22 Black male gun undetermined foot No No
Baton Rouge, LA 27AUG2019 Keith Carter 52 Black male gun shoot car Yes No
Baton Rouge, LA 14SEP2019 Melvin Watkins 54 Black male unarmed undetermined not No No
Bossier City, LA 25OCT2019 Shannon Gail Rupert 45 White female knife move not No No
Clinton, LA 12APR2019 Myron Flowers 28 Black male gun shoot not No No
DeRidder, LA 27FEB2019 Gary Clark 21 White male unknown threat   No No
Ethel, LA 14OCT2019 Christopher Whitfield 31 Black male unarmed undetermined foot Yes No
Lacombe, LA 25SEP2019 Kevin Dudenhefer 32 White male gun point not Yes No
Lake Charles, LA 11JAN2019 Juston Landry 26 Black male gun threat other No No
Metairie, LA 18JUL2019 Leo Brooks 23 Black male gun threat not No No
New Orleans, LA 17FEB2019 Reginald Romero Bursey 32 Black male gun shoot not No No
New Orleans, LA 17MAY2019 Donald Davis, Jr. 40 Black male gun shoot   No Yes
Port Allen, LA 25JUL2019 Josef Delon Richardson 38 Black male unarmed undetermined   No No
Shreveport, LA 10APR2019 Trivenskey O. Odom 27 Black male gun shoot car No No
Shreveport, LA 01JUN2019 Marcus Boles 35 Black male knife attack not No No
St. Helena Parish, LA 09DEC2019 Antonio Nichols 47 Black male gun threat not No No
Terrytown, LA 27MAR2019 Chris Joseph 38 Black male vehicle attack not No No
Terrytown, LA 27MAR2019 Daviri Robertson 39 Black male vehicle attack car No No
Treme, LA 04JAN2019 Zonell Williams 33 Black male gun shoot not Yes Yes

statecode=MA

statecode=MD

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MD

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Baltimore, MD 19FEB2019 Emanuel David Joshua Oates 24 Black male knife threat not No No
Baltimore, MD 24MAR2019 Kevin Bruce Mason 57 Black male unarmed threat not No Yes
Baltimore, MD 15JUL2019 Ashanti Pinkney 49 Black male gun shoot not No Yes
Baltimore, MD 28AUG2019 Tyrone Domingo Banks 30 Black male vehicle;gun shoot car No No
Baltimore, MD 28SEP2019 Jamaal Ramone Taylor 31 Black male knife attack foot No No
Baltimore, MD 30OCT2019 John Feggins 24 Black male gun attack not No Yes
Davidsonville, MD 04JUN2019 Martin Allen Goodier 56 White male knife threat not No No
Havre de Grace, MD 30MAY2019 Steve Huff 58 White male gun move not Yes No
Hyattsville, MD 26SEP2019 Leonard Shand 49 Black male knife attack not No No
Linthicum, MD 27DEC2019 John Lowell Dollen 55 White male gun shoot not Yes No
Parkville, MD 02MAY2019 Robert Uhl Johnson 76   male gun point not Yes Yes
Phoenix, MD 22JUN2019 Scott William Robertson 41 White male gun threat   No Yes
Rising Sun, MD 13MAY2019 James Douglas Meadows 45 White male gun point not Yes No
Rockville, MD 13JUN2019 Marquis Weems 17 Black male vehicle attack car No No
Rosedale, MD 06JUL2019 Kareem Omar Morgan 43 Black male gun shoot other No No
Silver Spring, MD 16JAN2019 Mikyas Mehary Tegegne 31 Black male gun move foot No No
Sparks, MD 26NOV2019 Eric Sopp 48 White male knife attack car Yes Yes
Thurmont, MD 25MAR2019 Abraham Arellano 26 Hispanic male gun threat   Yes No
Westminster, MD 11MAR2019 Michael J. D'Angelo 34 White male knife attack not No No

statecode=ME

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=ME

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Auburn, ME 21MAY2019 Steven Case 29 White male gun shoot not No No
Gorham, ME 31MAY2019 Kyle Needham 32 White male vehicle attack car No No
Limerick, ME 27DEC2019 Christopher Camacho 16 Hispanic male gun;knife threat   No No

statecode=MI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bagley Township, MI 02JUL2019 Chad Williams 44 White male blunt_object attack   Yes No
Detroit, MI 03JUN2019 Kevin Pudlik 41 White male unarmed move car No No
Flint, MI 24FEB2019 Tommy Kirby 41 White male undetermined undetermined car No No
Flint, MI 17APR2019 Akeen Brown 34 Black male gun shoot not No No
Gaines Township, MI 24NOV2019 Steven Forrest Saucier 34 White male gun point not No No
Jackson, MI 28JAN2019 Joey Duane Ramirez 29 Hispanic male gun shoot foot No No
Kalamazoo, MI 12MAR2019 Brandon Stacey 31 White male gun shoot not No No
Kalamazoo, MI 04APR2019 Thomas Verile Jr. 37 White male unarmed threat not Yes No
Pennfield Township, MI 09MAR2019 Joel David Kellay 46 White male gun shoot not No No
Redford Township, MI 14DEC2019 Louis Patrick Veal 65 Black male gun shoot not No No
Sebewaing, MI 02MAR2019 Ricky Lee Prichard 49   male gun shoot not Yes No
St. Joseph County, MI 18OCT2019 David Sanders 46   male vehicle attack not No No
Walloon Lake, MI 26OCT2019 Johnathan Wayne Slattery 27 White male gun shoot not Yes No

statecode=MN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Albert Lea, MN 03JAN2019 Joseph Roberts 27 White male knife attack   Yes No
Brooklyn Center, MN 31AUG2019 Kobe Heisler 23 Black male blunt_object threat not No Yes
Coon Rapids, MN 18APR2019 John Duane Fairbanks 40 Native American male gun shoot foot No Yes
Eagan, MN 02JUL2019 Isak Abdirahman Aden 23 Black male gun threat foot No Yes
Hermantown, MN 04MAY2019 Timothy Russell Majchrzak 37 White male gun shoot foot No No
Miltona, MN 26FEB2019 Tyler Schmidtbauer 27 White male gun threat not No Yes
Minneapolis, MN 02AUG2019 Mario Benjamin 34 Black male gun point not No Yes
Minneapolis, MN 15DEC2019 Chiasher Fong Vue 52 Asian male gun shoot not No Yes
Richfield, MN 07SEP2019 Brian Quinones 30 Hispanic male knife threat car Yes No
Saint Louis Park, MN 19JAN2019 Matthew Neil Tuhkanen 35 White male unarmed undetermined not Yes No
Saint Paul, MN 15SEP2019 Ronald Davis 31 Black male knife attack not No Yes

statecode=MO

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MO

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Barton County, MO 28NOV2019 Jeremy Pelican 34 White male gun threat car No No
Chesterfield, MO 31DEC2019 Frederick Perkins Jr. 37 Black male vehicle attack car No No
Cotter, MO 29SEP2019 Angela Louise Perkins 38 White female vehicle attack car No No
Fulton, MO 30DEC2019 Cody McCaulou 25 White male vehicle attack car No No
Independence, MO 12SEP2019 Allen Cates 29 White male undetermined attack   No No
Joplin, MO 13AUG2019 David Ingle 31 White male unarmed attack not Yes No
Kansas City, MO 26MAY2019 Terrance Bridges 30 Black male gun attack foot No No
Kansas City, MO 09AUG2019 Jose Mendez 37 Hispanic male gun;vehicle attack foot No No
Kansas City, MO 18NOV2019 Cody McClintick 26 White male gun attack   No No
Kansas City, MO 03DEC2019 Cameron Lamb 26 Black male gun threat not No No
Leadwood, MO 08JAN2019 Michael W. Mobley 53   male gun point not No No
Maryland Heights, MO 06OCT2019 Bradley Arning 42   male gun point not No No
Mountain Grove, MO 05JUL2019 James C. Pinkston 58 White male gun shoot not No No
O'Fallon, MO 18JAN2019 Dale Weich 64 White male gun point not Yes No
Pettis County, MO 05NOV2019 Jay P. Messer 58 White male gun shoot not No No
Saint Louis, MO 15JAN2019 Quency Chavez Floyd 22 Black male gun shoot foot No No
Saint Louis, MO 24JAN2019 Katlyn Alix 24 White female unarmed accident not No No
Saint Louis, MO 25MAR2019 Kaylon Robinson 18 Black male gun point not No No
Saint Louis, MO 11APR2019 Demetrious Brooks 34 Black male gun attack foot No No
Saint Louis, MO 06JUN2019 Rodnell Cotton 26 Black male gun shoot foot No No
Saint Louis, MO 31AUG2019 Terry Tillman 23 Black male gun threat foot No No
Saint Louis, MO 05SEP2019 Cortez Shepherd 28 Black male gun attack not No No
Saint Louis, MO 20OCT2019 Steven Day 30 Black male gun point car No No
Saint Louis, MO 12DEC2019 Cortez Bufford 24 Black male gun threat foot No No
Springfield, MO 25FEB2019 Bryan A. Ryder 38 White male knife move   Yes No
Springfield, MO 05MAR2019 Jared D. Kelly 36   male gun threat   No No
Springfield, MO 24DEC2019 David A. White 56 White male gun threat not No No
University City, MO 19MAR2019 James Hunn 61 White male gun point not Yes No

statecode=MS

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MS

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Braxton, MS 06JUN2019 Harry Gipson 70 White male gun point   Yes No
Clinton, MS 16FEB2019 Nam Quang Le 34 Asian male gun shoot not No No
DeSoto County, MS 29DEC2019 John Bott 76 White male gun shoot   Yes No
Fayette, MS 17OCT2019 Cameron Bennett 22 Black male gun;vehicle attack car No No
Florence, MS 31AUG2019 Shawn Fondren 47   male vehicle move car No No
Greenville, MS 05MAR2019 Joshua Worth 31 White male undetermined undetermined   Yes No
Hancock County, MS 29APR2019 Lawrence Bottoms 29 White male gun point foot No No
Hattiesburg, MS 22DEC2019 Kenneth Collins 46 Black male unknown move other No No
Horn Lake, MS 19NOV2019 Joel Avery   White male gun move not No No
Lumberton, MS 07MAY2019 Aubrey Manning 59 White male gun move not Yes No
Monroe County, MS 14MAR2019 George Wayne McCallum 33 White male gun threat car Yes No
Moss Point, MS 08AUG2019 Toussaint Diamon Sims 27 Black male gun point foot No Yes
Pearl, MS 28JUN2019 Ryan Moody 19 White male gun shoot not No No
Pearl River County, MS 23MAY2019 Adam Michael McCoy 28 White male gun shoot car Yes No
Pelehatchie, MS 18FEB2019 Pierre Woods 31 Black male gun shoot not Yes No
Pontotoc County, MS 01JUL2019 Terry Allen "Bubba" Payne 52 White male gun shoot car No No
Stone County, MS 06FEB2019 Miles Dylan Cooper 25 White male gun shoot car No Yes
Wesson, MS 22JUL2019 Shawan F. Allen   Black male gun shoot   No No

statecode=MT

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MT

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Billings, MT 20JAN2019 Chance Mavity 26 White male gun shoot foot No No
Bozeman, MT 03JAN2019 Eric David Sauerhagen 31 White male gun move not No No
Great Falls, MT 25NOV2019 Jason Quincey Niccum 42 White male gun move not No No
Great Falls, MT 17DEC2019 Ricky Lee Gardipee 41 White male gun shoot foot No No
Missoula, MT 02SEP2019 Steven Cole Gill 35 White male gun point not Yes No
Shelby, MT 22APR2019 Richard Allen Moench 50 White male gun shoot not No No

statecode=NC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Apex, NC 13FEB2019 Greg Alyn Carlson 47 White male gun attack not No No
Apex, NC 25APR2019 Stanley Edward Thompson 51 White male gun point   No No
Archdale, NC 20MAY2019 Carlos Javier Roman Santiago 46 Hispanic male knife attack not No No
Bailey, NC 09FEB2019 Jonathan Ramirez 28 Hispanic male gun threat not No Yes
Charlotte, NC 16JAN2019 Danny Kelley 32 White male knife move foot No No
Charlotte, NC 25MAR2019 Danquirs Napoleon Franklin 27 Black male gun threat not Yes Yes
Charlotte, NC 02AUG2019 Delano Williams 55 Black male gun shoot not Yes No
Charlotte, NC 15NOV2019 Treon McCoy 33 Black male gun shoot not No No
Cofield, NC 10MAR2019 Phillip Wayne Outland 44 White male gun point not No No
Davidson County, NC 01JAN2019 Dylan Michael Smith 26 White male gun attack foot No No
Durham, NC 30MAR2019 Ondrae Levado Hutchinson 30 Black male gun attack foot No Yes
Elizabethtown, NC 22NOV2019 Lance Edward Smith 37 Black male gun shoot not No No
Ernul, NC 22MAR2019 Bruce Puchel 45 White male gun threat not Yes No
Fayetteville, NC 06NOV2019 Treva Smutherman 31 Black male gun attack not No No
Greenville, NC 09JUL2019 Sean Rambert 23 Black male gun shoot not No No
Greenville, NC 24OCT2019 Michael Babcock 53 White male gun threat not No No
High Point, NC 14OCT2019 Victor Jarvis 61 Black male gun shoot not No No
Jamestown, NC 15OCT2019 Dennis Patrick Jr. 28 White male gun shoot not Yes No
Lenoir, NC 19DEC2019 Kentrey Marquis Witherspoon 28 Black male gun shoot foot No No
Lincolnton, NC 08NOV2019 Ray Correll 38 White male gun point not Yes No
Mount Holly, NC 02MAR2019 Larry Todd Hoover 33 White male knife threat not Yes No
Raleigh, NC 20APR2019 Soheil Antonio Mojarrad 30 White male knife point not No No
Ramseur, NC 13AUG2019 Cole Steele Jessup 20 White male vehicle attack car No No
Richlands, NC 24SEP2019 Haywood Cannon 67 White male gun shoot car No No
Sanford, NC 24SEP2019 Ronald Michael McCrary 63   male knife threat   No No
Shallotte, NC 01JAN2019 Brandon Lovell Webster 28 Black male vehicle move car No No
Trinity, NC 05JUN2019 Scott Hedgecock 54 White male knife point not Yes No
Wake County, NC 31AUG2019     male gun point foot No No
Watauga County, NC 30MAR2019 Andrew John Mason 22 White male unarmed attack not No No
Welcome, NC 30APR2019 April Robertson 45 White female knife threat not No No
Wilmington, NC 29MAY2019 Gerald Tremblay 62 White male gun point not Yes No
Wilmington, NC 17DEC2019 Kyle Horton 31 White male gun point not No No
Wilson, NC 13NOV2019 Roy McAllister Jr. 27 Black male gun attack foot No No
Winston-Salem, NC 20DEC2019 Steven DeWayne Haizlip 61 Black male gun shoot not No No

statecode=NE

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NE

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Grand Island, NE 13MAR2019 Benjamin Melendez 29 Hispanic male knife attack not No No
Lincoln, NE 08OCT2019 Joseph Cimino 48 White male vehicle attack not No No
Omaha, NE 27JUN2019 Matthew Christian Smith 33 White male gun shoot not Yes No
Omaha, NE 31DEC2019 Terry Hudson 57 Black male gun shoot not No Yes
Rushville, NE 14APR2019 Clarence Leading Fighter 32 Native American male knife threat foot No No
South Sioux City, NE 11MAY2019 Luis Quinones Rosa 26 Hispanic male gun shoot not No No

statecode=NH

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NH

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Belmont, NH 15JUN2019 Michael Sheehan II 45 White male gun threat not Yes No
Manchester, NH 27MAR2019 Stephen Marshall 51 White male gun shoot not No No

statecode=NJ

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NJ

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Asbury Park, NJ 23JUL2019 James Manzo 27 White male knife threat not Yes No
Farmingdale, NJ 18OCT2019 Charles Tsakiris 38 White male knife attack not No No
Irvington, NJ 05AUG2019 Kaizen Crossen 39 Black male gun shoot not No No
Jersey City, NJ 10DEC2019 Francine Graham 50 Black female gun shoot not No No
Jersey City, NJ 10DEC2019 David N. Anderson 47 Black male gun shoot not No No
Logan Township, NJ 14JAN2019 William Owens 39 Black male gun shoot not No No
Newark, NJ 28JAN2019 Gregory Griffin 46 Black male gun flee car No Yes
Orange, NJ 13JUL2019 Jamahl Smith 46 Black male knife move foot No No
Passaic, NJ 31JAN2019 Randy Sanchez 24   male gun flee foot No No
Pemberton, NJ 19JUL2019 Witney Rivera 41 Hispanic male blunt_object move   No No
Secaucus, NJ 01DEC2019 Anthony Rosso 68 White male gun shoot   No No
Trenton, NJ 14MAR2019 Jason Williams 42   male replica threat not Yes No

statecode=NM

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NM

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Alamogordo, NM 01NOV2019 Benjamin Diaz 22 Hispanic male knife attack not No No
Albuquerque, NM 02JUL2019 Casiano Coronel 21   male gun shoot not No No
Albuquerque, NM 21JUL2019 Elisha Lucero 28 Hispanic female knife move not Yes No
Albuquerque, NM 22AUG2019 Roger Schafer 57 White male replica point not No No
Albuquerque, NM 14OCT2019 Daniel James Wood Jr. 29   male gun point not No No
Albuquerque, NM 25OCT2019 Raymond V. Tahod 27   male gun threat car No No
Angel Fire, NM 05MAY2019 George Herrera 61 Hispanic male knife threat not No No
Bernalillo, NM 05JUN2019 Fabian Rivera 28 Hispanic male gun threat not No No
Carlsbad, NM 19MAY2019 Lori Markham 47 White female gun point not No No
Carlsbad, NM 29AUG2019 Randall Gamboa 16   male gun point not No No
Farmington, NM 10OCT2019 Norbert Beyet 58 White male gun point not No Yes
Hobbs, NM 22AUG2019 Roberto Mata 46 Hispanic male gun shoot not No No
Las Cruces, NM 17JUN2019 Francisco Tarin 35 Hispanic male gun shoot car No No
Las Cruces, NM 04NOV2019 Daniel M. Munoz 21 Hispanic male gun shoot   No No
Meadowlake, NM 01MAY2019 Isaac Pineda 37 Hispanic male gun point not No No
Naschitti, NM 23JAN2019   Native American male undetermined undetermined   No No
Sunland Park, NM 04NOV2019     male gun shoot foot No No
Tularosa, NM 07JUL2019 Johnny M. Vigil 43   male gun shoot not No No

statecode=NV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Carson City, NV 03AUG2019 Cortney Ronald Staley 32 White male gun shoot not No No
Henderson, NV 21OCT2019 Claudia Nadia Rodriguez 37 Hispanic female gun shoot not No Yes
Henderson, NV 20NOV2019 Kenneth Simeus Jr. 18 Black male gun shoot   No Yes
Las Vegas, NV 21JAN2019 Horacio Ruiz-Rodriguez 37 Hispanic male unarmed threat car Yes No
Las Vegas, NV 15MAR2019 Michael Cohen 47 White male gun shoot not No Yes
Las Vegas, NV 19MAR2019 Stevie Garcia 37 Hispanic male gun point not No Yes
Las Vegas, NV 14MAY2019 Alex Steward Underdown 54 White male gun threat not Yes No
Las Vegas, NV 19AUG2019 Michael Lopez 69 Hispanic male gun shoot car No No
Mercury, NV 28JAN2019 Nekiylo Dawayne Graves 27 Black male unknown move car No No
Silver Springs, NV 02SEP2019 Robert Anderson 43   male undetermined attack not No No
Sparks, NV 28APR2019 Jose Dominguez 47 Hispanic male gun threat not Yes No

statecode=NY

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NY

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Ardsley, NY 03JUN2019 Samuel Galberth 43 Black male gun shoot   No No
Arietta, NY 10DEC2019 Daniel E. Condon 55 White male knife attack   Yes No
Brentwood, NY 19DEC2019 Emanuel Johnson III 21 Black male gun point foot No No
Greenport, NY 03JAN2019 Robert Myers 63 White male gun shoot not Yes No
Ithaca, NY 21DEC2019 Michael DeCastro 57 White male knife attack not Yes No
Jamaica, NY 30AUG2019 Stephen Gillard 27 Black male gun shoot not No No
Kirkwood, NY 28JAN2019 Nicholas Philhower 30 White male gun shoot car No No
Lee, NY 16APR2019 Tyler R. Johnson 24 White male knife move not Yes No
Montgomery, NY 23MAY2019 Luke H. Patterson 41 White male unarmed threat not No No
New York, NY 08FEB2019 Joshua Rember Williams 32 Black male knife attack not No No
New York, NY 14APR2019 Kawaski Trawick 32 Black male knife threat not Yes Yes
New York, NY 18APR2019 Luiz Leizado 42 Hispanic male gun shoot foot No No
New York, NY 02SEP2019 Brandon Clayton 29 Black male gun shoot foot No No
New York, NY 17SEP2019 Gregory Edwards 39 Black male gun shoot foot No Yes
New York, NY 29SEP2019 Antonio Williams 27 Black male gun shoot not No Yes
New York, NY 15OCT2019 Nasheem Prioleau 30 Black male gun shoot not No No
New York, NY 17OCT2019 Allan Feliz 31 Hispanic male vehicle attack not No No
New York, NY 23OCT2019 Victor Hernandez 29 Black male gun shoot not No Yes
New York, NY 25OCT2019 Kwesi Ashun 33 Black male other attack not Yes No
Oceanside, NY 17SEP2019 Brian Rodden 36 White male knife attack not Yes No
Syracuse, NY 18JUN2019 DeWayne Watkins 74 Black male replica point not No No
Syracuse, NY 03DEC2019 Miguel Russo 31 Black male gun attack not No Yes

statecode=OH

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=OH

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Akron, OH 15DEC2019 Mohammad Jamal Isaifan 40 Other male gun threat foot Yes No
Alliance, OH 16NOV2019 Robert Sikon III 41 White male unarmed attack foot No No
Ashtabula Township, OH 07NOV2019 Christopher Mills 37 White male gun threat not No No
Ashville, OH 20JUN2019 Dewayne Tackett 38 White male gun threat car No No
Barberton, OH 07FEB2019 Charles L. Cook 49 White male gun shoot not No No
Brooklyn, OH 08JUL2019 Shawn Toney 23 White male gun shoot not Yes No
Cincinnati, OH 31JUL2019 Robert Schneider 46   male gun point not No No
Cleveland, OH 15NOV2019 Mark Sheppard 27 Black male gun threat foot No No
Columbus, OH 11SEP2019 Tasjon Tyreek Osbourne 18 Black male gun threat car No No
Dayton, OH 04AUG2019 Connor Betts 24 White male gun shoot not Yes No
Dayton, OH 22AUG2019 Michael Tuck 29 Black male other attack foot No No
Defiance, OH 12FEB2019 Alex Johnson 58 Black male knife threat not No No
East Cleveland, OH 05NOV2019 Maurice Brown 48 Black male gun attack not No Yes
Elyria, OH 02JUL2019 Isaiah Robinson 39 Black male gun point car No No
Lancaster, OH 28DEC2019 Troy Kirk 31 White male knife attack not Yes Yes
Mansfield, OH 18MAR2019 Kenneth Cherry 36 White male knife threat not No No
Mansfield, OH 27NOV2019 Micduff Lamarco Robinson 40 Black male knife threat not No No
Niles, OH 02JAN2019 Matthew Burroughs 35 Black male vehicle attack foot No No
Springfield, OH 23JUN2019 Michael Spencer 29 White male knife attack foot Yes No
Struthers, OH 26FEB2019 Brandon Schmitt 48 White male gun shoot not No No
Sugarcreek, OH 26JUN2019 Elijah Collins III 32 Black male knife attack not No Yes
Trotwood, OH 21OCT2019 Joseph Bernhard-Williams Kisar 21 White male gun point car No No
Van Wert, OH 03SEP2019 Terry Pierce Jr. 46 White male vehicle flee car Yes No
Wadsworth, OH 07NOV2019 Guy Thomas Barnard 26 White male replica point   Yes No

statecode=OK

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=OK

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Ada, OK 21SEP2019 Jeffrey Peterson 29 White male undetermined attack not No No
Ada, OK 03DEC2019 Thomas Cole Thompson 58 White male gun shoot not No No
Bartlesville, OK 01JUN2019 Thomas Goodeyes Gay 35 Native American male unarmed undetermined not Yes No
Blackwell, OK 20MAY2019 Michael Ann Godsey 34 White female gun shoot car No No
Cache, OK 06JAN2019 James McDonald   White male gun shoot not No No
Chickasha, OK 27MAR2019 Kevin Samuel Capers 47 White male knife threat not No No
Del City, OK 09FEB2019 Gabriel Carter 25 White male gun shoot not No No
Edmond, OK 29APR2019 Isaiah Lewis 17 Black male unarmed attack foot No No
Henryetta, OK 06NOV2019 Corben Hunter Jones 20 White male undetermined undetermined   No No
Kansas, OK 25OCT2019 Clayton Andrews 40 White male gun shoot not No No
Lawton, OK 10JUN2019 Brent Durbin-Daniel 19 Black male gun move car Yes No
McAlester, OK 17JUL2019 Mark Anson Schoggins 35 White male gun shoot car No No
Muskogee, OK 05MAR2019 Danny Brogdon 56 White male knife threat not No No
Oklahoma City, OK 10JUN2019 Vincense Williams, Jr. 24 Black male gun threat not No Yes
Oklahoma City, OK 09SEP2019 Quentin Broadus 27 Black male gun shoot other No Yes
Oklahoma City, OK 15SEP2019 Brian Dryer 28 White male knife attack not Yes Yes
Oklahoma City, OK 03OCT2019 Michael John 24 Black male gun shoot not No Yes
Oklahoma City, OK 09OCT2019 Leo Craig Jr. 31 Black male gun point   No Yes
Oklahoma City, OK 12NOV2019 Justin Anderson 39 White male gun shoot   No No
Oklahoma City, OK 24DEC2019 Elray Barber 60 Black male gun point car No No
Pittsburg, OK 11OCT2019 Sayven Lane Rowland 19 White male gun point other No No
Porteau, OK 11JUN2019 Jaquan Derrick Diijon Thompson 27 Black male knife attack not No No
Sallisaw, OK 14MAR2019 Shawn Taylor Waite 27 Native American male knife point not No No
Sand Springs, OK 01SEP2019 Robert Desjarlais Jr. 49 White male vehicle attack car No Yes
Sperry, OK 16JAN2019 Terry Lee Cockrell 57 White male gun threat foot Yes Yes
Tahlequah, OK 07OCT2019 Bobby Lee Vaughn 54 White male gun point not Yes Yes
Tahlequah, OK 06NOV2019 Eddie Ray Maxwell Sr. 37 Black male gun point not No No
Tulsa, OK 07JAN2019 Jeremy Dale Edmonds 42 White male knife attack not No No
Tulsa, OK 10MAY2019 Derrec Jamal Shaw 25 Black male gun shoot foot Yes Yes
Tulsa, OK 20JUN2019 Eric Portillo 38 White male gun point car No Yes
Tulsa, OK 27JUN2019 William Aubrey Martin 50 White male vehicle attack car No No
Tulsa, OK 27OCT2019 Luis Arreguin-Lara 50 Hispanic male gun shoot not No Yes
Tulsa, OK 18DEC2019 Tyler Hall 29 White male gun point not No No
Washita County, OK 12DEC2019 Cade Humphrey 30 White male knife attack car No No

statecode=OR

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=OR

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Clackamas County, OR 19JAN2019 Mark Leo Gregory Gago 42 White male blunt_object attack not No No
Cottage Grove, OR 23AUG2019 Larry Leonard Lowry Jr. 34 White male knife move not No No
Eugene, OR 11JAN2019 Charles Frederick Landeros 30 Hispanic male gun shoot not No Yes
Eugene, OR 30NOV2019 Eliborio Rodriguez 40 Hispanic male unarmed attack not No No
Hillsboro, OR 21OCT2019 Jason Livegood 39 White male gun point not No No
Medford, OR 18JUL2019 Tony Orland Mills 73   male gun shoot not Yes No
Milwaukie, OR 05JAN2019 David John Engebretson 50 White male gun shoot not No No
Oakridge, OR 17OCT2019 Marcus Hartsfield 27 White male knife threat not No No
Ontario, OR 14MAR2019 Victor J. Morales Zavala 25 White male gun point car Yes No
Portland, OR 06JAN2019 Andre C. Gladen 36 Black male knife threat not Yes No
Portland, OR 14APR2019 Brian Dellaann Butts 33 White male gun shoot not No No
Portland, OR 29APR2019 Jeb Colin Brock 42 White male knife attack not No No
Portland, OR 09JUN2019 David Wayne Downs 38 White male knife threat not No No
Portland, OR 30JUL2019 Lane Christopher Martin 31 White male blunt_object point   No No
Portland, OR 08DEC2019 Koben S. Henriksen 51 White male knife threat not Yes No
Salem, OR 18SEP2019 Scott Gabriel Spangler 43 White male gun attack not No No
Springfield, OR 31MAR2019 Stacy William Kenny 33 White female vehicle flee car Yes No
The Dalles, OR 16MAR2019 James Young 77   male gun shoot not No No

statecode=PA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=PA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Allentown, PA 01AUG2019 Andre Leach 27   male gun shoot not Yes No
Aspers, PA 14FEB2019 Michael Drayer 34 White male knife attack not No No
Greensburg, PA 13MAR2019 Nina Adams 47 Black female gun point not Yes No
Hanover Township, PA 01DEC2019 Jordan Oliver 20 White male vehicle;knife;other attack car No No
Jim Thorpe, PA 28NOV2019 Nicholas Cantelmi 31 White male gun;vehicle attack other No No
Nelson Township, PA 11DEC2019 Delos P. Lowe 68 White male gun shoot not Yes No
Penn Hills, PA 14JUL2019 Onaje Dickinson 20 Black male gun shoot foot No No
Ross Township, PA 23JUL2019 Omari Thompson 31 Black male gun shoot not No No
Shaler Township, PA 06AUG2019 Donald Babbit 49 White male gun point not No No
State College, PA 20MAR2019 Osaze Osagie 29 Black male knife attack not Yes No
Stroudsburg, PA 28JUL2019 Larry Pettiford 69   male gun shoot not Yes No
Three Springs, PA 26JUL2019 Todd Messner 49 White male gun point not Yes No
Wilkinsburg, PA 18SEP2019 Shawn Stevens 49 Black male knife attack not No No
Wilkinsburg, PA 22DEC2019 Romir Talley 24 Black male gun shoot foot No No

statecode=SC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=SC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Andrews, SC 10DEC2019 Kreed Cornell Bateman 31 Black male gun shoot   No No
Belton, SC 14AUG2019 Thomas Michael Reynolds 37   male gun move not No No
Chester, SC 23NOV2019 Ariane Lamont McCree 28 Black male gun attack foot No Yes
Easley, SC 19OCT2019 Ricky Leonard Harris 61   male gun point not No No
Fountain Inn, SC 16APR2019 Chadwick Dale Martin Jr. 24 White male vehicle attack car No No
Greenville County, SC 10FEB2019 Willie Jermaine Robinson 34 Black male gun shoot not Yes Yes
Hartsville, SC 25SEP2019 Daryl Strickland 64 White male gun point not No No
Horry County, SC 25MAR2019 Brandon Coty Elliott 30 White male gun threat foot Yes No
Huger, SC 26FEB2019 Joseph Hart 51 White male gun shoot not No No
Inman, SC 22MAY2019 David Marcus Reece 47 White male gun point not No No
Lexington County, SC 26SEP2019 Chad Willis Huggins 28 White male gun shoot other No No
Myrtle Beach, SC 12OCT2019 Matthew Graham 32   male gun point not No Yes
Orangeburg, SC 27JUN2019 Benjamin Ray Smith 54 Black male undetermined undetermined   No No
Pelion, SC 03APR2019 Zachary Kinard   White male gun threat car No No
Sun City, SC 26JUL2019 Donald Williams Allamong 56 White male gun threat not Yes No
Union County, SC 05JAN2019 Harold Thompson 81   male gun shoot not No No
Union County, SC 09NOV2019 Daniel Thomas Childers Jr. 28 White male knife threat not No No
Walterboro, SC 22MAR2019 Derek Smith 22 Black male knife threat not No No

statecode=SD

statecode=TN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=TN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Blountville, TN 23FEB2019 Jackie Scott Pendergrass 44 White male gun shoot not No No
Bluff City, TN 03SEP2019 Attillio Gilmartin 30 White male gun shoot car No No
Bradley County, TN 10AUG2019 Manuel Charles Carter 57 White male knife point not No No
Bristol, TN 07JUN2019 Jason Nash 46 White male gun move not No No
Chattanooga, TN 31JUL2019 Jerry Reeves 42 White male gun point not No No
Cheatham County, TN 09MAR2019 Beth Plant 51 White female knife attack not No No
Claiborne County, TN 17FEB2019 Elizabeth Ann Stropp 37   female gun point foot No No
Clarksville, TN 23FEB2019 Angel Burke 29 White male gun threat foot No No
Clinton, TN 13AUG2019 Jerry Orlando Weaver 51 Black male gun point not Yes No
Collierville, TN 03JUN2019 David Hoal 59 White male gun point not Yes No
Dyersburg, TN 25JAN2019 Jeffrey Lynn Jones 60 White male gun point not No No
Elizabethon, TN 16SEP2019 Jeffrey Michael Gibble 33 White male gun shoot foot No No
Elizabethton, TN 28DEC2019 A.B. Carr 31 White male unknown attack not No No
Greeneville, TN 07APR2019 Anthony Orlando Bowers 24 Black male gun shoot not No No
Greeneville, TN 26NOV2019 Hollis Lewis 51 White male gun shoot not No Yes
Hamilton County, TN 07APR2019 Charles Bradley Payne 42 White male knife attack not No No
Kingsport, TN 10JUN2019 Terry Frost   White male vehicle attack not No No
Knoxville, TN 19JAN2019 Jason C. Minnick 30 White male vehicle move car No No
Knoxville, TN 26AUG2019 Channara Tom Pheap 33 Asian male unarmed attack not No No
LaFollette, TN 01APR2019 Lianna Renee London 28 White female gun point not No No
Memphis, TN 07FEB2019 Jason Matthew Hill 40 White male gun shoot not No No
Memphis, TN 12JUN2019 Brandon Webber 20 Black male vehicle attack foot No No
Memphis, TN 05AUG2019 James Lee Kirkwood 49 Black male knife attack foot No No
Memphis, TN 18SEP2019 Willie Hudson 33 Black male gun shoot not No No
Memphis, TN 26DEC2019 Antonio Smith Jr. 35 Black male unknown threat   No No
Morristown, TN 25OCT2019 Anthony John Michael Zapier 19 White male vehicle attack not No No
Ooltewah, TN 14SEP2019 James Hilton Glaze 76 White male gun point not Yes No
Pigeon Forge, TN 15APR2019 Samuel Charles Talbott   White male knife threat not Yes No
Smith County, TN 19DEC2019 Gary Wayne Madewell 38 White male knife threat   No No
Smyrna, TN 28JUN2019 William Lamb 76 White male gun shoot not No No
Soddy Daisy, TN 19SEP2019 John Emory Sawyer III 74   male unknown threat not Yes No
Walter Hill, TN 06FEB2019 Allon Jones 43 Black male gun point not Yes No
Whitehaven, TN 02JAN2019 Abdoulaye Thiam 20 Black male knife threat not No Yes

statecode=TX

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=TX

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Amarillo, TX 04JAN2019 Jeremy Dean Duncan 39 White male vehicle attack car No No
Amarillo, TX 30MAY2019 Isaac Ray Ruiz 22 Hispanic male gun shoot foot No No
Arlington, TX 11JAN2019 Treshun Symone Miller 20 Black male gun shoot foot No No
Arlington, TX 01AUG2019 Margarita Victoria Brooks 30 White female unarmed accident not No No
Arlington, TX 14SEP2019 Nicholas Walker 31 Black male replica point not Yes Yes
Austin, TX 29JAN2019 Paul Cantu 27 Hispanic male gun point car Yes Yes
Austin, TX 28APR2019 Carlos Manuel Dodero 45 Hispanic male gun threat not Yes Yes
Austin, TX 31JUL2019 Mauris Nishanga DeSilva 46 Asian male knife move not Yes No
Austin, TX 22SEP2019 Fred Louis Babcock 74 White male gun shoot not No No
Bacliff, TX 28JUN2019 Zackary Ryan Hoppe 40 White male gun point not No No
Baytown, TX 13MAY2019 Pamela Shantay Turner 45 Black female other attack not No No
Beaumont, TX 08OCT2019 Crederick Joseph 37 Black male blunt_object attack not No No
Beaumont, TX 14NOV2019 Kennith Waynon Hooker 52 White male knife attack not No No
Boerne, TX 11APR2019 Marcus McVae 34 Black male unarmed attack foot No No
Bracketville, TX 13SEP2019 25   male gun shoot not No No
Brownsville, TX 17JUN2019 Mark Anthony Galvan 20 Hispanic male vehicle attack car No No
Brownsville, TX 15DEC2019 Mario Alberto Torres 27 Hispanic male gun shoot not No No
Burnet, TX 27MAR2019 Brandon Michael Jacque 25 White male vehicle attack not No Yes
Canutillo, TX 11APR2019 Christopher Michael Alderete 20 Hispanic male gun point not No No
Carrollton, TX 23FEB2019 Sterling Durant Humbert 28 White male gun point car No Yes
Carrollton, TX 05OCT2019 Christopher Massey 33 White male gun attack not No No
Cedar Hill, TX 02MAY2019 Jorge Albert Merino 37 Hispanic male gun threat car No No
Cinco Ranch, TX 12FEB2019 Christopher Brimsey 20 Black male gun shoot car No No
Cinco Ranch, TX 12FEB2019 Patrick Reed 19 Black male gun shoot car No No
Cochran County, TX 27MAR2019 Leonardo Gallegos Jr. 40 Hispanic male gun shoot car No No
Corpus Christi, TX 13OCT2019 Emilio Mojica 22 Hispanic male blunt_object threat not Yes Yes
Dalhart, TX 14APR2019 Augustus Combs 27 White male gun move foot No No
Dallas, TX 17JUN2019 Brian Isaack Clyde 22 White male gun shoot foot Yes No
Dallas, TX 14JUL2019 Dijon D. Watkins 30 Black male gun shoot not No No
Dallas, TX 27JUL2019 Jamal Muhammad 42 Black male gun shoot not No No
Dallas, TX 17AUG2019 Schaston Theodore Lamarr Hodge 27 Black male gun point car No Yes
Dallas, TX 26SEP2019 Eric DeWayne Curtis 25 Black male gun point not No No
Edinburg, TX 06FEB2019 Hunter Alan 48 White male knife point not Yes No
El Paso, TX 14JAN2019 Louis Jose Burrus 25 Hispanic male gun threat foot No No
El Paso, TX 03JUL2019 Christine Soto Venegas 38 Hispanic female replica point not No No
El Paso, TX 23OCT2019 Matthew Wayne Sutton 47 White male vehicle attack car No No
El Paso, TX 17DEC2019 Paul Jarvis 63   male gun shoot   No No
Fairfield, TX 01MAR2019 Eduardo Munoz 29 Hispanic male unarmed threat not No No
Fairfield, TX 01MAR2019 Eduardo Munoz 26 Hispanic male undetermined threat not No No
Farmers Branch, TX 12JUN2019 Juan Manuel Moreno Jr. 35 Hispanic male unarmed move car No No
Fort Worth, TX 01JUN2019 Cody Wayne Seals 38 White male blunt_object point not Yes No
Fort Worth, TX 09JUN2019 JaQuavion Slaton 20 Black male gun threat foot No No
Fort Worth, TX 18JUL2019 Makeyvion Devonte Cannon 19 Black male gun shoot not No Yes
Fort Worth, TX 11AUG2019 John Michael George 46 White male gun point not No No
Fort Worth, TX 21AUG2019 Amari Malone 18 Black male gun point foot No Yes
Fort Worth, TX 12OCT2019 Atatiana Jefferson 28 Black female unarmed accident not No Yes
Garland, TX 25JAN2019 Russ Allen McClellan 48 White male gun point not Yes No
Garland, TX 09AUG2019 Jason Xavier Salas 52 Hispanic male knife attack not No No
Hopkins County, TX 11JUN2019 Jimmy De Odell 61 White male unknown threat not No No
Houston, TX 04JAN2019 Lawrence Thompson III 32 Black male gun point not Yes No
Houston, TX 06JAN2019 Nil Houer 38 Asian male gun threat not No No
Houston, TX 28JAN2019 Rhogena Nicholas 58 White female unarmed attack not No No
Houston, TX 28JAN2019 Dennis Tuttle 59 White male gun shoot not No No
Houston, TX 24MAY2019 Carlvon Mayo 35 Hispanic male gun threat not No No
Houston, TX 28JUN2019 24 White male gun shoot car No No
Houston, TX 28JUL2019 Aric Rashaad Moody 16 Black male gun move car No No
Houston, TX 12SEP2019 Brandon Bell 17 Black male gun shoot foot No No
Houston, TX 16SEP2019 Anthony Lonnie White 27 Black male gun shoot foot No No
Houston, TX 28DEC2019 Albert Benjamin Simon 52 White male gun move foot No No
Houston, TX 30DEC2019 Davion Edison 18 Black male gun shoot other No Yes
Katy, TX 15SEP2019 Jason Paul Delarosa 41 White male gun point foot No No
Kerrville, TX 02SEP2019 Tommy Luke Hranicky 17 White male knife move not No No
Killeen, TX 27FEB2019 James Scott Reed 40 Black male gun shoot not No No
Kountze, TX 07OCT2019 Joshua Chase Conner 31 White male knife threat not No No
Lake Jackson, TX 16JUL2019 Brandon Ray Stansel 36 White male gun shoot car No No
Lake Jackson, TX 16JUL2019 Kelly Danielle Brumley 40 White female gun shoot car No No
Lantana, TX 29JUN2019 Jack Daniel West 61 White male gun point not No Yes
League City, TX 19JUL2019 Jeffrey Bodie 39 White male gun point not Yes No
League City, TX 11DEC2019 Matthew Jonathan Krupar 31 White male unarmed attack not No No
Longview, TX 07AUG2019 Detravian Allison 18 Black male gun point not No No
Longview, TX 29SEP2019 Dewayne Morgan 37 White male unarmed attack foot No No
Marshall, TX 05DEC2019 Demetrius Williams 31 Black male vehicle attack foot No No
Midland, TX 08JAN2019 Jerald Wilson 33 White male blunt_object attack not Yes No
Midland, TX 30JAN2019 Anthony Patrick Pellissier 52 White male unknown point not No No
Mission, TX 20JUN2019 Juan Carlos Chapa Jr. 33 Hispanic male gun shoot foot Yes No
Monahans, TX 09MAR2019 Rodney Lassiter 30 Black male gun shoot not Yes No
Nacogdoches, TX 07SEP2019 Terry Wayne Phipps 40 White male knife move not No No
New Boston, TX 16MAY2019 Elizabeth Harris 58 White female gun shoot not Yes No
Odessa, TX 14JAN2019 Damon Murad Asad 33 White male gun shoot not No No
Odessa, TX 26MAY2019 Billy Wade Webber 48 White male gun point   No No
Odessa, TX 31AUG2019 Seth Aaron Ator 36 White male gun shoot car Yes No
Odessa, TX 01NOV2019 Luis Fino Nabarrette III 38 Hispanic male gun point car No No
Palestine, TX 19OCT2019 Terry Countryman 34 White male gun;vehicle shoot other No No
Pearland, TX 15JUN2019 Derrick Edmond 18 Black male gun threat not No No
Plainview, TX 14SEP2019 Jose Orona 33 Hispanic male gun point not Yes No
Poteet, TX 22FEB2019 Felipe Martinez Jr. 36 Hispanic male knife flee car No No
Quanah, TX 09MAR2019 Tommy Wayne Welch 59 White male knife undetermined not No No
San Antonio, TX 02JAN2019 Arron Thomas Lambert 33 White male other attack other No No
San Antonio, TX 03JAN2019 Samuel Garcia 39 Hispanic male gun shoot   No No
San Antonio, TX 04MAR2019 Daniel Moncada 27 Hispanic male gun shoot not No No
San Antonio, TX 04MAR2019 Jeremy Ponce 17 Hispanic male gun shoot car No No
San Antonio, TX 20MAR2019 Hannah Westall 26 White female replica point not Yes No
San Antonio, TX 28MAR2019 Augustine Gutierrez 42 Hispanic male gun threat car No No
San Antonio, TX 25JUN2019 Tomas Hernandez 35 Hispanic male knife move not Yes No
San Antonio, TX 31JUL2019 Jose Baca-Olivares   Hispanic male gun shoot not No No
San Antonio, TX 06NOV2019 Raul Casas Campo 34 Hispanic male gun move   No No
San Antonio, TX 23DEC2019 Macario Hernandez 34 Hispanic male gun threat car No No
San Marcos, TX 04JAN2019 John Richard Camacho 27 White male replica move car No No
Sanger, TX 16SEP2019 Kristopher Adams 37 White male gun point foot No No
Seminole, TX 24JUN2019 Peter Alexander Bohning 34 White male knife attack not No No
Snyder, TX 07FEB2019 Morgan Shane West 38 White male unarmed undetermined not No No
Sweetwater, TX 23OCT2019 Jordan Wade Waldrop 34 White male gun shoot not No No
Temple, TX 02DEC2019 Michael Dean 28 Black male unarmed undetermined not No No
Waco, TX 01MAR2019 Lorne Kyle Ashmore 50 White male knife attack not No No
Watauga, TX 22APR2019 James Freeman 46 White male gun point not No No
Willis, TX 05NOV2019 Christopher Alan Noe 45 White male knife threat car No No

statecode=UT

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=UT

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Cedar City, UT 11NOV2019 James Aubrey Sr. 56   male gun point not No No
Emery County, UT 21DEC2019 Mark Stoddard 40 White male gun point car No No
Layton, UT 08OCT2019 Zachary Aldrige Hall 28 White male vehicle attack car No No
Ogden, UT 16AUG2019 Jovany Mercado-Bedolla 26 Hispanic male knife attack not No Yes
Roy, UT 31JUL2019 Donald Lee Joseph 37 White male unknown threat   No No
Salt Lake City, UT 08APR2019 Harold Vincent Robinson 37 Black male gun shoot car No No
Salt Lake City, UT 15JUL2019 Michael Anthony Brand 43 White male replica threat not Yes Yes
Salt Lake City, UT 05AUG2019 Riche Antonio Santiago 29 Hispanic male gun shoot not No Yes
South Ogden, UT 27DEC2019 Frederick Jeremy Atkin 42 White male undetermined undetermined car No No
Wellington, UT 10SEP2019 Bobby Ray Duckworth 26 Black male knife threat not Yes Yes
West Jordan, UT 05JUL2019 Jose Martinez 34 Hispanic male knife threat foot No No
West Valley City, UT 23AUG2019 Chad Michael Breinholt 31 White male unarmed threat not No Yes

statecode=VA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=VA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Farmville, VA 04FEB2019 Corey Johnson 44 Black male gun shoot not No No
Hiltons, VA 01MAY2019 Timothy Manuel 28 White male gun shoot foot No No
Newport News, VA 17AUG2019 Uzzle Jerome   Black male gun shoot car No No
Newport News, VA 27DEC2019 Henry Kistler Berry III 43 White male other attack not No No
Richmond, VA 17SEP2019 Gay Ellen Plack 57 White female knife point not Yes Yes
Roanoke, VA 16OCT2019 Chase Andrew Austin 28 White male gun point other No No
Timberville, VA 26JUN2019 Michael Norquest 50 White male knife attack not No No
Timberville, VA 07JUL2019 Johnny W. Dellinger Jr. 41 White male gun threat not No No
Virginia Beach, VA 09FEB2019 Jeffrey D. Tyree 57 White male knife attack not Yes No
Wytheville, VA 09MAY2019 William R. Clark 31   male vehicle attack car No No

statecode=VT

statecode=WA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aberdeen, WA 09SEP2019 Kristopher Fitzpatrick 41 White male gun point foot No No
Auburn, WA 20MAY2019 Enosa Strickland Jr. 26 Black male knife attack not No No
Auburn, WA 31MAY2019 Jesse Sarey 26 Asian male unarmed threat not Yes No
Black Diamond, WA 22NOV2019 Anthony Chilcott 36 White male vehicle attack not No No
Centralia, WA 18JUN2019 Josh Flores 18 Hispanic male knife threat not No No
Eatonville, WA 29NOV2019 Shawn Wilcox   White male replica threat car No No
Everett, WA 09NOV2019 Ryan D. Hemmingson 44 White male knife threat not Yes No
Federal Way, WA 14MAR2019 27   male gun shoot not No No
Federal Way, WA 31DEC2019 Malik Williams 23 Black male gun shoot not No No
Franklin County, WA 18NOV2019 Dante Redmond Jones 28 Black male vehicle shoot car No No
Glenoma, WA 03MAR2019 Robert D. Richardson 40   male replica point not No No
Kent, WA 07JAN2019 Miguel Barraza-Lugo 38 Hispanic male gun shoot car No No
Kirkland, WA 13JUL2019 Derek Antonio-Sanchez 35 Hispanic male unarmed attack not No No
Kittitas, WA 19MAR2019 Juan Manuel Flores Del Toro 29 Hispanic male gun shoot car No No
Lakewood, WA 13JAN2019 Keith Harvey 43   male knife attack not Yes No
Longview, WA 08SEP2019 Christopher Johnson 51   male gun shoot not Yes No
Montesano, WA 16APR2019 Patrick West 42 White male knife threat not Yes No
Parkland, WA 03NOV2019 Curtis French 56 White male knife threat not Yes Yes
Pasco, WA 14DEC2019 Alejandro Betancourt-Mendoza 18 Hispanic male knife attack not No No
Poulsbo, WA 03JUL2019 Stonechild Chiefstick 39 Native American male knife threat not Yes No
Renton, WA 15JUN2019 Mantry Norris 20 Black male knife attack   Yes No
Renton, WA 12DEC2019 Anthony Tovar 43 White male replica threat not No No
Seattle, WA 07FEB2019 Danny Rodriguez 34 Hispanic male knife attack not No Yes
Seattle, WA 09MAY2019 Ryan Smith 31 Black male knife attack not Yes Yes
Spokane, WA 07JAN2019 David Novak 35 White male blunt_object attack not No Yes
Spokane, WA 23JAN2019 Dwight Steward 46 Black male knife move   No No
Spokane, WA 04MAY2019 Ethan Austin Murray 25 White male unarmed flee foot Yes No
Spokane, WA 23OCT2019 David W. Shafer 61 White male gun point not Yes No
Spokane Valley, WA 16AUG2019     male gun shoot car No No
Tacoma, WA 13JUL2019 Willem Van Spronsen 69 White male gun threat not Yes No
Tacoma, WA 21JUL2019 Hashim Jibiri Wilson 28 Black male gun point not No No
Tacoma, WA 08SEP2019 Bennie Branch 24 Black male replica undetermined foot No No
Toppenish, WA 15JUN2019 Alfredo Chino 38 Hispanic male knife threat not No No
Vancouver, WA 19FEB2019 Clayton Joseph 16 Asian male knife point not No No
Vancouver, WA 28FEB2019 Michael Pierce 29 White male gun point not Yes No
Vancouver, WA 07MAR2019 Carlos Hunter 43 Hispanic male gun threat not No No

statecode=WI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Appleton, WI 15MAY2019 Ruben Houston   Black male gun shoot not Yes Yes
Arpin, WI 11JUL2019 Logan O. Johnsrud 32 White male knife attack not Yes No
Ashland, WI 22MAY2019 Joseph M. Tedrick 33 White male gun threat car No No
Beloit, WI 10DEC2019 Montay Steven Penning 23 Black male gun move car No No
Caledonia, WI 18AUG2019 Jared R. Nelson 38 White male knife attack not No No
Fairchild, WI 02MAR2019 Tyler J. Meier 46 White male unarmed attack not No No
Fox Crossing, WI 14NOV2019 Michael A. Jolly 35 White male gun threat not Yes No
Kaukauna, WI 03SEP2019 Eduard Alexis Lopez-Ucles 34 Hispanic male vehicle threat car No No
Leon, WI 05NOV2019 Michael Lee Nguyen 32 Asian male gun move not No No
Loyal, WI 13SEP2019 Robert E. Domine 77 White male gun shoot not No No
Madison, WI 27OCT2019 Dean Thomas 63 White male gun shoot not No No
Menasha, WI 25JUN2019 Shawn D. Blowers 43 White male knife threat not No No
Milwaukee, WI 07MAY2019 Cesar Tomix Sarmiento-Molina 34 Hispanic male gun threat not No No
Milwaukee, WI 15DEC2019 Kean Walker 23 White male gun shoot car No No
Racine, WI 15JUN2019 Ty'Rese West 18 Black male unknown move other No No
Two Rivers, WI 04NOV2019 Nash Fiske 31 White male gun threat not No No
Waukesha, WI 10FEB2019 Ted Schmitz 58 White male replica threat not Yes No
West Kewaunee, WI 19NOV2019 Luis A. Cardona 38 Hispanic male gun shoot   No No

statecode=WV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Charleston, WV 01AUG2019 Eric Toon 36 White male gun point other No No
Clarksburg, WV 04FEB2019 Robert Matz 80 White male gun point not No No
Cross Lanes, WV 31DEC2019 Michael Vincent Davis 49 White male gun shoot foot No No
Drennen, WV 01OCT2019 Jack Thomas Naylor 50 White male gun shoot not No No
Huntington, WV 24SEP2019 Jarod Lee Smith 41   male gun shoot not No No
Hurricane, WV 06JAN2019 Kevin Shawn Hanson 42 Black male gun shoot car No No
Montgomery, WV 11FEB2019 Eric Young 34 White male unarmed move not Yes No
Morgantown, WV 06MAR2019 Donqaule Maurice Gray 25 Black male gun shoot foot No No
Ona, WV 30OCT2019 Michael Pinkerman Jr.   White male gun shoot not No No
Pentress, WV 17APR2019 John Stewart, Jr. Jr. 46 White male knife attack foot Yes Yes
Pocahontas County, WV 05AUG2019 William Biggs 43 White male gun shoot car No No
Walton, WV 22FEB2019 Timothy Rhodes 28 White male gun attack not No No
Welch, WV 29APR2019 Shawna Widemann 49 Asian female blunt_object threat not No No

statecode=WY

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WY

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Riverton, WY 21SEP2019 Anderson Antelope 58 Native American male knife attack not Yes No