crash_reports
1 row where "date" is on date 2019-07-12 and dcc_code = "[3]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-12
Time:
11:36
Address:
ELLIOT ST & OAK ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On 07/12/19 at 11:36 hours, I responded to Elliot and Oak Streets for a two car motor vehicle accident with no reported injuries. That intersection has a three way stop sign for all travel lanes. Operator of MV1 states he was traveling eastbound on Elliot Street and stopped for the stop sign at Elliot and Oak Streets. After, he proceeded straight through the intersection and was struck by MV2 on his passenger side rear wheel area. He states that MV2 never stopped for their stop sign and was coming through the intersection from Oak Street. I observed passenger side rear wheel and bumper damage to this vehicle but it was still driveable. Operator of MV2 states that she could not recall exactly what occurred but that she stopped for the stop sign. She could not provide which way she was traveling only stating that she was attempting to turn around and pull over to right side of the road to park. I observed damage to the driver's side front bumper area but the vehicle was still driveable. Based on the debris in the road and damage to the vehicles, it appears that MV2 never stopped for the stop sign on Oak Street (NB) as the other operator was proceeding through. MV2 then angled the vehicle to the right in order to pull over and park on the other side of the road. While doing so, she struck MV1. The operator was issued MA Uniform Citation # T1444918 for a Stop Sign Violation.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3127087
Longitude:
-71.2211196
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);