crash_reports
2 rows where dcc_code = "[4]" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-21
Time:
17:43
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On December 21, 2020 at approximately 17:43 hours I responded to a two vehicle crash with air bag deployment on Chestnut St. @ Boylston St. Upon arrival all occupents were out of the vehicles and reported no injuries. Operator of MV1 was traveling Northbound on Chestnut St when the operator of MV2 attempted to cross Chestnut St from Boylston St and MV1 struck the passanger side of MV2. The operator of MV2 claimed that he stopped at the stop sign and thought that the roadway was clear to pass but was struck by MV1. MV1 did not have a stop sign at the location of the crash and therefore had the right away. MV1 was towed from the scene by Tody's, MV2 conacted a private tow from the scene.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
Location:
Case
number:
Date:
2020-12-21
Time:
16:48
Address:
HOMER ST & ASHTON AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv 1 stated she was stopped at the stop sign on Ashton Ave. MV 1 was heading southbound and proceeded onto Homer St. to follow through to Pleasant St. Mv1 thought she had enough distance from Mv 2. Mv 1 then got hit on her driver side door by Mv 2. Mv 2 stated she was driving westbound on Homer St. when Mv 1 pulled out too fast from Ashton ave and caused the accident. No injuries were reported. No tows were needed.
Keywords:
Crash
Dcc:
Failed to yield
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);