crash_reports
1 row where intersection = 0, keywords contains "School" and "retrieved" is on date 2021-10-27
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-25
Time:
08:32
Address:
100 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On October 25th, 2021 at approximately 08:32 hours while working N491 I responded to a report of a MV crash in the area of Walnut St near Minot Place. On my arrival I located both involved vehicles near #100 Walnut St, The School Administration Building. Vehicle #1 was a blue 2015 Prius, Ma reg.945-AM3, operated by a William Aldridge. He stated he was first stopped N/B at the intersection of Walnut St @ Watertown St in the right turn only lane. The light turned green and realized he wanted to go straight so he continued heading N/B on Walnut St . However as he went straight he cut off vehicle #2 who was in the lane to his left who then honked his horn at him. Vehicle #1 then stopped ahead of vehicle #2 a short distance down the road. Vehicle #2 then drove around vehicle #1 who was still stopped. Vehicle #2 after going around vehicle #1 had to stop almost immediately due to a pedestrian crossing the street. Vehicle #1 at the same time proceeded forward behind vehicle #2 but then rear ended vehicle #2 after it stopped for the pedestrian. Vehicle #2 was a 2021 grey Toyota Highlander, Ma reg. 447AB8, operated by a Rizwan Khan. He stated he was stopped for the light N/B on Walnut St @ the intersection of Watertown St. He was in the lane for straight ahead traffic. As the light turned green vehicle #1 cut over into his lane ahead of him causing him to almost hit him. He then admitted beeping his horn at vehicle #1. Thats when vehicle #1 suddenly stopped in front of him. After vehicle #1 didn't move he decided to go around him. As he passed him there was a pedestrian crossing the street. He then stopped his vehicle so the person could cross. His vehicle was then rear ended by vehicle #1.
Keywords:
Crash, Ped, School
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.3569892
Longitude:
-71.2094134
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);