San Francisco Police Department Incident Reports
San Francisco Police Department Incident Reports
By City & County of San Francisco
San Francisco Police Department reports from 2018 to present
Product type
Dataset
Update frequency
Daily
Updated
Jun 7, 2023
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__2018_to_Present.csv
Key Statistics
Total records
483,757
Missing values
0.85%
Duplicate rows
0%
Columns
Columns
34
Categorical
4
Numeric
17
Date/time
4
Correlations
Correlations
6
Correlated columns
Incident Number and CAD Number, Incident ID and Incident Number, Row ID and CAD Number, Row ID and Incident ID, Row ID and Incident Number, Incident ID and CAD Number
Column name | Type | Unique values | Min value | Max value |
|---|---|---|---|---|
Incident Year | numeric | 4 | 2018 | 2021 |
Incident ID | numeric | 401,667 | 618687 | 1053579 |
Row ID | numeric | 483,757 | 61868707041 | 105357907021 |
Incident Number | numeric | 348,303 | 0 | 981424262 |
CAD Number | numeric | 187,306 | 1 | 1000000000 |
Incident Code | numeric | 810 | 1000 | 75030 |
CNN | numeric | 6,447 | 20013000 | 54121996 |
Latitude | numeric | 5,721 | 37.70799 | 37.82999 |
Supervisor District | numeric | 11 | 1 | 11 |
Longitude | numeric | 5,298 | -122.51129 | -122.36374 |
Neighborhoods | numeric | 116 | 1 | 117 |
ESNCAG - Boundary File | numeric | 1 | 1 | 1 |
Central Market/Tenderloin Boundary Polygon - Updated | numeric | 1 | 1 | 1 |
Civic Center Harm Reduction Project Boundary | numeric | 1 | 1 | 1 |
HSOC Zones as of 2018-06-05 | numeric | 5 | 1 | 5 |
Current Supervisor Districts | numeric | 11 | 1 | 11 |
Current Police Districts | numeric | 10 | 1 | 10 |
Incident Day of Week | categorical | 7 | 6 | 9 |
Report Type Code | categorical | 4 | 2 | 2 |
Filed Online | categorical | 2 | 3 | 4 |
Police District | categorical | 11 | 4 | 10 |
Report Type Description | text | 6 | 7 | 19 |
Incident Category | text | 50 | 3 | 44 |
Incident Subcategory | text | 72 | 3 | 40 |
Incident Description | text | 807 | 4 | 84 |
Resolution | text | 4 | 9 | 20 |
Intersection | text | 6,360 | 3 | 84 |
Analysis Neighborhood | text | 42 | 3 | 30 |
Point | text | 6,448 | 3 | 46 |
Incident Time | date | 1,440 | 00:00 | 23:59 |
Incident Date | date | 1,301 | 2018/01/01 | 2021/07/12 |
Report Datetime | date | 343,142 | 2018-01-01T00:01:00 | 2021-07-24T22:15:00 |
Incident Datetime | date | 227,077 | 2018-01-01T00:00:00 | 2021-07-24T21:25:00 |