crash_reports

1 row where "date" is on date 2020-03-18 and dcc = "["Failed to yield", "Inattention"]"

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

2000000241

Date:

2020-03-18

Time:

18:29

Address:

ALBEMARLE RD & CRAFTS ST

Speed limit:

25

Violation cited:

no

Narrative:

The operator of MV#2 (Jeep) had stopped at the stop sign on the corner of Albemarle Rd. and Crafts St. The operator proceeded southbound across Crafts St. towards Albemarle Rd. and was struck on it's passenger side by MV#1(Civic). The operator of MV#1 stated she was traveling eastbound on Crafts St. when she struck the passenger side of MV#2. The operator of MV#1 stated she did not observe MV#2 as it entered the roadway in front of her. Damage was observed to MV#1's front end, while MV#2 sustained damage to its passenger side front and rear doors, consistent with being "T-Boned". Both operators declined medical attention and were able to drive their vehicles away from the scene.

Keywords:

[]

Dcc:

Failed to yield, Inattention

Report url:

report

Image url:

image

Latitude:

42.3598454

Longitude:

-71.2170818

Location:

Crafts St & Albemarle Rd, Newton, MA 02460, 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);