crash_reports

1 row where dcc contains "Followed too closely", hit_run = 0 and "retrieved" is on date 2021-04-12

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

2100000237

Date:

2021-04-06

Time:

17:15

Address:

CRAFTS ST & MAGUIRE CT

Speed limit:

25

Violation cited:

no

Narrative:

Vehicle one was turning right out of Maguire Court onto Crafts Street when he thought vehicle two was driving straight and didn't look until he made contact with the back of vehicle two. Vehicle two was slowing and stopped on Craft St trying to take a left hand turn onto Clinton St. Vehicle one rear ended vehicle two.

Keywords:

[]

Dcc:

Followed too closely, Inattention

Report url:

report

Image url:

image

Latitude:

42.3551192

Longitude:

-71.2018354

Location:

Maguire Ct & Crafts 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);