crash_reports
2 rows where dcc contains "Inattention", "retrieved" is on date 2022-06-08 and speed_limit = 25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-23
Time:
16:28
Address:
LORING ST & WARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On May 23, 2022 at approximately 16:28 hours I responded to the area of Ward St at Loring St for a two car motor vehicle crash. Upon arrival, all parties were on scene and out of their vehicles. It was determined that MV1 was backing out of the driveway of 31 Loring St, which is on Ward St and backed into MV2, which was parked facing westbound in the eastbound lane. There was visible damage on MV1's Rear Passenger side bumper and visible damage on MV2's passenger side. It should be noted that the passenger side mirror had existing damage prior to the crash. I spoke with the owner of MV2, who was aware of the crash and I advised her that her vehicle was parked facing the wrong direction. I informed the involved both parties that a crash report would be on file and how to obtain it.
Keywords:
Crash
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.33816
Longitude:
-71.1919792
Location:
Case
number:
Date:
2022-06-04
Time:
13:25
Address:
22 WOODWARD ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Vehicle 1 was waiting in southbound traffic at the traffic light for the intersection of Woodward St and Boylston St when the operator realized he was in the wrong turn lane. Vehicle 1 then attempted to reverse to give him room between him and the vehicle in front of him so he could change lanes, however he did not notice Vehicle 2 waiting in traffic behind him. Vehicle 1 then backed into Vehicle 2, causing minor damage to the rear bumper of Vehicle 1 and significant damage to the front end of Vehicle 2. Both operators gave similar accounts.
Keywords:
[]
Dcc:
Visibility obstructed, Inattention
Report
url:
Image
url:
Latitude:
42.3193608
Longitude:
-71.2132886
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);