crash_reports

1 row where "date" is on date 2019-05-08 and dcc_code = "[3]"

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

1900000472

Date:

2019-05-08

Time:

11:48

Address:

WASHINGTON ST & PROSPECT ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of vehicle 1 stated he was traveling eastbound on Washington st and as he approached the intersection of Prospect St could not recall if the light was red or green but still preceded forward and was struck by vehicle 2. Operator of vehicle 2 states he was sitting on Prospect St at the light on Washington St. When the light turned green he proceeded forward across Washington St when vehicle 1 came across his path and he struck it on the driver side. Vehicle 1 had side airbag deployment. Both vehicles were towed by Todys. Both operators were evaluated by the medics and signed patient refusals.

Keywords:

Airbag

Dcc:

Signs/Signals

Report url:

report

Image url:

image

Latitude:

42.3456884

Longitude:

-71.2334977

Location:

Prospect St & Washington 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);