Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2021

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?
Fairbanks, AK 06MAR2021 Jessie Peter 27 White male gun point   No No
Fairbanks, AK 25JUN2021 Dimitri Lanahan 23 White male replica point not No No
Holy Cross, AK 25MAY2021 Devyn Walker 34   male gun shoot not No No
Salcha, AK 08OCT2021 Scott W. Hottinger 35 White male gun shoot   No No
Selawik, AK 19AUG2021 Douglas Brown Jr. 26 Native American male gun threat   No No
Wasilla, AK 13MAR2021 Douglas William Stroble 25 White male gun point not No No
Wasilla, AK 26AUG2021 Zaqua Radle-Maxson 27 Native American male replica threat car 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 20JAN2021 Eusi Malik Kater Jr. 21 Black male gun shoot foot No No
Birmingham, AL 04APR2021 Desmon Montez Ray Jr. 28 Black male gun shoot other No Yes
Birmingham, AL 16MAY2021 Brian Timothy Dunne 39 White male gun shoot   No No
Birmingham, AL 14JUN2021 Armondo Contreras 43 Hispanic male blunt_object attack foot No No
Blount County, AL 18MAY2021 Timothy James Hogland 32 White male gun shoot car No No
Columbiana, AL 04JAN2021 Amanda Faulkner   White female vehicle attack not No No
Cottonwood, AL 27JUL2021 Justin Roberts 35   male gun threat not No No
Cullman County, AL 06AUG2021 Nathan Larry Parsons 49 White male undetermined undetermined   No No
Dora, AL 27FEB2021 Roger Dale Gibson 27   male undetermined undetermined   No No
Dothan, AL 19APR2021 Doward Sylleen Baker 39 Black male gun shoot car No No
Dothan, AL 10OCT2021 Perry Lamar Stringfellow Jr. 50 White male vehicle attack   No No
Fruithurst, AL 22MAR2021     male gun point car No No
Jemison, AL 31MAY2021 Roger Dale Keller 71 White male gun shoot not No No
Lee County, AL 19JUN2021 Jeff Melvin 20 Black male gun point   Yes No
Malbis, AL 18JUL2021 Clint Dearman 35 White male gun threat car No Yes
Mobile, AL 26JAN2021 Edward Bittner 37 White male knife threat foot No Yes
Mobile, AL 04FEB2021 Treyh Webster 18 Black male gun shoot not No No
Montgomery, AL 18MAY2021 Gary Moncrief 32 Black male gun shoot   No No
Odenville, AL 20MAR2021 Gerald Wayne Marlin Jr. 41 White male gun shoot car No No
St. Clair County, AL 18JAN2021 Kevin Darion Wells 56 White male gun point not No No
Tuscaloosa, AL 15APR2021 Roderick Marcell Inge 29 Black male gun shoot other No Yes
Walker County, AL 26FEB2021 Frederick Earl Height II 26 White male undetermined undetermined   Yes No
Walker County, AL 10JUN2021 Gregory Hambric 64   male gun threat   No No
Wetumpka, AL 28JUL2021 Jonathan Andrew Pears 32 White male knife threat 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?
Austin, AR 13MAR2021 Dustin Roy Black 24 White male gun point not No No
Bentonville, AR 10JAN2021 Brian Williams 37 White male knife attack not No No
Conway, AR 24OCT2021 Nicholas Smith 35 Black male gun shoot not No No
Fort Smith, AR 17OCT2021 Christofer Cason Conner Sr. 40 White male knife attack not No No
Green Forest, AR 05JUN2021 Maung Tway 34 Asian male knife threat   No No
Harrison, AR 16JUN2021 David Aaron King 40 White male knife threat not No No
Hot Spring, AR 11FEB2021 Jacob Aaron Thomas 29 White male gun shoot foot No No
Hot Springs, AR 02JUN2021 Timothy Andrew Kemp Jr. 34 White male gun attack other No No
Lonoke, AR 21JUN2021 Hunter Brittain 17 White male undetermined undetermined   No Yes
Ozark, AR 01MAR2021 Adam Cunningham 46 White male blunt_object threat other No No
Perryville, AR 19JAN2021 Robert Laudell Bull 55 White male gun shoot not No No
Sparkman, AR 07MAR2021 Joel R. Weldon 43 White male gun shoot car No No
Texarkana, AR 26JUN2021 Don Crowson 37   male unknown threat not No Yes

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?
Buckeye, AZ 26DEC2021 Vincent Black 31 White male knife attack not No No
Casa Grande, AZ 23APR2021 Edward Robbesom 52 White male gun threat not No No
Chandler, AZ 02JAN2021 Anthony Bernal Cano 17 Hispanic male gun threat other No Yes
El Mirage, AZ 10AUG2021 Johan Alexis Salaza 21   male gun point foot No Yes
Glendale, AZ 03MAY2021 Mariano Villegas 45 Hispanic male blunt_object threat not No No
Glendale, AZ 09MAY2021 Maxwell Jerome Davis 28 White male unknown threat foot No No
Glendale, AZ 03NOV2021 Jose Enrique Cortez 26 Hispanic male vehicle attack other No No
Goodyear, AZ 17JAN2021 Daniel Canales Jr.   Hispanic male undetermined undetermined   No No
Kingman, AZ 17APR2021 Bradley Michael Rose 29 White male undetermined threat car No No
Mesa, AZ 06FEB2021 Keenan Sailer 23 White male gun point not Yes Yes
Nogales, AZ 24MAY2021 Glen Ray Cockrum Jr. 39 White male undetermined flee car No No
Paradise Valley, AZ 30JAN2021 Kenneth Michael Dallas 61 White male gun threat not No No
Payson, AZ 04JAN2021 Michael Romo 28 White male knife threat not No No
Payson, AZ 24AUG2021 31   male unarmed move   No No
Peoria, AZ 17MAY2021 Garrett Sheppard 32 White male undetermined attack   No Yes
Phoenix, AZ 09JAN2021 Paul Bolden 37 Black male gun shoot foot No Yes
Phoenix, AZ 12JAN2021 Antonio Carbajal 23 Hispanic male gun threat other No Yes
Phoenix, AZ 06FEB2021 Anthony Greco 29 White male gun point foot No No
Phoenix, AZ 24MAR2021     male knife;vehicle attack car No No
Phoenix, AZ 03APR2021 Jose Arenas 26 Hispanic male gun point foot No No
Phoenix, AZ 08JUL2021 Stanley Howard 64 White male replica point not Yes No
Phoenix, AZ 20JUL2021 Miguel F. Hernandez-Rodriguez 31 Hispanic male knife point not No No
Phoenix, AZ 15SEP2021 Kenzie Keyes 30 White female gun point foot No No
Phoenix, AZ 12NOV2021     male gun shoot car No No
Prescott Valley, AZ 16JAN2021 65   male gun shoot   Yes No
Saint Michaels, AZ 24FEB2021     male gun point car No No
San Tan Valley, AZ 26MAY2021 Efren Gomez 80   male knife threat not No No
Tempe, AZ 29SEP2021 Stephen Phil Franco 37 Hispanic male gun move not No No
Tucson, AZ 20JAN2021 Bradley Alexander Lewis 19 White male undetermined   car No No
Tucson, AZ 01FEB2021 Andrew Scott Kislek 34 White male vehicle attack other No No
Tucson, AZ 22MAR2021 Edward Kayer 42 White male gun shoot foot No No
Tucson, AZ 31MAY2021 Joshua Lee Moore 33 White male gun point not No Yes
Tucson, AZ 04JUN2021 Raymond Edwards 45 White male knife threat not No Yes
Tucson, AZ 18JUL2021 Leslie Stephen Scarlett 35 Black male gun shoot car No No
Tucson, AZ 05OCT2021 Donte Lorenzo Laster 23   male gun shoot   No No
Tucson, AZ 29NOV2021 Richard Lee Richards 61 White male knife move   No No
Wilcox, AZ 10JUN2021 Josiah Li’Shon Byard 21 Black male gun shoot car 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?
Alta Sierra, CA 04FEB2021 Ariella Sage Eloise Crawford 33 White female knife attack   Yes No
Altadena, CA 10JAN2021 Allen Mirzayan 48 White male knife attack not No No
Anaheim, CA 31AUG2021 Robert Nelson 55 White male unknown threat not No No
Antioch, CA 10DEC2021 Guadalupe Zavala 55   male unarmed undetermined foot No No
Arleta, CA 28JUN2021 Christopher Garcia 26 Hispanic male gun move car No Yes
Azusa, CA 28JUN2021 Jerome Barber 59 Black male knife threat not No No
Bakersfield, CA 27APR2021 Dalton James Gerrit Kooiman 20 White male gun shoot other No Yes
Bakersfield, CA 14JUN2021 Jose Antonio Ruiz III 25 Hispanic male gun shoot other No Yes
Bakersfield, CA 24JUN2021 Abraham Torres Meza 30 Hispanic male gun threat other No Yes
Bakersfield, CA 07AUG2021 Che Noe Zuniga Jr. 21   male unarmed undetermined car No Yes
Bakersfield, CA 13AUG2021     male undetermined undetermined not Yes Yes
Bakersfield, CA 06OCT2021 Fidel Bedolla 55   male gun point   No No
Barstow, CA 31MAR2021 Lance Montgomery Powell 60 White male gun shoot   No No
Barstow, CA 09JUN2021 Juan DeLaCruz Rodriguez Jr. 58 Hispanic male vehicle attack car No No
Barstow, CA 15AUG2021     male gun threat foot No No
Beaumont, CA 31DEC2021 Dennis McHugh 44 White male vehicle attack car No Yes
Buena Park, CA 03SEP2021 Cedric Baxter 60 Black male undetermined flee car No No
Burbank, CA 08MAR2021 David William Kahler 30 White male gun point   No No
Calexico, CA 14JUN2021 65 Hispanic male knife attack not No Yes
Campo, CA 14MAY2021 Silvestre Vargas Estrada 26   male undetermined undetermined car No No
Carmichael, CA 15JAN2021 Kershawn Geyger 24 Black male gun shoot not No No
Castaic, CA 11AUG2021 Adrian Joel Sanchez 34 Hispanic male vehicle attack other No No
Commerce, CA 12NOV2021 Wendy Flores de Roque 40 Hispanic female knife attack not No Yes
Corona, CA 02APR2021     male undetermined undetermined   No No
Corona, CA 12DEC2021 Cristian Alanzo Anguiano 32   male knife threat not No No
Costa Mesa, CA 19FEB2021 Jose David Valdez 34 Hispanic male vehicle attack car No Yes
Crescent City, CA 25AUG2021 Robert Anderson 38 Black male knife threat not No Yes
Daly City, CA 07APR2021 Roger Cornelius Allen 44 Black male replica threat not No No
Danville, CA 11MAR2021 Tyrell Wilson 32 Black male knife threat not No Yes
Delano, CA 25SEP2021 Sandra Barajas 30 Hispanic female knife attack not No No
Dixon, CA 31JAN2021 Karl Walker 29 Black male gun point not No No
El Cajon, CA 19AUG2021     male gun shoot   No No
El Monte, CA 15FEB2021 Francisco Eduardo Flores 30 Hispanic male undetermined attack foot No No
El Sereno, CA 28SEP2021 Leonel Chavez 24 Hispanic male undetermined move not No No
Encinitas, CA 18JUN2021 Eric Scott Anderson 40   male gun threat   No No
Escondido, CA 21APR2021 Steven John Olson 59   male blunt_object threat not Yes Yes
Escondido, CA 17SEP2021 Jonathan Carroll 38   male gun shoot car No No
Escondido, CA 27DEC2021 Roberto Salgado 39   male gun shoot car No No
Fontana, CA 13FEB2021 Daverion Kinard 28 Black male unarmed flee foot No Yes
Fontana, CA 22JUN2021     male vehicle flee car No No
Fremont, CA 24MAR2021 Joshua James Gloria 34 Hispanic male gun threat car No Yes
Fremont, CA 01APR2021 Stephen Patrick Moseley 36 Black male gun point foot No Yes
Fremont, CA 25AUG2021 Kevin Victor Johnson 25   male gun shoot   No Yes
Fresno, CA 20JAN2021 Frank Gonzales 38 Hispanic male blunt_object attack not No Yes
Gilroy, CA 08SEP2021 David Lopez 40 Hispanic male gun shoot not No Yes
Glendora, CA 04AUG2021 Dylan Harmer 21 White male gun point foot No No
Guadalupe, CA 22AUG2021 Juan Luis Olvera-Preciado 59 Hispanic male unarmed accident not No No
Hayward, CA 16MAR2021 Caleb Smith 22 Black male vehicle attack car No Yes
Hayward, CA 17APR2021 Matthew Harry 26   male gun shoot not No Yes
Highland, CA 18AUG2021 Ervin Olikong 34   male gun shoot   No No
Homeland, CA 26JAN2021 Steven Emmett Crosby 38 White male gun shoot   No Yes
Humboldt County, CA 09SEP2021 Charles David Chivrell 35 White male gun threat foot No Yes
Huntington Beach, CA 25SEP2021 Ronnie Andrew Garcia 43 Hispanic male gun move   No No
Huntington Beach, CA 27DEC2021     male gun threat   No No
Indian Wells, CA 15FEB2021 Royce Robertson 33 White male gun threat car No Yes
Kings County, CA 23MAY2021 Manuel Beltran Moreno 30 Hispanic male gun shoot car No No
La Habra, CA 06AUG2021 Matthew Tuan Tran 22   male gun threat not No No
La Quinta, CA 29JAN2021 Javiar Magdaleno 60 Hispanic male gun shoot not No No
Lompoc, CA 28MAR2021 Krys Brandon Ruiz 26 Hispanic male knife threat not No Yes
Lompoc, CA 09OCT2021 Travis Daniel Carlon 32   male gun point not No No
Long Beach, CA 06FEB2021 Anthony Loia 26 Hispanic male gun point   No Yes
Long Beach, CA 02APR2021     female gun point not Yes Yes
Long Beach, CA 27SEP2021 Manuela Rodriguez 18 Hispanic female unarmed flee car No No
Los Angeles, CA 27JAN2021 Randy Miller 55 Black male knife attack not No No
Los Angeles, CA 14MAR2021 David Ordaz Jr. 34 Hispanic male knife threat not Yes No
Los Angeles, CA 16MAR2021 Jorge Armando Cerda 37 Hispanic male gun shoot not Yes No
Los Angeles, CA 19MAR2021 Samuel Ponce 45 Hispanic male knife attack foot Yes Yes
Los Angeles, CA 29MAR2021 Matthew Blaylock 38 Black male gun threat foot No No
Los Angeles, CA 24APR2021 Richard Solitro 34 White male unarmed move not Yes Yes
Los Angeles, CA 27APR2021 Carlos Lopez-Melendez 50 Hispanic male gun shoot car No No
Los Angeles, CA 29APR2021 Alfredo Aceves 64 Hispanic male gun point   No No
Los Angeles, CA 15JUL2021 Matthew James Sova 48 White male replica point not No Yes
Los Angeles, CA 26JUL2021 Hermenegildo Gonzalez Jr. 58 Hispanic male knife attack not No No
Los Angeles, CA 23SEP2021 Barry Ross 34 White male gun point car No No
Los Angeles, CA 03OCT2021 Christopher Mosco 32 White male gun point   Yes No
Los Angeles, CA 05OCT2021 Jesse Medrano 35 Hispanic male gun shoot not No No
Los Angeles, CA 08OCT2021 Rudy Anderson 45 Black male gun attack not No Yes
Los Angeles, CA 13OCT2021 Carlos Arias 36 Native American male knife threat not No No
Los Angeles, CA 21NOV2021 John Anthony Holenbeck 28 Hispanic male gun shoot not No No
Los Angeles, CA 18DEC2021 Margarito Lopez 22 Hispanic male knife move not Yes Yes
Los Angeles, CA 18DEC2021 Rosendo Olivio 34 Hispanic male knife move not No No
Los Angeles, CA 23DEC2021 Valentina Orellana-Peralta 14 Hispanic female unarmed accident foot No Yes
Los Angeles, CA 23DEC2021 Daniel Elena Lopez 24 Hispanic male unknown attack   No No
Los Angeles, CA 26DEC2021 Enrique Ruiz 33 Hispanic male knife threat   No No
Menifee, CA 15JUN2021 Juan Miguel Bejar 37 Hispanic male gun;vehicle attack other No No
Merced, CA 22NOV2021 Rodolpho Antonio Ruiz 27 Hispanic male gun threat foot No No
Milpitas, CA 15OCT2021 Michael Edward Nelson Jr. 42   male gun threat not No Yes
Modesto, CA 18MAY2021 Xander Mann 16 White male undetermined flee car No Yes
Monterey Park, CA 17MAY2021     male knife attack not No No
Moreno Valley, CA 03APR2021 Juan Carlos Estrada 40 Hispanic male undetermined move not No No
National City, CA 08OCT2021 Brian Robert Umana 28 Hispanic male knife point not No Yes
North Richmond, CA 15DEC2021 Sergio Baldemar Escalera Valdez 45   male replica threat car No No
Norwalk, CA 23JUN2021 Frederick Holder 28 Black male undetermined threat car No No
Oakland, CA 13SEP2021 Michael Jonathan Cortez 30 Hispanic male gun threat foot No No
Oakland, CA 20NOV2021 26 Hispanic male gun;vehicle shoot   No No
Ontario, CA 22FEB2021 Joseph Anthony Benavente 23 Hispanic male vehicle attack car No Yes
Ontario, CA 12JUL2021     male vehicle flee car No No
Palm Springs, CA 14OCT2021 Russell Leggett 30 White male gun shoot car No No
Pasadena, CA 23NOV2021 Devin Edward Hall 24 Black male gun shoot foot No No
Paso Robles, CA 06JUL2021 Steven Adam Calderon 32 Hispanic male gun shoot   No No
Pittsburg, CA 20MAY2021 Patrick Watkins 31   male gun point not No Yes
Placentia, CA 29MAY2021 Matthew Wong 33 Asian male gun shoot not No Yes
Rancho Cucamonga, CA 08OCT2021 Isaac Louis Soria 28   male gun move not No No
Redding, CA 07FEB2021 Brooke Leann Blair 27 White female replica threat   No No
Redding, CA 06APR2021 Devin Wyteagle Kuykendall 26 White male gun shoot other No No
Redondo Beach, CA 25AUG2021 Kenneth Vessell 36 Black male gun;knife shoot foot No No
Rialto, CA 22OCT2021 Christian Valdez 23 Hispanic male vehicle attack foot No No
Riverside, CA 09MAR2021 Jehlani Jay Black 19 Black male gun threat foot No No
Riverside, CA 08MAY2021 Felix Jerry Marquez 34 Hispanic male gun point not No No
Sacramento, CA 18JAN2021 Robert Stephen Calderon 46 Hispanic male gun shoot car No No
Sacramento, CA 06SEP2021 Derek Pearson 53   male gun shoot not No Yes
Salinas, CA 20JUL2021 Gerardo Martinez 19 Hispanic male replica threat not No Yes
San Andreas, CA 06MAY2021 Mark Aitulagi Lavea 47 Hispanic male gun shoot not No Yes
San Diego, CA 13APR2021 Christopher Templo Marquez 36 Hispanic male gun threat other No No
San Diego, CA 23JUL2021 Jesus Salvador Valeta 22 Hispanic male gun threat other No No
San Fernando, CA 10APR2021 48   male gun shoot not No No
San Francisco, CA 19NOV2021 Ajmal Amani 41 Other male knife threat   Yes Yes
San Gabriel, CA 02JAN2021 Daniel Alvarado Jr. 38 Hispanic male gun attack not No No
San Jose, CA 21JAN2021 David Tovar Jr. 27 Hispanic male unarmed move foot No Yes
San Jose, CA 31MAY2021 Demetrious Stanley 31 Black male gun point not No No
Santa Ana, CA 28SEP2021 Brandon Lopez 34 Hispanic male undetermined flee car Yes No
Signal Hill, CA 20SEP2021 Phillip Lopez 42 Hispanic male knife attack foot No No
Siskiyou County, CA 28JUN2021 Soobleej Kaub Hawj Hawj 35 Asian male gun shoot car No Yes
Stockton, CA 11MAY2021 Lance Lowe 30 Black male gun shoot not No No
Stockton, CA 08DEC2021 Angelo Weitz 42 White male gun shoot not No Yes
Tustin, CA 09AUG2021 Luis Manuel Garcia 39 Hispanic male unarmed move not Yes No
Vacaville, CA 26JAN2021 Mark Meza 61 White male vehicle attack car No No
Van Nuys, CA 31OCT2021 Melkon Michaelidis 46 White male knife threat   Yes No
Victorville, CA 09JAN2021 Betty Lou Francois 91 White female gun point not No No
Victorville, CA 29AUG2021 Albert Perez 32 Hispanic male gun threat   No No
Visalia, CA 13JAN2021 Joshua Van Machado 43 White male gun point not No No
Visalia, CA 31MAR2021 Ivan Cuevas 27 Hispanic male knife attack not No No
Wasco, CA 25JUL2021 Jose Manuel Ramirez Jr. 41 White male gun shoot not No Yes
West Covina, CA 22NOV2021     male gun threat foot No No
West Sacramento, CA 25FEB2021 Adam John Lundt 24   male replica point   No Yes
Whitewater, CA 09APR2021 Gabriel Munoz Jr. 40   male blunt_object threat not No No
Whittier, CA 04JUN2021     male gun threat   No No
Whittier, CA 10OCT2021 Isaiah Raider Guevara 18 Hispanic male gun threat not No No
Woodville, CA 31JUL2021 Ruben Isaac Sanchez 31 Hispanic male gun shoot other No No
Yreka, CA 19FEB2021 Chad Curtis Loynachan 29 White male unarmed attack not No No
Yucca Valley, CA 31MAY2021 Bilal Winston Shabazz 29 Black male gun shoot foot 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 26JAN2021 Harmony Wolfgram 41 White female undetermined undetermined other No No
Adams County, CO 11AUG2021 Bruce Thurby 35 White male gun threat foot No No
Arvada, CO 02JUN2021 Eugene Milo Matthews 24 Hispanic male gun shoot car No No
Arvada, CO 21JUN2021 John Hurley 40 White male gun shoot not No No
Arvada, CO 17AUG2021 Destinee Thompson 27 N;H female undetermined undetermined other No No
Canon City, CO 01MAY2021 Dalton Buckholz 28 White male undetermined undetermined   No No
Centennial, CO 31JUL2021 Keith Wayne Homrighausen 49 White male gun shoot not No No
Clear Creek County, CO 21MAR2021     male gun point not No No
Colorado Springs, CO 22APR2021 Richard Quintana 37 White male gun point not Yes No
Colorado Springs, CO 03OCT2021 David Lee Jacques Jr. 24 White male gun shoot foot No No
Colorado Springs, CO 28OCT2021 Ahmad Akeem Abdul Muhammad 30 Black male gun point foot No No
Colorado Springs, CO 08DEC2021 Michael Pantoja   Hispanic male knife threat not No No
Colorado Springs, CO 10DEC2021 Xavier Miller   White male gun shoot not No No
Colorado Springs, CO 22DEC2021     male gun shoot not No No
Commerce City, CO 28JUN2021 Robert Alire   Hispanic male knife point not Yes No
Denver, CO 14MAY2021 Cedrick Vick 22 White male gun threat car No No
Denver, CO 19MAY2021 Raul Rosas-Zarsosa 52   male knife threat not No No
Denver, CO 30MAY2021 Shannon Wright 29 Black male gun threat not No No
Denver, CO 04JUN2021 Colton Frederic Wagner 31 White male gun point not No No
Denver, CO 13JUN2021 Duane Manzanares Jr. 30 Hispanic male gun threat not No No
Denver, CO 03SEP2021 Lisa Bernadette Garcia 52 Hispanic female gun point foot No No
Denver, CO 03SEP2021 Drew Lucero 37   male gun shoot   No No
Douglas County, CO 03APR2021 Samuel Yeager 23 White male gun shoot   No Yes
El Paso County, CO 19APR2021 Robert Paul Garcia 38 White male vehicle attack car No No
Englewood, CO 18MAY2021 Caleb Jereme Grisenti 22 White male vehicle attack car No Yes
Fort Lupton, CO 17APR2021 Smokey Lynn Crockett 60 White male gun threat not No No
Grand Junction, CO 25JUN2021     male gun point   No No
Greeley, CO 19JAN2021 Christopher Austin Dockery 32 White male gun threat other No No
Gunnison, CO 11NOV2021 Gerry Donald Cooper 44 White male vehicle attack car No No
Hotchkiss, CO 09APR2021 Paige Pierce Schmidt 26 White female undetermined undetermined   No No
Jefferson County, CO 02SEP2021 Christopher Derby 33 White male gun point   No No
Lakewood, CO 12JAN2021 Ty Spencer Walvatne-Donahey 32 White male gun shoot foot No No
Lakewood, CO 01APR2021 Steven Ross Glass 35 White male replica threat foot No No
Lakewood, CO 20APR2021 Jason Evan Pendergast Jr. 20 White male gun shoot foot No No
Lakewood, CO 27DEC2021 Lyndon James McLeod 47 White male gun shoot car No No
Loveland, CO 16AUG2021 Alexander Domina 19 White male knife threat not Yes No
Peyton, CO 01SEP2021 Connor Riley McDaniel 26 White male gun shoot not Yes No
Pueblo, CO 15NOV2021 Gary Woodrow Joseph Boulier Jr. 59 White male gun threat   No No
Thornton, CO 18AUG2021 Lucas Antonio Salas 33   male gun shoot car No No
Weld County, CO 26MAR2021 Steven Michael Kielian 32 White male gun shoot foot No No
Westminster, CO 05DEC2021 Raul Horacio Caraveo 49   male gun shoot other No No

statecode=CT

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=CT

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Hartford, CT 06JAN2021 Benicio Vasquez 34 Hispanic male gun shoot   No No
Stratford, CT 05FEB2021 Christopher Hagans 36 Black male gun;vehicle attack not No Yes

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 06JAN2021 Ashli Babbitt 35 White female unarmed attack not No No
Washington, DC 02APR2021 Noah Green 25 Black male knife;vehicle attack not Yes No
Washington, DC 30APR2021 Terrance Maurice Parker 36 Black male gun threat   No Yes
Washington, DC 24MAY2021 Vedo Hall 26 Black male gun point foot No Yes
Washington, DC 25AUG2021 Antwan Gilmore 27 Black male gun threat not No Yes
Washington, DC 31AUG2021 George David Watson 34 Black male replica point not No Yes
Washington, DC 18OCT2021 Deandre Johnson 30 Black male unarmed attack   No Yes

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?
Seaford, DE 25MAR2021 Kelly E. Rooks 51 White female gun threat not No No
Wilmington, DE 13JAN2021 Lymond Moses 30 Black male vehicle threat car No Yes

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?
Alford, FL 16JUN2021 John Earle Barnes   White male replica point not Yes No
Boynton Beach, FL 11MAY2021 Christian Castro 27 Hispanic male knife threat   No No
Cape Coral, FL 11MAR2021 Christopher J. Lefande 49 White male gun point not No No
Clay County, FL 27FEB2021 Rudy Duvivier 32 Black male gun shoot   No No
Clearwater, FL 07SEP2021 Josue Arias 32 White male gun threat not No No
Coconut Creek, FL 30AUG2021 Brittni Muldrew 36 White female vehicle move   No No
Coral Gables, FL 12FEB2021 Brandon Jerome Wimberly 36 Black male gun shoot   No No
Coral Gables, FL 28NOV2021 Nivaldo Lazaro Echevarria 31 White male vehicle attack car No No
Davenport, FL 20JUL2021 Gilberto Martinez-Nava 37   male knife point not No No
Doral, FL 22OCT2021 Yordany Rodriguez Perez 25 White male gun shoot car No No
Escambia County, FL 12JUL2021 Johnny Ray Kirk 22 White male gun shoot not No Yes
Estero, FL 16OCT2021 Joshua Dewayne Hammock 30 White male knife attack   No No
Gainesville, FL 05MAR2021 Gregory L. Williams 32 Black male gun shoot   No No
Homestead, FL 03JAN2021 La Garion Lamar Smith 27 Black male gun shoot foot No No
Homosassa, FL 22JAN2021 Steven Verdone   White male knife threat not No No
Hudson, FL 20MAR2021 James Zambrotto 79 White male gun threat not Yes Yes
Hudson, FL 27MAR2021 Russell Lindemeyer 49 White male knife attack not No No
Jacksonville, FL 21FEB2021 Daniel Newton Neal 37 Black male gun threat foot No No
Jacksonville, FL 30MAR2021 Michael Leon Hughes 32 Black male other attack not No Yes
Jacksonville, FL 28MAY2021 Arnold Frazier Hager Jr. 37 White male gun shoot   No Yes
Lakeland, FL 07MAR2021 Howayne Gayle 35 Black male gun shoot not No No
Lakeland, FL 28NOV2021 61   male gun threat not No No
Melbourne, FL 03DEC2021 Alhaji Sow 18 Black male knife attack not Yes No
Miami, FL 16FEB2021 Juan Carlos Pena-Noda 51 Hispanic male gun threat not No No
Miami, FL 18MAR2021 Daryl L. Jordan 50 Black male gun shoot other Yes No
Miami, FL 06APR2021 Stephanie Nicole Voikin 40 White female gun shoot not No No
Miami, FL 25OCT2021 Corey Timothy Alexis Stanley 37 Black male vehicle move   No No
Miami Shores, FL 30AUG2021 Etianna Planellas 48 White female replica threat not Yes No
Newberry, FL 23SEP2021 Barry P. Heckard 39 White male gun shoot car No No
North Lauderdale, FL 15APR2021 Jeffrey Guy Sacks 26 White male knife threat not Yes No
Ocala, FL 15NOV2021 Micah D Brillhart 33 White male gun threat not No No
Orlando, FL 12AUG2021 William Guy Sellers 73 White male gun threat not Yes Yes
Palm Bay, FL 14MAR2021 Christopher Ruffin 28 Black male gun point foot No No
Pensacola, FL 17MAR2021 Acea Robert Grozdanoff 35 White male gun threat not Yes No
Pensacola, FL 19OCT2021   White male gun shoot not No No
Pine Hills, FL 05FEB2021 Phillip Francis 43 Black male gun shoot not No Yes
Pine Hills, FL 30DEC2021 Kadeem Errol Livingston Smith III 28 Black male gun threat not No No
Polk County, FL 11NOV2021 Jessiram Hweih Rivera 24 Hispanic female blunt_object threat not No No
Port Salerno, FL 24MAR2021 Peter Joseph Wayne 57 White male gun shoot not No No
Riverview, FL 07DEC2021 Ronald Ehrich 88 White male gun threat   No Yes
Saint Petersburg, FL 04OCT2021 Chad Allen Jenkins 50 White male gun threat   No No
Sanford, FL 26AUG2021 Samuel Kirk 26 Hispanic male gun shoot not No No
Tallahassee, FL 08APR2021 Raheem Reeder 38 Black male gun point not No Yes
Tampa, FL 04JUL2021 John Reuben Turbe Jr. 40 Black male gun point foot No Yes
Tarpon Springs, FL 16OCT2021 Alexander King 17 White male replica point not No No
Titusville, FL 26DEC2021 James Lowery 40 Black male unarmed attack foot No Yes
West Melbourne, FL 30AUG2021 Paris Wilder 38 Black male gun shoot not No No
West Palm Beach, FL 17OCT2021 Allan Lorenzo Robb 33 Black male knife attack not No No
Winter Haven, FL 17APR2021 Larry Jenkins 52 Black male gun threat not No No
Yulee, FL 31JUL2021 Adam S. Moser 39 White male knife move not Yes 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?
Acworth, GA 13JUN2021 Luis Rey Ruiz 20 Hispanic male gun shoot foot No No
Adel, GA 22MAY2021 Steve Newsome 31 Black male gun shoot   No No
Albany, GA 21MAY2021 Kortnee Lashon Warren 23 Black male gun shoot not No No
Allenhurst, GA 21AUG2021 Daryl Jay Carr 45 White male undetermined threat not No No
Athens, GA 18FEB2021 Timothy Daniel Statham 37 White male unarmed move foot No Yes
Athens, GA 23MAY2021 Juan Joseph Daniele Castellano 38 Black male gun threat   No No
Atlanta, GA 09JUN2021 Terrell J. Gas 36 Black male gun shoot other No No
Atlanta, GA 30JUN2021 Joseph Lee Humbles 29 Black male gun shoot not No No
Atlanta, GA 25JUL2021 Gabriel Parker 38 Black male undetermined undetermined not No No
Atlanta, GA 29AUG2021 Grey Kennerly Bell 40 White male gun threat car No No
Atlanta, GA 20OCT2021 Jarvis Jarrett 32 Black male gun shoot not No No
Barrow County, GA 24JUN2021 Steven Jesse Dylan Thompson 29 White male gun shoot car No No
Bremen, GA 12APR2021 Pier Alexander Shelton 28 Black male gun shoot car No No
Byron, GA 17NOV2021 Kevin Mark Soles Jr. 37 White male gun point foot No No
Cairo, GA 19JUL2021 Jason Lee Fralick 43 White male vehicle threat car No Yes
Camden County, GA 04MAY2021 Latoya Denise James 37 Black female gun shoot not No Yes
Catoosa County, GA 28FEB2021 Fred Bowman Trundle 54   male gun point foot No No
Centerville, GA 20MAR2021 Shawn Michael Evanuk 48 White male knife attack not No No
Chamblee, GA 22SEP2021 Irlin Paz 40 Hispanic male knife attack not No No
College Park, GA 24AUG2021 Tory Brown 22 Black male unarmed undetermined   No No
Columbus, GA 08JUN2021 Kevin Christopher Caldwell 33 White male gun shoot car No No
Covington, GA 22JUN2021 Alexander Matthew Collins 27 White male gun shoot not No No
Covington, GA 03NOV2021 Johnny Michael Gilbert 43 White male other threat not No No
Cumming, GA 24JUN2021 Yonatan Aguilera 40 Hispanic male gun threat not No No
DeKalb County, GA 31MAR2021 Willie Roy Allen 57 Black male gun threat other No No
Decatur, GA 12APR2021 Matthew Zadok Williams 35 Black male knife threat not Yes Yes
Decatur, GA 18MAY2021 Tyrone Penny 21 Black male undetermined undetermined other No No
Decatur, GA 25SEP2021 Christian Smith 33   male gun threat   No No
Douglas County, GA 01JUL2021 Jesus Rodriquez 23   male knife threat foot No No
Evans County, GA 08OCT2021 Ramone Dwight 29 Black male gun shoot other No No
Henry County, GA 09DEC2021 Arrett Carr 64   male gun point car No No
Holly Springs, GA 16JUN2021 Ansy Dolce 29 Black male vehicle attack not No No
Jackson County, GA 05NOV2021 Jessica Worsham 43 White female gun shoot not No No
Lithia Springs, GA 30MAR2021 Shelby Jean Berkheimer 41 White female gun shoot not No No
Lithonia, GA 01DEC2021 Edward Allen Gatling 38 Black male gun shoot   No No
Marietta, GA 18AUG2021 Devonte Dawayne Brown 28 Black male vehicle attack car No No
Marietta, GA 17SEP2021 Joseph Matthew Wilbanks 41   male knife threat not Yes No
Monroe, GA 24JUN2021 Ted Frank Tippy 52 White male gun shoot not No No
Morrow, GA 05DEC2021 Miguel Eduardo Perez Gonzalez 38   male gun shoot not No No
Ray City, GA 01JUN2021 Donald Myers 48 White male knife threat not No No
Reidsville, GA 14MAR2021 Kelly Shannon Bowen 51 White male gun;vehicle attack other No No
Rex, GA 30NOV2021 Arthur Allen Gilliam 35   male gun shoot   No No
Rocky Face, GA 10AUG2021 Steven Ray Bailey 63 White male gun shoot   No No
Savannah, GA 17JUL2021 Maurice Sentel Mincey 36 Black male gun threat not No Yes
Savannah, GA 21DEC2021 Shawn Martin 45 White male knife attack not No No
Savannah, GA 27DEC2021 Kevin Dubois 31 Black male gun point foot No No
Smyrna, GA 13SEP2021 Robert Parks 39 Black male unknown attack not Yes No
Smyrna, GA 18SEP2021 Unsfored Lewis Thurmond III 27 Black male gun point   Yes No
Spalding County, GA 05JUN2021 Stephen Neil Weigand 29 White male gun point car No No
Valdosta, GA 12MAR2021 Raymond Whitfield Tarbox II 43 White male knife move not No No
Waverly, GA 10DEC2021 Christopher Paul Raborn 40 White male gun threat not 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?
Hilo, HI 13JUN2021 Ryan Yukiharu Santos 34   male gun shoot not No Yes
Hilo, HI 18JUN2021 Daniel Robert Buckingham 31 White male knife attack not No Yes
Honolulu, HI 05APR2021 Iremamber Sykap 16 Asian male replica flee car No Yes
Honolulu, HI 14APR2021 Lindani Myeni 29 Black male unarmed attack   No Yes
Honolulu, HI 11AUG2021 Elia Laeli 41 Asian male knife attack not No Yes
Kakaako, HI 27AUG2021 Brandon Michael Ventura 33 Hispanic male gun point not 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?
Bettendorf, IA 07FEB2021 Brian Gregory Scott 49 White male gun threat not No No
Cedar Rapids, IA 20FEB2021 Arnell States 39 Black male knife threat   No Yes
Centerville, IA 21NOV2021 Kevin Arbogast 45 White male undetermined undetermined   No Yes
Chelsea, IA 28OCT2021 Dewey Wilfong III 28 White male gun threat   No No
Davenport, IA 13OCT2021 Bobby Klum 37 White male gun threat   No No
Iowa Falls, IA 08DEC2021 Jared Risius 35 White male vehicle threat car No No
Martelle, IA 31AUG2021 Jeremy Michael Berg 45 White male knife threat   No No
Thompson, IA 11SEP2021 James Anderson 48   male gun point   No No
Waterloo, IA 16NOV2021 Brent Lee Boggess 42 White male vehicle attack not No 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?
Bingham County, ID 14FEB2021 Bruce Diehl 51 White male gun shoot not No No
Boise, ID 24JUL2021 Forrest T. Moore 31 White male replica point not No Yes
Boise, ID 25OCT2021 Jacob James Bergquist 27 White male gun shoot not No No
Boise, ID 27OCT2021 Zachary Snow 26 White male undetermined undetermined   Yes No
Caldwell, ID 16NOV2021 Kernie Armstrong 92 White male gun point not Yes No
Coeur d’Alene, ID 07AUG2021 Hayden McIlvain     male gun shoot not No No
Garden City, ID 13APR2021 Thomas Andrew Bunde 58 White male gun point not No No
Hailey, ID 16JUL2021 Dawn M. Simpson 51 White female gun shoot car No No
Idaho Falls, ID 08FEB2021 Joseph Johnson 37 White male gun threat not No No
McCammon, ID 13OCT2021 Buddy Byron McKenzie 41 White male gun shoot car No No
Nampa, ID 26AUG2021 Vladislav Fomin 53   male gun threat not No No
Pocatello, ID 13FEB2021     male gun shoot other No No
Rexburg, ID 15FEB2021 Troy Alton Allen 50 White male undetermined threat   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?
Brighton, IL 01APR2021 James Iler 47 White male knife attack not Yes No
Buffalo Grove, IL 02DEC2021 Brian Howard 25 White male gun move not Yes No
Calumet City, IL 25MAR2021 Alvin Burrage 26 Black male gun move not No No
Calumet City, IL 27JUL2021 Losardo Lucas 55 Black male gun threat   No No
Carterville, IL 06JUL2021 Joseph D. McGrath 52 White male gun point not No No
Champaign, IL 19MAY2021 Darion M. Lafayette 24 Black male gun shoot not No No
Chicago, IL 25MAR2021 Travon Chadwell 18 Black male gun shoot foot Yes No
Chicago, IL 29MAR2021 Adam Toledo 13 Hispanic male undetermined move foot No Yes
Chicago, IL 31MAR2021 Anthony Alvarez 22 Hispanic male gun threat foot No No
Chicago, IL 09JUL2021 Klevontaye White 34 Black male gun point not No Yes
Chicago, IL 24AUG2021 Jamar Jayson Taylor 33   male gun shoot foot No No
Chicago, IL 19SEP2021 Turell Brown 28 Black male knife threat   No No
Chicago, IL 04OCT2021 Michael Craig 61 Black male unarmed undetermined   No Yes
DeKalb, IL 25OCT2021 Kristopher M. Kramer 33 White male knife point not No No
Dolton, IL 27JUL2021 Alexis C. Wilson 19 Black female vehicle attack car No Yes
East Peoria, IL 02FEB2021 Joshua Crites 19 White male unknown attack car No No
Evanston, IL 09JAN2021 Jason Nightengale 32 Black male gun shoot other No No
Forest Park, IL 24MAR2021 Tony Smith 35 Black male gun threat not No No
Joliet, IL 06NOV2021 Jabbar Muhammad 21 Black male knife attack not No No
Lena, IL 09APR2021 David William Determan 52 White male gun point not No No
New Lenox, IL 20DEC2021 Alexander Wheeler 21 White male undetermined flee foot No No
Normal, IL 30AUG2021 Ronald Reiner 66 White male gun shoot   No Yes
North Aurora, IL 10AUG2021 James Robert Wiesner 51 White male gun point not No No
Red Bud, IL 23MAY2021 Timothy J. Snyder 27 White male gun shoot other No No
Rock Island, IL 01APR2021 DeShawn Tatum 25 Black male gun threat other No No
Rockford, IL 10APR2021 Faustin Guetigo 27 Black male blunt_object threat not No Yes
Villa Park, IL 24MAY2021 Haven A. Bailey 25 White male replica threat not Yes No
Yorkville, IL 20DEC2021 Marc Barnhart 68 White male gun threat   No No

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?
Anderson, IN 23MAR2021 Irvin Silas Myers 60 White male gun point not Yes No
Bartholomew County, IN 10MAR2021 Martin Louis Douglas Jr. 30 White male gun shoot car No No
Carmel, IN 31JAN2021 Keith Scales 60 White male gun shoot not Yes Yes
Culver, IN 28NOV2021 Dylan Bush 33 White male vehicle attack car No No
Elkhart, IN 27AUG2021 Lonnel Cephas Jr. 19   male gun threat car No No
Elkhart, IN 15DEC2021 Jahad Patterson 20 Black male gun undetermined other No No
Evansville, IN 19OCT2021 Carey Hammond 46 White male unknown point not No No
Indianapolis, IN 13FEB2021 De'Aire Gray   Black male replica point foot Yes Yes
Indianapolis, IN 14MAY2021 Monolito Ford 48 Black male gun point not Yes Yes
Indianapolis, IN 01SEP2021 James Williams 33 Black male gun threat   No No
Indianapolis, IN 24SEP2021 Jessie Leonard 36 White female gun threat car No Yes
Liberty, IN 26FEB2021 Maggie A. Dickerson 29 White female knife threat not No No
Marion, IN 17JAN2021 Daniel Young 25 White male vehicle attack not No No
Munster, IN 10JAN2021 Mark Bivins 28 Black male gun shoot other No No
Putnamville, IN 05AUG2021 Chad M. Fiscus 35 White male gun shoot not No No
Rushville, IN 29NOV2021 Benjamin Petry 34 White male gun point not No No
Selma, IN 03MAR2021 Jonathan Levi Allen 28 White male gun shoot car No No
South Haven, IN 01MAY2021 Alexander Thor Tuzinski 30 White male gun threat   No No
Sunman, IN 10OCT2021 Joshua Edward Ebinger 37 White male gun point   No Yes
Valparaiso, IN 01JAN2021 Jeffrey E. Marvin 62 White male vehicle attack car No No
Wolcott, IN 15JUN2021 Perry E. Boyd 56 White male gun shoot foot 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?
Chanute, KS 20AUG2021 Brandon Lee Schlichting 28 White male gun point   No No
Kansas City, KS 20JUN2021 Dario Dominguez 25 Hispanic male gun shoot other No Yes
Kansas City, KS 25JUN2021 Dennis Delgado 60 White male gun threat   No Yes
Kansas City, KS 22NOV2021 Lionel Womack 36 Black male gun attack not No Yes
Lenexa, KS 25MAY2021 Darren Dejuan Chandler 34 Black male gun shoot   No No
Minneola, KS 09MAR2021 Jim Wright 67 White male gun threat car No No
North Topeka, KS 11JAN2021 Joseph W. Howell 49 White male gun shoot car Yes No
Plainville, KS 27JUN2021 Nicole Dechant 29 White female gun threat   No No
Topeka, KS 10SEP2021 Jesse B. Lees 33 White male gun shoot foot No No
Wichita, KS 19JUN2021 Tyler Hodge 28 White male gun shoot not No Yes
Wichita, KS 03OCT2021 Jess Jackson 41 White male gun point not Yes 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?
Caneyville, KY 21JAN2021 Brian Abbott 34 White male knife threat not No No
Covington, KY 17JUN2021 Daniel Ray 35 White male gun shoot not Yes No
Danville, KY 06JUL2021 Shelby Ray Hardin 33 White male knife attack   No No
Elizabethtown, KY 07DEC2021 Gary Lee McCormick 34 Black male undetermined undetermined   No No
Elizabethtown, KY 11DEC2021 Christopher Sterusky 29 Black male knife attack not No No
Florence, KY 30JUN2021 Jeremy Nelson 33 White male gun shoot not No No
Floyd County, KY 02DEC2021     male undetermined undetermined   No No
Frankfort, KY 11DEC2021 Robert Lee Engle 64 White male undetermined undetermined   No No
Gallatin County, KY 18SEP2021     male gun shoot   No No
Georgetown, KY 09APR2021 DeShund Tanner 31 Black male gun threat foot No No
Grant County, KY 03NOV2021 Gary Wayne Bressler Sr. 48 White male undetermined undetermined   Yes No
Hopkinsville, KY 24OCT2021 Arthur Hunt 44   male gun point foot No No
Independence, KY 01JUN2021 Jonathan Craig Thompson 29 White male gun point not No No
Louisville, KY 30MAY2021 Ryan Bernal 32 White male gun point foot No No
Louisville, KY 26OCT2021 Ivan Foster   Black male gun shoot not No Yes
Mason County, KY 29MAR2021 Terry Darnell Jackson 48 Black male undetermined attack foot No No
Middlesboro, KY 29SEP2021 Daniel Ledford 41 White male undetermined undetermined   No No
Middlesboro, KY 09OCT2021 Timothy Houston 35 White male undetermined undetermined   No No
Morgan County, KY 27FEB2021 Jerry Roseberry 48 White male undetermined undetermined   No No
Russellville, KY 11FEB2021 Brian D. Ellis 44 White male vehicle attack not No No
Shepherdsville, KY 31JAN2021 Eric Kessler 20 White male vehicle attack car No Yes
Villa Hills, KY 20FEB2021 Randall Lockaby 57 White male gun point 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?
Abbeville, LA 03MAR2021 Dwight Brown 41 Black male gun shoot   Yes Yes
Berwick, LA 01JUN2021 Robert Lee-Roy Stanley Pearce 37 White male replica threat foot No No
Crowley, LA 25JUL2021     male gun shoot   No No
Doyline, LA 09JUL2021 Mahlon Taylor 59 White male gun shoot not Yes No
Fordoche, LA 22DEC2021 Jessie Lee Gaither IV 48 Black male gun;knife threat not No No
Houma, LA 04OCT2021 Shane E. Hartman   White male other attack not No No
Houma, LA 01NOV2021 Johnny McGee 36 Black male knife attack   Yes No
Lake Charles, LA 23SEP2021 Desmond Lewis 20 Black male gun shoot not No No
Lake Charles, LA 27DEC2021 Christopher Thomas 22 Black male gun shoot not No No
Madison Parish, LA 31MAY2021 Michael Jackson 29 Black male gun threat car No No
Metairie, LA 10APR2021 Joshua Alexander Mitchell 30 Black male gun point   No No
Metairie, LA 01SEP2021 Anne Schilly 65 White female vehicle attack car Yes No
Metairie, LA 21NOV2021 Jabari Farafiai Asante-Chioke 52 Black male gun;knife threat foot No No
Montegut, LA 12JAN2021 Gary Rodriguez Jr. 54 Hispanic male gun shoot not No No
Mount Hermon, LA 18FEB2021 Dustin A. Crain 28 White male knife threat not No No
Norwood, LA 21MAY2021     male gun threat   No No
Red River Parish, LA 10MAR2021 Michael Laduca 42 White male gun flee other No No
Shreveport, LA 11SEP2021 Desmond D. Lewis 30 Black male gun attack foot No No
Slidell, LA 24JAN2021 Caleb McCree 43 White male knife point   Yes No
Vernon Parish, LA 21DEC2021 Chantel Jean Myers 44 White female gun threat not Yes No
Westwego, LA 02OCT2021 Wade Adams 58 White male gun move car Yes No
Wisner, LA 05NOV2021 Barry Rigsby 36 Black male gun shoot not No No

statecode=MA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boston, MA 09NOV2021 Dashaun Wright 37 Black male gun shoot not Yes Yes
Braintree, MA 04JUN2021 Andrew Homen 34 White male gun shoot foot No No
Dorchester, MA 06NOV2021 Michael A. Quarrles 37 Black male gun shoot not Yes No
Fall River, MA 22NOV2021 Anthony Harden 30 Black male undetermined attack   No No
Leicester, MA 09MAY2021 Zachary Richardson 24 White male gun point not No No
Newton, MA 05JAN2021 Michael Conlon 28 White male knife threat not Yes No
Quincy, MA 26MAR2021 Eric Leach 36 White male gun threat car No No
Saugus, MA 14AUG2021 Stephanie Gerardi 38 White female knife threat not Yes No
Seekonk, MA 28NOV2021 Jeffrey W. Groulx 47 White male gun shoot other No No
Winthrop, MA 26JUN2021 Nathan Allan 28 White male gun;vehicle attack car No No
Worcester, MA 21APR2021 Phet Gouvonvong Jr. 31 Asian male gun threat not No No

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 04FEB2021 Dontae Green 34 Black male gun shoot not No No
Baltimore, MD 25FEB2021 Benjamin Tyson 35 Black male gun shoot foot No Yes
Baltimore, MD 08MAY2021 Everton Brown 56 Black male gun shoot not Yes Yes
Baltimore, MD 16MAY2021 Timothy Fleming 49 Black male knife threat   No Yes
Baltimore, MD 13JUL2021 Justin Powell 32 Black male gun shoot   No No
Baltimore, MD 08AUG2021 Marcus Martin 40 Black male gun shoot not Yes No
Gaithersburg, MD 08JAN2021 Kwamena Ocran 24 Black male gun threat foot No No
Gaithersburg, MD 16JUL2021 Ryan LeRoux 21 Black male gun threat not Yes Yes
Glen Burnie, MD 28NOV2021 Digno Ramon Yorro Jr. 32 Hispanic male knife point not No No
Laytonsville, MD 06FEB2021 Kevin Costlow 52 White male blunt_object attack not No No
Leonardtown, MD 13APR2021 Peyton Ham 16 White male knife point not No No
North East, MD 11JUL2021 Jonathan Balchunas 24 White male gun threat not No No
Oxon Hill, MD 10SEP2021 Cedric Williams 29 Black male replica threat   Yes No
Pasadena, MD 18MAR2021 Leonard John Popa 79 White male gun shoot not Yes No
Silver Spring, MD 29DEC2021 Osman Sesay 27 Black male gun shoot car No No
Woodlawn, MD 11OCT2021 Jovan Lewis Singleton 36 Black male gun shoot other 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 27SEP2021 Joseph Arbour 36 White male unknown flee foot No No
Augusta, ME 13OCT2021 Dustin Jay Paradis 34 White male knife threat   No No
Falmouth, ME 19OCT2021 Daniel DiMillo 51 White male knife threat   No No
Mars Hill, ME 14APR2021 Jacob Dustin Isaac Wood 28 White male unknown threat   No No
Presque Isle, ME 08JUL2021 Shannon M. Wilcox 53   male gun shoot   No No
Waterville, ME 11FEB2021 Eric J. Porter 32 White male knife threat foot 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?
Battle Creek, MI 22DEC2021 Brian Douglas Laxton 44 White male gun shoot car No Yes
Beaver Township, MI 22MAY2021 Johnny Owen King 63   male replica threat   No No
Bennington Township, MI 10JUL2021 Randy Lee Jenkins Jr. 37 White male gun shoot   No No
Burton, MI 21DEC2021 Brendan Patrick Pinkston 23 White male gun shoot foot No No
Chesaning, MI 07JAN2021 John R. Neitling 40 White male gun point not No No
Detroit, MI 01MAR2021 Chandra Moore 55 Black male gun shoot not No No
Detroit, MI 19APR2021 27   male gun shoot other No No
Detroit, MI 08AUG2021     male gun;vehicle point   No No
Detroit, MI 19DEC2021 Nakita Williams 33 Black female replica point not Yes Yes
Detroit, MI 28DEC2021 Dwayne McDonald 62 Black male gun shoot not No No
Eaton County, MI 19MAY2021 Robert Nazmi Rouhman Jr. 19 White male vehicle move car No No
Edmore, MI 21FEB2021 Andrew Allen Courser 38 White male gun point foot No No
Flint, MI 19JUN2021 Briana Sykes 19 Black female gun shoot   No No
Galesburg, MI 14AUG2021 Kyle Anthony Goidosik 35 White male gun shoot other No No
Galesburg, MI 04OCT2021 R.V. Johnson 22 Black male knife threat not No Yes
Garden City, MI 24FEB2021 Alonte Murphy 22 Black male gun shoot not No No
Gobles, MI 26JUL2021 Jacob Bender 39 White male knife attack not No No
Heath Township, MI 21JUN2021 Virgil-Lee Taylor 31 White male unarmed move   Yes No
Iron River, MI 24JUN2021 David R. Bridgette 45   male gun point not Yes No
Kalamazoo, MI 27NOV2021 Anthony Oliver 54 Black male gun shoot   No No
Kentwood, MI 24OCT2021 Kim Douglas Ropp 60   male knife attack not No No
Niles Charter Township, MI 30SEP2021 Chaz Nathan McGowen 28 White male knife threat not No No
Orangeville Township, MI 13OCT2021 Steven David Schumann 40 White male knife threat not No No
Reading Township, MI 28APR2021 Oscar Herrera 32 Hispanic male knife threat not No Yes
Royal Oak, MI 27FEB2021 Jason Raymond Sugg 34 White male gun point not No 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?
Austin, MN 23DEC2021 Kokou Christopher Fiafonou 38 Black male knife threat foot Yes No
Braham, MN 21FEB2021 Dominic Lucas Koch 27 Native American male gun shoot other No Yes
Brooklyn Center, MN 11APR2021 Daunte Wright 20 Black male undetermined accident   No Yes
Burnsville, MN 18APR2021 Bradley Michael Olsen 30 White male gun shoot car No Yes
Duluth, MN 25FEB2021 David Joseph Wayne Conwell 37 White male gun shoot   No Yes
Forest Lake, MN 28NOV2021 Bradley George Erickson 47   male undetermined threat car No Yes
Minneapolis, MN 03JUN2021 Winston Boogie Smith Jr. 32 Black male gun threat   No No
Mounds View, MN 28NOV2021 Noah Douglas Kelly 21 White male gun threat car No Yes
Olivia, MN 04JUL2021 Ricardo Torres Jr. 32 Hispanic male undetermined undetermined   No No
Robbinsdale, MN 08JAN2021 Brian Andren 47 White male knife move car No Yes
Wadena County, MN 27FEB2021 Shannon Savela 36 White male gun shoot not No No
Wadena County, MN 27FEB2021 David Savela 43 White male gun attack   No No

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?
Blue Springs, MO 06DEC2021 Douglas B. Halphin 48 White male gun;vehicle attack car No No
Cedar Hill, MO 28MAY2021 Anthony Legens 36 White male gun shoot   No No
Chillicothe, MO 19FEB2021 Timothy D. Frandson 34 White male blunt_object attack not Yes No
Columbia, MO 26MAY2021 James Grant Sears III 38 White male gun threat   No No
Columbia, MO 14NOV2021 30 Black male gun shoot foot No No
De Soto, MO 22JUN2021 Noah D. Sharp 26 White male gun shoot   No No
Diggins, MO 09SEP2021 David Ray Williams 37 White male gun threat foot No No
Ferguson, MO 12DEC2021 Jeremi Moore 35 Black male gun shoot   No No
Garden City, MO 07JUN2021 Crystal Renee Guhr 42 White female gun point not Yes No
Grandview, MO 16MAY2021 Lantz Stephenson Jr. 17 White male replica point   Yes No
Hermitage, MO 08DEC2021 42   female knife attack   No No
Independence, MO 31MAR2021 Aaron C. Pouche 35 White male gun shoot   No No
Independence, MO 15SEP2021 Cody L. Harrison 33 White male gun shoot   No No
Jacksonville, MO 23MAR2021 David Hill 44   male knife threat foot No No
Jefferson City, MO 03JAN2021 James Reising 49 White male knife threat   No No
Jefferson City, MO 07JUN2021 Clay Shannon Willingham 32 White male gun threat not Yes No
Jennings, MO 12DEC2021 George Hollins Jr. 26 Black male gun threat not No No
Joplin, MO 30OCT2021 Joseph Shane Endicott 41 White male gun point   No No
Kansas City, MO 25MAR2021 Malcolm Del'Von Johnson 31 Black male gun shoot not No No
Kansas City, MO 30APR2021 Hanad A. Abdiaziz 25 Black male gun shoot not No No
Kimberling City, MO 12MAR2021 Timothy Jonas Johnson 33 White male gun shoot not No No
Lincoln County, MO 29APR2021 Joe Earl Robideau 21 White male gun shoot car No No
Poplar Bluff, MO 17NOV2021 Bennie D. Foster Jr. 55 White male unknown threat   No No
Saint Louis, MO 03DEC2021 Michael Graves 39   male gun shoot other No No
Springfield, MO 17OCT2021 Douglas Knakmuhs 40 White male gun shoot foot No Yes
Springfield, MO 11NOV2021 Seth S. Rynio 21 White male gun shoot foot No No
Springfield, MO 23DEC2021 Richard R. McCormick 62   male gun point not No No
St. Charles County, MO 26MAR2021 Daniel Nolan 32 White male gun point not Yes No
Stockton Lake, MO 24JUN2021 Gary Deering   White male undetermined undetermined not Yes No
Webb City, MO 05AUG2021 Aler Ronald Escobar Velasquez 36 Hispanic male other attack   No No
Wentzville, MO 07OCT2021 Johan Quintero 22 Hispanic male gun threat not No 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?
Biloxi, MS 15JAN2021 Reginald Johnson 48 Black male knife threat not No No
Biloxi, MS 13NOV2021 Isaac Bell III 41 Black male undetermined attack foot No No
Canton, MS 17JUL2021 Quentin Bogard   Black male gun shoot not No No
Florence, MS 21AUG2021 Shannon Trevor McKinley 28 White male gun shoot foot No No
Gulfport, MS 11FEB2021 Jonathan Turner 39 Black male undetermined undetermined   No No
Jackson, MS 15JUN2021 Solomon Jamison 28 Black male gun shoot not Yes No
Jackson, MS 18SEP2021 Dishawn Sanders   Black male gun shoot not No No
Jackson, MS 29OCT2021     male vehicle attack car No No
Laurel, MS 30NOV2021 Jabari Louis Musgrove 43 Black male gun shoot not No No
Looxahoma, MS 23SEP2021 Keith Cole   Black male undetermined flee foot No Yes
Madison County, MS 09OCT2021 Calvin Robinson 52 Black male gun point car No No
Meridian, MS 02FEB2021     male knife threat foot No No
Meridian, MS 31DEC2021     male gun shoot not No No
Oxford, MS 08FEB2021 Clay Tatum 38 White male unknown threat other No No
Pearlington, MS 30AUG2021 Martin Luther Bowman III 80   male undetermined undetermined   No No
Rankin County, MS 21DEC2021 Robert Rigby Rushton 42 White male knife threat not No No
Scott County, MS 14AUG2021 Robert D. Bailey     male gun threat   No No
Sumrall, MS 01JUN2021 Christopher Dyess 43 White male undetermined undetermined   No No
Walnut, MS 23JUN2021 Robert Alan Blackburn 39 White male knife move foot Yes No
Waynesboro, MS 17NOV2021 Sylvester Tart 61 Black male gun shoot not No No
Yazoo City, MS 16SEP2021 Timothy Grayson     male gun threat car No No
Yazoo City, MS 16SEP2021 Katrina Simpson 27 Black female   undetermined   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 23APR2021 Michael Lee McClure 26 White male gun attack other No No
Flathead County, MT 19JUL2021 Xavier Hutt 24   male gun threat car No No
Fort Belknap, MT 23OCT2021 Clayburn Elwood Grant 34 Native American male unknown threat car No No
Kalispell, MT 26FEB2021 Isaiah Strong 41 White male blunt_object attack foot No No
Lame Deer, MT 02DEC2021 Arlin Duane Bordeaux 29 Native American male undetermined undetermined   No No
Missoula, MT 29AUG2021 Johnny Lee Perry II 31 Black male knife threat   No No
Stillwater County, MT 23MAR2021 Christopher Eric Cook 41 White male gun point car 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?
Bessemer City, NC 16JUN2021 Billy Barker 44 White male undetermined threat foot No No
Bessemer City, NC 18NOV2021 Chucky Nathaniel Bowden 53 Black male gun threat other No No
Canetuck, NC 14DEC2021 Kevin Glenn Swinson 45 White male unknown threat   No No
Charlotte, NC 23MAR2021 Frankie Jennings 32 Black male undetermined undetermined not No No
Charlotte, NC 05NOV2021 Derrell Lamar Raney 33 Black male gun point   No No
Charlotte, NC 18DEC2021 David Samuel Herbert 44 White male knife attack not No Yes
Churchland, NC 22MAY2021 Adam Hartley   White male gun;knife shoot   No No
Elizabeth City, NC 21APR2021 Andrew Brown Jr. 42 Black male unarmed undetermined car No Yes
Franklinton, NC 02FEB2021 Anthony Andrew Renuart 52 White male gun threat not No No
Gastonia, NC 08FEB2021 Shae Estelle Jones 33 White female gun threat   No Yes
Graham County, NC 20JUN2021 Mickey Ray Rice 31 White male replica move car No No
Grantsboro, NC 10AUG2021 Marvin Richard Hitchcock Jr. 71 White male gun threat not No No
Greensboro, NC 27AUG2021 Christopher Corey Moore 41 Black male unarmed attack not No No
Greensboro, NC 19NOV2021 Joseph Thomas Lee Lopez 29 Hispanic male undetermined undetermined foot No Yes
High Point, NC 04FEB2021 Josue Drumond-Cruz 34 Asian male gun shoot not No No
Hurdle Mills, NC 02APR2021 Jackie Cameron Capps Jr. 58 White male gun point not No No
Leland, NC 10OCT2021 Michael Beck 57 White male gun shoot not No No
McDowell County, NC 22FEB2021 Carlton James Adams 30 White male gun shoot   No No
Pembroke, NC 09JAN2021 Matthew Oxendine 46 White male replica point not No No
Salemburg, NC 04JUL2021 Craig Locklear 49 Native American male gun point other No No
Salisbury, NC 17FEB2021 James Edward Coe 28 White male gun shoot foot No No
Tarboro, NC 14OCT2021 Jermaine Harris 32 Black male knife attack not Yes Yes
Traphill, NC 02JUL2021 Thomas Charlie Billings 37 White male replica point not No No
Washington, NC 24JUN2021 Chad Necessary 48 White male unknown threat   No No
Whiteville, NC 24JUN2021 William Dean Hewett 54 White male gun threat   No No
Wilmington, NC 16NOV2021 Henry Timberlake Duncan 43 White male knife attack not No No
Winston-Salem, NC 28NOV2021 Adam McKnight 33 White male knife threat not Yes No

statecode=ND

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?
Bayard, NE 29JUN2021 Larry Hunt 58 White male undetermined undetermined   No No
Fremont, NE 14MAY2021 Aaron Schneider 33 White male gun shoot   Yes No
Juniata, NE 11AUG2021 Brooks Hacker 35 White male gun shoot not No No
Lincoln, NE 20FEB2021 Hailey R. Stainbrook 30 White female gun shoot car No Yes
Lincoln, NE 20FEB2021 Christian W. Alexander 26 White male gun shoot car No Yes
Lincoln, NE 24NOV2021 German Pedraza 27 Hispanic male gun threat   No No
North Platte, NE 15DEC2021 Keith A. Hinrichsen 52 White male gun point not No No
Omaha, NE 16MAY2021 Deven Telford 34 White male gun shoot not Yes Yes
Saint Paul, NE 14AUG2021 John A. Vogel 80 White male gun point not No No
Scottsbluff, NE 07JUN2021 Daniel Jacob Ojeda 47 White male gun shoot   Yes 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?
Claremont, NH 31MAR2021 Jeffrey Ely 40 White male gun shoot   Yes No
Pittsfield, NH 14JUN2021 Anthony Hannon 52 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?
Bayonne, NJ 07JUN2021 Lee Waskiewicz 47   male knife threat   Yes Yes
Buena Vista, NJ 05APR2021 Roy K. Jackel Jr. 41 White male undetermined flee car No No
Hillsborough, NJ 28SEP2021 Patrick Chin 43 Asian male knife threat   No No
Knowlton Township, NJ 07NOV2021 Timothy Quinn Parks 34 White male gun shoot not No Yes
Leonia, NJ 16JUN2021     male undetermined undetermined   No No
Long Branch, NJ 06NOV2021 Mark D. Walker II 34 Black male gun shoot not No No
Mantua Township, NJ 14SEP2021 Charles Frederick Sharp III 49 White male replica threat not No Yes
Newark, NJ 01JAN2021 Carl Dorsey III 39 Black male undetermined undetermined   No No
Newton, NJ 04JUL2021 Gulia Dale III   Black male undetermined undetermined   Yes Yes
Paterson, NJ 29DEC2021 Thelonious McKnight Jr. 25 Black male undetermined undetermined   No No
Vineland, NJ 18DEC2021 Joshua Gonzalez 20   male vehicle attack   No 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?
Albuquerque, NM 31JAN2021 Ezekiel Meza 41 Hispanic male gun shoot foot No Yes
Albuquerque, NM 20FEB2021 Claude Trivino 40 Hispanic male knife attack foot Yes Yes
Albuquerque, NM 14JUL2021 Marquez Floyd 31 Black male gun shoot not No No
Albuquerque, NM 15AUG2021 Eric Padilla 33 Hispanic male gun point foot No Yes
Albuquerque, NM 26NOV2021 Elijah Jacob Riche 18 W;H male gun threat   No Yes
Albuquerque, NM 07DEC2021 Mario Armando Diaz 41 Hispanic male unarmed attack foot No No
Chaves County, NM 21MAR2021 Sergio Gutierrez Chairez 31 Hispanic male gun point not No No
Clines Corners, NM 26NOV2021 Christean Ann Dimas 28 Hispanic female gun shoot car No No
Deming, NM 03FEB2021 Gilbert Valencia 29 Hispanic male replica threat not Yes No
Espanola, NM 08JUN2021 Luis Nathan Leyba 38 Hispanic male vehicle attack car No No
Estancia, NM 13DEC2021     male undetermined undetermined   No No
Farmington, NM 13SEP2021 Tedman Werito 44 Native American male gun point not No No
Las Cruces, NM 04FEB2021 Omar Felix Cueva 39 Hispanic male gun shoot car No No
Las Cruces, NM 09OCT2021 Gustavo A. Esparza 35   male gun shoot car No No
Las Vegas, NM 17JUL2021 Jeffrey Scott 30 Hispanic male gun shoot not No No
Los Lunas, NM 03SEP2021 Jose Angel Baca 28 Hispanic male gun shoot car No No
Moriarty, NM 06SEP2021 Cimmeron Christy 46 White male gun shoot not No No
Roswell, NM 15APR2021 Victor Ivan Barron 22 Hispanic male gun threat other No No
Roswell, NM 27JUN2021 Oscar Najera 25   male undetermined flee car No No
Roswell, NM 16JUL2021 Craig Gerard Heinzen 64 White male gun point   No No
Santa Fe, NM 23JUN2021 Francisco Javier Lino-Gutierrez 29   male gun shoot foot No No
Santa Fe, NM 23JUN2021 Nathan Roybal 32 Hispanic male gun;vehicle attack other No No
Santa Fe, NM 07JUL2021 Edward Daniel Santana 45 Hispanic male blunt_object point not No Yes
Shiprock, NM 11JUL2021 Shawn Thomas 36 Hispanic male gun threat car No No
Taos Pueblo, NM 14FEB2021 Antonio "Tai" Trujillo   Native American male undetermined undetermined not No No
Ventana Ranch, NM 16APR2021 Juan James Cordova 51   male gun point 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?
Eureka County, NV 16JUN2021 Zachery Isaiah Minissale 34 White male gun shoot foot No No
Golden Valley, NV 19OCT2021 Richard Thomas 41   male vehicle attack car No No
Henderson, NV 21SEP2021 Jose Antonio Oyuela-Palma 49 Hispanic male gun point   Yes No
Las Vegas, NV 03FEB2021 Marvin Payton Jr. 28 Black male knife attack foot No No
Las Vegas, NV 04MAY2021 William Thomas Holt Jr. 50 White male gun shoot not No No
Las Vegas, NV 27JUL2021 Douglas Claiborne 60 White male vehicle flee car No No
Las Vegas, NV 21SEP2021 Trent Leach 30 White male gun point   No No
Las Vegas, NV 03OCT2021     male undetermined undetermined   No No
Las Vegas, NV 04OCT2021 Demetrius Deshawn Roberts 21 Black male gun shoot foot No No
Las Vegas, NV 12OCT2021 Mario Lawrence Martinez 43 Hispanic male gun point not No Yes
Las Vegas, NV 17NOV2021 Steven Thomas 36 Black male gun threat other No Yes
Tonopah, NV 27AUG2021 Ingmar Von Strandberg 30 White male replica point car No Yes

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?
Auburn, NY 21SEP2021 Brandi R. Baida 30 White female gun shoot not No No
Brooklyn, NY 08JUL2021 Steven Leconte 53 Black male gun point foot No Yes
Dolgeville, NY 24DEC2021 Carson Elliot Dobson 24 White male knife threat   No No
Elmira, NY 27AUG2021 David G. Wandell 53 White male gun threat foot No No
Franklin, NY 05AUG2021 Roger Lynch 59 White male gun point car No No
Jamesville, NY 04MAR2021 Judson Albahm 17 White male replica point foot Yes Yes
Manorville, NY 20MAY2021 Jesse J. Bonsignore 44 White male knife threat not No No
New York, NY 21JAN2021 David McFarlane 51 Black male knife threat not No No
New York, NY 11NOV2021 Brian Astarita 65 White male gun threat car No No
New York, NY 20DEC2021 Eudes Pierre 26 Black male knife attack   Yes Yes
Oneonta, NY 06APR2021 Tyler R. Green 23 White male knife threat   No No
Rochester, NY 10MAR2021 Tyshon Jones 29 Black male knife threat foot Yes Yes
Rochester, NY 14MAY2021 Mark Gaskill 28 White male gun threat car No Yes
Rochester, NY 04JUN2021 Timothy Flowers 29 Black male gun shoot   No No
Rochester, NY 06OCT2021 Simran Gordon 24 Black male gun shoot not No Yes
Syracuse, NY 20OCT2021 Allison Lakie 33 White female knife attack not No No
Unadilla, NY 22DEC2021 Mark A. Beilby 24 White male knife threat not No No
Wallkill, NY 12JUN2021 Christopher VanKleeck 31 White male undetermined undetermined   Yes Yes
Walton, NY 04OCT2021 Paul J. Weeden 66 White male unknown point   Yes No

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 23DEC2021 James W. Gross 58 White male knife threat   No No
Bethel Township, OH 09APR2021 Douglas C. Barton 50 White male gun shoot not No No
Canton, OH 24MAR2021 Aaron Pierre Thomas 33 Black male gun shoot not No No
Cleveland, OH 05JAN2021 Vincent Belmonte 18 Black male gun threat other No Yes
Cleveland, OH 15APR2021 Innes Lee Jr. 25 Black male gun point foot No Yes
Cleveland, OH 12DEC2021 Patrick Horton 39 Black male gun shoot not No No
Columbus, OH 05MAR2021 Andrew Teague 43 Black male gun shoot car No No
Columbus, OH 20APR2021 Ma’Khia Bryant 16 Black female knife threat not No Yes
Columbus, OH 29SEP2021 Kyle Anthony Veyon 26 Black male knife threat not No Yes
Columbus, OH 08DEC2021 Donta Stewart 18 Black male gun shoot not No No
Dayton, OH 14DEC2021 William Gardner 21 Black male gun move not Yes No
East Cleveland, OH 10FEB2021 Cortez Lee Bogan 27 Black male gun threat not No No
Hamilton Township, OH 02MAY2021 Anthony D. Williams 57 White male gun point not Yes No
Harrison Township, OH 12MAR2021 Benjamin P. Cotton 24 White male knife move not No No
Leroy Township, OH 26OCT2021 Scott S. Wright 57 White male gun shoot not No No
Liberty Township, OH 11JAN2021 Junius Thomas 31 White male gun point not No No
Mansfield, OH 29JUL2021 James Aaron Haynes 39 Black male knife attack not No No
Miami Township, OH 06SEP2021 Fredrick A. Thomas 41 Black male gun shoot not No Yes
Mifflin Township, OH 04AUG2021 Sean Rowe   White male unknown threat not Yes No
Nelsonville, OH 27JUL2021 Michael Whitmer 37 White male vehicle attack car No Yes
Ravenna Township, OH 04JUL2021 Matthew J. Morse 36 White male gun threat   No No
Sylvania Township, OH 21MAR2021 Eduardo Parra 24 Hispanic male unarmed move foot No No
Toledo, OH 18JAN2021 Christopher Harris 27 Black male gun shoot foot Yes No
Toledo, OH 19JUL2021 Michael Clifton 50 White male gun point other Yes Yes
Trotwood, OH 05FEB2021 Andrew Hogan 25 Black male knife threat foot No No
Westerville, OH 12APR2021 Miles Jackson 27 Black male gun point not No Yes

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?
Anadarko, OK 05APR2021 Silas Zacharia Lambert 25 Native American male gun point   No Yes
Antlers, OK 30MAY2021 Hank Miller 48 White male vehicle attack car No No
Arkoma, OK 28AUG2021   Native American male vehicle attack car No No
Broken Bow, OK 31JAN2021 Franklin Gray 39 White male gun shoot not No No
Cartwright, OK 02JUN2021 Clayton Barbee 27 White male undetermined undetermined not Yes No
Davis, OK 15SEP2021 Christopher George 25 White male gun shoot   Yes No
Duncan, OK 22JUL2021 Shawn Tillison 43 White male gun point not No No
Geary, OK 14OCT2021 46   male knife attack not No No
Lawton, OK 17JAN2021 Zonterious Johnson 24 Black male gun point foot No No
Lawton, OK 05DEC2021 Quadry Sanders   Black male undetermined undetermined   No Yes
Muskogee, OK 28FEB2021 Farrah Rauch 17 White female gun shoot other No Yes
Oklahoma City, OK 04FEB2021 Tilford Barton 30 White male gun shoot   Yes No
Oklahoma City, OK 08MAY2021 Daniel Hobbs 34 White male other attack   Yes Yes
Tulsa, OK 05JUN2021 28 Hispanic male gun shoot not No No
Tulsa, OK 06JUN2021     male gun point not No No
Tulsa, OK 04NOV2021 36   male knife attack not Yes No
Vici, OK 24FEB2021 Michael Richard Stambaugh 39 White male gun;vehicle attack car No Yes
Webbers Falls, OK 24APR2021 Benjamin Ridley 29 White male gun threat   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?
Corvallis, OR 03APR2021 Jeffrey W. Appelt 32 White male knife threat   No Yes
Eagle Point, OR 23FEB2021 Dale Amstutz-Dunn 39 White male gun shoot car No No
Happy Valley, OR 07JUN2021 Jeremiah Lee Wright 44 White male undetermined flee other No No
Happy Valley, OR 27SEP2021 Nathan Thomas Honeycutt 26 White male gun threat car No No
Medford, OR 07JUL2021 Jerry Allan Gunter 34 White male knife threat not No Yes
Ontario, OR 03JAN2021 Henry Martinez Jr. 49 Hispanic male knife threat not No No
Portland, OR 16APR2021 Robert Douglas Delgado 46 White male replica threat   No No
Portland, OR 24JUN2021 Michael Ray Townsend 40 White male undetermined undetermined not Yes No
Portland, OR 27AUG2021 Alexander Tadros 30 White male gun shoot not No No
Portland, OR 06DEC2021 Brandon Keck 30 White male gun shoot car No No
Reedsport, OR 09MAR2021 David Robert Ruozi Jr. 30 White male undetermined attack not No No
Rogue River, OR 18MAY2021 32 White male gun threat car No No
Salem, OR 02APR2021 Natzeryt Viertel 22 White male gun threat not Yes No
Salem, OR 09JUL2021 Arcadia Castillo III 22 Hispanic male knife point   Yes No
Springfield, OR 06SEP2021 Robert Cruz Gutierrez 59 Hispanic male gun point   No No
Tigard, OR 06JAN2021 Jacob Ryan Macduff 26 White male knife attack not Yes No
Valley Falls, OR 01JAN2021 Isaac Matheny 37 Black male replica threat   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?
Butler, PA 23AUG2021 John Ebberts 35 White male knife attack   Yes No
Catasauqua, PA 19FEB2021 Ryan Shirey 27 White male gun threat not Yes No
Conshohocken, PA 03AUG2021 Michael Tristian Paone 22 White male replica point not No No
Delaware Township, PA 11JUN2021 William Michael Kradlak Jr. 70 White male gun shoot   No No
Falls Township, PA 29AUG2021 Jorge Albert "Cury" Perez 48 Hispanic male undetermined undetermined   No No
Foster Township, PA 22DEC2021 Ronald Hoffman 57 White male gun threat foot No No
Gaines Township, PA 27JUL2021 Robert P. Uhler 56 White male unknown threat   No No
Greene Township, PA 05OCT2021 Nurgazy Mamyrov 27 Asian male vehicle attack not No No
Mahoning Township, PA 18SEP2021 Christopher E. Rush 34 White male knife attack not No No
Muhlenberg Township, PA 15MAR2021 Stephen James Hughes 62 White male knife threat not No No
New Wilmington, PA 25FEB2021 Juan Carter Hernandez 33 Hispanic male unknown attack not No No
Pennsburg, PA 09FEB2021 Trey Bartholomew 27 White male knife threat not No No
Philadelphia, PA 07APR2021 James Alexander 24 Black male gun shoot not No No
Philadelphia, PA 22JUL2021 Carlos Rodriguez 40   male gun shoot not No No
Philadelphia, PA 18AUG2021 Terrence Bey 29 Black male gun shoot other No No
Philadelphia, PA 27OCT2021 Koffi Dzima 31   male blunt_object attack   No Yes
Pocono Township, PA 19OCT2021 Betty Jane Tibaldi 54   female gun shoot car Yes No
Saltlick Township, PA 13APR2021 Keith Robert Tafoya 67 White male gun point not No No
Sharon Hill, PA 27AUG2021 Fanta Bility 8 Black female unarmed accident not No No
Union Township, PA 07NOV2021 Andrew Dzwonchyk 40 White male vehicle attack car No No
West Hanover Township, PA 20JUL2021 Mitchell Shuller 35 White male gun shoot not Yes No
West Hanover Township, PA 31OCT2021 Glenn William Custer 59 White male knife threat not No No
Williams Township, PA 23MAY2021 Edward James Shadder 55 White male unarmed attack not Yes No
Williamsport, PA 11FEB2021 Clifford E. Wilbur Jr. 38 White male gun threat other No No

statecode=RI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=RI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Warwick, RI 22NOV2021 Frank Nappa Jr. 49 White male gun point not Yes 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?
Abbeville, SC 14JUN2021 Evin Kimberly Payne 54   male unknown threat not No No
Anderson, SC 12OCT2021 Jonathan Zachery Combs 40 White male gun threat car No No
Anderson, SC 14OCT2021 Robert Allen Maness 39 White male gun shoot car No No
Anderson County, SC 15DEC2021 Brandon Joshua Mauldin 32 White male undetermined undetermined car No No
Calhoun County, SC 30JUN2021 John Hayden Inabinet III 51 White male gun point   Yes No
Clemson, SC 11FEB2021 Gregory Chandler Metz 25 White male gun threat   No No
Greenville, SC 09MAY2021 Jeffrey Mark Murray 62 White male gun shoot not No Yes
Greenville, SC 23JUN2021 Earl Fitzgerald Hunter 40 Black male gun threat   No No
Greenville County, SC 26DEC2021 Matthew David Snyder 38 White male gun shoot foot No No
Greer, SC 18FEB2021 William Clayton Blackwell 39 White male gun point not No Yes
Horry County, SC 11SEP2021 Tristan Vereen 33 Black male other attack other No Yes
Indian Land, SC 08OCT2021 Derrick Clinton II 27 Black male gun shoot not No No
Lexington County, SC 15AUG2021 Phillip John Walden 40 White male unknown move car No No
Spartanburg, SC 01JUL2021 Shannon Earl Smith 45 Black male gun shoot   Yes No
Warrenville, SC 11JAN2021 Daryl Dye 45 White male knife threat not No No
West Ashley, SC 18SEP2021 Jason Husted 47 White male gun shoot   No Yes

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?
Bolivar, TN 06OCT2021 Andra Devon Murphy 43 Black male gun shoot car No No
Campbell County, TN 21OCT2021 Michael Raymond Hilton 34 White male undetermined flee car No No
Chattanooga, TN 19MAR2021 Mykel Dexter Jenkins 29 White male knife threat not Yes No
Clarksville, TN 08MAY2021 Adonis Traughber 54 Black male gun shoot not No No
Clarkville, TN 27MAY2021 Andre Luiz Snyder 33 Hispanic male gun shoot not Yes No
Cleveland, TN 07OCT2021 Lloyd Grant McClung Jr. 71 White male gun shoot not Yes No
Cleveland, TN 30OCT2021 Matthew James Rigg 50 White male gun shoot not Yes No
Cumberland County, TN 10DEC2021 David Denman Talbert 55 White male gun threat not No No
Greene County, TN 15AUG2021 Katelyn L. Harris 29 White female vehicle;gun move car No No
Hamilton County, TN 01OCT2021 James Michael Farris 27 White male gun point   No No
Jackson, TN 13NOV2021 Marcus Mann 42 Black male unarmed attack   No No
Kingsport, TN 01JUL2021 Lisa A. Short 54 White female gun threat   No No
Knoxville, TN 12APR2021 Anthony J. Thompson Jr. 17 Black male gun threat foot No Yes
Knoxville, TN 12OCT2021 Bryan Calvin Lee 43 White male gun point not No No
Lenoir City, TN 03FEB2021 Tracy Hope Walter-Hensley 56 White female gun shoot not No No
Madison, TN 16DEC2021 Anthony Marcell Phillips 39   male gun shoot not No Yes
McDonald, TN 25JUN2021 Michael Anthony Frederick 54 White male gun point not Yes Yes
Memphis, TN 12MAR2021 Nika Nicole Holbert 31 Black female gun shoot car No Yes
Memphis, TN 16AUG2021 Antonio Jackson 27 Black male vehicle attack   No No
Memphis, TN 15DEC2021 Kayla Lucas 25 White female vehicle attack car No No
Memphis, TN 16DEC2021 Terrance Dogan 27 Black male gun shoot car No No
Memphis, TN 16DEC2021 John H. Taylor 18 Black male undetermined flee car No No
Monteagle, TN 08NOV2021 Angie McFarland 50 White female gun point not No No
Nashville, TN 24APR2021 Marvin Veiga 32 Black male knife threat not No Yes
Nashville, TN 01MAY2021 Jacob Alexander Griffin 23 White male gun shoot   Yes Yes
Nashville, TN 03AUG2021 Antonio D. King 22 Black male gun point not No No
Nashville, TN 11AUG2021 Daniel Turney Crowley 31 White male knife threat not No Yes
Nashville, TN 18SEP2021 Adrian Cameron 47 Black male gun shoot not No No
Nashville, TN 05OCT2021 Corey Daniel Wellman 40 Black male gun shoot car No No
Overton County, TN 04JUN2021 Jerry Wayne Henley 42 White male undetermined undetermined   No No
Rogersville, TN 01OCT2021 Buster Lee Carpenter 32 White male vehicle attack car No No
Rutledge, TN 07MAY2021 Robbie Leigh Hodge 52 White male gun threat not No No
Sparta, TN 08JAN2021 Charles Edward Williams 47 White male undetermined threat foot No No
Westmoreland, TN 15JUN2021 Nathaniel Damien Raabe 48 White male gun shoot not Yes No

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?
Abilene, TX 26JUN2021 Roberto Acosta-Reyes 61 Hispanic male gun point not No No
Allen, TX 27SEP2021 Gloria Marie Strong 27 Black female gun shoot foot No No
Alvarado, TX 13MAY2021 Adrian Murillo 19 Hispanic male gun shoot car No No
Amarillo, TX 20AUG2021 George Michael Mireles 34 Hispanic male gun shoot   No No
Amarillo, TX 23AUG2021 Trinidad Marry 42 White male gun point   No No
Aransas Pass, TX 19APR2021 Antonio Cantu 52 Hispanic male gun shoot not No Yes
Arlington, TX 18MAR2021 Juan Jimenez-Salas 46 Hispanic male gun point not No No
Arlington, TX 20OCT2021 Jesse Joseph Fischer 40 White male vehicle move car No No
Austin, TX 05JAN2021 Alexander Gonzales 27 Hispanic male gun point not No Yes
Austin, TX 10FEB2021 Jordan Walton 21 Black male gun shoot not No Yes
Austin, TX 27OCT2021 Robert Bruce Richart 56 White male gun shoot not Yes Yes
Baylor County, TX 30JAN2021 Chase Anthony Coats 34 White male gun shoot not No No
Bexar County, TX 11SEP2021 William Frank Hull 31 White male gun shoot foot No No
Bexar County, TX 30SEP2021 Nicholas Charles Norris 32 White male undetermined attack car Yes No
Boerne, TX 22JUL2021 Cullen Condon 25 White male gun point not No No
Celina, TX 30JUL2021 Luis Fernando Flores 44 Hispanic male gun threat not No No
Cherokee County, TX 14JAN2021 Justin Pegues 26 White male undetermined undetermined   No No
College Station, TX 21JAN2021 Ryan D. Stallings 33 White male gun threat not No No
College Station, TX 23MAY2021 Roderick Devonne Merchant Jr. 21 Black male gun shoot   No No
College Station, TX 25JUN2021 Albert Wayne Finnie Jr. 22 Black male gun threat foot No No
Corpus Christi, TX 29MAR2021 Robert Lee Canchola 33 White male gun shoot foot No Yes
Corpus Christi, TX 28JUN2021 Tristen Xavier Trevino 24 Black male gun threat not No No
Corpus Christi, TX 05OCT2021 Daniel Garcia 43 Hispanic male unarmed move car No No
Corpus Christi, TX 02NOV2021 Kody Marshall 15 White male gun shoot not No No
Crosby, TX 12AUG2021 Dexter Attaway 35 White male gun shoot car No No
Cypress, TX 17MAR2021 Matthew Hurlock 35 White male knife threat   No Yes
Dallas, TX 19APR2021 Edgar Luis Tirado 28 Hispanic male replica point foot No No
Del Rio, TX 11APR2021 Crystal Jean Alcozer 34 White female unknown threat   No No
Edinburg, TX 11JAN2021 Jesse Daniel Davila 29 Hispanic male unarmed attack not No No
El Paso, TX 15JAN2021 Jean Paul Stanley 27 White male gun threat   Yes No
El Paso, TX 14FEB2021 Adam Bruce Connors 32 White male gun threat other Yes No
Flour Bluff, TX 29JUN2021 Philip Sanders 32 White male gun shoot foot No No
Forest Hill, TX 09JUN2021 Michael Lee Ross Jr. 32 Black male knife undetermined not No Yes
Fort Worth, TX 18APR2021 Ryan Williams 31 Black male gun shoot foot No Yes
Fort Worth, TX 03SEP2021 Estevan Xavier Ramirez 18 Hispanic male gun point car No No
Fulshear, TX 10JUN2021 Calvin William Elmore 53 White male vehicle attack car No Yes
Graham, TX 27JUN2021 Stephen Winder 39 White male undetermined undetermined not Yes No
Hawkins, TX 17SEP2021 Shaine Marie Selph 21 White female knife attack not Yes No
Horizon City, TX 13JUL2021 Jesse Joe Carranza 21 Hispanic male other threat not No No
Houston, TX 05JAN2021 Jose Guzman 27 Hispanic male gun threat   No No
Houston, TX 11FEB2021 Edwin Adan Velasquez 20 Hispanic male gun point not No No
Houston, TX 17FEB2021 Adrian Castro 30 Hispanic male gun threat not No Yes
Houston, TX 03MAR2021 Broderick Woods 33 Black male gun threat car No No
Houston, TX 14APR2021 Marcelo Garcia 46 Hispanic male knife threat not Yes Yes
Houston, TX 21MAY2021 Zaekwon Malik Gullatte-Graves 25 Black male gun shoot not No Yes
Houston, TX 06JUL2021 Jose Benitez-Vasquez 32 Hispanic male gun attack   No Yes
Houston, TX 14JUL2021 David Salinas 32 Hispanic male gun move car No Yes
Houston, TX 18JUL2021 Irvin Peterson 35 Black male gun shoot not No Yes
Houston, TX 01SEP2021 Omar Hernandez Lazano 39 Hispanic male vehicle attack car No Yes
Houston, TX 20SEP2021 Deon Ledet 30 Black male gun shoot not No Yes
Houston, TX 11NOV2021 Elliot Maxent Lewis 42 Black male gun shoot car No No
Houston, TX 26DEC2021 Christopher Johnson 41 Black male gun shoot not Yes Yes
Huntsville, TX 16SEP2021 Dan Ross Boyd II 38 White male gun shoot not No No
Killeen, TX 10JAN2021 Patrick Lynn Warren Sr. 52 Black male unarmed move not Yes Yes
Killeen, TX 13MAY2021 Samuel Roberto Pleasant Sr. 40 Black male undetermined undetermined   No No
Lacy Lakeview, TX 07FEB2021 Dustin Demaurean Powell 34 Black male knife threat foot Yes No
Lancaster, TX 10MAY2021 Kalon J. Horton 29 Black male gun point   Yes No
Laredo, TX 14MAR2021 Angel B. Degollado 21 Hispanic male undetermined undetermined   Yes No
Laredo, TX 16OCT2021 Guillermo Gonzalez 40 White male gun shoot not No No
Lufkin, TX 07SEP2021 Anthony Cravo 52 White male gun point not No Yes
Lufkin, TX 07SEP2021 Richard Dee Woods 43 White male gun threat not No No
McKinney, TX 23SEP2021 Paul Bryan Stone 40 White male gun point not Yes No
Mesquite, TX 04MAY2021 Ashton Jiata Pinke 27 Black male knife attack not Yes Yes
Monahans, TX 13MAR2021 Charles Ray Phillips 51 Black male knife;knife attack foot No No
Mount Pleasant, TX 24MAR2021 James Patrick Carlisle 46 White male vehicle;gun shoot not No No
Odessa, TX 05MAR2021 Justin Lynn 44 White male gun shoot   No No
Pflugerville, TX 18AUG2021 Ronald Zavaglia 72 White male gun point   No Yes
Plano, TX 29AUG2021 Imran Ali Rasheed 32 Asian male gun shoot not No No
Rosenberg, TX 23APR2021 Tory Casey 41 Black male gun threat   No No
Round Rock, TX 07JUN2021 Antonio Diaz 39 Hispanic male gun threat   No Yes
San Antonio, TX 26JAN2021 Felix Ramirez Santos 48 Hispanic male gun shoot car No No
San Antonio, TX 27JAN2021 Erick Mejia 26 Hispanic male gun threat foot No Yes
San Antonio, TX 26FEB2021 Thomas Mack 39 Hispanic male gun shoot foot No No
San Antonio, TX 26MAR2021 John Pena Montez 57 White male knife move not No Yes
San Antonio, TX 15APR2021 Joe Guadalupe Gomez 46 Hispanic male gun shoot   Yes No
San Antonio, TX 16APR2021 Sammie Joe Barbosa 33 White male undetermined undetermined not No Yes
San Antonio, TX 16APR2021 Alex Anthony Garcia 25 Hispanic male gun shoot   No Yes
San Antonio, TX 20APR2021 Brian Deleon 37 Hispanic male gun shoot   No No
San Antonio, TX 20APR2021 Terry Wayne Bishop 28 White male gun threat   No No
San Antonio, TX 03JUN2021 Kolton Mitchell Chavez 18 Hispanic male knife move not No No
San Antonio, TX 05JUL2021 Eduardo Mendez Amezquita 28 Hispanic male gun shoot other No Yes
San Antonio, TX 26JUL2021 Neida Guadalupe Tijerina 29 Hispanic female unarmed accident   No No
San Antonio, TX 13AUG2021 Steven Dean Primm 35 White male gun shoot other No Yes
San Antonio, TX 12SEP2021 Rodolfo Gonzales 46 Hispanic male gun threat foot No No
San Marcos, TX 10APR2021 Rescue Eram 31 Asian male knife point not No No
Sanger, TX 22OCT2021 Gregory Gene Goodall 35 White male knife threat not No No
Seguin, TX 09AUG2021 Christopher Daniel Robinson Sr. 47 Black male gun shoot car No No
Simms, TX 10DEC2021 Mark Robert Peters 60 White male gun shoot not Yes No
Snook, TX 18AUG2021 James Matalice Smith 41 Black male gun shoot not No No
Snyder, TX 01FEB2021 Kevin Hayes 57 White male gun shoot   No No
Spring, TX 08AUG2021 Randal Boyd Burton 62 White male gun shoot car No No
Waco, TX 03AUG2021 Ent Wright 76 White male gun shoot not No No
Weslaco, TX 06OCT2021 Guillermo San Miguel Sanchez 25 Hispanic male knife attack not Yes No
Wichita Falls, TX 24JAN2021 Tyree Kajuan Rogers 38 Black male vehicle attack car No No
Wichita Falls, TX 16SEP2021 Gabriel Michael Varela 17 Hispanic male gun shoot not No No
Wylie, TX 17MAR2021 Shawn Myers 36 White male gun threat not 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?
Clinton, UT 16DEC2021 Christopher Anthony Alexander 32   male knife attack foot No No
Farmington, UT 10SEP2021 Joseph Anthony Manhard 31 Hispanic male gun shoot car No Yes
Grantsville, UT 25AUG2021 Rodney Barton 42   male knife point car No No
Kearns, UT 06FEB2021 Dennis Denham 60 White male gun shoot not No No
Murray, UT 22JUN2021 Willie Salazar 33 Hispanic male gun shoot   No No
Ogden, UT 06FEB2021 Dino Morales 28 Hispanic male gun threat other No No
Orem, UT 28NOV2021 41   male unknown attack   No Yes
Provo, UT 24AUG2021 Paul Finn Rasmussen 48 White male gun point car No No
Salt Lake City, UT 10APR2021 Joshua Michael Johnson 31 White male gun shoot not No No
Salt Lake City, UT 10JUN2021 Rezek Yaqub Yahya 39   male knife attack not No Yes
South Ogden, UT 30JUN2021 56   male gun shoot not No No
Taylorsville, UT 01DEC2021 Anei Gabriel Joker 20 Black male gun shoot 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?
Amherst County, VA 16JUN2021 Kendall Allen Jamerson 35 White male gun;vehicle attack other No No
Arlington, VA 03AUG2021 Austin William Lanz 27 White male knife attack not Yes No
Bristol, VA 30MAR2021 Jonathen B. Kohler 31 White male vehicle attack not No No
Caroline County, VA 01FEB2021 Richard F. Thomas 58 White male unarmed threat not Yes No
Chesapeake, VA 06NOV2021 Brian Michael Price 45 White male blunt_object attack other No No
Chesterfield, VA 14JAN2021 Jeffrey D. Kite 36 White male gun shoot not No No
Culpeper, VA 25FEB2021 Donald Francis Hairston 44 Black male gun shoot not Yes No
Goochland County, VA 10JAN2021 Xzavier D. Hill 18 Black male gun point car No No
Goodview, VA 07NOV2021 Chelsae L. Clevenger-Kirk 29 White female gun threat other Yes No
Grottoes, VA 14MAY2021 Jeffrey J. Bruce   White male knife threat foot No No
Henrico County, VA 06NOV2021 Tony Singleton 53 White male undetermined undetermined   No No
King George County, VA 25MAR2021 Charles C. White III 35 Black male gun shoot not No No
Langley, VA 03MAY2021 Roy Gordon Cole 31 White male unknown move   No No
Luray, VA 22JUN2021 De'Shon Hill 39 Black male gun point not Yes No
Martinsville, VA 05FEB2021   Black male gun shoot not No Yes
Roanoke County, VA 26NOV2021 Shawn Alan Smith 52 White male undetermined undetermined   No No
South Hill, VA 23DEC2021 Steven B. Matze 44 White male gun shoot not No No
Stanley, VA 26FEB2021 Dakota G. Richards 29   male gun shoot foot No No
Virginia Beach, VA 26MAR2021 Donovon W. Lynch 25 Black male undetermined undetermined   No No
Washington County, VA 20MAY2021 Brandon Scott Odell 31 White male gun point not No No
Wise County, VA 17JUL2021 Anthony Allen Ray Cooke 16 White male unknown attack   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?
Algona, WA 27DEC2021 Sorin Ardelean 43   male gun shoot not No No
Fife, WA 25JUN2021     male vehicle flee car No No
Graham, WA 25JAN2021 Juan Eric Ostbye 50 White male knife threat   No No
Hazel Dell, WA 04FEB2021 Jenoah Donald 30 Black male unarmed attack not No No
Lakewood, WA 04SEP2021 Spencer Allan Clayborn 25   male gun shoot   No No
North Bend, WA 16NOV2021 Cody Rebischke 33 White male undetermined attack   No No
Renton, WA 08NOV2021     male gun threat not No No
Seattle, WA 09FEB2021 Gregory Taylor 45 Black male gun shoot   No Yes
Seattle, WA 16FEB2021 Derek J. Hayden 44 White male knife threat foot Yes Yes
Seattle, WA 05AUG2021 Isaiah Thomas Hinds 22 Black male gun shoot not No Yes
Spokane, WA 05JAN2021 Shawn McCoy 36 White male gun shoot   No No
Spokane, WA 10DEC2021 Michael Lee Dingman 43 White male gun shoot foot No No
Vancouver, WA 17OCT2021 Kfin Karuo 28 Asian male gun point car 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?
Eau Claire, WI 03NOV2021 LeKenneth Q. Miller 30 Black male knife threat not No No
Goetz, WI 08OCT2021 Lance R. Stelzer 30 White male undetermined undetermined not No No
Green Bay, WI 01MAY2021 Bruce K. Pofahl 62 White male gun shoot not No No
Kewaskum, WI 03FEB2021 Nicholas Pingel 30 White male gun shoot foot No No
Milwaukee, WI 31MAY2021 Roberto Zielinski 47 Hispanic male gun shoot not No Yes
Milwaukee, WI 16AUG2021 Broderick Shelton Jr. 42 Black male gun shoot not Yes No
Milwaukee, WI 22AUG2021 Tyran Lamb 31 Black male gun shoot car No Yes
Milwaukee, WI 26AUG2021 Earl Lawhorn 33 Black male gun threat foot No Yes
New Berlin, WI 22JUN2021 Michael P. Wolski 57 White male gun threat not No No
Oak Creek, WI 03SEP2021 David Marshall Jr. 31 White male gun threat other Yes No
Pine River, WI 10DEC2021 John Z. Moua 28 Asian male knife threat   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?
Beckley, WV 18AUG2021 Kevin Eugene Norris 50 White male replica threat   No No
Mingo County, WV 18OCT2021 Shawn Delemore Dempsey 32 White male gun shoot car No No
Montcalm, WV 19NOV2021 Christopher Wade 45   male gun threat car No No
Old Fields, WV 06SEP2021 Christopher C. Zenittini 35   male gun shoot not No No
Parkersburg, WV 23MAY2021 Rufus James Ramsey III 34   male knife threat not No No
Weston, WV 03SEP2021 Mark Edward Danley 52 White male gun;vehicle attack car No No

statecode=WY