crash_reports

1 row where dcc contains "Distracted", keywords contains "Ped" and street2 = "WALNUT ST"

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

1900000804

Date:

2019-08-05

Time:

18:22

Address:

ELM ST & WALNUT ST

Speed limit:

25

Violation cited:

yes

Narrative:

Operator of vehicle 1 stated he was heading east on Elm St approaching the cross walk when he looked to one side but not the other and inched out and struck the pedestrian in the cross walk. Pedestrian stated he was in the cross walk when the car was inching forward and then accelerated and that is when he got hit.

Keywords:

Ped, Walk

Dcc:

Inattention, Distracted

Report url:

report

Image url:

image

Latitude:

42.3516

Longitude:

-71.230741

Location:

37 Elm St, Newton, MA 02465, 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);