crash_reports_fts

1 row where keywords = "["Citation", "Snow", "Tree"]"

✎ 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
222 222 1900000225 2019-03-02T09:47 2019-03-02 09:47 885 CENTRE ST OPER OF MV#1 STATED THAT HE WAS TRAVELLING SB ON CENTRE ST (#855), WHEN HIS VEHICLE LOST TRACTION ON THE SNOW COVERED ROAD, AND SPUN OUT STRIKING A TREE. MV#1 SUSTAINED HEAVY FRONT END DAMAGE WITH AIR BAG DEPLOYMENT, AND WAS TOWED FROM THE SCENE. OPER OF MV#1 WAS ISSUED MA CITATION T1440992 FOR OPERATING AN UNREGISTERED VEHICLE ON A PUBLIC WAY. Citation, Snow, Tree Unknown 99 885 Centre St, Newton, MA 02459, USA 31676  

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