crash_reports_fts

1 row where "datetime" is on date 2019-07-21 and dcc = "["Inattention"]"

✎ 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
737 737 1900000750 2019-07-21T13:36 2019-07-21 13:36 400 CENTRE ST Operator of vehicle 1 was traveling northbound on Centre St when he tapped the rear of vehicle 2 which was attempting to merge off on Centre St onto Centre Ave. There was minor to no damage on both vehicles. No tows required. No reported injuries. [] Inattention 19 400 Centre St, Newton, MA 02458, USA 52663  

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