crash_reports_fts

2 rows where "datetime" is on date 2019-02-15 and dcc = "["Unknown"]"

✎ 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 51100  
189 189 1900000192 2019-02-15T13:35 2019-02-15 13:35 399 WASHINGTON ST Oper # 1 stated he was driving on Washington Street on 1/30/19 at 20:00 and spun out causing him to hit a pole. Claims no damage to pole and minor damage to car. Only reporting to satisfying Insurance company. [] Unknown 99 399 Washington St, Newton, MA 02458, USA 51100  

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