crash_reports

1 row where dcc contains "Followed too closely", intersection = 0 and "retrieved" is on date 2021-09-22

✎ 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:

2100000712

Date:

2021-09-15

Time:

16:54

Address:

190 TREMONT ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was travling eastbound on Tremont St following the flow of traffic. MV2 stated he was looking down away from the roadway to grab his coffee when he did not realize that MV1 had slowed down in the flow of traffic. MV2 rearended MV1. No injuries and both cars drove away.

Keywords:

[]

Dcc:

Followed too closely, Inattention

Report url:

report

Image url:

image

Latitude:

42.3524327

Longitude:

-71.1762984

Location:

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