Police Killings: police_killings.csv

This directory contains the data behind the story Where Police Have Killed Americans In 2015.

We linked entries from the Guardian's database on police killings to census data from the American Community Survey. The Guardian data was downloaded on June 2, 2015. More information about its database is available here.

Census data was calculated at the tract level from the 2015 5-year American Community Survey using the tables S0601 (demographics), S1901 (tract-level income and poverty), S1701 (employment and education) and DP03 (county-level income). Census tracts were determined by geocoding addresses to latitude/longitude using the Bing Maps and Google Maps APIs and then overlaying points onto 2014 census tracts. GEOIDs are census-standard and should be easily joinable to other ACS tables -- let us know if you find anything interesting.

Field descriptions:

Header Description Source
name Name of deceased Guardian
age Age of deceased Guardian
gender Gender of deceased Guardian
raceethnicity Race/ethnicity of deceased Guardian
month Month of killing Guardian
day Day of incident Guardian
year Year of incident Guardian
streetaddress Address/intersection where incident occurred Guardian
city City where incident occurred Guardian
state State where incident occurred Guardian
latitude Latitude, geocoded from address
longitude Longitude, geocoded from address
state_fp State FIPS code Census
county_fp County FIPS code Census
tract_ce Tract ID code Census
geo_id Combined tract ID code
county_id Combined county ID code
namelsad Tract description Census
lawenforcementagency Agency involved in incident Guardian
cause Cause of death Guardian
armed How/whether deceased was armed Guardian
pop Tract population Census
share_white Share of pop that is non-Hispanic white Census
share_bloack Share of pop that is black (alone, not in combination) Census
share_hispanic Share of pop that is Hispanic/Latino (any race) Census
p_income Tract-level median personal income Census
h_income Tract-level median household income Census
county_income County-level median household income Census
comp_income h_income / county_income Calculated from Census
county_bucket Household income, quintile within county Calculated from Census
nat_bucket Household income, quintile nationally Calculated from Census
pov Tract-level poverty rate (official) Census
urate Tract-level unemployment rate Calculated from Census
college Share of 25+ pop with BA or higher Calculated from Census

Note regarding income calculations:

All income fields are in inflation-adjusted 2013 dollars.

comp_income is simply tract-level median household income as a share of county-level median household income.

county_bucket provides where the tract's median household income falls in the distribution (by quintile) of all tracts in the county. (1 indicates a tract falls in the poorest 20% of tracts within the county.) Distribution is not weighted by population.

nat_bucket is the same but for all U.S. counties.

Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub

467 rows sorted by longitude

View and edit SQL

Suggested facets: gender, raceethnicity, cause, armed, county_bucket, nat_bucket

month

Link rowid name age gender raceethnicity month day year streetaddress city state latitude longitude ▼ state_fp county_fp tract_ce geo_id county_id namelsad lawenforcementagency cause armed pop p_income h_income county_income comp_income county_bucket nat_bucket pov urate college
330 Michael Kocher Jr 19 Male White January 3 2015 2600 Kaumualii Hwy Kaumakani HI 21.9338608 -159.64270019999998 15 7 40800 15007040800 15007 Census Tract 408 Kauai Police Department Struck by vehicle Knife 4189 30533 72000 62052 1.160317153 5 4 5.4 0.045591398 0.182048498
64 Bruce Zalonka 46 Male Asian/Pacific Islander May 12 2015 1031 Nuuanu Ave Honolulu HI 21.3106435 -157.86259840000002 15 3 4000 15003004000 15003 Census Tract 40 US Marshals Service Gunshot No 1392 35788 62594 72764 0.860233082 2 4 14.4 0.055155875 0.510619469
416 Sheldon Haleck 38 Male Asian/Pacific Islander March 16 2015 364 S King St Honolulu HI 21.306512899999998 -157.8598659 15 3 3900 15003003900 15003 Census Tract 39 Honolulu Police Department Taser No 403 21509 25323 72764 0.34801550200000003 1 1 20.1 0.23178807899999998 0.272237197
226 Jeffrey Surnow 63 Male White March 1 2015 Waikoloa Rd Waikoloa Village HI 19.915194 -155.83175400000002 15 1 21704 15001021704 15001 Census Tract 217.04 Hawaii Police Department Struck by vehicle Firearm 7883 36696 70159 51250 1.3689560980000002 5 4 7.3 0.110093792 0.313166605
248 John Whittaker 33 Male Hispanic/Latino February 10 2015 1503 Medfra St Anchorage AK 61.2075577 -149.8582001 2 20 902 2020000902 2020 Census Tract 9.02 Anchorage Police Department Gunshot Knife 2619 32902 51445 77454 0.664200687 1 3 18.4 0.096503497 0.35508849600000003
293 Larry Kobuk 33 Male Native American January 28 2015 Corrections Department, 1400 E 4th Ave Anchorage AK 61.218408 -149.858016 2 20 901 2020000901 2020 Census Tract 9.01 Anchorage Corrections Department Death in custody Knife 5733 20075 41268 77454 0.532806569 1 2 20.2 0.129310345 0.076845638
382 Robert Box 55 Male White May 29 2015 108 Fir Canyon Rd Grants Pass OR 42.3600731 -123.4464111 41 33 361500 41033361500 41033 Census Tract 3615 Oregon State Police Gunshot Knife 2186 23281 48077 37733 1.274136697   3 16 0.138248848 0.24741144399999998
58 Brian Babb 49 Male White March 31 2015 2200 Devos St Eugene OR 44.0894276 -123.18122220000001 41 39 2501 41039002501 41039 Census Tract 25.01 Eugene Police Department Gunshot Firearm 5057 20407 47795 42931 1.1132980829999999 3 3 21.6 0.150479846 0.151658768
439 Tim Elliott 53 Male Unknown January 2 2015 600 E Island Lake Dr Shelton WA 47.2465324 -123.1194992 53 45 960600 53045960600 53045 Census Tract 9606 Mason County Sheriff's Office Gunshot Non-lethal firearm 4347 18999 39495 48755 0.810070762 1 2 18.4 0.064193168 0.091157703
311 Mark Cecil Hawkins 49 Male White April 24 2015 1940 Turner Rd SE Salemburg OR 44.913921 -122.996177 41 47 1000 41047001000 41047 Census Tract 10 Salem Police Department Gunshot Firearm 4083 17474 31863 46885 0.6795990190000001 1 1 33.8 0.23807080600000002 0.11268191300000001
26 Andrew Shipley 49 Male White March 17 2015 360 Argyle Ct Medford OR 42.3301735 -122.89873500000002 41 29 800 41029000800 41029 Census Tract 8 Medford Police Department Gunshot Firearm 5824 21610 43625 44005 0.991364618 3 2 24.8 0.13115891699999999 0.125731679
298 Lewis Lembke 47 Male White January 2 2015 4505 SW Masters Loop Aloha OR 45.4866905 -122.8912506 41 67 31703 41067031703 41067 Census Tract 317.03 Washington County Sheriff's Office Gunshot No 4978 29959 56020 64180 0.872857588 2 3 8.8 0.13554791900000002 0.174886536
206 James Morris 40 Male Unknown May 31 2015 Juanipero Way and La Loma Dr Medford OR 42.311009000000006 -122.8316269 41 29 602 41029000602 41029 Census Tract 6.02 Medford Police Department Gunshot Non-lethal firearm 5737 22947 40781 44005 0.9267355979999999 2 2 20.2 0.187595323 0.378757515
274 Karen Janks 46 Female White April 23 2015 2661 Gravenstein Hwy S Sebastopol CA 38.3767128 -122.79187009999998 6 97 153403 6097153403 6097 Census Tract 1534.03 Sonoma County Sheriff's Office Gunshot Vehicle 4082 33918 68926 63356 1.0879159040000002 4 4 6.6 0.065811966 0.40019795399999997
340 Mychael Lynch 32 Male White March 23 2015 707 W 13th St Vancouver WA 45.6310601 -122.67825500000001 53 11 42400 53011042400 53011 Census Tract 424 Clark County Sheriff's Department Death in custody Knife 2150 15892 28281 58225 0.485719193 1 1 27.4 0.133171913 0.294513956
80 Christopher Healy 36 Male White March 22 2015 2300 SE 130th Ave Portland OR 45.5057439 -122.5299 41 51 9201 41051009201 41051 Census Tract 92.01 Portland Police Department Gunshot Other 7687 21049 35978 52511 0.685151683 1 2 31 0.138262782 0.130825139
422 Stephen Cunningham 47 Male White May 11 2015 3420 S Proctor St Tacoma WA 47.2285385 -122.4888763 53 53 62600 53053062600 53053 Census Tract 626 Tacoma Police Department Gunshot Knife 2758 21658 36642 59204 0.6189108839999999 1 2 24.5 0.12909699 0.131484335
94 Daniel Covarrubias 37 Male Hispanic/Latino April 21 2015 3600 SW 108th St Lakewood WA 47.159210200000004 -122.48494720000001 53 53 71807 53053071807 53053 Census Tract 718.07 Lakewood Police Department Gunshot Firearm 3531 21626 38688 59204 0.65346936 1 2 18 0.131736527 0.14203027599999998
20 Alvin Haynes 57 Male Black January 26 2015 1 Moreland Dr San Francisco CA 37.62797929999999 -122.45393370000001 6 81 614000 6081614000 6081 Census Tract 6140 San Francisco Sheriff's Department Death in custody No 5740 37455 111903 88202 1.268712728 4 5 6.4 0.06326836599999999 0.40952621
63 Bruce Steward 34 Male White February 15 2015 29000 S Wall St Colton OR 45.1577606 -122.4377594 41 5 24100 41005024100 41005 Census Tract 241 Clackamas County Sheriff's Office Gunshot Non-lethal firearm 4689 25130 58358 64352 0.906856042 2 4 5 0.11032343800000001 0.165820137
19 Alice Brown 24 Female White March 17 2015 Van Ness Ave and Pine St San Francisco CA 37.7894309 -122.42209840000001 6 75 11100 6075011100 6075 Census Tract 111 San Francisco Police Department Gunshot Firearm 5286 41676 61904 75604 0.818792656 2 4 11.6 0.040850588 0.552548489
320 Matthew Hoffman 32 Male White January 4 2015 630 Valencia St San Francisco CA 37.7628479 -122.4220047 6 75 20700 6075020700 6075 Census Tract 207 San Francisco Police Department Gunshot Other 5731 64657 115750 75604 1.531003651 5 5 8.6 0.050441655 0.7940698620000001
21 Amilcar Perez-Lopez 21 Male Hispanic/Latino February 26 2015 Folsom St and 24th St San Francisco CA 37.752510799999996 -122.41408009999999 6 75 22901 6075022901 6075 Census Tract 229.01 San Francisco Police Department Gunshot Vehicle 4303 27384 60479 75604 0.799944447 2 4 12.7 0.115890508 0.349884906
209 Jamison Childress 20 Male White March 19 2015 Kneuman Rd Sumas WA 49.0000114 -122.2853775 53 73 10200 53073010200 53073 Census Tract 102 US Border Patrol Gunshot Firearm 8196 22021 55432 51939 1.067251969 3 3 17.4 0.12704918 0.15408805
466 Yuvette Henderson 38 Female Black February 3 2015 3800 Hollis St Oakland CA 37.8271294 -122.2844925 6 1 401700 6001401700 6001 Census Tract 4017 Emeryville Police Department Gunshot Firearm 2544 26971 63052 72112 0.874362103 2 4 23.9 0.06960142799999999 0.39647577100000003
204 James Jimenez 41 Male Hispanic/Latino March 13 2015 1410 Hill Ave Napa CA 38.306118 -122.27445220000001 6 55 200400 6055200400 6055 Census Tract 2004 Napa Police Department Gunshot Firearm 3524 41719 90271 70443 1.281475803 4 5 8.6 0.066012002 0.48236196299999995
362 Philip Conley 37 Male White March 21 2015 904 Admiral Callaghan Ln Vallejo CA 38.1320534 -122.2226868 6 95 250105 6095250105 6095 Census Tract 2501.05 Vallejo Police Department Gunshot Firearm 7099 34516 91573 67177 1.36316001 5 5 5.6 0.108266073 0.35083633299999994
31 Angel Corona Jr 21 Male Hispanic/Latino April 10 2015 4740 Barham Ave Corning CA 39.9362717 -122.2013168 6 103 1100 6103001100 6103 Census Tract 11 Tehama County Sheriff's Department Gunshot Knife 7886 19599 46320 41924 1.104856407 4 3 24.1 0.17323741 0.11798007199999999
467 Zaki Shinwary 48 Male Unknown January 16 2015 Lake Arrowhead Ave and Great Salt Lake Dr Fremont CA 37.5864713 -122.06001029999999 6 1 441522 6001441522 6001 Census Tract 4415.22 Fremont Police Department Gunshot Firearm 5177 33590 88940 72112 1.233359219 4 5 6.1 0.08091210000000001 0.435773284
338 Millard Tallant III 62 Male White May 26 2015 17500 Tester Rd Snohomish WA 47.8377751 -122.0135761 53 61 52209 53061052209 53061 Census Tract 522.09 Snohomish County Sheriff's Office Gunshot Knife 5169 11405 41000 68381 0.599581755 1 2 19.1 0.11381323 0.143147897
257 Jose Ceja 36 Male Hispanic/Latino January 15 2015 2007 Sousa Ct Fairfield CA 38.2652893 -121.9976044 6 95 252707 6095252707 6095 Census Tract 2527.07 Fairfield Police Department Gunshot Disputed 4759 28062 45833 67177 0.6822722059999999 1 3 23.5 0.16014726199999998 0.14463504900000002
266 Joseph Weber 28 Male White April 8 2015 Tasman Dr and Lawrence Expy Sunnyvale CA 37.4033102 -121.9956697 6 85 504802 6085504802 6085 Census Tract 5048.02 Sunnyvale Police Department Gunshot Firearm 5153 30908 80962 91702 0.882881507 2 5 6.6 0.120577121 0.350638761
130 Devin Gates 24 Male Black March 22 2015 2105 Scott Blvd Santa Clara CA 37.3612938 -121.95913700000001 6 85 505202 6085505202 6085 Census Tract 5052.02 Santa Clara Police Department Gunshot Other 6461 26846 62664 91702 0.683343875 1 4 9.1 0.10711097900000001 0.348542762
365 Phillip Watkins 23 Male Black February 11 2015 1300 Sherman St San Jose CA 37.316599 -121.8759895 6 85 503113 6085503113 6085 Census Tract 5031.13 San Jose Police Department Gunshot Firearm 4866 22132 39892 91702 0.435017775 1 2 32.2 0.083946344 0.11226252199999999
408 Scott Dunham 57 Male White March 24 2015 2600 Senter Rd San Jose CA 37.3052139 -121.84149170000002 6 85 503213 6085503213 6085 Census Tract 5032.13 San Jose Police Department Gunshot Firearm 4026 17467 41767 91702 0.455464439 1 2 17.1 0.115249119 0.156238291
132 Dewayne Ward Jr 29 Male Black February 3 2015 1000 Claudia Ct Antioch CA 37.9996185 -121.8187332 6 13 307102 6013307102 6013 Census Tract 3071.02 Contra Costa Sheriff's Office Gunshot Firearm 5072 22193 45512 78756 0.577886129 1 3 20.7 0.175749894 0.048747913
74 Chance Thompson 35 Male White February 15 2015 Hammonton Smartville Rd Marysville CA 39.122150399999995 -121.56549840000002 6 115 40302 6115040302 6115 Census Tract 403.02 Yuba County Sheriff's Office Taser Firearm 2367 14746 28837 44902 0.642220836 1 1 32.2 0.214501511 0.10699001400000001
304 Luis Chavez-Diaz 27 Male Hispanic/Latino April 29 2015 1624 Hood Franklin Rd Elk Grove CA 38.36859129999999 -121.49391940000001 6 67 9900 6067009900 6067 Census Tract 99 California Department of Fish and Wildlife Gunshot Knife 4192 28730 60833 55064 1.104768996 3 4 14.7 0.164906988 0.176865936
390 Roberto Leon 22 Male Hispanic/Latino March 17 2015 Elkhorn Blvd and Dry Creek Rd Rio Linda CA 38.683769899999994 -121.43839990000001 6 67 7202 6067007202 6067 Census Tract 72.02 California Highway Patrol Gunshot Knife 4315 30472 56458 55064 1.025315996 3 4 11.2 0.11952862 0.17356010800000002
319 Matthew Coates 42 Male White May 16 2015 2010 61st St Sacramento CA 38.55151370000001 -121.4342575 6 67 1700 6067001700 6067 Census Tract 17 Sacramento Police Department Gunshot Firearm 5372 30332 48188 55064 0.875127125 2 3 31.1 0.107025846 0.47530521600000003
316 Matautu Nuu 35 Male Asian/Pacific Islander January 28 2015 Martinique Ct Stockton CA 38.029109999999996 -121.31568909999999 6 77 3311 6077003311 6077 Census Tract 33.11 Stockton Police Department Gunshot Firearm 3140 17026 41385 53380 0.775290371 2 2 29.1 0.23550212199999998 0.101457097
357 Patrick Wetter 25 Male White January 6 2015 800 Howard St Stockton CA 37.9297473 -121.2981304 6 77 801 6077000801 6077 Census Tract 8.01 Stockton Police Department Gunshot Other 7323 15628 44228 53380 0.828550019 2 2 29.4 0.26522411100000004 0.049474494
67 Carl Lao 28 Male Asian/Pacific Islander March 4 2015 South San Joaquin St and East Church St Stockton CA 37.948280100000005 -121.2858499 6 77 100 6077000100 6077 Census Tract 1 Stockton Police Department and San Joaquin County Sheriff's Office Gunshot Knife 3568 11805 15212 53380 0.284975646 1 1 50.7 0.348008386 0.061581248
217 Jason Moland 29 Male Black March 30 2015 3700 Beyer Park Dr Modesto CA 37.6910477 -120.9706879 6 99 403 6099000403 6099 Census Tract 4.03 Ceres Police Department Gunshot Knife 4296 28397 53097 49297 1.0770837979999999 4 3 11.6 0.092623405 0.276122083
11 Albert Hanson Jr 76 Male White April 26 2015 7th Ave and Kansas Ave Hanford CA 36.210960299999996 -119.5828798 6 31 1200 6031001200 6031 Census Tract 12 Kings County Sheriff's Office Gunshot Knife 2786 26916 56065 48133 1.164793385 4 3 9.2 0.041085271 0.10032894699999999
464 William Dick III 28 Male Native American April 4 2015 Bureau of Indian Affairs Rd 66 Tonasket WA 48.7085419 -119.43682859999998 53 47 970400 53047970400 53047 Census Tract 9704 US Forest Service Taser Firearm 4154 18470 35608 40368 0.88208482 1 2 27.3 0.133650291 0.174524982
108 David Garcia 33 Male Hispanic/Latino January 26 2015 1134 E St Wasco CA 35.5890732 -119.33475490000001 6 29 4402 6029004402 6029 Census Tract 44.02 Kern County Sheriff's Office Gunshot Firearm 4934 12741 23692 48552 0.487971659 1 1 50.6 0.151145038 0.026600166
383 Robert Burdge 36 Male White March 19 2015 200 Trask St Bakersfield CA 35.3536224 -119.3315506 6 29 3700 6029003700 6029 Census Tract 37 Bakersfield Police Department (Swat) Gunshot Firearm 3921 21115 55093 48552 1.134721536 4 3 23.1 0.11783783800000001 0.070159027
258 Jose Herrera 27 Male Hispanic/Latino April 22 2015 3000 W Cecil Ave Delano CA 35.7697792 -119.3015518 6 29 4604 6029004604 6029 Census Tract 46.04 California Department of Corrections and Rehabilitation Gunshot Firearm 13987 15480 48561 48552 1.000185368 3 3 20.1 0.151374509 0.084873066
395 Rodolfo Velazquez 47 Male Hispanic/Latino April 16 2015 West Lerdo Hwy and South Wall St Shafter CA 35.4998598 -119.28055 6 29 4101 6029004101 6029 Census Tract 41.01 Shafter Police Department Gunshot Firearm 4932 21130 49076 48552 1.010792552 3 3 18.8 0.078510317 0.13387151
323 Meagan Hockaday 26 Female Black March 27 2015 500 W Vineyard Ave Oxnard CA 34.227813700000006 -119.18288419999999 6 111 3010 6111003010 6111 Census Tract 30.10 Oxnard Police Department Gunshot No 3172 29511 65552 76544 0.856396321 2 4 8.9 0.08654906300000001 0.318350079
381 Roark Cook 36 Male White May 4 2015 3320 W 9th Ave Kennewick WA 46.20137020000001 -119.16800690000001 53 5 11002 53005011002 53005 Census Tract 110.02 Kennewick Police Department/Tri-City Swat Team Gunshot Firearm 4284 22348 42759 60485 0.7069356040000001 1 2 20.5 0.08303730000000001 0.12808080800000002
40 Antonio Zambrano-Montes 35 Male Hispanic/Latino February 10 2015 1107 W Lewis St Pasco WA 46.22851179999999 -119.1019287 53 21 20200 53021020200 53021 Census Tract 202 Pasco Police Department Gunshot Firearm 6747 16558 28537 55177 0.517190134 1 1 35.9 0.131743119 0.057256583
400 Russell Sharrer 54 Male White February 27 2015 1016 N 4th Ave Pasco WA 46.2375755 -119.09591670000002 53 21 20200 53021020200 53021 Census Tract 202 Franklin County Corrections Division Death in custody Firearm 6747 16558 28537 55177 0.517190134 1 1 35.9 0.131743119 0.057256583
220 Jeff Alexander 47 Male White March 17 2015 1125 1/2 19th St Bakersfield CA 35.376175 -119.01448490000001 6 29 1600 6029001600 6029 Census Tract 16 Bakersfield Police Department Gunshot Firearm 1354 12297 18942 48552 0.390138408 1 1 46.2 0.132231405 0.066834805
7 Adrian Hernandez 22 Male Hispanic/Latino March 27 2015 4000 Union Ave Bakersfield CA 35.3956975 -119.0027449 6 29 700 6029000700 6029 Census Tract 7 Bakersfield Police Department Gunshot Firearm 5027 25949 58068 48552 1.195996045 4 4 17.2 0.131461131 0.20380117
57 Brendon Glenn 29 Male Black May 6 2015 1602 Pacific Ave Los Angeles CA 33.9877281 -118.47171780000001 6 37 273502 6037273502 6037 Census Tract 2735.02 Los Angeles Police Department Gunshot Firearm 2860 42931 60714 55909 1.085943229 3 4 13.2 0.12679524 0.662311147
28 Andrew Valadez 26 Male White April 23 2015 Tyler St and Glenoaks Blvd Sylmar CA 34.31029 -118.45318970000001 6 37 106405 6037106405 6037 Census Tract 1064.05 Los Angeles Police Department Gunshot Firearm 3202 22441 52344 55909 0.9362356690000001 3 3 17.4 0.098980204 0.17937219699999998
376 Richard Hanna 56 Male Unknown April 6 2015 400 Steuber Rd Tehachapi CA 35.1274796 -118.41394809999998 6 29 6007 6029006007 6029 Census Tract 60.07 Tehachapi Police Department Gunshot Firearm 6657 26741 56698 48552 1.1677788759999999 4 4 11.5 0.113105925 0.10737248199999999
331 Michael Lemon 57 Male Unknown April 8 2015 11936 California Rte 178 Lake Isabella CA 35.6425591 -118.4136963 6 29 5203 6029005203 6029 Census Tract 52.03 Kern County Sheriff's Office Taser Firearm 4466 18472 30119 48552 0.620345197 1 1 28.2 0.108664773 0.155529618
117 Dean Bucheit 64 Male White February 9 2015 13600 Culver Blvd Los Angeles CA 34.0021591 -118.4123077 6 37 275102 6037275102 6037 Census Tract 2751.02 Los Angeles Police Department Struck by vehicle Firearm 4225 21130 55458 55909 0.99193332 3 3 7.3 0.068592058 0.285611251
411 Sergio Navas 34 Male Hispanic/Latino March 5 2015 N Pass Ave and W National Ave Burbank CA 34.151061799999994 -118.3435524 6 37 311600 6037311600 6037 Census Tract 3116 Los Angeles Police Department Gunshot Firearm 7914 44585 83325 55909 1.490368277 5 5 6.8 0.085368162 0.502911679
389 Robert Washington 37 Male Black April 1 2015 14200 Kornblum Ave Hawthorne CA 33.9017922 -118.3373257 6 37 603703 6037603703 6037 Census Tract 6037.03 Hawthorne Police Department Gunshot No 2666 32242 83258 55909 1.489169901 5 5 7.4 0.08111888099999999 0.252503954
455 Victor Terrazas 28 Male Hispanic/Latino March 25 2015 10200 S Vermont Ave Los Angeles CA 33.943603499999995 -118.29126740000001 6 37 240402 6037240402 6037 Census Tract 2404.02 Los Angeles County Sheriff's Department Gunshot Firearm 3862 16940 26250 55909 0.469512959 1 1 33.7 0.066431095 0.12200736599999999
39 Antonio Perez 32 Male Hispanic/Latino March 12 2015 2400 Flower St Los Angeles CA 34.0280075 -118.2735977 6 37 224020 6037224020 6037 Census Tract 2240.20 Los Angeles County Sheriff's Department Gunshot Firearm 2584 15373 27585 55909 0.493391046 1 1 37.4 0.123766135 0.10067567599999999
8 Adrian Solis 35 Male Hispanic/Latino March 26 2015 1500 Bayview Ave Wilmington CA 33.7930495 -118.2709256 6 37 294200 6037294200 6037 Census Tract 2942 Los Angeles Police Department Gunshot Non-lethal firearm 5238 25043 66543 55909 1.190201935 4 4 12.2 0.094346979 0.09043760099999999
61 Brian Pickett 26 Male Black January 6 2015 1600 E 123rd St Los Angeles CA 33.9208252 -118.2461601 6 37 540700 6037540700 6037 Census Tract 5407 Los Angeles County Sheriff's Department Taser Firearm 3078 17893 38690 55909 0.692017385 2 2 23.6 0.214183381 0.198357549
75 Charly 'Africa' Keunang 43 Male Black March 1 2015 500 San Pedro St Los Angeles CA 34.043777500000004 -118.243721 6 37 206300 6037206300 6037 Census Tract 2063 Los Angeles Police Department Gunshot Vehicle 5222 8206 10290 55909 0.18404908 1 1 79.2 0.43959044399999997 0.060441941
356 Pablo Meza 24 Male Hispanic/Latino January 17 2015 E 6th St and Mateo St Los Angeles CA 34.0383897 -118.2327244 6 37 206031 6037206031 6037 Census Tract 2060.31 Los Angeles Police Department Gunshot No 3040 39531 67542 55909 1.208070257 4 4 25.5 0.103303862 0.560435572
4 Aaron Valdez 25 Male Hispanic/Latino March 11 2015 3000 Seminole Ave South Gate CA 33.9392976 -118.21946340000001 6 37 535607 6037535607 6037 Census Tract 5356.07 South Gate Police Department Gunshot Firearm 4343 17194 48295 55909 0.863814413 3 3 11.7 0.124827269 0.050132928
392 Roberto Rodriguez 39 Male Hispanic/Latino April 8 2015 4th St and Mathews St Los Angeles CA 34.0401299 -118.21066979999999 6 37 204300 6037204300 6037 Census Tract 2043 Los Angeles Police Department Gunshot No 5158 14162 25792 55909 0.461321075 1 1 38.5 0.218400688 0.065922921
305 Luis Molina Martinez 35 Male Hispanic/Latino April 21 2015 3400 Manitou Ave Los Angeles CA 34.0717621 -118.2049866 6 37 199120 6037199120 6037 Census Tract 1991.20 Los Angeles Police Department Gunshot Firearm 4371 12376 23075 55909 0.41272424799999996 1 1 50.6 0.157422081 0.126103405
59 Brian Barbosa 23 Male Unknown January 11 2015 8900 Kauffman Ave South Gate CA 33.9523485 -118.1889472 6 37 536000 6037536000 6037 Census Tract 5360 South Gate Police Department Gunshot Firearm 4179 18047 43750 55909 0.782521598 2 2 16.3 0.12576542599999999 0.015885947
184 Hector Morejon 19 Male Hispanic/Latino April 23 2015 1100 Hoffman Ave Long Beach CA 33.780946 -118.1735922 6 37 576402 6037576402 6037 Census Tract 5764.02 Long Beach Police Department Gunshot No 4424 17223 30398 55909 0.543704949 1 1 42 0.17133443199999998 0.039807524
162 Feras Morad 20 Male Unknown May 27 2015 4600 E 15th St Long Beach CA 33.785408000000004 -118.1393127 6 37 575002 6037575002 6037 Census Tract 5750.02 Long Beach Police Department Gunshot Firearm 4863 31776 65912 55909 1.178915738 4 4 11.3 0.086558761 0.44280553899999997
347 Nephi Arriguin 21 Male Black May 7 2015 17200 Pires Ave Cerritos CA 33.8749829 -118.05035349999999 6 37 554512 6037554512 6037 Census Tract 5545.12 Los Angeles County Sheriff's Department Gunshot Firearm 5931 42774 101818 55909 1.821137921 5 5 1.5 0.056978002 0.556167665
436 Thong Kien Ma 32 Male Asian/Pacific Islander May 5 2015 10400 Enloe St South El Monte CA 34.053605299999994 -118.0453592 6 37 433503 6037433503 6037 Census Tract 4335.03 Los Angeles County Sheriff's Department Gunshot Knife 3416 17367 57500 55909 1.028456957 3 4 13.8 0.015197568 0.07275132299999999
118 Dean Genova 45 Male White April 26 2015 13822 Brookhurst St Garden Grove CA 33.7610283 -117.95374299999999 6 59 88902 6059088902 6059 Census Tract 889.02 Fountain Valley Police Department Gunshot Firearm 4791 19598 56818 75422 0.7533345709999999 2 4 24.3 0.11815301 0.16562602699999998
339 Monique Deckard 43 Female Black March 8 2015 900 S Euclid St Anaheim CA 33.820074700000006 -117.941376 6 59 87106 6059087106 6059 Census Tract 871.06 Anaheim Police Department Gunshot Firearm 5062 21008 45353 75422 0.601323221 1 3 11.2 0.11998292099999999 0.10503282300000001
358 Paul Anderson 31 Male Black April 4 2015 150 E Lincoln Ave Anaheim CA 33.836670899999994 -117.9137003 6 59 87300 6059087300 6059 Census Tract 873 Anaheim Police Department Gunshot Knife 9738 25755 51901 75422 0.6881413909999999 1 3 22.4 0.12332439699999999 0.253384913
157 Ernesto Javier Canepa Diaz 27 Male Hispanic/Latino February 27 2015 1000 W 3rd St Santa Ana CA 33.7470254 -117.8777748 6 59 74901 6059074901 6059 Census Tract 749.01 Santa Ana Police Department Gunshot No 9699 16620 41611 75422 0.55170905 1 2 25.7 0.065989848 0.030701753999999998
46 Benito Osorio 39 Male Hispanic/Latino March 11 2015 300 S Main St Santa Ana CA 33.7431641 -117.867981 6 59 74601 6059074601 6059 Census Tract 746.01 Santa Ana Police Department Gunshot Knife 8623 19978 47233 75422 0.626249635 1 3 20.6 0.123624444 0.06139805
402 Salome Rodriguez Jr 23 Male Hispanic/Latino March 13 2015 184 W 3rd St Pomona CA 34.056838 -117.7509385 6 37 408800 6037408800 6037 Census Tract 4088 Los Angeles Police Department Gunshot Knife 3755 15632 26970 55909 0.48239102799999994 1 1 39.3 0.122121424 0.20140845100000002
156 Ernesto Flores 52 Male Hispanic/Latino April 15 2015 11157 Chico Ave Pomona CA 34.051128399999996 -117.720726 6 71 303 6071000303 6071 Census Tract 3.03 San Bernardino County Sheriff's Office Gunshot Knife 7528 22177 46944 54090 0.867886855 3 3 23.2 0.135651629 0.084254483
145 Edixon Franco 37 Male Hispanic/Latino March 10 2015 Fern Ave and Phillips St Ontario CA 34.050080200000004 -117.65465990000001 6 71 1707 6071001707 6071 Census Tract 17.07 Ontario Police Department Gunshot Firearm 5950 24026 61989 54090 1.146034387 4 4 7.6 0.160571809 0.163655685
360 Paul Johnson 59 Male White February 4 2015 7100 Pine Ave Chino CA 33.95342479999999 -117.6501793 6 71 1903 6071001903 6071 Census Tract 19.03 Corona Police Department Gunshot No 8960 37453 97955 54090 1.810963209 5 5 6 0.138940153 0.512849414
12 Alec Ouzounian 40 Male White May 12 2015 28 Paseo Viento Rancho Santa Margarita CA 33.6533852 -117.6133728 6 59 32049 6059032049 6059 Census Tract 320.49 Orange County Sheriff's Department Gunshot No 9429 51186 117413 75422 1.5567473680000001 5 5 4.4 0.057580779000000006 0.527176781
24 Andrew Driver 36 Male White March 13 2015 9700 Kempster Ave Fontana CA 34.077442100000006 -117.4297614 6 71 3302 6071003302 6071 Census Tract 33.02 Fontana Police Department Gunshot Firearm 6460 18376 39153 54090 0.72384914 2 2 24.4 0.26297696800000003 0.071504237
301 Lorenzo Hayes 37 Male Black May 13 2015 N Addison St and E Sanson Ave Spokane WA 47.7065501 -117.40327990000002 53 63 400 53063000400 53063 Census Tract 4 Spokane Police Department Death in custody No 4502 17901 32143 49233 0.652875104 1 1 24.4 0.09994900599999999 0.110704111
252 Jonathan Harden 23 Male White February 13 2015 4023 University Pkwy San Bernadino CA 34.164711 -117.3321762 6 71 4601 6071004601 6071 Census Tract 46.01 San Bernardino Police Department Gunshot Firearm 6230 26030 52656 54090 0.97348863 3 3 15 0.102047449 0.16954429699999998
174 Gary Kendrick 56 Male White March 27 2015 Shadytree Ln and Glen Arbor Dr Encinitas CA 33.049740299999996 -117.24153000000001 6 73 17104 6073017104 6073 Census Tract 171.04 San Diego County Sheriff's Department Gunshot No 4040 40529 96094 62962 1.526222166 5 5 7.5 0.057553957 0.540820096
169 Fridoon Rawshannehad 42 Male White April 30 2015 3200 Hancock St San Diego CA 32.7543667 -117.2051807 6 73 6500 6073006500 6073 Census Tract 65 San Diego Police Department Gunshot Firearm 2674 23467 31495 62962 0.500222356 1 1 23 0.090163934 0.362808843
264 Joseph Slater 28 Male White April 15 2015 27767 Base Line Highland CA 34.1207352 -117.19861599999999 6 71 7604 6071007604 6071 Census Tract 76.04 Highland Police Department Death in custody Knife 3859 22628 50645 54090 0.9363098540000001 3 3 11.8 0.176044568 0.06447425400000001
164 Francis Rose III 42 Male White February 2 2015 9000 Buena Vista St Apple Valley CA 34.4155171 -117.17689540000002 6 71 9708 6071009708 6071 Census Tract 97.08 San Bernardino County Sheriff's Department Gunshot Firearm 4284 23716 49844 54090 0.9215012020000001 3 3 23.6 0.086389961 0.141213064
124 Dennis Fiel 34 Male White May 17 2015 7700 Mesa College Dr San Diego CA 32.801961199999994 -117.15433200000001 6 73 8702 6073008702 6073 Census Tract 87.02 San Diego Police Department Gunshot Vehicle 5029 26928 66542 62962 1.056859693 3 4 10.8 0.056382145999999994 0.38528720200000005
247 John Sawyer 35 Male White February 5 2015 1200 Calimesa Blvd Calimesa CA 33.9951673 -117.0581017 6 65 43802 6065043802 6065 Census Tract 438.02 Riverside County Sheriff's Department Gunshot Firearm 5651 23378 43460 56529 0.76880893 2 2 16 0.119515253 0.148913897
147 Elias Cavazos 29 Male Hispanic/Latino April 17 2015 Girard Street and Acacia Ave Hemet CA 33.7439798 -116.95425 6 65 43308 6065043308 6065 Census Tract 433.08 Riverside County Sheriff's Department and California Highway Patrol Gunshot Firearm 2886 17632 32708 56529 0.578605671 1 1 32 0.216848674 0.08590604
441 Todd Allen Hodge 36 Male White January 21 2015 40200 Clark Dr Hemet CA 33.741718299999995 -116.9542389 6 65 43308 6065043308 6065 Census Tract 433.08 Riverside County Sheriff's Department Gunshot Firearm 2886 17632 32708 56529 0.578605671 1 1 32 0.216848674 0.08590604
417 Simon Hubble 33 Male White May 27 2015 3600 Emmanuel Way Alpine CA 32.750515 -116.7029652 6 73 21302 6073021302 6073 Census Tract 213.02 San Diego County Sheriff's Department Gunshot Firearm 7371 20164 71929 62962 1.142419237 4 4 19.2 0.090909091 0.22739273899999998
56 Brandon Rapp 31 Male White March 18 2015 9000 Charles Way Middleton ID 43.7041283 -116.57971950000001 16 27 21903 16027021903 16027 Census Tract 219.03 Canyon County Sheriff's Office Gunshot Knife 9680 28125 58600 42105 1.391758698 5 4 9.5 0.095137421 0.226443265

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "police-killings/police_killings" (
"name" TEXT,
  "age" TEXT,
  "gender" TEXT,
  "raceethnicity" TEXT,
  "month" TEXT,
  "day" INTEGER,
  "year" INTEGER,
  "streetaddress" TEXT,
  "city" TEXT,
  "state" TEXT,
  "latitude" REAL,
  "longitude" REAL,
  "state_fp" INTEGER,
  "county_fp" INTEGER,
  "tract_ce" INTEGER,
  "geo_id" INTEGER,
  "county_id" INTEGER,
  "namelsad" TEXT,
  "lawenforcementagency" TEXT,
  "cause" TEXT,
  "armed" TEXT,
  "pop" INTEGER,
  "share_white" TEXT,
  "share_black" TEXT,
  "share_hispanic" TEXT,
  "p_income" TEXT,
  "h_income" INTEGER,
  "county_income" INTEGER,
  "comp_income" REAL,
  "county_bucket" INTEGER,
  "nat_bucket" INTEGER,
  "pov" TEXT,
  "urate" REAL,
  "college" REAL
);
Powered by Datasette · Query took 288.694ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub