crash_reports
1 row where keywords contains "Helmet" and "retrieved" is on date 2021-12-03
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-12-01
Time:
14:13
Address:
CABOT ST & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/01/2021 while assigned to unit 524 I responded to the area of Walnut St and Cabot St for a report of a bicyclist that had possibly been struck by a vehicle. The incident was reported by two passerbys that stated they saw a young white male on a blue bike wearing black pants, red shoes and a black helmet get struck by a gray Honda CRV. Units checked the area and could not find the bicyclist or the vehicle. Shortly after clearing the initial call the operator of the vehicle called to report the accident. I spoke to Jean Ferreira who stated she was traveling southbound on Walnut St and noticed a young male about 13 yoa riding a bicycle along side her on her right side. As they approached the intersection of Cabot St Ferreira felt a thud along her passenger side. She looked in her rearview and saw the male down on the ground. She immediately stopped and exited her vehicle to check on him. As she approached the male party he apologized for hitting her car and said it was his fault. Ferreira did everything she could to help the male but he kept saying he was uninjured and he was sorry and that he only lived down the road (pointing down Cabot St). Ferreira offered to call the males parents or the police and medics but he refused and got back on his bike and left down Cabot St. (cid:31)I advised Ferreira that we had received a call on the incident but was unable to find the bicyclist. I told her I would document the incident for now with a report and if any one reaches out to us we will add to the report.
Keywords:
Bike, Crash, Helmet
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3477321
Longitude:
-71.2066792
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);