crash_reports
2 rows where dcc = "["Signs/Signals", "Reckless driving"]", intersection = 0 and "retrieved" is on date 2020-10-07
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-29
Time:
15:30
Address:
1000 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV1 was travelling behind MV2 when he attempted to pass her in a no passing zone. As he attempted to cross back to the correct side of the road MV1 made contact with the front drivers side of MV2. MV2 was travelling WB on Commonwealth ave when MV1 attempted to pass her and she was struck as he entered back into her lane. Operator 1 states operator 2 was making obscene gestures at him and he was attempting to separate himself from the situation and that is why he attempted to pass where it was illegal. Operator 2 states MV1 was tailgating her for approximately 3 blocks when she threw her hands up in the air and he then attempted to pass her. MV1 sustained minor rear end damage. MV2 sustained moderate front end damage. Both vehicles driven from the scene and no injuries were reported. Operator 1 issued MA Uniform Citation #T1445050 for marked lane violation.
Keywords:
Citation, Moderate
Dcc:
Signs/Signals, Reckless driving
Report
url:
Image
url:
Latitude:
42.3374309
Longitude:
-71.2088565
Location:
Case
number:
Date:
2019-12-13
Time:
23:17
Address:
12 KAPPIUS PATH
Speed
limit:
5
Violation
cited:
yes
Narrative:
Operator of Vehicle #1 was traveling on Saw Mill Brook Parkway before turning right over a curb and onto Kappius Path. Kappius Path is a walking path not intended for vehicle traffic. While traveling on Kappius Path the operator struck a tree with the driver's side front of the vehicle. The vehicle then rolled onto the passenger side. In order to extract both occupants of the vehicle, Newton Firefighters used the Jaws of Life to remove the roof of the vehicle. Firefighters also had to remove several sections of a chain link fence belonging to the property owner of 19 Kappius Path. Newton Medics obtained patient refusals from both occupants. No injuries were reported. The vehicle was towed from the scene by Todys and an inventory sheet was completed by Officer Emmanuel. Five photographs of the scene were submitted to the IT Bureau. The operator of Vehicle #1 was subsequently arrested and charged with OUI, Negligent Operation and Marked Lanes.
Keywords:
Fire, Pictures, Tree, Walk
Dcc:
Signs/Signals, Reckless driving
Report
url:
Image
url:
Latitude:
42.2904813
Longitude:
-71.1856739
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);