This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden
| id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
|---|---|---|---|---|---|---|
| 87 | sf-film-locations 8 | Title | 307 | 0 | 0 | value |
| 88 | sf-film-locations 8 | Director | 249 | 0 | 0 | value |
| 89 | sf-film-locations 8 | Writer | 266 | 0 | 0 | value |
| 90 | sf-film-locations 8 | Release Year | 75 | 0 | 0 | value |
| 91 | sf-film-locations 8 | Actors | 551 | 0 | 0 | value |
| 92 | sf-film-locations 8 | Production Company | 179 | 0 | 0 | value |
| 93 | sf-film-locations 8 | Distributor | 119 | 0 | 0 | value |
| 94 | sf-film-locations 8 | Film_Locations_in_San_Francisco | 1622 | 1 | 0 | |
| 95 | sf-film-locations 8 | Film_Locations_in_San_Francisco_fts | 1622 | 1 | 1 | |
| 96 | sf-film-locations 8 | Film_Locations_in_San_Francisco_fts_segments | 61 | 0 | 1 | |
| 97 | sf-film-locations 8 | Film_Locations_in_San_Francisco_fts_segdir | 1 | 0 | 1 | |
| 98 | sf-film-locations 8 | Film_Locations_in_San_Francisco_fts_docsize | 1622 | 0 | 1 | |
| 99 | sf-film-locations 8 | 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)
);