crash_reports
1 row where "datetime" is on date 2019-03-09, intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-09
Time:
02:23
Address:
2401 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
On Saturday March 9, 2019, at approximately 0230 hours, I, Officer Brandon, responded to the Weston/Newton line on Commonwealth Ave to assist Weston PD with field sobriety. On arrival Weston PD had concluded field sobriety and determined that the party, Glenn Matot, was not under the influence. Weston PD then explained that they had been contacted by AAA stating that a single vehicle accident occurred in Weston's jurisdiction. After further review, Weston PD and I determined that the accident was in fact in Newton. I then spoke with the operator of MV1, Glenn Matot, who stated that he was on his way home from work traveling westbound on Commonwealth ave in front of the Charles River Canoe and Kayak when he became distracted by a text message. Mr. Matot further explained that while texting, his car drifted to the right causing him to drive up on the snow bank and up onto the guard rail before then falling off back into the road. MV1 sustained major damage to both the passenger side and undercarriage. Mr. Matot did not sustain any injuries and denied any medical attention. AAA arrived on scene and removed the vehicle from the road and Mr. Matot took an Uber home. Two pictures were taken of the damaged City of Newton guard rail and submitted to IT to be attached to the report.
Keywords:
Crash, Distracted, Phone, Pictures, Snow
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.344638
Longitude:
-71.2598115
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);