crash_reports

1 row where "datetime" is on date 2020-05-16, dcc contains "Reckless driving" and speed_limit = 30

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

2000000299

Date:

2020-05-16

Time:

04:38

Address:

COMMONWEALTH AVE & HAMMOND ST

Speed limit:

30

Violation cited:

yes

Narrative:

The operator of MV 1 was traveling westbound on Commonwealth Avenue when he struck the route 30 sign pole at the intersection of Commonwealth Avenue and Hammond St. The operator admitted to driving the vehicle. The operator was issued in hand citation number T 2080794. The medics responded and transported the operator to Newton Wellesley. MV 1 sustained major damage to the entire front side. There was also minor damage along the right side of the vehicle indicating the operator possibly hit unknown objects before the collision with the pole. The vehicle was towed by Tody's due to it being disabled on a public way. An inventory sheet was filled out and filed.

Keywords:

Citation

Dcc:

Reckless driving, Other improper action

Report url:

report

Image url:

image

Latitude:

42.3361

Longitude:

-71.1785818

Location:

Commonwealth Avenue & Hammond St, Newton, MA 02467, 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);