About this Dataset

Sheriff's Inspector General Cases And Resolutions

A. SUMMARY This dataset contains public information on sheriff misconduct cases split up by unique allegations. This includes case numbers, dates of receipt, 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. B. HOW THE DATASET IS CREATED The data set is created when a complaint is made to the Office of Sheriff’s Inspector General (OSIG). OSIG 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 OSIG’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:59:37.002331

Tables

Table 1

@usgov.city_of_san_francisco_sheriffs_inspector_general_cases_678e7ad7.table_1

21.94 KB
11 rows
26 columns


CREATE TABLE table_1 (
  "unique_id" VARCHAR,
  "case_type" VARCHAR,
  "case_number" VARCHAR,
  "complainant_age_group" VARCHAR,
  "ethnicity" VARCHAR,
  "gender" VARCHAR,
  "deputy_293_and_public_narrative" VARCHAR,
  "complaint_received_date" VARCHAR,
  "findings_issued_date" VARCHAR,
  "case_origin" VARCHAR,
  "referral_to_agency_account_name" VARCHAR,
  "referral_from_agency_account_name" VARCHAR,
  "deputy_involvement_id" VARCHAR,
  "allegation_id" VARCHAR,
  "allegation_type" VARCHAR,
  "allegation_summary" VARCHAR,
  "allegation_summary_old" VARCHAR,
  "sig_finding" VARCHAR,
  "open_or_closed_case" VARCHAR,
  "status" VARCHAR,
  "sub_status" VARCHAR,
  "days_intake_submitted" DOUBLE,
  "case_length_of_investigation_days" DOUBLE,
  "location_of_incident" VARCHAR,
  "data_as_of" TIMESTAMP,
  "data_loaded_at" VARCHAR
);