This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
100 | sf-trees 9 | PlantType | 3 | 0 | 0 | value |
101 | sf-trees 9 | qCaretaker | 21 | 0 | 0 | value |
102 | sf-trees 9 | qSiteInfo | 31 | 0 | 0 | value |
103 | sf-trees 9 | qSpecies | 562 | 0 | 0 | value |
104 | sf-trees 9 | qCareAssistant | 15 | 0 | 0 | value |
105 | sf-trees 9 | qLegalStatus | 9 | 0 | 0 | value |
106 | sf-trees 9 | Street_Tree_List | 189144 | 1 | 0 | |
107 | sf-trees 9 | Street_Tree_List_fts | 189144 | 1 | 1 | |
108 | sf-trees 9 | Street_Tree_List_fts_segments | 1570 | 0 | 1 | |
109 | sf-trees 9 | Street_Tree_List_fts_segdir | 5 | 0 | 1 | |
110 | sf-trees 9 | Street_Tree_List_fts_docsize | 189144 | 0 | 1 | |
111 | sf-trees 9 | Street_Tree_List_fts_stat | 1 | 0 | 1 | value |
JSON shape: default, array, newline-delimited, object
CREATE TABLE tables ( id integer PRIMARY KEY, database_id integer, name text, count integer, has_fts integer, is_hidden integer, label_column text, FOREIGN KEY (database_id) REFERENCES databases(id) );