crash_reports

1 row where dcc contains "Visibility obstructed", intersection = 0 and "retrieved" is on date 2021-09-28

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

2100000709

Date:

2021-09-15

Time:

10:46

Address:

5 TAFT AVE

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 (MA Reg 130AXN) stated her vehicle was parked legally in front of 5 Taft Ave when she observed a white pickup truck swipe the side of her vehicle. Operator of MV2 (MA CON V97640) stated he was traveling EB on Taft ave when he approached vehicles parked on both sides of the street. Operator stated as he attempted to squeeze through the vehicles the dumpster attached to the truck caught the rear Driver's side panel. MV1 was unoccupied at this time and sustained minor damage. MV2 had no damage. No injuries reported at the scene and both vehicles are able to operate safely.

Keywords:

[]

Dcc:

Visibility obstructed

Report url:

report

Image url:

image

Latitude:

42.3612661

Longitude:

-71.22206

Location:

5 Taft Ave, West Newton, MA 02465, 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);