crash_reports_fts

1 row where "datetime" is on date 2021-03-26, dcc = "["Failed to yield", "Inattention", "Unknown"]" and dcc contains "Failed to yield"

✎ 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
2349 2349 2100000208 2021-03-26T18:06 2021-03-26 18:06 WALNUT ST & WATERTOWN ST MV#1 Was traveling Westbound on Watertown St attempting to make a right turn onto Walnut St when he was struck by MV#2 in the intersection. OPMV#1 Stated he was making a right turn and the other vehicle was making a left turn at the same time he was when they collided. MV#2 Was traveling Eastbound on Watertown St attempting to make a left turn onto Walnut St when she was struck by MV#1 in the intersection. OPMV#2 Stated she was making a left turn onto Walnut St when she collided with the other vehicle. [] Failed to yield, Inattention, Unknown 4, 19, 99 Watertown St & Walnut St, Newton, MA 02460, USA 12078  

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