crash_reports_fts

1 row where "date" is on date 2019-02-10 and dcc contains "Lane departure"

✎ 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
165 165 1900000168 2019-02-10T15:34 2019-02-10 15:34 CRAFTS ST & WATERTOWN ST Vehicle 1 was travelling straight ahead, westbound on Watertown St. Vehicle 2 was in the left turn only lane, and taking a turn onto Crafts St. The operator of vehicle 1 stated they needed to swerve off of the road to avoid getting struck by the rear of vehicle 2. Vehicle 1 struck the curb with their right front tire. The tire popped and the rim was damaged. No one was injured due to the accident. Vehicle 1 was towed by Tody's. A level 3 inspection was done to vehicle 2 by Officer Marini, and a citation was issued. Citation, Crash Lane departure 9 Watertown St & Crafts St, Newton, MA 02460, USA 74958  

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