crash_reports

Table actions

1 row where "datetime" is on date 2022-05-26 and dcc_code = "[4]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
22000455
Date:
2022-05-26
Time:
15:56
Address:
BRANDEIS RD & 140 BRANDEIS RD PARKING LOT
Speed limit:
25
Violation cited:
yes
Narrative:
MV1 was traveling Northbound out of the parking lot and attempting to pull out Westbound onto Brandeis Rd. while MV3 was stopped in the Eastbound lane, allowing for MV1 to pull out. When MV1 pulled out they struck MV2 who was traveling Westbound on Brandeis Rd. MV1 subsequently hit MV3 from the impact. MV1 had damage to the front right of the vehicle and driver side door. MV2 had damage to the driver side door. MV3 had damage to the driver side door. There were no injuries and MV1 was towed from the scene. A towed MV form was completed and filed with NPD. Operator of MV1 was issued in hand MA Uniform Citation #T1447650 MGL Ch. 89/8 Failure to Yield to oncoming Traffic while attempting to turn left.
Keywords:
Citation, Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3134114
Longitude:
-71.1866254
Location:
140 Brandeis Rd, Newton, MA 02459, 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);