crash_reports
1 row where "datetime" is on date 2021-01-21 and "retrieved" is on date 2021-02-19
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-01-21
Time:
11:02
Address:
NAHANTON ST & WINCHESTER ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
Operator of Motor Vehicle # 1 stated he was stopped at the red light in the left turn only lane Southbound on Winchester Street. Party stated a red Mazda 5 was taking a left turn onto Winchester street from Nahanton Street and drove on the wrong side of the road in the right turn only lane next to him and struck the rear panel on the passengers side causing minor damage. Operator of Motor Vehicle #1 stated that he attempted to stop Motor Vehicle #2 however the vehicle did not stop.. Operator of Motor Vehicle #1 stated he made a U-Turn and started following Motor Vehicle # 2 and called the Newton Police. Operator of Motor Vehicle # 2 stated that she did not realize that she hit Vehicle # 1 and was unaware that she drove on the wrong side of the road. Operator of Motor Vehicle # 2 was subsequently arrested for Operating Under the Influence with numerous other motor vehicle infractions. See report # 21003316 Motor Vehicle # 1 and 2 sustained minor damage. Motor Vehicle # 2 was towed by Todys's Towing at the location of Commonwealth Avenue and Avondale Road. (See repot # 21002695)
Keywords:
[]
Dcc:
Wrong way, Reckless driving
Report
url:
Image
url:
Latitude:
42.2969738
Longitude:
-71.2009796
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);