crash_reports
2 rows where dcc = "["Signs/Signals", "Glare"]" and dcc contains "Signs/Signals"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-08-14
Time:
07:54
Address:
JACKSON RD & PEARL ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of Motor Vehicle #1 stated that he was traveling Eastbound on Jackson Road and preceded straight through the green light at the intersection of Jackson Road and Pearl Street and was struck by motor vehicle #2 that ran the red light. Operator of Motor Vehicle #2 stated that he was traveling Northbound on Pearl Street and the glare of the sun was in is eyes and did not see the red light until it was to late and struck motor vehicle #1 which caused it to roll over. Operator of motor vehicle #2 stated that he helped to operator of motor vehicle #1 get out of the car and stated that he had a few scratches on his knee. Motor vehicle #1 sustained major damage throughout the entire vehicle. Operator of Motor vehicle #1 sustained minor injuries and was transported to Newton Wellesley Hospital. Motor vehicle #2 sustained moderate front end damage. Tody's Towing towed motor vehicle #1. A citation was issued to the operator of motor vehicle #2 for failure to stop at red light..
Keywords:
Citation, Glare, Hospital, Moderate, Solar
Dcc:
Signs/Signals, Glare
Report
url:
Image
url:
Latitude:
42.359451
Longitude:
-71.194781
Location:
Case
number:
Date:
2022-01-27
Time:
10:23
Address:
HIGHLAND AVE & LOWELL AVE
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 01/27/2022 while working a detail for Feeney Utility Co, Lt Healy called over the air that he had just witnessed a motor vehicle pedestrian accident at his location and that no one was injured. On arrival I spoke to the pedestrian involved, Jinny Lin who stated he was walking northbound on Lowell Ave and was crossing Highland Ave in the marked crosswalk when he was struck by vehicle 1. Lin stated he was more than halfway across the street when he was struck. Lin said he was only bumped by the vehicle and was never knocked over. Lin had already notified his mother, Tina Chan who arrived on scene shortly after. Lin was seen by Fallon medics and signed a patient refusal. I than spoke to the operator of vehicle, Ali Roozbehani1 who stated he was traveling southbound on Lowell Ave and saw that it was blocked off and detoured down Highland Ave due to road construction. Roozbehani said he was slightly blinded due to solar glare as he made a left turn onto Highland Ave and as he did so struck a pedestrian. Roozbehani had no damage to his vehicle and was uninjured. I took several digital images of the scene and submitted them to IT to be attached to this report. Roozbehani was issued MA Uniform Citation #T2016735 for 89/11 pedestrian in a crosswalk.
Keywords:
Citation, Crash, Crosswalk, Glare, Ped, Solar, Walk
Dcc:
Signs/Signals, Glare
Report
url:
Image
url:
Latitude:
42.3490357
Longitude:
-71.2106948
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);