killings: 28
This data as json
| rowid | victim_name | victim_age | victim_gender | victim_race | victim_image | date_of_incident | street_addess | city | state | zip | county | agency | ori_agency_id | cause_of_death | description | official_disposition_of_death | criminal_charges | official_documentation | victim_mental_illness | victim_armed | alleged_weapon | alleged_threat_level | threat_level_description | victim_fleeing | body_camera | wa_po_id | off_duty | geography | MPV ID | fatal_encounters_id | encounter_type | reported_reason_for_encounter | officer_names | officer_races | officer_past_shootings | call_for_service | census_tract_id | hud_upsai_geography | nchs_urban_rural_id | census_median_household_income | latitude | longitude | census_population | white_non_hispanic | black_non_hispanic | native_american | asian_percent | pacific_islander | other_two_or_more | hispanic | congressional_district | congressional_representative_last_name | congressional_representative_first_name | congressional_representative_party | officer_prosecuted_by | prosecutor_race | prosecutor_gender | chief_prosecutor_political_party | chief_prosecutor_term | officer_prosecuted_by_in_court) | special_prosecutor | independent_investigation | prosecutor_source | killed_by_police_2013_22 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28 | Deshawn Jones | 45 | Male | Black | 22-12-2022 | 500 Mt Vernon Ave | Portsmouth | VA | 23707 | Portsmouth City | Portsmouth Police Department | VA1200000 | Gunshot | Officers responded to a domestic incident in which Deshawn Jones is alleged by police to have stabbed and killed his mother. Six or seven officers demanded Deshawn Jones opened the door. They forcibly entered the house and claim they saw Jones with a knife. They shot and killed him. | Pending investigation | No known charges | https://www.13newsnow.com/article/news/crime/portsmouth-mt-vernon-shooting/291-e80e8fde-2fbc-4832-83e2-4fee02f4b877 | No | Allegedly Armed | knife | attack | brandished weapon | Not Fleeing | No | 8784 | Suburban | 11227 | Part 1 Violent Crime | murder; stabbing | Yes | 210200 | Urban | Large fringe metro (2) | 67196 | 36.846347 | -76.336799 | 1623 | 69% | 19% | 0% | 1% | 0% | 6% | 6% | VA3 | Scott | Robert | 1 |