home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Followed too closely", dcc_code = "[5, 18]" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900001246
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:
report
Image url:
image
Latitude:
42.3513057
Longitude:
-71.218124
Location:
27 Parsons St, Newton, MA 02465, USA
Case number:
2000000330
Date:
2020-06-15
Time:
15:30
Address:
2040 COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
On 6/15/2020 at approximately 1540 hours, I responded to 2040 Commonwealth ave for a report of a two car accident. Upon arrival, I spoke with MV 1 who stated that he was reversing his tractor trailer into the shaws loading dock area when he struck MV2 with the backend of his cab. There is minimal damage and no injuries reported. I then spoke MV2 who stated that he was behind MV1 driving westbound on Commonwealth ave. He stopped to let the tractor trailer back into the loading dock. He realized he did not leave the trailer enough room to make the turn and that is when MV1 and MV2 struck. He reports no injuries and minor damage to his vehicle.
Keywords:
Crash
Dcc:
Followed too closely, Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3469722
Longitude:
-71.2448227
Location:
2040 Commonwealth Avenue, Auburndale, MA 02466, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 947.563ms