crash_reports
1 row where "datetime" is on date 2019-01-19, dcc = "[]" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-01-19
Time:
18:08
Address:
167 CHERRY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 (MA Reg: 63EP17, a 2000 Acura 32TL; operator: Carlos Standford) was traveling NORTH on Cherry St when a vehicle swirved into his lane head-on. In order to avoid MV3 he swirved into the other lane and side-swiped MV2. MV2 (MA Reg: 9JX388, a 2019 Subaru Outback; operator: James Cant) was traveling SOUTH on Cherry St when he had come to a complete stop, put his left turn signal on to show him turning left into his driveway at 176 Cherry St. He was waiting to make his turn until MV1 had driven past so it was safe to do so. As he was at a complete stop, MV1 collided with his rear driver side bumper in an effort to avoid a head on collision with MV3. MV3 (MA Reg: 93YE85; a 1997 Toyota Camry; operator Matthew Kuniholm) was traveling SOUTH on Cherry St when he had seen MV2 at a complete stop with a turn signal. He didn't give himself enough time to stop, began to slide as he was braking and went over the marked lanes into oncoming traffic in an effort to not collide with MV2. MV3 operator, Matthew Kuniholm, was issued in hand MA Uniform Citation T1440470 for Marked Lane Violation 89/9a. All vehicles were still in driveable condition. MV1 had damage to the front driveside wheel fender and driver door. MV2 had slight damage to rear driver side bumper. MV3 did not have damage to his vehicle. Weather was icy and there was an active snow fall during the time of the accident, which was 1815hrs.
Keywords:
Citation, Crash, Ice, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585592
Longitude:
-71.2273505
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);