crash_reports
1 row where dcc = "["Too fast for conditions", "Lane departure"]", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
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);