Others titles
- Crimes in San Francisco in 2020
- All Reported Incidents in San Francisco
Keywords
- San Francisco Crimes
- San Francisco Incidents
- Incidents of Crime
- Crime Victims
- Criminal Offenses
- Offenses
- Police Incidents
- San Francisco Offenses
SFPD Incident Report
This dataset includes police incident reports filed by officers and by individuals through self-service online reporting for non-emergency cases. Reports included are those for incidents that occurred starting January 1, 2018 onward and have been approved by a supervising officer.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
Incident reports filed by officers are approved by a supervising officer. Once approved and electronically signed by a Sergeant or Lieutenant, no further information is added to the initial report. A supplemental report for additional information or clarification is generated if necessary.
Reports can come from one of three sources. These are discernable through the “Report Type Description” and “Report Type Code” field:
1. Initial: The first report filed for the incident
2. Vehicle: A special incident report related to stolen and/or recovered vehicles
3. Coplogic: Filed online by an individual
Incidents can have one or many associated Incident Codes. For example, an officer may have a warrant for an arrest and while making the arrest discovers narcotics in the individual’s possession. The officer will record an incident code for the warrant as well as the discovery of narcotics.
Coordinates are provided within the dataset where feasible. Coordinates could be missing for the following reasons:
1. Invalid addresses – addresses submitted by officers pass through validation, however, the online submission does not validate addresses on entry. While best efforts are made to match those to valid addresses when loading to the Crime Data Warehouse, there are still technical limitations to fixing all poorly formed addresses.
2. Addresses for incidents outside of SF – some cases are referred from outside San Francisco Police Department (SFPD) districts, these will be marked as Out of SF in the Police District column and not have associated geographic information.
About this Dataset
Data Info
Date Created | 2018-09-06 |
---|---|
Last Modified | 2024-02-10 |
Version | 2024-02-10 |
Update Frequency |
Quarterly |
Temporal Coverage |
2018-2024 |
Spatial Coverage |
San Francisco |
Source | John Snow Labs; San Francisco Police Department; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | San Francisco Crimes, San Francisco Incidents, Incidents of Crime, Crime Victims, Criminal Offenses, Offenses, Police Incidents, San Francisco Offenses |
Other Titles | Crimes in San Francisco in 2020, All Reported Incidents in San Francisco |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Incident_Date_Time | The date and time when the incident occurred | datetime | - |
Incident_Day | The day of the week incident occurred | string | - |
Report_Date_Time | Distinct from Incident_Date_Time, Report_Date_Time is when the report was filed. | datetime | - |
Incident_ID | This is the system generated identifier for incident reports. An incident report can have multiple incident codes associated. Thus, this identifier, while unique to the report, will be duplicated within this dataset to represent those 1 to many relationships when they exist. Incident IDs and Incident Numbers both uniquely identify reports, but Incident Numbers are what are used and referenced in the cases and report documents. | integer | level : Nominal |
Incident_Number | The number issued on the report, sometimes interchangeably referred to as the Case Number | integer | level : Nominal |
CAD_Number | The Computer Aided Dispatch is the system used by the Department of Emergency Management (DEM) to dispatch officers and other public safety personnel. CAD Numbers are assigned by the DEM system and linked to relevant incident reports (Incident Number). Not all Incidents will have a CAD Number. Reports filed online via Coplogic (see field: Filed Online) will not have a CAD Number and certain other reports not filed through the DEM system will also not have these numbers. | integer | level : Nominal |
Report_Type_Code | A system code for report types, these have corresponding descriptions within the dataset. | string | - |
Report_Type_Description | The description of the report type can be one of Initial: Initial; Initial Supplement; Vehicle Initial; Vehicle Supplement; Coplogic Initial; Coplogic Supplement | string | - |
Is_Filed_Online | Police reports filed online for non-emergency cases. | boolean | - |
Incident_Code | Incident Codes are the system codes to describe a type of incident. A single incident report can have one or many incident types associated. In those cases you will see multiple rows representing a unique combination of the Incident ID and Incident Code. | integer | level : Nominal |
Incident_Category | A category mapped on to the Incident Code used in statistics and reporting. Mappings provided by the Crime Analysis Unit of the Police Department. | string | - |
Incident_Subcategory | A subcategory mapped on to the Incident Code used in statistics and reporting. These nest inside the Category field. Mappings provided by the Crime Analysis Unit of the Police Department. | string | - |
Incident_Description | The description of the incident that corresponds with the Incident Code. These are generally self-explanatory. | string | - |
Resolution | The resolution of the incident at the time of the report. Can be one of: - Cite or Arrest Adult - Cite or Arrest Juvenile - Exceptional Adult - Exceptional Juvenile - Open or Active - Unfounded Note: once a report is filed the resolution does not change on the filed report later. | string | - |
Intersection | The 2 or more street names that intersect closest to the original incident separated by a forward slash (). Note, the possible intersections will only include those that satisfy the privacy controls. | string | - |
Centerline_Node_Network | The unique identifier of the intersection for reference back to other related basemap datasets. | string | - |
Police_District | The Police District reflecting current boundaries (boundaries changed in 2015). | string | - |
Analysis_Neighborhood | The Department of Public Health and the Mayor's Office of Housing and Community Development, with support from the Planning Department, created 41 neighborhoods by grouping 2010 Census tracts, using common real estate and resident definitions for the purpose of providing consistency in the analysis and reporting of socio-economic, demographic, and environmental data, and data on City-funded programs and services. | string | - |
Supervisor_District | There are 11 members elected to the Board of Supervisors in San Francisco, each representing a geographic district. The Board of Supervisors is the legislative body for San Francisco. The districts are numbered 1 through 11. | integer | level : Nominal |
Latitude | The latitude of the location where the incident occurred | number | - |
Longitude | The longitude of the location where the incident occurred | number | - |
Data Preview
Incident Date Time | Incident Day | Report Date Time | Incident ID | Incident Number | CAD Number | Report Type Code | Report Type Description | Is Filed Online | Incident Code | Incident Category | Incident Subcategory | Incident Description | Resolution | Intersection | Centerline Node Network | Police District | Analysis Neighborhood | Supervisor District | Latitude | Longitude |
2021-07-25T00:00:00 | Sunday | 2021-07-25T13:41:00 | 1057189 | 216105573 | II | Coplogic Initial | True | 6372 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, $50-$200 | Open or Active | Southern | |||||||
2022-06-28T23:58:00 | Tuesday | 2022-06-28T23:58:00 | 1165543 | 220264913 | VS | Vehicle Supplement | 71012 | Other Offenses | Other Offenses | License Plate, Recovered | Open or Active | Out of SF | ||||||||
2022-03-11T10:30:00 | Friday | 2022-03-11T20:03:00 | 1130480 | 226040232 | II | Coplogic Initial | True | 71000 | Lost Property | Lost Property | Lost Property | Open or Active | Central | |||||||
2021-05-15T17:47:00 | Saturday | 2021-05-15T17:47:00 | 1030518 | 210183345 | VS | Vehicle Supplement | 7043 | Recovered Vehicle | Recovered Vehicle | Vehicle, Recovered, Motorcycle | Open or Active | Out of SF | ||||||||
2022-06-28T17:22:00 | Tuesday | 2022-06-28T17:22:00 | 1165351 | 220361741 | VS | Vehicle Supplement | 7041 | Recovered Vehicle | Recovered Vehicle | Vehicle, Recovered, Auto | Open or Active | Out of SF | ||||||||
2021-11-18T13:30:00 | Thursday | 2021-11-18T16:24:00 | 1094352 | 216178097 | II | Coplogic Initial | True | 28150 | Malicious Mischief | Vandalism | Malicious Mischief, Vandalism to Property | Open or Active | Mission | |||||||
2022-06-28T14:00:00 | Tuesday | 2022-06-28T15:09:00 | 1165462 | 226109026 | II | Coplogic Initial | True | 6244 | Larceny Theft | Larceny - From Vehicle | Theft, From Locked Vehicle, >$950 | Open or Active | Richmond | |||||||
2022-08-07T22:00:00 | Sunday | 2022-08-16T15:26:00 | 1182772 | 226147327 | II | Coplogic Initial | True | 6374 | Larceny Theft | Larceny Theft - Other | Theft, Other Property, >$950 | Open or Active | Richmond | |||||||
2022-05-04T09:38:00 | Wednesday | 2022-05-04T09:39:00 | 1147129 | 210618041 | VS | Vehicle Supplement | 7041 | Recovered Vehicle | Recovered Vehicle | Vehicle, Recovered, Auto | Open or Active | Out of SF | ||||||||
2018-05-11T17:30:00 | Friday | 2018-05-13T13:50:00 | 669184 | 186110767 | II | Coplogic Initial | True | 71000 | Lost Property | Lost Property | Lost Property | Open or Active | Out of SF |