crash_reports

1 row where dcc contains "Reckless driving", keywords contains "Speed" and "retrieved" is on date 2022-03-21

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

22000233

Date:

2022-03-19

Time:

00:57

Address:

CRAFTS ST & WALNUT ST

Speed limit:

25

Violation cited:

yes

Narrative:

MV1 was traveling north bound on Walnut St at a high rate of speed when it hit the curb of the median at the intersection of Walnut and Craft St both public ways in the City of Newton. MV1 then skidded across the median coming to rest on the other side in front of 309 Craft St. Operator of MV1 was unsteady on his feet, had glassy eyes and was speaking with slurred speech. Air bags deployed and one occupant was transported to Newton Wellesley wit non-fatal injuries. MV1 was towed by Tody's. MA Uniform Citation T1445642 was issued. Pictures were taken on scene of damaged city property.

Keywords:

Citation, Pictures, Speed

Dcc:

Reckless driving

Report url:

report

Image url:

image

Latitude:

42.359029

Longitude:

-71.2122128

Location:

Walnut St & Crafts St, Newton, MA 02460, 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);