crash_reports
2 rows where dcc contains "Over-steering", hit_run = 0 and "retrieved" is on date 2021-04-12
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-04-08
Time:
21:58
Address:
527 WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 stated he was traveling westbound on Washington Street. As he passed Walnut Pk, he struck MV2 with the front passenger side of his vehicle, it then caused MV1 to flip on to its roof and rest in the left hand lane facing southbound. Operator of MV1 stated he was talking on his cell phone that was mounted on his dash. MV2 was parked and unoccupied facing westbound. Both vehicles were towed. The operator of MV1 had a laceration to his forehead and was evaluated by the medics. The operator signed a refusal and was picked up by a friend. Operator of MV1 was handed a Mass Uniform Citation T2014950 for 90/13 Impeded Operation (using PED) and 89/4A, Marked lane violation.
Keywords:
Citation, Phone
Dcc:
Over-steering, Inattention
Report
url:
Image
url:
Latitude:
42.3553951
Longitude:
-71.1947475
Location:
Case
number:
Date:
2021-04-09
Time:
10:45
Address:
2014 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated she was sitting in her parked vehicle facing Eastbound when Vehicle #1 was struck from behind. Operator of Mv #1 described vehicle #2 as a small grey sedan that continued Eastbound on Washington St. Operator of vehicle #2 stated he was travelling Eastbound on Washington St. in the right hand lane. Operator #2 stated an unknown vehicle crossed into his lane forcing him to swerve to the right causing vehicle #2 to collide with vehicle #1.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3306338
Longitude:
-71.2464373
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);