crash_reports
1 row where keywords contains "Helmet" and "retrieved" is on date 2021-05-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2021-05-20
Time:
16:37
Address:
CANTERBURY RD & WALDORF RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling eastbound on Canterbury Rd approaching the intersection at Waldorf Rd when a bicyclist appeared out of nowhere traveling from Waldorf Rd northbound, didn't attempt to stop at the intersection and struck MV1 in the front right fender and windshield. Operator of MV1 remained on scene until emergency personnel arrived. The juvenile bicyclist, Daniel Yeo, states he was riding his bicycle with a helmet on northbound on Waldorf Rd approaching the intersection at Canterbury Rd when he saw MV1 enter the intersection and struck MV1 with his bicycle in the front right fender where he went over the bicycles handlebars landing on the roadway. Daniel states he attempted to apply the brakes, but realized it was too late and made contact with MV1. Medics evaluated Daniel for injuries where he complained of head and stomach pain. Daniel was transported with his mother, Jennifer Wu, to Mass General Hospital. Pictures were taken of the scene and submitted to IT to be attached with this report.
Keywords:
Bike, Helmet, Hospital, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.318986
Longitude:
-71.217644
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);