crash_reports

1 row where "datetime" is on date 2019-06-04, dcc contains "Followed too closely" and intersection = 0

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

1900000571

Date:

2019-06-04

Time:

08:34

Address:

118 WINCHESTER ST

Speed limit:

30

Violation cited:

no

Narrative:

Operator of MV1 (MA Con S33031) was stopped in front of 118 Winchester Street waiting for the light to turn when his vehicle was rear ended. Operator of MV2 was traveling Northbound on Winchester Street and failed to stop in time before striking MV1. Both vehicles suffered minor damage and did not require tow's. Operator of MV1 was complaining about back pain. Engine 7, A2 and Medic 1 responded to the scene. Operator of MV1 was transported to NWH. Operator of MV2 was evaluated by the medics and signed a refusal.

Keywords:

[]

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.315936

Longitude:

-71.2086477

Location:

118 Winchester 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);