crash_reports

1 row where dcc = "["Failed to yield", "Glare"]", dcc contains "Failed to yield" and intersection = 0

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

2000000172

Date:

2020-02-20

Time:

15:41

Address:

697 WASHINGTON ST

Speed limit:

25

Violation cited:

no

Narrative:

Opr of V1 stated she was traveling westbound on Washington Street. Opr of V1 stated V2 came out of no where and made contact with her vehicle. Opr of V1 stated she was in the furthest westbound lane from the building and did not see the vehicle come from the parking lot. V1 was towed by Todys's. Opr of V1 sustained minor injuries and signed a refusal with the medics. Opr of V1 stated her husband will drive her to the hospital. Opr of V2 stated he was attempting to make a left hand turn out of the parking lot. While turning he was obstructed by two uninvolved vehicles. Opr of V2 thought he was clear to pull out and turn, but made contact with V1. Op of V2 was not injured. V2 was not towed.

Keywords:

Hospital

Dcc:

Failed to yield, Glare

Report url:

report

Image url:

image

Latitude:

42.3529253

Longitude:

-71.2021966

Location:

697 Washington 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);