crash_reports_fts

1 row where "datetime" is on date 2022-06-10 and dcc = "["Over-steering"]"

✎ 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
3554 3554 22000510 2022-06-10T16:10 2022-06-10 16:10 21 HAZELTON RD MV#1 was parked unoccupied in front of 21 Hazelton Rd. Operator of MV#2 was attempting to back down the street when he hit MV#1. He stated MV#1 was in his blind spot. Moderate damage to right rear of MV#1 and moderate damage to right rear of MV#2. Both vehicles driven from the scene. Moderate Over-steering 12 21 Hazelton Rd, Newton Centre, MA 02459, USA 69111  

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