crash_reports
1 row where "datetime" is on date 2020-06-26, dcc contains "Failed to yield" and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-26
Time:
12:14
Address:
WASHINGTON ST & QUINOBEQUINN RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 6/26/2020 at approx 1214hrs while assigned to 497 I responded to the area of Washington St at Quinobequin Rd for a report of a 2 car crash with air bag deployment. Upon arrival I observed Ma Reg 579AM3 a gray Toyt Rav 4 and Ma Reg 219w70 a red Toyota Corolla in the middle of the EB lanes of Washington St both with significant damage, front and side airbag deployment and fluids leaking. I ascertained the operators were not hurt and called for two tows and NFD for speedy dry. I spoke with the operator of the red Toyt Brendan OCONNOR who stated he was travelling EB on Washington St, had the green light, was proceeding through the intersection when he was struck by the operator of the Toyt Rav 4,Gabriella NUGENT. I spoke with NUGENT who stated she was attempting to take the left onto Quinobequin Rd from the WB lane of Washington St when she collided with OCONNOR. NUGENT acknowledged that although the light was green WB she did not have the left arrow to turn. Both cars towed by Todys, both Nugent and OCONNOR signed patient refusals with Cataldo ambulance.
Keywords:
Airbag, Crash, Ems, Fire, Speed
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);