Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2017

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 15NOV2017 Thomas Barclay 48 White male gun point car No No
Anchorage, AK 20DEC2017 Charles McBride 56 Black male gun shoot not No No
Big Lake, AK 17FEB2017 Jean R. Valescot 35 Black male gun point not No No
Fairbanks, AK 25MAY2017 Shawn Buck 23 White male gun shoot car No No
Fairbanks, AK 19JUN2017 Matthew Colton Stover 21 Native American male gun shoot foot Yes No
Fairbanks, AK 24DEC2017 Cody Dalton Eyre 20 White male gun point not Yes Yes
Seward, AK 01OCT2017 Micah McComas 41 White male unarmed flee car No Yes
Wasilla, AK 26MAR2017 Justin Quincy Smith 36 White male gun attack other 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?
Abbeville, AL 02JUN2017 Charles Darnell Baker Jr. 29 Black male gun attack not No No
Anniston, AL 01NOV2017 Jamee Almarez 27 Hispanic male gun shoot not No No
Baldwin County, AL 12MAY2017 Jonathan David Victor 35 White male unarmed accident not No No
Birmingham, AL 19OCT2017 Steven Wayne Truex 38 White male gun threat not No No
Birmingham, AL 28DEC2017 Christopher Baird 37   male gun point not No No
Clay, AL 18JUL2017 Daniel Thomas Reid 32 White male gun point not Yes No
Crenshaw County, AL 17AUG2017 Peter Daniel Grima 65 White male undetermined undetermined not No No
Deer Park, AL 24JUN2017 Christopher Michael Murray 24 White male   threat not No No
Fairhope, AL 26OCT2017 Sanders Surber 32 White male gun shoot other No No
Hamilton, AL 13DEC2017     male unknown threat not No No
Homewood, AL 19AUG2017 Thomas Justin Walton 32 White male other attack not No No
Homewood, AL 12OCT2017 John Robert Payne 35 Black male gun shoot foot Yes No
Huntsville, AL 07JUL2017 Gabriel Sage Barnes 15   male undetermined flee car No No
Huntsville, AL 20SEP2017 Haraesheo Rice 31 Black male gun point not Yes No
Huntsville, AL 26NOV2017 William Freddy Carter Jr. 31 White male gun shoot not No No
Jackson County, AL 07FEB2017 Alex Christopher Davis 18 White male blunt_object threat not No No
Jacksonville, AL 29AUG2017 Larry Moore Miller 68   male gun shoot not No No
Leeds, AL 05OCT2017 Johnny Ray Leeds Jr. 40 White male gun shoot   No No
Mobile, AL 10DEC2017 Ira Crawford 26   male knife attack not No No
Ohatchee, AL 03NOV2017 Christopher Edward Loftis 39 White male vehicle;gun point car No No
Oxford, AL 25JAN2017 Micah R. Lambert 37 White male   attack car Yes No
Pell City, AL 23NOV2017 Jackie Germaine Ragland 32 Black male gun point not No No
Phenix City, AL 07MAY2017 Cedric Jamal Mifflin 27 Black male undetermined undetermined other No Yes
Piedmont, AL 18SEP2017 Jesse VanSipe 33 White male gun threat not Yes No
Prichard, AL 18NOV2017 Lawrence Hawkins 56 Black male unarmed accident car No 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?
Batesville, AR 03NOV2017 Marvin Stair 44   male gun shoot not No No
Bull Shoals, AR 19FEB2017 Kyle Riggs 33 White male gun shoot not No No
Clarksville, AR 04NOV2017 Nyung Kyee 56 Asian male knife point not No No
Little Rock, AR 26MAR2017 Michael Hornibrook 54 White male gun point foot No No
Little Rock, AR 05APR2017 Austin Dakota Snyder 22 White male   move   No No
Marion, AR 25JUL2017 Aries Clark 16 Black male replica point not No No
Mulberry, AR 19DEC2017 Tom Heath 56   male knife threat foot Yes No
Pine Bluff, AR 26AUG2017 Michael Malik Kawon Lee 18 Black male gun shoot foot No Yes
Rose Bud, AR 09DEC2017 James Newman 69 White male gun point not No No
Sheridan, AR 23MAR2017 Eddie Davis 42 Black male knife attack car No No
West Memphis, AR 15APR2017 Olugbalah Ridley 33 Black male gun point   No No
Yellville, AR 20AUG2017 Jonathan Bolger 44 White male replica 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?
Apache Junction, AZ 28JAN2017 Bradley Joseph Szacaks 45 White male gun point not No No
Avondale, AZ 13APR2017 Erik Pamias 28 White male   threat not No No
Avondale, AZ 03JUN2017 Donald Lee Cramer 44 White male gun point not No No
Avondale, AZ 25JUL2017 Moises Balladares 33 Hispanic male gun shoot not Yes No
Eagar, AZ 18JUL2017 Mark Allan Smith 36   male gun threat not No No
Flagstaff, AZ 12OCT2017 Sean D. Brady 29 White male gun shoot not Yes Yes
Glendale, AZ 20APR2017 Brandon Pequeno 25 Hispanic male   threat car No No
Glendale, AZ 20APR2017 Sariah Marie Lane 17 White female unarmed accident car No No
Glendale, AZ 23MAY2017 Jorge Alberto Fuentes 21 Hispanic male gun shoot other No No
Glendale, AZ 01JUL2017 Patrick Sanchez 23 Hispanic male gun threat not No Yes
Golden Shores, AZ 13FEB2017 Drey Krause 53 White male gun shoot not No No
Golden Valley, AZ 11JUL2017 Silas Andrew Smith 54 White male gun shoot foot No No
Goodyear, AZ 13JUL2017 Pedro Rubio 42 Hispanic male knife attack not No No
Kingman, AZ 14MAY2017 David Jay Juarez 41 Hispanic male gun shoot car No No
Marana, AZ 11OCT2017 Brandon Wade Rucker 43 White male gun threat not No No
Mesa, AZ 22SEP2017 Scott Farnsworth 28 White male gun point not Yes No
Mesa, AZ 04OCT2017 Michael Ferrell 67 White male gun threat not No No
Mesa, AZ 08OCT2017 Sabrina Ann Garcia 34 Hispanic female gun point foot Yes No
Paulden, AZ 21JUL2017 Martin Avena 70   male gun shoot not No Yes
Phoenix, AZ 09JAN2017 JR Williams 38 Black male unarmed move foot No Yes
Phoenix, AZ 02MAR2017 Michael Cisneros 27 Hispanic male replica point not No No
Phoenix, AZ 15MAR2017 Todd Munson 25 White male   threat car No No
Phoenix, AZ 23MAR2017 Francisco Valdez 24 Hispanic male knife attack not No No
Phoenix, AZ 15MAY2017 Jonie Block 27 Black female gun threat not No No
Phoenix, AZ 23JUN2017 Jesus Ramon Deltoro 34 Hispanic male   attack car No No
Phoenix, AZ 25JUN2017 Nicholas Johnston 47 White male gun point not No No
Phoenix, AZ 26JUL2017 Andrew Collins 35 White male gun shoot other No No
Phoenix, AZ 17AUG2017 Edgar Ramirez Carreto 28 Hispanic male knife threat not Yes No
Phoenix, AZ 10NOV2017 Thomas Aikens 43 Black male knife attack not No No
Phoenix, AZ 14NOV2017 Adam Brogdon 23 Hispanic male gun point foot No No
Phoenix, AZ 24DEC2017 Charlie Joseph Murillo 25 Hispanic male knife move not No No
Picture Rocks, AZ 16OCT2017 Luis David Flores 34 Hispanic male gun threat not No No
Pima, AZ 13JUL2017 Chancey Chamblee 55 White male gun threat   No No
Pinetop-Lakeside, AZ 08OCT2017 Glenn Southwood Jr. 46 White male gun shoot not No No
Prescott, AZ 23APR2017 Wayne Noel Simard 70 White male gun shoot not No No
Quartzsite, AZ 13SEP2017 Rodolfo Ballardo 31 Hispanic male gun shoot car No No
Tempe, AZ 16MAY2017 Tristan Long 25 Black male knife threat   No No
Three Points, AZ 29NOV2017     male undetermined attack   No No
Tucson, AZ 19FEB2017 Manuel Encinas 26 Hispanic male gun point not No No
Tucson, AZ 26MAY2017 Joseph Zimmerman 34 White male replica point not Yes No
Tucson, AZ 18OCT2017 Daniel Spear 35 White male gun shoot foot No No
Tucson, AZ 07DEC2017 Frederick Douglas Wilburn Jr. 34 Black male   attack car No No
Youngtown, AZ 10SEP2017 Erick Perez 22 Hispanic male gun attack not No No
Yuma, AZ 24NOV2017 Steve Steenhard 51 White male unknown threat 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?
Alhambra, CA 27JAN2017 Eduardo Hernandez 25 Hispanic male gun shoot not Yes Yes
Anderson, CA 26MAR2017 Edward Paul Parienlla 53 White male gun shoot not No No
Antioch, CA 16JUN2017 Nathan Banks 37 White male gun threat foot No No
Antioch, CA 04JUL2017 Zepp Crouchet 42 Black male gun threat car No No
Arcata, CA 09SEP2017 Ervin Eugene Sweat Jr. 26 Black male gun shoot not No No
Artesia, CA 10DEC2017 Frank Dario Lopez 48 Hispanic male knife attack not No No
Atascadero, CA 24JAN2017 Josue Gallardo 34 Hispanic male gun threat not No No
Atwater, CA 16OCT2017 Ezekiel Juan Duran 18 Hispanic male gun shoot not No No
Avenal, CA 27JUL2017 Sergio Velasco-Martinez 25 Hispanic male blunt_object attack not No No
Azusa, CA 15JAN2017 Eric David Anderson 48 White male gun point not No No
Bakersfield, CA 24JAN2017 Antonio Arturo Perez Garcia 27 Hispanic male gun point other No No
Bakersfield, CA 04APR2017 Rogelio Vidal Landa 47 Hispanic male unarmed move foot No No
Bakersfield, CA 08JUN2017 Oscar Junior 45 Hispanic male gun point not No No
Bakersfield, CA 31AUG2017 Issac Cervantes 22 Hispanic male gun shoot not No No
Bakersfield, CA 04NOV2017 Augustus Joshua Crawford 20 Black male gun undetermined foot No No
Barona Indian Reservation, CA 10MAY2017 Jeroen Peter Koornwinder 50 White male   move car No No
Barstow, CA 06NOV2017 Jeffrey Todd Sprowl 48 White male gun point car No No
Bassett, CA 11SEP2017 Vincent Edward Hernandez Jr 39 Hispanic male replica point not No No
Beaumont, CA 02SEP2017     male gun point not No No
Bellflower, CA 25APR2017 Juan Manuel Avilla 20 Hispanic male   move car No No
Burbank, CA 29JUN2017 Marco Cardoza 41 Hispanic male replica point not No No
Cabazon, CA 04MAR2017 Edward Manning III 26 White male blunt_object flee foot No No
Campo, CA 04JUN2017 Bruce Dawley 66 White male gun shoot not Yes No
Carson, CA 22JAN2017 Jorge Victor 33 Hispanic male gun threat not No No
Ceres, CA 22OCT2017 Nicholas Pimentel 27 Hispanic male unarmed flee car No No
Chico, CA 17MAR2017 Desmond Phillips 25 Black male knife threat not Yes No
Chico, CA 23JUL2017 Kyle Scott Rushing 34 White male knife attack not No Yes
Chowchilla, CA 27JUL2017 Alejandro Alvarado 35 Hispanic male knife attack not No No
Chula Vista, CA 19SEP2017 David Scott 27 White male knife attack not Yes No
Cloverdale, CA 21OCT2017 Victor Gonzalez 44 Hispanic male blunt_object threat not No No
Colton, CA 02DEC2017 Mario Guevara 37 Hispanic male knife threat not Yes No
Cottonwood, CA 24MAR2017 Austin Tyler Macon 18 White male gun shoot not No No
Covina, CA 26NOV2017 Daniel Navarro 22 Hispanic male knife threat not No No
Del Mar, CA 15MAY2017 Emmanuel Ibarra 34 Hispanic male knife attack foot Yes No
Delano, CA 31DEC2017 Ernie Macias 32 Hispanic male   threat car No No
Desert Hot Springs, CA 19MAR2017     male knife attack not No No
Desert Hot Springs, CA 26DEC2017 Robo Raikoglo 30 White male gun point car No No
Dinuba, CA 05JAN2017 Luis Vargas 20 Hispanic male gun shoot not No No
Douglas City, CA 16FEB2017 Jonathon Daniel Simmons 22 White male gun threat not No No
Duarte, CA 06OCT2017 Matthew Jonathan Luis Hurtado 28 Hispanic male   undetermined   No No
Durham, CA 22AUG2017 Mark Aaron Jensen 56 White male gun point not Yes No
Emeryville, CA 27SEP2017 Demilo Trayuon Hodge 45 Black male gun shoot car No No
Escondido, CA 10MAR2017 Damon Seitz 40 White male gun point not Yes No
Fair Oaks, CA 19JUL2017 Nolan Cornett 24 White male gun point not No No
Fremont, CA 05FEB2017 Nana Adomako 45 Black male unarmed attack not Yes No
Fresno, CA 30JAN2017 Refugio Alvarez 45 Hispanic male gun;knife attack not Yes No
Fresno, CA 15APR2017 Isaiah Murrietta-Golding 16 Hispanic male unarmed move foot No Yes
Fresno, CA 07JUN2017 Salvadro Alfredo Pablo Lopez 21 Hispanic male gun shoot   No Yes
Gardena, CA 16FEB2017 Jimmy Briggs 21 Black male gun shoot foot No No
Grand Terrace, CA 27JUL2017 Michael Fitzgerald 26 White male gun shoot not No No
Grover Beach, CA 12JUL2017 Keith Alan Eustace 58 White male blunt_object threat not No No
Hayward, CA 14MAR2017 Elena "Ebbie" Mondragon 16 Hispanic female unarmed move   No No
Hesperia, CA 31MAY2017 James Gleason 24 White male   attack   No No
Highland, CA 01FEB2017 Michael Russo 31 Black male   attack car No No
Hollywood, CA 31JAN2017 Solomon Picart 37 Black male knife attack not Yes No
Hollywood Hills, CA 23JUN2017 Santino Trevino 20 Hispanic male gun point not No No
Huntington Beach, CA 09MAR2017 Steven Schiltz 29 White male blunt_object;blunt_object threat not Yes No
Huntington Beach, CA 22SEP2017 Dillan Tabares 27 Asian male undetermined attack not Yes No
Ladera Heights, CA 07MAR2017 Dennis Todd Rogers 41 Black male knife threat not Yes No
Lake Elsinore, CA 11JAN2017 Hafez Abousamra 41 Other male gun shoot other No No
Lemon Grove, CA 24AUG2017 Isaias Raziel Ochoa 19 Hispanic male gun shoot foot No No
Lemoore, CA 03MAR2017 Dave Phoenix 25 Native American male replica point not No No
Lemoore, CA 26NOV2017 Johnny Castro 43 Hispanic male gun shoot car No No
Livermore, CA 16AUG2017 James Midkiff 54 White male gun point not Yes No
Lodi, CA 23OCT2017 Matthew David Palaita 35 Hispanic male gun point not No No
Lompoc, CA 19NOV2017 Geronimo Vicente Santos 34   male gun shoot   No No
Long Beach, CA 15JAN2017 Sinuon Pream 37 Asian female knife threat not Yes No
Long Beach, CA 15MAY2017     male undetermined point other No No
Long Beach, CA 08JUN2017 Michele Rice 33 White female gun point not No No
Los Angeles, CA 10JAN2017 Michael Rogers 32 White male knife threat not No No
Los Angeles, CA 18JAN2017 Daniel Darnell Stroughter 50 White male knife threat car No No
Los Angeles, CA 04MAR2017 Alejandro Valencia Mendez 70 Hispanic male blunt_object threat not No No
Los Angeles, CA 25MAR2017 Fred Barragan 35 Hispanic male gun threat foot No No
Los Angeles, CA 12APR2017 Zelalem Eshetu Ewnetu 28 Black male gun threat not No No
Los Angeles, CA 08MAY2017 Anthony David Soderberg 29 White male gun shoot not No No
Los Angeles, CA 24MAY2017 Luis Garcia 25 Hispanic male gun shoot not No No
Los Angeles, CA 28JUN2017 Samuel Alamillo 33 Hispanic male gun point not Yes Yes
Los Angeles, CA 15JUL2017 Gerber Dieguez 29 Hispanic male gun threat foot No No
Los Angeles, CA 27JUL2017 Jerauld Phillip Hammond II 46 White male gun threat not No No
Los Angeles, CA 10AUG2017 Eric Bogart 49 White male gun shoot not No No
Los Angeles, CA 16AUG2017 Kenneth Lewis 34 Black male gun undetermined foot No No
Los Angeles, CA 22AUG2017 Konstantin Morozov 48 White male gun threat not No No
Los Angeles, CA 06SEP2017 Timothy Elam 42 White male unarmed move not No No
Los Angeles, CA 17SEP2017 Eric Alvarez 40 Hispanic male knife threat not No No
Los Angeles, CA 23DEC2017 Jesse Daniel Murillo 32 Hispanic male blunt_object threat foot No No
Los Angeles, CA 30DEC2017 Oscar Sandoval 39 Hispanic male gun threat not No No
Los Banos, CA 31JUL2017 Norberto Nieblas Reyes 39 Hispanic male gun shoot not Yes No
Madera, CA 16JUN2017 Sergio Valdovinos 32 Hispanic male knife threat not Yes No
Madera, CA 20AUG2017     male undetermined threat foot No No
Modesto, CA 30JAN2017 Spencer Herckt 42 White male blunt_object threat not No No
Montebello, CA 17JUN2017 Samantha Aguilar 28 Hispanic female vehicle threat not No No
Moreno Valley, CA 15JUL2017 Vaughn Shaw 23 Black male gun threat not Yes No
Napa, CA 13MAR2017 Noel Aaron Russell 23 White male knife threat not Yes No
Napa, CA 04APR2017 Stephen Connard Ferry 65 White male gun shoot car No No
Newman, CA 15FEB2017 Mauro Garnica 55 Hispanic male unknown attack not No No
Newport Beach, CA 15APR2017 David Airth 56 White male knife threat not No No
Norco, CA 29JUL2017 Jashod Arthur Carter 29 Black male gun shoot car No No
North Hollywood, CA 30NOV2017 Juan Andres Barillas 37 Hispanic male gun threat car No No
Oakland, CA 17FEB2017 Jesse Enjaian 32 White male gun shoot not No No
Oceanside, CA 22SEP2017 Alexander Ochoa 26 Hispanic male gun;knife point not No No
Oceanside, CA 20DEC2017     male gun undetermined foot No No
Olivehurst, CA 14OCT2017 Eddie Sanders 25   male gun threat not No No
Olympic Valley, CA 03FEB2017 Jose Gonzales Lera 27 Hispanic male gun attack car No No
Ontario, CA 09APR2017 William Baker 36   male gun threat not No No
Orange, CA 12MAR2017 Michael Anthony Perez 33 Hispanic male knife threat not Yes No
Orcutt, CA 22AUG2017 Robert Earl Adams 30 White male knife threat foot No No
Palmdale, CA 22JUN2017 Armando Garcia-Muro 17 Hispanic male unarmed accident not No No
Pleasanton, CA 20MAY2017 Shannon Edward Estill 58 White male replica point not Yes Yes
Point Loma, CA 10DEC2017 Kyle Zahacefski 24 White male knife threat   No No
Pomona, CA 04JAN2017 Ruben Randolph 51 Black male gun shoot foot No No
Rancho Cordova, CA 08MAY2017 Mikel Laney McIntyre 32 Black male blunt_object attack foot Yes No
Redding, CA 08DEC2017 Vernchoy Saechao 22 Asian male gun shoot not No No
Redwood City, CA 30DEC2017 Marco Antonio Carlos 31 Hispanic male gun shoot not No No
Rialto, CA 16JUN2017 Hector Cisneros Soria 30 Hispanic male gun threat not No Yes
Richmond, CA 02AUG2017 Jeffrey Barboa 45 Hispanic male knife attack car No No
Ripon, CA 26FEB2017 Evin Sanna Olsen 46 White female vehicle threat car No No
Riverside, CA 08MAR2017     male knife threat not No No
Riverside, CA 31OCT2017 Luvelle Kennon 27 Black male undetermined threat not No No
Rocklin, CA 25FEB2017 Lorenzo Antoine Cruz 23 Black male replica point foot Yes No
Sacramento, CA 30AUG2017 Thomas Daniel Littlecloud 32 Native American male gun shoot car No No
Sacramento, CA 07SEP2017 Eric Dwan Arnold 41 Black male gun shoot car No No
Sacramento, CA 02NOV2017 Wallace Jory 56 White male other attack not Yes No
Salinas, CA 18JAN2017 Marlon Joel Rodas-Sanchez 16 Hispanic male knife threat not No Yes
San Diego, CA 06MAY2017 Jacob Peterson 15 White male replica point not Yes Yes
San Diego, CA 04AUG2017 47 Black male gun threat not No No
San Fernando, CA 08OCT2017 Albert Garcia 58 Hispanic male knife threat not No No
San Francisco, CA 03MAY2017 Nicholas Flusche 26 White male knife attack not No Yes
San Francisco, CA 23MAY2017 John Eno 59 White male gun threat not No No
San Francisco, CA 24SEP2017 Damien Murray 39 Black male gun threat not No Yes
San Francisco, CA 01DEC2017 Keita O'Neil 42 Black male unarmed flee car No Yes
San Jose, CA 03MAY2017 28   male knife attack not Yes No
San Jose, CA 03MAY2017 Mirza Tatlic 24 White male gun point not Yes No
San Jose, CA 28MAY2017 Francis de la Cruz 35   male blunt_object threat not Yes No
San Jose, CA 15SEP2017 Jacob Dominguez 32 Hispanic male unarmed move car No No
San Marcos, CA 02MAR2017 Isidro Bazan Jr 34 Hispanic male blunt_object threat not No No
San Mateo, CA 28APR2017 Luis Fernando Pacheco 25 Hispanic male gun attack not No No
Santa Ana, CA 29JAN2017 Steve Salgado 18 Hispanic male unarmed flee foot No No
Santa Ana, CA 21JUL2017 Yahir Breito 22 Hispanic male knife threat not No No
Santa Barbara, CA 12FEB2017 Bryan Devin Carreno 26 Hispanic male knife threat foot Yes No
Santa Clara, CA 09MAR2017 Jesus Alberto Geney 24 Hispanic male knife threat   Yes No
Santa Monica, CA 06FEB2017 Gerardo Vasquez 52 Hispanic male knife attack foot Yes No
Santa Paula, CA 09APR2017 Jose Gonzales Rendon 36 Hispanic male knife attack not No No
Santa Rosa, CA 05AUG2017 Pablo Garcia 35 Hispanic male knife attack not Yes Yes
Selma, CA 12JUN2017 Johnny Platas 45 Hispanic male knife threat not No No
South Gate, CA 20JUN2017 David Pacas 36 Hispanic male replica point other No No
South Gate, CA 27NOV2017 Christian Chavez 40 Hispanic male gun shoot not Yes No
Stockton, CA 14NOV2017 Keian Jones 51   male knife threat car No No
Sunnyvale, CA 31OCT2017 Jesus Birelas-Contreras 25 Hispanic male knife attack not No No
Torrance, CA 14OCT2017 Michael David Lopez 44 Hispanic male undetermined move car No No
Tulare, CA 26DEC2017 Robert Miller 40   male gun point car No No
Tustin, CA 16MAY2017 Edwin Fuentes 24 Hispanic male gun shoot not Yes No
Twentynine Palms, CA 17JAN2017 Dominic Hodges 39 Hispanic male gun shoot not No No
University City, CA 30APR2017 Peter Raymond Selis 49 White male gun shoot not No No
Vacaville, CA 29MAY2017 Joseph Godinez 20 Hispanic male   attack car No Yes
Vallejo, CA 23JAN2017 Angel Ramos 21 Hispanic male knife attack not No Yes
Van Nuys, CA 15NOV2017 Oscar Anaya 22 Hispanic male gun shoot car No No
Visalia, CA 01AUG2017 Franklin Oden 39 White male gun shoot foot No No
Vista, CA 05JUL2017 Jonathan Coronel 24 Hispanic male unarmed flee foot No No
Yuba City, CA 22APR2017 Joseph Sin 43 Asian male gun;knife shoot foot No No
Yuba City, CA 01AUG2017 Mark Anthony Sanchez 33 Hispanic male gun shoot not 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?
Centennial, CO 31MAY2017 James Daniel Hill 17 White male gun threat other No No
Centennial, CO 29OCT2017 Mark Bidon 50 White male gun point not No No
Colorado City, CO 21AUG2017 Dennia Flowers 66 White male gun shoot not No No
Colorado Springs, CO 21FEB2017 Misael Macias Cano 39 Hispanic male gun threat other No No
Colorado Springs, CO 14AUG2017 Steven James Young 45 White male replica point foot No No
Colorado Springs, CO 02DEC2017 Christopher Louis Willard 33 White male gun point not No No
Commerce City, CO 06FEB2017 Cole Wooley 50 Black male gun point not Yes No
Denver, CO 30JUN2017 Stephanie Lopez 32   female gun shoot car No No
Denver, CO 21SEP2017 Austin Dunsmore 25 Black male undetermined move car No No
Denver, CO 22SEP2017   White male undetermined threat not No No
Denver, CO 10NOV2017 John Bazemore III 25 Black male gun flee foot No No
Denver, CO 07DEC2017 Kyler Grabbingbear 19 Native American male unarmed flee foot No No
Englewood, CO 03MAR2017 Michael Kocher 32 White male gun threat not Yes No
Federal Heights, CO 04JUL2017     male gun undetermined not No No
Fort Collins, CO 01JUL2017 Jeremy Holmes 19 Asian male knife threat not Yes Yes
Golden, CO 06OCT2017 Dale Sisson 51 White male gun shoot car No No
Greeley, CO 28OCT2017 Danny Sanchez 40 Hispanic male vehicle;gun point car No No
Greeley, CO 21DEC2017 Jose Aguero 26 Hispanic male gun threat foot Yes No
Highlands Ranch, CO 31DEC2017 Matthew Riehl 37   male gun shoot not Yes Yes
Loveland, CO 08JUN2017 Stephen Rich 48 White male gun shoot   No No
Loveland, CO 30JUN2017 Chet Knuppel 23 White male unarmed attack foot No No
North Fort Collins, CO 01OCT2017 George Randall Newman 26 White male gun point not No Yes
Northglenn, CO 07JAN2017 Hector Navarrete 31 Hispanic male   threat not Yes No
Northglenn, CO 13DEC2017 Jeremy Patscheck     male vehicle attack   No No
Parker, CO 04NOV2017 Michael Wayne Marin 35 White male gun shoot   No No
Pleasant View, CO 04JUL2017 Tyrone Orvy Peabody 53 Native American male gun shoot not No No
Pueblo, CO 05FEB2017 Andrew Byrd 33 Hispanic male   move not No Yes
Valdez, CO 11OCT2017 Kristian Martinez 44 Hispanic male unarmed attack foot No No
Westminster, CO 14MAR2017 Alexander Meltz 18 White male gun point not No No
Westminster, CO 09MAY2017 Joseph Jaster 40 White male gun shoot not No No
Westminster, CO 30JUN2017 Brett Rodriguez 33 Hispanic male gun threat foot 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?
Bridgeport, CT 09MAY2017 Jayson Negron 15 Hispanic male   threat car No No
New Britain, CT 14DEC2017 Zoe Dowdell 20 Black male   move car No No
New Milford, CT 28AUG2017 Kostatinos Sfaelos 62 White male gun point foot No No
Oakdale, CT 29JAN2017 Val Thomas 53   male other attack not Yes No
Suffield, CT 13APR2017 Thomas Gezotis 57 White male gun threat   No No

statecode=DC

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?
Dover, DE 09DEC2017 Juliun Pitcher 16 White male gun shoot not No No
Middletown, DE 27APR2017 Burgon Sealy Jr. 26 Black male gun shoot not No No
New Castle, DE 29MAR2017 Leroy Brown Jr. 28 Black male undetermined threat car No No
Wilmington, DE 23JAN2017 Bruce Altenburger 60 White male gun threat not Yes No
Wilmington, DE 19APR2017 Keith Price 21 Black male gun point other No Yes
Wilmington, DE 15DEC2017 Adam Radcliffe 30 White male   move car 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?
Bradenton, FL 06APR2017 Glenn Watenpool 68 White male gun shoot not No No
Brooksville, FL 20FEB2017 Taylor Hodge 26 White male knife attack not Yes No
Brooksville, FL 22SEP2017 Scott Michael Chamberlain 44 White male   attack car Yes No
Callahan, FL 04JUN2017 Jeremy Austin Lindsey 27 White male gun point   No No
Cantonment, FL 01APR2017 Marcus Williams 34 Black male gun shoot foot No No
Cape Canaveral, FL 19MAR2017 Trevor Allen Brice Gingras 19 White male gun point foot No No
Clearwater, FL 19OCT2017 Mitchell Fox 34 White male gun threat not Yes No
Coral Springs, FL 06DEC2017 Robert Page 71   male gun undetermined not Yes No
Crescent City, FL 08JUL2017 Cardell Vance III 23 Black male knife threat not Yes No
Crystal Springs, FL 13JUL2017 Stephen Steele 47 White male knife threat not Yes No
DeLand, FL 04FEB2017 Thomas Scott Henry 56 White male gun shoot not Yes No
DeLand, FL 19MAR2017 Mario Simoes 45 Hispanic male gun threat car Yes No
Delray Beach, FL 26MAR2017 David Eric Ufferman 56 White male unarmed attack not Yes No
Deltona, FL 16MAR2017 Daniel Donarski 58 White male gun point not Yes No
Deltona, FL 29JUN2017 Jose Guillermo Flores Colon 37 Hispanic male other threat not No No
Englewood, FL 26FEB2017 Jacob Taulbee 41 White male knife threat not No No
Floral City, FL 26FEB2017 James Leroy Marker 66 White male gun threat car No No
Fort Myers, FL 31AUG2017 Debi Lynn Thorkelson 54 White female gun point not No No
Gainesville, FL 20JAN2017 Gino Martin Palazzolo 39 White male gun point not Yes No
Gifford, FL 19MAR2017 Alteria Woods 21 Black female unarmed accident not No No
Hallandale Beach, FL 15SEP2017 Matthew Michael McTague 48 White male   attack car Yes No
Hialeah, FL 01OCT2017 Lester Jesus Machado 24 Hispanic male   attack car No No
Indiantown, FL 27OCT2017 Jerry Richardson 46 Black male knife threat not Yes No
Jacksonville, FL 06FEB2017 Jerome Allen 22 Black male replica point not No No
Jacksonville, FL 26APR2017 Selwyn Aubrey Hall 57 Black male other threat not No No
Jacksonville, FL 09MAY2017 Terry Percy Campbell 25 Black male gun shoot not Yes No
Jacksonville, FL 25JUL2017 Michael Joseph Harris 28 White male gun point car No No
Jacksonville, FL 14AUG2017 Robert Emmett Bracewell Jr. 20 White male gun point not No No
Jacksonville, FL 18AUG2017 Derrick Rashard Brabham 25 Black male gun shoot not No No
Jacksonville, FL 25AUG2017 Daniel Blyler 44 White male gun threat not No No
Jupiter, FL 12MAY2017 Phillip O'Shea 46 White male gun shoot car No No
Kendale Lakes, FL 05SEP2017 Daniel Wheelock 16 White male knife attack not No No
Lakeland, FL 02NOV2017 Jerry Roach 71 White male gun shoot not Yes No
Lakes Wales, FL 05JUN2017 Quentin Louis Case 34 White male gun shoot other No No
Largo, FL 06APR2017 Richard Xavier Summers 49 Black male gun shoot not No No
Lauderdale Lakes, FL 06DEC2017 Jean Pedro Pierre 42 Black male unarmed attack not Yes Yes
Miami, FL 28MAY2017 Jilani Mario Mitchell 24   male gun shoot car No No
Miami, FL 05JUN2017 John Spaulding 47 Black male gun threat   No No
Miami, FL 09JUN2017 Theodore Brendecke 82 White male gun shoot   Yes No
Miami, FL 30AUG2017 Anthony Antonio Ford 27 Black male unarmed move foot No No
Miami, FL 06OCT2017 Ernesto Padron 52 Hispanic male gun flee foot No No
Miami, FL 08OCT2017 Cariann Hithon 22 Black female vehicle attack car No No
Ocala, FL 12JAN2017 Kevin Ernest Tree 54 White male gun threat not Yes No
Orange Park, FL 02FEB2017 Michael Sword 57 White male gun threat not No No
Orlando, FL 28FEB2017 Christopher Redding Jr. 20 Black male gun shoot foot No No
Orlando, FL 21MAY2017 Carlos Garcia Petrovich 37 Hispanic male unarmed attack not No No
Orlando, FL 06OCT2017 Roberto Callejas 35 Hispanic male knife attack not Yes No
Palatka, FL 30SEP2017 Tyrell Dewayne Pinkston 28 Black male gun threat not No No
Palmetto, FL 25SEP2017 Anthony Robinson 32 Black male gun shoot foot No No
Panama City Beach, FL 14MAR2017 Shawn Anthony Dumitras 43 White male gun shoot   No No
Plant City, FL 06JUL2017 Jesus Cervantes 35 Hispanic male undetermined threat car No No
Port Orange, FL 03NOV2017 Robert Powell 53 White male vehicle;gun shoot car No No
Saint Petersburg, FL 25OCT2017 Timothy Earl Jackson 33 Black male gun shoot not No No
Spring Hill, FL 27SEP2017 Anthony Wallace 44 White male gun shoot car No No
Sunrise, FL 25AUG2017 Kristen Ambury 28 White female gun threat not Yes No
Vero Beach, FL 26JUL2017 Susan Teel 62 White female knife attack not Yes No
Yulee, FL 02JUN2017 Edward Everett Courtenay 51 White male   attack car 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?
Atlanta, GA 26JAN2017 Deaundre Phillips 24 Black male gun move car No Yes
Atlanta, GA 28APR2017 Avery Richard 32 Black male gun shoot not No No
Atlanta, GA 02AUG2017 Quintas Harris 27 Black male gun shoot not Yes No
Atlanta, GA 16SEP2017 Scout Schultz 21 White non-bi knife threat not Yes No
Austell, GA 27MAY2017 Eduardo Valencia 30   male gun shoot not No No
Bonaire, GA 03JUL2017 Christopher Henry Cashell 45 White male gun threat not No No
Brooklet, GA 23JAN2017 Gary Mark Wigley 52 White male gun point foot No No
Cedartown, GA 18MAR2017 Jason Dennis Watkins 36 White male   move car No No
Columbus, GA 04SEP2017 James Fuller 52 White male other attack not No No
Columbus, GA 29DEC2017 Jarvis Lykes 35 Black male undetermined threat car No No
Cumming, GA 08JAN2017 Jason Aldridge 44 White male knife threat not Yes No
Forest Park, GA 08NOV2017 James Jacob Bailey 30 White male gun shoot car No No
Griffin, GA 27SEP2017 Guy Lynn Scott Jr. 48 White male gun point not Yes No
Habersham, GA 13AUG2017 Christopher Collins 24 White male gun threat not No No
Hiram, GA 05OCT2017 Brandon Lee Bohanon 35 White male unarmed move not No No
Lizella, GA 25APR2017 Gavin Williams 27 Black male knife threat not No No
Lumpkin, GA 25FEB2017 William Dwayne Darby 39 White male gun shoot car No No
Marietta, GA 29JUN2017 Joel Gatu Muturi 23 Black male   threat not No No
Marietta, GA 07JUL2017 Brian Easley 33 Black male unarmed attack not Yes No
Marietta, GA 07NOV2017 Talathia Brooks 32 White female gun point not Yes No
Monticello, GA 04DEC2017 Jeffrey Scott Cantrell 46 White male gun shoot not No No
Moultrie, GA 04FEB2017 Peter Torres 23 Hispanic male unarmed move not No No
Peachtree City, GA 03MAY2017 William Dean 67 White male gun shoot not Yes No
Rincon, GA 12DEC2017 Marcia Metzger Aiken 50 White female undetermined threat not Yes No
Thomas County, GA 04OCT2017 Jomekia Minter 37 Black male gun point not No No
Thomasville, GA 15AUG2017 Herbert Gilbert 37 Black male vehicle threat not No Yes
Tyrone, GA 16JAN2017 David Wesley Carroll 36 White male gun shoot other No No
Woodstock, GA 01JAN2017 Chad Erik Roberts 35 White male gun point car No No
Woodville, GA 25AUG2017 Charles David Robinson 47 Black male unarmed attack foot No No

statecode=HI

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?
Dakota City, IA 11NOV2017 Shane Jensen 19 White male gun point other Yes No
Davenport, IA 19NOV2017 Matthew Donald Tobin 26 White male gun shoot not No No
Des Moines, IA 05JUL2017 Tiffany Lynn Potter 29 White female gun shoot foot No Yes
North English, IA 10JUN2017 Robin Blaylock 53 White male gun threat not No No
West Burlington, IA 01OCT2017 Marquis "Bubba" Jones 27 Black male gun threat other No Yes

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 18MAR2017 Benjamin Christian Barnes 42 White male gun shoot not No No
Coolin, ID 26SEP2017 Craig A. Johnson 50 White male gun threat not No No
Kuna, ID 24JAN2017 Ramon Milanez 32 Hispanic male unarmed move other No Yes
Melba, ID 29JUL2017 Dennis W. Robinson 48 White male gun shoot car No No
Mountain Home, ID 22MAY2017 Aaron M. Thompson 31 White male knife attack not No No
Pocatello, ID 22DEC2017 Lawrence McClellon 62   male gun threat not 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?
Belleville, IL 04JUL2017 Donald Martin 39 White male gun shoot not Yes No
Chicago, IL 15JAN2017 Herbert Johnson 34 Black male gun shoot foot No No
Chicago, IL 08FEB2017 Chad Robertson 25 Black male unarmed flee foot No No
Chicago, IL 10FEB2017 Michelle Robey 55 White female knife attack not Yes No
Chicago, IL 02JUN2017 Corsean Lewis 17 Black male gun shoot not No No
Chicago, IL 09JUL2017 Brayant Alvarez 24 Hispanic male gun shoot foot No No
Chicago, IL 10SEP2017 Juan Flores 19 Hispanic male   attack not No Yes
Chicago, IL 29NOV2017 Aquoness Cathery 24 Black male gun threat   No Yes
Dalton, IL 08AUG2017 Darreon Neal 17 Black male gun threat other No No
Forest Park, IL 03FEB2017 Marco A. Gomez 26 Hispanic male   move car No No
Jerseyville, IL 13JUN2017 Austin Durham 24 White male gun shoot foot No No
Lawndale, IL 01JUL2017 Quintec Locke 37 Black male gun threat not No Yes
Lyons, IL 09JUN2017 Antonio Juarez 44 Hispanic male gun shoot car No No
Maeystown, IL 05JUL2017 Edwin "Beanie" Esker 53 White male other threat not No No
Peoria, IL 20SEP2017 Eddie Russell Jr. 25 Black male gun move not Yes No
Rockford, IL 05NOV2017 Eddie Lee Patterson 49 Black male   undetermined car No No
Springfield, IL 23JAN2017 Daniel D. Rogers 27 White male unarmed attack not Yes Yes
Stockton, IL 29MAR2017 Troy Boyle 41 White male gun shoot car No No
Villa Park, IL 01JAN2017 Trevon Johnson 17 Black male knife threat not Yes 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?
Brookville, IN 08FEB2017 Donald Parker Jr. 29 White male gun threat not No No
Columbua, IN 30SEP2017 Quentin Starke 44 White male gun shoot car No No
Dyer, IN 10AUG2017 Mark P. Coffey 33 White male gun point   Yes No
Elkhart, IN 28DEC2017 Corey Bailey 30 Black male gun point car No No
English, IN 04JAN2017 Richard A. Jackson 45 White male unknown attack car No No
Evansville, IN 29AUG2017 Ricky Ard 55 Black male blunt_object threat not Yes Yes
Fishers, IN 03JUL2017 John Donadio 51 White male gun shoot not Yes No
Gary, IN 18JAN2017 Marquis Thomas 19 Black male gun shoot car No No
Gary, IN 03AUG2017 Kemonte Cobbs 15 Black male gun point foot No No
Goshen, IN 05APR2017 Michael Alcaraz 19 Hispanic male gun shoot car No No
Indianapolis, IN 29JUN2017 Aaron Bailey 45 Black male unarmed flee car No No
Lafayette, IN 28MAR2017 Peter J. Doffin Jr. 36 White male gun point car No No
Lawrence, IN 26DEC2017 Jesse Scarsbrook 28 Black male gun shoot car No No
New Castle, IN 24SEP2017 Jarred Burke 24 White male gun shoot foot No No
New Castle, IN 29OCT2017 Brandon Lee Flowers 41 White male knife attack not No No
Owen County, IN 04NOV2017 Mason Johnson III 31 White male gun shoot not Yes No
Portage, IN 22APR2017 William D. Spates 39 Black male   threat not Yes No
Shelbyville, IN 14FEB2017 Steven C. Oliger 64 White male gun shoot not No No
Vincennes, IN 14FEB2017 David Zimmerman 35 White male gun move other 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?
Finney County, KS 05OCT2017 Cristino Umana-Garcia 29 Hispanic male knife threat not Yes No
Junction City, KS 08AUG2017 Peter James Robbins 23 White male gun point not Yes No
Leavenworth, KS 11JUL2017 Antonio Garcia Jr. 47 Black male knife undetermined not No No
Lehigh, KS 20JUN2017 Robb Stewart 50 White male gun threat not Yes No
Newton, KS 23FEB2017 David Lee Montano 33 Hispanic male gun point not No No
Newton, KS 28AUG2017 William Matthew Holmes 24 Black male undetermined attack car Yes Yes
Olathe, KS 23AUG2017 Ciara Howard 26 White female gun threat not Yes No
Topeka, KS 28SEP2017 Dominique Tyrell White 30 Native American male gun attack foot No Yes
Udall, KS 13APR2017 Charles Johnston 25 White male gun shoot car No No
Wichita, KS 18MAR2017 Kevin C. Perry 25 White male gun shoot not No No
Wichita, KS 07AUG2017 Jose Ortiz 29 Hispanic male knife threat not No No
Wichita, KS 27DEC2017 Andrew Finch 28 White male unarmed accident not 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?
Bardstown, KY 05JUN2017 Charles Edgar Mullins 45 White male gun shoot car No No
Booneville, KY 22MAR2017 Charles Harris 42 White male knife threat not No No
Flatwoods, KY 09NOV2017 Kiser L. Sturgell 27 White male gun threat car No No
Flatwoods, KY 09NOV2017 Ashley Jenkins 23 White female unarmed accident car No No
Fulton, KY 16JAN2017 Charles Christopher McClure 43 White male knife;blunt_object threat not No No
Lancaster, KY 04JAN2017 Welby O'Dell Mullins Jr. 64 White male gun shoot not No No
Lawrenceburg, KY 29MAR2017 Fred Ratliff 45 White male gun shoot not No No
London, KY 24FEB2017 Joey Isgrigg 30 White male gun shoot not Yes No
Louisville, KY 11FEB2017 William A. Young Jr. 32 White male blunt_object attack not Yes Yes
Louisville, KY 08OCT2017 Corey Boykin 24 Black male gun threat not No Yes
Pippa Passes, KY 01NOV2017 Christopher Jacobs 28 White male   attack car No No
Richmond, KY 07FEB2017 Kenneth B. Huntzinger 51 White male   move   No No
Sharpsburg, KY 27AUG2017 Dwayne Martin 34 White male knife attack foot No No
Shelbyville, KY 23OCT2017 Ashleigh Bertucci 31 White female gun threat not Yes Yes
Trosper, KY 12JUN2017 John Wesley Bays 50 White male gun shoot not No No
Warren County, KY 18NOV2017 Brian Calvert 18 White male   point car No No
Wayne County, KY 13OCT2017 Paul Dolen 57 White male gun shoot 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?
Baton Rouge, LA 13JUN2017 Jordan Frazier 35 Black male gun threat not No No
Baton Rouge, LA 13NOV2017 Calvin Toney 24 Black male unarmed attack foot No Yes
Bernice, LA 19SEP2017 Randall Ross 53 White male undetermined undetermined   No No
Cade, LA 12JUN2017 Avery D. Metrejean 35 White male gun threat not No No
Converse, LA 21MAY2017 Ricco Devante Holden 24 Black male unarmed attack not No No
Coushatta, LA 02AUG2017 Preston Thornton 29 Black male gun shoot not Yes No
Crowley, LA 22MAR2017 Don Johnson 27 Black male gun shoot not No No
East Baton Rouge, LA 11MAR2017 Brandon Wiley 30 Black male gun shoot   No No
Gibson, LA 10NOV2017 Terry A. Dubois Jr. 55 White male gun shoot not Yes No
Homer, LA 27JUL2017 Deltra Henderson 39 Black male gun attack car No No
Houma, LA 28FEB2017 Jose Olivares 43 Hispanic male gun threat not Yes No
Kenner, LA 23JAN2017 Armond Brown 25 Black male knife threat not Yes No
Lincoln Parish, LA 29AUG2017 Joshua Mark Cloud 22 White male gun shoot not No No
Mamou, LA 06JUL2017 Dejuan Guillory 27 Black male unarmed move not No No
New Iberia, LA 01APR2017 Phosowath Sengphong 30 Asian male knife threat   No No
New Orleans, LA 24JAN2017 Arties Manning III 26 Black male gun point car No Yes
St. Tammany Parish, LA 11NOV2017 Eddy Longoria 55 White male gun point not No No
West Monroe, LA 17NOV2017 Shady Bell Jr. 46 Black male gun shoot not No No
West Ouachita, LA 02OCT2017 Marquinton T. Brooks 22 White male gun threat foot No No

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 07FEB2017 Curtis Jamal Deal 18 Black male gun threat other No Yes
Baltimore, MD 24MAR2017 Reno Joseph Owens Jr. 39 Black male knife threat not Yes Yes
Baltimore, MD 16OCT2017 Eric Garrison 20 Black male gun move foot No Yes
Dundalk, MD 07JUN2017 Blaine Robert Erb 35 White male gun shoot not No Yes
Elkridge, MD 07JAN2017 William Tucker Mathis 41 White male unarmed attack not Yes No
Montgomery Village, MD 27MAR2017 Richard Alexander Tilley 28 White male knife threat not No Yes
Mt Airy, MD 10JUL2017 Cody Ethan Mitchell 26 White male   attack not No No
Overlea, MD 26JAN2017 Kerry Lee Coomer 59 White male gun point not Yes Yes
Woodlawn, MD 13MAR2017 Rashad Daquan Opher 20 Black male   threat other No Yes

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?
Arundel, ME 29MAY2017 Chad Dionne 37 White male gun threat not No No
Belgrade, ME 20MAY2017 Roger Bubar 65 White male gun shoot not No No
Madison, ME 05JUL2017 Carroll Tuttle Jr. 51 White male gun shoot   No No
Orrington, ME 06JUN2017 Mark Ellis 54 White male gun shoot not No No
Portland, ME 18FEB2017 Chance David Baker 22 Black male replica threat not Yes No
Presque Isle, ME 17MAR2017 Brentant M. Lahey 25 White male knife threat not No No
Vassalboro, ME 10FEB2017 Kadhar Bailey 25 White male   move   No No
Vassalboro, ME 10FEB2017 Ambroshia Fagre 18 White female unarmed move   No No
Waldoboro, ME 22JAN2017 Jon M. Alspaugh 57 White male gun shoot not 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?
Algoma Township, MI 24JAN2017 Jonathan David Sper 30 White male unarmed attack not Yes No
Brighton Township, MI 09MAY2017 Ian Thomas Little 36 White male replica point not Yes No
Detroit, MI 13FEB2017 Raynard Burton 19 Black male unarmed attack other No No
Detroit, MI 30APR2017 James Edward Ray 46 Black male gun shoot not No No
Eaton County, MI 28NOV2017 Robert Claude Smith 64 White male   attack car No No
Grand Rapids, MI 03MAY2017 Malik Carey 18 Black male gun shoot not No Yes
Holland Township, MI 23NOV2017 David Leroy Thelen Jr. 43 White male knife threat not Yes No
Inkster, MI 02NOV2017     male gun shoot not No No
Manistee, MI 28MAR2017 Lee Pat Milks 73 White male gun point not No No
Marine City, MI 04AUG2017 Melissa Wiseman 36 White female gun threat not No No
Oak Park, MI 18DEC2017 Todd A. Stone 48 Black male knife threat not No No
Saginaw, MI 19JUL2017 Farhad Jabbari 38 Other male unarmed attack not No No
Warren, MI 16MAR2017 Frederick Ricardo Brown 34 Black male gun shoot not No No
Waterford Township, MI 24AUG2017 Colton Puckett 28 White male gun threat 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?
, MN 20MAR2017 Clarence Duane Huderle 73   male gun shoot   No No
Austin, MN 11JAN2017 Ronnie Johnson 41 White male blunt_object threat not No No
Crystal, MN 10NOV2017 Ronald L. Klitzka 62 White male gun shoot not Yes No
Gilbert, MN 22DEC2017 Jeffrey John Golnick 40 White male gun shoot foot No No
Minneapolis, MN 15JUL2017 Justine Damond 40 White female unarmed undetermined not No No
North Branch, MN 10JUL2017 Gregory Shawn Thrower 39 White male gun point car No No
Saint Paul, MN 15MAR2017 Cordale Quinn Handy 29 Black male gun threat not No No
Saint Paul, MN 05OCT2017 Phumee Lee 28 Asian male gun shoot not No Yes
Vadnais Heights, MN 16APR2017 Darren Jahnke 47 White male gun threat not No No
Vineland, MN 12JAN2017 Jamison Christopher Anderson 20 Native American male gun point not 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?
Affton, MO 19MAR2017 Clifton Knickmeyer 59 White male gun point other No No
Blue Summit, MO 07AUG2017 Christopher K. Sales 36 White male unarmed flee car No No
Cape Girardeau, MO 15FEB2017 Andrew McClendon 33 White male knife threat not No No
Columbia, MO 13MAY2017 Clarence E. Coats Jr. 41 Black male gun shoot   No No
Florissant, MO 19JAN2017 Elijah Smith 25 White male knife attack not Yes No
Independence, MO 07JAN2017 Carlos A. Cruz 50 Hispanic male gun point not Yes No
Jefferson City, MO 03OCT2017 John Loaiza 40 White male blunt_object attack not No No
Kansas City, MO 04FEB2017 Johnnie J. Harris Jr. 68 Black male gun point not No No
Kansas City, MO 11FEB2017 Alonzo E. Ashley Jr. 27 Black male gun point not No No
Kansas City, MO 28JUL2017 Rodney E. Jacobs 31 Black male gun point not No No
Kansas City, MO 06AUG2017 Danatae Franklin 28 Black male gun point foot No No
Lebanon, MO 23NOV2017 Nikolas Wanner 32 White male gun point not Yes No
Monett, MO 08SEP2017 Michael Culhane 50 White male undetermined threat not Yes No
Neosho, MO 20JUL2017 Joshua Daniels 52 White male gun point not No No
Nevada, MO 21JUN2017 Brandon D. Lukenbill 33 White male undetermined threat car No No
Poplar Bluff, MO 11JUL2017 Steve Scott 48 White male gun threat not No No
Saint Joseph, MO 20FEB2017 Jason Fanning 27 White male unarmed attack not No No
Saint Joseph, MO 22OCT2017 Samantha Hennard 25 White female gun shoot foot No No
Saint Louis, MO 09JAN2017 Davion Henderson 21 Black male gun point car No No
Saint Louis, MO 21FEB2017 Don Clark 63 Black male gun shoot not No No
Saint Louis, MO 10MAY2017 Robin White 50 Black female gun shoot not No No
Saint Louis, MO 26MAY2017 Jamie J. Robinson 33 White male gun shoot not Yes No
Saint Louis, MO 07JUN2017 Isaiah M. Hammett 21 White male gun shoot not No No
Saint Louis, MO 20JUL2017 Isaiah Perkins 27 Black male gun point car No No
Saint Louis, MO 24JUL2017 Jerrod Kershaw 31 White male gun shoot car Yes No
Saint Louis, MO 22AUG2017 Kiwi Herring 30 Black female knife attack not No No
Saint Louis, MO 01OCT2017 Joshua Lanflisi 38 White male gun;knife threat not Yes No
Saint Louis, MO 23NOV2017 Rehyen Bost-McMurray 17 Black male gun point   No No
Springfield, MO 01JAN2017 James E. Lewis 44 Black male gun point foot Yes No
St Louis, MO 13JUN2017 Chazz Brown 33 Black male gun shoot not No No
Sugar Creek, MO 24JAN2017 Dakota A. Lukecart 22 White male unarmed flee car 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 11OCT2017 Vincent Dronet 61 White male   attack car No No
Columbus, MS 27MAR2017 Pryor Spencer Bailey IV 45 White male gun shoot car No No
Columbus, MS 04NOV2017 Raymond Davis 24 Black male gun threat not No Yes
Greenville, MS 21JAN2017 Ronnie Lee Shorter 44 Black male gun shoot not No No
Gulfport, MS 20NOV2017 Seth William Johnson 15 White male knife flee not No No
Hattiesburg, MS 22SEP2017 Bryan Wright 40 White male gun shoot not No No
Hinds County, MS 10NOV2017   Black male   move not No No
Jackson, MS 15NOV2017   Black male knife threat not No No
Lauderdale County, MS 04AUG2017 Jeremy Gabrial 31 White male replica point not Yes Yes
Meridian, MS 05NOV2017 John Quincy Grady 35 White male gun shoot not No No
Neshoba County, MS 09NOV2017 Charles Edwin Nickels 35 White male gun point not Yes No
Petal, MS 02JUN2017 Marc Brandon Davis 34 Black male unarmed attack not No No
Southaven, MS 25JAN2017 Kevin Darnell Washington 54 Black male gun shoot not No No
Southaven, MS 23JUL2017 Ismael Lopez Rodriguez 41 Hispanic male gun point not No No
Tate County, MS 29OCT2017 Eric Higgs 46 Black male gun shoot car No No
Water Valley, MS 16JUN2017 Robert J. Berube 41 White male gun shoot car No No
Water Valley, MS 16JUN2017 Jamie Dougan 24 White female unarmed accident car 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 12MAY2017 Ryan Lowell 30 White male gun point not Yes No
Billings, MT 04NOV2017 Frank Half Jr. 30 Native American male gun shoot   No No
Billings, MT 18NOV2017 Preston Bell 24 Native American male vehicle attack car No Yes
Great Falls, MT 11SEP2017 Thomas Addison 25 Native American male unknown threat foot No No
Great Falls, MT 11DEC2017 Stacy Micheletti 51 White male unknown threat   No No
Three Forks, MT 16MAY2017 Marshall Barrus 38 White male gun shoot 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?
Cary, NC 28MAY2017 Shaquian Tyrone Johnson 22 Black male gun shoot not No No
Charlotte, NC 26JAN2017 Josue Javier Diaz 28 Hispanic male gun threat car No No
Charlotte, NC 08MAR2017 Iaroslav Mosiiuk 25 White male gun threat not Yes No
Charlotte, NC 06SEP2017 Rueben Galindo 29 Hispanic male gun threat not No No
Durham, NC 12FEB2017 Willard Eugene Scott Jr. 31 Black male gun threat other No No
Durham, NC 15FEB2017 Kenneth Lee Bailey Jr. 24 Black male gun point foot No No
Efland, NC 18FEB2017 Keo Crockett 46 Black male gun point not No No
Fayetteville, NC 16MAR2017 Patrick Earl Gatson 32 Black male gun point not No No
Greensboro, NC 10FEB2017 Carlos Keith Blackman 25 Black male gun shoot other No Yes
Hendersonville, NC 30NOV2017 Rufus Cedric Baker 32 Black male gun move foot No No
Hickory, NC 03FEB2017 William David Whetstone 33 White male gun point not No Yes
Hudson, NC 07JUN2017 Donald Smith 75 White male gun shoot not Yes No
Huntersville, NC 10SEP2017 Joseph Charles Cook 76 White male gun point not No No
Kings Mountain, NC 19OCT2017 Matthew Whitley 26 White male gun shoot other No No
Monroe, NC 19SEP2017 Joshua Stubbs 25 White male gun;knife point car No Yes
Morganton, NC 21AUG2017 Jeffrey Jacobs 42 White male replica point not No No
Mt. Airy, NC 01AUG2017 Mikle Eugene Dixon 42 White male knife threat not No No
Newton Grove, NC 08JUL2017 Tina Medlin 50 White female gun shoot not No No
Parkton, NC 02OCT2017 Kevin Anthony Battaglia 33 White male gun shoot not Yes No
Rowland, NC 03FEB2017 Jamake Cason Thomas 22 Black male gun point car No No
Salisbury, NC 09NOV2017 Paul Jones III 25 Black male gun shoot car No No
Shelby, NC 27FEB2017 Joey J. Bridges Jr. 27 White male gun shoot foot Yes No

statecode=ND

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?
Canaan, NH 23DEC2017 Jesse Champney 26   male undetermined threat not No No
Hampton, NH 13JUN2017 Barry Jones 36 White male gun threat not No No
Newton, NH 15JUN2017 Michael Brown 40 White male gun undetermined car 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?
Bloomfield, NJ 18AUG2017 Leroy Frank 60   male knife move not No No
Brick, NJ 20AUG2017 Keshawn Wilson 32 Black male gun point not No No
Bridgeton, NJ 10FEB2017 Darryl L. Fuqua 23 Black male gun flee foot No No
Camden, NJ 11JAN2017 Jose A. Fernandez-Ventura 38 Hispanic male gun shoot not No No
Cranbury Township, NJ 30MAR2017 Christopher Angelo Pizzichetta 46 White male   move car No No
Newark, NJ 06APR2017 Kenneth Francis 37 Black male gun shoot not No No
Newark, NJ 25APR2017 Hakim McNair 23 Black male gun threat car No No
North Bergen, NJ 07AUG2017 Winston Espino Sanchez 45 Hispanic male knife attack not No No
Orange, NJ 24AUG2017 Scott Mayfield 24 Black male gun threat foot No No
Paterson, NJ 02MAR2017 Ramon Andrade 37 Hispanic male knife threat not Yes No
Paterson, NJ 14APR2017     male gun shoot not Yes No
Toms River, NJ 14MAR2017 Christopher Apostolos 56 White male unarmed attack   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?
Albuquerque, NM 07JAN2017 Gilbert Zambronio-Lovato 38 Hispanic male replica threat not No No
Albuquerque, NM 04JUL2017 Miguel Gonzales 28 Hispanic male gun undetermined other No No
Albuquerque, NM 28JUL2017 Raymond Cruz 37 Hispanic male   attack car No No
Albuquerque, NM 31JUL2017 Robert Savelli 43 White male gun point not No Yes
Albuquerque, NM 22AUG2017 Henry Rivera Jr. 71 Hispanic male   attack car No No
Albuquerque, NM 10NOV2017 Matthew Joseph Scudero 50 White male gun shoot not No No
Albuquerque, NM 17NOV2017 Martin Jim 25 White male unarmed accident car No No
Albuquerque, NM 17NOV2017 Isaac Padilla 23 Hispanic male unarmed flee car No No
Crownpoint, NM 09FEB2017     male undetermined undetermined   No No
Eldorado, NM 29APR2017 Andrew James Lucero 33 Hispanic male   attack not No Yes
Farmington, NM 27AUG2017 William Wilson 26 Hispanic male gun shoot not No No
Farmington, NM 20DEC2017 Frankie Anchondo 35   male unarmed move not No No
Las Cruces, NM 24JAN2017 Jeremy Lopez-Robledo 29 Hispanic male knife attack foot Yes Yes
Las Cruces, NM 17JUL2017 Ernesto Sedillo 52 Hispanic male gun point not No Yes
Las Cruces, NM 31OCT2017 Heather Denean Bubrig 37 White female blunt_object threat not Yes No
Penasco, NM 25NOV2017 Nelson F. Rodarte 39 Hispanic male gun point not No No
Roswell, NM 26DEC2017 James Alan Berrones 46   male gun shoot   No No
Rowe, NM 26JUN2017 Rip Huntington 36 Hispanic male gun shoot not Yes No
Rudioso, NM 05NOV2017 Marylsa Sanchez 31 Hispanic female vehicle attack not No No
San Rafael, NM 26MAY2017 Hector Gamboa 59 Hispanic male unarmed threat not No No
Santa Fe, NM 19JUL2017 Anthony Benavidez 24 Hispanic male knife threat not Yes Yes

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?
Jean, NV 21JAN2017 Paul Carr Palmer III 50 White male knife attack not Yes No
Las Vegas, NV 06MAY2017 Steven Price 62 White male blunt_object threat not Yes No
Las Vegas, NV 01JUN2017 Francisco Suarez-Madonado 27 Hispanic male gun shoot not Yes No
Las Vegas, NV 20JUN2017 Pedro Ramirez 28 Hispanic male knife threat not No Yes
Las Vegas, NV 25JUN2017 George Marcus Tillman 56 Black male gun shoot not Yes Yes
Las Vegas, NV 11JUL2017 Caleb Edward Blaylock 27 White male knife undetermined   Yes Yes
Las Vegas, NV 01AUG2017 Miguel Salas 25 Hispanic male gun shoot not Yes Yes
Las Vegas, NV 25SEP2017 Cody O'Bryan 31 White male other point not Yes Yes
Las Vegas, NV 07NOV2017 Jarrett Varnado 35 Black male gun point not No No
Las Vegas, NV 11NOV2017 Phillip Pitts 41 Black male gun point not No No
Pahrump, NV 23MAY2017 Michael Anthony Bonini 65 White male gun shoot not No No
Reno, NV 23FEB2017 Steven Valenzuela 24 Hispanic male gun threat foot No No
Reno, NV 02MAR2017 Rafael Navarro-Garcia 25 Hispanic male gun shoot not No No
Reno, NV 28NOV2017 Lucas Stone 30 White male gun shoot not No No
Spanish Springs, NV 04AUG2017 Cory Stephens 35 White male gun threat not No No
Sparks, NV 22OCT2017 Johnny Bonta 43 Native American male gun point not No 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?
Bronx, NY 05DEC2017 Mario Sanabria 69 Hispanic male knife threat not No No
Brooklyn, NY 03JAN2017 James Owens 63 Black male knife threat not Yes No
Brooklyn, NY 04JAN2017 Joshua Martino 18 White male gun point foot No No
Brooklyn, NY 16FEB2017 Kadeem Torres 17 Black male gun shoot foot No No
Brooklyn, NY 31JUL2017 Dwayne Jeune 32 Black male knife attack not Yes No
Buffalo, NY 07MAY2017 Jose Hernandez-Rossy 26 Hispanic male gun shoot foot No No
Canandaigua, NY 04OCT2017 Sandy Guardiola 48 Black female gun shoot not No No
Elmira, NY 15NOV2017 Phillip Van Cise 59 White male gun shoot not Yes No
Glenville, NY 28JUL2017 Brian J. Skinner 32 White male knife move not Yes No
Horseheads, NY 26OCT2017 James M. Davis 34 White male gun shoot car No No
New York, NY 14JAN2017 Jahlire Nicholson 28 Black male knife attack not No No
New York, NY 19FEB2017 Sergio Reyes 18 Hispanic male replica point foot No No
New York, NY 05JUL2017 Alexander Bonds 34 Black male gun shoot foot No No
New York, NY 06SEP2017 Miguel Richards 31 Black male knife threat not Yes Yes
Tremont, NY 13NOV2017 Cornell Lockhart 67 Black male knife attack not Yes Yes
Yonkers, NY 15DEC2017 Eric Campbell     male gun threat car No 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 09JUL2017 Edward Taylor 54 Black male gun shoot not No No
Akron, OH 03SEP2017 William Porubsky 30 White male unarmed attack not Yes Yes
Canton, OH 24MAY2017 Hayden J. Stutz 24 White male unarmed attack not Yes Yes
Cleveland, OH 10APR2017 Jeffrey Findlay 30 White male gun threat not No No
Cleveland, OH 25OCT2017 Antonio Levison 33 Black male gun shoot foot No No
Colebrook Township, OH 15APR2017 Frederick H. Hall 56 White male gun point not Yes No
Columbus, OH 14FEB2017 Michael Lee Morris 53 White male knife threat not Yes No
Columbus, OH 23FEB2017 Jimmie Patton 38 White male gun point not No No
Columbus, OH 26APR2017 Jason Thomas Christian 32 White male   move car No No
Columbus, OH 07JUL2017 Kareem Ali Nadir Jones 30 Black male gun threat not No Yes
Dayton, OH 26JUL2017 Kesharn K. Burney 25 Black male   attack car No No
Englewood, OH 05FEB2017 Shelly Porter III 41 Black male gun attack not Yes Yes
Euclid, OH 13MAR2017 Luke O. Stewart 23 Black male   move   No Yes
Geneva Township, OH 09FEB2017 Vincent Palma 26 White male unarmed move not No No
Girard, OH 21OCT2017 Jason Marble 37 White male gun shoot not No No
Hamilton, OH 22APR2017 Michael Wilson-Salzl 24 White male knife threat not Yes No
Howland Township, OH 07FEB2017 Richard Latimer 34 White male gun shoot not No No
Kent, OH 19FEB2017 Christopher Carter 27 Black male knife attack not No No
Kettering, OH 27AUG2017 Jason Hoops 33 White male gun threat not No No
Lima, OH 03AUG2017 Keith Burkholder 57 White male gun shoot not No No
Madison Township, OH 26JAN2017 William Brigham 34 White male blunt_object threat not No No
Madison Township, OH 06APR2017 Benjamin Ailstock 38 White male gun attack not Yes No
Medina, OH 07MAR2017 Roy Dale Evans Jr. 38 White male undetermined flee car No No
Miami Township, OH 20DEC2017 Robert Edwards 33 White male replica threat not Yes No
Moraine, OH 20OCT2017 Jamarco McShann 23 Black male gun point not Yes No
New Straitsville, OH 05AUG2017 Timmy Wilson 24 White male gun attack not No No
Saint Clair Township, OH 20JUN2017 Jacob Faulkner 32 White male gun point other Yes No
Springfield, OH 01JAN2017 John McLaughlin 42 White male gun threat not No No
Steubenville, OH 21AUG2017 Nathaniel Richmond 51 Black male gun shoot not No No
Tiffin, OH 09MAY2017 Scott N. Bloomfield 34 White male gun shoot not No No
Toledo, OH 04SEP2017 Shane Marsh 44 White male knife attack not No No
Uniontown, OH 09JUL2017 Ryan A. Probst 28 White male gun shoot not No No
Vandalia, OH 04JUL2017 Dana Dubose 36 Black male knife attack not No No
Westerville, OH 06APR2017 Christopher Wade 39 Black male replica point not 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?
Anadarko, OK 08FEB2017 Henry James Hunter 34 Native American male knife threat   No No
Bethany, OK 10FEB2017 James Stephen McMullen 45 White male gun point not No No
Boswell, OK 21SEP2017 Mack Brinkley 70 White male gun shoot car No No
Byars, OK 29MAR2017 Doyle Wayne Johnson 59 White male gun point car No No
Fairfax, OK 23FEB2017 Kenneth Robertson 54   male gun shoot not No No
Fairland, OK 07JAN2017 Travis Edward Baker 42 White male gun point other No No
Fort Smith, OK 20OCT2017 Phillip Joel Trammell 30 White male knife attack not No Yes
Kiowa, OK 30JAN2017 Marvin Washington 50 Black male gun threat not No No
Logan County, OK 20APR2017 Marion Lee Holliday 64 White male gun point not Yes No
Millerton, OK 21JUN2017 Daniel Francisco Valenzuela 37 Hispanic male knife threat not No No
Oklahoma City, OK 04MAR2017 George Lee Seeton 38 White male   attack car No Yes
Oklahoma City, OK 25JUN2017 Deveonte Johnson 24 Black male gun point not No Yes
Oklahoma City, OK 12JUL2017 Dorsey Glenn Taulbee Jr. 33 Native American male gun shoot not No No
Oklahoma City, OK 20SEP2017 Magdiel Sanchez 35 Hispanic male blunt_object threat not No No
Oklahoma City, OK 15NOV2017 Dustin Robert Pigeon 29 Asian male unarmed threat not Yes Yes
Oklahoma City, OK 10DEC2017 Kyle Anthony Mihecoby 28 Native American male other attack not No No
Roland, OK 08JUN2017 Paul Mashburn 58 White male gun point not Yes No
Sallisaw, OK 05JUL2017 Jamie Huskey 45 White male gun shoot not No No
Tom, OK 30APR2017 Devin Hawkins 32 White male gun shoot not Yes No
Tulsa, OK 17FEB2017 David English 34 White male knife attack not Yes No
Tulsa, OK 02JUN2017 Naway Willy 18 Asian male gun point foot No No
Tulsa, OK 09JUN2017 Joshua Barre 29 Black male knife threat not Yes No
Tulsa, OK 24JUN2017 Jimmie Bevenue 47 White male gun point foot No No
Tulsa, OK 25DEC2017 Jacob Lee Craig 31 White male gun point not Yes Yes
Watts, OK 18JAN2017 Stoney McJunkin 40 White male blunt_object point not No No
Wewoka, OK 15MAY2017 Keith Andrew Chesser 48 White male other point not 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?
Beaverton, OR 21FEB2017 Douglas Michael Smith 51 White male gun threat not Yes No
Boring, OR 25DEC2017 Nathaniel Fritz Macalevy 44   male gun shoot car No No
Eugene, OR 26SEP2017 Roger Craig Nielsen 31 White male gun point not No No
Florence, OR 24JUN2017 Cameron Ollman 37 White male gun shoot car Yes No
Hillsboro, OR 03JUL2017 Holden Gorka 25 White male gun shoot foot No No
Klamath Falls, OR 23NOV2017 Emilio John Cruz Hernandez 26 Hispanic male gun threat foot No No
Polk County, OR 28OCT2017 Baltazar Escalona-Baez 17 Hispanic male knife threat car No No
Portland, OR 09FEB2017 Quanice Derrick Hayes 17 Black male replica move foot No No
Portland, OR 10MAY2017 Terrell Kyreem Johnson 24 Black male knife threat foot Yes No
Springfield, OR 18JUL2017 Robert Earl Vaughan 70 White male gun threat not Yes No
West Linn, OR 21APR2017 Chance Rickie Thompson 25 White male gun threat not Yes No
Wolf Creek, OR 24APR2017 Jacy Kevin McManus 35 White male knife threat 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 21MAY2017 Joseph M. Hodgin 43 White male gun shoot car No No
Canton Township, PA 01OCT2017 Anthony Gallo 34 White male knife threat not Yes No
Dover Township, PA 28DEC2017 Isaiah Christian Green 20   male gun threat not No No
Erie, PA 26OCT2017 Charles L. Wallace 46   male   move not No No
Fairchance, PA 18AUG2017 Clarence Belsar III 26 White male gun shoot not No No
Harrisburg, PA 22DEC2017 Ahmed Aminamin El-Mofty 51   male gun shoot foot No No
King of Prussia, PA 29OCT2017 Kalin Jackson 23 Black male   threat not No No
Lancaster City, PA 24JAN2017 Jose Efrain Rodriguez 18 Hispanic male gun shoot not No No
Lewistown, PA 26APR2017 Charles Bossinger 53 White male gun threat not Yes No
Lower Mount Bethel, PA 20MAY2017 Anthony Paul Ardo 47 White male other threat not Yes No
Mead Township, PA 04AUG2017 Joseph Miller 54 White male gun threat not No No
Old Forge, PA 07DEC2017 John Souder 40 White male gun point car No No
Perryopolis, PA 06OCT2017 Garrett Hoose 47 White male gun threat not Yes No
Philadelphia, PA 12MAY2017 Ronald Singletary 51 Black male knife threat not No No
Philadelphia, PA 08JUN2017 David Jones 30 Black male unarmed threat foot No No
Philadelphia, PA 11AUG2017 Tyrease Carlyle 31 Black male gun threat not Yes No
Philadelphia, PA 27DEC2017 Dennis Plowden 25 Black male   attack car No No
Pittsburgh, PA 22JAN2017 Christopher Thompkins 57 Black male gun shoot not No No
Plymouth Township, PA 24OCT2017 Sean Bohinski 37 White male unarmed attack not No No
Reading, PA 24FEB2017 Michael T. Stoudt 62 White male gun point not No No
Sharon, PA 06JAN2017 Sean Ryan Hake 23 White male knife threat not Yes No
Stewartstown, PA 24APR2017 Robert Becker 79 White male gun shoot not Yes No
Union Township, PA 08MAR2017 Frank W. Wratny 91 White male gun point not 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?
Providence, RI 09NOV2017 Joseph Santos 32 White male   shoot car No Yes

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?
Fountain Inn, SC 04MAR2017 Joseph Scott Inabinet 50 White male gun point not Yes No
Greenville, SC 11FEB2017 Jason Robert Mendez 37 White male gun threat not No No
Greenville County, SC 19NOV2017 Jacob McCarty 27 White male gun point car No No
Hardeeville, SC 20APR2017 Jose Trejo 26 Hispanic male gun shoot not No No
Lake View, SC 12JUL2017 James Gerald Davis 40 White male undetermined threat not Yes No
Lexington, SC 09MAY2017 John Bittle 39 White male unarmed flee foot No No
Myrtle Beach, SC 03SEP2017 Jarvis Hayes 31 Black male   attack car No No
North Charleston, SC 25JUN2017 Lawrence Heyward Jr. 56 Black male gun flee foot No No
Pendleton, SC 03APR2017 Jose Antonio Hernandez 46 Hispanic male gun threat not Yes Yes
Simpsonville, SC 16OCT2017 James Michael Chappell 32 White male gun attack not No No
Surfside Beach, SC 04AUG2017 Aaron Payne 33 White male gun point not Yes No
York, SC 01DEC2017 Trent Fondren 33 White male knife threat   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?
Alamo, TN 16MAR2017 Rodney James Hess 36 Black male   attack not Yes Yes
Bon Aqua, TN 06AUG2017 Kyle Andrew Lankford 32 White male knife threat foot No No
Charleston, TN 17DEC2017     male unknown threat foot No No
Chattanooga, TN 29MAR2017 Daniel Hendrix 26 White male gun threat not No No
Clarksville, TN 17APR2017 Michael Zennie Dial II 33 White male   move car No No
Clinton, TN 08NOV2017 Roger Raymond York Jr. 32 White male gun attack foot No No
Cosby, TN 13AUG2017 Carmen William Rongione 41 White male knife attack foot No No
Fairview, TN 26SEP2017 Jeffory Hughes 50 White male gun point not No No
Franklin, TN 20JUN2017 David Bryan Creson 40 White male gun point car No No
Hixson, TN 11SEP2017 Brian Patrick Allen 48 White male gun point car No No
Hohenwald, TN 05SEP2017 John Timmons 67   male gun threat not No No
Johnson City, TN 15MAY2017 Buford Shane Whitson 47 White male gun point other Yes No
Knoxville, TN 13FEB2017 Brandon S. Lambert 32 White male   attack car No No
Knoxville, TN 23MAY2017 Albert Gagnier 74 White male gun shoot not No No
Lakeland, TN 17MAR2017 Nancy Jane Lewellyn 59 White female replica point not Yes No
Lewisburg, TN 27MAR2017 Steven Hopwood 51 White male gun shoot not No No
Livingston, TN 31OCT2017 Paul Landis Gorden 39 White male gun point not No No
McMinnville, TN 15DEC2017 Clifford Keller 34 White male gun shoot not No No
Monteagle, TN 05JAN2017 Randy Wayne Cole 41 White male gun shoot not Yes No
Mt. Pleasant, TN 07FEB2017 Bradley Nelson 35 White male gun point car Yes No
Nashville, TN 10FEB2017 Jocques Scott Clemmons 31 Black male gun threat foot No No
Nashville, TN 28JUN2017 Rodney L. Cole 37 Black male knife attack not No No
Oneida, TN 27MAY2017 Ron Harlan Lewallen 30 White male   threat car No No
Reagan, TN 10JAN2017 Darrion Barnhill 23 Black male unarmed attack not No No
Soddy-Daisy, TN 17JAN2017 Christopher Dalton Sexton 29 White male gun point car Yes No
Somerville, TN 14JUN2017 Michael Morris 54 White male knife threat not Yes No
Weakley County, TN 26DEC2017 Salvador Byassee 34   male knife threat other No 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 10JUN2017 Emmett Edward Hall 60 White male knife threat not Yes No
Allen, TX 01JAN2017 Mark Guirguis 21 Black male   attack car No No
Amarillo, TX 27JUN2017 Jason Magana Herrera 35 Hispanic male gun point foot No No
Amarillo, TX 08SEP2017 Billy Joe Elmore 45 White male gun point not No No
Arlington, TX 01FEB2017 Tavis Michael Marrell Crane 23 Black male vehicle attack car No No
Arlington, TX 11MAY2017 Gabriel Ramirez 26 Hispanic male gun shoot not No No
Arlington, TX 15JUL2017 Keith Allynn Wade 23 White male gun point foot No No
Arlington, TX 31OCT2017 Vincent Jewan Hall 22 Black male gun shoot not No No
Austin, TX 14JAN2017 Scott Laurance Gilpin 47 White male gun shoot foot No No
Austin, TX 22FEB2017 Morgan London Rankins 30 Black female knife threat car Yes No
Austin, TX 02MAY2017 Jason Sebastian Roque 20 Hispanic male gun threat not Yes No
Austin, TX 07MAY2017 Landon Nobles 24 Black male gun shoot foot No No
Balch Springs, TX 29APR2017 Jordan Javon Edwards 15 Black male unarmed undetermined not No Yes
Bandera, TX 16MAR2017 Michael William Sanders 47 White male knife point not No No
Brownsville, TX 05OCT2017 German Ornelas 31 Hispanic male knife attack not No No
Cedar Lake, TX 16NOV2017 Chester Randolph Ward 68 Black male gun shoot not No No
Channelview, TX 11AUG2017 Nicholas Andrew Solis 24 Hispanic male gun shoot not No No
Cisco, TX 24MAR2017 Matthew Gambaro 26 Hispanic male gun threat foot No No
Conroe, TX 22FEB2017 Medger Blake 41 Black male knife attack not No No
Conroe, TX 01MAY2017 Joseph William Alain 25 White male gun point not No No
Corpus Christi, TX 19OCT2017 Dewboy Lister 55 Black male unarmed attack foot No Yes
Crowell, TX 30DEC2017 Heath Wayne Hodges 36 White male undetermined undetermined   No No
Dallas, TX 18JAN2017 Genevive Dawes 21 White female unarmed move car No Yes
Dallas, TX 19JUN2017 Alton Folmar 28 White male gun threat not No No
El Paso, TX 03NOV2017 Jorge Hidalgo 43 Hispanic male knife threat   No No
Farmers Branch, TX 26DEC2017 Brooke Amelia Camacho 38 Hispanic female gun shoot not No No
Fort Stockton, TX 28JAN2017 Gerardo Coronado Jr. 25 Hispanic male gun point car No No
Fort Worth, TX 25APR2017 Fred Cardenas 53 Hispanic male gun point   Yes Yes
Fritch, TX 19JAN2017 Christopher Garza 44 Hispanic male gun shoot foot No No
Gilmer, TX 03JAN2017 Dale Hightower Jr. 53 White male gun point not Yes Yes
Gonzales County, TX 05JUN2017 Adrian Maurice Hardeman 37 Black male gun threat   No No
Grand Prarie, TX 17FEB2017 Joshua Henry 30 White male unarmed attack not Yes Yes
Houston, TX 01JAN2017 Juan Carlos Cuadra 23 Hispanic male gun point foot No No
Houston, TX 28FEB2017 Earl Riley 25 Black male gun shoot not No No
Houston, TX 04APR2017 Michael Maldonado 32 Hispanic male   attack car No No
Houston, TX 10APR2017 Jarrad Lamark Hill 39 Black male gun threat foot No Yes
Houston, TX 24APR2017 Kendell Wilson 16 Black male gun threat foot No Yes
Houston, TX 20OCT2017 Jorge Cabrera 54 Hispanic male knife threat not No No
Houston, TX 24OCT2017 David Campos 34 Hispanic male knife threat not No No
Irving, TX 03FEB2017 Daniel Loren Rucker 45 White male gun threat not No No
Irving, TX 02MAY2017 Rodney Henderson 48 Black male knife attack not No No
Katy, TX 04MAY2017 Lucille Espinosa 54 Hispanic female gun threat not Yes No
Killeen, TX 24APR2017 Daezion Turner 15 Black male gun shoot not No No
Kingwood, TX 16OCT2017 Joshua Clayton Johnson 31 White male gun attack car No No
La Marque, TX 03DEC2017 Gregory Ray Ham 62 White male knife attack not No No
La Porte, TX 19SEP2017 Patrick Warren Ford 55 White male gun point not Yes No
Lake Jackson, TX 24FEB2017 Jacqueline Cheyanne Johnson 33 White female gun shoot car No No
Laredo, TX 02JUN2017 Antonio Gerardo Rodriguez 55 Hispanic male gun shoot not No No
Little Elm, TX 17JAN2017 Rudy Garcia 46 Hispanic male gun shoot not Yes No
Lufkin, TX 01MAR2017 Epthen Lamont Johnson 40 Black male knife attack not No Yes
Midlothian, TX 11MAR2017 Mark Robert Carlberg 51 White male gun point not No No
Mission, TX 21JUL2017 Vicente Velasquez 42 Hispanic male gun shoot foot No No
Panhandle, TX 03FEB2017 Yia Lee 41 Asian male gun shoot not No No
Plano, TX 12JUN2017 Eleuterio Amaya-Torres 63 Hispanic male gun shoot not No No
Plano, TX 10SEP2017 Spencer Hight 32 White male gun point not No No
Progreso, TX 24DEC2017 Evilio Gomez 46 Hispanic male knife threat not No No
Rockwall, TX 21SEP2017 Jose Felix Reyes 38 Hispanic male   attack car No No
San Antonio, TX 16FEB2017 Joseph Tamayo 48 Hispanic male gun point not No No
San Antonio, TX 20APR2017 Ray Valdez 55 Hispanic male knife threat   No No
San Antonio, TX 17JUL2017 Jose Cazares 37 Hispanic male gun point not No No
San Antonio, TX 26JUL2017 Giovani Casiano 26 White male gun shoot not No No
Schertz, TX 21DEC2017 Kameron Christopher Prescott 6 White male unarmed accident not No No
Schertz, TX 21DEC2017 Amanda Lenee Jones 30 White female blunt_object threat foot No Yes
Spring, TX 05SEP2017 Claudia Abigail Garcia-Miranda 17 Hispanic female vehicle attack car No No
Terrell, TX 12FEB2017 Robert Randell Schneider Jr. 40 White male vehicle move other No No
The Colony, TX 19DEC2017 Shaquille Rashad Rogers 24 Black male knife threat not No No
Waco, TX 01AUG2017 Kerry Bradley 37 Black male   attack car No No
Watagua, TX 29AUG2017 Brandy Caldwell 46 White female gun threat not Yes No
Whitewright, TX 29MAR2017 Dennis Wasson II 27 White male   threat car No No
Wichita Falls, TX 02FEB2017 Miguel Angel Silva 18 Hispanic male gun threat not No No
Wimberley, TX 24NOV2017 Rocky Miles West 26 White male gun shoot foot 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?
Aragonite, UT 26FEB2017 Barry Michael Zumwalt 36 White male gun threat not Yes No
Centerville, UT 04JUL2017 Cody Ray McCray 32 Hispanic male   threat car Yes No
Ogden, UT 21FEB2017 Bartolo Justice Sambrano 25 Hispanic male gun point not No Yes
Roy, UT 21FEB2017 Nicolas Sanchez 38 Hispanic male gun point not No Yes
Salt Lake City, UT 13AUG2017 Patrick Harmon 50 Black male knife flee foot No Yes
Salt Lake City, UT 28SEP2017 Michael Bruce Peterson 39 White male blunt_object threat not No No

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?
Abingdon, VA 08OCT2017 Roberto Avendano   Hispanic male knife threat foot No No
Alexandria, VA 14JUN2017 James T. Hodgkinson 66 White male gun shoot not No No
Arlington, VA 17MAY2017 Daniel George Boak 28 White male   attack car No No
Bassett, VA 05DEC2017 Johnnie D. Carter 24 Black male gun shoot not No No
Charlottesville, VA 13OCT2017 J.C. Hawkins Jr. 42 Black male gun point foot No No
Chester, VA 27DEC2017 Kenneth J. Perna-Rutsky 38 White male gun shoot not Yes No
Culpeper, VA 17JUL2017 Eric Wesley Clark 43 White male gun point car No No
Fairfax, VA 17NOV2017 Bijan C. Ghaisar 25 White male unarmed undetermined car No No
Hampton, VA 17OCT2017 DeAndre Bethea 24 Black male   threat not No No
Haymarket, VA 15SEP2017 Ruben Urbina 15 Hispanic male blunt_object move not No No
Herndon, VA 16JAN2017 Mohammad Azim Doudzai 32 Asian male gun;knife shoot not No No
Independence, VA 19SEP2017 Jimme Knight Smith 55 White male gun point not Yes No
Lexington, VA 15DEC2017 Robert Allen Morrison 57   male gun point foot No No
Lynchburg, VA 06NOV2017 Pamela Webber 54 White female knife threat not Yes No
Newport News, VA 29APR2017 Caleb Jackson 35 Black male gun point not No No
Norfolk, VA 02JUL2017 Tyson Chad Williams 39 White male gun shoot not Yes No
Norfolk, VA 17JUL2017 India N. Nelson 25 Black female gun shoot not No No
Pearisburg, VA 12JAN2017 Rodney L. Hoback Jr. 26 White male knife attack not Yes No
Pulaski, VA 14MAY2017 James A. Burton 48 White male gun shoot not Yes No
Richmond, VA 15MAY2017 Jaison Fitzgerald 29 Black male gun threat not No No
Richmond, VA 25JUL2017 Alexander J. Schoessel 23 White male blunt_object threat foot Yes No
Roanoke, VA 08NOV2017 Victor Demetrius Bray 31 White male gun threat not No No
Woodford, VA 19JAN2017 William D. Fisher 49 White male gun threat not Yes No

statecode=VT

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=VT

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Poultney, VT 01SEP2017 Michael Battles 32 White male replica point not Yes No

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?
Auburn, WA 10JUN2017 Isaiah Obet 25 Black male knife threat car No No
Bainbridge Island, WA 09JUL2017 Robert Yeiser 34 White male gun shoot not No No
Bellingham, WA 12MAR2017 Manuel Gonzalez 28 Hispanic male knife attack foot No Yes
Bremerton, WA 17DEC2017 Willy Floyd McCord 52   male gun shoot not No No
Burien, WA 14JUN2017 Tommy Le 20 Asian male other attack not No No
Des Moines, WA 28JAN2017 Mi'Chance Dunlap-Gittens 17 Black male gun point not No No
Des Moines, WA 23MAR2017 William Stokes 51 Black male knife threat not Yes No
Federal Way, WA 30OCT2017 Robert James Lightfeather 33 Native American male gun point not No No
Fife, WA 14MAR2017 Ryan L. Rosa 36 White male   attack not No No
Frederickson, WA 12AUG2017 Eduardo Navarrete 35 Hispanic male knife attack not No No
Hillyard, WA 28NOV2017 James C. Danforth 59 White male gun shoot foot No No
Kennewick, WA 13AUG2017 Hussein Hassan 46 Black male knife attack not Yes No
Kent, WA 24JUN2017 Giovonn Joseph-McDade 20 Black male   threat car No No
Kent, WA 09AUG2017 Eugene Nelson 20 Black male   attack car No No
Kirkland, WA 19DEC2017     male gun threat not No No
Lacey, WA 08JUL2017 Michael Anthony Rude 22 Asian male knife threat not Yes No
Lake Stevens, WA 09FEB2017 Juan Salinas 33 Hispanic male knife threat not Yes No
Longview, WA 03SEP2017 Henry Stephen Rakoz Jr. 47 White male gun threat not No No
Lynnwood, WA 30JAN2017 Jeremy Dowell 36 White male knife threat not Yes No
Oak Harbor, WA 17SEP2017 Nicholas K. Perkins 37 White male gun shoot not Yes No
Richland, WA 04JUL2017 Douglas West 46 White male gun threat not No No
Rochester, WA 10OCT2017 Daniel James 55   male gun point   Yes No
Seattle, WA 20APR2017 Damarius Butts 19 Black male gun shoot   No No
Seattle, WA 18JUN2017 Charleena Lyles 30 Black female knife threat not Yes No
Seattle, WA 11DEC2017 24 White male gun shoot car No Yes
Spanaway, WA 14APR2017 Charles Shands 33 White male gun threat car Yes No
Spokane, WA 15JAN2017 Dexter Martin Dumarce 33 White male knife threat foot No Yes
Spokane, WA 03JUL2017 Daniel Craven 53 White male gun threat not No Yes
Spokane, WA 04OCT2017 Chad Cochell 34 White male   move not Yes No
Spokane, WA 26DEC2017 Joshua Paul Spottedhorse 36 Native American male gun shoot foot No Yes
Tacoma, WA 10SEP2017 Frankie Santos 58 Hispanic male gun shoot not No No
Tacoma, WA 21SEP2017 Matthew Wells 40 White male knife threat not Yes No
Vancouver, WA 10FEB2017 Justin Burton 25 White male knife threat foot No No
Vancouver, WA 06JUN2017 David W. Hamilton 50   male gun shoot car No No
Wenatchee, WA 27JUL2017 Matthew Folden 31 White male knife threat not No No
Yakima, WA 27NOV2017 Christopher J.H. Escobedo 26   male gun shoot car No No
Yakima, WA 25DEC2017 Adrian Escobar 28   male gun shoot not No No
Yakima, WA 26DEC2017 Jose Garcia 31   male undetermined undetermined not Yes 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 21MAY2017 Jimmie Montel Sanders 33 Black male gun shoot not No No
Black River Falls, WI 28OCT2017 Lucas DeFord 27 Native American male gun move car No Yes
Corning, WI 27FEB2017 Shawn M. Igers 40 White male gun shoot not No No
Crandon, WI 22OCT2017 Dexter David Anthony Baxter 30 Native American male unarmed attack not No No
Eau Claire, WI 28JAN2017 Matthew Zank 48 White male replica point not Yes No
Eau Claire, WI 08APR2017 Gregory Kever 25 White male knife threat not No No
Eau Claire, WI 23JUL2017 Michael Caponigro 59 White male gun shoot not Yes No
Franklin, WI 21AUG2017 Tyler Whitmire 22 White male knife threat other Yes No
Geneva, WI 02FEB2017 Kris Kristl 26 White male replica threat not No No
La Crosse, WI 13AUG2017 Roger Burzinski 54 White male gun threat car No No
Millston, WI 25JAN2017 Donovan Paul Scheurich Sr. 50 White male gun shoot not Yes Yes
Milwaukee, WI 16MAR2017 Jermaine Claybrooks 32 Black male gun threat not No Yes
Milwaukee, WI 11JUN2017 Terry Williams 19 Black male   threat car No No
Milwaukee, WI 11JUL2017 Randy Engstrom 34 White male gun threat car Yes No
Milwaukee, WI 03SEP2017 Antwon Springer 37 Black male gun shoot not No No
Mount Hope, WI 01SEP2017 Roger Helgerson Jr. 45 White male unknown threat foot No No
Odanah, WI 08NOV2017 Jason Ike Pero 14 Native American male knife threat not No No
Oshkosh, WI 31JUL2017 Isaiah Tucker 28 Black male unarmed attack car No Yes
Pardeeville, WI 21AUG2017 Thomas Selje 64 White male gun shoot not No No
Peshtigo, WI 07DEC2017 Jesse Cole Shuping 35 White male gun point car No No
Rib Mountain, WI 02MAR2017 John Hall 33 White male gun attack not Yes No
Waukesha, WI 18JUN2017 William Webster 64 White male gun threat not Yes No
West Allis, WI 13MAY2017 Maxwell Holt 37 White male gun shoot foot No No
Weston, WI 22MAR2017 Nengmy Vang 45 Asian 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?
Brandywine, WV 18APR2017 Casey Desper 32 White male   attack car No No
Charleston, WV 07OCT2017 Samuel David Lanham 25 White male gun shoot car Yes No
Charleston, WV 17NOV2017 Seth Hardwick 30 White male gun shoot not No No
Frametown, WV 14SEP2017 Gary Joe McCourt Jr. 50 White male knife attack not No No
Gerrardstown, WV 29MAY2017 Larry Warren Kipps 62   male gun shoot not Yes No
Grafton, WV 03FEB2017 Daniel McMasters 38 White male gun point not No No
Mannington, WV 02AUG2017 Phillip Rhoades 28 White male   move car No No
Princeton, WV 07JAN2017 Daniel Scott Giberson 25 White male knife threat car No No
Princeton, WV 22FEB2017 Kyle Copson 26 White male knife threat not Yes No
Valley Head, WV 17DEC2017 Spencer Crumbley 52   male blunt_object attack not No No
West Milford, WV 17SEP2017 Brian Ziro 21 Black male gun shoot foot 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?
Cheyenne, WY 06DEC2017 Scott Addison 49 White male gun shoot not No No