crash_reports_fts

1 row where "datetime" is on date 2019-09-25

✎ 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
959 959 1900000976 2019-09-25T14:49 2019-09-25 14:49 BRANDEIS RD & OLDE FIELD RD ACCIDENT IS A HIT AND RUN. OPERATOR STATES THAT HE STOPPED AT THE STOP SIGN AT THE INTERSECTION OF OLDE FIELD AND BRANDEIS RD. HE STATES AS HE ENTERED THE INTERSECTION A POSSIBLE TOYOTA COROLLA BLACK IN COLOR, STRUCK HIM. CAUSING DAMAGE TO HIS FRONT BUMPER AND RIGHT FRONT TIRE. NO INJURIES REPORTED, I CANVASSED THE AREA LOOKING FOR THE SUSPECT VEHICLE, NEGATIVE RESULTS. Crash [] [] Olde Field Rd & Brandeis Rd, Newton, MA 02459, USA 65488  

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