tables

10 rows where database_id = 6

View and edit SQL

Suggested facets: count, has_fts, is_hidden

id ▼ database_id name count has_fts is_hidden label_column
61 food-trucks 6 Applicant 131 0 0 value
62 food-trucks 6 FacilityType 2 0 0 value
63 food-trucks 6 block 414 0 0 value
64 food-trucks 6 Status 6 0 0 value
65 food-trucks 6 Mobile_Food_Facility_Permit 673 1 0  
66 food-trucks 6 Mobile_Food_Facility_Permit_fts 673 1 1  
67 food-trucks 6 Mobile_Food_Facility_Permit_fts_segments 28 0 1  
68 food-trucks 6 Mobile_Food_Facility_Permit_fts_segdir 1 0 1  
69 food-trucks 6 Mobile_Food_Facility_Permit_fts_docsize 673 0 1  
70 food-trucks 6 Mobile_Food_Facility_Permit_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 16.86ms