About this Dataset

Motor Vehicle Crash Reports (2010-2018)

NOTE: Post-2018 crash data is available here: https://data.somervillema.gov/Public-Safety/Police-Data-Crashes/mtik-28va/about_data

This data set tracks motor vehicle crashes within the City of Somerville from 1/1/2010 through 4/30/2018. This data was created by OSPCD in collaboration with the Somerville Police Department.
Organization: City of Somerville
Last updated: 2020-11-10T16:58:50.580537
Tags: bicycle, bike, crash, motor-vehicle, pedestrian, public-safety

Tables

Table 1

@usgov.city_of_somerville_motor_vehicle_crash_reports.table_1

163.64 kB
4,059 rows
89 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "location" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "weather_2_3" VARCHAR  -- Weather (2&3),
  "road_surface_6" VARCHAR  -- Road Surface (6),
  "traffic_control_device_4" VARCHAR  -- Traffic Control Device (4),
  "intersection_type_7" VARCHAR  -- Intersection Type (7),
  "traffic_way_desc_8" VARCHAR  -- Traffic Way Desc (8),
  "collision_manner_11" VARCHAR  -- Collision Manner (11),
  "n__of_involved_vehicles" DOUBLE  -- # Of Involved Vehicles,
  "vehicle1_configuration_21" DOUBLE  -- Vehicle1 Configuration (21),
  "driver1_contrib_code1_25" DOUBLE  -- Driver1 Contrib Code1 (25),
  "driver1_contrib_code2_25" DOUBLE  -- Driver1 Contrib Code2 (25),
  "vehicle2_configuration_21" DOUBLE  -- Vehicle2 Configuration (21),
  "driver2_contrib_code1_25" DOUBLE  -- Driver2 Contrib Code1 (25),
  "driver2_contrib_code2_25" DOUBLE  -- Driver2 Contrib Code2 (25),
  "vehicle3_configuration_21" DOUBLE  -- Vehicle3 Configuration (21),
  "driver3_contrib_code1_25" DOUBLE  -- Driver3 Contrib Code1 (25),
  "driver3_contrib_code2_25" DOUBLE  -- Driver3 Contrib Code2 (25),
  "vehicle4_configuration_21" DOUBLE  -- Vehicle4 Configuration (21),
  "driver4_contrib_code1_25" DOUBLE  -- Driver4 Contrib Code1 (25),
  "driver4_contrib_code2_25" DOUBLE  -- Driver4 Contrib Code2 (25),
  "vehicle5_configuration_21" DOUBLE  -- Vehicle5 Configuration (21),
  "driver5_contrib_code1_25" DOUBLE  -- Driver5 Contrib Code1 (25),
  "driver5_contrib_code2_25" DOUBLE  -- Driver5 Contrib Code2 (25),
  "vehicle6_configuration_21" DOUBLE  -- Vehicle6 Configuration (21),
  "driver6_contrib_code1_25" DOUBLE  -- Driver6 Contrib Code1 (25),
  "driver6_contrib_code2_25" VARCHAR  -- Driver6 Contrib Code2 (25),
  "vehicle7_configuration_21" DOUBLE  -- Vehicle7 Configuration (21),
  "driver7_contrib_code1_25" DOUBLE  -- Driver7 Contrib Code1 (25),
  "driver7_contrib_code2_25" VARCHAR  -- Driver7 Contrib Code2 (25),
  "bicycle" BIGINT,
  "pedestrian" BIGINT,
  "non_mv" BIGINT,
  "non_motorist_location_16" DOUBLE  -- Non-Motorist Location (16),
  "non_motorist_action_15" DOUBLE  -- Non-Motorist Action (15),
  "non_motorist_type" VARCHAR,
  "manner_of_non_motorist_person_collision" DOUBLE  -- Manner Of Non-Motorist (Person) Collision,
  "injury" BIGINT,
  "multiple" DOUBLE,
  "gender1" DOUBLE,
  "age1" DOUBLE,
  "severity1" DOUBLE,
  "hospital1" DOUBLE,
  "gender2" DOUBLE,
  "age2" DOUBLE,
  "severity2" DOUBLE,
  "hospital2" DOUBLE,
  "gender3" DOUBLE,
  "age3" DOUBLE,
  "severity3" DOUBLE,
  "hospital3" DOUBLE,
  "gender4" DOUBLE,
  "age4" DOUBLE,
  "severity4" DOUBLE,
  "hospital4" DOUBLE,
  "gender5" DOUBLE,
  "age5" DOUBLE,
  "severity5" DOUBLE,
  "hospital5" DOUBLE,
  "city_vehicle" DOUBLE  -- City Vehicle?,
  "notes" VARCHAR,
  "column_65" VARCHAR,
  "column_66" VARCHAR,
  "column_67" VARCHAR,
  "column_68" VARCHAR,
  "column_69" VARCHAR,
  "column_70" VARCHAR,
  "column_71" VARCHAR,
  "column_72" VARCHAR,
  "column_73" VARCHAR,
  "column_74" VARCHAR,
  "column_75" VARCHAR,
  "column_76" VARCHAR,
  "column_77" VARCHAR,
  "column_78" VARCHAR,
  "column_79" VARCHAR,
  "column_80" VARCHAR,
  "column_81" VARCHAR,
  "column_82" VARCHAR,
  "column_83" VARCHAR,
  "column_84" VARCHAR,
  "column_85" VARCHAR,
  "column_86" VARCHAR,
  "column_87" VARCHAR,
  "column_88" VARCHAR,
  "column_89" VARCHAR
);