crash_reports
1 row where keywords contains "Citation", latitude = "42.3344554" and "retrieved" is on date 2022-05-23
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-09
Time:
07:31
Address:
CENTRE ST & HOMER ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 stated he was travelling southbound on Centre St when his brakes failed and could not stop in time, striking MV#2 which pushed MV#2 into MV#3. MV#1 sustained minor damage to its front bumper. There were no reported injuries to the operator of MV#1. The operator of MV#1 did not have his license in his possession. He provided me with his information and an R.M.V query showed that he had a license status of suspended. While on scene I had the operator of MV#1 log on to his R.M.V account, pay off his balance owed and reinstate his driver's license (R.M.V confirmation #0-847-910-848). MV#1 was inspected and the brakes appeared to be in working order. The operator of MV#2 stated she was travelling southbound on Centre St when she was struck from behind by MV#1 which pushed her vehicle into MV#3 in front of her. MV#2 sustained moderate damages to its rear and front bumpers. The operator of MV#2 sustained non-incapacitating injury to her neck and refused medical attention. The operator of MV#3 stated she was travelling southbound on Centre St when she was struck from behind by MV#2. MV#3 sustained minor damage to its rear bumper. There were no reported injuries to the operator of MV#3. As of 05/12/2022, the license status of the operator of MV#1 is still suspended. I will mail MA uniform citation #T2012917 to the operator of MV#1 for violation of c90 s23 operating after suspended license.
Keywords:
Citation, Moderate
Dcc:
Defective equipment
Report
url:
Image
url:
Latitude:
42.3344554
Longitude:
-71.1934235
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);