crash_reports
2 rows where "date" is on date 2019-07-20 and speed_limit = 35
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-20
Time:
16:52
Address:
JACKSON RD & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of MV1(Ma reg 866MF0) stated he was traveling EB on Washington St when his vehicle was struck in the rear. Operator of MV1 stated he was stopped at the red light at the intersection of Jackson Rd. Operator of MV2(AMB1406) stated he was traveling EB on Washington St when he struck the rear of MV1. Operator of MV2 stated he observed a vehicle coming down from Lewis Terrace and was concerned they were not gonna stop at the intersection. This distraction caused MV2 to strike MV1 at a slow rate of speed. Both vehicles sustained minor damage and did not require a tow. The passenger and driver of MV1 were observed by the medics. The passenger was transported in the ambulance for undisclosed minor injury. The driver refused to sign the medical release. 5 Photos were taken of both vehicles showing the damage. I put the memory card in an envelope and left it for the I.T. Bureau.
Keywords:
Distracted, Ems, Pictures, Speed
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3549582
Longitude:
-71.1952442
Location:
Case
number:
Date:
2019-07-20
Time:
23:24
Address:
552 COMMONWEALTH AVE
Speed
limit:
35
Violation
cited:
yes
Narrative:
On 7/20/19 at 23:24 hrs I responded to the area of 552 Commonwealth Avenue for a report of a MVA. Upon arrival it was determined MV#1 had struck two unoccupied parked vehicles in the eastbound parking shoulder. The operator of MV#1 stated he was on his phone while driving and when he picked his head up another vehicle coming westbound was in his lane so he swerved to avoid collision and struck the parked vehicles. The impact caused MV#1 to spin and came to final rest facing Westbound. All vehicles were towed from he scene by Tody's towing. The operator of MV#1 was transported to the hospital for potential injuries. The Operator of MV#1 is being issued MA Citation T1442692 for 90/24 OUI Drugs, 89/4a Marked Lane Violation and 90/13B Impeded Operation/Phone Use and MA Citation T1442693 for 90/24 Operating to Endanger.
Keywords:
Citation, Crash, Hospital, Phone
Dcc:
Lane departure, Distracted
Report
url:
Image
url:
Latitude:
42.3360887
Longitude:
-71.1895313
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);