crash_reports
1 row where date = "2019-03-28" and dcc contains "Lane departure"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-28
Time:
09:46
Address:
DEDHAM STREET & BOUND BROOK ROAD
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday, March 28, 2019 while assigned to Traffic unit N525, I responded to the area of Dedham Street and Bound Brook Road, Newton for a report of a motor vehicle accident. Dedham Street and Bound Brook Road are both public ways maintained by the City of Newton. Anna Johnson (S14645384) stated her vehicle, a 2012 Honda CRV (MA: 4AG988), was parked unoccupied on Dedham Street (S) right before Bound Brook Road. Johnson stated she was made aware that her vehicle was hit by a passing vehicle. When she arrived at her vehicle, she observed damage to the driver side door mirror and the rear driver side door area. A note with a name and phone number was left on her vehicle by the operator of MV2. I spoke with Maria Diaz-Santos (S91121221) stated she was operating her 2018 Chrysler Pacifica (MA: 1MMB61) south on Dedham Street towards Bound Brook Road. Diaz-Santos stated as she was traveling past MV1, her rear passenger side door mirror area made contact with the driver side of the parked vehicle. Diaz-Santos stated she contacted Newton PD to make them aware of the accident and left her name and phone number on MV1 for it's owner to exchange information. Diaz-Santos stated there is very minor damage to her passenger side door mirror.
Keywords:
Crash, Phone
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.311434
Longitude:
-71.202243
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);