crash_reports_fts

2 rows where "datetime" is on date 2021-03-26

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), dcc (array)

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
2323 2323 2100000209 2021-03-26T12:53 2021-03-26 12:53 200 BOYLSTON ST -Mv#2 was parked in a stall at the Wegman's Supermarket parking lot when it was struck by MV#1. -OpMv#2 came to the Newton Police station to report that she parked Mv#2 in the Florence Street side ( south/lower) parking lot stall and when into the store approximately 1050. Upon returning she stated she observed damage to the rear left side panel. -I conducted an inspection of the vehicle and observed minor damage to the vehicles left rear panel.The damage consists of scuffs and paint chips on the surface of the vehicle with no visible structural damage to the panel. I observed surveillance cameras outside the Wegman's super market which may have capture the collision. -There were no injuries or other property damage reported at the time of this collision being reported and no vehicle was towed from the scene. [] Unknown 99 200 Boylston St, Chestnut Hill, MA 02467, USA 13279  
2349 2349 2100000208 2021-03-26T18:06 2021-03-26 18:06 WALNUT ST & WATERTOWN ST MV#1 Was traveling Westbound on Watertown St attempting to make a right turn onto Walnut St when he was struck by MV#2 in the intersection. OPMV#1 Stated he was making a right turn and the other vehicle was making a left turn at the same time he was when they collided. MV#2 Was traveling Eastbound on Watertown St attempting to make a left turn onto Walnut St when she was struck by MV#1 in the intersection. OPMV#2 Stated she was making a left turn onto Walnut St when she collided with the other vehicle. [] Failed to yield, Inattention, Unknown 4, 19, 99 Watertown St & Walnut St, Newton, MA 02460, USA 13279  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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