crash_reports

1 row where "datetime" is on date 2019-04-03, intersection = 0 and keywords contains "Speed"

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

1900000336

Date:

2019-04-03

Time:

16:04

Address:

1507 WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator of MV#1 stated she was travelling east in the area of 1507 Washington St in the southbound lane. She began to slow down in traffic when she was rear ended by MV#2. MV#1 suffered minor damage to the back and was able to be driven from the scene. Operator of MV#2 stated she was also in the southbound lane and traffic was travelling at a normal speed when she turned to look left to switch lanes. She stated at that moment "traffic began to slow down into gridlock" and she could not stop in time. She rear ended the back of MV#1. MV#2 suffered major damage to the front end and was towed from the scene by AAA (CJ's Auto.) No injuries.

Keywords:

Speed

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3463183

Longitude:

-71.2332675

Location:

1507 Washington St, West Newton, MA 02465, 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);