killings: 74
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | John Ray Romero | 58 | Male | Hispanic | 08-12-2022 | 4000 42nd St | San Diego | CA | 92105 | San Diego | San Diego Police Department | CA0371100 | Gunshot | Officers responded to reports of a man with a "gun." The man was ordered by police to drop the object and he refused. He was initially shot with beanbags and attempted to stand up but was still holding the object. He was then shot and killed by officers. He was holding a BB gun. | Pending investigation | No known charges | https://www.sandiegouniontribune.com/news/public-safety/story/2022-12-14/san-diego-police-release-video-of-fatal-shooting-by-officers-in-city-heights | Yes | Unarmed/Did Not Have Actual Weapon | toy weapon | other | brandished weapon | Foot | Yes | 8725 | Urban | 11179 | Person with a weapon | Person with a "weapon" | Gregory Bergman, Jonathan Estrada, Michael Thornton | 1 | Yes | 2202 | Urban | Large central metro (1) | 31518 | 32.749793 | -117.104455 | 2305 | 11% | 4% | 0% | 16% | 0% | 0% | 69% | CA51 | Vargas | Juan | 1 |