killings: 12
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | William Shae McKay | 44 | Male | White | 29-12-2022 | 3900 Golden West Ave | Riverside | CA | 92509 | Riverside | Riverside County Sheriff's Department | CA0330000 | Gunshot | A man allegedly shot a law enforcement officer, leading to a manhunt and pursuit that ended with the man allegedly shooting at deputies and being shot and killed. | Pending investigation | No known charges | https://ktla.com/news/local-news/riverside-county-sheriffs-deputy-shot-in-jurupa-valley/ | No | Allegedly armed | gun | attack | used weapon | Car | No | 8771 | Suburban | 11267 | Part 1 Violent Crime | murder | Yes | Large central metro (1) | 1 |