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

90 rows where month = "January" sorted by month

View and edit SQL

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

month

  • January · 90
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
9 Alan Alverson 44 Male White January 28 2015 Pickett Runn Rd Sunset TX 30.6653042 -96.4014816 48 41 603 48041000603 48041 Census Tract 6.03 Wise County Sheriff's Department and Texas DPS Gunshot Firearm 4832 16778 30391 38310 0.7932915690000001 2 1 37.7 0.140832976 0.047601339000000006
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
22 Andre Murphy Sr 42 Male Black January 7 2015 1223 Omaha Ave Norfolk NE 42.0185249 -97.3862886 31 119 960600 31119960600 31119 Census Tract 9606 Norfolk Police Division Death in custody No 5213 23342 54809 46566 1.177017566 4 3 10.3 0.035221496 0.258886442
27 Andrew Toto 54 Male White January 21 2015 Scobie Pond Rd and Julian Rd Derry NH 42.90808010000001 -71.33664990000001 33 15 3302 33015003302 33015 Census Tract 33.02 Derry Police Department Gunshot Firearm 4521 32921 61167 77348 0.790802606 1 4 5.4 0.08738548300000001 0.28485424600000003
30 Andy Martinez 33 Male Hispanic/Latino January 9 2015 4400 Tetons Dr El Paso TX 31.857637800000003 -106.43961780000001 48 141 404 48141000404 48141 Census Tract 4.04 El Paso Police Department Gunshot Firearm 4160 13231 17388 40157 0.433000473 1 1 58.1 0.14461316 0.047239915
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
45 Autumn Steele 34 Female White January 6 2015 104 N Garfield Ave Burlington IA 40.810028100000004 -91.1185837 19 57 400 19057000400 19057 Census Tract 4 Burlington Police Department Gunshot Firearm 4465 15488 26964 42451 0.635179383 1 1 26.3 0.105963791 0.096564885
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
62 Brock Nichols 35 Male White January 6 2015 2388 E Kansas Hwy 4 Assaria KS 38.71123239999999 -97.5695687 20 169 1200 20169001200 20169 Census Tract 12 Saline County Sheriff's Office Gunshot Knife 3770 31080 57244 47215 1.21241131 4 4 9.5 0.041356877 0.240897389
69 Carter Ray Castle 67 Male White January 18 2015 Kentucky Rte 7 Gunlock KY 37.5631485 -82.9268265 21 153 970400 21153970400 21153 Census Tract 9704 Magoffin County Sheriff's Office and Kentucky State Police Gunshot Firearm 2422 12840 25139 26877 0.935335045   1 34.2 0.31261101199999997 0.035820896
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
85 Cody Karasek 26 Male White January 28 2015 4100 Avenue I Rosenberg TX 29.5576077 -95.7844925 48 157 675100 48157675100 48157 Census Tract 6751 Rosenburg Police Department Gunshot Firearm 10229 22235 53831 85297 0.631100742 2 3 19.4 0.06807653599999999 0.113879004
92 Daniel Brumley 25 Male Hispanic/Latino January 17 2015 NE 36th St Fort Worth TX 32.810365000000004 -97.342555 48 439 100202 48439100202 48439 Census Tract 1002.02 Fort Worth Police Department Gunshot Firearm 4917 19146 32245 56853 0.567164442 1 1 21.5 0.144497608 0.013547237
99 Darin Hutchins 26 Male Black January 24 2015 1900 McHenry St Baltimore MD 39.2844658 -76.6468658 24 510 200300 24510200300 24510 Census Tract 2003 Baltimore Police Department Gunshot Firearm 1625 11157 21433 41385 0.517892956 1 1 51 0.309882747 0.014117646999999999
104 Daryl Myler 45 Male White January 24 2015 164 E Main St Rexburg ID 43.8255653 -111.77870940000001 16 65 950200 16065950200 16065 Census Tract 9502 Rexburg Police Department Gunshot Non-lethal firearm 3481 10987 19672 32059 0.613618641 1 1 42.4 0.091570649 0.26719057
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
122 Demaris Turner 29 Male Black January 23 2015 1980 NW 46 Ave Lauderhill FL 26.1503577 -80.2101228 12 11 60402 12011060402 12011 Census Tract 604.02 Lauderhill Police Department Gunshot No 6074 20254 29884 51251 0.583091062 1 1 26.9 0.160730056 0.18292338100000002
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
140 Donte Sowell 27 Male Black January 15 2015 East 38th St and North Mitthoeffer Rd Indianapolis IN 39.8262703 -85.99104969999999 18 97 360404 18097360404 18097 Census Tract 3604.04 Indianapolis Metropolitan Police Department Gunshot Other 7499 20623 36070 42334 0.852033826 3 2 28.9 0.121461408 0.14285714300000002
146 Edward Bright Sr 54 Male Black January 31 2015 9800 Liberty Rd Randallstown MD 39.3798716 -76.82020899999999 24 5 402505 24005402505 24005 Census Tract 4025.05 Baltimore County Police Department Gunshot Firearm 3070 37922 54274 66486 0.816322233 2 3 10.1 0.067278287 0.345549738
171 Garrett Gagne 22 Male White January 1 2015 Crowell Rd and Tipcart Dr Chatham MA 41.684818299999996 -69.96642299999999 25 1 10600 25001010600 25001 Census Tract 106 Chatham Police Department Struck by vehicle Unknown 3396 31641 67059 60526 1.107937085 4 4 7.7 0.09679529099999999 0.5278201220000001
183 Hashim Abdul-Rasheed 41 Male Black January 7 2015 4600 International Gateway Columbus OH 39.997512 -82.890052 39 49 980000 39049980000 39049 Census Tract 9800 Columbus Police Department Gunshot Firearm 0 -   50877       -    
187 Howard Robbins 69 Male White January 16 2015 US-150 Stanford KY 37.51334 -84.59906009999999 21 137 920103 21137920103 21137 Census Tract 9201.03 Stanford Police Department Struck by vehicle No 2143 16615 17917 33651 0.532435886 1 1 45.4 0.205128205 0.10382059800000001
191 Isaac Holmes 19 Male Black January 21 2015 4200 St Louis Ave St Louis MO 38.660987899999995 -90.2338638 29 510 111300 29510111300 29510 Census Tract 1113 St Louis Metropolitan Police Department Gunshot Firearm 1325 14048 18828 34582 0.544445087 1 1 37.6 0.507614213 0.029233871
197 James Barker 42 Male White January 8 2015 600 Second Ave Salt Lake City UT 40.771666499999995 -111.87140819999999 49 35 101200 49035101200 49035 Census Tract 1012 Salt Lake City Police Department Gunshot Firearm 3745 30391 44638 60555 0.737148047 2 2 18.3 0.03653323 0.638549618
224 Jeffrey Nielson 34 Male White January 14 2015 120 Honey Berry Ct Draper UT 40.539855200000005 -111.88724669999999 49 35 112823 49035112823 49035 Census Tract 1128.23 West Valley City Police Department and Draper Police Police Department Gunshot No 4748 30625 68125 60555 1.125010321 4 4 7.7 0.018841912 0.32857142899999997
230 Jermonte Fletcher 33 Male Black January 27 2015 265 Buffalo Ct Columbus OH 39.879382 -82.9963372 39 49 8822 39049008822 39049 Census Tract 88.22 Columbus Police Department, Ohio State Highway Patrol Gunshot No 4419 16616 33370 50877 0.6558955910000001 2 1 26 0.145665323 0.06088993
234 Jessica Hernandez 17 Female Hispanic/Latino January 26 2015 Newport St & E 25th Ave Denver CO 39.7534 -104.90935990000001 8 31 4104 8031004104 8031 Census Tract 41.04 Denver Police Department Gunshot Firearm 4293 32602 54261 50313 1.078468785 3 3 11.8 0.096314908 0.441001565
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
242 John Ballard Gorman 45 Male White January 21 2015 3468 Casino Way Robinsonville MS 34.8307787 -90.32121 28 143 950100 28143950100 28143 Census Tract 9501 Mississippi Gaming Commission Gunshot Firearm 5683 22681 32899 31446 1.046206195   1 31.4 0.091877986 0.174675128
244 John Marshall 48 Male White January 30 2015 Billings Clinic, 2800 10th Ave N Billings MT 45.789441 -108.5132285 30 111 402 30111000402 30111 Census Tract 4.02 Billings Police Department Gunshot Firearm 3238 24076 38365 51342 0.747243972 1 2 21.6 0.17055469199999998 0.36834798700000004
245 John O'Keefe 34 Male White January 13 2015 Constitution Ave and San Mateo Blvd Albuquerque NM 35.0946403 -106.5861697 35 1 402 35001000402 35001 Census Tract 4.02 Albuquerque Police Department Gunshot Firearm 3404 34326 54855 48801 1.124054835 4 3 7.3 0.050728277 0.507961165
246 John Quintero 23 Male Hispanic/Latino January 3 2015 500 North Oliver Ave Wichita KS 37.6939376 -97.2804936 20 173 1000 20173001000 20173 Census Tract 10 Wichita Police Department Gunshot Knife 4020 22016 36701 49865 0.7360072190000001 2 2 24.1 0.106899903 0.20673076899999998
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
256 Jose Antonio Espinoza Ruiz 56 Male Hispanic/Latino January 23 2015 202 Avenue A Levelland TX 33.5913373 -102.3692241 48 219 950400 48219950400 48219 Census Tract 9504 Levelland Police Department Gunshot No 4966 15511 31952 50565 0.631899535 1 1 29.3 0.087265136 0.050646175
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
260 Joseph Caffarello 31 Male White January 7 2015 6100 Scott St Rosemont IL 41.9897374 -87.87591040000001 17 31 770700 17031770700 17031 Census Tract 7707 Rosemont Police Department Gunshot Firearm 2680 27172 46048 54548 0.844173939 3 3 11.5 0.095054592 0.131664853
268 Joshua Garcia 24 Male Hispanic/Latino January 26 2015 2500 FM1054 Tahoka TX 33.1661153 -101.6661762 48 305 950600 48305950600 48305 Census Tract 9506 Lynn County Sheriff's Office Gunshot Knife 1363 22734 36912 44375 0.831819718   2 26 0.043478261 0.11707317099999999
276 Kavonda Payton 39 Male Black January 16 2015 138 Del Mar Cir Aurora CO 39.72816470000001 -104.8446426 8 5 7600 8005007600 8005 Census Tract 76 Aurora Police Department Gunshot Vehicle 3219 25279 48169 60651 0.794199601 2 3 20.3 0.13408820000000002 0.263902439
281 Kenneth Brown 18 Male White January 4 2015   Guthrie OK 35.8801193 -97.4228592 40 83 600200 40083600200 40083 Census Tract 6002 Oklahoma State Police Gunshot Non-lethal firearm 3014 16463 41901 53591 0.7818663579999999 2 2 33.3 0.10576923099999999 0.105675147
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
290 Kristiana Coignard 17 Female White January 22 2015 Longview Police Department, 302 W Cotton St Longview TX 32.49541 -94.746094 48 183 1100 48183001100 48183 Census Tract 11 Longview Police Department Gunshot Firearm 4045 14332 26458 45525 0.581175178 1 1 27.4 0.13706706 0.17430703600000003
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
296 Leslie Sapp III 47 Male Black January 6 2015 Redlyn St Pittsburgh PA 40.413045000000004 -79.991463 42 3 300100 42003300100 42003 Census Tract 3001 US Marshals Service, Pennsylvania State Police, Allegheny County Sheriff's Office Gunshot Firearm 4667 18978 32625 51366 0.635147763 2 1 30.5 0.102179837 0.083578792
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
300 Loren Simpson 28 Male White January 8 2015 3618 White Buffalo Rd Huntley MT 45.8630638 -108.3131864 30 111 940000 30111940000 30111 Census Tract 9400 Yellowstone County Sheriff's Office Gunshot Firearm 7864 28125 68949 51342 1.3429356080000001 5 4 9.5 0.049460432 0.300439399
302 Louis Becker 87 Male White January 14 2015 New York State Rte 23 and Cairo Junction Rd Catskill NY 42.262431 -73.9357393 36 39 81101 36039081101 36039 Census Tract 811.01 New York State Troopers Struck by vehicle Firearm 3947 27077 52165 49655 1.050548787 4 3 6.5 0.133264463 0.160841534
307 Marcus Golden 24 Male Black January 14 2015 261 E University Ave St Paul MN 44.9580421 -93.09425350000001 27 123 42800 27123042800 27123 Census Tract 428 St Paul Police Department Gunshot Vehicle 2391 11425 18156 54247 0.334691319 1 1 48.9 0.223255814 0.17706708300000001
309 Mario Jordan 34 Male Black January 14 2015 Sir Gawaine Dr Chesapeake VA 36.781304 -76.347865 51 550 21404 51550021404 51550 Census Tract 214.04 Chesapeake City Police Department Gunshot Firearm 7340 26119 50664 69743 0.726438496 2 3 10.8 0.09905795 0.188659579
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
317 Matthew Ajibade 22 Male Black January 1 2015 1050 Carl Griffin Dr Savannah GA 32.0666924 -81.1678772 13 51 10501 13051010501 13051 Census Tract 105.01 Chatham County Sheriff's Office Death in custody Other 5502 25190 33545 45794 0.7325195440000001 2 1 30.1 0.119607843 0.202453988
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
328 Michael Goebel 29 Male White January 14 2015 600 Spring Dr Robertsville MO 38.3187816 -90.7944026 29 71 800800 29071800800 29071 Census Tract 8008 St Louis County Police Department Gunshot No 7585 27917 55279 48857 1.131444829 5 3 12 0.13811188800000002 0.11350548
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
335 Michael Rodriguez 39 Male Hispanic/Latino January 5 2015 818 31st St Evans CO 40.3840446 -104.6920242 8 123 1004 8123001004 8123 Census Tract 10.04 Evans Police Department Gunshot Firearm 4129 18022 27500 57180 0.480937391 1 1 42.7 0.121156494 0.062254902
337 Miguel Anguel de Santos-Rodriguez 36 Male Hispanic/Latino January 21 2015 ChapeÌ_å±o Rd Roma TX 26.5522499 -99.13320920000001 48 427 950202 48427950202 48427 Census Tract 9502.02 US Border Patrol Gunshot Firearm 2377 14457 26346 24927 1.056926225 3 1 33.1 0.063807531 0.10672514599999999
344 Nathan Massey 33 Male White January 15 2015 Becky Sue St Ville Platte LA 30.751305 -92.43799399999999 22 39 950200 22039950200 22039 Census Tract 9502 Evangeline Parish Sheriff's Office Gunshot Knife 1977 21831 43056 31832 1.352601156 4 2 18.5 0.02987013 0.12213114800000001
348 Nicholas Brickman 30 Male White January 7 2015 SE 4th St and Scott Ave Des Moines IA 41.581039700000005 -93.609646 19 153 5200 19153005200 19153 Census Tract 52 Des Moines Police Department Gunshot Firearm 3687 16071 29375 59018 0.497729506 1 1 31.3 0.127948113 0.042051282
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
354 Omarr Jackson 37 Male Black January 8 2015 Lasalle St and Josephine St New Orleans LA 29.9412498 -90.0852399 22 71 8500 22071008500 22071 Census Tract 85 New Orleans Police Department Gunshot Firearm 1345 9353 15293 37146 0.411699779 1 1 54.6 0.324444444 0.039319872
355 Orlando Lopez 26 Male Hispanic/Latino January 25 2015 Troy Ave and Oakshire Ln Pueblo CO 38.2854206 -104.57347800000001 8 101 902 8101000902 8101 Census Tract 9.02 Pueblo Police Department Gunshot Firearm 5747 22057 34987 41777 0.837470378 3 2 22.1 0.171932403 0.211460151
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
359 Paul Campbell 49 Male White January 19 2015 69 Prospect Hill Dr Weymouth MA 42.2566948 -70.9316177 25 21 422800 25021422800 25021 Census Tract 4228 Weymouth Police Department Gunshot Firearm 3902 36062 66036 84916 0.777662631 2 4 4.7 0.09338521400000001 0.364356436
364 Phillip Garcia 26 Male Hispanic/Latino January 16 2015 12810 Gulf Fwy Houston TX 29.6131928 -95.2134526 48 201 334002 48201334002 48201 Census Tract 3340.02 Houston Police Department Gunshot Firearm 2802 40387 53244 53137 1.002013663 3 3 6.3 0.094994312 0.35181762200000005
367 Quincy Reed Reindl 24 Male White January 15 2015 Nesbitt Ave S and 99th St W Bloomington MN 44.8254901 -93.35840999999999 27 53 25903 27053025903 27053 Census Tract 259.03 Bloomington Police Department Gunshot Knife 6185 43458 82702 64403 1.284132727 4 5 6.9 0.049067982 0.622360248
368 Ralph Willis 42 Male White January 29 2015 604 E Maple Ave Stillwater OK 36.1211052 -97.05012509999999 40 119 10600 40119010600 40119 Census Tract 106 Stillwater Police Department Gunshot Firearm 4908 14964 32054 36812 0.870748669 3 1 34 0.066425993 0.28454231399999996
370 Raymond Kmetz 68 Male White January 26 2015 4401 Xylon Ave N Minneapolis MN 45.035038 -93.3867416 27 53 21503 27053021503 27053 Census Tract 215.03 Minneapolis Police Department Gunshot Other 4836 28690 46519 64403 0.722311072 2 3 8.7 0.112132353 0.264764622
377 Richard McClendon 43 Male White January 13 2015 600 Olive St Jourdanton TX 28.911590000000004 -98.5429517 48 13 960600 48013960600 48013 Census Tract 9606 Jourdanton Police Department Gunshot Firearm 6033 26101 48735 47543 1.02507204 4 3 10 0.064629434 0.163523637
384 Robert Edwards 68 Male White January 14 2015 500 Sycamore St Lake Jackson TX 29.0344224 -95.4281493 48 39 663500 48039663500 48039 Census Tract 6635 Lake Jackson Police Department Gunshot No 6016 27875 54329 67603 0.8036477670000001 2 3 8.6 0.051835853 0.170081392
385 Robert Francis Mesch 61 Male White January 23 2015 120 W Slaughter Ln Austin TX 30.167617800000002 -97.78916170000001 48 453 2421 48453002421 48453 Census Tract 24.21 Austin Police Department Gunshot No 7456 31969 59435 58025 1.024299871 3 4 11.5 0.081466763 0.428831012
391 Roberto Ornelas 18 Male Hispanic/Latino January 1 2015 39 N Marlin Ave Key Largo FL 25.155902899999997 -80.3902588 12 87 970300 12087970300 12087 Census Tract 9703 Monroe County Sheriff's Office Unknown Knife 2355 25977 54219 53607 1.0114164190000001 3 3 16.4 0.08126259200000001 0.31395902800000003
394 Rodney Walker 23 Male Black January 16 2015 W 11th St Tulsa OK 36.1459389 -95.9928436 40 143 2500 40143002500 40143 Census Tract 25 Department of Veteran Affairs Gunshot Firearm 3300 16953 34432 48181 0.71463855 2 2 26.7 0.080686695 0.40877437299999997
396 Ronald Sneed 32 Male Black January 7 2015 300 Yaupon St Freeport TX 28.955221500000004 -95.3685641 48 39 664400 48039664400 48039 Census Tract 6644 Freeport Police Department Gunshot Knife 6118 24236 48635 67603 0.7194207359999999 2 3 18.4 0.12814412 0.077154583
403 Salvador Figueroa 29 Male Hispanic/Latino January 11 2015 Circle K, 1301 N Eastern Ave Las Vegas NV 36.18512 -115.116428 32 3 510 32003000510 32003 Census Tract 5.10 North Las Vegas Police Department Gunshot No 4993 19746 41875 52873 0.7919921320000001 2 2 22.9 0.140275387 0.039349224
418 Sinthanouxay Khottavongsa 57 Male Asian/Pacific Islander January 16 2015 5900 Xerxes Ave N Minneapolis MN 45.0622444 -93.3187485 27 53 20304 27053020304 27053 Census Tract 203.04 Brooklyn Center Police Department Taser Firearm 3081 26143 38958 64403 0.604909709 1 2 23 0.101226994 0.20644456600000002
425 Talbot Schroeder 75 Male White January 14 2015 40 Cedar Grove Pl Old Bridge Township NJ 40.4052734 -74.3010178 34 23 7906 34023007906 34023 Census Tract 79.06 Old Bridge Police Department Gunshot Knife 1753 29741 75050 79596 0.942886577 2 5 14.3 0.07543103400000001 0.22251773
426 Terence Walker 21 Male Black January 17 2015 Old Agency Baptist Church Muskogee OK 35.766201 -95.3946991 40 101 200 40101000200 40101 Census Tract 2 Muskogee Police Department Gunshot Firearm 1925 15252 17025 38502 0.44218482200000003 1 1 51.8 0.09475218699999999 0.106906339
435 Thomas Hamby 49 Male White January 8 2015 2964 W 2125 S Syracuse UT 41.08326339999999 -112.0831375 49 11 125403 49011125403 49011 Census Tract 1254.03 Syracuse Police Department, Davis County Sheriff's Office Gunshot Firearm 11719 36216 81064 69707 1.1629248140000001 4 5 4.4 0.046353872000000004 0.34196806799999996
437 Tiano Meton 25 Male Black January 22 2015 I-10 Sierra Blanca TX 31.172832 -105.357927 48 229 950300 48229950300 48229 Census Tract 9503 US Border Patrol Gunshot Other 3394 14989 22545 22545 1.0   1 44.1 0.081601232 0.110399211
438 Tiffany Terry 39 Female White January 30 2015 1702 S 50th St Omaha NE 41.242736799999996 -95.9904175 31 55 3700 31055003700 31055 Census Tract 37 Omaha Police Department Gunshot Firearm 2646 36394 66786 53325 1.252433193 4 4 5.5 0.028415961 0.496179039
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
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
443 Tommy Smith 39 Male White January 12 2015 224 Circle Dr Arcola IL 39.691962 -88.3028705 17 41 952400 17041952400 17041 Census Tract 9524 Tuscola Police Department Gunshot Firearm 3565 27719 51518 52741 0.9768112090000001 2 3 14 0.053739612 0.158820941
451 Unknown Unknown Male Unknown January 16 2015 Co Rd 2718 Mabank TX 32.407138800000006 -96.0738907 48 467 951000 48467951000 48467 Census Tract 9510 Texas Rangers/ ATF Gunshot Other 6852 22969 50280 43439 1.157485209 5 3 17.9 0.058573297999999996 0.100249066
454 Victor Reyes 31 Male Hispanic/Latino January 31 2015 West Little York Rd Houston TX 29.865415000000002 -95.524052 48 201 532300 48201532300 48201 Census Tract 5323 Houston County Sheriff's Department Gunshot No 5065 29695 41265 53137 0.776577526 2 2 12.5 0.023561091 0.22967891199999999
459 Wendell King 40 Male White January 29 2015 4800 Hildring Dr E Forth Worth TX 32.6786003 -97.3807373 48 439 105404 48439105404 48439 Census Tract 1054.04 Fort Worth Police Department Gunshot Unknown 4074 54494 102938 56853 1.810599265 5 5 11.2 0.027574564 0.71127026
462 William Campbell 59 Male Unknown January 25 2015 335 New Brooklyn Rd Berlin NJ 39.7491188 -74.92930600000001 34 7 609103 34007609103 34007 Census Tract 6091.03 Winslow Police Department Gunshot Non-lethal firearm 5065 31470 65759 61683 1.066079795 3 4 7.3 0.14086629 0.236107027
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

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