About this Dataset

Police Data: Computer Aided Dispatch (CAD)

This data set encompasses calls for service from 2017 to present from the City of Somerville's Computer Aided Dispatch (CAD) system. It excludes routine or administrative tasks (like vehicle refueling), community engagement efforts, and other non-call-related activities.

Certain sensitive incidents, such as potential homicides or those requiring investigative follow-up, are omitted. Additionally, some incidents deemed sensitive statutorily or by SPD are included in the data set but stripped of temporal or geographic information in order to protect the privacy of victims.

This data set is refreshed daily with data appearing with a one-month delay (e.g. CAD calls for service 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:07.652276

Tables

Table 1

@usgov.city_of_somerville_police_data_computer_aided_dispatch_cad.table_1

3.72 MB
300,737 rows
10 columns

CREATE TABLE table_1 (
  "incident_number" BIGINT,
  "day_and_month_reported" VARCHAR,
  "year_reported" BIGINT,
  "police_shift" VARCHAR,
  "incident_type_code" VARCHAR,
  "incident_type" VARCHAR,
  "incident_description" VARCHAR,
  "incident_example" VARCHAR,
  "block_code" DOUBLE,
  "ward" DOUBLE
);