crash_reports
2 rows where dcc contains "Failed to yield" and "retrieved" is on date 2021-10-25
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-13
Time:
08:08
Address:
WASHINGTON ST & LOWELL AVE
Speed
limit:
35
Violation
cited:
no
Narrative:
MV1 proceeding straight ahead on Westbound via Washington Street collided with MV2 negotiating a Northbound turn from Washington Street to Lowell Ave. Collision resulted in MV2 rolling and coming to rest on roof. Operator MV2 was entrapped in vehicle, Officer Tocci able to break the window and assist Operator out of vehicle. Operator MV2 transported to Newton Wellesley Hospital via Medic 2. MV1 and MV2 towed to Tody's. A towed motor vehicle form completed and filed.
Keywords:
Hospital
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3510472
Longitude:
-71.2106128
Location:
Case
number:
Date:
2021-10-13
Time:
09:38
Address:
QUINOBEQUIN RD & WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 10/13/2021 at approx 0938Hrs while assigned to 497 I responded to the area of Washington St and Quinobequin Rd for a report of a 2 car crash. Upon arrival both operators where pulled to the side of the road on Quinobequin Rd. I spoke with the operator of Ma Reg 3FWN51 Alicione Goncalves who stated she had the green light travelling Quinobequin Rd southbound when the pickup truck turned in front of her causing the collision. i spoke with the operator of NH Com Reg RBAC02, Robert Allen who stated he was travelling northbound on Quinobequin Rd , mistakenly though the green light was a green arrow to turn left onto Washington St colliding with Goncalves.
Keywords:
Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3274875
Longitude:
-71.2531655
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);