crash_reports

2 rows where dcc contains "Followed too closely", intersection = 0 and keywords contains "Severe"

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

2100000901

Date:

2021-11-04

Time:

15:59

Address:

CRAFTS ST

Speed limit:

25

Violation cited:

no

Narrative:

While traveling eastbound on Crafts St, LAWLER was operating Vehicle 1 and stopped at the stop light at the intersection with Linwood Ave. RAY was operating Vehicle 2 and was also traveling eastbound on Crafts St behind LAWLER and did not stop and made contact with the rear bumper of LAWLER's vehicle with the front bumper of her vehicle, causing minimal damage to LAWLER's vehicle and extensive damage to the front of her vehicle which appeared to be in excess of $1000. Neither party was able to explain how the collision occurred. There were no injuries reported. I facilitated the exchange of information between both drivers and both were allowed to drive away from the scene.

Keywords:

Severe

Dcc:

Signs/Signals, Followed too closely

Report url:

report

Image url:

image

Latitude:

42.358132

Longitude:

-71.21015

Location:

Crafts St, Newton, MA, USA

Case number:

22000636

Date:

2022-07-15

Time:

17:32

Address:

514 LOWELL AVE

Speed limit:

25

Violation cited:

no

Narrative:

MV1 stated she was traveling southbound on Lowell Ave when she locked up the brakes and came to an abrupt stop due to a turkey coming into the roadway. MV2 was travelling southbound behind MV1 and his vehicle struck MV1 in the rear causing severe front end damage to his vehicle (MV2) and heavy damage to the rear of her vehicle (MV1). MV1 spoke with Fallon Ambulance and signed a patient refusal. MV1 did not require a tow. Both front seat airbags in MV2 deployed and required a tow. MV2 also spoke with Fallon Ambulance and signed a patient refusal.

Keywords:

Airbag, Ems, Severe

Dcc:

Followed too closely, Other improper action

Report url:

report

Image url:

image

Latitude:

 

Longitude:

 

Location:

None

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