crash_reports

1 row where dcc contains "Physical impairment", hit_run = 0 and "retrieved" is on date 2021-05-31

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), dcc (array)

case_number ▼	date	time	address	speed_limit	violation_cited	narrative	keywords	dcc	report_url	image_url	latitude	longitude

Case number:

2100000387

Date:

2021-05-27

Time:

23:59

Address:

236 LINWOOD AVE

Speed limit:

30

Violation cited:

yes

Narrative:

Vehicle 1 was traveling north on Linwood Ave. Vehicle 2 was legally parked in front of 236 Linwood Ave. As vehicle 1 approached the area of 236 Linwood Ave. it veered off the road to the east side and collided with the rear of Vehicle 2. There was little to no damage to either vehicle. The operator of Vehicle 1 was unlicensed and believed to be under the influence of liquor. The operator of Vehicle 1 was charged with MGL Ch 90/24/J OUI Liquor and MGL Ch. 90/10/A Unlicensed Operation of a Motor Vehicle. Vehicle 1 was towed from the scene By Tody's. There we no injuries reported.

Keywords:

[]

Dcc:

Physical impairment

Report url:

report

Image url:

image

Latitude:

42.3595554

Longitude:

-71.20823

Location:

236 Linwood Ave, 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);