crash_reports_fts

1 row where "date" is on date 2019-02-10 and dcc contains "Followed too closely"

✎ 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
166 166 1900000169 2019-02-10T17:04 2019-02-10 17:04 CENTRE ST & COMMONWEALTH AVE Operator of vehicle 1 stated that traffic was coming to a hault and she slammed on her breaks to avoid hitting the vehicle in front of her. Operator of vehicle 2 stated she did not have enough reaction time to avoid hitting vehicle 1 and rear ended vehicle 1. [] Followed too closely 5 Commonwealth Avenue & Centre St, Newton, MA 02459, USA 74650  

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