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) );