crash_reports
3 rows where address = "2102 COMMONWEALTH AVE" and dcc contains "Failed to yield"
This data as json, CSV (advanced)
Suggested facets: street1, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-14
Time:
10:52
Address:
2102 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling east on Commonwealth Ave in the left hand lane when MV#2 emerged from parking area at #2102 Comm Ave into her travel lane and crash occurred. MV#2 was attempting to make a left hand turn onto Comm Ave west bound. The operator of MV#2 stated that he was attempting to exit the parking area at #2102 Comm Ave when the traffic in the right hand lane on Comm Ave east bound had stopped to allow him to enter. MV#2 the entered the left hand lane of Comm Ave east bound and crash occurred with MV#1. No injuries, air bags deployed in MV#1 and both MV's towed by Tody's.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477264
Longitude:
-71.2477463
Location:
Case
number:
Date:
2019-08-14
Time:
09:26
Address:
2102 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated that she was traveling east (left lane) on Commonwealth Ave when MV#2 entered her travel lane from #2102 Comm. Ave and crash occurred. The operator of MV#2 stated that he was attempting to enter Commonwealth Ave (west bound) from #2102 Commonwealth Ave and the MV in the right hand lane had stopped to allow him to enter when crash occurred with MV#1. No injuries, no tows.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477264
Longitude:
-71.2477463
Location:
Case
number:
Date:
2019-12-10
Time:
10:36
Address:
2102 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/10/2019 at approx 1036hrs while assigned to 497 i responded to the area of 2102 Commonwealth Av for a report of a 2 car crash. upon arrival I observed Ma Reg V10183 a red Ford F150 pick up with front plow partially on the curb blocking the EB lane of Commonwealth Ave and Ma Reg 8PE124 a black Ford Focus pulled off to the side WB with extensive front end damage. I spoke with the operator of the pick up, Leonardo TAPIA who stated he had been travelling WB on Commonwealth Av when the Ford Focus pulled out in front of him causing the collision. I spoke to the operator of the Ford Focus John KELLY who stated he was taking a left out of the parking lot of 2102 Commonwealth Av, traffic in the EB lanes stopped to let him out, as he was entering the WB lane he collided with the pick up. Ford Focus towed by Todys, both operators signed refusals with Cataldo.
Keywords:
Crash, Severe
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477264
Longitude:
-71.2477463
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);