crash_reports
3 rows where dcc = "["Lane departure", "Over-steering"]", dcc contains "Over-steering" and keywords contains "Citation"
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-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:
Case
number:
Date:
2022-04-06
Time:
07:24
Address:
332 LANGLEY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Mv#1 operator stated he turned left from Hamlet St onto Langley Rd S/B. #1 continued travel on Langley Rd S/B and veered right off the road and struck a city tree head on in front of 335 Langley. Operator stated he briefly blacked out for unknown reasons prior to the collision. Operator was evaluated by medics and signed a patient refusal. Operator was conscious and alert. No reported operator medical problems. No citation issued at this time. Tody's towed #1 with heavy front end damage. City Forestry arrived and inspected the tree.
Keywords:
Citation, Tree
Dcc:
Lane departure, Over-steering
Report
url:
Image
url:
Latitude:
42.3224769
Longitude:
-71.1847864
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);