About this Dataset

Police Data: Traffic Citations

This complete version of the dataset contains traffic citations issued in Somerville by Somerville police officers since 2017. Citations include both written warnings and those with a monetary fine. Every citation is composed of one or more violations. Each row in the dataset represents a violation.

This data set should be refreshed daily with data appearing with a one-month delay (e.g. citations issued on 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:57:54.269679
Tags: police

Tables

Table 1

@usgov.city_of_somerville_police_data_traffic_citations.table_1

1.33 MB
61994 rows
14 columns


CREATE TABLE table_1 (
  "citation_number" VARCHAR,
  "date_and_time_issued" TIMESTAMP,
  "police_shift" VARCHAR,
  "address_of_violation" VARCHAR,
  "violation_code" VARCHAR,
  "violation_description" VARCHAR,
  "vehicle_mph" DOUBLE,
  "mph_zone" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "block_code" BIGINT,
  "ward" DOUBLE,
  "violation_category" VARCHAR,
  "warning_flag" VARCHAR
);