crash_reports_fts

1 row where "datetime" is on date 2021-01-20

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
2163 2163 2100000032 2021-01-20T13:29 2021-01-20 13:29 200 BOYLSTON ST The operator of MV1 stated she parked her department of public works city vehicle, MA REG M7917A in the public parking lot of Wegmans located at 200 Boylston street at 1pm and when she came back to her vehicle around 2pm she noticed minor damage to the drivers side panel. MV1 stated there were no witnesses and she does not recall what vehicle was parked next to her. There are no cameras in the area. Pictures of the damage were taken and submitted to the IT Bureau. MV1 was able to leave the scene without further incident. Pictures [] [] 200 Boylston St, Chestnut Hill, MA 02467, USA 45177  

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