About this Dataset

Police Accountability Misconduct Cases And Allegations

A. SUMMARY This dataset contains public information on police misconduct cases split up by unique allegations. This includes case numbers, dates of receipt, incident locations, police districts involved, allegations made, investigation findings, issuance dates of findings, and case closure dates. Its purpose is to enhance transparency and accountability by providing accessible details about alleged misconduct to the public. By offering insights into the scope and outcomes of investigations, it enables citizens to stay informed about incidents in their communities, fostering trust and facilitating discussions on police accountability and reform efforts. Access to this dataset empowers individuals to monitor the progress of cases and engage in constructive dialogue to promote positive change in law enforcement practices. B. HOW THE DATASET IS CREATED The data set is created when a complaint is made to DPA. DPA opens the case and date is developed through out the life of the case. C. UPDATE PROCESS The data is downloaded once a week from DPA’s Case Management System. D. HOW TO USE THIS DATASET The dataset includes information on complaints received and closed in the current calendar year. Some cases will display received dates in previous years due to them being closed out in the current year. E. RELATED DATASETS

Police Accountability Misconduct Cases and Allegations
Organization: City of San Francisco
Last updated: 2025-03-29T16:52:51.828490

Tables

Table 1

@usgov.city_of_san_francisco_police_accountability_misconduct_826cb3a8.table_1

295.97 KB
5510 rows
30 columns


CREATE TABLE table_1 (
  "unique_id" VARCHAR,
  "case_type" VARCHAR,
  "case_number" VARCHAR,
  "complainant_age_group" VARCHAR,
  "ethnicity" VARCHAR,
  "gender" VARCHAR,
  "officer_293_and_public_narrative" VARCHAR,
  "complaint_received_date" TIMESTAMP,
  "findings_issued_date" TIMESTAMP,
  "case_origin" VARCHAR,
  "referral_to_agency_account_name" VARCHAR,
  "referral_from_agency_account_name" VARCHAR,
  "district" VARCHAR,
  "officer_involvement_id" VARCHAR,
  "allegation_id" VARCHAR,
  "allegation_type" VARCHAR,
  "allegation_summary" VARCHAR,
  "allegation_summary_old" VARCHAR,
  "dpa_finding" VARCHAR,
  "open_or_closed_case" VARCHAR,
  "status" VARCHAR,
  "sub_status" VARCHAR,
  "case_length_of_investigation_days" DOUBLE,
  "days_intake_submitted" DOUBLE,
  "incident_location" VARCHAR,
  "analysis_neighborhood" VARCHAR,
  "supervisor_district" DOUBLE,
  "n__point" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);