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 state_fp

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
1 A'donte Washington 16 Male Black February 23 2015 Clearview Ln Millbrook AL 32.529577 -86.362829 1 51 30902 1051030902 1051 Census Tract 309.02 Millbrook Police Department Gunshot No 3779 28375 51367 54766 0.937935946 3 3 14.1 0.097686375 0.16850950899999997
34 Anthony Briggs 36 Male Black May 25 2015 1100 E Gateway Dr SE Huntsville AL 34.6168404 -86.5641098 1 89 2921 1089002921 1089 Census Tract 29.21 Huntsville Police Department Gunshot Knife 6018 34698 57935 58434 0.9914604509999999 3 4 8.9 0.06365809900000001 0.422256775
143 Douglas Harris 77 Male Black March 27 2015 7901 1st Ave S Birmingham AL 33.563751200000006 -86.7238083 1 73 2000 1073002000 1073 Census Tract 20 Birmingham Police Department Gunshot No 3708 13968 23977 45429 0.5277906179999999 1 1 37.5 0.145048815 0.088550247
163 Fletcher Stewart 46 Male White February 11 2015 Booger Hollow Rd Dadeville AL 32.864521 -85.7209778 1 123 962400 1123962400 1123 Census Tract 9624 Tallapoosa County Sheriff's Department Gunshot Firearm 4720 18363 36694 39130 0.937745975 3 2 20.1 0.07816316599999999 0.15942482
176 Gilbert Fleury 54 Male White March 11 2015 Cliffs Landing Rd Bay Minette AL 30.8661098 -87.880188 1 3 10300 1003010300 1003 Census Tract 103 Baldwin County Sheriff's Office Gunshot Firearm 6971 23683 48173 50221 0.9592202470000001 3 3 8.3 0.073079325 0.25110035199999997
412 Shane Watkins 39 Male White March 19 2015 1040 County Rd 249 Moulton AL 34.56684129999999 -87.28665050000001 1 79 979500 1079979500 1079 Census Tract 9795 Lawrence County Sheriff's Office Gunshot Other 5791 19149 38078 38551 0.9877305390000001 3 2 17 0.168279344 0.068518038
419 Stanley Grant 38 Male Black February 20 2015 2200 Green Springs Hwy Birmingham AL 33.4814291 -86.82417059999999 1 73 5000 1073005000 1073 Census Tract 50 Homewood Police Department Gunshot Firearm 3681 21908 35780 45429 0.787602633 2 2 23.2 0.052918942000000004 0.40567612700000005
461 William 'Rusty' Smith 53 Male White March 10 2015 700 Valley St Hoover AL 33.4149311 -86.8515567 1 73 14412 1073014412 1073 Census Tract 144.12 Hoover Police Department Gunshot No 4547 42312 81996 45429 1.8049263690000001 5 5 3 0.035916061 0.627631579
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
6 Adam Reinhart 29 Male White March 7 2015 18th St and Palm Ln Phoenix AZ 33.4693799 -112.0433197 4 13 111602 4013111602 4013 Census Tract 1116.02 Phoenix Police Department Gunshot No 4682 15523 20833 53596 0.388704381 1 1 58 0.073651452 0.102955195
68 Carlos Saavedra Ramirez 51 Male Hispanic/Latino April 22 2015 101 Naco Hwy Bisbee AZ 31.3995342 -109.91780849999999 4 3 1200 4003001200 4003 Census Tract 12 Bisbee Police Department Gunshot Knife 3035 20428 36442 45755 0.796459403 2 2 25.8 0.103244838 0.211139241
77 Chris Ingram 29 Male White January 27 2015 Coronado Trail Morenci AZ 33.0515518 -109.32492830000001 4 11 960200 4011960200 4011 Census Tract 9602 Clifton Police Department and Greenlee County Sheriff's Office Gunshot Firearm 3357 37579 60670 47992 1.264169028   4 10.9 0.107042254 0.146116241
93 Daniel Caldwell 56 Male White February 16 2015 8351 N Cracker Barrel Rd Marana AZ 32.358058899999996 -111.09249109999999 4 19 4427 4019004427 4019 Census Tract 44.27 Marana Police Department Gunshot Knife 8205 38593 69616 45841 1.5186405180000002 4 4 3 0.07910447799999999 0.42380708100000003
97 Daniel Mejia 37 Male Hispanic/Latino February 15 2015 200 S McNab Pkwy San Manuel AZ 32.6101336 -110.6317321 4 21 700 4021000700 4021 Census Tract 7 Pinal County Sheriff's Office Gunshot No 3887 22833 40984 50027 0.819237612 2 2 15.7 0.188067445 0.16084788
131 Dewayne Carr 42 Male Black January 15 2015 Chaparral Rd and Hayden Rd Scottsdale AZ 33.50943 -111.90871979999999 4 13 217001 4013217001 4013 Census Tract 2170.01 Scottsdale Police Department Gunshot Knife 4542 36099 52038 53596 0.9709306659999999 3 3 10 0.024411135 0.505309505
144 Ebin Proctor 19 Male Unknown May 30 2015 Yuma Circle Cottonwood AZ 34.6895294 -111.98518370000001 4 25 2002 4025002002 4025 Census Tract 20.02 Yavapai County SheriffÌ_Ì_åÈs Office Gunshot No 5206 16415 36818 42987 0.856491497 1 2 21.7 0.216194332 0.13952077599999999
150 Enoch Gaver 21 Male White March 21 2015 2003 E Rodeo Dr Cottonwood AZ 34.713046999999996 -112.0006409 4 25 2002 4025002002 4025 Census Tract 20.02 Cottonwood Police Department Gunshot Firearm 5206 16415 36818 42987 0.856491497 1 2 21.7 0.216194332 0.13952077599999999
152 Eric Robinson 40 Male White May 23 2015 135 N Main St Eagar AZ 34.11333870000001 -109.2914933 4 1 970501 4001970501 4001 Census Tract 9705.01 Eagar Police Department and Apache County Sheriff's Office Gunshot Firearm 5269 20644 47821 31476 1.519284534 5 3 16.3 0.059301769000000004 0.097701149
155 Erik Tellez 43 Male White April 18 2015 20th St and Thomas Rd Phoenix AZ 33.4802603 -112.0388203 4 13 111601 4013111601 4013 Census Tract 1116.01 Phoenix Police Department Gunshot Firearm 3082 19343 27066 53596 0.505000373 1 1 39.9 0.12 0.13821938
235 Jessica Uribe 28 Female Unknown February 28 2015 1113 W St Mary's Rd Tuscon AZ 34.292964899999994 -111.6646957 4 25 1500 4025001500 4025 Census Tract 15 Tucson Police Department Gunshot Firearm 6202 20860 37292 42987 0.867518087 2 2 20.9 0.151329243 0.080025472
239 Joaquin Hernandez 28 Male Hispanic/Latino February 4 2015 E Baseline Rd and S 48th St Phoenix AZ 33.378193800000005 -111.978452 4 13 116205 4013116205 4013 Census Tract 1162.05 Tempe, Chandler and Mesa Police Departments [US Marshals Service Task Force] Gunshot Other 4579 23243 35524 53596 0.6628106579999999 2 2 39.7 0.149219467 0.24432029800000002
249 Johnathon Guillory 32 Male White January 18 2015 Greenland Park Dr Maricopa AZ 33.0835686 -112.04293059999999 4 21 1702 4021001702 4021 Census Tract 17.02 Maricopa Police Department Gunshot Firearm 2732 45333 83438 50027 1.667859356 5 5 7.1 0.067204301 0.427527406
265 Joseph Tassinari 63 Male White March 24 2015 6600 W Christy Dr Glendale AZ 33.5838023 -112.2006413 4 13 104222 4013104222 4013 Census Tract 1042.22 Glendale Police Department Gunshot Firearm 6257 30661 55133 53596 1.0286775129999999 3 3 13 0.05121876 0.245041426
267 Joshua Deysie 33 Male Hispanic/Latino April 29 2015 1400 E Harmony Ave Mesa AZ 33.3896023 -111.80060459999999 4 13 422302 4013422302 4013 Census Tract 4223.02 Mesa Police Department Gunshot Knife 5442 22995 52661 53596 0.982554668 3 3 13.4 0.118041583 0.19829564100000002
270 Justin Fowler 24 Male Native American March 19 2015 Indian Rte 13 Lukachukai AZ 36.4117088 -109.25 4 1 944100 4001944100 4001 Census Tract 9441 Navajo Police Department Gunshot Firearm 5808 13130 24637 31476 0.782723345 2 1 48.9 0.262736536 0.10293012800000001
277 Kaylene Stone 49 Female White March 18 2015 6735 W Peoria Ave Peoria AZ 33.5812721 -112.2033386 4 13 71915 4013071915 4013 Census Tract 719.15 Glendale Police Department Gunshot Non-lethal firearm 3803 23974 34219 53596 0.638461826 1 1 17.6 0.104332953 0.100755668
279 Ken Cockerel 51 Male White April 3 2015 W Union Hills Dr and N 39th Ave Phoenix AZ 33.6546099 -112.14319979999999 4 13 618200 4013618200 4013 Census Tract 6182 Phoenix Police Department Gunshot No 3817 23250 55233 53596 1.0305433240000001 3 3 13 0.10789715300000001 0.190435887
282 Kenneth Buck 22 Male Hispanic/Latino January 5 2015 E Knox Rd Chandler AZ 33.326980600000006 -111.8252487 4 13 522901 4013522901 4013 Census Tract 5229.01 Chandler Police Department Gunshot No 4378 32211 53346 53596 0.9953354729999999 3 3 8.5 0.069218871 0.269216758
322 Matthew Metz 25 Male White March 3 2015 College Ave and Curry Rd Tempe AZ 33.4402203 -111.93081979999998 4 13 320100 4013320100 4013 Census Tract 3201 Tempe Police Department Gunshot Firearm 2485 25839 44097 53596 0.8227666240000001 2 2 20.5 0.059773829 0.5180493979999999
350 Nicolas Tewa 26 Male Native American January 27 2015 4130 N Black Canyon Hwy Phoenix AZ 33.496246299999996 -112.11534879999999 4 13 109001 4013109001 4013 Census Tract 1090.01 Phoenix Police Department Gunshot No 4829 16012 17699 53596 0.330229868 1 1 57.1 0.206933333 0.035050676
401 Ryan Burgess 31 Male White March 11 2015 2241 Lucille Ave Kingman AZ 35.2040901 -114.0249939 4 15 953800 4015953800 4015 Census Tract 9538 Kingman Police Department Gunshot Firearm 6001 21374 42484 39200 1.08377551 4 2 16.2 0.149595213 0.141590679
404 Salvador Muna 28 Male Hispanic/Latino February 4 2015 E Baseline Rd and S 48th St Phoenix AZ 33.378193800000005 -111.978452 4 13 116205 4013116205 4013 Census Tract 1162.05 Tempe, Chandler and Mesa Police Departments [US Marshals Service Task Force] Gunshot Firearm 4579 23243 35524 53596 0.6628106579999999 2 2 39.7 0.149219467 0.24432029800000002
414 Shaun Johnson 35 Male White May 8 2015 59705 E Bidegain Pl Kearny AZ 33.078468300000004 -110.92328640000001 4 21 2300 4021002300 4021 Census Tract 23 Pinal County Sheriff's Office Gunshot No 2747 24352 49097 50027 0.981410039 3 3 19.5 0.078651685 0.080141129
421 Stephanie Hill 37 Female White February 28 2015 I-10 La Paz County AZ 32.230201 -110.98208899999999 4 19 300 4019000300 4019 Census Tract 3 Riverside County Sheriff's Department Gunshot No 1548 15686 27552 45841 0.601034009 1 1 31.2 0.138238573 0.39089969
41 Artago Howard 36 Male Black January 8 2015 9661 Strong Hwy Strong AR 33.111282300000006 -92.3590775 5 139 950100 5139950100 5139 Census Tract 9501 Union County Sheriff's Office Gunshot Firearm 3245 17853 32614 37435 0.8712167759999999 2 1 15.6 0.055732484000000006 0.100468284
79 Christopher Finley 31 Male White April 14 2015 900 Walnut St Jonesboro AR 35.8342552 -90.7173691 5 31 200 5031000200 5031 Census Tract 2 Jonesboro Police Department Gunshot No 3886 22080 43259 41393 1.045080086 3 2 18.2 0.09246901800000001 0.21394319399999998
237 Jimmy Foreman 71 Male Unknown January 9 2015 422 SE 3rd St England AR 34.542649100000006 -91.9658922 5 85 20700 5085020700 5085 Census Tract 207 England Police Department Gunshot Firearm 2979 18750 31458 52582 0.598265566 1 1 32.9 0.137774413 0.13246471199999998
253 Jonathan McIntosh 35 Male White May 19 2015 900 E Main St Cabot AR 34.967532500000004 -92.0081317 5 85 20202 5085020202 5085 Census Tract 202.02 Lonoke County Sheriff's Office and Arkansas Department of Community Correction Gunshot Knife 4227 22158 47051 52582 0.894811913 2 3 22.6 0.07388664 0.207895842
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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 368.848ms · Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub