crash_reports
2 rows where dcc = "["Failed to yield"]", keywords contains "Citation" and "retrieved" is on date 2021-07-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-06-22
Time:
15:06
Address:
130 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Veh #1 was traveling due West on Needham St. when veh #2 pulled out of #141 Needham St attempting to take a left and collided with veh #1. Veh #2 traveled into #130 Needham St window, Loyal Companion. Both air bags went off on veh #2 and both drivers were checked out by Medics and both signed patent refusals. Operator of veh #2 had a rash on her forearm from the airbag. Both vehicles were towed by Todys (David). Building Inspector Paul Nelson from the City of Newton came down on scene and stated that the damage to the building (#130 Needham St.) didn't effect the structural integrity. The operator of veh#2 admitted to hitting the gas instead of the brake. Operator of veh #2 cited in hand Mass. #T2080855 N.C.O.-Failure to use care in starting. I went inside Loyal Companion and spoke with Manager Micheal Wade. Wade stated no pets were hurt during the accident and he had already notified the buildindgs mainternece company to repsonde and board up the windows.
Keywords:
Airbag, Citation, Crash
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3130364
Longitude:
-71.2118267
Location:
Case
number:
Date:
2021-06-28
Time:
21:16
Address:
2040 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
I responded to 2040 Commonwealth Ave for a report of two car MVA. I arrived on location and the two involved MV's pulled into the parking lot of the Star Market. V1; MA Reg 66LS55, 2016 Volvo/Stwag color gray, operated by Hamar, Benjamin MA OLNS70134803. V1 traveling southbound on Commonwealth Ave collided with V2. V2; MA Reg 294F30, 2020 Jeep/util color white, operated by Xerras, Madeline MA OLN SA0790468. V2 was attempting to exit the parking lot of the Star Market, turning left from the exit. V2 was inattentive and failed to yield to oncoming traffic. V2 sustained front end damage. V1 sustained front/right end damge to the passenger side of the vehicle. Neither vehicle had airbag deployment. Neither of the operators sustained injury as a result of the collision. V2 operator was issued MA Uniform citation T2081075; 89/9 Fail to Yield.
Keywords:
Airbag, Citation
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3469722
Longitude:
-71.2448227
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);