crash_reports_fts

3 rows where "datetime" is on date 2019-01-19 and dcc_code = "["99"]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
66 66 1900000067 2019-01-19T14:14 2019-01-19 14:14 200 BOYLSTON ST Aubrey Quintus states that she parked ND Reg 539AAR at 200 Boylston St in the parking lot. When she came back to her vehicle she noticed the right side had been struck by an unidentified vehicle. No witnesses, injuries or tow. Quintus was advised. [] Unknown 99 200 Boylston St, Chestnut Hill, MA 02467, USA 65286  
69 69 1900000070 2019-01-19T18:44 2019-01-19 18:44 QUINOBEQUIN RD & WASHINGTON ST The OP. of MV#1 states she was travelling eastbound on Washington Street and had the green light when MV#2 suddenly made a turn in front of her. She tried to swerve away to avoid the collision but they still collided together. The OP. of MV#2 states she was on the westbound lane of Washington Street with intent to make a left turn towards Wales Street. The traffic light showed a green left arrow so she made the turn, that's when she collided with MV#1. [] Unknown 99 Quinobequin Rd & Washington St, Newton, MA 02462, USA 65286  
74 74 1900000075 2019-01-19T21:24 2019-01-19 21:24 391 LEXINGTON ST The OP. of MV#1 states while travelling northbound on Lexington Street, her car suddenly started sliding causing her to strike a tree by the roots area. Minor damage to the city tree, pictures taken. Pictures, Tree Unknown 99 391 Lexington St, Auburndale, MA 02466, USA 65286  

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