About this Dataset

Police Department Reported Victim And Suspect Demographic Data

A. SUMMARY This dataset provides aggregated counts of victims and suspects involved in crimes that fall under San Francisco’s mandated crime reporting categories, as recorded by the San Francisco Police Department (SFPD). The data is sourced from Crime Data Warehouse (CDW), which has been in operation since January 1, 2013. Because CDW was implemented on that date, data prior to 2013 is incomplete or unavailable. To protect the privacy and safety of vulnerable individuals, the dataset is aggregated and does not contain any personally identifiable information or individual case records. Crime categories are organized using: - San Francisco’s 96A.5 “Quarterly Crime Victim Data Reporting”, legislated for victim demographic reporting (Definitions of crime types can be found in Chapter 96A.1) - FBI Uniform Crime Reporting (UCR) system (Definitions can be found on the SFPD website.) This dataset also powers the public crime dashboards on the SFPD website, where users can explore summary statistics. B. HOW THE DATASET IS CREATED Data is added to open data once a quarter after extraction, transformation, and aggregation. Disclaimer : The San Francisco Police Department does not guarantee the accuracy, completeness, timeliness or correct sequencing of the information as the data is subject to change as modifications and updates are completed. C. UPDATE PROCESS Information is updated on a quarterly basis. D. HOW TO USE THIS DATASET This dataset provides aggregated counts of individuals involved in reported crimes, categorized by key demographics and crime-related attributes. It is used to power public-facing dashboards on the San Francisco Police Department (SFPD) website, where summary statistics and visualizations allow users to explore crime and victimization trends across the city. While the SFPD public dashboard provides many useful summaries and visualizations, not all data details are displayed there. For deeper or custom analysis, the full dataset can be downloaded for personal use.
Organization: City of San Francisco
Last updated: 2025-10-25T22:07:55.824226

Tables

Table 1

@usgov.city_of_san_francisco_police_department_reported_victi_d5835c80.table_1

1.12 MB
290,719 rows
14 columns

CREATE TABLE table_1 (
  "quarter_year" VARCHAR,
  "person_crime_category" VARCHAR,
  "age_range" VARCHAR,
  "district" VARCHAR,
  "district_description" VARCHAR,
  "person_race_description" VARCHAR,
  "person_sex_description" VARCHAR,
  "person_type" VARCHAR,
  "person_count" BIGINT,
  "mostseriousbias" VARCHAR,
  "mostseriousbiastype" VARCHAR,
  "ucr_report_type" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR
);