crash_reports

Table actions

1 row where dcc_code = "[3]" and "retrieved" is on date 2021-06-07

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
2100000398
Date:
2021-06-03
Time:
19:50
Address:
LEWIS TER & NEWTONVILLE AVE
Speed limit:
25
Violation cited:
no
Narrative:
The operator of MV1 stated she was traveling westbound on Newtonville Ave, approaching Lewis Ter when MV2 failed to stop at the stop sign on Lewis Ter. As MV1 was passing Lewis Ter, MV2 pulled onto Newtonville Ave, hitting the passenger side of MV1. MV1 then pulled over immediately after being struck. As MV1 pulled over, MV2 then turned left onto Newtonville Ave and continued eastbound, failing to stop to exchange paperwork. The operator of MV1 stated it was a gold Mercury Sable with tinted windows and front end damage, missing front bumper. Dispatch was updated and notified other units along with State. MV1 sustained significant damage to both the passenger side front and rear doors. The operator of MV1 father arrived and was able to drive the vehicle home. The operator and passenger both declined medical treatment.
Keywords:
[]
Dcc:
Signs/Signals
Report url:
report
Image url:
image
Latitude:
42.3528551
Longitude:
-71.1966008
Location:
Lewis Terrace & Newtonville Ave, 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);