SPD Officer Involved Shooting (OIS) Data
City of Seattle
@usgov.city_of_seattle_spd_officer_involved_shooting_ois_data_65553
City of Seattle
@usgov.city_of_seattle_spd_officer_involved_shooting_ois_data_65553
Records of Officer Involved Shootings (OIS) from 2005 to the present, including a brief narrative synopsis. Beginning in Q3 2023, the summary will be replaced with a link to the FRB findings documented, prepared for public release. A link for each OIS will be embedded in the file. Data set does not contain records from active investigations. Data is visualized in a dashboard on the SPD public site (https://www.seattle.gov/police/information-and-data/use-of-force-data/officer-involved-shootings-dashboard), please reference as a guide for use. Dashboard is available for download.
Updates are posted twice a year (January and July), as cases complete the inquest process (https://kingcounty.gov/services/inquest-program.aspx).
Use of force data also available here: https://data.seattle.gov/Public-Safety/Use-Of-Force/ppi5-g2bj and is updated daily. Data includes Type III - OIS.
Organization: City of Seattle
Last updated: 2024-12-16T22:30:03.174018
Tags: officer-involved-shooting, ois, police, use-of-force
CREATE TABLE table_1 (
"frb" VARCHAR -- FRB #,
"incident_number" BIGINT,
"date_time" VARCHAR -- Date / Time,
"blurred_address" VARCHAR,
"longitude" DOUBLE,
"latitude" DOUBLE,
"city" VARCHAR,
"state" VARCHAR,
"rank" VARCHAR,
"officer_gender" VARCHAR,
"officer_race" VARCHAR,
"years_of_spd_service" VARCHAR,
"officer_injured" VARCHAR,
"number_of_rounds" VARCHAR,
"subject_gender" VARCHAR,
"subject_race" VARCHAR,
"subject_dob" VARCHAR,
"subject_age" VARCHAR,
"subject_weapon" VARCHAR,
"type_of_weapon" VARCHAR,
"fatal" VARCHAR,
"on_duty" VARCHAR,
"disposition" VARCHAR,
"officer_disciplined" VARCHAR -- Officer Disciplined?,
"summary" VARCHAR
);Anyone who has the link will be able to view this.