Police Killings: police_killings.csv
Data license: CC Attribution 4.0 License · Data source: fivethirtyeight/data on GitHub · About: simonw/fivethirtyeight-datasette
18 rows where armed = "Vehicle"
This data as json, copyable, CSV (advanced)
Suggested facets: age, gender, raceethnicity, month, day, state, state_fp, county_fp, cause, share_black, share_hispanic, county_bucket, nat_bucket
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 | share_white | share_black | share_hispanic | p_income | h_income | county_income | comp_income | county_bucket | nat_bucket | pov | urate | college |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17 | 17 | Alexia Christian | 25 | Female | Black | April | 30 | 2015 | 141 Pryor St SW | Atlanta | GA | 33.7512627 | -84.3930283 | 13 | 121 | 3500 | 13121003500 | 13121 | Census Tract 35 | Atlanta Police Department | Gunshot | Vehicle | 1997 | 30.5 | 58.4 | 6.4 | 23205 | 56190 | 56857 | 0.988268815 | 3 | 3 | 42.4 | 0.229482072 | 0.3805374 |
21 | 21 | Amilcar Perez-Lopez | 21 | Male | Hispanic/Latino | February | 26 | 2015 | Folsom St and 24th St | San Francisco | CA | 37.7525108 | -122.4140801 | 6 | 75 | 22901 | 6075022901 | 6075 | Census Tract 229.01 | San Francisco Police Department | Gunshot | Vehicle | 4303 | 28.3 | 5.1 | 58.1 | 27384 | 60479 | 75604 | 0.799944447 | 2 | 4 | 12.7 | 0.115890508 | 0.349884906 |
33 | 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 | 0.6 | 98.6 | 0 | 22968 | 37109 | 46250 | 0.802356757 | 3 | 2 | 18.9 | 0.218520333 | 0.140077821 |
43 | 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 | 33.9 | 2.6 | 56.6 | 17225 | 32860 | 45215 | 0.726749972 | 2 | 1 | 25.1 | 0.142746615 | 0.035338785 |
75 | 75 | Charly 'Africa' Keunang | 43 | Male | Black | March | 1 | 2015 | 500 San Pedro St | Los Angeles | CA | 34.0437775 | -118.243721 | 6 | 37 | 206300 | 6037206300 | 6037 | Census Tract 2063 | Los Angeles Police Department | Gunshot | Vehicle | 5222 | 18 | 54.9 | 23 | 8206 | 10290 | 55909 | 0.18404908 | 1 | 1 | 79.2 | 0.439590444 | 0.060441941 |
124 | 124 | Dennis Fiel | 34 | Male | White | May | 17 | 2015 | 7700 Mesa College Dr | San Diego | CA | 32.8019612 | -117.154332 | 6 | 73 | 8702 | 6073008702 | 6073 | Census Tract 87.02 | San Diego Police Department | Gunshot | Vehicle | 5029 | 47.3 | 6.7 | 29 | 26928 | 66542 | 62962 | 1.056859693 | 3 | 4 | 10.8 | 0.056382146 | 0.385287202 |
158 | 158 | Ethan Noll | 34 | Male | White | April | 4 | 2015 | Mountainair St | Edgewood | NM | 35.0556297 | -106.1947021 | 35 | 49 | 10312 | 35049010312 | 35049 | Census Tract 103.12 | New Mexico State Police | Gunshot | Vehicle | 4356 | 67.9 | 0 | 27.1 | 27273 | 49308 | 52917 | 0.931798855 | 2 | 3 | 12.5 | 0.078817734 | 0.27692788 |
205 | 205 | James Moore | 43 | Male | White | March | 22 | 2015 | 5900 S Lewis Ave | Tulsa | OK | 36.0787522 | -95.9580338 | 40 | 143 | 6803 | 40143006803 | 40143 | Census Tract 68.03 | Tulsa Police Department | Struck by vehicle | Vehicle | 2712 | 63.2 | 21.4 | 4.7 | 20213 | 31169 | 48181 | 0.646914759 | 1 | 1 | 21.1 | 0.119248218 | 0.319685039 |
208 | 208 | Jamie Croom | 31 | Male | Black | March | 10 | 2015 | 10064 Elm Grove Garden Dr | Baton Rouge | LA | 30.5366734 | -91.1694337 | 22 | 33 | 3103 | 22033003103 | 22033 | Census Tract 31.03 | US Marshals Service | Gunshot | Vehicle | 1862 | 5.4 | 93.1 | 1.3 | 10219 | 21964 | 48506 | 0.452809962 | 1 | 1 | 48.4 | 0.27734375 | 0.120772947 |
229 | 229 | Jeremy Lett | 28 | Male | Black | February | 5 | 2015 | 2400 W Tharpe St | Tallahassee | FL | 30.4664764 | -84.3292542 | 12 | 73 | 2101 | 12073002101 | 12073 | Census Tract 21.01 | Tallahassee Police Department | Gunshot | Vehicle | 4498 | 56.5 | 35.1 | 2.9 | 19218 | 38658 | 46369 | 0.833703552 | 2 | 2 | 32.6 | 0.133175195 | 0.38185567 |
274 | 274 | Karen Janks | 46 | Female | White | April | 23 | 2015 | 2661 Gravenstein Hwy S | Sebastopol | CA | 38.3767128 | -122.7918701 | 6 | 97 | 153403 | 6097153403 | 6097 | Census Tract 1534.03 | Sonoma County Sheriff's Office | Gunshot | Vehicle | 4082 | 83.3 | 1.5 | 10.9 | 33918 | 68926 | 63356 | 1.087915904 | 4 | 4 | 6.6 | 0.065811966 | 0.400197954 |
276 | 276 | Kavonda Payton | 39 | Male | Black | January | 16 | 2015 | 138 Del Mar Cir | Aurora | CO | 39.7281647 | -104.8446426 | 8 | 5 | 7600 | 8005007600 | 8005 | Census Tract 76 | Aurora Police Department | Gunshot | Vehicle | 3219 | 37.7 | 17.2 | 42.1 | 25279 | 48169 | 60651 | 0.794199601 | 2 | 3 | 20.3 | 0.1340882 | 0.263902439 |
306 | 306 | Mack Long | 36 | Male | Black | April | 12 | 2015 | E 31st St and N Sherman Dr | Indianapolis | IN | 39.8115999 | -86.1025699 | 18 | 97 | 350700 | 18097350700 | 18097 | Census Tract 3507 | Indianapolis Metropolitan Police Department | Gunshot | Vehicle | 1471 | 1.4 | 87.2 | 4.5 | 20072 | 25677 | 42334 | 0.606533755 | 1 | 1 | 38.2 | 0.224820144 | 0.085378869 |
307 | 307 | Marcus Golden | 24 | Male | Black | January | 14 | 2015 | 261 E University Ave | St Paul | MN | 44.9580421 | -93.0942535 | 27 | 123 | 42800 | 27123042800 | 27123 | Census Tract 428 | St Paul Police Department | Gunshot | Vehicle | 2391 | 18.9 | 42.3 | 5.4 | 11425 | 18156 | 54247 | 0.334691319 | 1 | 1 | 48.9 | 0.223255814 | 0.177067083 |
341 | 341 | Nadir Soofi | 34 | Male | Asian/Pacific Islander | May | 3 | 2015 | 4999 Naaman Forest Blvd | Garland | TX | 32.9599406 | -96.6389561 | 48 | 113 | 19027 | 48113019027 | 48113 | Census Tract 190.27 | Garland Police Department | Gunshot | Vehicle | 4775 | 34.7 | 16.3 | 14.6 | 31009 | 49973 | 49481 | 1.009943211 | 3 | 3 | 9.2 | 0.092148913 | 0.315638907 |
352 | 352 | Norman Cooper | 33 | Male | Black | April | 19 | 2015 | 4800 Legend Well Dr | San Antonio | TX | 29.5922401 | -98.4028975 | 48 | 29 | 121810 | 48029121810 | 48029 | Census Tract 1218.10 | San Antonio Police Department | Taser | Vehicle | 4542 | 46.4 | 5.3 | 43.2 | 40693 | 71272 | 50112 | 1.422254151 | 4 | 4 | 5.2 | 0.047184774 | 0.355059417 |
388 | 388 | Robert Rooker | 26 | Male | White | March | 29 | 2015 | Fields Hollow Rd | Peebles | OH | 39.083271 | -83.2555466 | 39 | 131 | 952700 | 39131952700 | 39131 | Census Tract 9527 | Pike County Sheriff's Department | Gunshot | Vehicle | 4430 | 95.5 | 0 | 0 | 18133 | 46007 | 42165 | 1.091118226 | 5 | 3 | 18.2 | 0.177073171 | 0.086883596 |
399 | 399 | RubÌ_å©n GarcÌ__a Villalpando | 31 | Male | Hispanic/Latino | February | 20 | 2015 | 2500 Texas Hwy 121 | Euless | TX | 32.8722464 | -97.0993902 | 48 | 439 | 113519 | 48439113519 | 48439 | Census Tract 1135.19 | Grapevine Police Department | Gunshot | Vehicle | 5917 | 68.9 | 10.7 | 10.7 | 43062 | 79821 | 56853 | 1.403989235 | 5 | 5 | 2.9 | 0.06846473 | 0.411525586 |
Advanced export
JSON shape: default, array, newline-delimited
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 );