crash_reports_fts

1 row where "datetime" is on date 2019-09-20 and dcc = "["Inattention"]"

✎ 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
946 946 1900000963 2019-09-20T13:35 2019-09-20 13:35 999 BOYLSTON ST OPERATOR OF MV 1 STATED THAT SHE WAS IN THE PARKING LOT BEHIND 999 BOYLSTON STREETAND WHILE SHE WAS IN A SPOT, SHE BELIEVES SHE ACCIDENTALLY STEPPED ON THE GAS PEDAL AND THE VEHICLE MOVED FORWARD. THE VEHICLE STRUCK A SECTION OF THE WOODEN FENCE WHICH FELL AND CAUSED MINOR DAMAGE TO THE VEHICLE PARKED NEXT TO THEM. MODERATE DAMAGE SUSTAINED TO MV 1 AND NO INJURIES WERE REPORTED. OWNER OF MV REQUESTED A PRIVATE TOW FOR THE VEHICLE. TWO OTHER VEHICLES WHO WERE PARKED CLOSE TO MV 1 MAY HAVE BEEN DAMAGED BY THE FALLING FENCE. Crash, Moderate Inattention 19 999 Boylston St, Newton Highlands, MA 02461, USA 43069  

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