crash_reports

1 row where "datetime" is on date 2022-03-29, dcc contains "Failed to yield" and keywords contains "Fire"

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

22000261

Date:

2022-03-29

Time:

18:54

Address:

GROVE ST & RTE 128

Speed limit:

25

Violation cited:

no

Narrative:

Opr of MV1 stated he was traveling on Grove street. At this time, MV2 pulled out and made contact with him. MV1's airbags deployed and then pulled over. No injuries. MV1 sustained minor damage to the left side and was towed by Todys's. Opr refused to cooperate with fire. Opr of MV2 stated he was taking a left from the Route 128 off ramp. Due to the glare of the sun, he could not see MV1. At this time, MV2 made contact with MV1. No injuries. MV2 sustained minor damage to the front of his van. Opr of MV2 was legally driving with his Israeli Driver's License and proper documentation. For the purpose of the report his MA ID number was added to the license section.

Keywords:

Airbag, Fire, Glare, Solar

Dcc:

Failed to yield

Report url:

report

Image url:

image

Latitude:

42.3423767

Longitude:

-71.2488975

Location:

128 Grove St, Auburndale, MA 02466, 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);