Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2016

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 12JUL2016 Benjamin Zeckovic 23 White male knife attack not Yes No
Anchorage, AK 21SEP2016 Robert Musser 69 White male gun shoot not Yes No
Anchorage, AK 12NOV2016 James Dale Ritchie 40 White male gun shoot not No No
Barrow, AK 10FEB2016 Vincent Nageak III 36 Native American male gun point not No No
Fairbanks, AK 29AUG2016 James Robert Richards, Jr. 28 Native American male gun attack foot No Yes
Houston, AK 21FEB2016 Patricia Kruger 38 Native American female gun point not No No
Spenard, AK 12JAN2016 Herman Bean Jr. 49 Native American male knife threat not Yes No
Wasilla, AK 03JUN2016 Joshua Smith 33 White male knife threat not No No

statecode=AL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Ashville, AL 28FEB2016 Nathan Grissom 41 White male gun point not No No
Birmingham, AL 09JUN2016 William Michael Hollis 34 White male gun shoot car No No
Birmingham, AL 22JUN2016 Isaiah Core III 20 Black male   attack car No No
Brooksville, AL 19APR2016 Daniel Eric Blackmon 38 White male gun shoot car No No
Clanton, AL 23JAN2016 Michael Lamar Robinson 43 White male replica threat not No Yes
Eastaboga, AL 28MAY2016 Dennis Hudson 50 Black male gun point not No No
Eufaula, AL 04JUN2016 Demarco Rhymes 35 Black male gun shoot other No Yes
Gadsden, AL 24DEC2016 Orande Kandie Hayes     male gun point foot No No
Homewood, AL 29JUL2016 Amanda Page Bivens 40 White female gun point not No No
Huntsville, AL 18JUN2016 William Thomas Hennessey 34 White male replica attack not No Yes
Huntsville, AL 17SEP2016 Robert Young 45 White male replica point other No Yes
Killeen, AL 07OCT2016 Eddie Collins 42 White male gun shoot not No No
Macon County, AL 03APR2016 Melissa Boarts 36 White female unknown threat not Yes Yes
Meridianville, AL 20JAN2016 Randy Joe Sanders Jr. 33 White male gun threat foot No Yes
Mobile, AL 13JUN2016 Michael Moore 18 Black male gun threat not No No
Montgomery, AL 25FEB2016 Greg Gunn 56 Black male blunt_object undetermined not No Yes
Phenix City, AL 29JAN2016 Angela Hiatt 41 White female vehicle point car No No
Phenix City, AL 15OCT2016 Daniel Richard Murphy 38   male gun point not No No
Phenix City, AL 06NOV2016 Christian Andrew Redwine 17 White male   move car No No
Piedmont, AL 13MAR2016 Wesley Chad Deerman 26 White male gun shoot car No No
Rainbow City, AL 17JAN2016 Joshua Tate Fielding 38 White male gun threat not No No
Selma, AL 07JUL2016 Earnest Fells 63 Black male gun shoot not No Yes
Tuscumbia, AL 02DEC2016 Derek Lynn Scott 33 White male gun shoot not No No
Westover, AL 22OCT2016 Nathaniel B. Dorough 21 White male unknown threat not Yes No

statecode=AR

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=AR

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Austin, AR 07FEB2016 Phillip Luchsinger 36 White male gun threat not No No
Benton, AR 07OCT2016 Thomas Jeffery Burns 49 White male replica threat not No No
Benton, AR 17OCT2016 Keegan Schweikle 17 White male gun point foot Yes No
Desha, AR 25DEC2016 Joseph Garcia 33   male gun shoot not No No
Dover, AR 01DEC2016 Quinton Phillips 83 White male gun shoot not No No
Farmington, AR 24JUN2016 Randy Blecher 50 White male gun point not No No
Fayetteville, AR 23APR2016 Willie Tillman 33 Black male   move car No Yes
Fayetteville, AR 21DEC2016 Benjamin Ortiz 25   male knife move not Yes No
Little Rock, AR 26SEP2016 Leeland White 32 White male gun threat not Yes No
Little Rock, AR 25OCT2016 Roy Lee Richards 46 Black male replica threat not No No
Mena, AR 16FEB2016 Shawn Henry Allen Dickens 30 White male gun move foot No No
Mountain Pine, AR 27JAN2016 Scott Scanlon 52 White male gun shoot not No No
Perryville, AR 20APR2016 Jackie Lee Kirkham 52 White male unknown threat not No No
Sims, AR 04MAR2016 John Alan Chamberlain 66   male undetermined undetermined   No No
Springdale, AR 04OCT2016 Zachary Sutton 26 White male gun shoot not 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?
Apache Junction, AZ 16AUG2016 Larry Eugene Kurtley Jr. 53 White male replica threat not No No
Bullhead City, AZ 11DEC2016 Amber Lewis 44 White female replica point not Yes No
Casa Grande, AZ 18NOV2016 Gabriel Parker 48   male knife threat not Yes No
Chandler, AZ 23APR2016 Mitchell Oakley 24 White male gun shoot not Yes No
Flagstaff, AZ 21MAY2016 Mark Nelson 31 Native American male gun point not Yes Yes
Flagstaff, AZ 23MAY2016 Verl Bedonie 26 Native American male gun point foot No Yes
Flagstaff, AZ 13JUL2016 Donald S. Myers 32 White male gun undetermined foot No Yes
Florence, AZ 30APR2016 Bender Dass 55 White male   attack car No No
Gilbert, AZ 03MAR2016 Sergio Ochoa 27 Hispanic male knife move car No No
Glendale, AZ 30MAR2016 Ruben Cossyleon 25 Hispanic male gun undetermined not No No
Kingman, AZ 29AUG2016 Paula Dell Phillips 35 White female gun point not No No
Kingman, AZ 29SEP2016 Jeffrey Clair Cave 53 White male gun shoot not No Yes
Kingman, AZ 30OCT2016 Kenneth Jack Kennedy 34 White male   threat car No No
Lake Havasu City, AZ 20JUN2016 Devin Christopher Scott 20 White male knife threat not No Yes
Mesa, AZ 17JAN2016 Daniel Shaver 26 White male unarmed move not No Yes
Mesa, AZ 04FEB2016 Kayden Clarke 24 White male knife threat not Yes Yes
Mesa, AZ 12AUG2016 Jesus Armando Carillo 22 Hispanic male undetermined threat car No No
Parker, AZ 03JUN2016 Hubert Thomas Burns, Jr. 34 Native American male knife threat not No No
Phoenix, AZ 18JAN2016 Levi Gene Wilson 39 White male gun point not Yes No
Phoenix, AZ 21FEB2016 Sherrisa Homer 36 Native American female gun point foot Yes No
Phoenix, AZ 23FEB2016 Alex Buckner 26 White male gun shoot not Yes No
Phoenix, AZ 24FEB2016 Victor Rivera 27 Hispanic male   move car No No
Phoenix, AZ 14MAY2016 Francis Clark 43 Native American male gun shoot not No Yes
Phoenix, AZ 18MAY2016 Israel Santos-Banos 20 Hispanic male gun shoot not No No
Phoenix, AZ 01JUN2016 Kevin Thomas Marshall 30 White male gun shoot not No No
Phoenix, AZ 13AUG2016 Ruben Horacio Strand Alvear 38 Hispanic male knife attack not Yes No
Phoenix, AZ 19AUG2016 Jorge Ceniceros 22 Hispanic male gun attack not No No
Phoenix, AZ 27AUG2016 Angel Torres Jr. 26 Hispanic male replica point not No No
Phoenix, AZ 06SEP2016 Steven Del Rio 31 Hispanic male gun point car No No
Phoenix, AZ 06SEP2016 Dylan Papa 25 White male knife attack not Yes No
Phoenix, AZ 15SEP2016 Robert Carrillo 32 Hispanic male gun threat other No No
Phoenix, AZ 27SEP2016 John Ethan Carpentier 26 White male   threat car No No
Phoenix, AZ 30DEC2016 Dustin Selby 31 White male knife threat foot No No
Scottsdale, AZ 27JUL2016 Dylan Liberti 24 White male knife threat foot No Yes
Scottsdale, AZ 09OCT2016 Luis Michael Hoff 40 White male gun threat car Yes No
Show Low, AZ 09NOV2016 Daniel Erickson 36 White male gun shoot not No No
Somerton, AZ 09JUN2016     male blunt_object attack not No No
Surprise, AZ 26NOV2016 Derek Adame 20 Hispanic male   attack car No Yes
Tempe, AZ 27JUL2016 Dalvin Hollins 19 Black male unarmed attack foot Yes No
Tucson, AZ 18JAN2016 Jordan Szymanski 33 White male gun shoot not Yes No
Tucson, AZ 30MAY2016 Osee Calix 33 Black male gun point not No No
Tucson, AZ 08JUL2016 Abraham Smith 30 White male knife threat not Yes No
Tucson, AZ 28JUL2016 Jesus Rael 31 Hispanic male gun shoot other No No
Tucson, AZ 16AUG2016 Marcos Antonio Gastelum 25 Hispanic male unarmed attack not No No
Tucson, AZ 12NOV2016 Richard T. Herrera Jr. 29 Hispanic male gun shoot car No No
Tucson, AZ 25NOV2016 Carlos Valencia 26 Hispanic male unarmed threat not No Yes
Tucson, AZ 01DEC2016 Jose Noe Barron Gomez 27 Hispanic male gun shoot   No No
Winslow, AZ 27MAR2016 Loreal Tsingine 27 Native American female knife move not Yes Yes
Yuma, AZ 05JUL2016 Melissa Ventura 24 Hispanic female knife 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?
Anaheim, CA 09FEB2016 Gustavo Najera 22 Hispanic male unarmed undetermined not No Yes
Anaheim, CA 20FEB2016 Danny Rendon 30 Hispanic male gun shoot car No Yes
Anaheim, CA 19NOV2016 Adalid Flores 29 Hispanic male unarmed attack foot No Yes
Antelope, CA 18AUG2016 Chad Irwin 40 White male knife threat not No No
Azusa, CA 08NOV2016 Carlos Mendez 45 Hispanic male gun shoot not No No
Bakersfield, CA 31JAN2016 Joshua Shane Bispo 42 White male gun point car No No
Bakersfield, CA 22FEB2016 Jamie Clark Long 45 White male knife attack not No No
Bakersfield, CA 18AUG2016 Francisco Villarreal 37 Hispanic male gun shoot car No No
Bakersfield, CA 12DEC2016 Francisco Serna 73 Hispanic male unarmed undetermined not No No
Beaumont, CA 17SEP2016 Robert Duh 42 White male knife threat not No No
Bell, CA 07JUL2016 Vinson Lee Ramos 37 Hispanic male knife threat not No No
Boyle Heights, CA 13MAY2016 Robert Mark Diaz 28 Hispanic male gun shoot not No Yes
Brawley, CA 20DEC2016     male knife threat not Yes No
Byron, CA 18MAR2016 Michael Mallet 49   male gun point not Yes No
Carmichael, CA 18JUN2016 Sergey Makarenko 17 White male   threat car No No
Castaic, CA 02AUG2016 William Bowers 51 White male unarmed flee foot No No
Ceres, CA 05JAN2016 Albert Thompson 28 Hispanic male other move foot No No
Cerritos, CA 24FEB2016 Francisco Garcia 26 Hispanic male   attack not No No
Chatsworth, CA 31OCT2016 Jose Armando Cueva 55 Hispanic male knife attack not No No
Chino, CA 23JUL2016 Bernard Wells III 31 Black male gun point foot No No
Chula Vista, CA 14JUN2016 Fernando Geovanni Llanez 22 Hispanic male undetermined attack not No No
Citrus Heights, CA 19MAY2016 Jaime Ide 35 Hispanic male knife threat not No Yes
Citrus Heights, CA 08AUG2016 Michael McClurg 56 White male replica point not No No
City Terrace, CA 28JUL2016 Omar Gonzalez 36 Hispanic male gun threat car No Yes
Clearlake Park, CA 29MAR2016 Joseph Louis Melvin 46 White male blunt_object attack not No Yes
Clovis, CA 07JUL2016 Adam Smith 33 White male   threat car No No
Coalinga, CA 21DEC2016 Anthony Lovell Eddington 24 Black male gun shoot not No No
Colton, CA 12SEP2016 Christian Vargas 25 Hispanic male unarmed accident car No No
Compton, CA 28JUL2016 Donnell Thompson Jr. 27 Black male unarmed attack other No No
Compton, CA 25AUG2016 Donta Taylor 31 Black male gun point foot No No
Compton, CA 25AUG2016 David Coborubio 32 Hispanic male undetermined accident not No No
Concord, CA 11OCT2016 Dominick Musulman 30 White male knife threat not No No
Delhi, CA 08SEP2016 Jose Torres 38 Hispanic male replica shoot not No No
East Hollywood, CA 19AUG2016 Marcelo Luna 47 Hispanic male gun threat not Yes No
El Cajon, CA 16JAN2016 Kelsey Rose Hauser 25 White female unarmed accident car No No
El Cajon, CA 27SEP2016 Alfred Olango 38 Black male unarmed point not Yes Yes
El Monte, CA 23DEC2016 Jose Sanchez 30 Hispanic male vehicle move car No No
Fair Oaks, CA 23SEP2016 Jesse Ataway 41 White male unarmed point foot No No
Florence, CA 16MAR2016 Cristian Rene Medina 23 Hispanic male unarmed move not Yes No
Florence, CA 01SEP2016 Joshua Quintero 23 Hispanic male gun threat foot No No
Fresno, CA 23MAR2016 Raymond Gonzalez 34 Hispanic male gun point foot No Yes
Fresno, CA 25JUN2016 Dylan Noble 19 White male unarmed move car Yes Yes
Fullerton, CA 03JUL2016 Pedro Villanueva 19 Hispanic male   threat car No No
Glendale, CA 13MAR2016 Gevork Alachadzhyan 45 White male   point car Yes No
Grass Valley, CA 27DEC2016 Dustin Kirk 35 White male gun point not No No
Hacienda Heights, CA 15DEC2016 Robert James Hess 60 White male gun point not No No
Hayward, CA 13AUG2016 Eric Ortega Soto 36 Hispanic male   threat car No No
Hemet, CA 20DEC2016 Nick Hamilton 31   male gun threat other No No
Hollywood Hills, CA 16JAN2016 Alfred Longoria 34 Hispanic male replica threat foot No No
Huntington Park, CA 01SEP2016   Hispanic male blunt_object threat not No No
Indio, CA 20AUG2016 Pedro Montanez 71 Hispanic male knife threat not Yes Yes
Inglewood, CA 21FEB2016 Kisha Michael 31 Black female gun threat not No No
Inglewood, CA 21FEB2016 Marquintan Sandlin 32 Black male undetermined accident not No No
Irvine, CA 10OCT2016 Maurico Barron 27 Hispanic male unarmed move not Yes No
La Mirada, CA 22NOV2016 Mark Daniel Sly 45 White male gun shoot not No No
La Quinta, CA 28JUL2016 Jeffrey Smith 47 Black male undetermined threat car No No
Lake Elsinore, CA 15APR2016 Clemente Najera 38 Hispanic male blunt_object threat not No No
Lancaster, CA 11FEB2016 Matthew Quinn 45 White male blunt_object threat not No No
Lincoln, CA 25OCT2016 Brandon Millard 37 White male knife threat not Yes No
Lompoc, CA 21NOV2016 Michael Giles 27 White male knife threat foot Yes No
Long Beach, CA 10MAR2016 Martin Hurtado 21 Hispanic male gun threat foot No No
Long Beach, CA 08MAY2016 Lionel Gibson 21 Black male replica threat not No No
Long Beach, CA 28JUN2016 Barry Prak 27 Asian male knife threat foot No No
Long Beach, CA 04SEP2016 Jose Romero 39 Hispanic male knife threat not Yes No
Los Angeles, CA 06FEB2016 Jose Mendez 16 Hispanic male gun point car No Yes
Los Angeles, CA 14FEB2016 Eduardo Rodriguez 29 Hispanic male gun threat not No No
Los Angeles, CA 30MAR2016 Angel Montion 33 White male gun point foot No No
Los Angeles, CA 10APR2016 Arturo Yobani-Torrez Valdez 28 Hispanic male knife attack not No No
Los Angeles, CA 30APR2016 Marion Habana 28 Asian male knife threat not No Yes
Los Angeles, CA 10JUN2016 Keith Bursey Jr. 31 Black male gun shoot not No No
Los Angeles, CA 25JUL2016 Richard Risher Jr. 18 Black male gun shoot foot No No
Los Angeles, CA 09AUG2016 Jesse James Romero 14 Hispanic male gun shoot foot No Yes
Los Angeles, CA 16AUG2016 Kenney Watkins 18 Black male gun threat foot No No
Los Angeles, CA 01OCT2016 Carnell Snell Jr. 18 Black male gun threat foot No Yes
Los Angeles, CA 02OCT2016 Daniel Perez 16 Hispanic male replica point not Yes Yes
Los Angeles, CA 28NOV2016 Pablo Renato Cartagena 23 Hispanic male gun threat foot No No
Los Angeles, CA 17DEC2016 Fidel Barrios 33 Hispanic male gun threat not No No
Los Angeles, CA 18DEC2016 Ryan Joseph 20 Black male gun threat foot No No
Maywood, CA 11JUN2016 Jesus Duran 31 Hispanic male knife threat not No No
McKinneyville, CA 18AUG2016 David Fulton 59 White male gun shoot not Yes No
Modesto, CA 10APR2016 Lonnie Ball 39 White male gun threat car No No
Modesto, CA 08OCT2016 Kim Jackson 53 White female knife attack not No No
Newark, CA 31JAN2016 Jeffry Graves 62   male gun point not Yes No
Newark, CA 11MAR2016 Teodoro Valencia 23 Hispanic male gun point foot No No
North Hills, CA 17JAN2016 Efrain Herrera Jr. 24 Hispanic male knife threat not No No
Palm Springs, CA 04NOV2016 Abraham Ortiz 26 Hispanic male unarmed threat not No No
Pico Rivera, CA 24DEC2016 Zhonghua Li 48 Asian male knife attack not Yes No
Poway, CA 18AUG2016 Trenton Lohman 38 White male gun point car No No
Rancho Cordova, CA 02FEB2016 Justin Prescott 30 White male knife threat not Yes No
Redding, CA 05JAN2016 Stephen Bukwich 52 White male gun threat not Yes No
Redding, CA 16NOV2016 Edmund Leighty Sr. 56 White male gun threat not No No
Redlands, CA 24MAR2016 Andrew Mike 29 White male gun shoot not No No
Ripon, CA 23FEB2016 Angel Alan Gleason 36 Hispanic male gun threat other No No
Sacramento, CA 08APR2016 Dazion Flenaugh 40 Black male knife threat foot Yes No
Sacramento, CA 11JUL2016 Joseph Mann 50 Black male knife threat not Yes Yes
Sacramento, CA 28OCT2016 Jason King 38 Black male gun point not Yes No
San Bernardino, CA 16JUL2016 Cody Wayne Jarrett 26 White male gun attack other No No
San Bernardino, CA 27JUL2016 Saddam Trejeda-Campos 24 Hispanic male knife threat not Yes No
San Bernardino, CA 29AUG2016 Michael Peacor 56 White male knife attack not No No
San Diego, CA 01JAN2016 Joshua Sisson 30 White male knife threat not No Yes
San Diego, CA 11MAY2016 Thongsoune Vilaysane 33 Asian male   move car No Yes
San Diego, CA 13NOV2016 Juan Carlos Fernandez 22 Hispanic male gun shoot not No Yes
San Fernando, CA 11JAN2016 Alan Paul Bartley 56 White male   attack car No No
San Francisco, CA 07APR2016 Luis Gongora 45 Hispanic male knife threat not No No
San Francisco, CA 19MAY2016 Jessica Nelson-Williams 29 Black female unarmed flee car No No
San Francisco, CA 14OCT2016 Nicholas McWherter 26 White male gun shoot not Yes No
San Jose, CA 07MAR2016 Byron Rosas 45 Hispanic male knife threat not No No
San Jose, CA 04JUL2016 Anthony Nunez 18 Hispanic male gun threat not Yes No
Santa Ana, CA 18FEB2016 Jose Quintanilla 30 Hispanic male undetermined undetermined not No No
Santa Ana, CA 18FEB2016 Oscar Reyes 35 Hispanic male undetermined undetermined not No No
Santa Ana, CA 01AUG2016 Richard Swihart 32 White male undetermined attack not Yes No
Santa Ana, CA 06NOV2016 David Contreras Jr. 33 Hispanic male unarmed attack not No No
Santa Clarita, CA 14JAN2016 Miguel Hernandez 39 Hispanic male knife move not No No
Santa Cruz, CA 16OCT2016 Sean Arlt 32 White male other attack not Yes No
Santa Maria, CA 20JUL2016 Javier Garcia Gaona 31 Hispanic male knife threat not Yes No
Santee, CA 05AUG2016 David Michael Moya 31   male other attack not Yes No
Saratoga, CA 12SEP2016 Eugene Craig 86   male gun threat not No No
Siskiyou County, CA 17MAY2016 Luke Sanders 36 White male blunt_object threat not Yes No
Solvang, CA 26MAY2016 Fernando Castro 19 Hispanic male gun shoot car No No
South Gate, CA 06MAR2016 Osvaldo Torres 41 Hispanic male gun shoot other No No
Stockton, CA 13APR2016 Rodney Watts 35 Black male undetermined attack not No No
Stockton, CA 16AUG2016 Colby Friday 30 Black male gun threat foot No Yes
Stockton, CA 21DEC2016 Luis Ambrosio-Aguilar 30 Hispanic male knife undetermined not No No
Sylmar, CA 06APR2016 Cesar Frias 20 Hispanic male knife attack not Yes No
Temecula, CA 04MAY2016 Matthew Tucker 18 Black male knife threat not No No
Temecula, CA 05JUL2016 Sam Newby 49 White male undetermined move car No No
Temecula, CA 15NOV2016 Michael Cookson 48   male knife threat not No No
Torrance, CA 31OCT2016 Michelle Lee Shirley 39 Black female vehicle attack car Yes No
Turlock, CA 07JUN2016 Omar Villagomez 21 Hispanic male vehicle threat not No No
Union City, CA 18JAN2016 Vasilios Alexander Katsouras 29 White male blunt_object move not Yes Yes
Van Nuys, CA 14FEB2016 Rammy Jaradat 26 White male knife threat not No No
Visalia, CA 03MAY2016 Raymond Hopper 59 White male knife threat not No No
Vista, CA 11AUG2016 Sergio Daniel Weick 33 Hispanic male knife threat other No No
Watsonville, CA 19NOV2016 Luke Smith 15 Asian male knife threat foot No Yes
Whittier, CA 16NOV2016 Jose George Anthony Franco 37 Hispanic male knife threat not No No
Wildomar, CA 22OCT2016 Junef Monzon 31   male vehicle attack car No No
Winchester, CA 24JUL2016 Robert Lee Lourenco Jr. 36 White male gun;knife point not Yes No
Yorba Linda, CA 15FEB2016 Brandon Lee Witt 39 White male undetermined undetermined not No No
Yreka, CA 04JUN2016 Daniel Jonathan Shaham 31 White male undetermined attack 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?
Aurora, CO 11MAY2016 Stephen Schuster 35 White male gun point car No No
Bailey, CO 24FEB2016 Martin Wirth 58 White male gun shoot not Yes No
Boulder, CO 22MAY2016 Bryson Fischer 28 White male gun point not Yes No
Boulder, CO 10SEP2016 Adrian Joseph Shaffer 37 White male gun shoot not No Yes
Boulder, CO 05OCT2016 Brandon Simmons 28 White male knife threat not Yes No
Colorado City, CO 10MAR2016 German Gonzalez 23 Hispanic male   point car No No
Colorado Springs, CO 22JUN2016 Josiah Williams 25 White male gun shoot not No No
Colorado Springs, CO 23OCT2016 Demetrius Mac Moore 40 Black male gun shoot not No No
Denver, CO 11JAN2016 Ramone Lonergan 32 White male gun threat not No No
Denver, CO 22FEB2016 Gerardino Cayetano Gonzalez Jr. 33 Hispanic male gun shoot other No No
Denver, CO 12APR2016 Dion Daman 40 White male unarmed threat car No No
Denver, CO 27AUG2016 Terry Salazar 49   male knife threat not No No
Denver, CO 31AUG2016 Michael Ferguson 21 White male gun attack foot No No
Denver, CO 08NOV2016 Juan Ramos 23 Hispanic male gun shoot other No No
Evans, CO 25FEB2016 Luke Miller 37 White male gun shoot foot No Yes
Fort Collins, CO 30JAN2016 Philip B. Salazar 38 Hispanic male knife move not No No
Fort Collins, CO 25AUG2016 Jerry Lee Jackson 63 White male knife threat not No Yes
Grand Junction, CO 04SEP2016 Simon Gomez 44 Hispanic male knife threat not Yes No
Grand Junction, CO 11NOV2016 Brian Gaither 24 White male   attack car No No
Greeley, CO 11MAY2016 Sean Ryan Mondragon 24 Black male gun point car No No
Lakewood, CO 26APR2016 Robin Barber 28 White male gun shoot foot No No
Lakewood, CO 13AUG2016 Perry Lee Heitman 53 White male gun threat not No No
Montrose County, CO 11NOV2016 William Ray Score Jr. 47   male gun shoot not No No
Park County, CO 30JUN2016 Tristan Vilters 24 White male gun shoot not No No
Parker, CO 02SEP2016 Randall Rodick 40   male gun shoot car Yes Yes
Pueblo, CO 24MAR2016 Joel A. Gonzales 48 Hispanic male gun;knife move not No Yes
Pueblo, CO 10JUN2016 Bobby Sanchez 32 Hispanic male gun point foot No No
Thornton, CO 23MAR2016 Daven Scott Hannu 51 White male gun shoot not No No
Westminster, CO 27APR2016 Damon Blair 21 White male gun shoot not No No
Westminster, CO 16JUN2016 Nicholas Damon 30 Hispanic male   attack car No No
Westminster, CO 20SEP2016 Thomas Tucker Jr. 49 White male gun threat foot No No

statecode=CT

statecode=DC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=DC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Washington, DC 01FEB2016 Peter John 36 Black male replica attack foot No No
Washington, DC 27JUN2016 Sherman Evans 63 Black male replica point not Yes Yes
Washington, DC 04JUL2016 Sidney Washington 21 Black male gun shoot not No No
Washington, DC 11SEP2016 Terrence Sterling 31 Black male vehicle attack other No No
Washington, DC 25DEC2016 Gerald Hall 29 Black male knife threat not No Yes

statecode=DE

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=DE

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Frederica, DE 27JUN2016 Raymond Hutson 25 White male replica threat 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?
Belle Glade, FL 16JAN2016 Henry Bennett 19 Black male gun point foot No No
Bradenton, FL 14FEB2016 Marc Stoddart 50 White male knife threat not Yes No
Cape Coral, FL 05JUN2016 Christopher Michael Moran 31 White male gun threat car No No
Deland, FL 29MAY2016 Donald Edward Brown III 32 White male knife threat not No No
Fort Pierce, FL 23APR2016 Demarcus Semer 21 Black male   attack car No No
Fort Walton Beach, FL 19JUN2016 Anthony Ford 30   male gun threat not No No
Fort Walton Beach, FL 18NOV2016 Joseph Leland Fletcher 35 White male gun threat not Yes No
Fruitland Park, FL 06DEC2016 Wayne Donald Dorsey 49 White male blunt_object attack other No No
Gainesville, FL 20MAR2016 Robert Dentmond 16 Black male replica threat not Yes No
Hallandale Beach, FL 22MAY2016 Michael Eugene Wilson Jr. 27 Black male unarmed flee car No Yes
Hog Valley, FL 09MAY2016 Joseph Napoli 59   male gun shoot not No No
Holiday, FL 17OCT2016 Eric St. Germain 39 White male knife threat not Yes No
Homestead, FL 20APR2016 Francis Scot Dufore 41 White male gun point not No No
Immokalee, FL 31JAN2016 Juan A. Ruiz 46 Hispanic male knife threat not No No
Jacksonsville, FL 14MAY2016 Cody Marsh 19 White male knife threat not Yes No
Jacksonville, FL 22MAY2016 Vernell Bing Jr. 22 Black male unarmed move car No No
Jacksonville, FL 20OCT2016 Jacob DePetris 29 White male gun point not No No
Lake Asbury, FL 16JUL2016 Billy D. Smith 31 White male gun point not Yes No
Lake Wales, FL 24DEC2016 Miriam Ann Savino 53 White female knife threat not No No
Lakeland, FL 08SEP2016 Francis Perry 32 White male gun shoot not No No
Lakeland, FL 10NOV2016 John Pacuicrk 53 White male gun point not No No
Lealman, FL 05NOV2016 John F. Zemola 49 White male knife threat not Yes No
Lealman, FL 23NOV2016 William J. Beavers 43 White male knife threat not No No
Loxahatchee, FL 31DEC2016 Ricky Whidden 46 White male knife attack not Yes No
Miami, FL 22MAR2016 Ethan James Rincon 25 Hispanic male blunt_object threat not Yes No
Miami, FL 28APR2016 Kendar del Rosario 37 Black male knife attack not No No
Miami, FL 19MAY2016 Kentrill William Carraway 22 Black male gun threat not No No
Miami, FL 17OCT2016 Rolando Delgado 50 Hispanic male knife threat not Yes No
Miami, FL 30DEC2016 Jamal Rollins 21 Black male gun threat car No No
Miami Gardens, FL 25MAY2016 Doll Pierre-Louis 24 Black male   threat car No No
Middleburg, FL 25DEC2016 Michael Alan Altice 61 White male gun point not Yes No
Milton, FL 05FEB2016 Blake Edward Fitzgerald 30 White male gun threat car No No
Noma, FL 12APR2016 Travis Wood 20 White male   threat car No Yes
Ocala, FL 03FEB2016 Cristiaan Oliver Dubrino 31 Hispanic male gun shoot not Yes No
Orange City, FL 06DEC2016 Westley Daum 47 White male gun point not No No
Orlando, FL 18JAN2016 Eric Provost 28 White male replica threat not No No
Orlando, FL 01MAY2016 Charlin Charles 25 Black male replica point not No No
Orlando, FL 05MAY2016 Deresha Armstrong 26 Black female gun point not No No
Orlando, FL 12JUN2016 Omar Mateen 29 Other male gun shoot not Yes Yes
Orlando, FL 24AUG2016 William Charbonneau 43 White male gun threat not Yes No
Osteen, FL 14MAY2016 Jeffrey Sims 59 White male gun point not No No
Palm Bay, FL 01MAR2016 Dimitri Corcino 39 Hispanic male gun point not Yes No
Palm Bay, FL 02AUG2016 DeMarco Newman 43 Black male gun shoot not Yes No
Palm Harbor, FL 22DEC2016 Stanley D. Eversole 55   male other point not No No
Pensacola, FL 31DEC2016 Daniel Ralph Daily Sr. 57   male gun shoot not No No
Pinellas Park, FL 25JUN2016 Waldemar Bogusiewicz 59 White male gun shoot not No No
Pompano Beach, FL 09SEP2016 Gregory Frazier 55 Black male knife threat not No No
Port Saint Lucie, FL 20SEP2016 Joshua Scott 22 White male gun shoot not Yes No
Port Saint Lucie, FL 18NOV2016 Samson Fleurant 25 Black male knife threat not Yes No
Riverview, FL 24JUN2016 Jamil Alejandro Valladares 26 Hispanic male gun shoot not No No
Riverview, FL 04OCT2016 Isaias Salgado 31 Hispanic male blunt_object attack foot No No
Saint Petersburg, FL 07MAY2016 Alton Fitzgerald Witchard 37 Black male gun point other No No
Sneads, FL 26MAY2016 Tonnia Reshelle Jarvis 48 White female knife threat not No No
Tampa, FL 08MAR2016 Jeffrey Glen Casale 27 White male replica point not Yes No
Tampa, FL 17MAR2016 Sunny Chin 53 Asian male gun shoot not No No
Tampa, FL 26MAR2016 Patrick Matthew McManamon 46 White male gun shoot not Yes No
Tampa, FL 30AUG2016 Levonia Riggins 22 Black male unarmed move not No No
Titusville, FL 07SEP2016 Jesse Daniel Joynt 35 White male undetermined threat not No No
Weeki Wachi, FL 15SEP2016 Joseph Allen Schlosser 69 White male gun threat not Yes No
Wellington, FL 22JUN2016 Roger Ponce 37 Hispanic male knife threat not No No

statecode=GA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=GA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Acworth, GA 08JAN2016 Andrew Earl Abernathy 50 White male gun point not Yes No
Albany, GA 07SEP2016 Robert Lee Brown 55 Black male knife attack not No No
Atlanta, GA 27APR2016 Cin Lam Mung 34 Asian male knife threat not No No
Atlanta, GA 22JUN2016 Deravis Caine Rogers 22 Black male unarmed undetermined other No Yes
Cartersville, GA 01JUL2016 Steven McQueen 30 White male gun point not No No
Cobb County, GA 27JAN2016 Israel Vladimir Rodriguez 26 Hispanic male gun shoot car No No
Cochran, GA 27JUN2016 Blake Peacock 32 White male gun point not No No
Commerce, GA 18FEB2016 Joseph Noel 25 White male undetermined threat not No No
East Point, GA 05AUG2016 Jamarion Rashad Robinson 26 Black male gun shoot not Yes No
East Point, GA 11NOV2016 Andrew Depeiza 30 Black male unarmed attack foot No No
Elberton, GA 27OCT2016 Edwin Amaya Maldonado 24 Hispanic male undetermined attack foot No No
Fort Valley, GA 12DEC2016 Rainer Tyler Smith 31 White male gun shoot not No No
Gainesville, GA 25JUN2016 Rodrigo Guardiola 36 Hispanic male unarmed attack other No No
Hampton, GA 13DEC2016 Earl Labon Eubanks Jr. 32 Black male gun threat not Yes No
Jackson, GA 30MAR2016 Thomas Lagano 52 White male gun point not No No
Loganville, GA 03NOV2016 Rita King 56 White female gun point not No No
Ludowici, GA 18NOV2016 Dontrell Montrese Carter 25 Black male gun shoot not No No
Mableton, GA 18APR2016 Demetrius Dorsey 18 Black male gun shoot not No No
Macon, GA 07OCT2016 Larry Daniel Matthews 57 Black male other threat not No No
Newnan, GA 01JUN2016 Michael Johnson 21 Black male gun shoot foot No Yes
Riverdale, GA 11FEB2016 Jerand Edward Ross 24 Black male gun shoot foot No No
Riverdale, GA 16MAY2016 Jabril Robinson 23 Black male gun point foot No No
Rossville, GA 30JAN2016 Jose Alegre 64 Hispanic male gun shoot not Yes No
Stockbridge, GA 14MAY2016 Ryan Johnson 34 White male gun threat not Yes No
Stockbridge, GA 07JUN2016 William David Powell 63 White male gun point not No No
Valdosta, GA 19JAN2016 Jim Redmond 28 White male gun point not Yes No
Valdosta, GA 28SEP2016 Johnathan Lozano-Murillo 28 Hispanic male knife attack not No Yes

statecode=HI

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=HI

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Hilo, HI 05FEB2016 Ronald Barawis Jr. 38 Asian male   threat car No No
Hilo, HI 09FEB2016 Scottie Yanagawa 29 Asian male gun shoot not No No
Hilo, HI 06JUN2016 Kalyp Allen Rapoza 25 Asian male knife threat not No No
Hilo, HI 21JUL2016 BJ Medeiros 36 Hispanic male gun point not Yes No
Honolulu, HI 28JUN2016 Walden Dang 61 Asian male knife attack not No No
Keaau, HI 09DEC2016 Stephen Joshua Whitney 30 Asian male   threat not No No

statecode=IA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=IA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boone, IA 27JUN2016 Michael Disbrowe 28 White male replica point not Yes No
Cedar Rapids, IA 12SEP2016 Markell Bivins 25 Black male knife attack not No No
Fort Madison, IA 29JUN2016 Lafayette Evans 37 Black male gun shoot foot No No
Sioux City, IA 07DEC2016 Daniel Riedmann 36 White male undetermined move not No No
Urbandale, IA 13FEB2016 Ali Eisa Abdalla Yahia 29 Black male gun shoot not 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 28APR2016 Lee Easter 53 White male gun point not Yes Yes
Boise, ID 14JUN2016 Noel Rodriguez 50 Hispanic male   threat car No Yes
Boise, ID 11NOV2016 Marco Romero 33 Hispanic male gun shoot other No No
Garden City, ID 26SEP2016 Anthony Ray Bauer 52 White male gun point other No No
Hammett, ID 02AUG2016 Matthew David Conrad 34 White male gun point car Yes No
Idaho Falls, ID 18MAR2016 David Alma Giles 60 White 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?
Antioch, IL 16APR2016 Gerald Robert Boyes 53 White male gun point not No No
Belleville, IL 23JUN2016 Angelo Brown   Black male gun shoot foot No No
Benton, IL 12APR2016 Joshua Moreno 38 Hispanic male gun shoot car No No
Chicago, IL 30JAN2016 Charles M. Smith 29 Black male gun shoot not No No
Chicago, IL 14MAR2016 Lamar Harris 29 Black male gun shoot foot No No
Chicago, IL 19MAR2016 Thurman Reynolds 21 Black male gun shoot foot No No
Chicago, IL 11APR2016 Pierre Loury 16 Black male gun point foot No No
Chicago, IL 09MAY2016 Michael Johnson 26 White male gun threat foot No No
Chicago, IL 21JUL2016 Derek Love 50 Black male gun shoot not No No
Chicago, IL 28JUL2016 Paul O'Neal 18 Black male unarmed threat car No Yes
Chicago, IL 18NOV2016 Darius Jones 26 Black male gun shoot not No No
Chicago, IL 23NOV2016 Kajuan Raye 19 Black male gun threat foot No Yes
Chicago, IL 25NOV2016 Cleotha Mitchell 37 Black male gun shoot   No No
Chicago, IL 27NOV2016 Richard Grimes 33 Black male gun shoot foot No No
Clinton, IL 11MAR2016 Jack Goodman 46 White male knife threat not Yes No
Dolton, IL 26JUN2016 Donte L. Johnson 30 Black male gun point not No No
East Saint Louis, IL 11JUL2016 Jason Brooks 41 Black male gun shoot not No No
Hurst, IL 14JAN2016 Willie Holderfield 40 White male gun point not Yes No
Lansing, IL 26MAY2016 Warren Christian 43 White male gun shoot foot No No
Markham, IL 02OCT2016 Donte T. Jones 36 Black male unknown threat not No No
Metropolis, IL 03SEP2016 Donny Max Daugherty 36 White male gun shoot other No No
North Riverside, IL 27DEC2016 Alfonso Lopez 41 Hispanic male knife point not No No
Round Lake, IL 02SEP2016 Michael Robert Musson 22 White male knife threat not No No
Shawnee National Forest, IL 15MAY2016 Dracy "Clint" Pendleton 35 White male gun shoot foot No No
Washington Park, IL 26MAY2016 Devonte Gates 21 Black male undetermined undetermined foot No No
Zion, IL 06JAN2016 Charles Hollstein 38 White male replica threat foot 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?
Avon, IN 29NOV2016 Bradley King 29 White male knife threat not Yes No
Elkhart, IN 04DEC2016 Norman Gary 29 Black male gun shoot car No No
Evansville, IN 15MAR2016 Daniel J. Wooters 38 White male knife move car No Yes
Fort Wayne, IN 20MAR2016 Abraham Martinez 62 Hispanic male gun shoot foot No No
Fort Wayne, IN 07OCT2016 Joseph S. Schroeder 36 White male knife threat not No No
Fort Wayne, IN 08OCT2016 Charles Antrup 62 White male knife threat not No No
Greenwood, IN 10DEC2016 Samson G. Varner 36 White male knife threat not No Yes
Indianapolis, IN 02APR2016 Cameron Gover 30 Black male gun point not No No
Indianapolis, IN 05APR2016 Kevin Hicks 44 Black male unarmed attack not No Yes
Indianapolis, IN 27MAY2016 Terry Edwards 59 White male gun point not No No
Indianapolis, IN 25JUL2016 Jeff Cornell Tyson 32 Black male gun shoot car No No
Knox, IN 21DEC2016 William Newman 46   male   threat   No No
Muncie, IN 15APR2016 Storm Allen Smith Jr. 26 White male undetermined attack foot No Yes
Muncie, IN 04JUN2016 Larry Dustin Stepp 31 White male knife threat not Yes Yes

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?
Hays, KS 18AUG2016 Joseph Weber 36 White male undetermined flee car No No
Hays, KS 08NOV2016 Kenton Kobza 19 White male unarmed attack car No No
Hesston, KS 25FEB2016 Cedric Ford 38 Black male gun shoot not Yes No
Hutchinson, KS 06DEC2016 Richard R. Jones 55 White male gun point not No No
McPherson, KS 14APR2016 Jeff Robertson 54 White male unarmed attack not Yes No
Medicine Lodge, KS 11DEC2016 Gary Leon Herd Jr. 24 White male gun shoot not No No
Olathe, KS 27NOV2016 Walter R. Echols 50 White male blunt_object attack not No No
Rosalia, KS 11MAR2016 Manford "Butch" Moore Jr. 51 White male gun point not Yes Yes
Topeka, KS 07MAR2016 Randall J. Selsor 45 White male undetermined undetermined not No No
Wichita, KS 01SEP2016 Caleb J. Douglas 18 White male gun threat car No Yes

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?
Barbourville, KY 29JUN2016 Jessie J. Mills 30 White male unarmed attack not No No
Berea, KY 01JUN2016 Daniel Pigg 51 White male gun shoot foot No No
Bowling Green, KY 06NOV2016 Randy J. Clark Jr. 43 White male   threat car No No
Daviess County, KY 06JAN2016 Kenneth Clay 34 White male gun point not No No
East Bernstadt, KY 04MAR2016 Brandon Stanley 30 White male unarmed undetermined not No No
Edmonton, KY 23OCT2016 Kenny Tomblin 38 White male gun shoot not No No
Fisty, KY 19MAY2016 Timothy Brandon Stacy 36 White male gun point not No No
Georgetown, KY 08AUG2016 Juan J. Godines 34 Hispanic male gun point other No No
Hiseville, KY 12JUN2016 John Williams 61 Black male gun shoot car No No
Louisville, KY 10FEB2016 Timothy Vessels 41 White male gun point not No No
Louisville, KY 08AUG2016 Darnell Wicker 57 Black male knife threat not No Yes
Morehead, KY 12OCT2016 Matthew Brewer 22 White male gun point not No No
Owensboro, KY 16SEP2016 Lucas Anderson 29 White male knife attack not No No
Paris, KY 18OCT2016 Charles Stidham 34 White male gun shoot not No No
Phelps, KY 31JUL2016 John Casey 32 White male blunt_object attack foot No No
Russellville, KY 15MAR2016 Joseph Harris 34 White male gun threat foot No No
Simpsonsville, KY 02DEC2016 Dylan M. Dalzell 22 White male blunt_object threat not No No
White Plains, KY 19MAR2016 Dylan R. Whitaker 23 White male gun shoot other 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?
Alexandria, LA 07OCT2016 Christopher Darnell Shackleford   Black male gun shoot not No No
Baton Rouge, LA 13FEB2016 Calvin Smith 22 Black male gun shoot car Yes Yes
Baton Rouge, LA 23FEB2016 Travis Stevenson 48 Black male   attack not Yes No
Baton Rouge, LA 05JUL2016 Alton Sterling 37 Black male undetermined undetermined not No Yes
Baton Rouge, LA 17JUL2016 Gavin Eugene Long 29 Black male gun shoot not Yes No
Baton Rouge, LA 27NOV2016 Terrell Walker 48 Black male gun shoot not No No
Covington, LA 19MAR2016 Joshua Douglas 24 White male undetermined undetermined car No No
Gretna, LA 05MAY2016 Corey DiGiovanni 36 White male   attack car No No
Houma, LA 02NOV2016 Wilton Henry 59 White male gun point not Yes Yes
Livingston Parish, LA 12OCT2016 Blaine J. Beason 31 White male gun point not No No
Metairie, LA 27JUL2016 Devon Martes 17 Black male gun point foot No No
Metairie, LA 03DEC2016 Isreal Flores 38   male gun shoot foot No No
New Iberia, LA 03JUL2016 Shannon Labit 40 White male knife threat not Yes No
New Orleans, LA 08FEB2016 Eric Harris 22 Black male   threat car No No
Ouachita Parish, LA 29JUN2016 Tyrone Reado   Black male gun point not No No
Plaquemine, LA 11AUG2016 Tommy Seneca 54 White male gun point not No No
Port Barre, LA 20JAN2016 Timothy Albert 40 Black male gun point not No No
Raceland, LA 03APR2016 Preston Paul Perez Sr. 48 White male unarmed undetermined   No No
Ragley, LA 04JAN2016 Eric John Senegal 27 Black male unknown undetermined not No No

statecode=MA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boston, MA 12FEB2016 Peter Fanfan 29 Black male gun shoot not Yes No
Boston, MA 12OCT2016 Kirk Figueroa 33 Black male gun shoot not No No
Boston, MA 30OCT2016 Terrence Coleman 31 Black male knife threat not Yes No
Braintree, MA 24MAR2016 Robert L. Dussourd 44 White male knife threat foot No No
Everett, MA 21APR2016 Mario Mejia Martinez 48 Hispanic male knife threat not No No
Lowell, MA 26MAR2016 Jose Perez 39 Hispanic male knife threat not Yes No
Lynn, MA 29JAN2016 Randolph McClain 33 Black male gun point other No No
Lynn, MA 03OCT2016 Robert Dapkus 57 White male gun point not No No
Lynn, MA 29NOV2016 Michael McInnis 41 White male unarmed move not No No
Oxford, MA 22MAY2016 Jorge Zambrano 35 Hispanic male gun shoot not No No
Taunton, MA 10MAY2016 Arthur DaRosa 28 Black male knife attack not Yes No
West Springfield, MA 05APR2016 Peter J. Doherty 52 White male knife threat not Yes No

statecode=MD

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MD

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Abingdon, MD 10FEB2016 David Brian Evans 67 White male gun shoot not No No
Baltimore, MD 31MAR2016 Kimani Johnson 18 Black male gun point not No No
Baltimore, MD 31MAR2016 Matthew Vincent Wood Jr. 43 Black male gun point not No No
Baltimore, MD 14JUL2016 Dayten Ernest Harper 33 Black male gun shoot not No No
Baltimore, MD 13DEC2016 Lavar Montray Douglas 18 Black male gun shoot not No No
Bel Air, MD 02MAR2016 Travis Boyd Bradley 36 White male unarmed move not Yes No
Capitol Heights, MD 22DEC2016 Terrence Thomas 19 Black male gun point not No No
Chestertown, MD 29DEC2016 James L. Rich II 52 Black male gun shoot not No Yes
Elkton, MD 25OCT2016 Brandon Jones 25 White male replica point not Yes No
Elkton, MD 25OCT2016 Chelsea M. Porter 25 White female replica point not No No
Greenbelt, MD 18APR2016 Rico Don Rae Johnson 28 Black male gun shoot not No No
Landover, MD 13MAR2016 Jacai Colson 28 Black male gun accident not No No
Pikesville, MD 23SEP2016 Oddis Bernard Colvin Jr. 33 Black male   threat not No Yes
Randallstown, MD 01AUG2016 Korryn Gaines 23 Black female gun point not No No
Rising Sun, MD 10JAN2016 Christine A. Lucas 45 White female replica point not Yes 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?
Naples, ME 27NOV2016 Norman J. Strobel 59 White male gun shoot not No No
Presque Isle, ME 07MAY2016 Derek J. Sam 29 White male knife threat 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?
Belleville, MI 30SEP2016 Richard Parent 37 White male gun point other No No
Benton Harbor, MI 18OCT2016 Darius Wimberly 28 Black male gun shoot not No Yes
Columbia Township, MI 26JUN2016 Terry Lynn Maurer 51 White male blunt_object attack not Yes No
Dearborn, MI 27JAN2016 Janet Wilson 31 Black female vehicle threat car Yes No
Detroit, MI 03AUG2016 Bradley Carey 54 White male knife attack not No No
Hessel, MI 04OCT2016 Dean Bruning 51 White male gun threat not Yes No
Ishpeming Township, MI 09JUN2016 Clifford Tucker 68 White male gun point not Yes Yes
Kentwood, MI 08APR2016 Lamont Gulley 43 Black male knife move not No Yes
Romulus, MI 11JUL2016 Pablo Medina 41 Hispanic male gun point not No No
Saint Joseph, MI 11JUL2016 Larry Darnell Gordon 44 White male gun shoot not No No
Southfield, MI 15JAN2016 Rakeem Bentley 24 Black male gun shoot not No No
Wyoming, MI 07SEP2016 Sadiq Bishara-Abaker Idris 25 Black male gun point not No No

statecode=MN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aitkin, MN 29MAR2016 Denise Fairchild 50 White female gun shoot not Yes No
Alexandria, MN 02AUG2016 Adam Jo Klimek 31 White male knife threat not No No
Burnsville, MN 17MAR2016 Map Kong 38 Asian male gun move not Yes Yes
Burnsville, MN 26SEP2016 Jamie Joseph Lewis 48 White male gun threat not Yes Yes
Eagan, MN 28AUG2016 Justin Kulhanek-Derks 37 White male gun shoot not Yes No
Falcon Heights, MN 06JUL2016 Philando Castile 32 Black male gun move not No Yes
Mankato, MN 31DEC2016 Chase Anthony Tuseth 33 White male unarmed attack not No No
Minneapolis, MN 04APR2016 Raul Salvador Marquez Heraldes 50 Hispanic male knife attack not Yes No
Morris, MN 28OCT2016 Jay Johannes Holmgren 37 White male gun point other No No
Peterson, MN 23OCT2016 Kristofer Daniel Youngquist 45 White male replica point not No No
Roseville, MN 10FEB2016 John Birkeland 52 White male knife attack not Yes Yes
Saint Cloud, MN 17SEP2016 Dahir Adan 22 Black male knife attack not No No
Saint Paul, MN 09MAY2016 Jaffort Smith 33 Black male gun shoot not No No
Saint Paul, MN 26MAY2016 Eugene "Geno" Francis Smith 29 White male gun shoot 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?
Big Bear, MO 16SEP2016 Thomas P. Mone III 46   male gun shoot not No No
Blue Springs, MO 24FEB2016 Robert Keil 16 White male knife threat not Yes No
Blue Springs, MO 24MAR2016 Jermon Seals 22 Black male gun point not No No
Buffalo, MO 04MAY2016 Gerry J. Thompson 40 White male undetermined attack not No No
Harrisonville, MO 24MAY2016 Leslie Goletz 57   male other move car No No
Jackson, MO 29APR2016 Jeffrey Darrell Hobbs 48 White male   attack car No No
Kansas City, MO 04FEB2016 Scott Harless 47 White male gun point foot No No
Kansas City, MO 08JUN2016 Carlos Garcia 43 Hispanic male gun point not No No
Kansas City, MO 20NOV2016 Jacob C. Stevens 18 White male gun threat foot No No
Kansas City, MO 30NOV2016 David K. Crosby-Dowdy 25 Black male gun move not No No
Lee's Summit, MO 27MAR2016 Jeffrey Lanahan 34 White male knife threat not Yes No
McDowell, MO 31AUG2016 Thomas E. Sekscinski 38 White male   threat car No No
North Saint Louis, MO 24OCT2016 Aaron Marquis Ballard 19 Black male gun point car No No
Odessa, MO 14JUN2016 Nicholas Ferro 47 White male gun point not No No
Republic, MO 16FEB2016 Destry Meikle 48 White male   attack car No No
Saint Louis, MO 17JAN2016 Crayton West 52 Black male gun point not No No
Saint Louis, MO 19APR2016 Jorevis Scruggs 15 Black male gun point other No No
Saint Louis, MO 02SEP2016 Michael Thompson Jr. 38 Black male gun shoot other No No
Saint Louis, MO 21NOV2016 George Bush III 19 Black male gun shoot foot No No
Sugar Creek, MO 30JAN2016 Jeremy J. Sinclair 42 White male gun shoot car No No
Sullivan, MO 18MAY2016 Joseph Weatherby 44 White male gun point other 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 10MAR2016 Wesley Sheppard 37 White male replica threat not No No
Gautier, MS 01MAR2016 Mickey Dewayne Sweatt 37 White male gun shoot not No No
Hattiesburg, MS 25NOV2016 Jerome Chris Harmon 23 Black male gun shoot other No No
Iuka, MS 20FEB2016 Charles Lee Lambert 45 White male gun shoot not Yes No
Saint Martin, MS 09MAY2016 Christian Bowman 23 White male unarmed attack not No No
Tupelo, MS 11JUN2016 Lyndarius Cortez Witherspoon 27 Black male gun shoot car No No
Tupelo, MS 18JUN2016 Antwun Shumpert 37 Black male unarmed attack foot No No
Walls, MS 22JUN2016 Quencezola Maurice Splunge 44 Black male gun shoot foot 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 07MAR2016 John Charles "JC" Graham 42 White male gun shoot not No No
Billings, MT 27OCT2016 Kyle Killough 32 White male gun threat not Yes No
Butte, MT 16JUN2016 Peter Grandpre 36 White male gun shoot not No Yes
Livingston, MT 02JAN2016 Sean O'Brien 37 White male knife threat not No No
Malta, MT 27JUL2016 Emil Ambrose Mecklenburg 20 White male knife attack not No No

statecode=NC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Anson County, NC 16MAR2016 Dennis Penny 40 White male gun shoot not Yes No
Asheville, NC 02JUL2016 Jai Lateef Solveig Williams 35 Black male gun threat car No No
Charlotte, NC 03JAN2016 Germonta Wallace 30 Black male gun shoot not No No
Charlotte, NC 05JAN2016 Carlton Antonio Murphy 33 Black male gun shoot not No No
Charlotte, NC 19APR2016 Sylasone Ackhavong 41 Asian male gun point not Yes No
Charlotte, NC 02JUN2016 Rodney Rodriguez Smith 18 Black male gun threat not No Yes
Charlotte, NC 18AUG2016 Daniel Kevin Harris 29 White male unarmed move car No Yes
Charlotte, NC 20SEP2016 Keith Lamont Scott 43 Black male gun threat not No Yes
Clinton, NC 29MAY2016 John Mark Coffey 53 White male gun point not No Yes
Durham, NC 22NOV2016 Frank Nathaniel Clark 34 Black male gun shoot not No No
East Flat Rock, NC 25APR2016 Kay Frances Campbell 60 White female gun shoot not Yes No
Fayetteville, NC 07DEC2016 Mark Anthony Hicks 31 Black male knife threat not No Yes
Granite Falls, NC 19DEC2016 Roy Minton 52 White male gun threat not No No
Greensboro, NC 12MAR2016 Christopher Michael Tokazowski 43 White male gun shoot not Yes Yes
Hickory, NC 28NOV2016 Irecas Valentine 41 Black male   threat car No No
Iredell County, NC 10JUN2016 Clayton Millsaps 29 White male blunt_object threat not No No
Kinston, NC 27MAR2016 Deriante Deon Miller 18 Black male gun move not No No
Lawndale, NC 21JUN2016 Pedro Cruz-Amado 24 Hispanic male other attack not Yes No
Leland, NC 09DEC2016 Brent Quinn 43 White male gun shoot not No No
Lenoir, NC 16AUG2016 Carl Nivens 32 White male gun shoot foot No Yes
Lumberton, NC 10OCT2016 Dennis Hunt 50   male gun threat not No No
Maiden, NC 11FEB2016 Alijah Jackson 35 White male knife threat not Yes No
Peachland, NC 15JUL2016 Bobby Horne 63 White male gun point not Yes No
Pleasant Hill, NC 29JUL2016 Melvin Faison 59 White male gun point not No No
Raleigh, NC 29FEB2016 Akiel Denkins 24 Black male gun attack foot No No
Raleigh, NC 29AUG2016 Jaqwan Julius Terry 24 Black male gun shoot foot No No
Rutherfordton, NC 17SEP2016 William Joseph Ryan 55 White male gun shoot not Yes No
Salisbury, NC 03NOV2016 Ferguson Laurent 23 Black male gun shoot not No No
Statesville, NC 19JAN2016 Samuel Grady 55 White male knife threat not Yes No
Stoneville, NC 29MAY2016 Todd Brent Burroughs 38 White male unarmed threat car No No
Union Grove, NC 05FEB2016 Vinson Ray Strickland 51 White male gun shoot foot No No
Wilkesboro, NC 08AUG2016 James Eugene Burgess 64 White male gun shoot not No No

statecode=ND

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=ND

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bismarck, ND 06MAR2016 James Scott 42 White male unarmed flee foot No No

statecode=NE

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NE

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Lincoln, NE 26JUN2016 Germichael Kennedy 22 Black male gun shoot foot No No
Louisville, NE 21SEP2016 Austin M. Baier 23 White male unarmed move not No No
Omaha, NE 28JAN2016 William A. Adams 33 White male gun point foot Yes No
Omaha, NE 07APR2016 Lance C. McIntire 44 White male   attack not No No
Omaha, NE 20MAY2016 Joshua Beebee 31 Black male knife threat foot No Yes
Omaha, NE 06SEP2016 David L. Anderson 25 White male vehicle threat other No No
York, NE 11DEC2016 Timothy Case 53 White male knife threat not Yes No

statecode=NH

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NH

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Claremont, NH 25SEP2016 Cody Lafont 25 White male gun move not Yes No
Peterborough, NH 21JUN2016 Lane Lesko 19 White male replica point car Yes 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 03SEP2016 Jerome Damon 25 Black male gun threat foot No No
Little Egg Harbor Township, NJ 16JUL2016 Patrick Fennell 57 White male gun threat foot No No
Manchester, NJ 07FEB2016 Michael Laniado 27   male knife threat not No No
Manchester, NJ 31JUL2016 Limichael Shine 18 Asian male knife threat not Yes Yes
Maurice River, NJ 06NOV2016 Jimmy L. Testa 31 White male blunt_object threat foot No No
New Brunswick, NJ 09APR2016 Diahlo Grant 27 Black male gun shoot foot No No
Newark, NJ 30SEP2016 George Richards-Meyers 18 Black male undetermined undetermined not No No
Newark, NJ 30SEP2016 Najier Salaam 18 Black male undetermined undetermined not No No
Newark, NJ 22NOV2016 Talif Scudder 23 Black male gun point not No No
Paterson, NJ 24JUN2016 Ismael Miranda 36 Black male gun shoot not No No
Ventnor, NJ 03OCT2016 John H. Fetter 49 White male gun threat not No No
Vineland, NJ 17APR2016 Richard Bard Jr. 31 Black male gun point foot 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 02SEP2016 Joseph Moreno 38 Hispanic male gun shoot foot No Yes
Albuquerque, NM 01FEB2016 Edgar Rene Alvarado 21 Hispanic male gun shoot car Yes Yes
Albuquerque, NM 20FEB2016 Edgar Camacho-Alvarado 23 Hispanic male gun point foot No No
Albuquerque, NM 26APR2016 Jacquelyn Burke 24 White female gun point car Yes No
Albuquerque, NM 24MAY2016 Mario Montoya 31 Hispanic male gun shoot not No No
Albuquerque, NM 28MAY2016 Dennis Humphrey 58 White male gun point not No Yes
Albuquerque, NM 16JUN2016 Ronald Delfino 21 Hispanic male gun shoot car No No
Artesia, NM 26JUL2016 Juan Reynaldo Duran 36 Hispanic male gun threat   No No
Carlsbad, NM 07MAR2016 Daniel H. Chavez Jr. 41 Hispanic male   threat car No No
Carrizozo, NM 06JAN2016 Alan Huberth Franco-Armenta 32 Hispanic male gun shoot not Yes No
Gallup, NM 24JUL2016 Alvin R. Sylversmythe 29 Native American male knife threat not Yes No
Hanover, NM 23JUN2016 Josh Herrera 29   male gun undetermined not No No
Jal, NM 15FEB2016 Guadalupe Sauceda 52 Hispanic male gun shoot not No No
Laguna Pueblo, NM 27JUN2016 Travis Vierra 26 White male gun point not No No
Las Cruces, NM 21AUG2016 Juan Gabriel Torres 36 Hispanic male knife threat not No Yes
Las Cruces, NM 02DEC2016 Josh Dunne 36 White male gun point not Yes No
Pueblo of Laguna, NM 24MAR2016 Mario Sandoval 19 Hispanic male gun shoot not No Yes
Roswell, NM 27MAR2016 Robert D. Guerin 33 White male gun point not Yes Yes
Ruidoso, NM 18AUG2016 David Klassen 29 White male gun threat not No No
Santa Fe, NM 27JAN2016 Herman Flores 31 Hispanic male gun shoot not No No
Socorro, NM 26MAY2016 Angel Daniel Navarro 25 Hispanic male gun shoot car No No

statecode=NV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Carson City, NV 01NOV2016 Henry Simpson 76 White male gun move not No No
Henderson, NV 19OCT2016 Javier Munoz 28 Hispanic male vehicle attack car No No
Las Vegas, NV 31MAR2016 James Craig Simpson 31 Black male gun shoot foot No Yes
Las Vegas, NV 11APR2016 Efren Eloy Trujillo 22 Hispanic male gun shoot not No No
Las Vegas, NV 19MAY2016 Jeremias Cruz 30 Hispanic male unarmed attack not No No
Las Vegas, NV 26AUG2016 Matthew Gibbon 41 White male gun shoot foot No No
Las Vegas, NV 12OCT2016 Rex Vance Wilson 50 Native American male gun threat car No Yes
Reno, NV 25JAN2016 Sergio Alvarado-Morales 38 Hispanic male knife threat not Yes No
Reno, NV 10MAR2016 Arteair Porter Jr. 22 Black male replica point foot Yes No
Reno, NV 03JUL2016 Raul Saavedra-Vargas 24 Hispanic male   threat car No No
Reno, NV 19AUG2016 Kyle Zimbelman 29 White male gun shoot car No No
Reno, NV 21DEC2016 Raymond Salaiz 38 Hispanic male   attack car No No
Sparks, NV 28JUL2016 Jorge Moreno-Aguirre 41 Hispanic male gun threat 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?
Berne, NY 22APR2016 Carl Baranishyn 51 White male knife attack not Yes No
Bronx, NY 18OCT2016 Deborah Danner 66 Black female blunt_object attack not Yes No
Brooklyn, NY 19NOV2016 Erickson Brito 21 Black male blunt_object attack not Yes No
Cheektowaga, NY 05MAR2016 Darrell Bosell 34 White male gun point not Yes No
Middletown, NY 13JUL2016 Richard G. Dinneny 56 White male replica threat not Yes No
New York, NY 17APR2016 George Tillman 32 Black male gun point foot No No
New York, NY 18MAY2016 Garry Conrad Jr. 46 White male knife threat not Yes No
New York, NY 19JUN2016 Rashaun Lloyd 25 Black male gun point not No No
New York, NY 11JUL2016 Orville Edwards 39 Black male gun point foot No No
New York, NY 17JUL2016 Jermaine Johnson 42 Black male gun shoot not No No
New York, NY 04NOV2016 Manuel Rosales 35 Hispanic male gun shoot other Yes No
Rochester, NY 07MAR2016 Philip Vitullo 49 White male gun point not Yes No
Rotterdam, NY 10APR2016 William Clark 30 White male knife attack not Yes No
Schenectady, NY 13JUN2016 Joshua Sciscm 33 White male gun point not No No
Syracuse, NY 12FEB2016 Sahlah Ridgeway 32 Black female gun threat not Yes No
Syracuse, NY 09OCT2016 Deric J. Brown 41 Black male gun shoot not No No
Troy, NY 17APR2016 Edson Thevenin 37 Black male   attack 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 18SEP2016 Philip Hasan 61 Black male gun threat not No No
Ashtabula, OH 08NOV2016 Evan Cox 26 White male   attack car No No
Brookville, OH 31OCT2016 Ashley Sides 31 White female gun shoot other No No
Cincinnati, OH 11JAN2016 Robert Tenbrink 45 White male replica point foot Yes No
Cincinnati, OH 17FEB2016 Paul Gaston 37 Black male replica threat other No No
Cincinnati, OH 07AUG2016 Jawari Porter 25 Black male knife attack not Yes No
Circleville, OH 09AUG2016 Ronald Smith 45 White male gun threat not Yes No
Columbus, OH 07FEB2016 Marese V. Collins 23 Black male gun threat other No No
Columbus, OH 11FEB2016 Mohamed Barry 30 Black male knife attack car No No
Columbus, OH 06JUN2016 Henry Green V 23 Black male gun shoot not No No
Columbus, OH 30JUN2016 Kawme Dejuan Patrick 25 Black male gun move   No No
Columbus, OH 14SEP2016 Tyre King 13 Black male replica threat foot No No
Columbus, OH 30SEP2016 Jacquarius M. Robinson 20 Black male gun flee foot No No
Columbus, OH 28NOV2016 Abdul Razak Ali Artan 18 Black male knife attack not No No
Dayton, OH 17APR2016 Kisha Arrone 35 Black female gun threat car No No
Fairborn, OH 22FEB2016 Rouven Loch 22 White male replica threat not No No
Hamilton, OH 22AUG2016 Kelley Brandon Forte 34 Black male knife attack not No No
Hudson, OH 04DEC2016 Saif Nasser Mubarek Alameri 26 Asian male unarmed threat foot No No
Montpelier, OH 16JUN2016 John Anderson 59 White male gun threat not Yes No
North Royalton, OH 28OCT2016 Jun Wang 45 Asian male knife attack not Yes No
Oak Hill, OH 06APR2016 Marvin Cremeans 60 White male blunt_object threat not No No
Perry Township, OH 04FEB2016 Thomas Hirko 54 White male replica point not No No
Rome, OH 16AUG2016 Michael S. Martin 36 White male gun threat car No No
Sylvania Township, OH 01SEP2016 Ed Holup 60 White male   threat not Yes No
Westlake, OH 10OCT2016 Devan Desnoyers 26 White male   flee car No No
Willoughby, OH 19OCT2016 Frank J. Sandor 38 White male   threat car 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?
Bartlesville, OK 26OCT2016 William Clifford Cole 36 White male unarmed attack not No No
Broken Bow, OK 09JUL2016 Andre Johnson 40 Black male gun shoot car No No
Burns Flat, OK 21DEC2016 Colton Calaway 25 White male gun point other No No
Byng, OK 11MAY2016 Steve Godfrey   White male gun point car Yes No
Cache, OK 15APR2016 David Swatsky 52 White male gun point not Yes No
Chickasha, OK 19NOV2016 Steve Dwayne Vananda 55   male gun shoot not No Yes
Eufaula, OK 21JAN2016 Cedric Norris 39 Black male gun shoot car Yes No
Leedey, OK 30OCT2016 Michael Dale Vance Jr. 38 Native American male gun shoot car No No
Okemah, OK 05NOV2016 James Carl Coale 36 White male   threat car No No
Oklahoma City, OK 04JAN2016 Rodney Turner 22 Black male gun attack foot No Yes
Oklahoma City, OK 25MAY2016 Derek Prophet 43 White male knife threat not Yes No
Oklahoma City, OK 24JUN2016 Miguel Angel Chavez-Angles 42 Hispanic male gun threat other Yes No
Oklahoma City, OK 13NOV2016 Daniel Laguna 21 Hispanic male gun shoot not No No
Ponca City, OK 21DEC2016 Ian Shea King 31   male blunt_object threat not No No
Rush Springs, OK 06JUL2016 Thomas Vandemark 65 White male gun threat not No Yes
Schulter, OK 03FEB2016 John Henry Neuman 53 White male gun shoot not No No
Tahlequah, OK 12AUG2016 Dominic Rollice 49 White male blunt_object threat not Yes Yes
Tulsa, OK 15JUN2016 Russell Rosser 43 White male   attack car No No
Tulsa, OK 17JUL2016 Michael Ray Ramsey Jr. 43 White male knife attack not No No
Tulsa, OK 18JUL2016 Jerry Brimer 56 White male blunt_object threat not Yes No
Tulsa, OK 16SEP2016 Terence Crutcher 40 Black male unarmed move not No No
Tulsa, OK 18OCT2016 Salvador Reyes 42 Hispanic male gun attack not No No
Tulsa, OK 21OCT2016 William Frost Jr. 58 White male knife threat   No No
Tulsa, OK 18DEC2016 Ronald Roy Massengale 72 White male gun point not Yes No
Wagoner, OK 07JUN2016 Andrew Henson 25 White male unarmed move car No Yes
Wetumka, OK 08OCT2016 Dylan Rogers 39   male   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?
Beaverton, OR 16JAN2016 Adam Karjalainen 44 White male replica threat not No No
Bend, OR 31MAY2016 Nicholas Berger 36 White male knife threat not No No
Bend, OR 23DEC2016 Michael Tyler Jacques 31 White male vehicle move not Yes No
Burns, OR 26JAN2016 Robert "LaVoy" Finicum 55 White male gun move not No No
Clackamas County, OR 28JAN2016 Christopher Kalonji 19 Black male gun threat not Yes No
Dallas, OR 16DEC2016 Jeremiah N. Anderson 36   male gun shoot not No No
Grants Pass, OR 13OCT2016 Shawn Pappe 46 White male knife threat   Yes No
Gresham, OR 24MAY2016 Bodhi Wilson Dean Phelps 22 White male knife threat not No No
King City, OR 25DEC2016 James Tylka 30 White male gun shoot car Yes No
Medford, OR 18JAN2016 Timothy Caruthers 27 White male knife threat foot No No
Oregon City, OR 21MAY2016 Travis Moore 38 White male unarmed attack not Yes No
Portland, OR 06DEC2016 Steven Wayne Liffel 52 White male gun shoot not No No
Salem, OR 05JUL2016 Joshua Bolster 29 White male knife threat   No No
Seaside, OR 05FEB2016 Phillip Ferry 55 White male gun shoot not No Yes
Tualatin, OR 30MAY2016 Robert Wickizer 70 White male gun point 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?
Avella, PA 07DEC2016 Steven Garrett Ward 20   male knife attack not Yes No
Bloomsburg, PA 13NOV2016 Jonathan M. Young 38 White male blunt_object attack not Yes No
Chambersburg, PA 03NOV2016 Dennis Kirk 64   male knife attack not Yes No
Chester, PA 08FEB2016 Shalamar Longer 33 Black male gun point car No No
Chester, PA 13MAR2016 Keith Montgomery Jr. 24 Black male gun shoot not No No
Forks Township, PA 09DEC2016 Scott MacIntosh 35 White male gun;knife threat not Yes No
Fort Littleton, PA 20MAR2016 Clarence Briggs 54 White male gun shoot other No No
Harrisburg, PA 07AUG2016 Earl Pinckney 20 Black male knife threat not Yes No
Huntingdon County, PA 31DEC2016 Jason Michael Robison 32 White male gun shoot other No No
Johnstown, PA 02MAR2016 Daniel Burkhardt 41 White male knife move not No No
Penn Township, PA 11JAN2016 Ciara Meyer 12 White female unarmed accident not No No
Philadelphia, PA 09APR2016 Quron Williams 19 Black male gun shoot foot No No
Philadelphia, PA 04MAY2016 Richard Ferretti 52 White male   threat not No No
Philadelphia, PA 17SEP2016 Nicholas Glenn 25 Black male gun shoot foot No No
Philadelphia, PA 28SEP2016 Christopher Sowell 32 Black male unarmed attack not No No
Philadelphia, PA 07NOV2016 Darryl Chisholm 31 Black male gun point other No No
Philadelphia, PA 12DEC2016 Kenneth Robledo 28 Black male gun point not No No
South Greensburg, PA 21MAR2016 Edward J. Gorinski 28 White male gun point car Yes No
Upper Darby, PA 05JAN2016 David Zollo 54 White male knife move not Yes No
Wilkinsburg, PA 31JAN2016 Bruce Kelley Jr. 37 Black male knife attack not Yes No
York, PA 09JUN2016 James Allen Nickol 38 White male gun shoot   No No
York County, PA 15NOV2016 Rasheem Singletary 25 Black male   move car 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 24MAR2016 Dominique Silva 24 Black male replica point foot No No
Tiverton, RI 13JUN2016 Edward Acquisto 80 Hispanic male gun shoot car 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?
Aiken, SC 06NOV2016 Joel B. Keenan 43 White male gun point not Yes No
Campobello, SC 30SEP2016 Douglas Marrickus Rainey 32 Black male gun attack foot No No
Chesterfield County, SC 21MAY2016 Norman Campbell 63 White male gun point not No No
Edmund, SC 01AUG2016 Bryan N. Byrd 43 White male   attack car No No
Greenville, SC 02MAY2016 Reginald Darnell Dogan 52 Black male gun point not No No
Hardeeville, SC 20JUN2016 Raufeal M. Bostick 23 Black male gun shoot not No No
Iva, SC 29NOV2016 Alexander Chance Partain 31 White male unarmed attack foot No No
Lake City, SC 02AUG2016 Richard Lance London 22 White male gun shoot car No No
Landrum, SC 01JUL2016 Alexis George Mishtowt 63 White male gun point not No Yes
Latta, SC 27JAN2016 John Wesley Smith 27 White male knife threat not No No
Little Mountain, SC 08AUG2016 James W. Jennings Jr. 69 White male gun point not Yes No
Moncks Corner, SC 05OCT2016 Lucas M. Felkel 35 White male gun shoot car No No
Myrtle Beach, SC 26MAR2016 Donald Andrew White 55 White male gun point not No Yes
North Charleston, SC 04JUL2016 William Tracy Patterson 34 White male gun shoot not No Yes
Piedmont, SC 29MAR2016 Robert Morgan Garrison Jr. 51 White male gun point not Yes No
Piedmont, SC 09AUG2016 Jeffrey Allen Morris 44 White male undetermined threat not No No
Sumter, SC 10DEC2016 Waltki Williams 35 Black male gun shoot foot 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 01MAY2016 Ronald Branch 28 White male gun threat not Yes No
Arlington, TN 17DEC2016 Jimmy Lee Lawson 48 White male knife move not No No
Bristol, TN 02JUL2016 Jonathan Lane Justiss 50 White male gun point not No No
Counce, TN 15AUG2016 Danny Pirtle 42 White male gun shoot other No No
Decatur County, TN 20SEP2016 Charles Dove 35 White male gun move car No Yes
East Ridge, TN 19AUG2016 Todd P. Browning 54 White male knife threat not No No
Elizabethton, TN 19FEB2016 Curtis James Dugger 31 White male gun shoot not No No
Estill Springs, TN 27JUL2016 Michael Adams 33 White male knife threat foot No Yes
Gallatin, TN 06APR2016 Laronda Sweatt 40 Black female blunt_object attack not No Yes
Gray, TN 06SEP2016 Larry Grant Whitehead 70 White male gun threat not No Yes
Jackson, TN 24NOV2016 Don Fitzgerald White 45   male knife attack not Yes No
Johnson City, TN 05JAN2016 James K. Maher 39 White male knife threat foot No No
Lenoir City, TN 27JAN2016 Thongsavanh Vandarack 40 Asian male replica threat not Yes No
Lenoir City, TN 13MAR2016 Joshua Grubb 30 White male unarmed flee car No Yes
Memphis, TN 27JAN2016 Johnathan Bratcher 32 Black male gun shoot other No Yes
Memphis, TN 09SEP2016 Ricardo Tenorio 32 Hispanic male gun shoot not No No
Nashville, TN 20SEP2016 Sandy Joe Duke 43 White male gun point not No No
Raleigh, TN 23MAR2016 Alexio Allen 30 Black male gun point not Yes No
Sevierville, TN 13JAN2016 Brandon Bearden 29 White male gun threat foot No Yes
Shelbyville, TN 24AUG2016 Jeffrey Darren Hosea 53 White male gun point not No No
Sparta, TN 13APR2016 Koltlee Whitson 26 White male gun shoot car No No
Spring Hill, TN 28DEC2016 Christopher Blake Tucker 28 White male knife threat 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?
Addison, TX 13MAR2016 Jose Raul Cruz 16 Hispanic male unarmed undetermined car No No
Allen, TX 08DEC2016 Robert Wilburn Head 64 White male gun shoot not No No
Amarillo, TX 14JUN2016 Mohammad Moghaddam 54 Other male gun shoot not No No
Austin, TX 08FEB2016 David Joseph 17 Black male unarmed move not No No
Austin, TX 03APR2016 Darrin Andrew Martin 25 White male gun shoot foot No No
Austin, TX 22APR2016 Tyler Hunkin 29 White male knife attack not Yes No
Austin, TX 05SEP2016 Cesar Garcia 35 Hispanic male gun threat not No No
Austin, TX 15SEP2016 Morgan Wayne Crocker Jr. 34 White male gun shoot foot No No
Austin, TX 16OCT2016 Micah Dsheigh Jester 26 White female replica point not Yes No
Azle, TX 06MAR2016 Mark Damien Minnick 51 White male gun point not Yes No
Baytown, TX 22NOV2016 Ivory Charles Pantallion III 36 Black male gun threat car No No
Beaumont, TX 05MAR2016 Herbert Edgar Ballance 22 White male gun threat not Yes No
Beaumont, TX 14OCT2016 Chaz Logan York 23 White male blunt_object attack not No No
Beckville, TX 13FEB2016 Calin Roquemore 24 Black male unarmed move other No No
Bellville, TX 22JUN2016 Shaun Trevor Walke 31 White male gun point not No Yes
Campbellton, TX 27DEC2016 Jake Childers 36 White male gun shoot other No No
Carrollton, TX 26OCT2016 Malcolm Loren Hickson 25 Black male gun threat not No No
Corpus Christi, TX 30OCT2016 Jordan Gonzales 23 Hispanic male gun point not No No
Dallas, TX 19JAN2016 Gary Wayne Jones 36 White male gun shoot car No No
Dallas, TX 19OCT2016 Anthony Garcia 24 Hispanic male replica threat not No No
El Paso, TX 04FEB2016 Hector Leroy 43 Hispanic male gun point not No No
El Paso, TX 17APR2016 Eric John Wilson 22 White male unarmed threat not Yes No
El Paso, TX 09MAY2016 Arthur R. Williams Jr. 33 Black male replica threat not No No
Ellis County, TX 05SEP2016 Moses Ruben 36 Black male gun attack car No No
Euless, TX 01MAR2016 Jorge Brian Gonzalez 22 Hispanic male gun shoot not Yes No
Fort Worth, TX 12FEB2016 David Glen Watson 53 White male gun threat not No No
Fort Worth, TX 15MAR2016 Ed Russell McIver Sr. 43 White male gun threat other No Yes
Friendswood, TX 29NOV2016 Toby Cummins 55 White male blunt_object flee car No Yes
Fulshear, TX 24JUN2016 Christy Byrd Sheats 42 White female gun shoot not Yes No
Gladewater, TX 05NOV2016 Patrick Wise 34 White male gun threat other No Yes
Groveton, TX 30SEP2016 Clayton Eugene Baker 38 White male   undetermined not No No
Harker Heights, TX 30AUG2016 Lyle Patrick Blanchard 59 White male unarmed threat other No No
Henderson County, TX 10FEB2016 Anthony Bertoni 56 Hispanic male gun shoot not Yes No
Houston, TX 23FEB2016 Baltazar Ramos 39 Hispanic male knife attack not Yes No
Houston, TX 12MAR2016 Peter Gaines 37 Black male unarmed move foot No No
Houston, TX 12MAR2016 Marco Loud 20 Black male other attack not No No
Houston, TX 17MAR2016 Scott Bennett 29 Black male gun shoot   No No
Houston, TX 17MAR2016 Christopher Nelms 30 Black male gun shoot not No No
Houston, TX 28APR2016 Ashtian Barnes 24 Black male   move car No No
Houston, TX 29MAY2016 Dionisio Augustine Garza III 25 Hispanic male gun shoot not Yes No
Houston, TX 10JUL2016 Alva Burnett Braziel 38 Black male gun threat not No Yes
Houston, TX 26SEP2016 Nathan DeSai 46 White male gun shoot not No Yes
Houston, TX 07DEC2016 Redrick Jevon Batiste 37 Black male gun shoot not No No
Irving, TX 29JAN2016 Christopher Michael Dew 29 Black male gun threat not No No
Kerrville, TX 20JAN2016 Michael Clyde Lynch 37 White male knife flee other No No
Kingsbury, TX 26APR2016 Darrel S. Machemehl 44 White male gun threat other No No
Laredo, TX 11DEC2016 Jose Angel Vallarta 30 Hispanic male knife attack not No No
Llano, TX 13APR2016 Jeffrey Gray Wise 52 White male gun point not No No
Lockhart, TX 01APR2016 Jesus Juarez 65 Hispanic male blunt_object threat not Yes No
Mansfield, TX 27JAN2016 Nathan Lee Bailey 30 White male gun shoot car No No
Maryneal, TX 02JAN2016 Lance Light 54 White male gun point car No No
Midland, TX 10OCT2016 Kheyanev Littledog 19 Native American male gun threat   No No
Mission, TX 22FEB2016 David Michael Green III 38 White male   threat car Yes No
Myra, TX 23AUG2016 Bobby Lyn Buck 49 White male vehicle attack car No No
Nacogdoches, TX 09MAY2016 Jamie Stotts 29 White male gun point other Yes No
Oak Cliff, TX 24AUG2016 Elias Portillo 36 Hispanic male gun point foot No No
Oak Cliff, TX 14OCT2016 George Zapata 24 Hispanic male gun shoot not No No
Odessa, TX 10MAR2016 Jason Meador 50 White male gun point not Yes No
Odessa, TX 01APR2016 Joel Fabela 37 Hispanic male gun attack not No No
Pearland, TX 27DEC2016 Judy Boardman 71 White female gun point not No No
Pharr, TX 20DEC2016 Martin Gomez 46 Hispanic male knife threat not No No
Port Arthur, TX 09JUN2016 John Michael Brisco 52 Black male gun threat foot No No
Reno, TX 18FEB2016 Ronnie Padron 32 Hispanic male gun point not No No
Rosser, TX 04JUL2016 Dannie Lee Whitmore 26 Black male knife threat not No Yes
Saginaw, TX 31JAN2016 Michael Brown 25 White male unarmed attack not No No
San Angelo, TX 10NOV2016 George Delacruz 41 Hispanic male gun undetermined   No No
San Antonio, TX 16JAN2016 Ashton Lane Morris 27 White male gun shoot foot No No
San Antonio, TX 04FEB2016 Antronie Scott 36 Black male unarmed move not No No
San Antonio, TX 27FEB2016 Fernando Hernandez 23 Hispanic male gun shoot car No Yes
San Antonio, TX 16MAR2016 Eric Hernandez 33 Hispanic male gun point not Yes No
San Antonio, TX 26MAY2016 Donovan Garcia 45 Hispanic male gun threat not No No
San Antonio, TX 23JUL2016 Steven Alfred Longoria 34 Hispanic male gun shoot not No No
San Antonio, TX 23SEP2016 Christopher Contreras 30 Hispanic male gun threat foot No No
San Antonio, TX 27OCT2016 Thad Demarco Hale 33 Black male gun;knife threat not No No
San Antonio, TX 20NOV2016 Andrew Moreno 24 Hispanic male gun point not No No
Splendora, TX 27MAR2016 Earl Ashby 33 White male gun point not Yes No
Spring, TX 19SEP2016 Michelle Miller 46 White female gun point not Yes Yes
Temple, TX 03SEP2016 Richard Jeremiah Ramirez 27 Hispanic male gun point car No No
Weatherford, TX 30AUG2016 Gregory Mathis 36 White male knife threat not No No
Webster, TX 15NOV2016 Robert Tobe Daffern 37 White male gun point not No No
Wood County, TX 19SEP2016 Gary Don Lafon 56 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?
Clearfield, UT 03AUG2016 Benjamin William Heaton 31 White male gun shoot foot No No
Eagle Mountain, UT 12JUN2016 Daniel Bennett Edwards 23 White male knife threat not Yes No
Logan Canyon, UT 19SEP2016 Jeremy Ray Swenson 30 White male unknown threat not Yes No
Milcreek, UT 27APR2016 David Shane Anderson 36 White male gun attack not No No
Ogden, UT 19FEB2016 Justin Patrick Moses 35 White male knife attack not Yes No
Salt Lake City, UT 17JAN2016 Corey Lee Henderson 31 White male gun shoot foot No Yes
Spanish Fork, UT 30APR2016 Mark Daniel Bess 33 White male knife threat foot No No
West Jordan, UT 02NOV2016 Jesse Jay Taylor 40 White male gun threat other 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?
Aldie, VA 05AUG2016 Johannes Wood 58 White male knife threat not Yes No
Arvonia, VA 13FEB2016 Dyzhawn L. Perkins 19 Black male unarmed attack not No No
Chesapeake, VA 26APR2016 Joshua Brooks 26 Black male gun shoot not Yes Yes
Falls Church, VA 15AUG2016 Jovany Martinez 29 Hispanic male blunt_object threat not Yes No
Fredericksburg, VA 22MAR2016 Travis J. Blair 33 White male   point other No Yes
Grundy, VA 26MAR2016 Terrence Shane Blackburn 36 White male gun threat not Yes No
Hopewell, VA 20MAR2016 Boyd Keith Ballard 61 White male knife threat not Yes Yes
Norfolk, VA 12JAN2016 Keith Richardson 58 White male gun attack not Yes No
Norfolk, VA 11MAR2016 Tyre Privott 25 Black male gun shoot not No Yes
Norfolk, VA 19MAR2016 India Beaty 25 Black female replica point not No No
Norfolk, VA 23APR2016 Eric C. Wakup 30 White male gun shoot not Yes No
Norfolk, VA 02JUN2016 Willie Demetrius James 43 Black male knife threat not Yes Yes
Norman, VA 07JUN2016 Willis N. Walker Jr. 49 Black male gun threat not No No
Richmond, VA 31MAR2016 James Brown III 34 Black male gun shoot not No No
Roanoke, VA 26FEB2016 Kionte Desean Spencer 18 Black male replica threat not Yes No
Scott County, VA 03AUG2016 E.J. Walters Jr. 69 White male gun threat car No No
Stafford, VA 01AUG2016 Kenneth Eugene Bonanno 67 White 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?
Burlington, VT 21MAR2016 Ralph Philip Grenon 76 White male knife threat not Yes Yes
Winooski, VT 16SEP2016 Jesse Beshaw 29 Native American male unarmed move foot No Yes

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 09SEP2016 Travis Ell 64 White male unknown threat not Yes No
Beaver, WA 05NOV2016 Edward Lowell Hills 59   male gun threat   Yes No
Burien, WA 04MAY2016 Cayce A. DiTullio 39 White male gun point car No No
Cle Elum, WA 13JAN2016 Timothy Meehan 60 White male gun point not Yes No
East Wenatchee, WA 03SEP2016 Cameron Ayers 25 White male undetermined undetermined not No No
Everett, WA 17DEC2016 Chassady LeClair 44 Native American male gun threat not No No
Federal Way, WA 08OCT2016 Ricardo Hernandez 21 Hispanic male knife threat not Yes No
Graham, WA 30AUG2016 Justin Baker 36   male other attack not Yes No
Kelso, WA 10JAN2016 David Jay Kent 37 White male other threat not Yes No
Kelso, WA 17AUG2016 Omer Ismail Ali 27 Black male blunt_object attack not No No
Kent, WA 13OCT2016 Patrick D. Reddeck 38 White male gun threat not No No
Lake Stevens, WA 07MAY2016 Nathan Q. Cates 29 White male gun threat not Yes No
Lakewood, WA 20FEB2016 Marcos Perea 41 Black male gun shoot car No No
Muckleshoot Indian Reservation, WA 21OCT2016 Renee Davis 23 Native American female gun threat not Yes No
Ridgefield, WA 13JUN2016 Kenneth Allen Pointer 43 White male undetermined move car No No
Ridgefield, WA 18DEC2016 Paul Kolar 37 White male gun threat not No No
Seattle, WA 21FEB2016 Che Taylor 46 Black male undetermined threat not No No
Seattle, WA 11OCT2016 Michael L. Taylor 44 Asian male knife threat not No No
Spokane, WA 28APR2016 Michael Kurtz 45 White male knife threat not Yes Yes
Tacoma, WA 28JAN2016 Jacqueline D. Salyers 32 Native American female vehicle threat not No No
Tacoma, WA 01DEC2016 Bruce Randall "Zeus" Johnson II 38 Black male gun shoot not No No
Tukwila, WA 11AUG2016 Jeff Martelli 59 White male gun shoot not Yes No
Tumwater, WA 05JAN2016 Joel Anthony Nelson 29 White male   attack foot No No
Vancouver, WA 13MAR2016 Amy Jean McCoy 38 White female blunt_object attack not Yes No
Wapato, WA 31JUL2016 Mario Martinez Torres 38 Hispanic male other threat not No No
Yakima, WA 10JUN2016 J. Juan Briseno-Ortega 50 Hispanic male gun point not No Yes

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?
Antigo, WI 23APR2016 Jakob E. Wagner 18 White male gun shoot not No No
Beaver Dam, WI 05AUG2016 James Quealy 59 White male gun shoot not Yes No
East Troy, WI 24FEB2016 Christopher J. Davis 21 Black male unarmed accident car No No
Eau Claire, WI 03APR2016 David Mack 69 White male other attack not No No
Geneva, WI 08JAN2016 Eric C. Olsen 26 White male knife threat not No No
Jackson, WI 01JUL2016 Helmut Wihowski 58 White male knife threat not No No
Lake Hallie, WI 08APR2016 Melissa M. Abbott 25 White female knife threat not Yes No
Madison, WI 29JUN2016 Michael William Schumacher 41 White male other threat not Yes No
Milwaukee, WI 05MAY2016 Burt Johnson 38 Black male gun shoot foot No Yes
Milwaukee, WI 23JUL2016 Austin Jerry Lee Howard Jr. 49 Black male knife attack not No Yes
Milwaukee, WI 13AUG2016 Sylville Smith 23 Black male gun threat foot No Yes
New London, WI 19AUG2016 Kole B. Knight 31 White male replica point not Yes Yes
Pembine, WI 15JUN2016 Michael Rasmussen 38 White male gun point car Yes No
Pine River, WI 26JUL2016 Scot Minard 50 White male gun shoot car No No
Sheboygan, WI 17JUL2016 Kevin Higgins 39 White male gun threat not No No
Wausau, WI 30APR2016 Oswald Mattner 42 White male knife threat not No No
Wauwatosa, WI 23JUN2016 Jay Anderson 25 Black male gun threat not No Yes

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?
Augusta, WV 16AUG2016 John O'Handley 55 White male gun threat not No No
Buckhannon, WV 22JUL2016 Paul Edward Yacabitis 50 White male gun shoot   No No
Clendenin, WV 05NOV2016 Russell Elswick 56 White male gun point not No No
Elkins, WV 15JAN2016 William Keith Waldron 26 White male gun point not No No
Fairmont, WV 11DEC2016 Randy Lee Cumberledge 39 White male   threat not No No
Hensley, WV 06NOV2016 Joseph Newcomb 32 White male blunt_object threat not Yes No
Hometown, WV 01OCT2016 Joshua Allen Perry 28 White male gun point foot No No
Montcalm, WV 10SEP2016 Dennis Claude Stanley 69 White male replica threat not Yes Yes
Morgantown, WV 27AUG2016 Darrel Hetrick 82 White male gun point not No Yes
Petroleum, WV 16JAN2016 Clarence Layfield Jr. 55 White male   threat car No No
Spencer, WV 06SEP2016 Bernard Cottrell 65   male gun shoot car Yes No
Weirton, WV 06MAY2016 Ronald D. Williams Jr.   Black male gun threat not Yes 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?
Casper, WY 21JUN2016 Jeff Hyde 50 White male gun shoot not Yes No
Douglas, WY 30JUN2016 Jasen Scott Ramirez 44 Hispanic male undetermined undetermined not No No