crash_reports
1 row where date = "2019-04-27" and keywords contains "Walk"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-04-27
Time:
09:41
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator was travelling on the Boylston St W/B off ramp at the Chestnut St intersection. #1 front seat passenger spoke for #1 operator who spoke limited English. #1 passenger stated #1 operator came to a stop at the posted stop sign, prior to attempting to cut straight across the intersection further W/B on the ramp. After stopping, #1 proceeded straight ahead into the intersection and collided with Mv#2 which was travelling straight ahead on Chestnut St. #1 driver's side front struck #2 passenger side front. No injuries. #1 appeared to sustain moderate damage and did not require towing. #2 stated he was travelling straight ahead on Chestnut St N/B (right of way). #2 stated he was travelling at a low speed. #2 stated when he arrived at the off ramp intersection, #1 drove out straight ahead from his right and crashed into his passenger side front. No injuries. #2 appeared to sustain moderate damage, was leaking fluids and required towing. Tody's towed #2 to their storage yard without incident. Witness was walking on the Chestnut St sidewalk. Witness stated he observed #1 edging out (stop and go fashion) into the intersection before he observed #1 fully proceed forward colliding with #2.
Keywords:
Crash, Moderate, Speed, Walk
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);