About this Dataset

Police Data: Crashes

This data set contains Somerville crashes that occurred from May 2018 to present. Crash reports are completed when a motor vehicle crash occurs on a public way and involves at least one of the following: Any person is killed, any person is injured, or damage is in excess of $1,000 to any one vehicle or other property. Data does not include crashes that are under active investigation, nor those that occur on state roads, which are under the jurisdiction of the Massachusetts State Police. State crash data may be accessed on the Massachusetts Department of Transportation’s crash data portal, IMPACT.

This data set should be refreshed daily with data appearing with a one-month delay (e.g. crashes that occurred 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.690247

Tables

Table 1

@usgov.city_of_somerville_police_data_crashes.table_1

146.23 kB
2,951 rows
35 columns

CREATE TABLE table_1 (
  "crash_number" BIGINT,
  "date_and_time_of_crash" TIMESTAMP,
  "police_shift" VARCHAR,
  "crash_location" VARCHAR,
  "light_conditions" VARCHAR,
  "weather_conditions" VARCHAR,
  "road_surface" VARCHAR,
  "road_contributing_circumstances" VARCHAR,
  "traffic_control_device_type" VARCHAR,
  "roadway_intersection_type" VARCHAR,
  "trafficway_description" VARCHAR,
  "manner_of_collision" VARCHAR,
  "first_harmful_event" VARCHAR,
  "first_harmful_event_location" VARCHAR,
  "speed_limit" VARCHAR,
  "work_zone" VARCHAR,
  "count_fatal_injury" BIGINT,
  "count_suspected_serious_injury" BIGINT,
  "count_suspected_minor_injury" BIGINT,
  "count_possible_injury" BIGINT,
  "count_no_apparent_injury" BIGINT,
  "count_unknown_injury" BIGINT,
  "count_not_reported_injury" BIGINT,
  "total_non_motorists" BIGINT,
  "pedestrian_involvement_non_motorist" BIGINT  -- Pedestrian Involvement (Non-Motorist),
  "cyclist_involvement_non_motorist" BIGINT  -- Cyclist Involvement (Non-Motorist),
  "other_non_motorist_involvement" BIGINT,
  "non_motorist_location" VARCHAR,
  "non_motorist_action" VARCHAR,
  "non_motorist_condition" VARCHAR,
  "hit_and_run_flag" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "ward" DOUBLE,
  "block_code" BIGINT
);