crash_reports
2 rows where "datetime" is on date 2019-07-25 and intersection = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-25
Time:
10:28
Address:
CENTRE ST & BOYLSTON ST OFF RAMP (WB)
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/25/19 at 10:28 hours, I responded to Centre Street and Boylston St off ramp (WB) for a two car motor vehicle accident with no injuries reported. Operator of MV1 states he was traveling straight ahead on Centre Street (NB) when he observed MV2 inching out of the Boylston Street off ramp. He was not able to stop in time and the two vehicles struck one another. I observed heavy damage to the passenger front bumper and tire area and the vehicle was towed by Tody's. Operator of MV2 states he was exiting the Boylston Street off ramp (WB) and was going to attempt a left turn on to Centre Street after stopping for the stop sign. He then slowly pulled out into the intersection due to National Grid trucks blocking his view and that is when he came in contact with MV1 on his driver's side front bumper. I observed moderate damage to the entire front bumper but the vehicle was still driveable. I did observe National Grid trucks parked at the intersection setting up to do construction work. One truck was parked on the left side of the off ramp and the other was parked on the side where the crash occurred. This did obstruct the operator of MV2's view when pulling out.
Keywords:
Crash, Moderate
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3194198
Longitude:
-71.2057176
Location:
Case
number:
Date:
2019-07-25
Time:
16:41
Address:
ASHTON AVE & HOMER STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated she was traveling West on Homer Street about to cross over the intersection of Ashton Ave when all of the sudden vehicle 2 was crossing over Homer Street right in front of her. It was too late to stop and she crashed into vehicle 2. The passenger stated the same. The operator of Vehicle 2 stated he was driving North on Pleasant Street, came to a stop and proceeded to cross over Homer Street headed to Ashton Ave. He stated it looked safe to cross over and while he was crossing vehicle 1 came from his right side at a high rate of speed and crashed into his passenger side door. All parties either signed medical refusals or were cleared by cataldo medics. Both vehicles were towed by Todys.
Keywords:
Crash, Speed
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3349479
Longitude:
-71.2016431
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);

