crash_reports
2 rows where dcc = "["Lane departure", "Over-steering"]", intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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);