crash_reports_fts

1 row where "date" is on date 2019-10-02 and keywords = "["Citation", "Crash", "Ems"]"

✎ 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
984 984 1900001001 2019-10-02T19:43 2019-10-02 19:43 229 WINCHESTER ST Vehicle 1 was traveling S/B on winchester st when it collided with parked vehicle 2 in front of 229 Winchester st. Vehicle 2 was pushed into parked vehicle 3. Vehicle 2 and 3 were unoccupied at the time of the accident. Operator 1 had minor injuries and was transported to the NWH by Cataldo ambulance 1. Vehicle 1 and 2 were towed by todys towing. Operator 1 was issued ma Citation T2015491 for c90s24 OUI (Liquor), c90s24 Negligent Operation and c89s4A Marked Lanes violation. See incident #19041837 in regards to this accident for charges. Citation, Crash, Ems Reckless driving 10 229 Winchester St, Newton, MA 02461, USA 11649  

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