crash_reports
1 row where dcc_code = "[11, 97]" and "retrieved" is on date 2021-01-08
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-12-18
Time:
11:13
Address:
HYDE ST & WALNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#2 operator stated he was travelling on Walnut St S/B and braked for Mv#1 that was slowing ahead of him preparing to turn left on Hyde St. Mv#2 stated his truck slid over a snow patch which caused him to rear end Mv#1. The plow from Mv#2 struck the rear end of #1. Operator of Mv#2 was not injured. Mv#1 operator stated she was slowing on Walnut St S/B preparing to turn left when she was rear ended by Mv #2. Operator was not injured. Operator stated she does not have a license due to license paperwork issues. Operator produced a MA license which when queried expired on 5/7/18. Mv#1 rear seat juvenile passenger was picked up by his father on scene. Father refused evaluation for his son. A MA licensed operator arrived on scene to drive #1 from the scene. #1 operator was issued citation #T2080651 in hand for 90/10 unlicensed operation. Walnut St is a public way.
Keywords:
Citation, Snow
Dcc:
Swerving, Other improper action
Report
url:
Image
url:
Latitude:
42.3258015
Longitude:
-71.2065359
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);