Historical San Francisco Police Department Incident Reports
Historical San Francisco Police Department Incident Reports
By City & County of San Francisco
San Francisco Police Department reports from 2003 to 2018
Product type
Dataset
Update frequency
Historical
Updated
Aug 17, 2020
Delivery method
Download
Metadata is available for each file version of the dataset. A JSON file can be downloaded once you subscribe to the dataset. The information below is an example of the metadata included in each JSON file.
Dataset file name: Police_Department_Incident_Reports__Historical_2003_to_May_2018.csv
Key Statistics
Total records
2,160,953
Missing values
0.77%
Duplicate rows
0%
Columns
Columns
35
Categorical
3
Numeric
26
Date/time
2
Correlations Correlations are columns within the dataset that have a linear dependency on each other and can be dropped or filtered out when creating models
Correlations
9
Correlated columns
DELETE - HSOC Zones 2 2 and DELETE - Zip Codes 2 2, OWED Public Spaces 2 2 and DELETE - HSOC Zones 2 2, PdId and IncidntNum, Fix It Zones as of 2017-11-06 2 2 and Fix It Zones as of 2018-02-07 2 2, DELETE - Zip Codes 2 2 and HSOC Zones as of 2018-06-05 2 2, DELETE - HSOC Zones 2 2 and HSOC Zones as of 2018-06-05 2 2, Neighborhoods 2 and SF Find Neighborhoods 2 2, Analysis Neighborhoods 2 2 and DELETE - Neighborhoods 2 2, OWED Public Spaces 2 2 and HSOC Zones as of 2018-06-05 2 2
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
Incident Code | numeric | 930 | 0 | 75030 |
PdId | numeric | 2,160,953 | 397963010 | 99158237763010 |
IncidntNum | numeric | 1,717,518 | 3979 | 991582377 |
X | numeric | 12,887 | -122.51364 | -120.5 |
Y | numeric | 17,761 | 37.70788 | 90 |
SF Find Neighborhoods 2 2 | numeric | 117 | 1 | 117 |
Current Police Districts 2 2 | numeric | 10 | 1 | 10 |
Analysis Neighborhoods 2 2 | numeric | 41 | 1 | 41 |
Current Supervisor Districts 2 2 | numeric | 11 | 1 | 11 |
DELETE - Fire Prevention Districts 2 2 | numeric | 15 | 1 | 15 |
DELETE - Supervisor Districts 2 2 | numeric | 11 | 1 | 11 |
DELETE - Police Districts 2 2 | numeric | 10 | 1 | 10 |
DELETE - Zip Codes 2 2 | numeric | 29 | 54 | 29492 |
DELETE - 2017 Fix It Zones 2 2 | numeric | 24 | 1 | 24 |
Civic Center Harm Reduction Project Boundary 2 2 | numeric | 1 | 1 | 1 |
DELETE - Neighborhoods 2 2 | numeric | 41 | 1 | 41 |
DELETE - HSOC Zones 2 2 | numeric | 5 | 1 | 5 |
Fix It Zones as of 2017-11-06 2 2 | numeric | 25 | 1 | 25 |
Fix It Zones as of 2018-02-07 2 2 | numeric | 25 | 1 | 25 |
Central Market/Tenderloin Boundary 2 2 | numeric | 1 | 1 | 1 |
CBD, BID and GBD Boundaries as of 2017 2 2 | numeric | 15 | 1 | 15 |
OWED Public Spaces 2 2 | numeric | 49 | 2 | 80 |
Central Market/Tenderloin Boundary Polygon - Updated 2 2 | numeric | 1 | 1 | 1 |
HSOC Zones as of 2018-06-05 2 2 | numeric | 5 | 1 | 5 |
Neighborhoods 2 | numeric | 117 | 1 | 117 |
Areas of Vulnerability, 2016 2 2 | numeric | 2 | 1 | 2 |
DayOfWeek | categorical | 7 | 6 | 9 |
PdDistrict | categorical | 11 | 3 | 10 |
Resolution | categorical | 12 | 4 | 38 |
Category | text | 38 | 4 | 27 |
Descript | text | 892 | 4 | 73 |
Address | text | 25,127 | 11 | 49 |
location | text | 61,364 | 30 | 46 |
Time | date | 1,439 | 00:01 | 23:59 |
Date | date | 5,613 | 01/01/2003 | 05/12/2018 |