crash_reports
1 row where address = "BEACON ST & CENTRE ST" and "retrieved" is on date 2022-05-04
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-01
Time:
13:09
Address:
BEACON ST & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was traveling eastbound on Beacon Street approaching the intersection of Centre Street when she came to a stop at the red traffic light. Operator of MV1 states when the traffic light turned green she accelerated and struck a male party on a recumbent trike with the front bumper of MV1. Operator of MV1 states her visibility was obstructed from the hood of her vehicle because the recumbent trike is very low to the ground. It should be noted the trike had a flag attached to it, which the operator of MV1 stated she didn't see until after the accident happened. MV1 sustained minor damage to front bumpers license plate. No injuries. The bicyclist, Christopher Tsu, states he was traveling eastbound on Beacon Street on his recumbent trike when he came to a stop at the red traffic light at Centre Street. Mr. Tsu states when the traffic light turned green, MV1 struck him in the rear of his trike causing him to fall to the ground. Fallon Medic 5 evaluated Mr. Tsu and he signed a patient refusal. No damage done to the trike and no injuries.
Keywords:
Bike, Crash
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3300268
Longitude:
-71.1948254
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);