crash_reports
1 row where dcc contains "Reckless driving", keywords contains "Speed" and "retrieved" is on date 2022-04-26
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-21
Time:
23:52
Address:
318 CRAFTS ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 4/21/22, I was dispatched to the intersection of Crafts St./California St. for a motor vehicle collision involving a single vehicle into a tree. Upon arrival, I observed MV#1 had crashed into a tree in front of 315 Craft St. The operator stated the "road was slippery" and he veered off the roadway, hitting the curb, before traveling 20-25 yards on the sidewalk, hitting two tree's. MV#1 sustained heavy front end damage and air bag deployment consistent with colliding into a tree at a decent rate of speed. MV#1 was removed from the roadway by Tody's Tow Service. The operator of Mv#1 was transported to Newton-Wellesley Hospital with injuries. Charges pending at this time for OUI Liquor 2nd Offense, Marked Lanes Violation and Negligent Operation of a Motor Vehicle.
Keywords:
Crash, Hospital, Speed, Tree
Dcc:
Reckless driving
Report
url:
Image
url:
Latitude:
42.358935
Longitude:
-71.2125693
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);