crash_reports

1 row where dcc contains "Followed too closely", dcc_code = "[4, 5]" 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:

1900001221

Date:

2019-11-27

Time:

19:02

Address:

311 CENTRE ST

Speed limit:

30

Violation cited:

no

Narrative:

MV 1 was changing lanes from the right lane to the left lane southbound on Centre St. When MV 1 changed lanes in front of MV 2, he was rear ended by MV 2. MV 2 was traveling straight southbound on Centre St when MV 1 changed lanes and crossed in front of her. At this time she rear ended MV 1. There were no injuries to either party and each operator was advised with an accident report number.

Keywords:

Crash

Dcc:

Failed to yield, Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3577434

Longitude:

-71.1848012

Location:

311 Centre St, Newton, MA 02458, 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);