home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2021-12-20

✎ 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:
2100001040
Date:
2021-12-11
Time:
17:41
Address:
CENTRE ST
Speed limit:
30
Violation cited:
no
Narrative:
The operator of MV2 stated he saw the light at Centre Street and Gibbs Street turn yellow so he slowed down and stopped. After stopping he was struck from behind by MV1. The operator of MV1 stated when the light turned yellow MV2 slammed on the brakes and when she tried to stop she hydroplaned into MV2. MV1 had damage to the front bumper and MV2 had damage to the rear bumper. Neither party were injured and neither vehicle were disabled and both parties were able to drive their vehicles from the scene.
Keywords:
[]
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3293773
Longitude:
-71.1950856
Location:
Centre St, Newton, MA, USA
Case number:
2100001054
Date:
2021-12-16
Time:
10:19
Address:
888 WALNUT STREET
Speed limit:
25
Violation cited:
no
Narrative:
Thursday, December 16, 2021, while assigned to Traffic unit N525, I responded to the area of Beacon Street and Walnut Street in Newton for a report of a crash involving a City of Newton owned vehicle. Beacon Street and Walnut Street are both public ways maintained by the City of Newton. The operator of MV1, Ms. Risheen Brown (S34655505), stated she was operating her 2017 Subaru Forester (MA: 2VG176) on Walnut Street (N) past the Beacon Street intersection. Ms. Brown stated she slowed down in traffic to allow a vehicle in front of her make a turn. Ms. Brown stated MV 2 then crashed into the rear of her vehicle. I observed significant damage to the rear bumper/trunk area of MV1. Due to the damage to her vehicle, Ms. Brown was also advised to replace the two car seats in her vehicle. Ms. Brown reported no injuries on scene. The operator of MV2, Mark Whooten (S39870664), stated he was operating a City of Newton owned Ford F-350 (MA MVN: M99235) on Walnut Street (N) past the Beacon Street intersection. Mr. Whooten stated the vehicle in front of him abruptly stopped in their travel lane to allow a vehicle to turn. The front of MV2 crashed into the rear of MV1. I observed minor damage to the front area of MV2. Mr. Whooten reported no injuries on scene. Mr. Whooten is an employee of the City of Newton DPW. Photos were taken and submitted to the IT Bureau.
Keywords:
Crash, Pictures
Dcc:
Followed too closely
Report url:
report
Image url:
image
Latitude:
42.3311046
Longitude:
-71.2071052
Location:
888 Walnut St, Newton, MA 02461, 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 637.258ms