crash_reports_fts

1 row where "datetime" is on date 2020-11-24 and dcc = "["Inattention"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), dcc (array)

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
1949 1949 2000000671 2020-11-24T13:30 2020-11-24 13:30 HAMMONDSWOOD RD & HAMMOND ST Operator 1 states he was traveling Northbound on Hammond St passing Hammondswood Rd. when vehicle 2 pulled out of Hammondswood Rd and struck vehicle 2 on the driver side rear door. Operator 2 stated that he stopped at the stop sign on Hammondswood Rd @ Hammond St. He thought vehicle 1 had a stop sign and that it was a four way stop. Vehicle 1 pulled into the intersection where he struck vehicle 2. [] Inattention 19 Hammondswood Rd & Hammond St, Newton, MA 02467, USA 85708  

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