crash_reports
2 rows where date = "2019-12-20" 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-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:
Case
number:
Date:
2019-12-20
Time:
23:33
Address:
40 PARK ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
MV 1 was traveling Northbound on Park St when she drove off the road and crashed into a telephone pole at 40 Park St. Park St is a public way in Newton. There was major damage to the front center, front left, and front right of MV 1. Powerlines covered the vehicle and entrapped the operator. The operator of MV was arrested for OUI (see incident report 19055618) Tody's towed the vehicle.
Keywords:
Crash
Dcc:
Lane departure, Other improper action
Report
url:
Image
url:
Latitude:
42.3554507
Longitude:
-71.1819377
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);