crash_reports

1 row where dcc contains "Followed too closely", dcc_code = "[5, 20]" and intersection = 0

✎ View and edit SQL

This data as json, CSV (advanced)

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

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

Case number:

1900001187

Date:

2019-11-20

Time:

17:35

Address:

CENTRE ST BY MILLER RD

Speed limit:

30

Violation cited:

no

Narrative:

MV 1 was traveling Northbound on Centre St behind MV 2 and rear ended the back bumper of MV 2. MV 2 was traveling Northbound on Centre St and was rear ended by MV 1. The accident occured Northbound on Centre St by Miller Rd. There were no injuries to either party of MV 1 or MV 2. MV 1 was towed by Tody's due to damage. Inventory sheet completed and filed.

Keywords:

Crash

Dcc:

Followed too closely, Distracted

Report url:

report

Image url:

image

Latitude:

42.321758

Longitude:

-71.201179

Location:

Miller Rd, Newton, MA, 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);