crash_reports

1 row where dcc = "["Failed to yield"]", intersection = 0 and "retrieved" is on date 2021-10-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:

2100000802

Date:

2021-10-10

Time:

13:31

Address:

175 BOYLSTON ST

Speed limit:

15

Violation cited:

no

Narrative:

The operator of MV1 stated he was traveling westbound in the parking lot travel lane at Bloomingdale's's when MV2 drove out behind a dodge truck and struck the passenger side of his vehicle. The operator of MV2 stated he was driving across a parking spot, to another spot and as he entered the travel lane in the parking lot, he struck the passenger side of MV1 with the front of his vehicle. All occupants stated they were not injured. MV1 sustained significant damage to the passenger side of the vehicle. MV2 had major damage to the front of his vehicle. MV1 was able to drive away from the accident after proper paper work was gathered. MV2 called for a private tow, AAA.

Keywords:

Crash

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3214181

Longitude:

-71.1748826

Location:

175 Boylston St, Chestnut Hill, 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);