Dark Mode
Geocoded San Francisco Crime Data since 2018
Public Safety & Security
Tags and Keywords
Trusted By
"No reviews yet"
Free
About
Provides access to the San Francisco Police Department’s (SFPD) official incident reports, spanning from 2018 to the present day. The data offers detailed records of incidents, including temporal, geographic, and categorisation details, serving as a primary source for analysing public safety trends and activities within the city. This data product is updated daily, ensuring timeliness for users tracking ongoing events.
Columns
The dataset features 34 unique columns, documenting various aspects of each incident report:
- Incident Datetime, Incident Date, Incident Time, Incident Year, Incident Day of Week: Temporal details of when the incident occurred.
- Report Datetime: The date and time when the report was officially filed.
- Row ID, Incident ID, Incident Number: Unique identifiers for rows and reports. The Incident Number is used for referencing cases and report documents.
- CAD Number: Identifier assigned by the Computer Aided Dispatch (CAD) system; note that not all incidents (such as those filed online via Coplogic) will have a CAD Number.
- Report Type Code, Report Type Description: System codes and corresponding descriptions (e.g., Initial, Initial Supplement, Coplogic Initial).
- Filed Online: Indicates whether the report was filed online (TRUE or blank).
- Incident Code, Incident Category, Incident Subcategory, Incident Description: Detailed classification system for the type of incident recorded. Larceny Theft is the most frequent category.
- Resolution: Status of the case, such as 'Open or Active', 'Cite or Arrest Adult', or 'Unfounded'.
- Intersection, CNN: Location information using street intersections (separated by a backward slash) and a unique intersection identifier (CNN).
- Police District, Analysis Neighborhood, Supervisor District: Geographical demarcation fields used for identifying the location within the city's administrative boundaries.
- Latitude, Longitude, Point: Geolocation coordinates (WGS84 format) for spatial analysis.
Distribution
This product contains over 500,000 records, specifically totalling approximately 796,000 valid rows based on time series counts. It is structured with 34 columns and is typically available in CSV format. The estimated size of the data file is 292.15 MB. The data is expected to update on a daily basis.
Usage
This data is ideal for:
- Urban planners and policymakers conducting analyses of public safety and identifying patterns in San Francisco.
- Researchers and journalists studying historical crime trends and geographical incident distributions spanning from 2018 onwards.
- Data scientists building models based on law enforcement activity, temporal patterns, and resolution rates.
- Criminologists examining correlations between incident type and specific Police or Supervisor Districts.
Coverage
Geographic Scope: Focused entirely on the city of San Francisco, California, with detailed location fields specifying Police Districts (11 unique districts) and Analysis Neighborhoods (42 unique neighborhoods).
Time Range: The dataset covers incidents from January 2018 up to the present date (as of late November 2023).
Frequency Notes: Data collection is continuous and updated daily. The most frequent days for incidents are Friday and Wednesday.
License
Attribution 4.0 International (CC BY 4.0)
Who Can Use It
- Government Agencies: For operational planning, resource allocation, and public safety initiatives.
- Academic Researchers: To model crime statistics, spatial clustering, and resolution rates.
- Data Scientists/Analysts: For time-series analysis on incident frequency and geographical visualisations.
Dataset Name Suggestions
- San Francisco Police Incident Reports (2018-Present)
- SFPD Daily Incident Logs
- Geocoded San Francisco Crime Data since 2018
Attributes
Original Data Source: Geocoded San Francisco Crime Data since 2018
QUALITYLoading...