crash_reports

1 row where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2022-01-24

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

22000061

Date:

2022-01-22

Time:

18:25

Address:

195 ADAMS ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 said he was traveling south bound on Adams street and a vehicle traveling north bound had it's high beams on. Operator of MV1 said this caused him to pull quickly to the right and he could not see initially. Operator of MV1 said he struck MV2 which was parked in front of 195 Adams Street. MV1 had damage to the front passenger bumper. MV2 had damage to the rear driver side bumper. There were no injuries and MV1 was towed away by Tody's. Owner of MV2 arranged for his vehicle to be towed privately. A towed motor vehicle form was filled out and placed in its proper location.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3582404

Longitude:

-71.2003053

Location:

195 Adams St, Newton, MA 02458, 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);