crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and keywords contains "Phone"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-29
Time:
16:59
Address:
1619 CENTRE ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
All operators state MV3 was stopped in traffic, with MV2 stopped in traffic behind it. Both vehicles were heading southbound on Centre St. MV1 failed to stop behind MV2, colliding with the rear of MV2. MV2 was sent forward from the impact and collided with MV3. No injuries were reported on scene and no tows were needed. On my arrival all parties had exchanged information. After further investigation it was determined the operator of MV2 was driving with a suspended license. I spoke to her via phone and she stated she thought it was cleared up. I advised her that I would be mailing a citation to her (Citation #T1441680) for operating after a suspended license. She was driven away from the scene by a neighbor (Michael Manna, S20209078).
Keywords:
Citation, Crash, Phone
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.321044
Longitude:
-71.2047956
Location:
Case
number:
Date:
2019-05-28
Time:
15:07
Address:
1045 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states he was stopped in traffic westbound, in the area of 1045 Beacon St. He states suddenly he was struck from behind by MV2. The vehicles seperated briefly and MV2 struck the back of MV1 again. Operator of MV2 stated she was driving at a slow rate of speed, behind MV1. She states she tried to stop her car but it was not responding. She attempted to downshift her car and put it in park, but instead it lunged forward into MV1 multiple times. No injuries were reported on scene. MV2 was towed by Todys. The passenger of MV2 had already left the scene prior to my arrival. I was able to speak to his father via phone who stated he was uninjured and did not need medical treatment.
Keywords:
Phone, Speed
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3308483
Longitude:
-71.2049812
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);