crash_reports_fts

1 row where "date" is on date 2020-08-19 and keywords = "["Crash"]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
1767 1767 2000000459 2020-08-19T08:58 2020-08-19 08:58 CENTRE ST BRIDGE & WASHINGTON ST Operator #1 stated she she was going N/B over the Centre St bridge when she was rear ended by vehicle #2. Operator#2 stated he was going N/B over the Centre St when vehicle #1 suddenly stopped in front of him causing him to crash into the rear of vehicle #1. There were no injuries due to this accident and neither vehicle was towed. Crash Followed too closely 5 Centre St & Washington St, Newton, MA 02458, USA 7008  

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