crash_reports
2 rows where "datetime" is on date 2021-11-04, dcc contains "Followed too closely" and intersection = 0
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-04
Time:
15:59
Address:
CRAFTS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
While traveling eastbound on Crafts St, LAWLER was operating Vehicle 1 and stopped at the stop light at the intersection with Linwood Ave. RAY was operating Vehicle 2 and was also traveling eastbound on Crafts St behind LAWLER and did not stop and made contact with the rear bumper of LAWLER's vehicle with the front bumper of her vehicle, causing minimal damage to LAWLER's vehicle and extensive damage to the front of her vehicle which appeared to be in excess of $1000. Neither party was able to explain how the collision occurred. There were no injuries reported. I facilitated the exchange of information between both drivers and both were allowed to drive away from the scene.
Keywords:
Severe
Dcc:
Signs/Signals, Followed too closely
Report
url:
Image
url:
Latitude:
42.358132
Longitude:
-71.21015
Location:
Case
number:
Date:
2021-11-04
Time:
19:48
Address:
260 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On November 4, 2021 at approximately 19:48 hours Officer Guarino and I, Officer Joyce responded to 160 Needham St. for a report of a three car motor vehicle crash. Upon arrival, all vehicles were off of the roadway and parked at 160 Needham St. The operator of MV1 had heavy front end damage and all operators agreed that MV2 and MV3 were stopped on Needham St when MV1 Crashed into MV2 causing MV2 to crash into MV3. There was no visible damage to MV3, MV2 had damage to the rear bumper. There were no reported injuries and MV1 was towed by Tody's. All parties were advised that a poilce report would be on file and were given the report number.
Keywords:
Crash
Dcc:
Followed too closely, Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3087594
Longitude:
-71.214008
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);