crash_reports

1 row where dcc = "["Over-steering", "Inattention"]", intersection = 0 and keywords contains "Tree"

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

2000000304

Date:

2020-05-23

Time:

22:24

Address:

385 WARD ST

Speed limit:

25

Violation cited:

no

Narrative:

Motor Vehicle 1 was traveling eastbound on Ward St when driver didn't account for the bend in the road. Driver tried to oversteer the vehicle and lost control of the vehicle. Vehicle then hit a tree in front of 385 Ward St. Vehicle was towed.

Keywords:

Tree

Dcc:

Over-steering, Inattention

Report url:

report

Image url:

image

Latitude:

42.3389972

Longitude:

-71.188946

Location:

385 Ward St, Newton, MA 02459, 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);