crash_reports

Table actions

1 row where dcc contains "Visibility obstructed" and latitude = "42.321813"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2000000676
Date:
2020-11-25
Time:
13:55
Address:
LINCOLN ST & WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
Operator of MV1 states he was traveling southbound on Walnut Street at Lincoln Street when MV2 entered the intersection from Lincoln St and struck MV2. MV1 sustained minor damage to the back right passenger door. Operator of MV2 states he was traveling eastbound on Lincoln Street entering the intersection at Walnut Street. Operator of MV2 states two vehicles were in the middle of the intersection attempting to take a left from Walnut Street northbound onto Lincoln Street westbound and they were obstructing his view of the roadway. Operator of MV2 states when the two vehicles cleared he attempted to take a left onto Walnut Street northbound and struck MV1. MV2 sustained minor damage to the front right bumper. Pictures were taken of the crash and submitted to IT. There were no injuries due to this accident and neither vehicle was towed
Keywords:
Crash, Pictures
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.321813
Longitude:
-71.2062923
Location:
Walnut St & Lincoln 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);