crash_reports
1 row where dcc = "["Failed to yield", "Too fast for conditions"]" and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-16
Time:
09:38
Address:
141 NEEDHAM ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 07/16/19 at approximately 09:38 I responded to a two vehicle crash on Needham St. outside of #141. The Operator of Veh #1 stated she was turning left on Needham St when the South bound traffic stopped to left her turn. As she turned, Veh#2 drove South down the multi-turn lane and they collided nearly head on. Heavy damage and air bag deployment to Veh #1. The operator was checked out by Medics and signed a patient refusal. The Operator of Veh #2 stated she was driving down the multi-turn lane South on Needham St.. She was preparing to take a left onto Jaconnet St when Veh #1 pulled out of parking lot and collided with her vehicle. I observed moderate to heavy damage to Veh #2 and noted that the vehicle didn't have its directional on. The operator of Veh #2 complained to left leg pain and was transported to Newton-Wellesley Hospital By Ambulance #1. Both vehicles were towed by Tody's Towing. At the conclusion of my investigation it appears as if both vehicles were at fault during this crash; Veh#1 for not yielding to right of way and Veh #2 for traveling too soon in a turn lane, no directional and driving too fast for the heavy traffic conditions. Both operators were given verbal warnings and there will be no citations issued at this time.
Keywords:
Citation, Crash, Ems, Hospital, Moderate
Dcc:
Failed to yield, Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);