crash_reports

1 row where "date" is on date 2021-06-16 and dcc = "["Failed to yield", "Inattention"]"

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

2100000439

Date:

2021-06-16

Time:

17:59

Address:

CARVER RD & WOODWARD ST

Speed limit:

30

Violation cited:

no

Narrative:

The operator of vehicle 1 stated he was traveling on Woodward Street North bound. While traveling past Carver Road, vehicle 2 crashed into his passenger side. The Passenger in Vehicle 1 stated the same thing. The operator of vehicle 2 stated he was traveling West on Carver Road. As he approached Woodward Street he looked to his right and it was clear, he proceeded out onto Woodward Street without looking to his left to see if his route was clear, and crashed into vehicle 1.

Keywords:

Crash

Dcc:

Failed to yield, Inattention

Report url:

report

Image url:

image

Latitude:

42.3220959

Longitude:

-71.217935

Location:

Carver Rd & Woodward St, Newton, MA 02461, 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);