crash_reports
2 rows where dcc contains "Unknown" and "retrieved" is on date 2021-02-22
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-02-15
Time:
11:57
Address:
916 WALNUT ST
Speed
limit:
5
Violation
cited:
no
Narrative:
Mv#1 (tractor trailer) operator stated he had a clear access road in the parking lot as he was backing to make a delivery into the Whole Foods loading dock. #1 further stated before he backed up, he observed Mv#2 off to an adjacent side corner of the parking lot, which left the access road clear leading to the loading dock. #1 stated at that time while he was backing, #2 attempted to pass his trailer on the right. A collision occurred with the passenger side rear trailer and the driver's side front of #2. #2 operator stated he was attempting to exit the parking lot by the access road leading out to Beacon St. #2 further stated he observed the trailer backing up, at which time he stated he came to a complete stop and was honking his horn to alert #1. #2 stated at that time, #1 did not stop and backed into his driver's side front end. #2 sustained moderate damage. #1 sustained no damage to the rear trailer. Observations of Mv positioning on arrival was:the trailer was almost fully in the center of the access road leaving only about a 3 foot opening from the curb on its right. Mv#2 was in the far right lane of the access road. Although #2 reported he came to a complete stop prior to the colllision, it appeared #2 intended to pass and approached too closely to the rear of the trailer to leave enough safe distance between both Mvs.
Keywords:
Moderate
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3300663
Longitude:
-71.2063967
Location:
Case
number:
Date:
2021-02-16
Time:
16:50
Address:
WASHINGTON STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Opr of MV1 stated she was traveling around the rotary eastbound. Opr of MV1 stated she was in the right lane making her way to the Massachusetts Turnpike. At this time, she was passing the off-ramp and made contact with MV2. Opr of MV1 stated she did not know how she hit MV2. MV1 suffered major damage and was towed by Tody's. Opr of MV1 was evaluated and signed a refusal. When I arrived on scene, Opr of MV2 was not there. I spoke to him on the phone. Opr of MV2 stated he traveled off the off-ramp, was traveling straight and at some point was struck on his rear left side of his vehicle. Opr of MV2 stated he was not injured and suffered minor damage on his vehicle.
Keywords:
Phone
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3498391
Longitude:
-71.2179998
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);