crashreports: crash_reports_fts: 2 rows where "datetime" is on date 2019-05-19

2 rows where "datetime" is on date 2019-05-19

Search:

descending

Link	rowid ▼	case_number	datetime	date	time	address	narrative	keywords	dcc	dcc_code	geocoded_address	crash_reports_fts	rank
498	498	1900000506	2019-05-19T00:04	2019-05-19	00:04	134 MT VERNON ST	MV1, a 1999 Ford Explorer, MA Reg: 7ZT136, collided with a tree on city property just outside of 134 Mt Vernon St. Operator, Jarrod Stomberg, immediately told me that he looked down at his phone to make a phone call and in that moment, ran off the road and hit the tree. There was airbag deployment. Jarrod signed a refusal with the medics and was driven home by a family member. He was issued in hand MA Citation T1441780 for 90/13B - Texting While Driving. The vehicle was towed by Tody's Towing. Pictures were taken of the scene and placed into ITs box.	Airbag, Citation, Phone, Pictures, Tree	Distracted	20	134 Mt Vernon St, Newton, MA 02465, USA	29839
499	499	1900000507	2019-05-19T03:32	2019-05-19	03:32	PARK ST & WASHINGTON ST	On Sunday May 19th 2019 at 03:32, I responded to a single car accident at the intersection of Washington Street and Park Street. Operator of MV1 stated she was alone in the car and was coming from the Newton Corner rotary attempting to turn onto Park Street. She stated that she misjudged the right turn and went up onto the first median knocking down a crosswalk signal pole and the pole with the traffic signal and Park Street sign. She then went up onto the second median taking down another crosswalk pole and a street sign pole. Operator of MV1 stated she was fatigued and was not paying attention when the accident occurred. She was evaluated by Cataldo Medic 1 and signed a patient refusal. David Donahue of Todys Towing removed the vehicle from the accident scene. Large debris and the poles were placed onto the median and out of traffic. 494 and myself placed cones over each of the bases of the poles. Dagle and the City of Newton were notified about the damage and for the debris to be picked up in the morning. A total of 12 pictures of the damage was taken and turned into IT.	Crash, Crosswalk, Pictures, Solar	Fatigue/Sleep	21	Park St & Washington St, Newton, MA 02458, USA	29839

Advanced export

JSON shape: default, array, newline-delimited

CREATE VIRTUAL TABLE [crash_reports_fts] USING FTS5 (
    [case_number], [datetime], [date], [time], [address], [narrative], [keywords], [dcc], [dcc_code], [geocoded_address],
    content=[crash_reports]
);