crash_reports

Table actions

1 row where date = "2022-05-12", keywords contains "Crash" and "retrieved" is on date 2022-05-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:
22000392
Date:
2022-05-12
Time:
15:46
Address:
LEWIS TER & WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Vehicle 1 was traveling East on Washington St. in the right hand travel lane. Vehicle 2 was traveling West on Washington St. in the middle travel lane. Both direction each had a straight Green Traffic Signal. Vehicle 2 was attempting a left hand turn onto Lewis Ter. The operator of Vehicle 2 stated when he saw a break in the traffic he attempted the left turn but did not see Vehicle 1. Vehicle 1 collided with Vehicle 2 in a T-Bone manner. Vehicle 1 sustained significant damage to its front end and needed to be towed from the scene (Todys). Vehicle 2 sustained damage to its passenger side door and passenger side front quarter panel but was able to drive away from the scene. There were no injuries reported at the accident.
Keywords:
Crash
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3548687
Longitude:
-71.1957088
Location:
Lewis Terrace & Washington St, Newton, MA 02458, 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);