crash_reports
1 row where dcc_code = "[3]" and "retrieved" is on date 2021-09-20
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)
Case
number:
Date:
2021-09-14
Time:
18:08
Address:
BEACON ST & BEACONWOOD RD
Speed
limit:
30
Violation
cited:
no
Narrative:
The operator of vehicle 1 stated he was turning left from Beacon Street into a parking lot off of Beaconswood Road as cars in traffic had stopped to let him turn. As he was turning a motorcycle came up from behind on the right side of the cars letting him turn, he was unable to stop fast enough and struck the motorcycle. There was minor front end damage to vehicle 1. The operator of vehicle 2 stated he saw the traffic stopped ahead of him and decided to pass them all on the right, he proceeded past the parking lot when vehicle 1 struck him on his left side. The operator reported no injury and minimal damage to the bike. The operator was evaluated by medics and was able to drive off.
Keywords:
[]
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3309493
Longitude:
-71.2088849
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);