crash_reports_fts

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

✎ 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
2703 2703 2100000606 2021-08-13T12:20 2021-08-13 12:20 14 MT IDA ST ON 8-13-21 AT APPROX. 1220HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT HIT AND RUN. UPON ARRIVAL AT 14 MT. IDA ST. I SPOKE TO THE LESSEE ( CHRISTIAN FALK ) OF VEHICLE #1. LESSEE STATES HE PARKED HIS CAR ON THE STREET IN FRONT OF 14 MT. IDA ST AND SOMETIME BETWEEN 0030-1200HRS. SOMEONE HIT HIS CAR AND SPED AWAY. VEHICLE #1 HAD LEFT REAR QTR. PANEL DAMAGE, LEFT REAR DOOR DENTS AND LEFT REAR TIRE SCRAPES. IT WAS DIFFICULT TO TELL FROM THE DAMAGE THE ANGLE AS WELL AS THE POSSIBLE VEHICLE INVOLVED. DRIVER ADVISED TO CONTACT HIS INSURANCE COMPANY. CLEARED WITHOUT FURTHER INCIDENT. Crash Other improper action 97 14 Mt Ida St, Newton, MA 02458, USA 40928  

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