Police Department Incident Reports: Historical 2003 To May 2018 by US Government | Demographics and Population Studies

About this Dataset

Police Department Incident Reports: Historical 2003 To May 2018

For up to date data starting in 2018, please go to the new dataset at: https://data.sfgov.org/d/wg3w-h783

As of May 2018, the feed from the legacy mainframe CABLE was discontinued. It was extremely prone to issues and caused many delays in data accessibility. The new dataset linked above comes from the Crime Data Warehouse, a more reliable data system maintained by the Police Department.

This data will undergo a minor update to conform more closely to the schema of the new dataset. We will post a change notice when that work is planned. This change will not include adding new fields or backfilling data. It is provided as is. We are keeping data from the two systems separate to make it transparent to data users that there were fundamental changes.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:55.948475
Tags: crime, crime-reports, police-department, sfpd

Tables

Table 1

@usgov.city_of_san_francisco_police_department_incident_repor_919b9112.table_1

98.72 MB
2073322 rows
36 columns


CREATE TABLE table_1 (
  "pdid" BIGINT,
  "incidntnum" BIGINT,
  "incident_code" BIGINT,
  "category" VARCHAR,
  "descript" VARCHAR,
  "dayofweek" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "pddistrict" VARCHAR,
  "resolution" VARCHAR,
  "address" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "location" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods_2_2" DOUBLE,
  "current_police_districts_2_2" DOUBLE,
  "current_supervisor_districts_2_2" DOUBLE,
  "analysis_neighborhoods_2_2" DOUBLE,
  "delete_fire_prevention_districts_2_2" DOUBLE,
  "delete_police_districts_2_2" DOUBLE,
  "delete_supervisor_districts_2_2" DOUBLE,
  "delete_zip_codes_2_2" DOUBLE,
  "delete_neighborhoods_2_2" DOUBLE,
  "delete_2017_fix_it_zones_2_2" DOUBLE,
  "civic_center_harm_reduction_project_boundary_2_2" DOUBLE,
  "fix_it_zones_as_of_2017_11_06_2_2" DOUBLE,
  "delete_hsoc_zones_2_2" DOUBLE,
  "fix_it_zones_as_of_2018_02_07_2_2" DOUBLE,
  "cbd_bid_and_gbd_boundaries_as_of_2017_2_2" DOUBLE,
  "areas_of_vulnerability_2016_2_2" DOUBLE,
  "central_market_tenderloin_boundary_2_2" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated_2_2" DOUBLE,
  "hsoc_zones_as_of_2018_06_05_2_2" DOUBLE,
  "owed_public_spaces_2_2" DOUBLE,
  "neighborhoods_2" DOUBLE
);