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

114 rows where month = "March" sorted by county_fp

View and edit SQL

month

  • March · 91
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
32 Angelo West 41 Male Black March 27 2015 Humboldt Ave and Ruthven St Roxbury MA 42.3126099 -71.0899229 25 25 82100 25025082100 25025 Census Tract 821 Boston Police Department Gunshot Firearm 4924 14995 20388 53540 0.380799402 1 1 41.3 0.22039801 0.18233618199999999
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
444 Tony Robinson 19 Male Black March 6 2015 1125 Williamson St Madison WI 43.0824051 -89.36500550000001 55 25 1900 55025001900 55025 Census Tract 19 Madison Police Department Gunshot Firearm 6145 35028 53089 61721 0.860144845 2 3 13.3 0.055254849 0.744900197
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
346 Neil Seifert 40 Male White March 27 2015 N Main St Webster MA 42.058589899999994 -71.8781281 25 27 754200 25027754200 25027 Census Tract 7542 Webster Police Department Gunshot No 3776 21131 35507 65223 0.544393849 1 2 16.7 0.134320175 0.158213475
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
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
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
374 Richard Castilleja 29 Male Hispanic/Latino March 14 2015 2615 Mossrock San Antonio TX 29.5134506 -98.53582 48 29 181001 48029181001 48029 Census Tract 1810.01 San Antonio Police Department Gunshot Firearm 3679 26047 45208 50112 0.9021392079999999 3 3 21.7 0.074115665 0.240572172
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
447 Tyrel Vick 34 Male White March 20 2015 Oklahoma Hwy 48 and E1750 Rd Wapanucka OK 34.476518 -96.4245157 40 29 388200 40029388200 40029 Census Tract 3882 Oklahoma Highway Patrol and Tupelo Police Department Gunshot Firearm 2032 25110 40000 34867 1.147216566   2 20.7 0.05624297 0.163706564
280 Kendre Alston 16 Male Black March 19 2015 1800 Helena St Jacksonville FL 30.3778403 -81.6836172 12 31 11500 12031011500 12031 Census Tract 115 Jacksonville Sheriff's Office Gunshot Firearm 4294 14754 23880 48323 0.49417461700000004 1 1 36.4 0.23204104899999997 0.105285592
208 Jamie Croom 31 Male Black March 10 2015 10064 Elm Grove Garden Dr Baton Rouge LA 30.536673399999998 -91.1694337 22 33 3103 22033003103 22033 Census Tract 31.03 US Marshals Service Gunshot Vehicle 1862 10219 21964 48506 0.452809962 1 1 48.4 0.27734375 0.12077294699999999
54 Brandon Jones 18 Male Black March 19 2015 1077 Parkwood Dr Cleveland OH 41.52857589999999 -81.6090775 39 35 116500 39035116500 39035 Census Tract 1165 Cleveland Division of Police Gunshot Firearm 2182 14560 19643 43804 0.448429367 1 1 32.8 0.20428015600000002 0.083226633
433 Theodore Johnson 64 Male Black March 10 2015 6902 Ottawa Rd Cleveland OH 41.4501534 -81.6409378 39 35 115400 39035115400 39035 Census Tract 1154 Cleveland Division of Police Gunshot No 1548 15871 21378 43804 0.488037622 1 1 39.8 0.448074679 0.0675
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
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
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
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
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
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
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
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
138 Donald Matkins 49 Male White March 1 2015 Mt Pleasant Rd Lucedale MS 30.8003197 -88.6320801 28 39 950301 28039950301 28039 Census Tract 9503.01 George County Sheriff's Department Gunshot Firearm 6604 21837 36319 43958 0.826220483 1 2 22.9 0.105180534 0.09578997199999999
424 Steven Snyder 37 Male White March 24 2015 760 W Johnson St Fond du Lac WI 43.7826881 -88.4753418 55 39 40300 55039040300 55039 Census Tract 403 Wisconsin State Police Gunshot Firearm 6145 20423 34339 53820 0.638034188 1 1 26.6 0.109457093 0.14297231900000001
228 Jeremy Kelly 27 Male Black March 25 2015 Dixie St Johnsonville SC 33.8190804 -79.4618912 45 41 1900 45041001900 45041 Census Tract 19 Johnsonville Police Department and Florence County Sheriff's Department (Swat) Gunshot Firearm 6384 17493 32639 41910 0.778787879 2 1 24.1 0.15176873300000002 0.109768379
129 Deven Guilford 17 Male White March 1 2015 331 W Grand Ledge Hwy Roxand Township MI 42.755621399999995 -84.8926637 26 45 20500 26045020500 26045 Census Tract 205 Eaton County Sheriff's Office Gunshot Non-lethal firearm 3751 32088 67756 54115 1.252074286 5 4 8.5 0.09042553199999999 0.16807692300000002
160 Fednel Rhinvil 25 Male Black March 3 2015 East Rd and Olivia St Salisbury MD 38.3791997 -75.60712020000001 24 45 10200 24045010200 24045 Census Tract 102 Maryland State Police Gunshot Firearm 6493 18976 30844 51092 0.603695295 1 1 23.4 0.20633872600000003 0.09398399199999999
134 Dominick Wise 30 Male Black March 30 2015 1301 Spring Meadow Ln Culpeper VA 38.484317499999996 -77.9793973 51 47 930300 51047930300 51047 Census Tract 9303 Culpeper Police Department Taser Firearm 6106 28490 46382 64423 0.7199602629999999 1 3 14.8 0.0509487 0.176186645
218 Jason Smith 42 Male White March 20 2015 4604 Summit St Columbus OH 40.059024 -82.997337 39 49 7730 39049007730 39049 Census Tract 77.30 Columbus Division of Police Gunshot Unknown 2993 22750 42642 50877 0.8381390409999999 3 2 13.4 0.063731932 0.24372586899999998
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
81 Christopher Mitchell 23 Male White March 10 2015 6530 Georgia Rte 21 Port Wentworth GA 32.1656761 -81.1842117 13 51 10700 13051010700 13051 Census Tract 107 Port Wentworth Police Department Gunshot Firearm 18168 37721 68136 45794 1.4878805080000002 5 4 12.2 0.050383480999999994 0.479000583
379 Richard White 63 Male Black March 20 2015 Louis Armstrong New Orleans International Airport, 900 Airline Dr Kenner LA 29.9859313 -90.2577119 22 51 980000 22051980000 22051 Census Tract 9800 Jefferson Parish Sheriff's Office Gunshot Disputed 0 -   48261       -    
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
182 Harvey Oates 42 Male White March 27 2015 Horseshoe Run Rd Fort Ashby WV 39.481971 -78.812003 54 57 10200 54057010200 54057 Census Tract 102 West Virginia State Police Gunshot Firearm 3255 26643 40541 31163 1.3009338 5 2 13.3 0.09318766099999999 0.160032167
227 Jeremy Anderson 36 Male White March 31 2015 1600 Grass Lake Dr Tampa Bay FL 28.102209100000003 -82.4886322 12 57 11107 12057011107 12057 Census Tract 111.07 Tampa Bay Police Department [US Marshals Service Task Force] Gunshot No 6993 35194 77275 49596 1.5580893619999998 5 5 7.9 0.063364345 0.42492080299999996
3 Aaron Siler 26 Male White March 14 2015 22nd Ave and 56th St Kenosha WI 42.5835597 -87.83571009999999 55 59 1200 55059001200 55059 Census Tract 12 Kenosha Police Department Gunshot No 4079 25286 45365 54930 0.8258692879999999 2 3 14.6 0.166293142 0.147312269
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
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
115 David Watford 47 Male White March 17 2015 US-65 Tallulah LA 32.3727417 -91.19936369999999 22 65 960200 22065960200 22065 Census Tract 9602 Louisiana State Troopers Struck by vehicle Firearm 3403 15373 21803 25498 0.855086673 2 1 43.1 0.192203083 0.123522459
349 Nicholas Thomas 23 Male Black March 24 2015 2475 Cumberland Pkwy SE Atlanta GA 33.86441 -84.477958 13 67 31211 13067031211 13067 Census Tract 312.11 Smyrna Police Department Gunshot Knife 3574 45795 53891 63920 0.8431007509999999 2 3 6.9 0.033260234 0.543604651
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
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
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
465 William Poole 52 Male White March 16 2015 130 Wedowee Ln Gaston NC 35.205776 -81.240669 37 71 31704 37071031704 37071 Census Tract 317.04 Gaston County Police Department Gunshot Firearm 3850 21175 38200 42017 0.909155818 2 2 28.5 0.256149733 0.072764228
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
170 Garland Wingo 64 Male White March 18 2015 Lake Ella Tallahassee FL 30.4609642 -84.2794113 12 73 700 12073000700 12073 Census Tract 7 Tallahassee Police Department Gunshot Firearm 1911 21261 28859 46369 0.622377019 2 1 36.6 0.091334895 0.35888501700000003
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
201 James Ellis 44 Male White March 21 2015 New York State Rte 31A Clarendon NY 43.1940384 -78.065712 36 73 40801 36073040801 36073 Census Tract 408.01 Orleans County Sheriff's Office Gunshot Firearm 4696 30489 57747 48502 1.190610696 5 4 9.5 0.09765625 0.16256457
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
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
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
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
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
449 Tyrone Ryerson 45 Male Black March 5 2015 468 E Plainfield Ave Milwaukee WI 42.9687729 -87.9034882 55 79 20900 55079020900 55079 Census Tract 209 Milwaukee Police Department Gunshot Non-lethal firearm 2657 35316 63444 43193 1.4688491190000001 5 4 11 0.065342729 0.296017223
200 James Damon 46 Male White March 9 2015 US-40 Craig CO 40.5144005 -107.4890213 8 81 300 8081000300 8081 Census Tract 3 Moffat County Sheriff's Office and Colorado Parks and Wildlife Law Enforcement Gunshot No 2892 39179 74510 53231 1.3997482669999999   4 7.7 0.041666667000000004 0.207537688
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
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
37 Anthony Hill 27 Male Black March 9 2015 3028 Chamblee Dunwoody Rd Chamblee GA 33.8942184 -84.3032227 13 89 21208 13089021208 13089 Census Tract 212.08 DeKalb County Sheriff's Department Gunshot No 3305 32142 57964 50856 1.139767186 4 4 18.6 0.170409511 0.565535024
179 Gregory Smith 39 Male White March 30 2015 2293 N Main St Crown Point IN 41.4479828 -87.37110899999999 18 89 42504 18089042504 18089 Census Tract 425.04 Lake County Sheriff's Department Taser Firearm 7338 36727 65074 49035 1.3270928929999999 5 4 8.8 0.086255656 0.307383628
119 Deanne Choate 53 Female White March 26 2015 400 N Birch Gardner KS 38.816658000000004 -94.9135437 20 91 53707 20091053707 20091 Census Tract 537.07 Gardner Police Department Gunshot Firearm 4643 33869 67702 74717 0.906112397 3 4 6.3 0.035865793 0.28366187800000003
65 Byron Herbert 29 Male Black March 29 2015 111 Towne Dr Elizabethtown KY 37.734657 -85.88842700000001 21 93 901 21093000901 21093 Census Tract 9.01 Elizabethtown Police Department Gunshot Knife 10220 28556 58463 48687 1.2007928190000001 4 4 8.6 0.053564237 0.214598953
167 Fred Liggett Jr 59 Male White March 13 2015 8700 E 97th Ter Kansas City MO 38.9474373 -94.4866943 29 95 12906 29095012906 29095 Census Tract 129.06 US Marshals Service Gunshot No 4411 25030 46007 47015 0.978560034 3 3 14.1 0.138454667 0.16181116199999998
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
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
125 Denzel Brown 21 Male Black March 22 2015 1851 Sunrise Hwy Bay Shore NY 40.7399445 -73.2372284 36 103 146003 36103146003 36103 Census Tract 1460.03 Suffolk County Police Department Gunshot Firearm 8222 30784 72218 87763 0.822875244 1 4 4.4 0.10936837599999999 0.240339473
29 Andrew Williams 48 Male Black March 6 2015 Putnam Loop Rd Putnam Hall FL 29.743281 -81.963951 12 107 950300 12107950300 12107 Census Tract 9503 Putnam County Sheriff's Office Gunshot Firearm 6172 23926 36844 32497 1.1337661940000001 4 2 18.2 0.17614879600000002 0.15356292
43 Aurelio Duarte 40 Male Hispanic/Latino March 8 2015 3632 SW 38th St Oklahoma City OK 35.4262543 -97.5826111 40 109 107001 40109107001 40109 Census Tract 1070.01 Oklahoma City Police Department Gunshot Vehicle 5887 17225 32860 45215 0.726749972 2 1 25.1 0.142746615 0.035338785
100 Darrell 'Hubbard' Gatewood 47 Male Black March 1 2015 616 SW 59th St Oklahoma City OK 35.4057617 -97.524292 40 109 107222 40109107222 40109 Census Tract 1072.22 Oklahoma City Police Department Taser Firearm 1812 22857 32886 45215 0.727325003 2 1 33.4 0.20327102800000002 0.081980519
450 Tyson Hubbard 34 Male White March 5 2015 27th St and Fletcher Ave Lincoln NE 40.8747297 -96.68187009999998 31 109 2900 31109002900 31109 Census Tract 29 US Marshals Service Gunshot Unknown 5459 26597 40404 51574 0.7834180009999999 2 2 19.9 0.055735770999999996 0.362382445
195 Jamalis Hall 39 Male Black March 27 2015 1000 block Mayflower Rd Fort Pierce FL 27.448650399999995 -80.3266068 12 111 380100 12111380100 12111 Census Tract 3801 Saint Lucie County Sheriff's Office Gunshot Firearm 732 11338 11378 43413 0.262087393 1 1 54.2 0.305194805 0.095599393
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
446 Troy Boyd 36 Male White March 15 2015 McEwien Swamp Rd Ruth MS 31.324930199999997 -90.31533809999999 28 113 950101 28113950101 28113 Census Tract 9501.01 Pike County Sheriff's Office Gunshot Firearm 4980 22213 46740 34841 1.341522918 5 3 15.5 0.055140187 0.127942064
42 Askari Roberts 35 Male Black March 17 2015 3189 Morton Bend Rd Rome GA 34.2185669 -85.3869934 13 115 2000 13115002000 13115 Census Tract 20 Floyd County Sheriff's Office Taser Knife 4947 20248 40708 40821 0.9972318170000001 3 2 20.5 0.150121065 0.192909897
48 Bernard Moore 62 Male Black March 6 2015 Metropolitan Pkwy and Fair Dr Atlanta GA 33.7033899 -84.40805019999999 13 121 7500 13121007500 13121 Census Tract 75 Atlanta Police Department Struck by vehicle No 3580 14256 17545 56857 0.308581177 1 1 41.4 0.23108747 0.129396985
271 Justin Tolkinen 28 Male White March 16 2015 400 White Bear Ave St Paul MN 44.9535713 -93.02455140000001 27 123 34701 27123034701 27123 Census Tract 347.01 St Paul Police Department Gunshot Firearm 4264 23280 47525 54247 0.8760853129999999 2 3 18.1 0.106712565 0.161686451
126 Derek Cruice 26 Male White March 4 2015 800 Maybrook Dr Deltona FL 28.886303499999997 -81.25322390000001 12 127 91017 12127091017 12127 Census Tract 910.17 Volusia County Sheriff's Office Gunshot Unknown 3536 19921 43413 42457 1.022516899 3 2 17.4 0.102382486 0.056138934
388 Robert Rooker 26 Male White March 29 2015 Fields Hollow Rd Peebles OH 39.083271 -83.25554659999999 39 131 952700 39131952700 39131 Census Tract 9527 Pike County Sheriff's Department Gunshot Vehicle 4430 18133 46007 42165 1.0911182259999999 5 3 18.2 0.177073171 0.086883596
428 Terrance Moxley 29 Male Black March 10 2015 280 N Main St Mansfield OH 40.766098 -82.5142975 39 139 3100 39139003100 39139 Census Tract 31 Mansfield Police Department Taser Firearm 2326 11576 19732 41835 0.471662484 1 1 40.3 0.177252585 0.066876475
205 James Moore 43 Male White March 22 2015 5900 S Lewis Ave Tulsa OK 36.078752200000004 -95.9580338 40 143 6803 40143006803 40143 Census Tract 68.03 Tulsa Police Department Struck by vehicle Vehicle 2712 20213 31169 48181 0.646914759 1 1 21.1 0.119248218 0.319685039
5 Adam Jovicic 29 Male White March 19 2015 364 Hiwood Ave Munroe Falls OH 41.1485748 -81.4298782 39 153 530800 39153530800 39153 Census Tract 5308 Kent Police Department Gunshot No 6809 33954 68785 49669 1.384867825 5 4 1.9 0.063549832 0.403954214
202 James Greenwell 31 Male White March 11 2015 700 N Auburndale St Memphis TN 35.1571117 -90.00006640000001 47 157 1700 47157001700 47157 Census Tract 17 Memphis Police Department Gunshot Other 3636 22255 40721 46250 0.8804540540000001 3 2 15.4 0.13939105599999999 0.324362111
297 Lester Brown 58 Male White March 9 2015 85 Almost Home Rd Penrose NC 35.2702599 -82.6380997 37 175 960100 37175960100 37175 Census Tract 9601 North Carolina Alcohol Law Enforcement, Transylvania County Sheriff's Office, Homeland Security Gunshot Firearm 5006 19645 36583 41781 0.875589383 2 2 14.8 0.09527468300000001 0.15303283199999998
434 Thomas Allen Jr 34 Male Black March 1 2015 Morton Ave and Chatham Ave St Louis MO 38.673210100000006 -90.2913402 29 189 213900 29189213900 29189 Census Tract 2139 Wellston Police Department Gunshot Firearm 2150 11656 20844 58910 0.35382787299999996 1 1 50.8 0.299757282 0.05115346
413 Shaquille Barrow 20 Male Black March 2 2015 Richards St Joliet IL 41.525211 -88.07419499999999 17 197 882000 17197882000 17197 Census Tract 8820 Joliet Police Department Gunshot Firearm 3362 16065 25093 76147 0.329533665 1 1 37.5 0.152272727 0.070552147
47 Benjamin Quezada 21 Male Hispanic/Latino March 31 2015 West Texas Ave and Gaillard St Baytown TX 29.7330154 -94.9706357 48 201 254400 48201254400 48201 Census Tract 2544 Baytown Police Department Gunshot Other 3013 18995 30804 53137 0.579709054 1 1 36.2 0.109816972 0.022668393999999998
445 Tony Ross 34 Male White March 6 2015 Lamar St and Whitworth St Sulphur Springs TX 33.1287286 -95.5938203 48 223 950600 48223950600 48223 Census Tract 9506 Sulphur Springs Police Department Taser Knife 4177 19921 42282 43657 0.968504478 2 2 24.3 0.197698745 0.18205510100000002
223 Jeffrey Jackson 47 Male White March 22 2015 Kentucky Rte 92 Williamsburg KY 36.7391205 -84.1332397 21 235 920500 21235920500 21235 Census Tract 9205 Whitley County Sheriff's Department and Kentucky State Police Death in custody Firearm 6740 15289 27582 29769 0.9265343140000001 3 1 33.2 0.096566524 0.14285714300000002
159 Eugene Smith II 20 Male White March 17 2015 313 S Houston Ave Onalaska TX 30.706146 -94.93002299999999 48 373 210102 48373210102 48373 Census Tract 2101.02 Onalaska Police Department Gunshot No 6613 26675 39113 37855 1.03323207 3 2 16.3 0.133622126 0.10316428300000001
254 Jonathan Paul 42 Male Black March 12 2015 300 E Mitchell St Arlington TX 32.728282899999996 -97.1045675 48 439 122400 48439122400 48439 Census Tract 1224 Arlington Police Department Death in custody No 5947 14765 25625 56853 0.450723796 1 1 36.4 0.106456044 0.390316206
457 Walter Brown III 29 Male Black March 24 2015 19 Colin Drive S Portsmouth VA 36.818569200000006 -76.37033840000001 51 740 212900 51740212900 51740 Census Tract 2129 Portsmouth Police Department Gunshot Other 4996 27535 51480 46166 1.115106355 3 3 6.6 0.028934368 0.22578904800000002

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