crash_reports

1 row where "datetime" is on date 2019-06-24, dcc = "["Followed too closely"]" and keywords contains "Crash"

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

1900000651

Date:

2019-06-24

Time:

17:12

Address:

PROSPECT ST & WASHINGTON ST

Speed limit:

35

Violation cited:

no

Narrative:

On June 24, 2019 at approximately 17:12 hours I responded to a two car motor vehicle crash on Washington St at the intersection of Prospect St. Both vehicles were pulled over facing westbound on Washington St. MV1 had rear end damage, while MV 2 Had front end damage. Both operators said that the vehicle in front of MV1 made a sudden stop and turned left onto Prospect St without signaling, MV1 had to brake suddenly and MV2 crashed into the rear of MV1. The operator of MV1 complained of back pain but declined transport to the hospital after evaluation. MV2 was towed from the scene by Tody's.

Keywords:

Crash, Hospital

Dcc:

Followed too closely

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