crash_reports

1 row where dcc = "["Failed to yield"]", intersection = 0 and "retrieved" is on date 2021-06-18

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

2100000424

Date:

2021-06-14

Time:

08:19

Address:

401 WATERTOWN ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator of MV1 (ma reg 2SH825) stated she was parked in front of 401 Watertown Street when she attempted to merge into traffic from a parking spot. While pulling out of the spot her front bumper was struck by a motor vehicle traveling WB on Watertown Street. Operator of MV2 (ma reg 1KXG58) stated he was traveling WB on Watertown Street when his front passenger side wheel and side board struck the front driver's side of MV1. The side board caught the front bumper and ripped it off. Both vehicles suffered minor damage and were able to drive away from the scene safely. Medic 5 was called to the scene for a report of minor injuries. Both parties signed medical refusals.

Keywords:

[]

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3602807

Longitude:

-71.2024286

Location:

401 Watertown 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);