About this Dataset

Police Data: Crime Reports

This dataset contains crime reports from the City of Somerville Police Department's records management system from 2017 to present. Each data point represents an incident, which may involve multiple offenses (the most severe offense is provided here).

Incidents deemed sensitive by enforcement agencies are included in the data set but are stripped of time or location information to protect the privacy of victims. For these incidents, only the year of the offense is provided.

This data set is refreshed daily with data appearing with a one-month delay (for example, crime reports from 1/1 will appear on 2/1). If a daily update does not refresh, please email data@somervillema.gov.
Organization: City of Somerville
Last updated: 2024-05-10T23:58:00.539563

Tables

Table 1

@usgov.city_of_somerville_police_data_crime_reports.table_1

268.63 kB
19,651 rows
11 columns

CREATE TABLE table_1 (
  "incident_number" BIGINT,
  "day_and_month_reported" VARCHAR,
  "year_reported" BIGINT,
  "police_shift" VARCHAR,
  "offense_code" VARCHAR,
  "offense_type" VARCHAR,
  "offense_definition" VARCHAR,
  "offense_sub_category" VARCHAR,
  "offense_category" VARCHAR,
  "block_code" DOUBLE,
  "ward" VARCHAR
);