crash_reports

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

2100000265

Date:

2021-04-14

Time:

18:30

Address:

1321 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

MV1 was turning left from Washington St onto Cherry St heading NORTHBOUND. MV2 was entering traffic onto Cherry St from the Cherry St Municipal parking lot turning left heading NORTHBOUND. MV2 entered the traffic lane as a southbound MV waved him on to go. MV1 was unaware of this and continued driving in his lane northbound when it was struck by MV2 on its drivers side door. MV2 was damaged on its passenger front bumper area. No injuries reported. All vehicles were driveable and safetly left the scene.

Keywords:

[]

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3494467

Longitude:

-71.2276058

Location:

1321 Washington St, 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);