crash_reports
1 row where "datetime" is on date 2019-04-08, dcc = "["Failed to yield"]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2019-04-08
Time:
13:06
Address:
1255 CENTRE STREET
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 (Ma reg CHE1) stated he was traveling SB on Centre Street approaching the intersection of Beacon St when his vehicle was struck on the driver's side door. Operator of MV1 stated he was in the second line when a MV from the left side entered into his lane hitting his running board. Operator of MV1 stated he never saw this vehicle attempting to enter into his lane. Operator of MV2 (Ma reg 6pw879) stated she was traveling SB on Centre Street approaching the intersection of Beacon St when she attempted to enter into the adjacent lane. Operator of MV2 stated she put on her right blinker and attempted to enter the lane to the left. Operator of MV2 front passenger side bumper struck MV1's driver's side running board. There was very minor damage to the running board on MV1. MV2 had more significant damage to the front bumper area. Both parties stated they were not injured at this time. Both vehicles were able to operate without any incidents.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3304655
Longitude:
-71.1950492
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);