tables

12 rows where database_id = 5

View and edit SQL

Suggested facets: count, has_fts, is_hidden

id ▼ database_id name count has_fts is_hidden label_column
49 sf-trees 5 PlantType 3 0 0 value
50 sf-trees 5 qCaretaker 21 0 0 value
51 sf-trees 5 qSiteInfo 31 0 0 value
52 sf-trees 5 qSpecies 562 0 0 value
53 sf-trees 5 qCareAssistant 15 0 0 value
54 sf-trees 5 qLegalStatus 9 0 0 value
55 sf-trees 5 Street_Tree_List 189144 1 0  
56 sf-trees 5 Street_Tree_List_fts 189144 1 1  
57 sf-trees 5 Street_Tree_List_fts_segments 1570 0 1  
58 sf-trees 5 Street_Tree_List_fts_segdir 5 0 1  
59 sf-trees 5 Street_Tree_List_fts_docsize 189144 0 1  
60 sf-trees 5 Street_Tree_List_fts_stat 1 0 1 value

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Query took 14.607ms