About this Dataset

SPD Crime Data: 2008-Present

Some location data has a data quality issue and has temporarily removed while we resolve the issue. WE will work on making it available as the highest priority. The Seattle Police Department (SPD) replaced its Records Management System (RMS) in May 2019. To preserve data quality and continuity between systems (2008-Present), SPD relied on the National Incident-Based Reporting System (NIBRS). The standardization of crime classifications allows for comparison over time. For more information on definitions and classifications, please visit https://www.fbi.gov/services/cjis/ucr/nibrs. Additional groupings are used to analyze crime in SPD’s Crime Dashboard. Violent and property crime categories align with best practices. For additional inquiries, we encourage the use of the underline data to align with the corresponding query. Disclaimer: Only finalized (UCR approved) reports are released. Those in draft, awaiting approval, or completed after the update, will not appear until the subsequent day(s). Data is updated once every twenty-four hours. Records and classification changes will occur as a report makes its way through the approval and investigative process.
Organization: City of Seattle
Last updated: 2024-12-16T22:33:22.013950
Tags: beat, crime, data-driven, mcpp, nibrs, offenses, seastat

Tables

Table 1

@usgov.city_of_seattle_spd_crime_data_2008_present_c0edb.table_1

62.81 MB
1449929 rows
19 columns


CREATE TABLE table_1 (
  "report_number" VARCHAR,
  "report_datetime" VARCHAR,
  "offense_id" BIGINT,
  "offense_date" VARCHAR,
  "nibrs_group_ab" VARCHAR,
  "nibrs_crime_against_category" VARCHAR,
  "offense_sub_category" VARCHAR,
  "shooting_type_group" VARCHAR,
  "block_address" VARCHAR,
  "latitude" VARCHAR,
  "longitude" VARCHAR,
  "beat" VARCHAR,
  "precinct" VARCHAR,
  "sector" VARCHAR,
  "neighborhood" VARCHAR,
  "reporting_area" VARCHAR,
  "offense_category" VARCHAR,
  "nibrs_offense_code_description" VARCHAR,
  "nibrs_offense_code" VARCHAR
);