crash_reports

Table actions

1 row where "datetime" is on date 2019-01-03 and street1 = "NORTH CHESTNUT TER"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Case number:
1900000013
Date:
2019-01-03
Time:
18:15
Address:
CHESTNUT TER & COMMONWEALTH AVE
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling westbound on Commonwealth Ave. when MV2 pulled onto Commonwealth Ave from Chestnut Terrace onto Comm. Ave. As MV2 was pulling onto Comm. Ave the vehicle struck the driver side front and rear door. The Operator of MV2 stated she was taking a right onto Comm. Ave from Chestnut Terrace and hit MV1 with the front driver side bumper. MV1 had moderate damage to the driver side front and rear door. MV2 had minor damage to the driver side front bumper. Both operators and passengers did not suffer any injuries and both vehicles did not need to be towed. Operator of MV2 was cited for Ch. 90/10 Unlicensed Operation (T1440967), see incident #19000357. The owner of MV2 arrived on scene and drove the vehicle home.
Keywords:
Citation, Moderate
Dcc:
Lane departure
Report url:
report
Image url:
image
Latitude:
42.3361982
Longitude:
-71.1899502
Location:
Commonwealth Avenue & Chestnut Terrace, 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);