crash_reports
1 row where dcc contains "Visibility obstructed", keywords contains "Bike" and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-05-30
Time:
17:50
Address:
HIBBARD RD & TREMONT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 stated she was traveling Westbound on Tremont Street and could not see well due to a sun glare. Operator of MV1 further stated when she approached the intersection of Tremont Street at Hibbard Road she struck a pedestrian riding a bicycle. I was able to speak with two witnesses on scene who were friends with Ms. Shokri. Both were approximately 10 feet behind her in the crosswalk before she was struck by MV1. Witness statements are documented in this report. Both parents responded on scene and were entered into this report as non-motorists. Both followed medics to Newton Wellesley Hospital. MV1 sustained moderate front end damage. Pedestrian involved suffered minor injuries and was transported to Newton Wellesley Hospital. Operator of MV1 was evaluated on scene and signed a patient refusal. Due to the bicycle being moved prior to my arrival, pictures were not taken on scene. The bicycle was left off the roadway for her friends to pick up. Ms. Skokri was wearing a pink shirt, black shorts and was riding a black bicycle. Ms. Shokri was not wearing any protective equipment.
Keywords:
Bike, Crosswalk, Glare, Hospital, Moderate, Ped, Pictures, Solar
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.354757
Longitude:
-71.1810975
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);