tables

13 rows where database_id = 4

View and edit SQL

Suggested facets: count, has_fts, is_hidden

id ▼ database_id name count has_fts is_hidden label_column
36 sf-film-locations 4 Title 307 0 0 value
37 sf-film-locations 4 Director 249 0 0 value
38 sf-film-locations 4 Writer 266 0 0 value
39 sf-film-locations 4 Release Year 75 0 0 value
40 sf-film-locations 4 Actors 551 0 0 value
41 sf-film-locations 4 Production Company 179 0 0 value
42 sf-film-locations 4 Distributor 119 0 0 value
43 sf-film-locations 4 Film_Locations_in_San_Francisco 1622 1 0  
44 sf-film-locations 4 Film_Locations_in_San_Francisco_fts 1622 1 1  
45 sf-film-locations 4 Film_Locations_in_San_Francisco_fts_segments 61 0 1  
46 sf-film-locations 4 Film_Locations_in_San_Francisco_fts_segdir 1 0 1  
47 sf-film-locations 4 Film_Locations_in_San_Francisco_fts_docsize 1622 0 1  
48 sf-film-locations 4 Film_Locations_in_San_Francisco_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 12.879ms