crash_reports_fts

1 row where "date" is on date 2019-02-10 and dcc contains "Failed to yield"

✎ 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
164 164 1900000167 2019-02-10T15:12 2019-02-10 15:12 CHESTNUT ST & PRINCE ST The operator of MV#1 stated that she was traveling south on Chestnut St approaching Prince St when MV#2 pulled out in front of her from Prince St and crash occurred. Operator #1 stated she had no time to stop. The operator of MV#2 stated that he was traveling west on Prince St and had come to a complete stop at the stop sign at Chestnut St, but did not see MV#1 until it was too late and crash occurred. Operator #2 stated the crash was his fault and he was cited. Citation, Crash Failed to yield 4 Chestnut St & Prince St, Newton, MA 02465, USA 74800  

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