crash_reports
2 rows where dcc = "["Failed to yield"]", "retrieved" is on date 2022-05-16 and speed_limit = 30
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-09
Time:
08:50
Address:
BEACON ST & CHESTNUT HILL DRIVEWAY
Speed
limit:
30
Violation
cited:
no
Narrative:
On Monday 5/9/2022 at approx 0850hrs, while assigned to N-496, I responded to the intersection of Beacon St and Chestnut Hill Dr for a 2 car MVA. Operator of MV1 states that she was traveling EB on Beacon St when suddenly MV2 drove in front her from her left side. She did not have time to break before they collided. MV1's front airbag was deployed. Operator of MV2 states that he was on Chestnut Hill Dr SB and came to a stop at Beacon St with the intention of going straight across. He said there were multiple cars in the left turn lane EB on Beacon St. He said that the front car motioned to him that he could go so he attempted to cross. He said that he did not see MV1 in the other lane and that his visibility was obstructed by all the cars in the left turn lane. Both operators signed medical refusals on scene. Both vehicles were towed by Tody's towing service.
Keywords:
Airbag
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3339598
Longitude:
-71.1623085
Location:
Case
number:
Date:
2022-05-13
Time:
15:55
Address:
CHESTNUT ST & ANITA CIR
Speed
limit:
30
Violation
cited:
no
Narrative:
The OP of MV#1 stated she was travelling southbound on Chestnut Street when MV#2 suddenly came out of a side street and collided into her car. The OP of MV#2 stated he was pulling out of Anita Circle when he thought it was safe to do so and there was a sudden collision that spun his car around. He doesn't know which direction MV#1 came from. Only MV#2 was towed. The OP of MV#1 is pregnant. All parties involved signed a medical refusal and will seek medical attention on their own.
Keywords:
[]
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.318103
Longitude:
-71.2259763
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);