crashreports: crash_reports_fts: 3 rows where "date" is on date 2019-11-24

3 rows where "date" is on date 2019-11-24

Search:

descending

Link	rowid ▼	case_number	datetime	date	time	address	narrative	keywords	dcc	dcc_code	geocoded_address	crash_reports_fts
1185	1185	1900001207	2019-11-24T05:24	2019-11-24	05:24	320 WASHINGTON ST	MV1 stated he got off the Mass Pike Eastbound at exit 17, and once at the top of the ramp, his GPS directed him to take a left onto Washington St. While responding to a separate call, I witnessed MV1 traveling the wrong direction (NE) in the area of 320 Washington St. (one way section of rotary). I activated my blue lights and pulled up to MV1, telling the operator the street was a one way and he needed to turn around. The operator stated he had room to turn around, at which point I blocked Washington St. While turning around, the trailer of MV1 struck a City of Newton concrete light pole and knocked it down. The concrete pole was taped and coned off, and Daigle was notified to respond. Photos were taken and submitted to the IT bureau.	Pictures	Signs/Signals	3	320 Washington St, Newton, MA 02458, USA	18216
1186	1186	1900001208	2019-11-24T16:57	2019-11-24	16:57	HAMMOND ST & HAMMONDSWOOD RD	Motor vehicle 1 (MV1) was traveling eastbound on Hammond St. when motor vehicle 2 (MV2), pulled out of Hammondswood Rd. (southbound) and crashed into the front end of MV1. As a result of the crash both MV1 and MV2 sustained significant front end damage. The Cataldo medics responded to the scene, and all parties involved signed patient refusals.	Crash	Failed to yield	4	Hammondswood Rd & Hammond St, Newton, MA 02467, USA	18216
1187	1187	1900001209	2019-11-24T17:30	2019-11-24	17:30	225 BOYLSTON ST	On Sunday 11/24/19 at approximately 1730 hours while working in marked unit n499 I was dispatched to the parking lot on the rt9 side of 225 Boylston Street (Bloomingdales) for a report of a minor motor vehicle crash. Upon arrival I spoke with the operator of motor vehicle 2, GIRARD Kathleen, who states that she was driving from the 2nd aisle of parking spots into the main travel lane to attempt to exit the mall. When she attempted to turn left she didnt see motor vehicle 1 already in the lane of traffic striking the side of the vehicle. After speaking with GIRARD I spoke with the operator of motor vehicle 1, SONG Guang min. SONG did not speak english, but he corroborated what GIRARD had stated by using a translation app on his cell phone. GIRARD had damage to the front of her vehicle and SONG had damage to the drivers side of his vehicle. Both vehicles were still operable and were driven from the scene. Neither party was injured	Crash, Phone, Solar	Failed to yield	4	225 Boylston St, Chestnut Hill, MA 02467, USA	18216

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