calls

Custom SQL query

Category

id, value

1 row

Request_Type

id, value

8 rows

Responsible_Agency

id, value

61 rows

Status

id, value

2 rows

calls

rowid, CaseID, Opened, Closed, Updated, Status, Status_Notes, Responsible_Agency, Category...

80,878 rows

Category_value_fts (hidden)

value

1 row

Category_value_fts_docsize (hidden)

docid, size

1 row

Category_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Category_value_fts_segments (hidden)

blockid, block

0 rows

Category_value_fts_stat (hidden)

id, value

1 row

Request_Type_value_fts (hidden)

value

8 rows

Request_Type_value_fts_docsize (hidden)

docid, size

8 rows

Request_Type_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Request_Type_value_fts_segments (hidden)

blockid, block

0 rows

Request_Type_value_fts_stat (hidden)

id, value

1 row

Responsible_Agency_value_fts (hidden)

value

61 rows

Responsible_Agency_value_fts_docsize (hidden)

docid, size

61 rows

Responsible_Agency_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Responsible_Agency_value_fts_segments (hidden)

blockid, block

0 rows

Responsible_Agency_value_fts_stat (hidden)

id, value

1 row

Status_value_fts (hidden)

value

2 rows

Status_value_fts_docsize (hidden)

docid, size

2 rows

Status_value_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

Status_value_fts_segments (hidden)

blockid, block

0 rows

Status_value_fts_stat (hidden)

id, value

1 row

calls_fts (hidden)

Category, Request_Type, Request_Details, Neighborhood

80,878 rows

calls_fts_docsize (hidden)

docid, size

80,878 rows

calls_fts_segdir (hidden)

level, idx, start_block, leaves_end_block, end_block, root

1 row

calls_fts_segments (hidden)

blockid, block

181 rows

calls_fts_stat (hidden)

id, value

1 row

Download SQLite DB: calls.db 41.2 MB

Powered by Datasette · Query took 102.384ms