crash_reports
2 rows where dcc = "["Too fast for conditions", "Lane departure"]", intersection = 0 and keywords contains "Citation"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-04
Time:
06:58
Address:
428 HAMMOND ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 3/4/19 I responded to the area of Hammond St and Chestnut Hill Rd for a report of a two car MVA. Upon arrival it was determined there were no injuries and the two drivers signed patient refusals with the ambulance. I first spoke with the operator of MV#1 who stated he was driving northbound on Hammond St near the Chestnut Hill T station where it bends and MV#2 was coming southbound and skidded on the snow and came into his lane. I then spoke with the operator of MV#2 who stated he was driving southbound on Hammond St when his vehicle lost control around the turn and drifted into the opposite lane and struck MV#1. I issued the operator of MV#2 MA Citation T1268628 for Chapter 89/4A; Marked Lanes Violation. At the time of this accident there were heavy snow conditions. Tody's Towing responded and towed both vehicles from the scene.
Keywords:
Citation, Crash, Ems, Snow
Dcc:
Too fast for conditions, Lane departure
Report
url:
Image
url:
Latitude:
42.3284846
Longitude:
-71.1650892
Location:
Case
number:
Date:
2021-01-02
Time:
01:15
Address:
229 AUBURN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Saturday January 2, 2021 at approximately 0115 hours I was dispatched to 229 Auburn St for a motor vehicle accident into a tree. MV1 was operating eastbound on Auburn St when it crossed over the marked center lane. MV1 struck the westbound side curb and jumped onto the sidewalk. MV1 then continued on the sidewalk until it struck the tree in front of 229 Auburn St. MV1 sustained total front end damage, as well as driver side damage. The driver side damage was to both driver side doors and both driver side tires were flat. MV1 was towed by Todys. MV1 operator was injured but conscious. However MV1 operator was unable to speak due to possible concussion injuries. MV1 was transported by Newton medics to Newton-Wellesley Hospital. MV1 was issued MA Uniform Citation T2015088 for marked lanes and speeding over reasonable and proper rate, and it will be sent to the MV1 operator via mail.
Keywords:
Citation, Crash, Hospital, Speed, Tree
Dcc:
Too fast for conditions, Lane departure
Report
url:
Image
url:
Latitude:
42.3460345
Longitude:
-71.2446603
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);