crash_reports
1 row where "datetime" is on date 2019-06-03 and dcc contains "Glare"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-03
Time:
16:10
Address:
WALDORF RD & CANTERBURY RD
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated he was taking a left onto Waldorf Rd. Westbound from Canterbury Rd. when he saw a child bicyclist traveling Eastbound on Waldorf Rd. in the street. He stated that immediately after, the solar glare from the sun impaired his vision and he could no longer see the child, and at that time the two collided. The left driver's side door area struck the bicyclist, as well as the possible front left tire. The operator and passenger stated they were uninjured. MV1 sustained little to no damage. The bicyclist was identified as CHO, Elena, and she stated she was traveling Eastbound on Waldorf Rd. approaching Canterbury Rd. She stated MV1 took a left onto Waldorf Rd. towards her and at that time she collided with the left side of MV1 and fell off her bike. The rear wheel of the bike was bent due to the collision. Elena stated that she was ok but had right hip pain. She was wearing a helmet, green jacket, blue shirt, black pants, and was riding a pink and white Diamondback bicycle (Serial # A1504026648). Her mother KIM, Kyung arrived on scene and signed a patient refusal with AMB1, and transported her to Harvard Vanguard Wellesley for an evaluation. I took photos of the scene and submitted them to the IT bureau to be attached to this report.
Keywords:
Bike, Glare, Helmet, Impairment, Pictures, Solar
Dcc:
Glare
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);