crash_reports

1 row where "datetime" is on date 2019-09-23, dcc contains "Followed too closely" 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:

1900000972

Date:

2019-09-23

Time:

19:13

Address:

2014 WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

The operator of vehicle 1 stated he was traveling eastbound on Washington St in the left lane when vehicle 2 crashed into his passenger side as vehicle 2 attempted to make a U turn. The Operator of vehicle 2 stated he was traveling Eastbound on Washington Street with his emergency lights activated the entire time and attempted to merge from the right lane to the left lane of Washington St and vehicle 1 came up along side him causing the vehicles to crash.

Keywords:

Crash

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3306338

Longitude:

-71.2464373

Location:

2014 Washington St, Newton, MA 02462, 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);