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

84 rows where month = "February" sorted by county_income

View and edit SQL

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

month

  • February · 84
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
87 Crystal Miley 34 Female White February 26 2015 5101 Georgia Rte 133 Moultrie GA 31.088287800000003 -83.6398052 13 71 970500 13071970500 13071 Census Tract 9705 Worth County Sheriff's Office Gunshot Knife 3520 21667 54871 32484 1.6891700530000002 5 3 14.8 0.140276302 0.200720072
186 Howard Brent Means Jr 34 Male White February 15 2015 1110 Battleground Dr Iuka MS 34.804702899999995 -88.202415 28 141 950300 28141950300 28141 Census Tract 9503 Iuka Police Department Gunshot No 6466 18243 30857 32592 0.946766078   1 16.1 0.096869245 0.12557934199999998
190 Ian Sherrod 40 Male Black February 28 2015 2300 block Main St Tarboro NC 35.906951899999996 -77.5407562 37 65 21000 37065021000 37065 Census Tract 210 Tarboro Police Department and Edgecombe Sheriff's Office Gunshot No 2929 20836 30588 33960 0.900706714 1 1 24.6 0.195104392 0.149602386
295 Ledarius Williams 23 Male Black February 3 2015 Minnesota Ave and Meramec St St Louis MO 38.5800999 -90.2375297 29 510 115700 29510115700 29510 Census Tract 1157 St Louis Metropolitan Police Department Gunshot No 3641 17693 33095 34582 0.957000752 3 1 38.7 0.201671309 0.10056391
318 Matthew Belk 27 Male White February 13 2015 2420 Terry Rd Huntingdon TN 35.9514389 -88.57345579999999 47 17 962300 47017962300 47017 Census Tract 9623 Carroll County Sheriff's Office Gunshot Other 4517 19400 32522 35049 0.927900939 2 1 18.1 0.14012143900000001 0.088607595
38 Anthony Purvis 45 Male White February 3 2015 1404 N June Ave Douglas GA 31.523361199999997 -82.8451767 13 69 10400 13069010400 13069 Census Tract 104 Douglas Police Department Gunshot Firearm 4838 21769 38988 35693 1.09231502 4 2 27.8 0.11037302 0.17274357399999998
284 Kenneth Kreyssig 61 Male White February 10 2015 645 Smyrna Center Rd Smyrna ME 46.1598784 -68.1000068 23 3 952600 23003952600 23003 Census Tract 9526 Maine State Troopers and Aroostook County Sheriff's Department Gunshot Knife 3045 18760 40288 37855 1.064271563 4 2 17.9 0.115207373 0.144492132
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
35 Anthony Giaquinta 41 Male Hispanic/Latino February 22 2015 Lower Pond Ct Clarkesville GA 34.6314812 -83.5972519 13 137 202 13137000202 13137 Census Tract 2.02 Habersham County Sheriff's Office Gunshot Firearm 5601 22085 47196 39306 1.200732713 5 3 9.5 0.133676093 0.26816187199999997
23 Andres Lara-Rodriguez 21 Male Hispanic/Latino February 13 2015 S 12th St and Ruby St Kansas City KS 39.0714403 -94.6402303 20 209 45000 20209045000 20209 Census Tract 450 Kansas City KS Police Department and Kansas Highway Patrol Gunshot Other 4149 22719 32471 39402 0.824095224 2 1 36.5 0.178185745 0.070931245
398 Roy Day 51 Male White February 14 2015 Gale St Laredo TX 27.554154999999998 -99.478091 48 479 1601 48479001601 48479 Census Tract 16.01 Laredo Police Department Gunshot Knife 3999 20900 42782 39449 1.084488834 4 2 17.4 0.05793871900000001 0.20679146699999998
329 Michael Ireland 31 Male White February 18 2015 1400 N Marion Ave Springfield MO 37.2242855 -93.3193785 29 77 1800 29077001800 29077 Census Tract 18 Springfield Police Department Gunshot No 2816 13929 26613 40337 0.6597664679999999 1 1 26.5 0.166007905 0.105626851
361 Pedro 'Pete' Juan Saldivar 50 Male Hispanic/Latino February 17 2015 US-90 and Charles Dr Del Rio TX 29.3685202 -100.8305995 48 465 950500 48465950500 48465 Census Tract 9505 Del Rio Police Department and Val Verde County Sheriff's Office Gunshot No 7556 17402 42026 40450 1.038961681 4 2 24.5 0.053399922999999995 0.136064165
255 Jonathan Pierce 37 Male White February 12 2015 Port St Joe Police Station, 410 Williams Ave Port St Joe FL 29.812402000000002 -85.30191500000001 12 45 960200 12045960200 12045 Census Tract 9602 Port St Joe Police Department Gunshot No 3660 20769 38176 40455 0.943665802   2 16 0.129227053 0.169018933
14 Alexander Long 31 Male White February 25 2015 25th St and Poplar St Terre Haute IN 39.4629302 -87.3788602 18 167 1400 18167001400 18167 Census Tract 14 Terre Haute Police Department Gunshot Firearm 3413 25563 44857 40692 1.1023542709999998 4 2 13.1 0.05447010099999999 0.34585785399999996
238 Jimmy Robinson Jr 51 Male Black February 4 2015 I-35 Waco TX 31.593082 -97.108858 48 309 1600 48309001600 48309 Census Tract 16 Waco Police Department Gunshot No 5506 21988 33320 41922 0.794809408 2 1 36.1 0.140606992 0.058467131
49 Betty Sexton 43 Female White February 17 2015 2325 Union Rd Gastonia NC 35.228649100000005 -81.1696243 37 71 32800 37071032800 37071 Census Tract 328 Gastonia Police Department Gunshot Firearm 5876 18843 30408 42017 0.723707071 1 1 28.7 0.195510204 0.17036235800000002
196 James Allen 74 Male Black February 7 2015 2701 Mary Ave Gastonia NC 35.2658062 -81.2271642 37 71 31800 37071031800 37071 Census Tract 318 Gastonia Police Department Gunshot Firearm 4049 15489 28696 42017 0.682961658 1 1 33.7 0.19297235 0.045287638
286 Kent Norman 51 Male White February 21 2015 1800 Heather Cir Indianapolis IN 39.792715799999996 -85.9919228 18 97 360502 18097360502 18097 Census Tract 3605.02 Indianapolis Metropolitan Police Department Gunshot Firearm 6142 25226 43110 42334 1.01833042 4 2 15.1 0.12563323199999998 0.090463918
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
213 Jason Carter 41 Male White February 21 2015 298 Gavilan Canyon Rd Rudioso NM 33.3267975 -105.6342545 35 27 960400 35027960400 35027 Census Tract 9604 New Mexico State Police and US Marshals Service Gunshot No 6941 18975 38893 43014 0.904193983 2 2 17.6 0.061612903 0.199338135
294 Lavall Hall 25 Male Black February 15 2015 19157 NW 3rd Ave Miami Gardens FL 25.9503192 -80.20742249999999 12 86 9906 12086009906 12086 Census Tract 99.06 Miami Gardens Police Department Gunshot Firearm 4945 26067 52453 43100 1.2170069609999998 4 3 8.2 0.116955017 0.16485773
105 David Cuevas 42 Male Hispanic/Latino February 26 2015 4660 N Socrum Loop Rd Lakeland FL 28.103445100000002 -81.9506454 12 105 12206 12105012206 12105 Census Tract 122.06 Lakeland Police Department Gunshot Firearm 5059 21474 39108 43113 0.907104586 2 2 14.3 0.155357805 0.258240183
393 Rodney Biggs 49 Male White February 26 2015 US-49 and Middle Driveway Gulfport MS 30.4247537 -89.09252430000001 28 47 1800 28047001800 28047 Census Tract 18 Gulfport Police Department Gunshot Other 2923 12930 19031 43124 0.441308784 1 1 47.1 0.12725450900000002 0.088779956
430 Terry Price 41 Male Black February 21 2015 951 West 36th St N Tulsa OK 36.205974700000006 -96.0020301 40 113 940005 40113940005 40113 Census Tract 9400.05 Osage Nation Police Department Taser Firearm 3630 26566 47350 44195 1.071388166 4 3 7.5 0.068774265 0.166792169
292 Larry Hostetter 41 Male White February 9 2015 200 Jordan Dr Nocona TX 33.78727 -97.71276379999999 48 337 950200 48337950200 48337 Census Tract 9502 Nocona Police Department Gunshot Other 1683 23750 45500 44231 1.028690285 2 3 10.3 0.075596817 0.140482128
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
460 Wilber Castillo-Gongora 35 Male Hispanic/Latino February 5 2015 US-287 Electra TX 34.044584 -98.931198 48 485 13800 48485013800 48485 Census Tract 138 Wichita County Sheriff's Office Taser Unknown 3507 31761 62817 45086 1.3932706380000002 5 4 4 0.034519957000000004 0.16980360100000003
177 Glenn Lewis 37 Male Black February 25 2015 2201 NW 27th St Oklahoma City OK 35.4976883 -97.5500717 40 109 100200 40109100200 40109 Census Tract 1002 Oklahoma City Police Department Gunshot No 5823 20405 29338 45215 0.6488554679999999 2 1 31.3 0.04467354 0.294754572
185 Herbert Hill 26 Male Black February 6 2015 1000 SW 62nd St Oklahoma City OK 35.40306470000001 -97.5325623 40 109 107220 40109107220 40109 Census Tract 1072.20 Oklahoma City Police Department Gunshot Knife 3754 14932 25357 45215 0.560809466 1 1 37.4 0.12745682 0.068254695
194 Jacob Haglund 17 Male White February 2 2015 1600 3rd St Bay City MI 43.5996857 -83.8729324 26 17 280300 26017280300 26017 Census Tract 2803 Bay City Police Department Gunshot Knife 1404 14504 19097 45376 0.42086124799999997 1 1 40 0.260663507 0.10129870099999999
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
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
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
33 Anthony Bess 48 Male Black February 10 2015 4545 Aldridge Dr Memphis TN 35.0246391 -90.0544891 47 157 22322 47157022322 47157 Census Tract 223.22 Memphis Police Department Gunshot Vehicle 4228 22968 37109 46250 0.802356757 3 2 18.9 0.218520333 0.140077821
314 Markell Atkins 36 Male Black February 4 2015 3800 Vernon Ave Memphis TN 35.1648337 -89.9334182 47 157 8800 47157008800 47157 Census Tract 88 Shelby County Sheriff's Department [US Marshals Service Task Force] Gunshot Firearm 6876 19029 32162 46250 0.695394595 3 1 34.3 0.112596554 0.040115301
229 Jeremy Lett 28 Male Black February 5 2015 2400 W Tharpe St Tallahassee FL 30.466476399999998 -84.32925420000001 12 73 2101 12073002101 12073 Census Tract 21.01 Tallahassee Police Department Gunshot Vehicle 4498 19218 38658 46369 0.833703552 2 2 32.6 0.133175195 0.38185567
193 Izzy Colon 37 Male Hispanic/Latino February 4 2015 4304 Pershing Pointe Pl Orlando FL 28.499574699999997 -81.3055038 12 95 13508 12095013508 12095 Census Tract 135.08 Orlando Police Department Gunshot Firearm 2537 17433 29410 47581 0.618103865 1 1 30.7 0.153279786 0.17137229199999998
261 Joseph Paffen 46 Male White February 8 2015 4501 Hoffner Ave Orlando FL 28.480550899999997 -81.3283666 12 95 13606 12095013606 12095 Census Tract 136.06 Orange County Sheriff's Office Gunshot Firearm 3748 17213 30069 47581 0.631953931 1 1 35.2 0.12754607199999998 0.146364057
53 Bradford Leonard 50 Male White February 22 2015 900 Castile Rd SE Palm Bay FL 27.990676899999997 -80.64576720000001 12 9 71322 12009071322 12009 Census Tract 713.22 Palm Bay Police Department Gunshot Knife 8874 22105 39535 48039 0.8229771640000001 2 2 14.1 0.080136986 0.175059952
86 Cornelius Parker 28 Male Black February 28 2015 E Broadway and US-63 Columbia MO 38.9464501 -92.2934712 29 19 1001 29019001001 29019 Census Tract 10.01 Boone County Sheriff's Department Gunshot Firearm 4377 21264 36649 48627 0.7536759409999999 2 2 36.2 0.034616881 0.674125874
76 Chazsten Freeman 24 Male White February 27 2015 South Carolina Rte 8 and Augusta Rd Peltzer SC 34.6285944 -82.3912225 45 45 3201 45045003201 45045 Census Tract 32.01 Greenville County Sheriff's Office Gunshot Firearm 5304 22409 42159 49022 0.860001632 3 2 14.4 0.095290859 0.198029891
127 Desmond Luster 45 Male Black February 9 2015 7400 Bonnie View Rd Dallas TX 32.6565955 -96.7502993 48 113 20200 48113020200 48113 Census Tract 202 Dallas Police Department Gunshot Firearm 4044 14256 23931 49481 0.483640185 1 1 40.1 0.172051696 0.029108327000000003
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
66 Calvon Reid 39 Male Black February 22 2015 1701 Andros Isle Coconut Creek FL 26.256782 -80.167854 12 11 30704 12011030704 12011 Census Tract 307.04 Coconut Creek Police Department Taser Firearm 4828 27031 39561 51251 0.77190689 2 2 7.8 0.08115048799999999 0.358902001
10 Alan James 31 Male White February 7 2015 200 Abbie St SE Wyoming MI 42.8932381 -85.6605835 26 81 14200 26081014200 26081 Census Tract 142 Kentwood Police Department and Wyoming DPS Gunshot Other 3795 22005 44553 51667 0.8623105659999999 3 2 18.4 0.174167417 0.102691511
165 Francis Spivey 43 Male White February 25 2015 5300 East Craig Road Las Vegas NV 36.242111200000004 -115.05694579999998 32 3 6001 32003006001 32003 Census Tract 60.01 Las Vegas Metro Police (Swat) Gunshot Firearm 4726 23444 35924 52873 0.6794394109999999 1 2 19.9 0.16389811699999998 0.21772039199999998
259 Joseph Biegert 30 Male White February 24 2015 1500 Plymouth Ln Green Bay WI 44.5266283 -88.05789159999999 55 9 401 55009000401 55009 Census Tract 4.01 Green Bay Police Department Gunshot Firearm 4716 23633 33835 53119 0.636966057 1 1 13.6 0.08816521 0.213095586
13 Alejandro Salazar Unknown Male Hispanic/Latino February 20 2015 1200 E Airtex Dr Houston TX 29.9832049 -95.4038566 48 201 240702 48201240702 48201 Census Tract 2407.02 US Marshals Service Gunshot No 11228 27414 53572 53137 1.008186386 3 3 18.1 0.073771857 0.095803642
189 Hung Trieu 35 Male Asian/Pacific Islander February 2 2015 13442 Bellaire Blvd Houston TX 29.704109000000003 -95.621871 48 201 452600 48201452600 48201 Census Tract 4526 Harris County Attorney's Department Gunshot No 7538 21306 41786 53137 0.78638237 2 2 28.3 0.10471204199999999 0.22823219
96 Daniel Elrod 39 Male White February 24 2015 1299 Hickory St Omaha NE 41.242793799999994 -95.93312809999999 31 55 2100 31055002100 31055 Census Tract 21 Omaha Police Department Gunshot Firearm 2314 16218 32948 53325 0.617871542 2 1 30.5 0.093378608 0.10933759
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
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
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
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
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
321 Matthew Lundy 32 Male White February 17 2015 3800 Canfield Rd Eaton Rapids Township MI 42.5121727 -84.7003385 26 45 21201 26045021201 26045 Census Tract 212.01 Eaton County Sheriff's Office Gunshot Other 3021 33875 71417 54115 1.319726508 5 4 3.3 0.069385271 0.238783649
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
232 Jerome Nichols 42 Male White February 23 2015 N Plymouth St Allentown PA 40.632019 -75.4338379 42 77 101 42077000101 42077 Census Tract 1.01 Catasauqua Police Department Gunshot Knife 3436 26001 46027 54923 0.8380277840000001 2 3 11.3 0.072277228 0.19303675
373 Richard Carlin 35 Male White February 13 2015 414 Rehr St Reading PA 40.3287582 -75.9080353 42 11 2000 42011002000 42011 Census Tract 20 Pennsylvania State Police Gunshot Firearm 4017 20761 29707 55170 0.5384629329999999 1 1 36.6 0.13974287300000002 0.068331143
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
325 Michael Casper 26 Male White February 16 2015 Malad St and Gourley St Boise ID 43.5789295 -116.22232220000001 16 1 1700 16001001700 16001 Census Tract 17 Boise Police Department Gunshot Knife 5726 20296 33611 55210 0.60878464 1 1 29.6 0.11779733199999999 0.228324505
210 Janisha Fonville 20 Female Black February 19 2015 Bellefonte Dr Charlotte NC 35.2506218 -80.8187485 37 119 5200 37119005200 37119 Census Tract 52 Charlotte-Mecklenburg Police Department Gunshot Firearm 2986 11184 18457 55444 0.332894452 1 1 68.2 0.42232142899999997 0.079066753
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
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
387 Robert Kohl 47 Male White February 23 2015 175 Bass Pro Blvd Denham Springs LA 30.4504135 -90.9602784 22 63 40805 22063040805 22063 Census Tract 408.05 Denham Springs Police Department Gunshot Firearm 5375 30540 70469 56811 1.240411188 5 4 10.8 0.065487392 0.204924761
399 RubÌ_å©n GarcÌ__a Villalpando 31 Male Hispanic/Latino February 20 2015 2500 Texas Hwy 121 Euless TX 32.872246399999995 -97.0993902 48 439 113519 48439113519 48439 Census Tract 1135.19 Grapevine Police Department Gunshot Vehicle 5917 43062 79821 56853 1.403989235 5 5 2.9 0.06846473 0.411525586
60 Brian Fritze 45 Male White February 10 2015 I-70 and US-6 Glenwood Springs CO 39.56085220000001 -107.3613187 8 45 951600 8045951600 8045 Census Tract 9516 Garfield County Sheriff's Office Gunshot Knife 3880 35827 59051 57022 1.0355827579999999 3 4 7.7 0.044583332999999996 0.380767739
407 Sawyer Flache 27 Male White February 8 2015 Texas Hwy 71 and Silvermine Dr Austin TX 30.2470483 -97.88839140000002 48 453 1908 48453001908 48453 Census Tract 19.08 Austin Police Department Gunshot No 8776 44430 84743 58025 1.4604567 5 5 7.3 0.069404151 0.636127355
111 David Kassick 59 Male White February 2 2015 36 Grandview Rd Hanover PA 39.7720299 -76.96617890000002 42 133 21801 42133021801 42133 Census Tract 218.01 Hummelstown Police Department Gunshot Firearm 4487 30491 65581 58745 1.11636735 4 4 7.4 0.034010601 0.267043669
84 Cody Evans 24 Male White February 15 2015 1600 W 500 N Provo UT 40.2463989 -111.6674271 49 49 2000 49049002000 49049 Census Tract 20 Provo Police Department Gunshot Knife 6457 14816 41866 60196 0.695494717 1 2 20.5 0.071107364 0.25940902
336 Michael Smashey 37 Male White February 23 2015 4817 W Mceachern Woods Dr Powder Springs GA 33.9112854 -84.69478609999999 13 67 30234 13067030234 13067 Census Tract 302.34 Cobb County Sheriff's Office Gunshot No 5456 49269 96625 63920 1.511655194 4 5 3 0.05030591400000001 0.43163841799999997
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
216 Jason Hendrix 16 Male White February 14 2015 1486 Hyde Park Rd Essex MD 39.298347799999995 -76.44016140000001 24 5 450504 24005450504 24005 Census Tract 4505.04 Baltimore County Police Department Gunshot Firearm 5437 25865 38879 66486 0.584769726 1 2 11.3 0.115929459 0.136934307
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
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
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
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
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
141 Doug Sparks 30 Male White February 17 2015 Forest Ave Tewksbury MA 42.614631700000004 -71.28314209999999 25 17 315100 25017315100 25017 Census Tract 3151 Tewksbury Police Department Gunshot No 5994 51071 102399 82090 1.247399196 4 5 1.8 0.058623619 0.41799308
456 Vincent Cordaro 57 Male White February 9 2015 N Little Tor Rd New City NY 41.1689186 -74.00443270000001 36 87 10801 36087010801 36087 Census Tract 108.01 Clarkstown Police Department Gunshot Firearm 4164 52896 142500 84951 1.6774375819999998 5 5 1.9 0.045 0.669916938
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
343 Natasha McKenna 37 Female Black February 8 2015 Fairfax County Adult Detention Center, 10520 Judicial Dr Fairfax VA 38.843990000000005 -77.311132 51 59 440502 51059440502 51059 Census Tract 4405.02 Fairfax County Sheriff's Office Taser No 7408 5688 138750 110292 1.2580241540000001 4 5 5.6 0.016203704 0.7169069459999999

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