crash_reports_fts

1 row where "datetime" is on date 2021-08-13 and dcc = "[]"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ case_number datetime date time address narrative keywords dcc dcc_code geocoded_address crash_reports_fts rank
2702 2702 2100000605 2021-08-13T14:15 2021-08-13 14:15 260 NEEDHAM ST On 08/13/21 at approximately 14:15 I responded to #260 Needham St.-Marshalls for a past H&R M.V.. Upon arrival I spoke with the owner of veh #1 who is an employee of Marshalls. She stated she parked her vehicle at approximately 09:00 this morning and when she finished her shift at approximately 14:15, she saw the passenger side rear quarter had been struck. It appears as if a small white colored car struck her parked vehicle while it was either pulling in or out. Owner of veh#1 stated she checked with her manager who told her there are no cameras in the area of the parking lot. Minor damage to veh #1. [] [] [] 260 Needham St, Newton, MA 02461, USA 40904  

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