This data as json, CSV (advanced)
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 |
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) );