crash_reports
1 row where keywords contains "Solar" 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-06
Time:
14:58
Address:
COMMONWEALTH AVE & HAMMOND ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle 1 states she was traveling northbound on Hammond St crossing Commonwealth Ave and had a green light. As she was crossing Commonwealth Ave vehicle 2 came across the front of her vehicle from her right (traveling westbound) and the vehicles collided. Operator of vehicle 2 stated she was traveling westbound on Commonwealth Ave and came to the intersection of Hammond St. Operator stated she had no idea if the light was green or red due to solar glare but continued through the intersection where she was struck on the drivers side by vehicle 1. Both operators and the two passengers of vehicle 1 signed patient refusals with Fallon medics. Vehicle 1 was able to be driven from the scene. Vehicle 2 was towed by Todys. The reporting party to the accident was an uninvolved witness. The witness told dispatch that vehicle 2 ran the red light causing the accident. I attempted to follow up with the witness by calling the number they called from (617-462-6762) with negative results. I did leave a voice mail and will attempt to follow up on my next tour of duty. ***On 10/07/2021 I was able to speak to the witness of the accident, Caroline O'Brien. O'Brien states she was on Hammond St behind vehicle 1 and states that they had the green light to proceed. She also states she saw vehicle 2 traveling westbound on Commonwealth Ave at a high rate of speed run the red light and strike vehicle 1.
Keywords:
Crash, Glare, Solar, Speed
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3361
Longitude:
-71.1785818
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);