crash_reports
2 rows where dcc contains "Followed too closely", intersection = 0 and keywords contains "Snow"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date)
Case
number:
Date:
2019-02-27
Time:
21:54
Address:
1 CENTRE AV
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of Vehicle #1 stated that she was slowing to merge into traffic on Washington St, after exiting the MassPike, prior to the collision with Vehicle #2. The operator of Vehicle #2 stated that he attempted to stop prior to striking Vehicle #1, but was unable to due to the fresh snow that had fallen. All parties declined medical attention. Vehicle #2 was towed by Tody's Towing Co.
Keywords:
Snow
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3226299
Longitude:
-71.101108
Location:
Case
number:
Date:
2019-12-03
Time:
22:00
Address:
27 PARSONS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, 12/4/2019, at approximately 2045 hours, Ofc Helms and I responded to a past hit and run at 27 Parsons St. Upon arrival, I spoke with the owner of MV 1 (Marc Rizza) who stated that he noticed damage to the left rear of his vehicle today when he came back from vacation to pick up his car. MV 1 was parked in the driveway of 27 Parsons St, (the brother in law of the vehicle owner). He further stated that he believed a plow may have struck his car when it was plowing the driveway after or during the last snow storm. Yellow streaks were visibly seen on the left rear bumper consistent with the damage. The owner of MV 1 further stated that he believed the house across the street, 28 Parsons St is the person that usually plows the driveway. I spoke with Jeffrey Timmins who told me that he in fact did plow the driveway of 27 Parsons St after the storm sometime on Tuesday 12/3/2019. Mr. Timmins admitted to being the operator of MV 2 and stated he did not notice if he hit MV 1 while plowing the driveway but he "could have". I advised both parties with an accident report number. No tows required or reported injuries by either party.
Keywords:
Crash, Snow
Dcc:
Followed too closely, Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3513057
Longitude:
-71.218124
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);