crash_reports_fts

1 row where "datetime" is on date 2021-09-18 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
2795 2795 2100000725 2021-09-18T15:38 2021-09-18 15:38 LOWELL AVE & WALNUT ST Operator of MV1 stated they were driving Southbound on Walnut St. towards the intersection of Lowell Ave. when MV2 struck the front right side of their vehicle. MV1 was disabled and facing Southbound in the Northbound lane of Walnut St. @Lowell Ave. Operator of MV2 stated they were traveling Northbound on Lowell Ave towards Walnut St. Operator of MV2 stated they came to a stop and attempted to turn right onto Walnut St. when they struck MV1. MV1 sustained damage to the front right side and was towed by Tody's. MV2 sustained damage to the front bumper. A towed MV inventory form was completed. [] Inattention 19 Walnut St & Lowell Ave, Newton, MA 02460, USA 18663  

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