Results: us_police_shootings_map.sas

The GMap Procedure

Gmap

Locations of those fatally shot by police in 2015

The Print Procedure

statecode=AK

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?
Arab, AL 23AUG2015 Christopher Ray Tompkins 36 White male gun shoot car No No
Bay Minette, AL 11MAR2015 Gilbert Fleury 54 White male gun shoot not No No
Birmingham, AL 20FEB2015 Douglas Harris 77 Black male gun point not Yes No
Clanton, AL 17JUN2015 Wendy Chappell 40 White female gun shoot car No No
Dadeville, AL 11FEB2015 Fletcher Ray Stewart 46 White male replica point foot Yes Yes
Homewood, AL 20FEB2015 Stanley Lamar Grant 38 Black male gun shoot not No No
Hoover, AL 11MAR2015 William Russell Smith 53 White male gun point not Yes No
Huntsville, AL 25MAY2015 Anthony Briggs 36 Black male knife attack not Yes No
Lawrence County, AL 19MAR2015 Shane Watkins 39 White male knife threat not Yes Yes
Millbrook, AL 23FEB2015 A'Donte Washington 16 Black male gun shoot not No No
Monroeville, AL 14OCT2015 Leslie Portis Jr. 57 Black male gun shoot not No No
Muscle Shoals, AL 04OCT2015 Eric Edgell 27 White male gun point foot Yes No
Opelika, AL 31OCT2015 Bennie Lee Tignor 56 Black male gun threat car No No
Opp, AL 16JUL2015 Pierre Gabriel Koellner 29 White male gun shoot foot No No
Sylacauga, AL 12SEP2015 Derick Davis 23 White male undetermined undetermined other No No
Tuscaloosa, AL 20AUG2015 Jeffory Ray Tevis 50 White male unarmed attack not Yes No
Washington County, AL 19SEP2015 Scott Beech 57 White male gun point not Yes Yes

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?
Cabot, AR 19MAY2015 Jonathan McIntosh 35 White male gun shoot not No No
England, AR 09JAN2015 Jimmy Foreman 71 White male gun shoot not No No
Jonesboro, AR 14APR2015 Christopher Grant Finley 31 White male knife attack not Yes No
Manila, AR 28JUL2015 Timothy Johnson 41 White male knife threat not No No
Strong, AR 08JAN2015 Artago Damon Howard 36 Black male unarmed attack 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?
Bisbee, AZ 22APR2015 Carlos Saavedra Ramirez 51 Hispanic male knife threat not No No
Chandler, AZ 05JAN2015 Kenneth Arnold Buck 22 Hispanic male gun shoot car No No
Cottonwood, AZ 21MAR2015 Enoch Gaver 21 White male gun shoot not No No
Cottonwood, AZ 30MAY2015 Ebin Lamont Proctor 19 White male unarmed attack foot No No
Eagar, AZ 23MAY2015 Eric Robinson 40 White male gun shoot car No No
Eagar, AZ 25NOV2015 Douglas R. Slade 52 White male gun shoot not No No
Gilbert, AZ 10AUG2015 Richard Tyler Young 24 White male   threat not No No
Glendale, AZ 18MAR2015 Kaylene Stone 49 White female gun point not No No
Glendale, AZ 25MAR2015 Joseph Tassinari 63 White male gun move not Yes No
Kearny, AZ 08MAY2015 Shaun Johnson 35 White male knife attack not No No
Kingman, AZ 11MAR2015 Ryan Dean Burgess 31 White male replica point not Yes No
La Paz County, AZ 28FEB2015 Stephanie Hill 37 White female gun shoot car No No
Marana, AZ 16FEB2015 Lawrence Caldwell 56 White male gun point not No No
Maricopa, AZ 18JAN2015 Jonathan Guillory 32 White male gun point not Yes No
Mesa, AZ 29APR2015 Joshua Deysie 33 Hispanic male gun point not Yes No
Mesa, AZ 07JUL2015 Adam Dujanovic 33 White male blunt_object threat not No No
Mesa, AZ 04DEC2015 Ivan Krstic 47 White male blunt_object threat not No No
Morenci, AZ 27JAN2015 Chris Ingram 29 White male gun shoot not No No
Phoenix, AZ 27JAN2015 Nicolas Leland Tewa 26 Native American male   threat not No No
Phoenix, AZ 07MAR2015 Adam Reinhart 29 White male gun point not No No
Phoenix, AZ 05APR2015 Ken Cockerel 51 White male knife threat not Yes No
Phoenix, AZ 18APR2015 Erik Tellez 43 Hispanic male gun shoot not Yes No
Phoenix, AZ 09JUL2015 Robert Hammonds 68 White male gun point foot No No
Phoenix, AZ 18JUL2015 Kevin Thomas Snyder 46 White male gun shoot not No No
Phoenix, AZ 25AUG2015 Shane Rudolph 45 White male gun point not No No
Phoenix, AZ 26DEC2015 Lonnie Niesen 41 White male blunt_object threat not Yes No
Prescott, AZ 02SEP2015 Arthur Bates 45 White male gun shoot not Yes Yes
Red Valley, AZ 20MAR2015 Justin Fowler 24 Native American male gun shoot car No No
San Manuel, AZ 13FEB2015 Daniel Mejia 37 Hispanic male knife threat not Yes No
Scottsdale, AZ 20JAN2015 Dewayne Carr 42 Black male   threat car No No
Sierra Vista, AZ 02OCT2015 David M. Diaz 28 Hispanic male gun shoot car No No
Sun City, AZ 08JUN2015 Richard Warolf 69 White male gun point not Yes No
Sun City, AZ 29NOV2015 Ralph Aguilar 69 Hispanic male gun point not Yes No
Tempe, AZ 04FEB2015 Salvador Muna 28 Hispanic male gun point car No No
Tempe, AZ 04FEB2015 Joaquin Hernandez 28 Hispanic male unarmed accident not No No
Tempe, AZ 03MAR2015 Matthew Metz 25 White male knife attack not No No
Tempe, AZ 27DEC2015 Sean Mould 34 White male knife threat not Yes Yes
Tucson, AZ 28FEB2015 Jessica Uribe 28 Hispanic female knife threat not No No
Tucson, AZ 01AUG2015 Armando Serrano Jr. 29 Hispanic male gun shoot not No No
Tucson, AZ 30AUG2015 David M. Leon 40 Hispanic male gun point not No No
Tucson, AZ 11DEC2015 Steven Wickert 36 White male unarmed attack not No No
Wilhoit, AZ 25SEP2015 Jeffrey Blood 45 White male gun shoot not No No

statecode=CA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=CA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aguanga, CA 09OCT2015 Margaret Wagner 62 White female gun point not No No
Alpine, CA 27MAY2015 Simon Hubble 33 White male knife threat not Yes No
Anaheim, CA 08MAR2015 Monique Jenee Deckard 43 Black female knife threat not Yes Yes
Anaheim, CA 08JUN2015 Rene Garcia 30 Hispanic male knife threat not Yes Yes
Antioch, CA 03FEB2015 Dewayne Deshawn Ward Jr. 29 Black male knife threat not Yes No
Apple Valley, CA 02FEB2015 Francis Murphy Rose III 42 White male gun shoot not Yes No
Atwater, CA 06JUL2015 David Oliva Sarabia 42 Hispanic male knife attack car No No
Azusa, CA 21JUN2015 Adrian Simental 24 Hispanic male unarmed threat not Yes No
Bakersfield, CA 18MAR2015 Jeff Alexander 47 White male knife threat not No No
Bakersfield, CA 19MAR2015 Robert Burdge 36 White male gun point not No No
Bakersfield, CA 27MAR2015 Adrian Hernandez 23 Hispanic male replica point car No No
Bakersfield, CA 07JUL2015 Daniel Hernandez Jr. 47 Hispanic male gun shoot not No No
Bakersfield, CA 22AUG2015 Jason Lee Alderman 29 White male blunt_object threat not No No
Bakersfield, CA 29NOV2015 Hugo Fernando Celio 23 Hispanic male gun shoot foot No No
Barstow, CA 14SEP2015 David Todd Powell 28 White male unarmed attack not Yes No
Barstow, CA 20NOV2015 Nathaniel Harris Pickett 29 Black male unarmed attack not Yes No
Boulder Creek, CA 09JUL2015 Cyrus Hurtado 17 White male gun point not Yes No
Burbank, CA 05MAR2015 Sergio Alexander Navas 36 Hispanic male unarmed flee car No No
Calexico, CA 21OCT2015 Miguel Angel Marin Galena 35 Hispanic male knife threat other No No
Calimesa, CA 07FEB2015 John Sawyer 26 White male replica point not No No
Camarillo, CA 16DEC2015 Bryant Neil Duncan 23 White male knife attack not Yes No
Carmichael, CA 22OCT2015 Adriene Jamarr Ludd 36 Black male gun shoot car No No
Cathedral City, CA 24OCT2015 Dominic Hutchinson 30 Black male blunt_object undetermined not No No
Cerritos, CA 07MAY2015 Nephi Arriguin 21 Black male   attack car No No
Chico, CA 10NOV2015 Eddie Gabriel Sanchez Jr. 34 Hispanic male gun point not No No
Chico, CA 26NOV2015 Andrew Thomas 26 White male unarmed accident car No Yes
Chino, CA 05FEB2015 Paul Alfred Eugene Johnson 59 White male replica flee car No No
Citrus Heights, CA 22JUN2015 Eduardo Reyes 35 Hispanic male gun shoot not No No
Corning, CA 10APR2015 Angel Cresencio Corona Jr. 21 Hispanic male knife attack not No No
Delano, CA 03JUN2015 Lorenzo Garza Jr. 46 Hispanic male gun shoot car No No
Downey, CA 10SEP2015 Eddie Tapia 41 Hispanic male gun point car No No
Dunsmuir, CA 13JUL2015 Matthew Ryan Graham 24 White male gun shoot car No No
Dunsmuir, CA 30JUL2015 Ryan Daniel Vrenon 25 White male gun point car No No
El Monte, CA 09SEP2015 William Chau 59 Asian male knife attack not No No
Elk Grove, CA 29APR2015 Luis Chavez-Diaz 27 Hispanic male gun point not No No
Emeryville, CA 03FEB2015 Yuvette Henderson 38 Black female gun point car No No
Encinitas, CA 27MAR2015 Gary Kendrick 56 White male gun point not Yes No
Eureka, CA 01NOV2015 Killian O'Quinn 20 White male gun shoot not No No
Fairfield, CA 15JAN2015 Jose Ceja 36 Hispanic male knife threat not Yes No
Fontana, CA 13MAR2015 Andrew Driver 36 White male knife attack not No No
Fontana, CA 10SEP2015 Santino Burce 34   male knife threat not Yes No
Fontana, CA 20NOV2015 Martin Arturo Rivera 50   male gun threat not Yes No
Fontana, CA 22NOV2015 James Daniel Hall 47 White male knife attack not Yes No
Fountain Valley, CA 26APR2015 Dean Genova 45 White male gun attack not No No
Fremont, CA 16JAN2015 Zaki Shinwary 48 Other male knife threat not No No
Fremont, CA 20JUL2015 Troy Francis 54 White male knife threat not No No
Fresno, CA 25JUN2015 Gilbert Jake Vanderburgh 61 White male gun point not No No
Fresno, CA 07AUG2015 Aaron Marchese 30 White male replica point not Yes No
Fresno, CA 03SEP2015 Freddy Centeno 40 Hispanic male unarmed point not Yes Yes
Fresno, CA 07SEP2015 Casimero Carlos Casillas 45 Hispanic male blunt_object threat foot No Yes
Fresno, CA 18OCT2015 Krikor Ekizian 28 White male knife attack not Yes No
Fresno, CA 30DEC2015 Fred Perez 55 Hispanic male knife attack not No Yes
Gilroy, CA 14DEC2015 Hector Alvarez 19 Hispanic male unarmed threat not No Yes
Happy Valley, CA 22SEP2015 Tim Kyle Torngren 55 White male gun point not Yes No
Hawaiian Gardens, CA 05JUL2015 Johnny Ray Anderson 43 Hispanic male unarmed flee not No No
Hawthorne, CA 01APR2015 Robert Washington 37 Black male gun shoot not No No
Hemet, CA 21JAN2015 Todd Allen Hodge 36 White male gun shoot not No No
Hemet, CA 17APR2015 Elias Cavazos 29 Hispanic male gun shoot not No No
Hemet, CA 12AUG2015 Anthony Lorenzo Vallejo 27 Hispanic male gun point car No No
Hemet, CA 10DEC2015     male gun point not No No
Hemet, CA 21DEC2015 Guadalupe Quiroz 34 Hispanic male gun point not No No
Highgrove, CA 24OCT2015 Juan Ulloa 34 Hispanic male gun shoot not No No
Indio, CA 14OCT2015 Samuel Villarreal 18 Hispanic male   threat car No No
Indio, CA 05DEC2015 Juan Perez 38 Hispanic male gun shoot not No No
Inyokern, CA 15AUG2015 Benjamin Peter Ashley 34 Black male gun point not Yes No
Jurupa Valley, CA 13NOV2015 Ernesto Gamino 25 Hispanic male undetermined undetermined   No No
Jurupa Valley, CA 14NOV2015 Ramon Salazar 31 Hispanic male blunt_object threat not No No
Kings County, CA 26APR2015 Albert Hanson Jr. 76 White male gun shoot not No No
Lakewood, CA 06JUL2015 John Leonard Berry 31 White male   attack other Yes No
Lancaster, CA 03JUL2015 Arturo Lopez 46 Hispanic male gun point not No No
Lodi, CA 10SEP2015 Austin Wilburly Reid 32 White male gun shoot foot No No
Long Beach, CA 23APR2015 Hector Morejon 19 Hispanic male unarmed move not No No
Long Beach, CA 27MAY2015 Feras Morad 20 Other male unarmed move not No No
Long Beach, CA 07AUG2015 Derrick Lee Hunt 28 Black male knife attack not No No
Long Beach, CA 14DEC2015 Mharloun Verdejo Saycon 39 Asian male knife threat not No No
Los Angeles, CA 17JAN2015 Pablo Meza 24 Hispanic male gun point not No No
Los Angeles, CA 01MAR2015 Charly Leundeu Keunang 43 Black male unarmed attack not Yes Yes
Los Angeles, CA 11MAR2015 Aaron Valdez 25 Hispanic male   threat not No No
Los Angeles, CA 08APR2015 Roberto Rodriguez 39 Hispanic male gun shoot foot No No
Los Angeles, CA 21APR2015 Luis Martinez 35 Hispanic male knife threat not Yes No
Los Angeles, CA 06JUL2015 Jason Hendley 29 Black male knife attack not No No
Los Angeles, CA 09JUL2015 Neil White 38 White male other attack other No No
Los Angeles, CA 13JUL2015 Jason Davis 41 White male knife threat not No No
Los Angeles, CA 12AUG2015 Redel Jones 30 Black female knife threat not No No
Los Angeles, CA 27AUG2015 Manuel Soriano 29 Hispanic male blunt_object attack not No No
Los Angeles, CA 15SEP2015 Carlos Wilhelm 39 Hispanic male gun shoot not No No
Los Angeles, CA 27SEP2015 Norma Angelica Guzman 37 Hispanic female knife threat not Yes Yes
Los Angeles, CA 19OCT2015 Dion Lamont Ramirez 53 Black male   attack not No No
Los Angeles, CA 09NOV2015 Miguel Cano 35 Hispanic male other threat not No No
Los Angeles, CA 19DEC2015 Ruben Jose Herrera 26 Hispanic male undetermined attack not Yes No
Lynwood, CA 12DEC2015 Nicholas Robertson 28 Black male gun point not No No
Marina, CA 10DEC2015 Thomas Arthur Gendreau Jr. 54 White male knife attack not No No
Meadow Vista, CA 23JUL2015 Tamala Satre 44 White female gun point not Yes No
Merced, CA 04NOV2015 Faisal Mohammad 18 Other male knife attack foot No No
Modesto, CA 17OCT2015 Gino Paredes 22 Hispanic male replica shoot not No No
Modesto, CA 17DEC2015 Christopher Fletcher 24 White male gun point other No No
Montclair, CA 15APR2015 Ernesto Flores 52 Hispanic male replica point not Yes No
Monterey, CA 06OCT2015 Donald Miller II 39 White male replica point not Yes No
Moreno Valley, CA 16JUL2015 Anthonie Smith 25 Black male blunt_object threat not Yes No
Napa, CA 13MAR2015 James Richard Jimenez 41 Hispanic male gun move other No No
Needles, CA 17JUL2015 Jackie Brand 50 White male gun point not Yes No
Norwalk, CA 01DEC2015 John Anthony Gonzalez 18 Hispanic male gun point not No No
Oakland, CA 06JUN2015 Demouria Hogg 30 Black male gun point not No Yes
Oakland, CA 03AUG2015 Antonio Clements 49 Black male gun shoot not No No
Oakland, CA 12AUG2015 Nathaniel Wilks 27 Black male gun point car No Yes
Oakland, CA 27AUG2015 Yonas Alehegne 30 Black male other attack not No Yes
Oakland, CA 22SEP2015 Dante Osborne 32 Black male gun shoot car No No
Oakland, CA 15NOV2015 Richard Perkins 39 Black male replica point not No No
Olivehurst, CA 11JUL2015 Billy Maine 31 White male gun point not No No
Ontario, CA 10MAR2015 Edixon Franco 37 Hispanic male knife threat car Yes No
Ontario, CA 20AUG2015 Raul Herrera III 17 Hispanic male gun point not Yes No
Ontario, CA 05SEP2015 Luis Wenceslao 32 Hispanic male blunt_object threat not Yes Yes
Orange, CA 04APR2015 Paul Anderson 31 Black male gun point not No Yes
Oxnard, CA 27MAR2015 Meagan Hockaday 26 Black female knife threat not No No
Pacific Beach, CA 04NOV2015 Timothy Gene Smith 47 White male unarmed move foot No Yes
Palmdale, CA 20DEC2015 Leroy Browning 30 Black male gun attack not No No
Palo Alto, CA 25DEC2015 William David Raff 31 White male knife attack not Yes No
Panorama City, CA 15SEP2015 Florencio Chaidez 32 Hispanic male gun point not No Yes
Pinion Hills, CA 10OCT2015 William Combs 38 White male   threat car Yes No
Pleasanton, CA 05JUL2015 John Deming Jr. 19 White male unarmed attack foot No No
Point Loma, CA 28OCT2015 Anthony Ashford 29 Black male unarmed attack not No No
Porterville, CA 24DEC2015 Omar Ventura 23 Hispanic male knife threat not No No
Rancho Santa Margarita, CA 12MAY2015 Alec Ouzounian 40 White male knife threat not Yes No
Rialto, CA 02OCT2015 Christian Pena 26 Hispanic male knife attack not No No
Rosemead, CA 29DEC2015 Tien Phuong Hua 33 Asian male unknown undetermined not No No
Sacramento, CA 17MAR2015 Roberto Leon 22 Hispanic male unarmed threat car No No
Sacramento, CA 15MAY2015 Matt Coates 42 White male replica point not Yes No
San Bernardino, CA 13FEB2015 Jonathan Larry Harden 23 White male   attack car No No
San Bernardino, CA 18SEP2015 Nicholas Alan Johnson 32 White male   undetermined car No No
San Bernardino, CA 11OCT2015 Joe Pasquez Ortiz 34 Hispanic male undetermined undetermined other No No
San Bernardino, CA 02DEC2015 Tashfeen Malik 27 Other female gun shoot car No No
San Bernardino, CA 02DEC2015 Syed Farook 28 Other male gun shoot car No No
San Bernardino, CA 12DEC2015 Roy Carreon 49 Hispanic male knife attack   No No
San Diego, CA 30APR2015 Fridoon Zalbeg Nehad 42 Other male unarmed move not Yes Yes
San Diego, CA 17MAY2015 Dennis Fiel 34 White male gun shoot foot Yes Yes
San Diego, CA 02JUL2015 Ton Nguyen 60 Asian male knife threat not No No
San Diego, CA 27AUG2015 Robert Hober 54 White male knife threat not No Yes
San Diego, CA 20OCT2015 Lamontez Jones 39 Black male replica point not No No
San Diego County, CA 04AUG2015 Daniel Robert Avila 55 Hispanic male undetermined move not Yes No
San Francisco, CA 04JAN2015 Matthew Hoffman 32 White male replica point not Yes No
San Francisco, CA 26FEB2015 Amilcar Perez-Lopez 21 Hispanic male knife threat not No No
San Francisco, CA 17MAR2015 Alice Brown 24 White female vehicle threat not Yes No
San Francisco, CA 15OCT2015 Herbert Benitez 27 Hispanic male gun point not No No
San Francisco, CA 11NOV2015 Javier Lopez Garcia 25 Hispanic male gun point not No No
San Francisco, CA 02DEC2015 Mario Woods 26 Black male knife threat not No No
San Jose, CA 11FEB2015 Phillip Watkins 23 Black male knife threat not Yes No
San Jose, CA 24MAR2015 Scott Dunham 57 White male gun shoot not Yes No
San Jose, CA 09AUG2015 Edrian Rivera 22 Hispanic male knife attack foot No No
San Jose, CA 16AUG2015 Matthew Castillo 29 Hispanic male gun move not No No
San Jose, CA 17AUG2015 Richard Jacquez 40 Hispanic male unarmed flee foot No No
San Jose, CA 09NOV2015 Leonel Acevedo 45 Hispanic male gun shoot not No No
San Ysidro, CA 28SEP2015 Alberto Hernandez 59 Hispanic male replica point not No Yes
Sand City, CA 21SEP2015 William Spaits 27 White male gun shoot not No No
Sand City, CA 21SEP2015 Tina Money 23 White female gun shoot not No No
Santa Ana, CA 27FEB2015 Ernesto Javiar Canepa Diaz 27 Hispanic male unarmed threat not No No
Santa Ana, CA 11MAR2015 Benito Osorio 39 Hispanic male gun shoot not No No
Santa Clara, CA 23MAR2015 Devin Gates 24 Black male gun shoot not No No
Santa Maria, CA 05JUN2015 Jesus Quezada Gomez 50 Hispanic male gun point not No No
Santa Nella, CA 29DEC2015 Siolosega Velega-Nuufolau 50 Asian female knife threat not Yes No
Seaside, CA 14OCT2015 Michael Donald Clark 59   male gun shoot not Yes No
Shafter, CA 16APR2015 Rodolfo Velazquez 47 Hispanic male knife threat not No No
Smartsville, CA 21DEC2015 Brandon Barsnick 30 White male gun point not No No
South El Monte, CA 05MAY2015 Thong Kien Ma 32 Asian male knife attack not No No
South Gate, CA 11JAN2015 Brian Barbosa 23 Hispanic male gun point not No No
South Lake Tahoe, CA 15JUN2015 Kris Jackson 22 Black male unarmed move foot No No
South Los Angeles, CA 25MAR2015 Victor Terrazas 28 Hispanic male gun shoot foot No No
Stockton, CA 06JAN2015 Patrick Wetter 25 White male knife attack not No No
Stockton, CA 28JAN2015 Matautu Nuu 35 Asian male blunt_object attack not Yes No
Stockton, CA 04MAR2015 Carl Lao 28 Asian male gun shoot not No No
Stockton, CA 14JUN2015 Kenneth Garcia 28 Hispanic male   attack car No No
Studio City, CA 24JUL2015 Seth Raines 44 White male replica shoot not No No
Sunnyvale, CA 08APR2015 Joseph Jeremy Weber 28 Asian male knife threat not Yes No
Sunnyvale, CA 15AUG2015 Allen Matthew Baker III 23 Black male gun point not No No
Sunnyvale, CA 12NOV2015 Moises Nero 42 Black male knife threat not No No
Sylmar, CA 23APR2015 Andrew Valadez 26 White male replica point not Yes No
Tehachapi, CA 05APR2015 Richard Hanna 56 White male gun point not No No
Valinda, CA 16OCT2015 Johnny Angel Rangel 27 Hispanic male unarmed attack not No No
Vallejo, CA 22MAR2015 Phillip Conley 37 White male knife threat not Yes No
Van Nuys, CA 04OCT2015 James Joseph Byrd 45 White male blunt_object undetermined not No No
Venice, CA 05MAY2015 Brendon Glenn 29 Black male unarmed attack not No Yes
Visalia, CA 16JUN2015 Christopher DeLeon 28 Hispanic male gun point not No No
Walnut Creek, CA 13MAR2015 Antonio Perez 32 Hispanic male unarmed move foot No No
Wasco, CA 26JAN2015 David Garcia 34 Hispanic male knife threat not Yes No
Watsonsville, CA 06JUN2015 Alejandro Campos Fernandez 45 Hispanic male gun shoot foot No No
Weitchpec, CA 04SEP2015 Richard Keith Kelley 27 White male gun shoot car No No
West Covina, CA 03JUL2015 Cesar A. Limon Juarez 27 Hispanic male knife attack not No No
West Goshen, CA 21OCT2015 Ryan Christopher Rodriguez 21 Hispanic male unarmed attack not Yes No
Whittier, CA 30JUL2015 Oscar Lotari Romero 47 Hispanic male blunt_object attack not No No
Wilmington, CA 26MAR2015 Adrian Solis 35 Hispanic male knife threat not Yes No
Windsor, CA 24APR2015 Karen Janks 46 White female   attack car No No

statecode=CO

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=CO

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aurora, CO 15JAN2015 Kavonda Earl Payton 39 Black male gun point not No No
Aurora, CO 06MAR2015 Naeschylus Vinzant 37 Black male unarmed move foot No No
Aurora, CO 30NOV2015 Tuan Hoang 25 Asian male   attack car No No
Aurora, CO 12DEC2015 Efrain Villanueva 51   male unknown attack   No No
Aurora, CO 21DEC2015 Chan Leith 25 Black male gun shoot not No No
Boulder, CO 27JUL2015 Samuel Forgy 22 White male blunt_object threat not No No
Brighton, CO 10NOV2015 Jason Leanard Mesaros 36 Hispanic male gun threat car No No
Broomfield, CO 11SEP2015 Phillip Pfleghardt 44 White male gun shoot car No No
Cañon City, CO 15APR2015 Stanley Watson 72 White male gun shoot not Yes No
Colorado Springs, CO 31OCT2015 Noah Harpham 33 White male gun shoot not No No
Colorado Springs, CO 10NOV2015 Dana Bruce Ott 63 White male replica point not Yes No
Denver, CO 26JAN2015 Jessie Hernandez 17 Hispanic female vehicle threat not No No
Denver, CO 12JUL2015 Paul Castaway 35 Native American male knife threat foot Yes No
Denver, CO 22NOV2015 Miguel Angel Martinez 28 Hispanic male gun shoot not No No
Denver, CO 02DEC2015 Phillip Munoz 35 Hispanic male gun shoot car No No
Dinosaur, CO 09MAR2015 James Brent Damon 46 White male gun point not No No
Eldorado Springs, CO 22APR2015 Lue Vang 39 Asian male gun point not No No
Evans, CO 04JAN2015 Michael Rodriguez 39 Hispanic male other point not No No
Fort Collins, CO 18JUL2015 David Wheat Jr. 22 White male knife attack not Yes No
Fountain, CO 24SEP2015 Patrick O'Grady 17 White male gun point not No No
Grand Junction, CO 19MAY2015 David Gaines 17 White male gun attack other No No
Greeley, CO 19JUN2015 Louis Atencio 50 Hispanic male gun shoot not No No
Loveland, CO 31AUG2015 William Rippley 45 White male knife attack foot No No
Mountain View, CO 13DEC2015 Enrique Gonzalez 32 Hispanic male gun point not No No
New Castle, CO 10FEB2015 Brian Fritze 45 White male gun point car Yes No
Northglenn, CO 28MAY2015 James Strong Jr. 32 Black male gun shoot not No No
Pueblo, CO 25JAN2015 Orlando Jude Lopez 26 Hispanic male gun shoot car No No
Strasburg, CO 06JUN2015 Damien Ramirez 27 Hispanic male gun shoot car No No
Trinidad, CO 24APR2015 Todd Jamal Dye 20 Black male gun point foot No Yes

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?
Bolton, CT 14AUG2015 Christopher Anderson 53 White male knife attack car No No
Old Saybrook, CT 10OCT2015 Richard Love 31 White male gun point not No No

statecode=DC

statecode=DE

statecode=FL

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=FL

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Auburndale, FL 21SEP2015 Dominic Fuller 34 Hispanic male other threat foot No No
Barberville, FL 21SEP2015 Timothy Wagner 26 White male gun shoot not No No
Brooksville, FL 22DEC2015 Michael Hilber 29 White male undetermined undetermined car No No
Cape Coral, FL 24OCT2015 Rolly Thomas 34 Black male gun shoot not No Yes
Carollwood, FL 31MAR2015 Jeremy Anderson 36 White male gun shoot not No No
Clermont, FL 25APR2015 Daniel Davis 58 White male knife threat not Yes No
Cocoa, FL 09MAR2015 Cedrick Lamont Bishop 30 Black male gun shoot not No No
Cocoa, FL 14JUN2015 Zane Terryn 15 White male gun shoot not Yes No
Deltona, FL 04MAR2015 Derek Cruice 26 White male unarmed move not No No
Deltona, FL 21DEC2015 Robert L. Teter 39 White male gun point not No No
Fort Lauderdale, FL 23JAN2015 Demaris Turner 29 Black male   threat not No No
Fort Pierce, FL 27MAR2015 Jamalis Hall 39 Black male knife threat not No No
Fort Pierce, FL 19NOV2015 Steve Dormil 27 Black male knife attack not No No
Ft. Lauderdale, FL 21MAY2015 Javoris Washington 29 Black male knife attack not No No
Homestead, FL 16JUL2015 Edward Foster III 35 Black male gun point not No No
Jacksonville, FL 19MAR2015 Kendre Alston 16 Black male gun point car No No
Jacksonville, FL 12MAY2015 D'Angelo Stallworth 28 Black male gun move foot No No
Jacksonville, FL 02JUL2015 Victor Emanuel Larosa 23 Black male unarmed attack foot No No
Jacksonville, FL 23AUG2015 Richard Francis Compo Jr. 36 White male gun shoot not Yes No
Jacksonville, FL 28OCT2015 Jerry Michael Graham Jr. 34 Black male gun point not No No
Lakeland, FL 26FEB2015 David Cuevas 42 Hispanic male gun point foot No No
Little Havana, FL 06SEP2015 Carlos Yero 59 Hispanic male gun point car No No
Manatee, FL 19NOV2015 Randy Allen Smith 34 Black male gun point   No No
Mascotte, FL 14JUL2015 Chacarion Avant 20 Black male gun point not No No
Melbourne, FL 07JUN2015 Matthew Wayne McDaniel 36 White male gun point not No No
Miami, FL 15APR2015 Tevin Barkley 22 Black male gun threat foot No No
Miami, FL 11JUN2015 Fritz Severe 46 Black male undetermined threat not No No
Miami, FL 25AUG2015 Marvin Arroliga 22 Hispanic male gun shoot not No No
Miami, FL 15SEP2015 Jorge Suarez-Ruiz 51 Hispanic male gun undetermined car Yes No
Miami, FL 24SEP2015 Ernesto Medina Lopez 42 Hispanic male knife attack not No No
Miami, FL 28SEP2015 Junior Prosper 31 Black male unarmed attack foot No No
Miami, FL 15OCT2015 Jorge Santiago Tapia 15 Hispanic male gun point car No No
Miami, FL 17NOV2015 Yohans Leon 28 Black male gun point foot Yes No
Miami, FL 05DEC2015 David Winesett 51 White male knife threat not No Yes
Miami Beach, FL 03JUL2015 Julien Joseph LaPierre 39 White male gun point not No No
Miami Gardens, FL 15FEB2015 Lavall Hall 25 Black male unarmed threat not Yes No
Micanopy, FL 25JUL2015 Earl Jackson 59 Black male gun shoot not No No
Naples, FL 14OCT2015 Michelle Marie Burg 46 White female gun shoot car Yes No
Navarre, FL 09APR2015 Gordon Kimbrell Jr. 22 White male knife attack not No No
Niceville, FL 22SEP2015 Joel Dixon Smith 33 White male gun shoot not Yes No
North Port, FL 06JUN2015 James Smillie 53 White male gun point not No No
Oakland Park, FL 21JUL2015 Joseph Fuller 24 White male gun move car No No
Old Town, FL 29OCT2015 Larry Watson Busby Jr. 52 White male gun shoot not No No
Opa-Locka, FL 18NOV2015 Cornelius Brown 25 Black male unknown threat not No No
Orange County, FL 08FEB2015 Joseph Paffen 46 White male gun shoot not No No
Orlando, FL 04FEB2015 Izzy Colon 37 Hispanic male gun point not No No
Orlando, FL 17JUL2015 Albert Joseph Davis 23 Black male unarmed attack foot No No
Palm Bay, FL 22FEB2015 Bradford Leonard 50 White male gun point not No No
Palm Beach Gardens, FL 18OCT2015 Corey Jones 31 Black male gun undetermined not No No
Panama City, FL 18APR2015 Grover Sapp 45 White male gun shoot not No No
Plantation, FL 12JUL2015 Salvado Ellswood 36 Black male unarmed attack not No No
Pompano Beach, FL 11JUN2015 Charles Ziegler 40 Black male gun point not No No
Putnam Hall, FL 06MAR2015 Andrew Anthony Williams 48 Black male   threat not No No
Saint Augustine, FL 11MAY2015 Justin Way 28 White male knife threat not Yes No
Saint Augustine, FL 14MAY2015 Cary Martin 53 White male gun shoot not Yes No
Saint Petersburg, FL 17MAY2015 Austin Goodner 18 White male gun shoot not Yes No
Tallahassee, FL 04FEB2015 Jeremy Lett 28 Black male unarmed attack not No No
Tallahassee, FL 18MAR2015 Garland Lee Wingo 64 White male gun point not No No
Tampa, FL 26OCT2015 Kobvey Igbuhay 18 Other male unarmed attack foot No No
Thonotosassa, FL 25AUG2015 Todd Tomlinson 53 White male gun point not No No
West Palm Beach, FL 07OCT2015 Amado Lago 46 Hispanic male knife attack not No No

statecode=GA

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=GA

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Arlington, GA 17NOV2015 Derry Touchstone 58 White male unarmed threat not No No
Atlanta, GA 09MAR2015 Anthony Hill 27 Black male unarmed move not Yes No
Atlanta, GA 29APR2015 Alexia Christian 25 Black female gun shoot not No No
Atlanta, GA 30NOV2015 Darius Smith 18 Black male gun shoot foot No No
Augusta, GA 22JUN2015 Tyler Wicks 29 White male gun point not Yes No
Barrow County, GA 16OCT2015 Jason Foreman 45   male gun shoot not No No
Carrollton, GA 28MAY2015 Kenneth Dothard 40 Black male gun point not No No
Cartersville, GA 14OCT2015 Brent Brannon 27 White male gun point not No No
Clarkesville, GA 23FEB2015 Anthony Giaquinta 41 White male gun shoot foot No No
Covington, GA 10JUL2015 Freddie Blue 20 Black male gun point not No No
Decatur, GA 25JUL2015 Roger Braswell 50 White male gun shoot not Yes No
Douglas, GA 03FEB2015 Anthony Purvis 45 White male gun point not Yes No
Douglasville, GA 21DEC2015 Bobby Daniels 48 Black male gun point not No No
Eden, GA 13NOV2015 Matthew Coleman 25 White male gun shoot foot No No
Jesup, GA 21JUL2015 Jerrod Tyre 35 White male gun point not No No
Lawrenceville, GA 07MAY2015 Joseph Hilton Roy 72   male knife threat not Yes No
Paulding County, GA 20NOV2015 William Tarrant 39 White male gun point not Yes No
Port Wentworth, GA 10MAR2015 Christopher Mitchell 23 White male knife attack not No Yes
Powder Springs, GA 23FEB2015 Michael Wayne Smashey 37 White male knife threat not No No
Rockville, GA 27MAY2015 Harry Davis 57 White male knife attack not Yes No
Rossville, GA 27SEP2015 Christopher Shell 43 White male gun point not No No
Savannah, GA 27OCT2015 Tyrie Cuyler 25 Black male gun shoot not No Yes
Smyrna, GA 25MAR2015 Nicholas Thomas 23 Black male undetermined threat car No Yes
Stone Mountain, GA 13JUL2015 Frederick Farmer 20 Black male gun shoot not No No
Sylvester, GA 26FEB2015 Crystal Lee Miley Harry 34 White female gun point car No No
Talking Rock, GA 25OCT2015 John Harley Turner 36 White male gun shoot not No No
Valdosta, GA 08APR2015 Dexter Pernell Bethea 42 Black male   attack car No No
White, GA 21JUL2015 Darren Billy Wilson 47 White male unarmed threat not No No
Whitfield County, GA 16NOV2015 Brent Noblitt 25 White male   threat car 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 12MAY2015 Bruce Zalonka 46 Asian male gun point not No No
Maui, HI 05AUG2015 Raymond Hodge 39 Black male gun shoot 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?
Burlington, IA 06JAN2015 Autumn Steele 34 White female unarmed accident not No Yes
Cedar Rapids, IA 20OCT2015 Jonathan Tyler Gossman 21 White male gun shoot foot No No
Des Moines, IA 07JAN2015 Nicholas Ryan Brickman 30 White male gun point car No No
Des Moines, IA 09JUN2015 Ryan Bolinger 28 White male unarmed move car No No
Wellman, IA 13SEP2015 Martin Francis Hammen 39 White male gun point not Yes No

statecode=ID

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=ID

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boise, ID 16FEB2015 Michael K. Casper 26 White male gun point not No No
Council, ID 01NOV2015 Jack Yantis 62 White male gun undetermined not No Yes
Homedale, ID 26DEC2015 Gilbert Heredia 38 Hispanic male gun shoot not No Yes
Jefferson County, ID 06APR2015 Tyrell J. Larsen 31 White male gun point car No No
Middleton, ID 19MAR2015 Brandon Rapp 31 White male gun point not No Yes
Rexburg, ID 24JAN2015 Daryl Myler 45 White male gun shoot not No No
Sandpoint, ID 11AUG2015 Casey George Alarcon 34 White male gun shoot 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?
Alton, IL 13APR2015 Isaac Jimenez 27 Hispanic male gun point not No No
Arcola, IL 11JAN2015 Tommy Smith 39 White male gun point not Yes No
Chicago, IL 17APR2015 Jeffrey Kemp 18 Black male gun point foot No No
Chicago, IL 20JUN2015 Alfontish Cockerham 23 Black male gun point foot No No
Chicago, IL 09JUL2015 Martice Milliner 27 Black male gun point foot No No
Chicago, IL 10JUL2015 Eugene McSwain 25 Black male gun point not No No
Chicago, IL 29AUG2015 Rafael Cruz Jr 29 Hispanic male unarmed undetermined car No No
Chicago, IL 25SEP2015 James Anderson 33 Black male knife threat not No No
Chicago, IL 04OCT2015 Jeffery McCallum 31 Black male gun point not No No
Chicago, IL 26DEC2015 Bettie Jones 55 Black female unarmed accident   No No
Chicago, IL 26DEC2015 Quintonio LeGrier 19 Black male blunt_object undetermined not Yes No
Harvey, IL 16MAY2015 Ronell Wade 45 Black male gun shoot foot No No
Joilet, IL 02MAR2015 Shaquille Barrow 20 Black male gun move foot No No
Lisle, IL 10OCT2015 Anthony Aguilar 35 Hispanic male unknown undetermined not No No
Marion, IL 28APR2015 Joshua Green 27 White male gun shoot not Yes No
Metropolis, IL 02APR2015 Donald Hicks 63 White male gun point not Yes No
Rantoul, IL 04AUG2015 Darius D. Graves 31 Black male blunt_object threat not Yes Yes
River Forest, IL 12JUL2015 Matthew Watson 24 White male gun shoot not No No
Rock Island, IL 02APR2015 Darrin Langford 32 Black male gun point foot No No
Rockford, IL 15MAY2015 Mark Farrar 41 White male gun shoot not Yes No
Zion, IL 04APR2015 Justus Howell 17 Black male gun point foot 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?
Beech Grove, IN 08JUN2015 James Johnson 54   male gun point not Yes No
Fort Wayne, IN 13JUN2015 Anthony Hodge 46 White male gun point not No No
French Lick, IN 04SEP2015 Jose Ramon Damiani Jr 49 Hispanic male blunt_object attack not No No
Hanover, IN 15AUG2015 John Unsworth 43 White male unarmed attack not No No
Harmony, IN 21MAR2015 Gary Page 60 White male gun shoot not Yes No
Indianapolis, IN 15JAN2015 Donte Sowell 27 Black male gun shoot foot No No
Indianapolis, IN 21FEB2015 Kent Norman 51 White male knife attack not No No
Indianapolis, IN 06APR2015 Alexander Myers 23 White male gun shoot not Yes No
Indianapolis, IN 12APR2015 Mack Long 36 Black male gun point foot No Yes
Indianapolis, IN 23JUN2015 Joshua Dyer 34 White male unarmed threat car No No
Indianapolis, IN 09AUG2015 Andre Green 15 Black male   point not No No
Indianapolis, IN 10SEP2015 Brandon Foy 29 Black male gun shoot not No No
Indianapolis, IN 10DEC2015 Jason Bryant 34 White male gun point not No No
Indianapolis, IN 12DEC2015 Christopher Goodlow 25 Black male knife attack not Yes No
Kokomo, IN 12JUN2015 Shelly Haendiges 17 White female replica point not Yes No
Monon, IN 09APR2015 Don Smith 29 Black male gun point car No No
Muncie, IN 03AUG2015 Shawn Ruble 35 White male replica point not Yes No
Shelbyville, IN 20SEP2015 Jerrald Wright 56 White male gun shoot not No No
Terre Haute, IN 26FEB2015 Alexander Phillip Long 31 White male unarmed threat not No No

statecode=KS

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=KS

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Assaria, KS 06JAN2015 Brock Nichols 35 White male gun point not No No
Colby, KS 18JUL2015 Charles Edward Dewey 65 White male gun shoot not No No
Gardner, KS 26MAR2015 Deanne Choate 53 White female gun shoot not No No
Hutchinson, KS 23JUN2015 Jonathan Wilson 22 White male knife attack not No No
Kansas City, KS 13FEB2015 Andres Lara-Rodriguez 21 Hispanic male gun point car No No
Kansas City, KS 16JUL2015 Patrick Stephen Pippin 30 White male gun shoot other No No
Topeka, KS 10APR2015 Richard Reed 38 White male gun shoot car No No
Wichita, KS 03JAN2015 John Paul Quintero 23 Hispanic male unarmed move not No No
Wichita, KS 22AUG2015 Nicholas Garner 26 White male   attack car No No

statecode=KY

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=KY

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Brodhead, KY 17SEP2015 Lawrence Price 61 White male gun shoot not No No
Burkesville, KY 30OCT2015 Floyd Ray Cook 62 White male gun shoot other No No
Chavies, KY 03MAY2015 Michael Asher 53 White male gun point not No No
Elizabethtown, KY 29MAR2015 Byron Herbert 29 Black male gun point not No No
Elizabethtown, KY 07JUL2015 Joshua Blough 28 White male knife threat not No No
Elsmere, KY 06AUG2015 Gustavo Ponce-Galon 42 Hispanic male knife attack not No No
Gunlock, KY 18JAN2015 Carter Castle 67 White male gun point not Yes No
Leitchfield, KY 09DEC2015 Christopher Higdon 66 White male gun point not No No
Louisville, KY 13JUN2015 Deng Manyoun 35 Black male blunt_object threat not No No
Louisville, KY 05AUG2015 Tyler Alexander Dattilo 18 White male knife attack not No No
Louisville, KY 20OCT2015 Roger D. Hall Jr. 30 White male replica point not No No
Ludlow, KY 22DEC2015 Charles Reynolds 61   male gun shoot not No Yes
Owensboro, KY 20MAY2015 Chrislon Talbott 38 Black male gun shoot not No No
Pine Top, KY 22OCT2015 Stephen H. Brock 53 White male undetermined move not No No
Princeton, KY 14SEP2015 Joseph Thompson Johnson-Shanks 25 Black male gun point car No No
Wilmore, KY 19APR2015 Michael Foster 40 White male gun point not Yes 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 15SEP2015 Bobby R. Anderson 27 Black male gun threat not No No
Baton Rouge, LA 10MAR2015 Jamie Croom 31 Black male gun shoot not No No
Baton Rouge, LA 26SEP2015 Anthony McKinney 46 Black male knife attack not No No
Bossier City, LA 26MAY2015 Jessie Williams 24 White male undetermined attack not No No
Breaux Bridge, LA 21DEC2015 Michael Noel   Black male unarmed threat not Yes No
Chalmette, LA 15SEP2015 Tyrone Bass 21 Black male blunt_object attack not No No
Denham Springs, LA 23FEB2015 Robert Kohl 47 White male gun point not Yes No
Evangeline Parish, LA 15JAN2015 Nathan Massey 33 White male gun point not No No
Franklin, LA 27DEC2015 Gayneaux Paul Trahan 52 White male undetermined undetermined not No No
Harvey, LA 06APR2015 Desmond Willis 25 Black male gun shoot foot No No
Harvey, LA 08MAY2015 Dedrick Marshall 48 Black male gun point not No No
Houma, LA 27JUL2015 Jean Paul Falgout 45 White male replica point car Yes No
Lakes Charles, LA 11OCT2015 Kevin Lau 44 Asian male gun point not No No
Mandeville, LA 20OCT2015 Darien Greenwood 30 White male knife attack not No No
Marksville, LA 03NOV2015 Jeremy Mardis 6 White male unarmed accident car No Yes
New Orleans, LA 07JAN2015 Omarr Julian Maximillian Jackson 37 Black male gun shoot foot No Yes
New Orleans, LA 20MAR2015 Richard White 63 Black male knife attack not Yes No
New Orleans, LA 28APR2015 Jared Johnson 21 Black male gun shoot not No Yes
New Orleans, LA 25JUL2015 Christopher Olmstead 60 White male blunt_object attack car Yes No
New Orleans, LA 14DEC2015 Calvin McKinnis 33 Black male gun shoot not No Yes
Pineville, LA 02APR2015 Aaron Rutledge 27 White male gun point not Yes No
Pride, LA 24DEC2015 Gregory Sanders 54   male gun point not Yes No
Shreveport, LA 26JUL2015 Khari Westly 33 Black male gun shoot not No No
Shreveport, LA 06SEP2015 Mohamed Ibrahim 28 Black male gun point car Yes No
Shreveport, LA 22OCT2015 Lawrence Green 38 Black male knife attack not No No
Slidell, LA 19SEP2015 Lucien Rolland 46 White male gun shoot car No No
Winnsboro, LA 24DEC2015 Schuylar Gunning 36 White male   threat car 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?
Beverly, MA 10OCT2015 Christopher Whitmarsh 49 White male   attack not Yes No
Boston, MA 27MAR2015 Angelo West 41 Black male gun shoot not No No
Boston, MA 19JUN2015 Santos Laboy 44 Hispanic male knife threat foot Yes No
Brockton, MA 02JUL2015 Douglas Buckley 45 White male replica point not Yes No
Lynn, MA 13JUL2015 Rafael Suazo 23 Hispanic male   attack not No No
Roslindale, MA 02JUN2015 Usaamah Rahim 26 Black male knife threat not No No
Tewksbury, MA 17FEB2015 Douglas Sparks 30 White male replica point foot No No
Webster, MA 27MAR2015 Neil Seifert 40 White male gun shoot foot No No
Weymouth, MA 19JAN2015 Paul Campbell 49 White male knife attack not No No

statecode=MD

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MD

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Baltimore, MD 24JAN2015 Darin Hutchins 26 Black male knife threat not Yes No
Baltimore, MD 11NOV2015 Ryan Quinn Martin 32 Black male gun shoot not No No
Columbia, MD 09OCT2015 Gary Carmona Boitano 19 Black male knife threat not No No
District Heights, MD 14AUG2015 Asshams Pharoah Manley 30 Black male unarmed attack foot Yes No
Elkton, MD 11MAR2015 Terry Garnett Jr. 37 Black male   threat not No No
Essex, MD 14FEB2015 Jason C. Hendrix 16 White male gun shoot car Yes No
Fort Meade, MD 31MAR2015 Mya Hall 27 Black female vehicle threat car No No
Frederick, MD 26OCT2015 Kevin Brunson 45 Black male knife threat not No No
Landover, MD 10MAY2015 Lionel Lorenzo Young 34 Black male   threat car No No
Middle River, MD 14DEC2015 Jeffrey Gene Evans 52 White male knife threat not Yes No
North East, MD 21AUG2015 Charles S. Hall 30 White male   attack car No No
Owings Mills, MD 25JUN2015 Spencer McCain 41 Black male unarmed threat not Yes No
Randallstown, MD 31JAN2015 Edward Donnell Bright Sr. 54 Black male knife threat not Yes No
Reisterstown, MD 23SEP2015 Keith Harrison McLeod 19 Black male unarmed move foot No No
Salisbury, MD 03MAR2015 Fednel Rhinvil 25 Black male gun point not No No

statecode=ME

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=ME

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bangor, ME 01DEC2015 Joshua Jozefowicz 23 White male gun shoot foot No No
Smyrna, ME 09FEB2015 Kenneth Kreyssig 61 White male gun point not Yes 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?
Bay City, MI 02FEB2015 Jacob Haglund 17 White male gun shoot not No No
Beaverton, MI 17SEP2015 Mark Gary 50 White male gun shoot not No No
Benton Township, MI 18NOV2015 Marcus Meridy 44 Black male gun shoot not No No
Bloomfield Township, MI 19AUG2015 Deviere Ernel Ransom 24 Black male gun shoot car No No
Cato Township, MI 10OCT2015 Travis Quay 40 White male other attack not No No
Dearborn, MI 23DEC2015 Kevin Matthews 35 Black male unarmed threat not Yes No
Detroit, MI 27APR2015 Terrance Kellom 20 Black male blunt_object threat not No No
Detroit, MI 23MAY2015 Caso Jackson 25 Black male gun point not Yes No
Eaton Rapids Township, MI 17FEB2015 Matthew Lundy 32 White male gun point not No No
Kentwood, MI 21OCT2015 Timothy Arnold 47 White male gun point not Yes No
Lansing, MI 24DEC2015 Terrozza Tyree Griffin 24 Black male gun shoot not No No
Marion, MI 15JUL2015 Eugene Kailing 43 White male blunt_object threat not Yes No
Portage, MI 14MAY2015 Sean Michael Pelletier 37 White male gun point car Yes No
Roxand Township, MI 28FEB2015 Deven Guilford 17 White male unarmed attack not No Yes
Trenton, MI 28MAY2015 Kyle Baker 18 White male blunt_object attack not No No
Wyoming, MI 29JAN2015 Alan James 31 White male gun shoot not Yes No

statecode=MN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Bloomington, MN 15JAN2015 Quincy Reed Reindl 24 White male gun point not Yes No
Cohasset, MN 22AUG2015 Adam Schneider 31 White male gun point not No No
Columbia Heights, MN 24NOV2015 Michael Kirvelay 45 White male replica threat not No No
Fridley, MN 08MAY2015 Sam Holmes 31 Black male   attack car No No
Hutchinson, MN 01NOV2015 Luverne Roy Christensen 49 White male gun shoot not No No
Minneapolis, MN 15NOV2015 Jamar Clark 24 Black male unarmed undetermined not No No
Mora, MN 29SEP2015 Robert Christen 37 White male unarmed attack not No No
New Hope, MN 26JAN2015 Raymond Kmetz 68 White male gun shoot not Yes No
Plymouth, MN 23JUL2015 Derek Wolfsteller 31 White male unarmed attack not Yes No
Saint Paul, MN 14JAN2015 Marcus Golden 24 Black male   attack not No No
Saint Paul, MN 16MAR2015 Justin Tolkinen 28 White male gun point not Yes No
Saint Paul, MN 24SEP2015 Philip Quinn 30 Native American male knife threat not Yes 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?
Columbia, MO 28FEB2015 Cornelius J. Parker 28 Black male gun shoot car No No
Columbia, MO 15APR2015 Mark W. Adair 51 White male replica point car No Yes
Franklin County, MO 14JAN2015 Michael Goebel 29 White male   attack not No No
Jennings, MO 17APR2015 Thaddeus McCarroll 23 Black male knife threat not Yes Yes
Kansas City, MO 13MAR2015 Fred Liggett Jr. 59 White male gun point not No No
Kansas City, MO 09JUL2015 Javon Hawkins 21 Black male knife threat not No No
Kansas City, MO 09SEP2015 Tyrone Holman 37 Black male other;gun threat not Yes No
Lakeshire, MO 05NOV2015 Jacob Hohman 30 White male blunt_object attack not No No
Lampe, MO 27NOV2015 Rick Gullickson 58 White male gun point not No No
Maysville, MO 29NOV2015 Lionel Kerns 53 White male gun point not No No
Ozark, MO 25NOV2015 Somer Speer 37 White female gun shoot not No No
Saint Louis, MO 21JAN2015 Isaac Holmes 19 Black male gun point not No No
Saint Louis, MO 03FEB2015 Ledarius D. Williams 23 Black male gun point foot No No
Saint Louis, MO 19AUG2015 Mansur Ball-Bey 18 Black male gun point foot No No
Saint Louis, MO 05DEC2015 Sheilah Huck 61 White female gun shoot not Yes No
Sedalia, MO 23MAY2015 James Horn Jr. 47 White male gun point not No No
Springfield, MO 17FEB2015 Michael Ireland 31 White male unarmed flee foot No No
Springfield, MO 04NOV2015 Joseph Tyndall 30 White male gun point foot No No
Springfield, MO 25NOV2015 Magnum Edgar Phillips 23 White male knife attack not No No
St Louis, MO 28FEB2015 Thomas Allen Jr. 34 Black male unarmed move car No No
Sugar Creek, MO 07JUL2015 Nicholas Booth 35 White male gun shoot car No No

statecode=MS

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=MS

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Barton, MS 01MAR2015 Donald Lewis Matkins 49 White male gun shoot not No No
Brookhaven, MS 12OCT2015 Rudolph Smith 31 White male gun shoot not No No
Columbus, MS 16OCT2015 Ricky Javenta Ball 33 Black male undetermined undetermined foot No Yes
Gulfport, MS 26FEB2015 Rodney Biggs 49 White male unarmed move not No No
Iuka, MS 15FEB2015 Howard Brent Means Jr. 34 White male gun shoot foot No No
Lucedale, MS 27DEC2015 Michael Parker 36 White male undetermined undetermined car No No
Ruth, MS 15MAR2015 Troy Ray Boyd 27 White male knife threat not No No
Smithville, MS 28OCT2015 Ricky Keith Keeton 57 White male replica shoot not No No

statecode=MT

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?
Archdale, NC 23AUG2015 Bobby Troledge Norris 53 Black male gun point not No No
Ashe County, NC 08JUL2015 Dallas Shatley 62 White male   attack car No Yes
Brevard, NC 09MAR2015 Lester Brown 58 White male gun point not No No
Canton, NC 19AUG2015 Wade Allen Baker 44 White male gun shoot not Yes No
Charlotte, NC 18FEB2015 Janisha Fonville 20 Black female knife threat not Yes No
Charlotte, NC 24DEC2015 Daquan Antonio Westbrook 18 Black male gun threat not No No
Dallas, NC 15DEC2015 Ronnie Dubose Carter 51 Black male   point car No No
Dublin, NC 17MAR2015 Declan Owen 24 White male gun shoot foot No No
Durham, NC 05SEP2015 La'vante Trevon Biggs 21 Black male replica point not Yes No
Franklin, NC 30JUN2015 Clay Alan Lickteig 52 White male gun shoot not No No
Gaston County, NC 17FEB2015 Betty Sexton 43 White female gun point not No No
Gastonia, NC 07FEB2015 James Allen 74 Black male gun point not No No
Gastonia, NC 16MAR2015 William Dean Poole 52 White male gun shoot not Yes No
Gastonia, NC 08AUG2015 Jeffrey Clyde Wilkes 59 White male gun shoot not No No
Greenville, NC 07AUG2015 Tsombe Clark 25 Black male gun shoot not No No
Pinnacle, NC 24JUL2015 Lee Aaron Gerston 30 White male knife threat not No No
Ronda, NC 22JUN2015 James Monroe Barrett 60 White male gun shoot foot No No
Salemburg, NC 12APR2015 Jason Lee Evans 32 White male gun point car Yes No
Spring Lake, NC 15NOV2015 John David Livingston 32 White male other attack not No No
Tarboro, NC 28FEB2015 Ian Sherrod 40 Black male gun shoot car Yes No
Wadesboro, NC 06NOV2015 Kim Lee Long 48 White male undetermined undetermined not No No
Wake Forest, NC 06MAY2015 David William Johnson 18 White male gun point car No No
Wake Forest, NC 21AUG2015 Alan Joseph Rushton 38 White male knife threat 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?
Wood Lake, ND 16JUN2015 Joe Charboneau 31 Native American male gun point not No No

statecode=NE

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NE

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Big Springs, NE 03DEC2015 Neil Scott Stretesky 66 White male gun shoot not No No
Lincoln, NE 05MAR2015 Tyson Hubbard 34 White male gun attack not No No
Lincoln, NE 29NOV2015 Zachary Grigsby 29 White male gun shoot   No No
Omaha, NE 27JAN2015 Tiffany Terry 39 White female knife attack not Yes No
Omaha, NE 23FEB2015 Daniel Elrod 39 White male unarmed move not No No
Omaha, NE 20MAY2015 Marcus Wheeler 26 Black male gun shoot not No No
Omaha, NE 23JUN2015 Taylor Culbertson 32 White male gun shoot not No No
Sidney, NE 19APR2015 Dana Hlavinka 44 White 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?
Bath, NH 06JUL2015 Hagen Esty-Lennon 42 White male knife threat not Yes Yes
Derry, NH 21JAN2015 Andrew Toto 54 White male gun shoot not Yes No
Merrimack, NH 04SEP2015 Harrison Lambert 23 White male knife threat not 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 07JUL2015 Tremaine Dantzler 37 Black male knife attack foot No No
Brick Township, NJ 23AUG2015 Julian Hoffman 21 White male replica point not No No
Byram, NJ 03JUN2015 Ronald Neal 56 White male gun point not Yes No
Camden, NJ 03JUL2015 Oscar Camacho 33 Hispanic male replica point not Yes No
Camden, NJ 24NOV2015 Freddy Baez Jr. 24 Hispanic male gun shoot not No No
Hackensack, NJ 21MAY2015 Elvin Diaz 24 Hispanic male knife threat not Yes No
Hackensack, NJ 11JUN2015 Raymond Peralta-Lantigua 22 Hispanic male knife threat not Yes No
Hamilton, NJ 01APR2015 Shawn Clyde 36 White male knife attack not No No
Ideal Beach, NJ 27MAY2015 Scott McAllister 39 White male knife attack not No No
Little Egg Harbor, NJ 17NOV2015 Francis Hartnett 47 White male gun attack not Yes No
Lyndhurst, NJ 29MAY2015 Kevin Allen 36 Black male knife threat not No No
Old Bridge, NJ 14JAN2015 Talbot Schroeder 75 White male knife attack not No No
Trenton, NJ 21APR2015 Daniel Wolfe 35 Black male   attack not No No
Winslow, NJ 25JAN2015 William Campbell 59   male gun point not No No
Woodbridge, NJ 05OCT2015 Rodney Jencsik 49 White male gun point 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?
Albuquerque, NM 13JAN2015 John Edward O'Keefe 34 White male gun shoot foot No Yes
Albuquerque, NM 03MAY2015 Billy Grimm 44 Hispanic male gun point not No No
Albuquerque, NM 31JUL2015 Rafael Molina Jr. 33 Hispanic male gun point not No Yes
Albuquerque, NM 11NOV2015 Joseph Jaramillo 31 Hispanic male   threat car No No
Albuquerque, NM 22DEC2015 Jose Rodriguez 19 Hispanic male gun undetermined foot No Yes
Artesia, NM 01SEP2015 Michael Todd Evans 47 White male gun shoot not No No
Deming, NM 02DEC2015 Florencio Lucero 36 Hispanic male gun point not No No
Edgewood, NM 04APR2015 Ethan Noll 34 White male gun point car Yes No
Hobbs, NM 17JUN2015 Kenneth Lanphier 48 White male gun shoot not Yes No
Hobbs, NM 12AUG2015 William Smith 49 White male gun undetermined car No No
Hobbs, NM 06SEP2015 William Verrett 45 White male gun point not No No
Las Cruces, NM 29JUL2015 Michael Malone 34 Hispanic male gun undetermined foot No No
Los Lunas, NM 03JUN2015 Rudy Baca 36 Hispanic male unarmed attack not No No
Lovington, NM 26SEP2015 Alejandro Lerma 23 Hispanic male gun shoot not No No
Roswell, NM 31JUL2015 Jeremy Hatch 34 White male gun shoot not No No
Ruidoso, NM 21FEB2015 Jason Moncrief Carter 41 White male gun point not No No
Ruidoso, NM 17MAY2015 Timothy Jones 27 White male knife threat not No No
Santa Fe, NM 25AUG2015 Marvin Maestas 30 Hispanic male gun shoot foot No No
Taos, NM 18DEC2015 Robert L. Martinez 58 Hispanic male replica point not Yes No
Truth or Consequences, NM 20OCT2015 Joel Lopes 40 Hispanic male gun point not No No

statecode=NV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=NV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Boulder City, NV 30MAR2015 John Marcell Allen 54   male gun shoot not No No
Carson City, NV 15AUG2015 Jonathon Pope 30 White male gun shoot not No No
Gardnerville Ranchos, NV 30JUL2015 Mark Perkins 48 White male gun point not No No
Henderson, NV 04JUL2015 Bryan David Bauer 36 White male gun attack not No No
Las Vegas, NV 25FEB2015 Francis Spivey 43 White male gun shoot not Yes No
Las Vegas, NV 10JUL2015 James Michael Todora 54 White male gun shoot not Yes Yes
Las Vegas, NV 25JUL2015 Bryan Keith Day 36 Black male replica shoot not No No
Las Vegas, NV 07AUG2015 Abel Correa 24 Hispanic male knife threat not Yes Yes
Las Vegas, NV 23AUG2015 William Lee Snider 57 White male gun shoot not No No
Las Vegas, NV 15OCT2015 Linda Lee Lush 50 White female gun shoot car Yes No
Las Vegas, NV 06NOV2015 James Francis Smyth 55 White male   threat car No No
Las Vegas, NV 24NOV2015 Thomas Joseph Mceniry 32 White male replica point foot Yes Yes
Las Vegas, NV 14DEC2015 Brenda Dean Kimberling 48 White female gun point not Yes No
Las Vegas, NV 14DEC2015 Roberto Sanchez 45 Hispanic male gun point not No No
Las Vegas, NV 31DEC2015 Keith Childress Jr. 23 Black male unarmed move not No Yes
North Las Vegas, NV 11JAN2015 Salvador Figueroa 29 Hispanic male gun point foot No No
North Las Vegas, NV 29AUG2015 James Marcus Brown 25 Black male gun point foot No No
North Las Vegas, NV 22SEP2015 Donaven Kyle Anderson 26   male gun shoot not No No
Reno, NV 22NOV2015 Matthew Grows 45 White male gun shoot 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?
Beacon, NY 07MAY2015 Michael Murphy 38 White male knife threat car No No
Bronx, NY 10JUN2015 Isiah Hampton 19 Black male gun point not No No
Clarendon, NY 21MAR2015 James Ellis 44 White male gun shoot car No No
Coney Island, NY 18JUN2015 Oleg Tcherniak 58 White male knife attack foot No No
Constantia, NY 08MAY2015 David Schwalm 58 White male gun point not Yes No
Edinburg, NY 29JUN2015 Richard LaPort 51 White male gun shoot not Yes No
Greece, NY 01JUN2015 Joseph Ladd 23 White male gun attack other Yes No
Islip, NY 22MAR2015 Denzel Brown 21 Black male undetermined attack car No No
Malone, NY 26JUN2015 Richard Matt 49 White male gun point other No No
Mount Vernon, NY 28AUG2015 Felix Kumi 61 Black male unarmed accident not No No
New City, NY 08FEB2015 Vincent Cordaro 57 White male gun shoot not Yes No
New Paltz, NY 24OCT2015 John Michael Tozzi 60 White male gun shoot not No No
New York, NY 25APR2015 David Felix 24 Black male unarmed attack foot Yes No
Potsdam, NY 10SEP2015 Tian Ma 31 Asian male knife attack not No No
Queens, NY 22APR2015 Jonathan Efraim 30 White male gun shoot foot Yes No
Queens, NY 26MAY2015 Dalton Branch 51 Black male gun shoot not No No
Staten Island, NY 14AUG2015 Garland Tyree 38 Black male gun shoot not No No
Troy, NY 22AUG2015 Thaddeus Faison 39 Black male gun shoot foot No No
Yonkers, NY 08DEC2015 Miguel Espinal 36 Black male unarmed flee foot 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 25SEP2015 William Lemmon 21 White male unarmed undetermined other Yes No
Akron, OH 05OCT2015 Omar Ali 27 Other male unarmed move not No No
Beverly, OH 20AUG2015 Tyler Gerken 19 White male gun shoot not Yes No
Celina, OH 29NOV2015 Justin D. McHenry 22 White male gun shoot not No No
Cincinnati, OH 09JUN2015 QuanDavier Hicks 22 Black male gun point not No No
Cincinnati, OH 19JUN2015 Trepierre Hummons 21 Black male gun shoot not Yes No
Cleveland, OH 10MAR2015 Theodore Johnson 64 Black male gun shoot not No Yes
Cleveland, OH 19MAR2015 Brandon Jones 18 Black male unarmed attack not No No
Cleveland, OH 08DEC2015 Derek Stokes 33 Black male gun shoot not No No
Columbus, OH 07JAN2015 Hashim Hanif Ibn Abdul-Rasheed 41 Black male knife threat not Yes No
Columbus, OH 27JAN2015 Jermonte Fletcher 33 Black male gun shoot not No No
Columbus, OH 21MAR2015 Jason Smith 42 White male gun point not No No
Columbus, OH 15OCT2015 Kaleb Alexander 25 Black male gun point not No No
Columbus, OH 29OCT2015 Deaunte Lamar Bell 25 Black male gun move not No No
Columbus, OH 23NOV2015 Barry Kirk 50 White male gun shoot not No No
Dayton, OH 23JUL2015 Dontae L. Martin 34 Black male gun point not No No
Findlay, OH 09JUN2015 Jeremy Linhart 30 White male unarmed attack not No No
Green, OH 20MAY2015 Jonathan Colley 52 White male knife threat not No No
Jasper, OH 29MAR2015 Robert Rooker 26 White male   attack car No No
Kent, OH 17DEC2015 Douglas Yon 25 White male knife threat not Yes No
Mansfield, OH 28APR2015 David Parker 58 White male gun shoot not No No
Mt. Auburn, OH 19JUL2015 Samuel DuBose 43 Black male unarmed flee car No Yes
Northwood, OH 18DEC2015 Erica Lauro 22 White female gun shoot other No No
Parma, OH 15OCT2015 Michael J. Brennan 31 White male replica point car No No
Richmond Heights, OH 06DEC2015 Carlumandarlo Zaramo 46 Black male gun shoot not Yes No
Southington, OH 14JUL2015 Charles D. Crandall 76   male gun shoot not No No
Toledo, OH 12AUG2015 Reginald Marshall 27 Black male gun shoot car No No
Twinsburg, OH 01SEP2015 Charles Robert Shaw 76 White male gun shoot not No No
Zanesville, OH 24OCT2015 Arthur West Jr. 28 White male gun point not Yes No

statecode=OK

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=OK

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Ardmore, OK 09AUG2015 Eric Tompkins 41 White male gun point not Yes No
Bunch, OK 26APR2015 Billy Joe Patrick 29 White male unarmed attack not No No
Chickasha, OK 29APR2015 Andrew Jackson 26 White male knife threat foot No No
Coal County, OK 20MAR2015 Tyrel Vick 34 White male gun shoot not No No
Colbert, OK 21NOV2015 Chris Nichols 24 White male unarmed attack foot No No
Cushing, OK 30AUG2015 Shawn Hall 20 White male gun point not No No
Edmond, OK 27MAY2015 Garrett Sandeno 24 White male replica point not Yes No
Guthrie, OK 04JAN2015 Kenneth Joe Brown 18 White male gun attack not No No
Healdton, OK 12DEC2015 Jonathan Wardlow 36 White male other point not No No
Hominy, OK 05NOV2015 James Bigley 20 White male gun point car Yes No
Kellyville, OK 09APR2015 Mark Dean Smith 54 White male   attack other No No
Lawton, OK 12OCT2015 Jason Day 40 Black male gun point not No No
McAlester, OK 13SEP2015 Clifford Butler Jr. 67 Black male gun shoot not Yes No
Miami, OK 24APR2015 Gary Timmie Collins 63 White male gun point car No No
Midwest City, OK 05OCT2015 Charles A. Pettit Jr. 18 Black male gun point not No No
Muskogee, OK 17JAN2015 Terence Walker 21 Black male gun point foot No Yes
Norwood, OK 30OCT2015 Daniel Nole 30 White male knife attack foot No No
Oklahoma City, OK 06FEB2015 Herbert Hill 25 Black male gun shoot not No No
Oklahoma City, OK 25FEB2015 Glenn Lewis 27 Black male   threat car No No
Oklahoma City, OK 08MAR2015 Aurelio Duarte 40 Hispanic male gun point not No No
Oklahoma City, OK 12APR2015 Richard Dale Weaver 83 White male knife threat not Yes No
Oklahoma City, OK 04JUL2015 Robert Elando Malone 42 Black male gun point foot No No
Oklahoma City, OK 06JUL2015 Tyler Rogers 20 White male gun point not No No
Oklahoma City, OK 22JUL2015 Andre Dontrell Williams 26 Black male knife threat other No No
Okmulgee County, OK 29MAY2015 Nehemiah Fischer 35 White male gun attack not No No
Pottawatomie County, OK 07APR2015 Erick Rose 32 White male gun shoot car No No
Pryor, OK 09DEC2015 Sammy Monroe Echols Jr. 51 White male gun shoot not Yes No
Rufe, OK 23APR2015 Joseph Potts 51 White male gun shoot not No No
Sand Springs, OK 11APR2015 Donald Allen 66 White male gun point not Yes Yes
Stillwater, OK 29JAN2015 Ralph Willis 42 White male unarmed move foot No No
Tahlequah, OK 27JUN2015 Joshua Crittenden 35 White male gun shoot not No Yes
Tulsa, OK 02APR2015 Eric Harris 44 Black male unarmed accident 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?
Aloha, OR 02JAN2015 Lewis Lee Lembke 47 White male gun point not No No
Aloha, OR 02OCT2015 Phyllis Ilene Jepsen 55 White female knife threat not Yes No
Beaverton, OR 08JUL2015 Michael Terence Westrich 59 White male gun shoot not No No
Colton, OR 15FEB2015 Bruce Steward 34 White male knife threat not Yes No
Eugene, OR 30MAR2015 Brian Babb 49 White male gun point not Yes No
Eugene, OR 24APR2015 Mark Cecil Hawkins 49 White male gun shoot not No No
Josephine County, OR 01JUL2015 Kaleb Landon 32 White male gun attack car No No
McMinnville, OR 01JUL2015 Kevin Lamont Judson 24 Black male   attack foot No No
Medford, OR 17MAR2015 Andrew Charles Shipley 49 White male gun shoot not Yes No
Medford, OR 31MAY2015 James Anthony Morris 40   male gun shoot not Yes No
Portland, OR 22MAR2015 Christopher Ryan Healy 36 White male knife threat foot Yes No
Portland, OR 28JUN2015 Alan Bellew 29 White male replica point not No No
Portland, OR 06NOV2015 Michael Johnson 51 White male gun shoot not Yes No
Salem, OR 28OCT2015 Jasper Levi Adams 35 White male gun point car No No
Wilderville, OR 29MAY2015 Robert Box 55 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?
Allentown, PA 23FEB2015 Jerome Nichols 42 White male knife attack car No No
Campbelltown, PA 03AUG2015 Joshua Malave 18 White male gun shoot foot No No
Canaan Township, PA 21DEC2015 Derek DeGroat 21 White male gun point not Yes No
Chester, PA 11SEP2015 Robert T. Edwards 31 White male gun point not No No
East Stroudsburg, PA 12DEC2015 Andrew Jospeh Todd 20 White male gun point not Yes No
Germantown, PA 15NOV2015 Shane Whitehead 16 Black male gun attack not No No
Hummelstown, PA 02FEB2015 David Kassick 59 White male unarmed flee foot No No
Knoxville, PA 06JAN2015 Leslie Sapp III 47 Black male replica point not No No
Lancaster, PA 20MAY2015 Anthony Gomez 29 Black male gun shoot not No No
Mount Washington, PA 04DEC2015 Raymone M. Davis 21 Black male gun point not No No
Philadelphia, PA 22JUL2015 Devon Guisherd 27 Black male gun shoot not No No
Pittsburgh, PA 22JUN2015 Tyrone Harris 20 Black male gun shoot car No No
Pittston, PA 09AUG2015 Robert Patrick Quinn 77   male replica point not Yes No
Reading, PA 13FEB2015 Richard Carlin 35 Hispanic male unarmed move not No No
Somerset, PA 22MAY2015 Michael Lowery 40 White male replica point not No No
Straban Township, PA 09APR2015 Jess Leipold 31 White male gun shoot not Yes No
West Chester, PA 25AUG2015 Curtis Smith 34 Black male knife attack not No No
York, PA 17OCT2015 Dequan Williams 28 Black male knife threat not Yes No

statecode=SC

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=SC

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Aiken, SC 11NOV2015 Brian Gavin 57 White male gun point not No No
Boiling Springs, SC 09APR2015 Phillip Burgess 28 White male gun point not No No
Cayce, SC 17NOV2015 Demetrius Bryant 21 Black male gun shoot not No No
Charleston, SC 21MAY2015 Jerome Caldwell 32 Black male gun shoot not No No
Goose Creek, SC 05NOV2015 Laura Lemieux 36 White female gun point not Yes No
Irmo, SC 21APR2015 Kimber Key 59 White male knife threat not Yes No
Irmo, SC 27JUL2015 Timothy Milliken 56 White male knife attack not No No
Johnsonville, SC 25MAR2015 Jeremy Lorenza Kelly 27 Black male gun shoot foot No No
Lancaster, SC 28MAY2015 Darrell Morgan 60 White male gun point not No No
Myrtle Beach, SC 23JUL2015 Brian Stortzum 32 White male gun point not No No
North Charleston, SC 04APR2015 Walter Scott 50 Black male unarmed flee foot No No
North Charleston, SC 21MAY2015 James Anthony Cooper 43 White male knife attack not No No
Pelzer, SC 28FEB2015 Chazsten Freeman 24 White male gun shoot not No No
Seneca, SC 26JUL2015 Zachary Hammond 19 White male   threat other No No
Spartanburg, SC 15APR2015 Dante Noble 41 Black male knife attack not No No
Spartanburg, SC 09NOV2015 Delvin Simmons 20 Black male   attack car No No
Summerville, SC 08AUG2015 Shamir Terrel Palmer 24 Black male gun shoot car No No
Taylors, SC 11OCT2015 Bernard Brandon Powers 23 Black male gun shoot not No No
Taylors, SC 10DEC2015 Charles Edward Rosemond Sr. 55 Black male gun shoot not No No

statecode=SD

statecode=TN

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=TN

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Antioch, TN 05AUG2015 Vincente Montano 29 White male knife attack not Yes No
Chattanooga, TN 16JUL2015 Mohammad Youssef Abdulazeez 24 Other male gun shoot not Yes No
Chattanooga, TN 26AUG2015 Brent Pickard 46 White male gun point car No No
Chattanooga, TN 12DEC2015 Javario Shante Eagle 24 Black male gun;knife point not No No
Columbia, TN 11JUN2015 Raymond Phillips 86   male gun point not Yes No
Dickson, TN 18SEP2015 Gregory Herrell 47 White male undetermined undetermined not No No
Gibson County, TN 13NOV2015 Michael Joseph Bartkiewicz 52 White male replica point not No No
Hendersonville, TN 26AUG2015 Steven Dodd 22 White male replica point not Yes No
Hohenwald, TN 29OCT2015 Allen Quintez Swader 18 White male gun shoot not No No
Humboldt, TN 14DEC2015 Michael Thomason 56 White male undetermined undetermined not No No
Knoxville, TN 18DEC2015 Amos Frerichs 32 White male   attack car No No
McLemoresville, TN 13FEB2015 Matthew D. Belk 27 White male gun point not No No
Memphis, TN 04FEB2015 Markell Atkins 36 Black male knife threat not No No
Memphis, TN 11MAR2015 James Greenwell 31 White male gun shoot not Yes No
Memphis, TN 17JUL2015 Darrius Stewart 19 Black male unarmed attack foot No No
Morristown, TN 04JUL2015 Michael Shannon Gaby 37 White male gun point not No No
Nashville, TN 29APR2015 John Acree 53 White male gun point not Yes No
Nashville, TN 30MAY2015 Alexander Tirado Rivera 39 Hispanic male replica point not No No
West Knox, TN 12SEP2015 Jack Stevens Jr. 45 White male gun point not No No
Whitehaven, TN 10FEB2015 Anthony Bess 49 Black 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?
Alvin, TX 04MAY2015 Alfredo Vasquez 38 Hispanic male gun shoot not No No
Amarillo, TX 02OCT2015 Matthew Dobbins 29 White male unarmed undetermined not No No
Amarillo, TX 20DEC2015 Mark Ramirez 31 Hispanic male gun point not Yes No
Arlington, TX 07AUG2015 Christian James Taylor 19 Black male unarmed threat not No No
Arlington, TX 13DEC2015 Shirley Farmer Weis 51 White female gun point not Yes No
Austin, TX 23JAN2015 Robert Francis Mesch 61 White male gun point not Yes No
Austin, TX 08FEB2015 Sawyer Flache 27 White male gun shoot not No No
Austin, TX 25MAY2015 Cassandra Bolin 31 White female gun point not Yes No
Austin, TX 05JUL2015 Michael Holt 35 White male gun shoot foot No No
Austin, TX 05JUL2015 Richard Munroe 25 White male replica point not Yes No
Austin, TX 12JUL2015 David Lepine 60 White male gun point foot No No
Azle, TX 02JUN2015 Kamal Dajani 26 White male knife attack not Yes No
Baytown, TX 31MAR2015 Benjamin Quezada 21 Hispanic male replica point not No No
Bexar County, TX 11JUN2015 Mark Anthony Flores Jr. 28 Hispanic male gun shoot not Yes No
Boerne, TX 14AUG2015 Hector Rene Sorriano Gonzalez 26 Hispanic male gun point not No No
Brookshire, TX 08AUG2015 Roderick Burr 33 Black male gun shoot not No No
Brownsville, TX 17JUL2015 Jose Roman Rodriguez 24 Hispanic male knife move other No No
Chapeno, TX 21JAN2015 Miguel Angel de Santos-Rodriguez 36 Hispanic male gun shoot foot No No
Clute, TX 13SEP2015 Jeffrey Eugene Brooks 29 White male gun point car No No
Corpus Christi, TX 23NOV2015 Henry Reyna 49 Hispanic male knife threat not No Yes
Dallas, TX 09FEB2015 Desmond Luster 45 Black male gun shoot not No No
Dallas, TX 07JUL2015 Joe Cody 59 White male gun point not No No
Dallas, TX 27AUG2015 Bertrand Davis 42 Black male knife attack not No No
Dallas, TX 21SEP2015 Gerardo Ramirez 24 Hispanic male gun shoot not Yes No
DeSoto, TX 14APR2015 Colby Robinson 26 Black male undetermined threat foot No No
Del Rio, TX 17FEB2015 Pedro Juan Saldivar 50 Hispanic male   threat not No No
Denton, TX 13DEC2015 Ryan McMillan 21 White male blunt_object threat not Yes No
Edinburg, TX 07JUL2015 Jose Graciano Lopez 39 Hispanic male gun shoot not Yes No
El Paso, TX 09JAN2015 Andy Martinez 33 Hispanic male gun point not No No
El Paso, TX 30APR2015 Erick Emmanuel Sanchez 22 Hispanic male blunt_object threat not No No
El Paso, TX 21MAY2015 David Alejandro Gandara 22 Hispanic male gun undetermined not Yes No
El Paso, TX 06AUG2015 Charles Bertram 22 Black male gun shoot car No No
Ellis County, TX 03JUN2015 Miguel Martinez 18 Hispanic male gun point car Yes No
Euless, TX 20FEB2015 Ruben Villalpando 31 Hispanic male unarmed move not No No
Fort Worth, TX 17JAN2015 Daniel Brumley 27 Hispanic male knife attack not No No
Fort Worth, TX 24JAN2015 Wendell King 40 White male gun shoot not No No
Fort Worth, TX 22APR2015 Reginald McGregor 31 Black male gun shoot foot No No
Fort Worth, TX 11MAY2015 Kelvin Goldston 30 Black male   attack car No No
Fort Worth, TX 30JUL2015 Philip Vallejo 30 Hispanic male gun point not No No
Freeport, TX 07JAN2015 Ron Sneed 31 Black male gun point not No No
Fuqua, TX 03JUN2015 Edelmiro Hernandez 33 Hispanic male knife threat car No No
Garland, TX 03MAY2015 Elton Simpson 30 Black male gun shoot not No No
Garland, TX 03MAY2015 Nadir Soofi 34 Other male gun shoot not No No
Houston, TX 31JAN2015 Victor Manuel Reyes 31 Hispanic male gun point not No No
Houston, TX 20FEB2015 Alejandro Salazar   Hispanic male gun point car No No
Houston, TX 01MAR2015 Hung Trieu 35 Asian male gun shoot not No No
Houston, TX 15APR2015 Frank Shephard 41 Black male unarmed move car No No
Houston, TX 21JUN2015 Charles Marshall 49 White male other threat not Yes No
Houston, TX 07JUL2015 Marcellus Jamarcus Burley 18 Black male gun shoot not No No
Houston, TX 02AUG2015 Virgil Reynolds 63 White male   threat not Yes No
Houston, TX 17AUG2015 Frederick Roy 35 Black male gun point not No No
Houston, TX 15OCT2015 Martin Ryans Jr. 20 Black male gun point not No No
Houston, TX 16OCT2015 Jeffrey Womack 27 White male gun point not Yes No
Houston, TX 30OCT2015 Tony Berry 25 Black male gun threat foot No No
Houston, TX 30OCT2015 Brian Crawford 24 Black male gun point not No No
Houston, TX 04NOV2015 John Allen 57 Black male gun point car No No
Hurst, TX 05OCT2015 James Dunaway 51 White male gun point foot No No
Hutchins, TX 13JUN2015 James Boulware 35 White male other;gun shoot not Yes No
Irving, TX 05DEC2015 Colten Price Marcellus 24 White male gun shoot foot No No
Jourdanton, TX 13JAN2015 Richard McClendon 43 White male knife threat not Yes No
Kerrville, TX 16AUG2015 Steven B. Norton 47 White male gun shoot not No No
Lake Jackson, TX 14JAN2015 Robert Edwards 68 White male gun point not No No
Laredo, TX 14FEB2015 Roy Joy Day 51 White male gun shoot not No No
Leon County, TX 16NOV2015 Cameron Davis Long 28 White male   undetermined car No No
Levelland, TX 23JAN2015 Jose Antonio Espinoza Ruiz 56 Hispanic male knife threat not No No
Longview, TX 22JAN2015 Kristiana Coignard 17 White female knife threat not Yes No
Longview, TX 28AUG2015 Devin Brian Dial 23 White male gun point not No No
Lorena, TX 04FEB2015 Jimmy Ray Robinson Jr. Jr. 51 Black male gun point car No No
Mabank, TX 16JAN2015 Scott Hall 41 White male gun shoot car No No
McKinney, TX 23SEP2015 Joseph Khammash 35 White male gun shoot not No No
Mesquite, TX 30OCT2015 Mario Martinez 29 Hispanic male gun point car No No
Midland, TX 06JUN2015 Joe Nevels 42 White male knife threat not Yes No
Mission, TX 20APR2015 Santos Cortez Hernandez 25 Hispanic male gun move not No No
Nocona, TX 08FEB2015 Larry Hostetter 41 White male gun point not No No
North Laredo, TX 09NOV2015 Cesar Cuellar Jr. 25 Hispanic male gun point not Yes No
Odessa, TX 12AUG2015 Richard Dean Shull Jr. 24 White male gun shoot not No No
Onalaska, TX 17MAR2015 Eugene Smith II 20 White male gun shoot not Yes No
Palestine, TX 31MAY2015 James Bushey 47 White male replica point not No Yes
Paris, TX 21SEP2015 Garrett Steven McKinney 21 White male unarmed attack not No No
Ponder, TX 27SEP2015 Victor Oswaldo Coronado-Martinez 40 Hispanic male gun shoot not No No
Rosenberg, TX 28JAN2015 Cody Karasek 26 White male gun shoot not No No
San Antonio, TX 14MAR2015 Richard Castilleja 29 Hispanic male gun shoot not Yes No
San Antonio, TX 08APR2015 Douglas Faith 60 White male gun shoot car No No
San Antonio, TX 26JUN2015 Joe Angel Cisneros 28 Hispanic male gun move foot No No
San Antonio, TX 28AUG2015 Gilbert Flores 41 Hispanic male undetermined undetermined not Yes No
San Antonio, TX 29AUG2015 Roger Albrecht 43 White male knife threat not No No
San Antonio, TX 02DEC2015 Allen Pacheco 32 Hispanic male gun threat not No No
Seagoville, TX 28NOV2015 Kevin Close 50 White male blunt_object;blunt_object threat not No No
Sierra Blanca, TX 22JAN2015 Tiano Meton 25 Black male replica point car No No
Springtown, TX 04SEP2015 Sully Lanier 36 White male gun shoot not No No
Sunset, TX 28JAN2015 Alan Lance Alverson 45 White male gun shoot not No No
Tahoka, TX 26JAN2015 Joshua Omar Garcia 24 Hispanic male unarmed flee car No No
Tomball, TX 09JUN2015 Greg Hartley 45 White male gun point car No No
Victoria, TX 25APR2015 Brandon Lawrence 25 White male knife threat not Yes Yes
Waco, TX 11AUG2015 Randall Lance Hughes 48 White male knife threat not No No
Weatherford, TX 23JUN2015 Randall Waddel 49 White male knife threat foot Yes No
Weatherford, TX 17NOV2015 Jeray Chatham 30 Black male knife threat car No No
Weatherford, TX 17NOV2015 Michael Tindall 41 White male gun undetermined car No No
West Odessa, TX 11OCT2015 Robert Humberto Medellin 43 Hispanic male knife threat car No No
Wink, TX 30NOV2015 Fernando Sauceda 31 Hispanic male undetermined threat not No No
Winnie, TX 20JUL2015 Joshua LeBoeuf 35 White male gun shoot other No No

statecode=UT

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=UT

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Draper, UT 14JAN2015 Jeffrey R. Nielson 34 White male knife attack not No Yes
Logan, UT 29JUL2015 Roger Darrin Barker 53 White male gun shoot not Yes No
Parowan, UT 09JUL2015 Rocco Joseph Palmisano III 50 White male gun point not No No
Provo, UT 16FEB2015 Cody Evans 24 White male replica point not Yes No
Roosevelt, UT 03MAY2015 Kevin Vance Norton 36 White male gun point not Yes Yes
Salt Lake City, UT 08JAN2015 James Dudley Barker 42 White male blunt_object attack not No Yes
Salt Lake City, UT 23SEP2015 Robert Berger 48 Hispanic male knife attack not No No
Spanish Fork, UT 28AUG2015 William Evans 28 White male gun shoot not Yes Yes
Syracuse, UT 08JAN2015 Thomas Hamby 49 White male gun shoot not No Yes
West Jordan, UT 26AUG2015 Kyle Lambrose 27 White male gun shoot not Yes 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?
Arlington, VA 19MAY2015 Alfredo Rials-Torres 54 Hispanic male unarmed attack not No No
Chesapeake, VA 14JAN2015 Mario Jordan 34 Black male gun shoot not Yes No
Emporia, VA 29APR2015 Jeffrey Adkins 53 Black male gun shoot not Yes No
Grayson County, VA 23SEP2015 Kenneth Ray Pinter Jr. 45 White male gun shoot not No No
Harrisonburg, VA 20SEP2015 Michael Thomas Pierce Jr. 23 White male gun point not No Yes
King George, VA 22AUG2015 Kenneth Henry Morgan 64 White male knife threat not No No
Newport News, VA 04JUL2015 Kawanza Beaty 23 Black male gun point foot No No
Portsmouth, VA 24MAR2015 Walter J. Brown III 29 Black male gun point car Yes No
Portsmouth, VA 22APR2015 William Chapman II 18 Black male unarmed threat not No No
Powhatan County, VA 03AUG2015 Franklin Short 71 White male gun point not No No
Pulaski, VA 05MAY2015 Robert A. Frost 46 White male gun shoot not Yes No
Richmond, VA 05AUG2015 Keshawn Dominique Hargrove 20 Black male gun shoot foot No No
Suffolk, VA 28DEC2015 Corey Jason Achstein 28 White male replica point not No Yes
Virginia Beach, VA 05SEP2015 Angelo Delano Perry 35 Black male gun shoot not No No
Virginia Beach, VA 05SEP2015 India Kager 27 Black female unarmed undetermined not No No
Winchester, VA 03APR2015 Christopher Prevatt 38 White male knife threat not No Yes
York County, VA 24JUN2015 Damien A. Harrell 26 Black male gun point not No Yes

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 22DEC2015 Kenneth Stephens 56 White male gun shoot not 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?
Grapeview, WA 21AUG2015 Timmy Walling 57 White male gun point not Yes No
Hunters, WA 19AUG2015 Jason Hale 29 White male gun point foot Yes No
Kennewick, WA 04MAY2015 Roark Cook 36 White male replica point not Yes No
Kirkland, WA 15OCT2015 Robert Burgess 35 White male gun point foot No No
Lakewood, WA 21APR2015 Daniel Covarrubias 37 Native American male unarmed move foot Yes No
Olympia, WA 13DEC2015 Nephi Leiataua 30 Asian male knife attack not No No
Pasco, WA 10FEB2015 Antonio Zambrano-Montes 35 Hispanic male unarmed flee foot Yes No
Seattle, WA 17JUL2015 Samuel Smith 27 White male knife threat foot No No
Seattle, WA 06DEC2015 Raymond Azevedo 35 White male gun shoot car No No
Shelton, WA 02JAN2015 Tim Elliot 53 Asian male gun point not Yes No
Snohomish, WA 26MAY2015 Millard Tallant III 62 White male gun point not Yes No
Spokane, WA 08AUG2015 Kevin McDaniel 46 White male gun shoot not No No
Sumas, WA 19MAR2015 Jamison Childress 20 White male unarmed attack not Yes No
Tacoma, WA 10MAY2015 Stephen Cunningham 47 White male gun point not No No
Tacoma, WA 05AUG2015 Jason Galaviz 40 White male gun point not No No
Woodland, WA 07JUN2015 Gene Marshall 58 White male gun point 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?
Ashwaubenon, WI 09SEP2015 Dustin Kuik 25 White male gun shoot not No No
Fond du Lac, WI 24MAR2015 Stephen Snyder 38 White male gun shoot not No No
Green Bay, WI 24FEB2015 Joseph Biegert 30 White male knife attack not Yes No
Greenfield, WI 05AUG2015 John Dieringer 51 White male knife threat not Yes No
Kenosha, WI 14MAR2015 Aaron Siler 26 White male gun point car No No
Madison, WI 06MAR2015 Tony Robinson 19 Black male unarmed attack foot No No
Milwaukee, WI 05MAR2015 Tyrone Ryerson Lawrence 45 Black male knife threat not Yes No
Monroe, WI 22JUL2015 Francisco Benitez-Santiago 25 Hispanic male gun shoot not No No
Neenah, WI 05DEC2015 Michael L. Funk 60 White male gun move not No No
Paddock Lake, WI 24OCT2015 Darren Myron Fude 47 White male gun point not No No
Wauwatosa, WI 16JUL2015 Antonio Gonzalez 29 Hispanic male knife threat not Yes No

statecode=WV

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WV

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Beckley, WV 30SEP2015 Brandon Lamar Johnson 28 Black male gun point car No No
Bluefield, WV 01SEP2015 Cedric Maurice Williams 33 Black male other;gun shoot foot No No
Braxton County, WV 09NOV2015 Dale Maverick Hudson 26 White male gun shoot not No No
Follansbee, WV 14MAR2015 Clifton Reintzel 53 White male knife threat not No No
Fort Ashby, WV 27MAR2015 Harvey Oates 42 White male gun point car No No
Meadow Bridge, WV 02JUL2015 Brian Johnson 59   male other attack not Yes No
Morgantown, WV 05JUN2015 Christie Cathers 45 White female vehicle threat car No No
Morgantown, WV 05NOV2015 David Romanoski 48 White male gun point not No No
Mount Hope, WV 14DEC2015 Mark Toney 33 White male gun point not No No
Nitro, WV 01AUG2015 David Cook 52   male gun shoot not No No

statecode=WY

Data Set WORK.TEMP_SHOOTINGS_DATA

statecode=WY

City Date Name Age Race Sex Armed with Threat type Flee status Was mental illness related? Body camera?
Casper, WY 12JUL2015 Christopher Benton 27 White male gun point not No No
Cheyenne, WY 16JUL2015 Saige Hack 23 Native American male gun shoot not No No
Douglas, WY 23JUL2015 Robbie Lee Edison 47 White male replica point not No No
Gillette, WY 20MAY2015 Nikki Jo Burtsfield 39 White female knife threat car No No
Laramie, WY 06DEC2015 John Alan Britton 48 White male knife threat not Yes No
Rawlins, WY 30DEC2015 John Randell Veach 39 White male undetermined undetermined   No No