Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2018

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 24MAR2018 Zander M. Clark 20 Native American male knife move foot No No
Copper Center, AK 06JUL2018 Eric Hash 38 Asian male other move   No Yes
Nikolaevsk, AK 24MAR2018 Nikolai Yakunin 42 White male unarmed attack not No No
North Pole, AK 29JUN2018 Garry Glenn Lawrence Jr. 36 White male blunt_object threat   No No
Palmer, AK 22NOV2018 Cameron McCarthy 20 White male knife threat foot No No
Pilot Station, AK 08MAR2018 Dwight Heckman 27 Native American male gun shoot foot No No
Wasilla, AK 16AUG2018 Adrian Herron 30 Black male knife attack not No No

statecode=AL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Barnwell, AL 05MAR2018 Robert Lewis Yates 65 White male gun shoot not No No
Birmingham, AL 06JAN2018 Jackie Harlan Roberts 62 White male gun point not No No
Citronelle, AL 08SEP2018 Elman Jerald Roberts 63 White male gun shoot not No No
Demopolis, AL 15NOV2018 Steven Smith Jr. 60 White male gun shoot not No No
Haynesville, AL 14NOV2018 George Crenshaw 55   male knife attack not No No
Hoover, AL 22NOV2018 Emantic Fitzgerald Bradford Jr. 21 Black male gun threat not No No
Huntsville, AL 03APR2018 Jeffrey Louis Parker 49 White male gun threat not Yes Yes
Mobile, AL 14FEB2018 Donald Fulton 41 White male gun shoot not Yes No
Montgomery, AL 21FEB2018 Lonnie Smith 21 Black male gun shoot foot No No
Montgomery, AL 27MAR2018 Holly Knighton 33 White female vehicle attack car No No
Morris, AL 05SEP2018 Mitchell Owen Buel 33 White male undetermined threat car No No
Sylacauga, AL 28MAR2018 Gerald Richard Johns 64 White male   attack car No No
Talladega, AL 21NOV2018 Eugene Benjamin Weathers 48 Black male gun shoot not 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?
Fort Smith, AR 12OCT2018 Samuel Morris 27 Black male knife threat not No No
Hackett, AR 07MAY2018 Peter Boden 48 White male gun shoot not No No
Helena-West Helena, AR 12APR2018 Rumondale Jones 39 Black male knife attack not No No
Jacksonville, AR 15SEP2018 Stephen Dove 50 White male knife attack not No Yes
Little Rock, AR 06JAN2018 Charles Smith Jr. 17 Black male gun shoot not No No
Lone Rock, AR 19MAR2018 Michael Lavelle Holliman 50 White male other threat not No No
Magnolia, AR 20NOV2018 Roderick McDaniel 33 Black male vehicle attack not No No
Mississippi County, AR 31JUL2018 James Edward Blackmon 35 Black male gun shoot foot No No
Ozark, AR 02JAN2018 Ronald Elliot 49 White male gun point not Yes No
Pine Bluff, AR 03AUG2018 Danny Lee 34 Black male gun point not No No
Pope County, AR 11DEC2018 Haze Connor Martin 22 White male knife threat car No No
Rector, AR 26DEC2018 Gary Warbritton 21 White male gun point not No No
Romance, AR 01JAN2018 Archie Lawhon III 42 White male gun point not No No
Russellville, AR 29JUN2018 Joshua Cartwright 36 White male gun shoot not No No
Searcy County, AR 06APR2018 Daniel Allen Yielding 23 White male knife attack foot No No
Springdale, AR 26JUL2018 Iman Joseph Buford 30 White male gun point not No No
Springdale, AR 09DEC2018 Terry Don King 50 White male gun point not No No
Trumann, AR 03AUG2018 Johnny Kelley 49 White male gun shoot not Yes No
Van Buren, AR 05AUG2018 Johnny Fisher 68 White male gun shoot not No No
West Memphis, AR 21MAY2018 Ronald Clinton 47 Black male   attack car No No

statecode=AZ

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AZ

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Buckeye, AZ 25DEC2018 Antonio A. Ramos 34 Hispanic male gun shoot not No No
Casa Grande, AZ 15MAR2018 Cameron Hall 27 Black male unarmed attack not No No
Chandler, AZ 12OCT2018 Kay Kenniker 84 White male gun shoot not Yes No
Chinle, AZ 05OCT2018 Venson Kee Yazzie 43 Native American male knife threat not No No
Douglas, AZ 23MAR2018 Robert Vega 48 Hispanic male other threat not No No
Flagstaff, AZ 09FEB2018 John Hamilton 78 White male gun threat not No Yes
Gilbert, AZ 26FEB2018 Joshua Kinnard 37 White male gun point   No No
Glendale, AZ 02MAR2018 Stephen Hudak 44 White male gun shoot foot No No
Glendale, AZ 31JUL2018 Skyler Martin 23 Hispanic male gun shoot not No No
Grand Canyon Caverns, AZ 25APR2018 James D. Warren 89   male gun point not Yes No
Kingman, AZ 10FEB2018 Michael Weber 63 White male gun point not No Yes
Lake Havasu, AZ 25JUL2018 Brent C. Bowdon 56 White male unarmed move not Yes Yes
Mesa, AZ 15FEB2018 Arthur Joseph Gonzales 57 Hispanic male gun point not No No
Mesa, AZ 02MAR2018 Christopher Race 36 White male knife threat not No No
Mesa, AZ 04APR2018 Kelvin Baldwin 30 White male gun shoot foot No No
Mesa, AZ 16JUN2018 Michael D. Fletcher 53 White male replica point not No No
Mesa, AZ 21JUL2018 Anthony C. Lopez 21 Hispanic male vehicle attack not No No
Mesa, AZ 14SEP2018 David Huffines Jr. 40 White male gun point not Yes No
Mesa, AZ 16DEC2018 Edward Rudhman 50 White male gun point not Yes No
Peoria, AZ 24SEP2018 Michael Stout 20 White male gun shoot not No No
Phoenix, AZ 17JAN2018 Jordan Keckhut 22 Hispanic male knife threat not No No
Phoenix, AZ 22FEB2018 Jacob Uptain 27 White male gun threat foot No No
Phoenix, AZ 09MAR2018 David Gardea 27 Hispanic male gun shoot foot No No
Phoenix, AZ 23MAR2018 Kevin Robles 23 White male knife attack not No No
Phoenix, AZ 27MAR2018 Jose Aaron Gonzalez 44 Hispanic male gun point not No No
Phoenix, AZ 01APR2018 John Wussler 58 White male gun threat foot No No
Phoenix, AZ 04APR2018 Alexis Stinson 44 White female gun shoot not No No
Phoenix, AZ 14APR2018 Andre Lavance Rippy 39 Black male gun point other No No
Phoenix, AZ 14APR2018 Eduardo Andrade 44 Hispanic male gun shoot not No No
Phoenix, AZ 29MAY2018 Rabi Brown 34 Native American male gun threat not No No
Phoenix, AZ 12JUN2018 Alexandre J. Aldrich 34 White male unarmed threat not No No
Phoenix, AZ 16JUN2018 Ronald Barney 48 White male gun point car No No
Phoenix, AZ 29JUN2018 Chukwumankpam Mbegbu 19 Black male gun shoot not No No
Phoenix, AZ 18AUG2018 Andres Arteaga 28 Hispanic male gun move foot No No
Phoenix, AZ 27AUG2018 Fabian Ortiz Adame 25 White male gun;vehicle attack car No No
Phoenix, AZ 27AUG2018 Bryce Schenkenberg 20 White male gun shoot not No No
Phoenix, AZ 29OCT2018 Arnaldo Caraveo 27 Hispanic male gun shoot car No No
Phoenix, AZ 13NOV2018 Timothy Leon 24 Black male unknown attack car No No
Phoenix, AZ 20NOV2018 Craig Allen 71 White male gun point not No No
Phoenix, AZ 29NOV2018 Miguel Angel Duran Delgado 46 Hispanic male gun point not No No
Phoenix, AZ 17DEC2018 Jose Manuel Cardenas Jr. 34 Hispanic male gun shoot not No No
Phoenix, AZ 19DEC2018 Angel Ocampo-Soto 50 Hispanic male undetermined attack not No No
Phoenix, AZ 28DEC2018 Edwin C. Bundy 46 White male gun move not No No
Pima County, AZ 03MAR2018 Amanda Alvarez 38 Hispanic female blunt_object threat not No No
Quartzsite, AZ 02MAY2018 Omar Cason 31 Black male gun shoot other No No
Salt River Reservation, AZ 07AUG2018 Pedro Lucero 42 Hispanic male gun threat other No No
Scottsdale, AZ 02MAR2018 Erik Dunham 48 White male gun threat not No No
Scottsdale, AZ 23MAR2018     male unknown threat not No No
Scottsdale, AZ 05MAY2018 Stephen Charles Arthur 51 White male gun shoot foot No No
Sedona, AZ 07JAN2018 Tyler Miller 51 White male unarmed move not Yes No
Surprise, AZ 28MAR2018 George Pappas 61 White male knife threat not No No
Tempe, AZ 05JUL2018 Sylvia Marie Bejarano 33 Hispanic female gun shoot other No No
Tucson, AZ 01MAR2018 Joel Jacobo 29 Hispanic male unknown threat not No No
Tucson, AZ 10APR2018 Mark Powell Jr. 39   male gun threat not No No
Tucson, AZ 08MAY2018 Charles Hutchison 37   male knife threat foot No No
Tucson, AZ 08JUL2018 Craig Yelton 34 White male gun threat not No No
Tucson, AZ 17JUL2018 Juan Manuel Correa-Leyva 27 Hispanic male gun shoot car No No
Tucson, AZ 21JUL2018 Vincent James Ewer II 39 White male vehicle;gun attack foot No No
Tucson, AZ 01AUG2018 David Judge 53 White male gun threat not No No
Tucson, AZ 10SEP2018 Joel R. Andrade 53   male gun;knife threat not Yes No
Yuma, AZ 07MAY2018 Lisa Rivera 49 Hispanic female gun 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?
Alpine, CA 12NOV2018 Danny Ayala   Hispanic male knife move not No Yes
Anaheim, CA 14APR2018 Petrica Peter Muntean 24 White male replica point not Yes Yes
Anaheim, CA 21JUL2018 Eliuth Penaloza Nava 50 Hispanic male replica threat foot Yes No
Antioch, CA 08FEB2018 Lloyd Harris Jr. 40 White male replica move not No No
Atwater, CA 30MAR2018 Timothy Breckenridge 42 White male replica threat not No No
Auburn, CA 07OCT2018 Nicholas Salisbury 36 White male replica point not Yes No
Azusa, CA 21DEC2018 Jose Lemus 57 Hispanic male gun attack not No No
Bakersfield, CA 19AUG2018 Christopher Alexander Okamoto 21 Black male replica threat not No No
Bakersfield, CA 24AUG2018 Felipe Perez Casas 41 Hispanic male knife threat   No No
Baldwin Hills, CA 10APR2018 Grechario Mack 30 Black male knife threat foot Yes No
Barstow, CA 05APR2018 Diante Yarber 26 Black male vehicle attack not No No
Bell Gardens, CA 21NOV2018 Martin Lopez 24 Hispanic male knife attack not No No
Calaveras County, CA 05JUL2018 John James Corrigan 38 White male replica point not Yes No
Cathedral City, CA 08APR2018 Carlos Roman Urias 24 Hispanic male replica point not No No
Ceres, CA 18AUG2018 Carmen Spencer Mendez 15 Hispanic male gun threat other No Yes
Charleston View, CA 08NOV2018 Jesus "Chuy" Guzman 34 Hispanic male gun point foot No No
Corona, CA 07NOV2018 Delson Silva 68   male gun point not No No
Crescent City, CA 22JAN2018 Scott Senior 38   male unknown attack   No No
Danville, CA 03NOV2018 Laudemer Arboleda 33 Black male vehicle move not Yes Yes
East Los Angeles, CA 24SEP2018 Ivan Pena 42 Hispanic male gun shoot not No No
El Sereno, CA 14JAN2018 Christian Escobedo 22 Hispanic male gun threat not No No
Elk Grove, CA 28APR2018 Nolberto Hernandez Leon 26 Hispanic male gun point not No No
Fontana, CA 10MAR2018 Orion Godbout 45 Hispanic male gun shoot not No No
Foresthill, CA 20APR2018 Lockwood Adrian Gibson 49 White male vehicle flee car Yes No
Fremont, CA 05APR2018 Nathaniel Prasad 18 Asian male gun shoot foot No No
Fresno, CA 20JUL2018 Ruben Maya 37 Hispanic male replica shoot not No No
Fresno, CA 14AUG2018   Hispanic male gun;knife point not Yes Yes
Fresno, CA 12NOV2018 Marty West 63 White male knife attack not Yes Yes
Fullerton, CA 31MAY2018 Katherine Brazeau 46 White female knife threat not Yes No
Gardena, CA 11APR2018 Kenneth Ross Jr. 25 Black male gun shoot not No No
Hanford, CA 15DEC2018 Edgar Espinoza 35 Hispanic male knife attack not No No
Hayward, CA 15NOV2018 Agustin Gonsalez 29 Hispanic male knife threat not Yes No
Hemet, CA 11NOV2018   Hispanic male gun shoot foot No No
Hesperia, CA 05AUG2018 Kevin Rhinehart 58   male gun threat not No No
Highland, CA 22JUL2018 Juan Ramon Ramos 32 Hispanic male knife attack foot No No
Hollywood, CA 29OCT2018 Albert Ramon Dorsey 30 Black male other move not No Yes
Huntington Beach, CA 11OCT2018     male gun threat car No No
Inglewood, CA 22JUN2018 Javier Desantiago 31 Hispanic male replica point not Yes No
Joshua Tree, CA 21MAY2018 Ray Wyatt 58 White male gun shoot foot Yes No
Jurupa Valley, CA 08MAR2018 32 Hispanic male undetermined undetermined   No No
Jurupa Valley, CA 03JUN2018 Rudy Molina 34 Hispanic male gun point car No No
Laguna Woods, CA 06FEB2018 Paul L. Mono 65   male gun point not No No
Lake Elsinore, CA 20DEC2018     male gun point car No No
Long Beach, CA 05JAN2018 Andy Vo 35 Asian male gun threat not No No
Long Beach, CA 07MAR2018 Donald McFarlane 53 White male gun point not No No
Los Angeles, CA 08JAN2018 Primitivo Macias-Rodriguez 46 Hispanic male gun threat   No No
Los Angeles, CA 04FEB2018 Anthony Jacob Weber 16 Black male gun move foot No No
Los Angeles, CA 06FEB2018 Cesar Bautista 37 Hispanic male   threat car No No
Los Angeles, CA 25FEB2018 Santos Nunez-Garcia 30 Hispanic male gun shoot not No No
Los Angeles, CA 26FEB2018 Orbel Nazarians 22 White male knife threat not Yes Yes
Los Angeles, CA 30MAY2018 Bryan Rodriguez 29 Hispanic male blunt_object attack foot No Yes
Los Angeles, CA 21JUL2018 Melyda Marciela Corado 27 Hispanic female unarmed accident foot No Yes
Los Angeles, CA 27JUL2018 Richard Mendoza 32 Hispanic male gun shoot not No Yes
Los Angeles, CA 07AUG2018 Daniel Valdez 70 Hispanic male gun threat   No No
Los Angeles, CA 12AUG2018 Anthony Daniel Vargas 21 Hispanic male gun attack foot No No
Los Angeles, CA 18AUG2018 Michael Harrison 30 White male knife move not No No
Los Angeles, CA 19SEP2018 Rene Herrera 39 Hispanic male gun shoot car No No
Los Angeles, CA 19SEP2018 Fernando Cruz 18 Hispanic male unarmed flee car No No
Los Angeles, CA 18NOV2018 Dereck Wilson 32 Black male gun shoot not No Yes
Los Banos, CA 11JUL2018 Salome Ramirez 34 Hispanic male replica threat not No No
Martinez, CA 05DEC2018 Paul Ridgeway 41 White male gun shoot foot No No
Marysville, CA 06APR2018 Jonathan Erick Alexander 26 Black male gun shoot car No No
Mecca, CA 03JUN2018     male blunt_object threat not No No
Napa, CA 05DEC2018 David Alejandro Molina 27 Hispanic male gun attack foot Yes No
Natomas, CA 17DEC2018   White male gun threat not No No
Nice, CA 05FEB2018 Jason Richard Sienze 35 White male gun threat not No No
Oakland, CA 03JAN2018 Shaleem Tindle 28 Black male gun shoot not No No
Oakland, CA 11MAR2018 Joshua Pawlik 32 White male gun point not Yes No
Orosi, CA 03MAY2018 Anthony Trujillo 26 Hispanic male knife attack not Yes No
Oroville, CA 07APR2018 Larry Siordia 33 White male gun shoot not No No
Palermo, CA 26APR2018 Myra Lisa Micalizio 56 White female vehicle attack car No Yes
Palmdale, CA 10JAN2018 Shalun Dique Smith 21 Black male vehicle threat car No No
Paradise, CA 15NOV2018 GD Hendrix 48 White male blunt_object move car Yes No
Pasadena, CA 30AUG2018 Vanessa Marquez 49 Hispanic female replica threat not Yes Yes
Pico Rivera, CA 19JUL2018 Carmen Pizarro 22 Hispanic male gun threat other No No
Pittsburg, CA 12JAN2018 Terry Amons 43 Black male gun move not No No
Pittsburg, CA 23OCT2018 Salvador Morales 37 Hispanic male gun shoot car No Yes
Pomona, CA 29JUN2018 Rodney Lee Hunter 27 Black male unknown undetermined car No No
Red Bluff, CA 04JUL2018 Abraham Noe Flores 34 Hispanic male gun point not Yes No
Redding, CA 27AUG2018 Eric Jay Hames 34 White male knife threat not Yes No
Redding, CA 06DEC2018 Benjamin David Larson 42 White male gun shoot car No No
Redlands, CA 29APR2018 42 White male unknown threat not No No
Redlands, CA 28AUG2018 Tyler Hodge 18 White male gun shoot not Yes No
Redondo Beach, CA 26JUL2018 Sergio Acosta 24 Hispanic male replica undetermined not No No
Redwood City, CA 10DEC2018 Kyle Hart 33 White male knife threat not Yes No
Reseda, CA 09APR2018 Daniel Joseph Carver 29 White male gun flee foot No Yes
Riverbank, CA 29MAY2018 Armando Osuna 51 Hispanic male blunt_object attack not No No
Riverside, CA 20JUL2018 Arthur Levario Jr. 45 Hispanic male gun shoot car No No
Riverside, CA 22JUL2018 Juan Garcia 38 Hispanic male unknown threat not No No
Sacramento, CA 18MAR2018 Stephon Clark 23 Black male unarmed move foot No Yes
Sacramento, CA 06SEP2018 Darell Richards 19 Black male replica point foot No No
San Diego, CA 27MAY2018 Raul Rivera 42 Hispanic male knife threat not Yes Yes
San Diego, CA 23JUN2018 Joe Darwish 28 White male gun shoot not No No
San Diego, CA 08AUG2018 Vaughn Denham 48 Black male other attack not No No
San Francisco, CA 06MAR2018 Jesus Delgado-Duarte 19 Hispanic male gun shoot not No No
San Francisco, CA 21MAR2018 Jehad Eid 21 Asian male gun shoot not No No
San Jose, CA 09JAN2018 Thompson Nguyen 27 Asian male blunt_object threat not Yes Yes
San Jose, CA 25DEC2018 Jennifer Vasquez 24 Hispanic female vehicle attack car No No
Santa Ana, CA 02MAR2018 Erick Eduardo Mora Martinez 31 Hispanic male vehicle attack not No No
Santa Ana, CA 01JUL2018     male blunt_object undetermined not No No
Santa Maria, CA 07JAN2018 Alejandro Valdez 27 Hispanic male knife threat not Yes No
South El Monte, CA 18MAR2018 Manuel Borrego 40 Hispanic male knife threat foot No No
South Lake Tahoe, CA 29OCT2018 Billy Jo Johnson 34 White male gun shoot car No No
Thousand Oaks, CA 10OCT2018 Michael Johnson 26 White male knife move not Yes Yes
Torrance, CA 01JUN2018   White male knife threat not No No
Torrance, CA 09DEC2018 Christopher Deandre Mitchell 23 Black male replica threat not No Yes
Tulare, CA 12MAR2018 Jontell Reedom 27 Black male blunt_object attack foot Yes No
Vallejo, CA 13FEB2018 Ronnell Foster 33 Black male unarmed attack foot No No
Valley View, CA 17MAR2018 Osbaldo Jimenez Ramirez 50 Hispanic male gun move car No No
Van Nuys, CA 16JUN2018 Guillermo Perez 32 Hispanic male knife attack not Yes No
Van Nuys, CA 31DEC2018 Rony Josue Parras-Mendez 18 Hispanic male knife threat not No Yes
Victorville, CA 02OCT2018 LaJuana Philips 36 Black female vehicle attack not No No
Westminster, CA 08JUL2018     male gun threat other No No
Whittier, CA 11JUN2018 Nicolas Moncada 29 Hispanic male knife threat car No No
Willits, CA 13FEB2018 Dawn Elika Center 48 White female gun threat car No No
Woodville, CA 14OCT2018 Umberto Sanchez Ramoz 17 Hispanic male knife attack not Yes 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 16JAN2018 Bailey Turner 27 White male unarmed attack not No No
Adams County, CO 07JUL2018 Adrian Emmanuel Martinez 17 Hispanic male unknown point other No No
Adams County, CO 28JUL2018 Isaiah Nathaniel Leyva 19 Hispanic male vehicle attack car No No
Alamosa, CO 28FEB2018 Ernesto Michel 47 Hispanic male unknown threat not No No
Alamosa, CO 25AUG2018 Jennifer Sharp 37 White female gun shoot car No No
Arvada, CO 31JAN2018 Adrian Valdez 39 Hispanic male knife threat not No No
Aurora, CO 10FEB2018 Troy Jacques 41 White male gun threat not No No
Aurora, CO 27JUN2018 Joey Bronson 39 White male gun point foot No No
Aurora, CO 29JUN2018 Anthony Sanchez 36 Hispanic male gun point car No Yes
Aurora, CO 30JUL2018 Richard Gary Black Jr. 73 White male gun accident not No No
Centennial, CO 23JUN2018 Andrew Payne 38   male gun shoot car No No
Centennial, CO 15NOV2018 Allen Fanning 18 Black male gun move not No No
Centennial, CO 27NOV2018 Nicholas Charles Ryan 19 White male gun shoot car No Yes
Clear Creek Canyon, CO 04NOV2018 Ryan Millsap 19 White male vehicle attack car No No
Colorado Springs, CO 05FEB2018 Manuel Zetina 19 Hispanic male gun shoot not No No
Colorado Springs, CO 12MAR2018 Corky Lee Oliver 31 White male gun threat not No No
Colorado Springs, CO 25APR2018 Jese Paul Schlegel 41 White male gun point foot No No
Denver, CO 06FEB2018 Alex Duran 29 Hispanic male knife threat not No No
Denver, CO 13FEB2018 Peter Le 52 Asian male gun;knife threat not No No
Denver, CO 19MAR2018 Steven Nguyen 27 Asian male unarmed flee car No No
Denver, CO 25APR2018 Charles Boeh 36 White male gun threat car No No
Denver, CO 13JUN2018 Carnell Nelson 29 Black male gun shoot foot No No
Denver, CO 14JUN2018     female gun point not No No
Fort Morgan, CO 25MAY2018 Dustin Montano 31 White male knife threat not Yes No
Grand Junction, CO 27MAY2018 Eugene Baylis 67 White male gun shoot not No No
Greeley, CO 08MAY2018 Thomas Junior Garcia 45 Hispanic male knife threat foot No No
Gunnison County, CO 22NOV2018 Patrick Michael Langhoff 59 White male gun point not No No
Hanover, CO 22JUL2018 William Bacorn 18 White male gun shoot not No No
Lakewood, CO 28NOV2018 Joe Richard Shorty 39   male gun shoot foot No No
Larimer County, CO 08OCT2018 Travis N. Craven 25 White male gun move car No No
Longmont, CO 20SEP2018 Gillie Thurby 28 White male gun threat   No No
Longmont, CO 31DEC2018 Jesus Ramos 34 Hispanic male undetermined threat foot Yes No
Northglenn, CO 28APR2018 David Navarro 46 White male gun threat not No No
Pueblo, CO 22JAN2018 Joe Delira-Alires 35 Hispanic male gun shoot other No Yes
Pueblo, CO 06MAR2018 Steven Peters 55 White male gun point foot No No
Pueblo, CO 19MAY2018 Santiago Evans-Valencia 36 Hispanic male gun shoot not No No
Pueblo, CO 04JUL2018 Emmanuel Bitsuie 32 Native American male knife attack not No No
Rangley, CO 11DEC2018 Daniel Pierce 58 White male gun threat not Yes Yes
Sedalia, CO 31AUG2018 Paul Askins 61 White male gun point not No Yes
Thornton, CO 13APR2018 Bruce Arnold Allee 31 White male gun threat car No No
Trinidad, CO 12APR2018     male knife threat not No No
Westminister, CO 10JUN2018 Brandon Vieweg 34 White male unknown threat foot No No
Westminster, CO 02AUG2018 Michael Lee Gonzales 57 White male vehicle attack car No No
Westminster, CO 04SEP2018 Timmy Henley 27 White male knife attack not No No
Wheat Ridge, CO 14JAN2018     male undetermined undetermined other No No
Wheat Ridge, CO 18OCT2018 Bailey Greek 18 White male gun attack 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?
Danbury, CT 30DEC2018 Paul Arbitelle 45 White male knife threat not No No

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 12JUN2018 Marqueese Alston 22 Black male gun shoot not No No

statecode=FL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=FL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Amelia Island, FL 21MAR2018 Jason M. Raffaeli 25 White male gun shoot not Yes No
Apopka, FL 02AUG2018 Landon Christopher Wooten 18 White male replica shoot not No No
Beverly Hills, FL 30AUG2018 Jessica Cribbs 45 White female gun point not No No
Bradenton, FL 23JAN2018 Corey Mobley 38 Black male unarmed threat car Yes No
Casselberry, FL 28APR2018 Joseph L. Hoffman 41 White male gun shoot not No No
Citra, FL 24MAY2018 Dustin D. Odom 30 White male unarmed attack foot No Yes
Clearwater, FL 26DEC2018 Wayne Falana Jr. 35 Black male gun shoot not Yes No
Cocoa Beach, FL 16FEB2018 Tim Berger 59 White male gun threat   Yes No
Dade City, FL 29JUN2018 James Palmquist 54 White male gun shoot not Yes No
Delray Beach, FL 04AUG2018 John Randolph 38 White male gun threat not Yes No
Dundee, FL 01JUN2018 Andres Estrada 21 Hispanic male unarmed attack not No No
Edgewater, FL 01JAN2018 Gary Johns 65 White male gun shoot not Yes Yes
Eustis, FL 13JUN2018 Dillan Shane Ezell 21 White male replica point not Yes No
Eustis, FL 05JUL2018 Tracy A. Richards 55 White male gun threat not Yes No
Floral City, FL 31AUG2018 Dennis Ray Blalock 64 White male gun point not Yes No
Florida City, FL 30MAY2018 Juvan Simon 23 Black male gun undetermined not No No
Fort Lauderdale, FL 18APR2018 Dytadious Mobley 31 Black male gun shoot not No No
Fort Pierce, FL 17NOV2018 Rio Antwuan Thomas 27 Black male vehicle attack car No No
Fort Pierce, FL 07DEC2018 Jesus Lainez 51 Hispanic male unknown attack not No No
Grant-Valkaria, FL 08FEB2018 Ricardo Colon 35 Hispanic male knife threat not Yes No
Hernando, FL 17FEB2018 Ryan Batchelder 28 White male   threat not No No
Hollywood, FL 05SEP2018 James Leatherwood 23 Black male unarmed threat not No No
Homestead, FL 12FEB2018 Raymond Bishop 84 White male gun point not Yes No
Jacksonville, FL 07JUL2018 Harold Kraai 52 White male knife point not Yes No
Jacksonville, FL 31OCT2018 Tony Bernard Smith Jr. 24 Black male gun move foot No No
Jacksonville, FL 12DEC2018 Jason Emerson Connell 43 White male gun shoot not No No
Jacksonville, FL 12DEC2018 Dylan Parker Thomas 18 White male replica point not No No
Lady Lake, FL 20JUL2018 Anthony Coleman 38 White male gun point not No No
Lake Mary, FL 15MAY2018 David M. Romansky 34 White male gun threat car No No
Lake Wales, FL 20JAN2018 Shannon Jason Cables 46 White male gun shoot not No No
Lakeland, FL 05MAR2018 Ryan L. Smith 44 White male knife move foot Yes No
Lakeland, FL 26DEC2018 Michael Jerome Taylor 17 Black male vehicle attack car No No
Lantana, FL 07FEB2018 Hugo Steven Selva 22 White male   attack car No No
Largo, FL 23MAR2018 Linus F. Phillip 30 Black male   attack not No No
Lauderhill, FL 07JAN2018 Trayvon Mitchell 38 Black male gun threat foot No No
Lawtey, FL 07OCT2018 Anthony Lee Hodges 39 White male gun shoot not Yes No
Miami, FL 10JUL2018 Leonardo Cano 53 Hispanic male gun shoot car No No
Miami, FL 20SEP2018 Alexander Carballido 40 Hispanic male gun shoot car No No
Miami, FL 19OCT2018 Neico Crooks Jr. 21 Black male vehicle attack car No No
Midway, FL 27MAR2018 Isaac Michael Scroggie 24 White male unarmed attack other Yes Yes
Olustee, FL 16AUG2018 Charlie "Lee" Hodges 58 White male gun shoot not No No
Orlando, FL 28FEB2018 Qawi A. Muhammad 48 Black male gun shoot not No No
Orlando, FL 20APR2018 James Bauduy 48 Black male unarmed threat not No No
Orlando, FL 07MAY2018 Juan Alberto Silva 32 Hispanic male   attack car No No
Orlando, FL 25SEP2018 Dravious Burch 34 Black male gun move not No No
Orlando, FL 01OCT2018 Brian Baker 33 White male unarmed threat not Yes No
Palatka, FL 27SEP2018 Datwan Keyo Lewis 41 Black male gun threat not No No
Panama City, FL 11OCT2018 Dakota Frank Brooks 26 White male undetermined attack foot No No
Pensacola, FL 01DEC2018 John Young 65 Black male knife attack not No No
Port Charlotte, FL 05NOV2018 George Smith 72 White male gun point not Yes No
Port Orange, FL 31OCT2018 John Wurms 32 White male gun point not No Yes
Quincy, FL 21OCT2018     male undetermined undetermined car No No
Rockledge, FL 21JAN2018 Ronald Jay Lawson 46 White male   threat car No No
Saint Augustine, FL 06FEB2018 James Benny Hobbs 59 White male unarmed threat not No No
Saint Cloud, FL 06NOV2018 67   male gun point not Yes No
San Carlos Park, FL 06JAN2018 Guillermo Mendoza 57 Hispanic male gun point not No No
Seville, FL 03AUG2018 Emmanuel Alquisiras 29 Hispanic male other threat not Yes Yes
Springfield, FL 21DEC2018 David MacAdams 56 White male knife threat not No No
Starke, FL 24JUL2018 Devaughdre Delsha Rogers 19 Black male gun threat car No No
Tamarac, FL 01DEC2018 Jarvis Randall 30 Black male knife attack not Yes No
Tampa, FL 10FEB2018 Sidney T. Richardson 48 Black male knife threat not Yes No
Tampa, FL 01APR2018 Timothy Wyatt 41 Black male gun shoot car No No
Tarpon Springs, FL 09MAR2018 Alkeeta Allena Walker 32 White female knife threat not No No
Winter Haven, FL 20MAR2018 Chance Christopher Haegele 20 White male gun point 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?
Atlanta, GA 03FEB2018 Mitchell Kitchen   Black male replica point foot No No
Atlanta, GA 09FEB2018 David Darden 36 Black male vehicle flee car No No
Atlanta, GA 12APR2018 Dashaun Shepard   Black male gun shoot not Yes No
Atlanta, GA 06AUG2018 Levester Taylor 39 Black male blunt_object attack not No No
Atlanta, GA 19AUG2018 Jeremiah Perdue 33 Black male gun point not No No
Augusta, GA 15NOV2018 Jack Fields, Jr. Jr. 25 Black male knife attack not Yes No
Austell, GA 17APR2018 Sanchez Lowe 25 Black male   attack car No No
Bibb County, GA 11DEC2018 Kaley Gay 25 White female gun shoot not No No
Buford, GA 25JAN2018 Steven Hutchins 27 White male replica point not Yes No
Calhoun, GA 11DEC2018 Tameka LaShay Simpson 27 Black female gun shoot not No No
Carnesville, GA 13MAY2018 James Brian Kay 54   male gun shoot not No No
Carroll County, GA 05MAR2018 David Willoughby 33 White male replica point not No No
Carrollton, GA 14APR2018 Jessie Thedford 32 White male vehicle attack not No No
Cartersville, GA 18OCT2018 Kenneth Martin Anderson 27   male gun shoot not No No
Chamblee, GA 28JAN2018 Paul David Johnson 38 White male gun shoot foot No No
Chatham County, GA 23JAN2018 Ricky Jerome Boyd 24 Black male replica shoot   No Yes
Clayton, GA 01FEB2018 Brett Dontae Bush 28 Black male knife threat other No No
Cobb County, GA 12OCT2018 Matthew Chambers 34   male gun shoot   No No
Columbus, GA 02MAY2018 Damion Collier 24 Black male gun point car No No
Cumming, GA 19JUN2018 Charles Spillers 65 White male gun point not No No
Cumming, GA 14SEP2018 Garrett Finley Mitchell 31 White male gun point not No No
Douglasville, GA 18APR2018 Justin Oakes 32 White male knife attack not No Yes
Dunwoody, GA 20JAN2018 Jason Lappe 44 White male gun threat not No No
East Point, GA 06MAY2018 Terence Leslie 32 Black male other attack car No No
Floyd County, GA 07MAY2018 Kimberly McCann 55 White female gun shoot car No No
Hall County, GA 14JUN2018 Joseph Villanueva 29 Hispanic male gun shoot foot No No
Hall County, GA 14OCT2018 James Christopher Manus 41 White male gun shoot not No No
Henry County, GA 06DEC2018 Dimaggio McNelly 53 Black male gun shoot not Yes No
Jackson, GA 29OCT2018 Ida Christy Stiles 42 White female replica point not Yes No
Johns Creek, GA 28APR2018 Shukri Ali Said 36 Black female knife threat not Yes No
Kingsland, GA 20JUN2018 Anthony Marcell Green 33 Black male unarmed attack foot No Yes
LaGrange, GA 06JUN2018 Roger Dale Sims 56 White male gun point not Yes No
Locust Grove, GA 09FEB2018 Tierre Guthrie 39 Black male gun shoot not No No
Mableton, GA 02OCT2018 James "Cody" Martin 26 White male gun shoot not Yes No
Molena, GA 04APR2018 Grady Parks 70   male gun point not No No
Monroe, GA 12JUN2018 Chavius Hollis 26 Black male gun shoot   Yes No
Monroe, GA 18OCT2018 Mahlon Edward Summerour 63 Black male replica point not Yes No
Rossville, GA 01JAN2018 Mark Steven Parkinson 65 White male gun point not Yes No
Savannah, GA 27JUL2018 Cynthia Fields 60 Black female unarmed accident   No No
Savannah, GA 09DEC2018 Joshua Boyd 24 Black male gun point not No No
Snellville, GA 22OCT2018 Tafahree Maynard 18 Black male blunt_object threat not No No
Spalding County, GA 04JUL2018 Ryan Force 35   male gun shoot not Yes Yes
Stone Mountain, GA 19JUN2018 Jonathan Buckley 20 Black male gun shoot not No No
Walton County, GA 26JUL2018 William Earnest Brooks 43   male gun point foot No No

statecode=HI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=HI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Honolulu, HI 01JUN2018 Renie Cablay 55 Asian male knife attack not Yes No
Honolulu, HI 20SEP2018 Freddie Joe Whitmore 55 White male gun point not No No
Honolulu, HI 27SEP2018 Michael Perez 37 Hispanic male knife threat not No No
Honolulu, HI 07OCT2018 Tison Dinney 51 Asian male knife attack not Yes Yes
Honolulu, HI 27NOV2018 Bert E. Mercado 42 Asian male gun point not Yes No
Nanakuli, HI 26JUL2018 Gavalynn Mahuka 53 Asian male gun shoot not Yes No
North Shore, HI 23JUN2018 Steven Allan Kaluahinui Hyer Jr. 32 Asian male other attack not Yes No
Pahoa, HI 11DEC2018 Tori Kaneshiro 30 Asian female gun point not No No
Puna, HI 20JUL2018 Justin Waiki 33 Asian male gun shoot car No No
Puna, HI 12OCT2018 Ashley Elisna Grammer 26 Asian female vehicle attack not No No
Wailuku, HI 23DEC2018 Kaulana "Toji" Reinhardt   Asian male gun shoot car No Yes

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?
Altoona, IA 17JUL2018 Isaiah Hayes 25 White male unknown move car No No
Ankeny, IA 15SEP2018 Christopher Lee Leonard 31 White male gun point not No Yes
Boone, IA 21APR2018 Timothy Wayne Anderson 48 White male knife move   No No
Creston, IA 13AUG2018 Chris Cameron 31 White male gun move not Yes No
Davenport, IA 23OCT2018 Robert Mitchell 27 White male undetermined threat car No Yes
Fort Dodge, IA 31DEC2018 Matthew Hurley 45 White male gun shoot car No No
Moorland, IA 29APR2018 Joshua Lee Ewing 26 White male gun shoot not No No
Nashua, IA 17JAN2018 Jihad Merrick 29 Black male gun shoot car Yes No
Panora, IA 01JUL2018 Joshua B. Reed 26 White male knife threat 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?
Blackfoot, ID 11MAY2018 Jacob T. Eldridge 24 Native American male knife attack not No No
Boise, ID 04JAN2018 Robert Hansen 27 White male gun shoot not No No
Boise, ID 01JUL2018 Daniel Norris 33 White male gun shoot foot No No
Coeur d'Alene, ID 27FEB2018 Curtis Bradley Ware 33 White male gun shoot not No No
Gooding, ID 16JAN2018 Kerry Lee Nield 53 White female gun point not No No
Hammett, ID 25MAY2018 Jon Jay Lewis 55   male knife threat car No No
Idaho Falls, ID 23JAN2018 Shane McVey 54 White male unknown threat foot No No
Idaho Falls, ID 02NOV2018 Jesse J. Quinton 35 Black male unarmed attack foot No No
Meridian, ID 23JUN2018 Robert L. Barton 48 White male gun;knife threat not No No
Meridian, ID 19NOV2018 Christopher Williams 41 White male vehicle attack car No No
Nampa, ID 27MAR2018 Evan Bashir 29 White male knife threat not No No
Nampa, ID 29SEP2018 Thomas Howard Luedtke 58 White male other point   Yes No
Sandpoint, ID 05MAR2018 Brandon Kuhlman 28 White male gun shoot not Yes 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?
Alton, IL 26JAN2018 Matthew Zimmerman 42 White male knife attack not No No
Aurora, IL 22MAR2018 Santiago Calderon 36 Hispanic male gun shoot foot No No
Chicago, IL 02JUN2018 Gus Tousis 43 Black male   attack car No No
Chicago, IL 06JUN2018 Maurice Granton Jr. 24 Black male gun threat   No No
Chicago, IL 03JUL2018 Terrell Eason 33 Black male gun flee foot No Yes
Chicago, IL 14JUL2018 Harith Augustus 37 Black male gun move foot No Yes
Danville, IL 12JUN2018 DeNathe M. Guilliford 34 Black male gun point car No No
Elgin, IL 12MAR2018 Decynthia Clements 34 Black female knife threat car Yes Yes
Gurnee, IL 23MAY2018 Makell Meyerin 31 White female gun point foot No No
Lakemoor, IL 26JUL2018 Kenneth Edwin Martell 36 White male gun threat not No No
Mackinaw, IL 20APR2018 Matthew G. Brown 18 White male gun point not No No
Nokomis, IL 15JUN2018 David L. Hicks 40 White male unarmed threat foot No No
Peoria, IL 01FEB2018 Daniel O. El 32 Black male gun shoot foot No No
Peoria, IL 19JUL2018 Luis Cruz 19 Hispanic male gun threat foot No No
Quincy, IL 14MAY2018 Rollie J. Davis Sr. 53 White male gun threat not No No
Richton Park, IL 13AUG2018 Mark Harvey 32 Black male gun shoot foot No Yes
Robbins, IL 11NOV2018 Jemel Roberson 26 Black male gun accident not No No
Rock Falls, IL 26JAN2018 Nathaniel T. Edwards 43 Black male   attack car No No
Rockford, IL 30DEC2018 Kerry D. Blake Jr. 44 Black male blunt_object attack not Yes No
South Elgin, IL 03JUL2018 Frank Dripps 52 White male gun shoot not 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?
Boonville, IN 19JAN2018 Marshall Coleman 58 White male knife attack not Yes No
Crawfordsville, IN 28DEC2018 Glenn A. Rightsell 56 White male gun move not No No
Evansville, IN 23FEB2018 Douglas Kemp 58 White male replica threat not No No
Evansville, IN 11MAY2018 Barry Freeman 51 White male gun point foot No No
Gary, IN 07JUN2018 Raymon Truitt II 28 Black male gun shoot not No No
Gary, IN 12SEP2018 Thomas Watkins 38 Black male gun shoot not No No
Indianapolis, IN 19NOV2018 Daniel Cedars 65 White male gun shoot not No No
Kokomo, IN 14FEB2018 Travis D. Tucker 29 White male gun threat not No No
Merrillville, IN 14FEB2018 Jimmy Terry 30 Black male knife point not Yes No
Monroe County, IN 07AUG2018 Daniel Boyer 24 White male gun point not No Yes
North Manchester, IN 06MAR2018 Michael Kline 40 White male gun point not No Yes
South Bend, IN 05APR2018 Terrance Eppenger 27 Black male knife threat not No No
South Bend, IN 05APR2018 Rafael Ramirez 56 Hispanic male knife threat not Yes No
Sullivan, IN 10OCT2018 Leslie Shayne Miller 49 White female gun point not No No
Terre Haute, IN 06MAR2018 Michael Reynolds 36 White male gun shoot not Yes No
Terre Haute, IN 04MAY2018 Christopher A. Wolfe 21 White male gun shoot car No No
Terre Haute, IN 18DEC2018 David Frederick 24 White male gun shoot car No No
Walton, IN 27JAN2018 William Pollard 45 Black male knife threat not Yes 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?
Kansas City, KS 02MAY2018 Manuel G. Palacio 27 Hispanic male gun threat   No No
Kansas City, KS 16DEC2018 Richard L. Johnson 46 Black male gun shoot not No No
Overland Park, KS 20JAN2018 John Albers 17 White male   move   Yes No
Overland Park, KS 06JUL2018 Charles Webb 43 Black male gun shoot not No No
Pratt, KS 13NOV2018 Rene Prieto 38 Hispanic male gun shoot not Yes No
Topeka, KS 27NOV2018 Jarmane Logan 35 Black male vehicle attack car No No
Wamego, KS 26FEB2018 Ethan Straub 25 White male gun shoot 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?
Baxter, KY 20MAY2018 Bradley J. Grant 36 White male gun threat foot No No
Bremen, KY 23NOV2018 Christopher L. Anderson 46 White male gun point not No No
Christian County, KY 17SEP2018 Damon Christopher Gayheart 44 White male vehicle attack car No No
Cumberland County, KY 17APR2018 Charles Whitley 40 White male   attack car No No
Elizabethtown, KY 28MAR2018 Jesse Kilgus 51 White male gun point not No No
Georgetown, KY 11SEP2018 Edward Reynolds 57 White male gun shoot   No No
London, KY 28JAN2018 Anthony S. McDaniel 45 White male gun shoot not No No
Louisville, KY 01FEB2018 Alexander W. Simpson 32 White male gun shoot not No No
Louisville, KY 01FEB2018 Billy Ray Riggs Jr. 38 White male vehicle threat not No No
Louisville, KY 08APR2018 Russell Bowman 45 White male knife threat not Yes Yes
Louisville, KY 22APR2018 Miguel Escalona Vivas 37 Hispanic male gun shoot foot No No
Louisville, KY 24APR2018 Demonjhea Jordan 27 Black male gun shoot   No Yes
Louisville, KY 25APR2018 Isaac Jackson 42 Black male knife attack not No No
Louisville, KY 05JUL2018 Raad Fakhri Salman 62 Asian male knife threat not No No
Louisville, KY 28NOV2018 Benjamin Kennedy 35 White male gun shoot   No Yes
Oil Springs, KY 05MAR2018 Steven Dalton 35 White male gun shoot not Yes No
Scott County, KY 20MAR2018 Joel Pflum 32 White male gun point not No No
Scottsville, KY 12JAN2018 Jason D. Whittemore 39 White male gun threat not No No
Utica, KY 19MAR2018 Quintin J. Horner 50 Native American male gun point other No No
Williamsburg, KY 24SEP2018 Ronald W. Leach 29 White male knife attack 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?
Amite, LA 13MAY2018 Philip Steven McMichael 36 White male gun shoot not No No
Bogalusa, LA 23MAR2018 Daniel Allen Young 32   male unarmed attack not No No
Denham Springs, LA 10AUG2018 Jackey Sampson 43 White male gun shoot   No No
East Baton Rouge, LA 14MAR2018 Shermichael Ezeff 31 Black male unarmed attack not Yes No
Goodbee, LA 01APR2018 Joseph Walden Johnson Jr. 24 White male gun shoot car No No
Hammond, LA 27SEP2018 Coltin Brennan Leblanc 23 White male vehicle threat not No Yes
Haughton, LA 11MAY2018 Benjamin Lee Sellers 33 White male knife threat not No No
Monroe, LA 23JUN2018 Detandel Pickens Devon 25 Black male knife attack not No No
New Llano, LA 01APR2018 Bobby Hinton 60 Black male gun shoot not No No
Pineville, LA 28JUL2018 Michael Neal 32 White male undetermined undetermined car No No
Shreveport, LA 29APR2018 Brandon Busher 38 White male unarmed attack foot No No
Shreveport, LA 07AUG2018 Michael Ducote 26 White male vehicle move car No No
Shreveport, LA 16SEP2018 Jerry Foster 31 Black male gun shoot not No No
Winn Parish, LA 11APR2018 Betty Lemoine 71 White female gun shoot not No No
Winn Parish, LA 11APR2018 Kendall Lemoine 50 White male gun shoot not 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 28JAN2018 Billy Lewis Rucker 33 Black male gun shoot foot No Yes
Baltimore, MD 23SEP2018 Nathaniel Sassafras 29 Black male gun shoot not No Yes
Clinton, MD 14MAY2018 Anthony Trice Jr. 24 Black male gun point not No No
Fort Washington, MD 21FEB2018 Glenn Tyndell II 37 Black male gun shoot car No No
Glen Burnie, MD 05NOV2018 Gary J. Willis 61 White male gun shoot not No No
Landover, MD 09AUG2018 Gregory Campfield Jr. 40 Black male gun threat foot No No
Little Orleans, MD 25JAN2018 William Charles Mackenzie 66 White male gun shoot not No No
Oxon Hill, MD 01AUG2018 David Edward Hall 27 Black male gun threat foot No No
Parkville, MD 29OCT2018 Derrick Alexander Sellman 28 Black male vehicle attack car No No
Silver Spring, MD 11JUN2018 Robert Lawrence White 41 Black male unarmed attack not Yes Yes
Silver Spring, MD 23JUL2018 John Carlos Natera-Perez 30 Hispanic male knife threat not Yes No
Temple Hills, MD 17SEP2018 Jose Alvarez 23 Hispanic male gun threat foot 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?
Oakfield, ME 04MAY2018 John Corneil 54   male replica threat not No No
Old Town, ME 29NOV2018 Adrian Bunker 37 White male unknown undetermined not No No
Wales, ME 14MAY2018 William N. Derick 54 White male gun point 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?
Battle Creek, MI 22JAN2018 Joshua Dale Prough 36 White male gun threat not Yes No
Blackman Township, MI 12MAR2018 Kenneth Scott Townley 47 White male gun shoot foot No No
Dearborn Heights, MI 13MAY2018 James Collins Jr. 38   male gun threat not No No
Detroit, MI 14SEP2018 Detric Driver 46 Black male gun point not No Yes
Detroit, MI 24OCT2018 45   male gun;knife threat not No Yes
Detroit, MI 23NOV2018 Martez Webb 23 Black male gun attack not No No
Genesee Township, MI 23MAR2018 Kevin Hall 40 White male unknown threat car No No
Jackson, MI 01APR2018 Christopher Hall 34 Black male gun shoot not Yes No
Lincoln Township, MI 21NOV2018 Robert William Reid 42 White male gun shoot not Yes No
Pavilion Township, MI 18APR2018 David Teneyuque 48 Black male gun point not No No
Plymouth Township, MI 18MAY2018     male gun point foot Yes No
Royal Oak, MI 10APR2018 Antonino Thomas Gordon 28 White male   flee car No No
Royal Oak, MI 14MAY2018 Cody Reynolds 20 White male unarmed attack not No No
Saint Clair Shores, MI 04NOV2018 Theoddeus Gray 29 Black male gun shoot foot No No
Shelby Township, MI 26APR2018 Brian Scott Tietze 35 White male gun shoot not Yes No
Shelby Township, MI 03NOV2018 Kanwarbir Malhi 25 Asian male unknown threat not No No
Troy, MI 09APR2018 Robert George Issa 23 White male knife attack not No No
Union Township, MI 24JAN2018 David Byron Kidney 62 White male gun shoot not No No
Waterford Township, MI 29JUN2018 Steve Ballard 56 White male gun point car Yes No
West Olive, MI 22APR2018 Matthew Hartman 27 White male gun attack 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?
Bemidji, MN 29NOV2018 Vernon May 32 Native American male gun threat not No Yes
Chanhassen, MN 13JUL2018 Archer Amorosi 16 White male knife attack not Yes Yes
Fairmont, MN 20JAN2018 Nicholas Daniel Moore 23 White male knife threat not No No
Hastings, MN 01OCT2018 Keagan Johnson 23 White male knife point foot No Yes
Lake Elmo, MN 12APR2018 Benjamin Evans 23 White male gun threat not Yes No
Minneapolis, MN 23JUN2018 Thurman Blevins 30 Black male gun shoot foot No Yes
Minneapolis, MN 09NOV2018 Travis Jordan 36 Black male knife threat not Yes Yes
Saint James, MN 31JAN2018 Gilbert Salas 20 Hispanic male knife threat foot No No
Saint Paul, MN 05AUG2018 William James Hughes 43 Native American male gun threat not No Yes
Shakopee, MN 09NOV2018 James Hanchett 61 White male gun point not No No
Stillwater, MN 21NOV2018 Keaton James Larson 22 White male knife threat not Yes Yes
Virginia, MN 27NOV2018 J Scot Alan Widmark 41 White male knife 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?
Aurora, MO 05MAY2018 Savannah Hill 21 White female vehicle attack car No No
Belton, MO 14FEB2018 Preston Ray Holloway 27 White male gun shoot other Yes No
Belton, MO 01APR2018 Donald McCarter 38 White male knife threat   No No
Clinton, MO 06MAR2018 James E. Waters 37 Black male gun shoot not Yes No
Everton, MO 27MAY2018     male knife threat not Yes No
Grandview, MO 01JUL2018 Larry San Nicolas 60 Asian male knife move not No No
Greene County, MO 18APR2018 William Ray Simcoe Jr. 45 White male gun point foot No No
Hayti, MO 05OCT2018     male gun point not No No
Johnson County, MO 03MAR2018 Michael McEntee 70   male gun shoot not No No
Joplin, MO 02JAN2018 Louis C. Miller 66   male knife attack not No No
Kansas City, MO 08JAN2018 Frank William Pawul 32 White male gun point foot No No
Kansas City, MO 08JAN2018 Travis Griffin 20 Black male gun point foot No No
Kansas City, MO 05MAR2018     male gun shoot   No No
Kansas City, MO 14JUN2018 Timothy Mosley 33 Black male gun shoot not No No
Kansas City, MO 14JUN2018 Ashley Dean Fulkerson 28 White female knife undetermined not No No
Kansas City, MO 14JUN2018 Robert A. White   White male gun threat not Yes No
Kansas City, MO 15JUL2018 Marlin Mack 25 Black male gun shoot not No No
Liberty, MO 04AUG2018 Eric Benjamen Richards 33 White male gun shoot not Yes No
Saint Joseph, MO 29DEC2018 Christopher Kelly 42 White male gun point not No No
Saint Louis, MO 26FEB2018 William Watson Jr. 40 Black male gun shoot not No No
Saint Louis, MO 25OCT2018 Armond Beckwith-Bell 28 Black male gun;vehicle attack not No No
Saint Louis, MO 12DEC2018 Demario Bass 29 Black male vehicle attack car No No
Springfield, MO 05JAN2018 William B. Oleson 46 White male gun point not No No
Springfield, MO 04JUN2018 Joshua S. Stanford 40 White male gun shoot foot 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?
Clarksdale, MS 10NOV2018 Patrick Bryant 41 Black male gun shoot not No No
Greenville, MS 04OCT2018 Arthur Harbison 25 White male knife attack   No No
Grenada, MS 25JUN2018 William Shawn Mann 30 White male gun threat car No No
Gulfport, MS 03FEB2018 Ernie Lizana 49 White male gun shoot foot No No
Gulfport, MS 03MAR2018 Marvin McMillian 41 Black male gun shoot not No No
Horn Lake, MS 08JAN2018     male gun shoot car No No
Jackson, MS 27JAN2018 Crystalline Barnes 21 Black female vehicle attack car No No
Jackson, MS 21FEB2018 Lee Edward Bonner 37 Black male gun shoot foot No No
Jackson, MS 09MAY2018 Elliott Reed 33 Black male gun shoot not No No
Madison County, MS 08JUN2018 Michael Renfroe 36 White male unarmed threat not 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 09APR2018 Zachary Glen Hoven 29 White male knife attack not No Yes
Billings, MT 10APR2018 Shawn Michael Hubbard 44 White male replica threat not No No
Great Falls, MT 19AUG2018 Charles Marcotte   White male gun move not No No
Helena, MT 01FEB2018 Taylor Schnortz 26 White male gun threat   Yes No
Lodge Grass, MT 15APR2018 Ruben Stewart 36 Native American male knife threat not No No
Missoula, MT 17NOV2018 Jenessa M. Cooper 49 White female gun point not Yes 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?
Aberdeen, NC 28JUL2018 Arthur Kenzie Garner 33 White male gun point not No No
Burlington, NC 23JUL2018 Rosalio Hernandez Ortega 33 Hispanic male knife threat not Yes No
Burnsville, NC 16MAR2018 Bobby Lovin 62 White male blunt_object threat   No No
Charlotte, NC 11JAN2018 Jonathan Bennett 23 Black male gun shoot not No No
Charlotte, NC 02FEB2018 Charlie Shoupe 27 White male knife threat not Yes Yes
Durham, NC 09AUG2018 Shaun Jeffery Christy 37 White male gun point not Yes Yes
Fayetteville, NC 03JUL2018 Lemuel Bunn 40 Black male knife attack not No No
Fletcher, NC 18JUL2018 Wesley Shelton 33 White male gun point not No No
Franklin, NC 29APR2018 Michael Scott Knibbs 47 White male gun point not No No
Greenville, NC 01APR2018 Brian Bellamy 41 Black male knife threat not No No
Greenville, NC 09SEP2018 Brandon Joyner   Black male gun shoot not No No
Henderson, NC 15FEB2018 Wesley Taylor 58 White male gun shoot not No No
Huntersville, NC 13JAN2018 Joseph Hilton 42 White male gun move not Yes Yes
Jonesville, NC 05SEP2018 Christopher Sage 45 White male gun shoot not No No
Lenoir, NC 17JUL2018 Kerry Edwin Townsend 51 White male gun shoot not No No
Lexington, NC 12MAR2018 Brisco Tim Woodell 61 White male gun shoot not No No
Liberty, NC 02MAY2018 Billy Carson Pike Jr. 48 White male gun shoot not No No
Sanford, NC 27MAR2018 Juan Carlos Romero 41 Hispanic male gun shoot not No Yes
Sparta, NC 11APR2018 Chad Eric Montgomery 39 White male knife threat not No Yes
Tarboro, NC 28AUG2018 Sebastian Siney Chamale 37 Hispanic male unknown threat not No No
Thomasville, NC 31MAY2018 Jerick Rasheem Gray 42 Black male knife attack car No No
Timberlake, NC 20MAR2018 Kent Earl Pittman 56 White male gun point not Yes No
Washington, NC 21OCT2018 Cedric Pritchard 27 Black male gun threat not No Yes
Wilmington, NC 05JUN2018 Joshua Nash Bryant 20 White male gun threat not Yes No
Winston-Salem, NC 30MAR2018 Edward Van McCrae 60 Black male gun move not No 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?
Omaha, NE 08AUG2018 Stephen L. Caldwell 54 Black male knife attack not No No

statecode=NH

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NH

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Epping, NH 29SEP2018 Walter Welch Jr. 40 White male gun threat not No No
Gonic, NH 20AUG2018 Douglas Heath 38 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?
Atlantic City, NJ 22JUN2018 Timothy Deal 32 Black male knife attack not No Yes
Deptford, NJ 09JUN2018 LaShanda Anderson 36 Black female vehicle threat car No No
Hardwick, NJ 08JUN2018 Todd Gregory 47 White male gun shoot car Yes No
Hardwick, NJ 12JUN2018 Stephen Cogelia 32 White male knife threat not No No
Mantoloking, NJ 12NOV2018 Edward M. Walsh 39 White male knife attack not No No
Millville, NJ 22JAN2018 Edward C. Gandy Jr. 47 White male other threat   Yes No
Millville, NJ 14APR2018 Jose Pietri 55 Hispanic male gun flee car No No
Newark, NJ 26SEP2018 Paul Braswell 29 Black male vehicle attack car No No
Princeton, NJ 20MAR2018 Scott Mielentz 56 White male replica threat not Yes No
Trenton, NJ 17JUN2018 Tahaji Wells 33 Black male gun shoot not No No
Vineland, NJ 07JUL2018 Rashaun Washington 37 Black male unarmed threat   Yes Yes
Vineland, NJ 18OCT2018 Jacob Servais 19 Black male undetermined move not 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?
Alamogordo, NM 14OCT2018 Gregory Allen Tilly 55   male gun move not No No
Albuquerque, NM 06JAN2018 Daniel Saavedra-Arreola 24 Hispanic male knife;blunt_object threat not No No
Albuquerque, NM 07JUN2018 Wes Allen 33 White male gun shoot car No No
Albuquerque, NM 16JUN2018 Richard Rivera 47 Hispanic male unarmed   car No No
Albuquerque, NM 15JUL2018 Jonathan Molina 23 Hispanic male gun attack not No No
Albuquerque, NM 18JUL2018 Arthur Lujan 30 Hispanic male gun shoot not No No
Albuquerque, NM 04NOV2018 Anthony David Chavez 18 Hispanic male gun threat not No No
Albuquerque, NM 12DEC2018 Gabriel Romero 19 Hispanic male gun shoot foot Yes No
Albuquerque, NM 23DEC2018 Jason Delgado Perez 36 Hispanic male gun shoot not Yes No
Albuquerque, NM 24DEC2018 Abdias Flores 35 Hispanic male gun shoot not No No
Bernalillo, NM 03SEP2018 Fernand "Fred" Lete 70 Hispanic male gun move   No No
Clovis, NM 08OCT2018 Aaron Joseph Chavez 22 Hispanic male knife threat foot No No
Farmington, NM 05MAR2018 Andrew Rossi 25 White male knife threat not No No
Fort Sumner, NM 11MAR2018 Andy Lucero 48 Hispanic male gun flee foot No No
Las Cruces, NM 17FEB2018 Nathaniel Montoya 23 Hispanic male   threat car No No
Las Cruces, NM 05AUG2018 James Bishop 29 White male blunt_object attack not Yes No
Las Cruces, NM 27SEP2018 Juan Angel Pinedo 32 Hispanic male gun threat foot No No
Los Lunas, NM 06JAN2018 John Bailon 40 Black male unarmed flee car No No
Los Lunas, NM 23AUG2018 Virginia Romero 34 Hispanic female vehicle threat not No No
Tucumcari, NM 19JUN2018 Robert Roybal 55 White male knife attack 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?
Elko, NV 12JAN2018 Jared S.R. Williams 31 White male gun threat not No No
Henderson, NV 13SEP2018 Ryan Yamasaki 36 Asian male knife attack not No Yes
Henderson, NV 22SEP2018 Joshua Works 26 White male gun point foot No Yes
Las Vegas, NV 26JAN2018 Axell Vivas 42 Hispanic male gun move   Yes No
Las Vegas, NV 29MAR2018 Christopher Gatewood 39 White male knife threat not No Yes
Las Vegas, NV 06APR2018 Junior Davis Lopez 22 Hispanic male gun point not Yes No
Las Vegas, NV 14JUN2018 Terrence White 18 Black male vehicle;gun attack car No No
Las Vegas, NV 11JUL2018 Fidel Miranda 22 Hispanic male gun shoot car No No
Las Vegas, NV 03AUG2018 Danzel Jamal Boyd 28 Black male gun shoot not No Yes
Las Vegas, NV 06AUG2018 Spurgeon Daniels 62 Black male knife attack not Yes Yes
Las Vegas, NV 08AUG2018 William Fuller 30 Black male knife attack not Yes Yes
Las Vegas, NV 25AUG2018 Roosevelt Brown 18 Black male gun threat foot No Yes
Las Vegas, NV 10OCT2018 Kenneth Ryan Busse Jr. 21 White male gun shoot foot Yes Yes
Las Vegas, NV 27OCT2018 Lloyd Gerald Napouk 44 Asian male unknown move not Yes Yes
Las Vegas, NV 01DEC2018 Demontry Floytra Boyd 43 Black male knife attack not No Yes
North Las Vegas, NV 31OCT2018 Gonzalo Rico-Jimenez 26 Hispanic male vehicle attack car No No
Pahrump, NV 06DEC2018 Jason O'Bannon 46 White male gun shoot not Yes Yes
Reno, NV 31MAR2018 Nicolas Sedano 21 Hispanic male   attack not No No
Sparks, NV 24JAN2018 Humberto Vera-Munoz 27 Hispanic male unknown threat foot No No
Sparks, NV 17JUL2018 Rolando Brizuela 57 Hispanic male gun threat   No No
Stead, NV 24SEP2018 Phillip Serrano 44   male vehicle threat not Yes Yes
Sunridge, NV 19MAY2018 Jimmy Alan Moss 77 White male   attack   No No
West Wendover, NV 08DEC2018 James N. Robertson 41 White male knife threat car 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?
Albany, NY 22JUN2018 Schuyler Lake 20 White male knife attack not Yes No
Bronx, NY 29JAN2018 Michael Hansford 52 Black male knife threat foot No Yes
Buffalo, NY 12SEP2018 Rafael Rivera 32 Hispanic male gun shoot not No Yes
Buffalo, NY 11DEC2018 Marcus Neal 47 Black male knife attack foot Yes No
Fredonia, NY 10DEC2018 George Penev 23 White male knife attack not Yes No
Greece, NY 05APR2018 Robert Litolff 81 White male gun point not No No
Manhasset, NY 12MAR2018 Michael Ward 46 Black male blunt_object attack not No No
Maspeth, NY 17SEP2018 Susan Muller 54 White female knife attack not Yes Yes
Merrick, NY 06JUN2018 Alan Goyano 43 Hispanic male knife threat   No No
New York, NY 04APR2018 Saheed Vassell 34 Black male blunt_object point not Yes No
Pembroke, NY 11APR2018 Keith Alan Kent 61 White male gun point not Yes Yes
Rochester, NY 10OCT2018 Terrell Blake 39 Black male gun shoot car No No
Shirley, NY 15DEC2018 Walter Kellogg 57 White male knife threat not Yes No
Stanfordville, NY 25SEP2018 Jaime Lopez 41 Hispanic male knife threat not No No
Staten Island, NY 09DEC2018 Faustino Dioso 50 Asian male knife attack not No Yes
Warwick, NY 16JUN2018 Dwayne Clyburn 37 Black male knife move not 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 11AUG2018 Robert Talbert 49   male gun point foot Yes No
Apple Creek, OH 16DEC2018 Rodney J. Geiser 60 White male gun move   Yes Yes
Cincinnati, OH 24AUG2018 James Clay 20 Black male replica shoot not No Yes
Cleveland, OH 24MAY2018 Brett Luengo 33 White male unarmed attack not Yes No
Columbus, OH 12JAN2018 Amanuel Dagebo 22 Black male gun threat not No No
Columbus, OH 10FEB2018 Steven Tyler Reed 25 White male replica threat foot No No
Columbus, OH 24MAR2018 Kaitlin Marie Demeo 25 White female gun shoot not No No
Columbus, OH 30APR2018 Abadi Gebregziber 64 Black male knife threat not No No
Columbus, OH 12MAY2018 Darrell J. Bruffy 55 White male gun shoot car No No
Columbus, OH 19MAY2018 Corey Cordova 30 White male gun shoot not No No
Columbus, OH 09AUG2018 Montae Shackleford 28 Black male gun shoot foot No No
Columbus, OH 23AUG2018 Donna Castleberry 23 White female knife attack not No No
Columbus, OH 07DEC2018 Julius Ervin Tate Jr. 16 Black male gun point not No No
Crawford County, OH 26FEB2018 Aaron Clifford Fike 27 White male gun shoot foot No No
Delaware, OH 06JUN2018 Brian Puskas 47 White male gun threat not Yes No
Fairfield, OH 22JUN2018 Logan Williamson 37 White male knife attack not No No
Fairview, OH 06MAY2018 Dwight Dearth 73 White male gun point not Yes No
Franklin County, OH 17JAN2018 Joseph Edward Haynes 16 White male unarmed threat not No No
Franklinton, OH 21NOV2018 Billy G. Heeter 52 White male gun threat not Yes No
Hilltop, OH 15OCT2018 Hustes Davila 58 Hispanic male gun shoot   No No
Jeffersonville, OH 14OCT2018 Eric Jamar Lupain Stromer 22 Black male gun shoot not No No
Kettering, OH 05MAY2018 Mitchell Simmons 24 White male gun shoot not No No
Martins Ferry, OH 16MAY2018 Kevin Nickle 59 White male knife threat not No No
Parma, OH 20JUN2018 Jonathan Legg 29 White male gun shoot not No No
Pike County, OH 13JUN2018 David Arthur 44 White male gun shoot not No No
Toledo, OH 21JUL2018 Dale Slocum 56 White male knife attack not No No
Toledo, OH 28JUL2018 Lamar C. Richardson Jr. 25 Black male gun threat foot No Yes
Toledo, OH 20DEC2018 Damon Barstad 23 White male other attack not No No
Washington Court House, OH 29AUG2018 Randall McKenzie 72 White male gun threat not No No
Waverly, OH 01FEB2018 James M. Burks 35 White male unarmed attack foot Yes No
Whitehall, OH 05JAN2018 Ledarren D. Mixon 28 Black male gun point not No 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?
Bixby, OK 22JUL2018 Logan Simpson 16 White male vehicle attack car No No
Catoosa, OK 17FEB2018 Paul Stanley Strickland 55 White male gun shoot not Yes No
Catoosa, OK 12NOV2018 Andrew Kana 36 Asian male gun threat not No No
Chickasha, OK 03JUN2018 Julio Eduardo Hernandez Mata 32 Hispanic male unarmed threat car No No
Enid, OK 27SEP2018 Joey Leon Nelson 19 White male gun;knife point car No No
Grant, OK 11FEB2018     male gun point not No No
Guthrie, OK 31MAR2018 Jason Birt 27 White male knife point not No No
Lawton, OK 03JUL2018 Millard Clark Jr. 41 White male knife attack not No No
Mannford, OK 21MAR2018 Mark Allen Lunn 47 White male knife threat not Yes No
McLoud, OK 06JAN2018 Jonathan William Leroy 39 White male blunt_object threat not No No
Noble County, OK 10DEC2018 Shane Wentling 41 White male gun point car No No
Norman, OK 17MAY2018 Daniel Timothy Johnson 34 White male gun shoot not No No
Oaks, OK 09APR2018 James Matthew Rogers 34 White male gun threat not No Yes
Okarche, OK 08OCT2018 Alexander G. Lindahl 24 White male gun threat car No No
Oklahoma City, OK 01FEB2018 William Young 56 White male gun shoot not No No
Oklahoma City, OK 25FEB2018 Haydon Taylor 25 Black male knife attack not No No
Oklahoma City, OK 13AUG2018 Christopher Anthony Stone 32 Black male gun point foot No No
Oklahoma City, OK 12NOV2018 Tony Mathis 47 Black male gun undetermined other No No
Oklahoma City, OK 16DEC2018 Jacob Mohow 35 White male knife threat not Yes No
Okmulgee, OK 04APR2018 Deshawn Antonio Carswell 27 Black male knife threat not Yes No
Okmulgee, OK 29SEP2018 Justin Snelson 54 Native American male undetermined threat car No No
Owasso, OK 21MAR2018 Duane Preciado 39 Native American male gun point not Yes Yes
Pink, OK 30JAN2018 Ricky Leon Rusche 40 White male unarmed threat not No No
Prague, OK 06MAY2018 Franklin Robert Vaughn 39 White male gun point car No No
Sallisaw, OK 22JAN2018 Jonathan Duane Atchley 37 White male unarmed threat not No No
Stillwater, OK 28MAR2018 William John Dominguez 31 White male gun;knife threat not Yes No
Talihina, OK 11MAY2018 Bradley Daniel Webster 52 White male gun shoot not No No
Tishomingo, OK 17APR2018 Justin Monjay 39 White male vehicle attack car No No
Tulsa, OK 17JAN2018 Geraldine Townsend 72 Black female replica shoot not No No
Tulsa, OK 22JAN2018 Joseph E. Knight 40 White male gun threat car No No
Tulsa, OK 07MAY2018 Albert Odom 26 White male gun threat not No Yes
Tulsa, OK 23OCT2018 Shaunday Mullins 37 Native American male gun shoot not No No
Wagoner, OK 11NOV2018 Elisha Edward Kelley 52 White male unarmed threat 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?
Amity, OR 07JUL2018 Kelly Kenneth Sutton 27 White male unarmed attack foot No No
Bandon, OR 03NOV2018 Robert Charles Foster 65   male gun shoot not Yes No
Bend, OR 20JUN2018 Jesse Wade Powell 44 White male blunt_object threat not No No
Cave Junction, OR 12JAN2018 Jeffrey Alan Burleson 37 White male gun point not No No
Coos Bay, OR 23JUN2018 Eric Sweet 47 White male gun point not No No
Eugene, OR 15JAN2018 Robert Martinez Jr. 42 Hispanic male gun threat not No No
Gresham, OR 18MAY2018 Dmitri Bullard 24 White male knife threat car No No
Hillsboro, OR 10MAR2018 Daniel Stacey Reynolds 20 Black male gun shoot not Yes No
Keizer, OR 14MAR2018 Ryan Chapman 26 White male   threat foot No No
Klamath Falls, OR 05OCT2018 Phillip Samuel Moskios Jr. 48 White male gun attack foot No No
Portland, OR 07APR2018 John A. Elifritz 48 White male knife threat other Yes No
Portland, OR 29JUN2018 Jason Washington 45 White male gun undetermined   No No
Portland, OR 30SEP2018 Patrick K. Kimmons 27 Black male gun shoot   No No
Portland, OR 10OCT2018 Samuel E. Rice 30 White male knife threat not No No
Seaside, OR 24JUL2018 Cashus Dean Case 44 White male gun threat not No Yes
Sherwood, OR 12JAN2018 Remi Sabbe 54 White male gun shoot car 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?
Abington Township, PA 04MAR2018 Angel Luis Ortiz   Hispanic male replica threat not No No
Bristol Township, PA 02MAR2018 Jose D. Gomez Burgos 29 Hispanic male unknown threat not No No
Franklin Township, PA 18DEC2018 Danny Washington 27 Black male unarmed attack car No No
Harrisburg, PA 18JAN2018 Kevin Sturgis 31 Black male gun shoot not No No
Harrisburg, PA 01FEB2018 Albert E. Morton Jr. 31 Black male   attack not No No
Lancaster, PA 08MAY2018 John Simson 65 White male gun shoot not No No
Lancaster, PA 16SEP2018 Ricardo Avenia 29 Hispanic male gun point not No No
Lower Burrell, PA 10MAY2018 Michael E. Hutchman 33 White male gun threat not No No
Lower Macungie Township, PA 28MAR2018 Aaron Ibrahem 26 White male gun shoot foot No No
Manchester Township, PA 06JAN2018 Gregory Stough 27 White male vehicle threat car No No
Manchester Township, PA 25AUG2018 Logan Montgomery 29 White male gun shoot not No No
Philadelphia, PA 06AUG2018 Ricardo Giddings 59 Black male gun shoot not No No
Philadelphia, PA 09AUG2018 Charles Meadows 48 Black male gun shoot foot No No
Philadelphia, PA 20AUG2018 Jeffrey Dennis 36 Black male vehicle attack car No No
Philadephia, PA 05DEC2018 Justin Smith 41 White male knife attack not No No
Pittsburgh, PA 11FEB2018 Mark Daniels 39 Black male gun shoot foot No No
Pittsburgh, PA 19JUN2018 Antwon Rose Jr. 17 Black male unarmed flee foot No No
Pottstown, PA 08MAR2018     male replica threat not Yes No
Prompton, PA 25JUN2018 James Sorrentino 36   male gun shoot not Yes No
South Whitehall Township, PA 28JUL2018 Joseph Santos 44 Hispanic male unarmed undetermined not No No
Union City, PA 18DEC2018 Keith A. Hawley 27 White male gun attack   No No
Volant, PA 05APR2018 William Frazier II 40 White male gun shoot not No No
Washington, PA 12APR2018 Steven Brooks 45 Black male gun point 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?
Pawtucket, RI 07SEP2018 DaShawn Cole 28 Black male gun attack   No No

statecode=SC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=SC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Blacksburg, SC 26AUG2018 Stephanie B. Owens 41 White female gun point not Yes No
Camp Croft, SC 05NOV2018 Anovath Troy Kongvongxay 48 Asian male blunt_object attack not Yes No
Chester, SC 27FEB2018 Dustin James Case 20 White male gun threat car No Yes
Darlington County, SC 20OCT2018 Kimberly Norris 34 White female gun shoot not No Yes
Darlington County, SC 16DEC2018 April Webster 47 Black female knife threat not Yes No
Enoree, SC 24AUG2018 Jeffery Paul Fabio 44 White male other point not Yes No
Florence, SC 14JUL2018 Jethro Benjamin 68 Black male gun shoot not No No
Greenville, SC 19MAR2018 Jermaine Massey 35 Black male knife threat not No Yes
Johns Island, SC 28SEP2018 Joseph Dawson 24 White male gun shoot not No No
Lexington County, SC 11JAN2018 Justin Coy Adkins 44 White male gun point car No No
Spartanburg, SC 14NOV2018 John David Manning 29 White male knife attack not No No
Swansea, SC 28MAR2018 Robert B. Shaw 29 White male gun threat car Yes No

statecode=SD

statecode=TN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=TN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bartlett, TN 03OCT2018 Toby Bailey 38 Black male gun point not Yes No
Carthage, TN 08AUG2018 Joseph Robbins 24 White male vehicle attack not No No
Chattanooga, TN 12NOV2018 Cesar Alehandro Ramos 25 Hispanic male gun shoot not No No
Church Hill, TN 08JAN2018 Eugene Loftis 25 White male gun move not No No
Church Hill, TN 22FEB2018 Joshua D. Babb 26 Black male gun threat   No No
Clarksville, TN 16MAR2018 James Alfonso Vaughn 49 Black male gun shoot not No No
Clarksville, TN 29MAR2018 James Decoursey 35 White male gun threat other No No
Cocke County, TN 05NOV2018 Henry Gregory Stroud 36 White male gun point not Yes No
Fairview, TN 31AUG2018 Chase Sullivan 36 White male knife threat not Yes No
Greenback, TN 30SEP2018 Brian Lee Rogers 40 White male blunt_object threat not Yes No
Jonesborough, TN 16MAR2018 Mark Clinton Harrell Jr. 26 White male knife threat foot Yes No
LaFollette, TN 25JUL2018 Michael Heatherly 64 White male gun point not Yes No
Lawrenceburg, TN 29JUN2018 Randy Thomas Groom 33 White male knife threat foot No No
Memphis, TN 17JAN2018 Brian Gregory 34 Black male gun move car No No
Memphis, TN 21APR2018 Terrence Carlton 25 Black male gun move foot No No
Memphis, TN 17OCT2018 Keyshon Parham 19 Black male gun shoot foot No No
Memphis, TN 13DEC2018 Andre Horton 42 Black male gun point not Yes No
Morristown, TN 10MAY2018 Kenneth Carter 46 White male vehicle attack not No No
Nashville, TN 26JUL2018 Daniel Hambrick 25 Black male gun threat foot No Yes
Nashville, TN 05OCT2018 Sershawn Martez Dillon 31 Black male gun shoot not No No
Newport, TN 22OCT2018 William David Williamson 61 White male unknown attack not No No
Oak Ridge, TN 08OCT2018 Isaiah Ramirez 36 White male vehicle attack car No No
Soddy-Daisy, TN 24JUL2018 Donna Lynn Allen 39 White female vehicle attack car No No
South Knoxville, TN 26NOV2018 Sierra McCauley 23   female knife attack not Yes No
Tullahoma, TN 28DEC2018 Mark Wade "Cornbread" Luttrell Jr. 34 White male gun point not 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 23MAR2018 Michael Leroy McGinnis II 29 White male gun point not No No
Alvin, TX 15JUL2018 Isaac Ovidio Chapa III 34 Hispanic male gun point not Yes No
Amarillo, TX 24APR2018 Adam Ulalio Zambrano 31 Hispanic male gun shoot not Yes No
Amarillo, TX 25JUL2018 Jose Luis Rodriguez 23 Hispanic male gun threat not No No
Arlington, TX 09MAR2018 Hieu Trung Than 38 Asian male knife attack not No No
Arlington, TX 01SEP2018 Oshae Marquis Terry 24 Black male vehicle attack car No No
Austin, TX 19FEB2018 Thomas Vincent Alvarez 23 Hispanic male gun point other Yes No
Austin, TX 07MAR2018 Victor Ancira 46 Hispanic male blunt_object threat not Yes No
Austin, TX 25MAR2018 Hugo Alvarez 28 Hispanic male gun shoot not No No
Austin, TX 07JUN2018 Leslie Yolanda Salazar 20 White female knife threat   No Yes
Austin, TX 17AUG2018 Aquantis Jaymond Griffin 21 Black male gun point   No No
Bedford, TX 16JAN2018 Victor Manuel Reyes Jr. 30 Hispanic male unknown move not No No
Bexar County, TX 07MAR2018 Amelia Huron-Macias 84 White female unarmed accident not No No
Bexar County, TX 05MAY2018 Matthew D. Mathison 59 White male gun shoot foot Yes No
Brownsville, TX 01APR2018 Luis Yair Alvarez 23 Hispanic male knife threat not Yes No
Camp Wood, TX 02JAN2018 Shana Diane Musquiz 30 White female gun shoot not No No
Childress, TX 23MAR2018 Steven Cortez 20 Hispanic male gun point foot No No
Clarksville, TX 02MAR2018 Michael James Chekel 56 White male unknown point not No Yes
Conroe, TX 28JAN2018 Gregory Kocian 33 White male gun shoot car No No
Corpus Christi, TX 04APR2018 Adan Rene Marrero 34 Hispanic male gun threat foot No No
Dallas, TX 27FEB2018 Marlon Smith 29 Black male gun shoot not No No
Dallas, TX 02MAY2018 Timothy Raye Mayfield 67 Black male gun shoot not No No
Denton, TX 19FEB2018 Lawrence Edward Shaw 45 Black male knife threat foot No Yes
Dilley, TX 13JUL2018 Juan Luna 25 Hispanic male gun shoot not No Yes
Dumas, TX 25MAY2018 Augustine Oliva 29 White male vehicle attack not No No
El Paso, TX 10OCT2018 Richard Palafox 76 White male gun point not No No
Fort Worth, TX 11JAN2018 Jose Arroyo-Rosales Sr. 60 Hispanic male gun point   No No
Fort Worth, TX 14FEB2018 Derek Wayne Porter 47 White male gun point foot No No
Fort Worth, TX 19DEC2018 Daniel Geiger 34 White male gun shoot not Yes No
Galveston, TX 25JUN2018 Luis Argueta 18 Hispanic male unknown threat   No No
Garland, TX 25JUN2018 Bobby Blade 29 White male gun point car No No
Garland, TX 10JUL2018 Shaun Gates 40 White male knife attack not No No
Grand Prairie, TX 25APR2018 Carlos Deone High 37 Black male gun point not No No
Greenspoint, TX 22MAR2018 Danny Thomas 35 Black male unarmed attack not Yes No
Guadalupe County, TX 18FEB2018 Ernest Manuel Montelongo 33 Hispanic male gun shoot car No No
Harris County, TX 29JAN2018 Mark Renee Flores 46 Hispanic male knife attack not No No
Harris County, TX 16MAR2018 Brian Patrick Thornburg 34 White male undetermined attack not No No
Hereford, TX 01AUG2018 Jonathan Joey Mendoza 35 Hispanic male gun point not No No
Houston, TX 25JAN2018 Ulises Valladares 47 Hispanic male unarmed accident not No No
Houston, TX 01FEB2018 Anthony Joe Williams 37 Black male gun point foot No No
Houston, TX 29AUG2018 Jalon Johnson 17 Black male vehicle attack car No No
Houston, TX 01OCT2018 Nowy Angel Duron 29 Other male gun threat   No No
Houston, TX 27OCT2018 Christopher Carroll 30 Black male gun point not Yes No
Houston, TX 31OCT2018 Jose Centeno, Jr. 17 Hispanic male replica shoot car No Yes
Houston, TX 16NOV2018 Anthony Rodriguez 19 Hispanic male gun shoot not No No
Irving, TX 22JAN2018 Aaron Olivarez Candanoza 28 Hispanic male   threat car No No
Lancaster, TX 18MAR2018 Michael Earl Brisco 36 Black male   attack car No No
Laredo, TX 18MAY2018 Reynaldo Pena 29 Hispanic male unknown threat   No No
League City, TX 23JAN2018 Alvaro Herrera 18 Hispanic male blunt_object attack foot No No
League City, TX 01MAY2018 Roger Fortner 49 White male knife threat not No No
Littlefield, TX 21MAR2018 Angel Uolla 18 Hispanic male knife attack foot No No
Llano, TX 30DEC2018 Warren Jay Beaubien 49 White male knife threat not No No
Longview, TX 20JAN2018 Arther McAfee Jr. 61 Black male unarmed threat not Yes No
Mathis, TX 22MAY2018 Martin Sandejo 49 Hispanic male knife threat not No No
Midland, TX 11MAR2018 Juan Garcia Alvarez 57 Hispanic male gun shoot not No No
Missouri City, TX 09SEP2018 Dereshia Blackwell 39 Black female gun;knife move not No No
Paris, TX 20OCT2018 Edward Paul Zumski III 35 White male gun point not No No
Pasadena, TX 29MAR2018 Marco Antonio Saavedra 44 Hispanic male gun point other Yes Yes
Pasadena, TX 21NOV2018 Nathan Alexander Schenk 34 White male unarmed flee foot No No
Pattison, TX 18JUL2018 Mickey Coy 59 White male gun point not No No
Pearland, TX 05JUN2018 Abel Guzman 55 Hispanic male gun point not Yes No
Port Arthur, TX 28DEC2018 Shane Lyons 35 Black male knife threat not No No
Quinlan, TX 17OCT2018 Daniel Paul Lehman 34 White male knife threat not No No
Rio Bravo, TX 23MAY2018 Claudia Patricia Gomez Gonzalez 20 Hispanic female unarmed attack not No No
Round Rock, TX 06JAN2018 Richard Rangel 21 White male gun attack not No No
San Antonio, TX 25JAN2018 Dustin Gonzales Castillo 19 Hispanic male knife attack other No No
San Antonio, TX 27JAN2018 Kirsten Kloppe 43 White female gun point not Yes No
San Antonio, TX 01APR2018 Cresencio Rodriguez Rico 34 Hispanic male gun threat not No No
San Antonio, TX 24APR2018 Jesse Pena 44 Hispanic male gun threat foot No No
San Antonio, TX 01MAY2018     male gun shoot car No No
San Antonio, TX 14MAY2018 Bob Browning Cruz 36 Hispanic male gun shoot not No No
San Antonio, TX 20JUL2018 Javier Lopez 19 White male gun shoot foot No No
San Antonio, TX 17OCT2018 Charles Roundtree 18 Black male unarmed accident not No No
San Antonio, TX 07NOV2018 Mark Anthony Sanchez 29 Hispanic male gun shoot not No No
Sandia, TX 03MAY2018 Sean Louis Justin 28 White male knife attack not No No
Shelbyville, TX 06MAR2018 Louis Troy Risinger 70 White male gun threat not No No
Silsbee, TX 26MAY2018 Homer Woodroe Tyler Jr. 51 White male gun threat not No No
Stratford, TX 21FEB2018 Darion Baker 22 Black male unarmed flee car No No
Temple, TX 09JUN2018 Timothy Owen 49 White male gun shoot not No No
Vernon, TX 26APR2018 Anthony Lamar Carter 22 Black male knife attack car No No
Waco, TX 13APR2018 Kenneth Warren Resendez 34 White male knife threat not No No
Willis, TX 11JUL2018 Laura Mae Bond 45 White female knife threat not No No
Winters, TX 02FEB2018 Joe Lester Wilson 81 White male gun point not Yes 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 27NOV2018 Allen Scott Culpepper 64 White male gun shoot not Yes No
Cottonwood Heights, UT 29MAY2018 Zane Anthony James 19 White male replica flee foot No No
Kearns, UT 17OCT2018 James Lyle Kuehn 61 White male knife threat   No No
Magna, UT 17APR2018 Lonnie Marcel Bowen 41 Black male knife attack car Yes No
Montezuma Creek, UT 15FEB2018 Fordell Hill 27 Native American male gun shoot car No No
Ogden, UT 09NOV2018 Christopher William Parrish 33 White male blunt_object attack car No No
Ogden, UT 30NOV2018 Ricardo Galvan 37 Hispanic male gun shoot not No Yes
Ogden, UT 04DEC2018 Anthony Ray Borden-Cortez 18 Hispanic male replica point not No Yes
Orem, UT 12OCT2018 Jacob E. Albrethsen 17 White male knife threat not No No
Riverton, UT 22OCT2018 Jason Whittle 26 White male knife attack not Yes No
Salt Lake City, UT 18OCT2018 Andrey Tkachenko 23 White male vehicle move car No No
Salt Lake City, UT 09NOV2018 Cody Paris Belgard 30 White male unarmed undetermined car No Yes
Sandy, UT 13MAR2018 Bryan Liles 31 White male gun threat not No No
South Salt Lake, UT 17JUN2018 Abe Martinez 44 Hispanic male gun threat not No No
South Salt Lake, UT 24NOV2018 Felix Anthony Calata 32 Hispanic male vehicle attack car Yes No
Sugar House, UT 18APR2018 Delorean Pikyavit 32 Native American male knife move not Yes No
West Jordan, UT 28MAY2018 Michael Glad 23 White male gun point car No No
West Jordan, UT 11OCT2018 Diamonte Riviore 22 Black male knife threat   No No
West Valley City, UT 08APR2018 Elijah James Smith 20 Black male knife flee foot 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?
Bristol, VA 23JUL2018 Paul Meade 71 White male gun point not Yes No
Danville, VA 07JAN2018 Richard R. Towler 54 Black male gun shoot not No No
Danville, VA 08APR2018 Juan Markee Jones 25 Black male unarmed threat other No Yes
Glade Spring, VA 08MAY2018 Phillip Cameron Gibson II 37 White male replica threat other No No
Harrisonburg, VA 22JUN2018 Thomas Albun Beall Jr. 31 White male knife attack not No No
Henrico, VA 01MAR2018 Timothy M. Gray 40 Black male knife threat car No No
Hopewell, VA 18DEC2018 Angel Viola Decarlo 31 Black female gun point foot No No
Montgomery County, VA 25AUG2018 Taylor K.E. Tincher 18 White male gun threat not Yes No
Portsmouth, VA 13MAY2018 Willie Rogers Marable 28 Black male unknown threat not No No
Richmond, VA 14MAY2018 Marcus-David L. Peters 24 Black male unarmed attack car No Yes
Richmond, VA 05DEC2018 Anthony M. Edwards 33 Black male knife attack not No No
Spotsylvania, VA 08MAR2018 Jamil Harvey 29 Black male gun shoot other No No
Sussex County, VA 01AUG2018 Tramaine Marquese Poole 41 Black male gun shoot car No No
Virginia Beach, VA 18SEP2018 Michael James Murphy 43 White male gun point foot No No
Waynesboro, VA 12AUG2018 Anthony Makai Hutchinson 40 Black male gun shoot car No No
Wise County, VA 26MAR2018 Nathan C. Castle 34 White male gun threat car No No
Woodbridge, VA 23FEB2018 Mario Dantoni Bass 37 Black male unarmed threat foot No No
Wythe County, VA 14NOV2018 Olajuwon Murphy 22 Black male gun shoot not No 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?
Bolton, VT 11FEB2018 Benjamin Gregware 42 White male gun threat not Yes No
Montpelier, VT 16JAN2018 Nathan Giffin 32 White male replica threat foot 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?
Alderwood Manor, WA 23OCT2018 Nickolas Michael Peters 24 White male unarmed attack car No No
Benton City, WA 07JUN2018 Douglas Conner 50 White male gun threat not No No
Cheney, WA 03SEP2018 Steve L. Anderson 40 White male knife move not Yes No
Deer Park, WA 03AUG2018 Josh Martin 31 White male gun point not Yes No
Ebey Island, WA 21JAN2018 Ilkka O. Hiironen 35 White male unknown threat not Yes No
Elk Plain, WA 16MAR2018 William Langfitt 28 White male knife move not Yes No
Federal Way, WA 06APR2018 Mitchell Nelson 36 White male gun shoot not No No
Kent Station, WA 26JUL2018 Jesus Hernandez Murillo 18 Hispanic male gun move not No No
Kirkland, WA 14JUN2018 Marcelo Castellano 40 Hispanic male gun threat not No No
Longview, WA 17OCT2018 Weston Willow Well Cole 29 White male gun shoot foot No No
Marysville, WA 18SEP2018 Jeffrey Sims 37 White male knife attack not Yes No
Oak Harbor, WA 23SEP2018 Richard J. Jackson 36   male knife threat   No No
Puyallup, WA 12JAN2018 Juan Valencia 36 Hispanic male gun shoot car No No
Seattle, WA 19FEB2018 Jason Seavers 41 White male gun shoot not No No
Seattle, WA 31DEC2018 Iosia Faletogo 36 Asian male gun point foot No Yes
Spanaway, WA 20OCT2018 Robert Smith Jr. 50 White male gun threat not No No
Spokane, WA 25JUL2018 Richard R. Bahr 54 White male vehicle attack car No No
Spokane, WA 19AUG2018 Bryan C. Bayne 42 White male gun point not Yes No
Stanwood, WA 09SEP2018 Adam Jensen 43   male knife threat not No No
Tacoma, WA 07JAN2018 Michael Bender 27 White male gun shoot not No No
Tacoma, WA 16OCT2018 Donald Judd 45   male vehicle attack not No No
Vancouver, WA 28NOV2018 David Villagran 33 Hispanic male vehicle attack car No No
Walla Walla, WA 16SEP2018 Christopher Adam Borland 40   male gun threat 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 07MAY2018 David J. Robinson 50 White male gun threat not Yes Yes
Clark County, WI 11MAY2018 Kelly G. Abbott 51 White male gun shoot car No No
Crandon, WI 04JAN2018 Brandon O. Cude 31 White male gun point not No No
Elkhorn, WI 18OCT2018 Sean Dutcher 38 White male vehicle attack car No No
Fox Crossing, WI 23MAY2018 Joshua M. Gomoll 25 White male knife threat not Yes No
Hawkins, WI 12AUG2018 Adam Knowlton 35 White male knife threat not Yes No
Manitowoc, WI 16SEP2018 Bruce Smith 25 White male unknown threat not No No
Middleton, WI 19SEP2018 Anthony Tong 43 Asian male gun shoot   Yes Yes
Milwaukee, WI 13AUG2018 Mario Hobson 48 Black male gun threat not Yes Yes
Milwaukee, WI 10OCT2018 Alonzo L. Smith 31 Black male gun shoot not No Yes
Racine, WI 17JAN2018 Donte D. Shannon 26 Black male gun point foot No No
Sparta, WI 06JAN2018 Skyler Burnette 21 Native American male knife threat not No No
York, WI 11MAY2018 Kelly G. Abbott 51 White male gun shoot car No No

statecode=WV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Charleston, WV 29MAR2018 Rodney Toler 39 Black male gun shoot car Yes No
Charleston, WV 02NOV2018 Andrew Moore 25 White male knife attack not No No
Inwood, WV 17FEB2018 Lamar Green 28 Black male gun shoot not No No
Monongalia, WV 24FEB2018 Randall Beymer 62 White male replica point not No Yes
Reynoldsville, WV 05APR2018 Raymond Lyle Bell 59 White male gun threat foot No Yes
Scarbo, WV 04OCT2018 William Cox 45   male gun point not No No
Sissonville, WV 16FEB2018 Odrey Paul Reed 39 White male undetermined undetermined   Yes No

statecode=WY