crash_reports
3 rows where dcc = "["Lane departure", "Over-steering"]", dcc contains "Lane departure" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: intersection, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-06
Time:
08:27
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper # 1 stated she was driving NB on Centre Street and was turning left onto Homer Street. During the turn she was reaching for something in her car and turned into snow bank and struck a city pole with a parking restriction sign on it. Traffic Officer Wade took photos. No tows. No citations
Keywords:
Citation, Pictures, Snow
Dcc:
Lane departure, Over-steering
Report
url:
Image
url:
Latitude:
42.3344554
Longitude:
-71.1934235
Location:
Case
number:
Date:
2020-06-17
Time:
19:03
Address:
CHESTNUT ST & WOODWARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of Vehicle #1 stated that he was stopped at the red light on Woodward Street when Vehicle #2 made a left turn from Chestnut Street and struck his driver's side door. Operator of Vehicle #1 was not injured. Operator of Vehicle #2 stated that she made a left turn from Chestnut Street onto Woodward Street. Operator stated that her dog was jumping around the front seat and she misjudged the turn. Operator over steered and struck Vehicle #1. Operator of Vehicle #2 was not injured. Vehicle #2 was towed from the scene by Tody's Towing.
Keywords:
[]
Dcc:
Lane departure, Over-steering
Report
url:
Image
url:
Latitude:
42.3260924
Longitude:
-71.2263534
Location:
Case
number:
Date:
2020-08-30
Time:
02:13
Address:
848 BEACON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
At the scene the operator of Vehicle #1 was extracted by Newton Fire and transported to Newton-Wellesley Hospital by Newton Medics. At the Hospital I spoke with the Operator of Vehicle #1. Operator states that she was driving home from a friends house and didn't remember any of the details of the crash. From my investigation, as well as the statement from the witness, it appears Vehicle #1 under steered while trying to make a left turn. The vehicle struck the curb, left the roadway and rolled onto its side. The driver was issued a citation for a Marked Lanes violation. The vehicle was towed from the scene by Tody's.
Keywords:
Citation, Crash, Fire, Hospital
Dcc:
Lane departure, Over-steering
Report
url:
Image
url:
Latitude:
42.3297729
Longitude:
-71.1956758
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);