crash_reports
1 row where address = "CENTRE ST & BEACON ST" and date = "2019-12-20"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-20
Time:
11:35
Address:
CENTRE ST & BEACON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV#1 stated she was travelling southbound on Centre St in the left travel lane when MV#2 swerved into her from the right travel lane. MV#1 sustained moderate damages to its right side front bumper. There were no reported injuries to the operator of MV#1 or its passengers. The operator of MV#2 stated she was travelling southbound on Centre St and was unsure what had happened. MV#2 sustained moderate damages to its driver's side front fender. There were no reported injuries to the operator of MV#2 or its passenger. A query of the operator of MV#1 showed a MA driver's license status of suspended. I issued in hand to the operator of MV#1 MA uniform citation #T2079506 for violation of c90 s23 operating after suspended license. A licensed operator (MA driver's license #S77072057) took possession of MV#1. The operator of MV#2 stated she did not have a driver's license and was never issued one. MV#2 showed that it was registered to the operator and provided a Brazilian passport for identification. I issued in hand to the operator of MV#2 MA uniform citation #T2079505 for violation of c90 s10 unlicensed operation of a motor vehicle. A licensed operator (MA driver's license #S47820770) took possession of MV#2.
Keywords:
Citation, Moderate
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3300268
Longitude:
-71.1948254
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);