crash_reports
2 rows where address = "LEWIS TER & NEWTONVILLE AVE" and dcc contains "Signs/Signals"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-01-29
Time:
21:21
Address:
LEWIS TER & NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
Vehicle #1 was traveling west on Newtonville Ave. As Vehicle #1 passed Lewis Terrace Vehicle #2's front driver side end collided with the side of Vehicle #1. Vehicle #2 was traveling south on Lewis Terrace. Vehicle #2 failed to stop at the Stop Sign at Lewis Terrance and Newtonville Ave and attempted to cross the west bound lane of Newtonville ave to make a left turn to go east on Newtonville Ave. Vehicle #2 failed to yield to Vehicle #1 who had the right of way. The driver of Vehicle #2 was cited with MGL 89/9 Stop Sign Violation and MGL 89/8 Fail to Yield to Oncoming Traffic (Citation #T2012618). The Driver Of Vehicle #2 was not injured. The Driver of Vehicle #1 suffered minor non life threatening injuries and was transported to Newton Wellesley Hospital. Vehicle #1 suffered heavy damage to it's passenger side and front end. Vehicle #2 suffered minor damage to it's front end driver side. Both Vehicles were towed by Todys. A towed MV form was completed and filed for both vehicles Photos of the damaged property at #3 Lewis Ter. was photographed and turned into the IT bureau.
Keywords:
Citation, Hospital, Pictures
Dcc:
Signs/Signals, Failed to yield
Report
url:
Image
url:
Latitude:
42.3528551
Longitude:
-71.1966008
Location:
Case
number:
Date:
2021-06-03
Time:
19:50
Address:
LEWIS TER & NEWTONVILLE AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated she was traveling westbound on Newtonville Ave, approaching Lewis Ter when MV2 failed to stop at the stop sign on Lewis Ter. As MV1 was passing Lewis Ter, MV2 pulled onto Newtonville Ave, hitting the passenger side of MV1. MV1 then pulled over immediately after being struck. As MV1 pulled over, MV2 then turned left onto Newtonville Ave and continued eastbound, failing to stop to exchange paperwork. The operator of MV1 stated it was a gold Mercury Sable with tinted windows and front end damage, missing front bumper. Dispatch was updated and notified other units along with State. MV1 sustained significant damage to both the passenger side front and rear doors. The operator of MV1 father arrived and was able to drive the vehicle home. The operator and passenger both declined medical treatment.
Keywords:
[]
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3528551
Longitude:
-71.1966008
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);