crash_reports_fts

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

✎ 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
1769 1769 2000000461 2020-08-19T13:31 2020-08-19 13:31 195 CRAFTS ST Operator #1 stated he was stopped in traffic, S/B on Craft St by the Fire Station, #197 Craft St when he was rear ended by vehicle #2. Operator #2 stated she was behind MV#1 on Craft St when she reported MV#1 stopped in front of her. She was unable to stop before crashing into the rear of his MV. There were no injuries due to this accident and vehicle #2 was towed by Todys due to damage. Crash, Fire Followed too closely 5 195 Crafts St, Newton, MA 02460, USA 7379  

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