crash_reports_fts

1 row where "datetime" is on date 2019-11-15 and dcc = "["Glare"]"

✎ 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
1154 1154 1900001176 2019-11-15T06:55 2019-11-15 06:55 258 DERBY ST Operator of MV1 was travelling eastbound on Derby Street when she collided with the rear of the attached trailer on MV2, which was parked on the side of the road in front of 258 Derby St. Operator of MV1 stated due to the sun glare she did not see the landscaping truck and trailer. MV1 sustained heavy front end damage and was towed by Tody's Towing. MV2 had very minor damage to the rear trailer and license plate. Operator of MV1 was evaluated by Cataldo and signed a patient refusal. MV2 was unoccupied at the time of the crash. Crash, Glare, Solar Glare 13 258 Derby St, West Newton, MA 02465, USA 61669  

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