crash_reports
2 rows where dcc = "["Improper turn", "Unknown"]" and intersection = 1
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-09-25
Time:
11:51
Address:
CHASE ST & RIPLEY ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated he was travelling on Chase St E/B and then turned right onto Ripley St making a U-turn reversing his direction intending to turn left back onto Ripley St W/B. As #1 was making the U-turn, #1 struck the passenger side rear end side of Mv#2. Mv#2 operator stated he was travelling on Chase St E/B behind #1. #2 stated #1 suddenly turned right onto Ripley St making a U-turn, then struck #2 passenger rear end side as #2 was passing by. The impact pushed #2 sideways and #2 crashed over the sidewalk into a city tree and stone wall at 40 Chase St. Both operators were uninjured. Both Mvs sustained significant damage; #1 was able to be driven away with driver's side front end damage; #2 was inoperable and towed by Tody's. Photos of city tree knocked over and stone wall were submitted to the I.T. bureau. City forestry notified. Based on the following observations and statements, #1 was issued citation #T2080655 for Ch90/Sec14 Improper Turn; #1 was making a simultaneous turn and U-turn prior to colliding with #2 on its rear end side indicating #2 had already passed through most of that intersection; most of crash debris was found in proper travel lane of #2 indicating #2 was suddenly struck by #1 not allowing enough reaction time for #2 to avoid being struck.
Keywords:
Citation, Crash, Pictures, Tree
Dcc:
Improper turn, Unknown
Report
url:
Image
url:
Latitude:
42.3283825
Longitude:
-71.1922189
Location:
Case
number:
Date:
2022-06-18
Time:
12:58
Address:
ELIOT AVE & WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 was driving northbound on Waltham St when her vehicle was struck by vehicle #2, which was taking a left onto Waltham St from Eliot Ave. Operator #2 stated she did not see vehicle #1 when she was attempting to take the turn. There were no reported injuries. Vehicle #1 had to be towed by Tody's due to substantial right side damage. Vehicle #2 had front end damage but was operable.
Keywords:
[]
Dcc:
Improper turn, Unknown
Report
url:
Image
url:
Latitude:
Longitude:
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);