crash_reports

1 row where "datetime" is on date 2019-12-02 and dcc = "["Over-steering", "Inattention"]"

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

1900001240

Date:

2019-12-02

Time:

22:24

Address:

WASHINGTON ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator of MV1 stated he was traveling Eastbound on Washington St. when MV2 turned left in front of his vehicle colliding with him. Operator of MV2 stated he was traveling in the right hand land on Washington St. traveling Eastbound when he attempted to make a U-turn to travel Westbound onto Washington St. Operator of MV2 stated he first attempted to change lanes, however collided with MV1. No injuries. MV1 sustained minor damage to the right front end. MV2 sustained moderate damage to the left front end. Todys responded and towed MV2. A towed motor vehicle form was filled out in regards and placed on file.

Keywords:

Moderate

Dcc:

Over-steering, Inattention

Report url:

report

Image url:

image

Latitude:

42.3498391

Longitude:

-71.2179998

Location:

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