About this Dataset

Office Of Police Accountability Complaints

This dataset represents complaints against employees of the Seattle Police Department (SPD). The data is pulled from dynamic, live databases and is subject to change. Each row represents an individual allegation of misconduct from a Complainant against an individual SPD employee. A single OPA case may contain one or more Complainant(s), Named Employee(s), and Allegation(s) against each Named Employee. Data is denormalized to represent the one-to-many relationship between the Complaint and all the associated allegations. USE CAUTION WHEN COUNTING
Organization: City of Seattle
Last updated: 2024-12-16T22:28:05.340522
Tags: complaints, office-of-police-accountability, office-of-police-accountability-complaints, opa, police, spd

Tables

Table 1

@usgov.city_of_seattle_office_of_police_accountability_compla_81be8c00.table_1

1.34 MB
34687 rows
21 columns


CREATE TABLE table_1 (
  "unique_id" VARCHAR,
  "file_number" VARCHAR,
  "incident_number" BIGINT,
  "occurred_date" VARCHAR,
  "received_date" VARCHAR,
  "incident_precinct" VARCHAR,
  "incident_sector" VARCHAR,
  "incident_beat" VARCHAR,
  "source" VARCHAR,
  "incident_type" VARCHAR,
  "allegation" VARCHAR,
  "disposition" VARCHAR,
  "discipline" VARCHAR,
  "complainant_number" BIGINT,
  "complainant_gender" VARCHAR,
  "complainant_race" VARCHAR,
  "complainant_age_complaint" BIGINT,
  "case_status" VARCHAR,
  "finding" VARCHAR,
  "investigation_begin_date" VARCHAR,
  "investigation_end_date" VARCHAR
);