crash_reports_fts

1 row where "datetime" is on date 2019-02-15 and keywords contains "Crash"

✎ 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
188 188 1900000191 2019-02-15T09:40 2019-02-15 09:40 137 EDINBORO ST OPERATOR STATED SHE WAS BACKING OUT OF HER DRIVEWAY AT #132 EDINBORO ST WHEN SHE POSSIBLY HIT THE ACCELERATOR AS OPPOSED TO HER BRAKE AND ACCELERATED ACROSS THE ROAD INTO A STONE WALL AT #137 EDINBORO RD. PROPERTY OWNER OF #137 EDINBORO IDENTIFIED AS ANITA WALSH WAS GIVEN VEHICLES INSURANCE INFORMATION. I ADVISED HER TO TAKE PHOTOS OF THE ACCIDENT SCENE, WHICH SHE DID WHILE I WAS THERE. Crash, Pictures Unknown 99 137 Edinboro St, Newton, MA 02460, USA 50534  

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