crash_reports

Table actions

1 row where "datetime" is on date 2019-02-02 and dcc = "["Failed to yield", "Inattention"]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000137
Date:
2019-02-02
Time:
13:13
Address:
HOVEY ST & WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling Westbound on Washington St. when MV2 collided with his vehicle attempting to take a left traveling Eastbound on Washington St. Operator of MV1 stated there was a vehicle traveling parallel to him on Washington St. that stopped at the intersection of Washington St. and Hovey St. but stated he did not see MV2 until the last second. MV2 stated he was facing Southbound on Hovey St. attempting to take a left on Washington St. to travel Eastbound when he observed MV1 at the last second and collided with him. No injuries. MV1 sustained heavy front end damage. MV2 sustained heavy front left end damage along with drivers side door damage. Both vehicles involved were towed on scene by Tody's towing. A towed motor vehicle form was filled out for both in regards.
Keywords:
[]
Dcc:
Failed to yield, Inattention
Report url:
report
Image url:
image
Latitude:
42.3560067
Longitude:
-71.1898424
Location:
Hovey St & 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);