crash_reports_fts

1 row where "datetime" is on date 2021-03-21 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
2299 2299 2100000202 2021-03-21T19:04 2021-03-21 19:04 140 VINE ST MV1 was traveling southbound when he thought he saw an animal in the road and swerved. MV1 lost control and struck a stone wall outside of 140 Vine St across the other lane of traffic. Both driver side and passenger side airbags deployed. Medics arrived and both parties signed patient refusals. MV1 sustained major damage and was towed by Tody's. Homeowner of 140 Vine St was advised of the damage and given the report number. Airbag Over-steering 12 140 Vine St, Chestnut Hill, MA 02467, USA 87159  

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