crash_reports_fts

1 row where "datetime" is on date 2021-12-02 and dcc = "["Failed to yield"]"

✎ 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
3099 3099 2100001011 2021-12-02T18:13 2021-12-02 18:13 QUINOBEQUIN RD & WASHINGTON ST The OP. of MV#1 stated she was on the eastbound lane of Washington Street at a red light. When the light turned green, she drove forward and MV#2 suddenly made a turn towards her and sideswiped her vehicle. She then observed MV#2 go behind her and drive away down either Quinobequin Road or Wales Street. She was unable to see the plate on MV#2 and could only describe it as a dark colored SUV. [] Failed to yield 4 Quinobequin Rd & Washington St, Newton, MA 02462, USA 28195  

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