crash_reports

1 row where date = "2019-10-28", dcc contains "Visibility obstructed" and dcc_code = "[4, 18]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

1900001107

Date:

2019-10-28

Time:

18:45

Address:

AUSTIN ST & LOWELL AVE

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1; MA reg 9RXW70 (2017 Hyundai Elantra red) said he was driving southbound on Lowell Ave when he was hit by MV2; MA reg BC1995 (2013 Ford Fusion black), who was taking a left turn off of Austin St turning westbound. Operator of MV2 stated he was driving westbound on Austin St and stopped at the Lowell Ave intersections. Operator of MV2 said he looked both ways before trying to take a left onto Lowell Ave southbound but struck MV1. MV1 sustained damage to the driverside wheelwell and driver side door. MV2 had front end damage. MV1 was towed by Tody's. No injuries.

Keywords:

[]

Dcc:

Failed to yield, Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3502544

Longitude:

-71.2108899

Location:

Austin St & Lowell Ave, Newton, MA 02460, USA

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);