killings: 17
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17 | Enrique Lopez | Unknown | Male | Hispanic | 28-12-2022 | Birchwood Rd | Medford | NY | 11763 | Suffolk | Suffolk County Police Department | NY0510100 | Gunshot | Officers responded to a 911 call and at some point when officers were on the scene, the alleged man stabbed two of them. The man was then shot and killed. | Pending investigation | No known charges | https://www.newsday.com/beta/long-island/suffolk/suffolk-police-officers-stabbed-l5ofcj4g | No | Allegedly armed | knife | attack | used weapon | Not Fleeing | No | 8774 | Suburban | 11240 | Domestic disturbance | domestic disturbance | Yes | 158711 | Suburban | Large fringe metro (2) | 72308 | 40.840257 | -72.999203 | 1622 | 91% | 3% | 0% | 1% | 0% | 0% | 5% | NY1 | Zeldin | Lee | 1 |