crash_reports_fts

1 row where "datetime" is on date 2021-03-01 and dcc = "[]"

✎ 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
2276 2276 2100000156 2021-03-01T12:40 2021-03-01 12:40 85 CHARLEMONT ST REPORTING PARTY OF MV1 STATED SHE PARKED HER CAR IN FRONT OF HER HOUSE AT 85 CHARLEMONT STREET FRIDAY NIGHT. SOMETIME SUNDAY MORNING WHEN SHE WENT OUT TO HER CAR SHE NOTICED THE REAR DRIVER'S SIDE PANEL HAD SOME DAMAGE. THE TAIL LIGHT WAS ALSO CRACKED AND SOME DENTS RIGHT BELOW THE GAS TANK. MOST OF THE DAMAGE TO THE VEHICLE WAS MINOR AND DOES NOT INTERFERE WITH THE OPERATION OF THE VEHICLE. I INFORMED THE DRIVER TO CONTACT INSURANCE COMPANY AND REPORT THE DAMAGE. I CHECKED THE SURROUNDING AREA IF I COULD FIND ANY VEHICLE THAT MIGHT HAVE HAD FRESH DAMAGE OR PAINT THAT MATCHED THE COLOR OF MV1. I CAME UP WITH NEGATIVE RESULTS. Night, Solar [] [] 85 Charlemont St, Newton, MA 02461, USA 45230  

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