crash_reports

1 row where "datetime" is on date 2019-05-28, intersection = 0 and keywords contains "Speed"

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

1900000546

Date:

2019-05-28

Time:

15:07

Address:

1045 BEACON ST

Speed limit:

25

Violation cited:

no

Narrative:

Operator of MV1 states he was stopped in traffic westbound, in the area of 1045 Beacon St. He states suddenly he was struck from behind by MV2. The vehicles seperated briefly and MV2 struck the back of MV1 again. Operator of MV2 stated she was driving at a slow rate of speed, behind MV1. She states she tried to stop her car but it was not responding. She attempted to downshift her car and put it in park, but instead it lunged forward into MV1 multiple times. No injuries were reported on scene. MV2 was towed by Todys. The passenger of MV2 had already left the scene prior to my arrival. I was able to speak to his father via phone who stated he was uninjured and did not need medical treatment.

Keywords:

Phone, Speed

Dcc:

Followed too closely

Report url:

report

Image url:

image

Latitude:

42.3308483

Longitude:

-71.2049812

Location:

1045 Beacon St, Newton, MA 02459, 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);