This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
20 | registered-business-locations 3 | Mail City | 2351 | 0 | 0 | value |
21 | registered-business-locations 3 | City | 2413 | 0 | 0 | value |
22 | registered-business-locations 3 | NAICS Code Description | 18 | 0 | 0 | value |
23 | registered-business-locations 3 | NAICS Code | 653 | 0 | 0 | value |
24 | registered-business-locations 3 | State | 61 | 0 | 0 | value |
25 | registered-business-locations 3 | Mail Zipcode | 4081 | 0 | 0 | value |
26 | registered-business-locations 3 | Source Zipcode | 3550 | 0 | 0 | value |
27 | registered-business-locations 3 | Neighborhoods - Analysis Boundaries | 41 | 0 | 0 | value |
28 | registered-business-locations 3 | Business Corridor | 10 | 0 | 0 | value |
29 | registered-business-locations 3 | Supervisor District | 11 | 0 | 0 | value |
30 | registered-business-locations 3 | Registered_Business_Locations_-_San_Francisco | 226184 | 1 | 0 | |
31 | registered-business-locations 3 | Registered_Business_Locations_-_San_Francisco_fts | 226184 | 1 | 1 | |
32 | registered-business-locations 3 | Registered_Business_Locations_-_San_Francisco_fts_segments | 2924 | 0 | 1 | |
33 | registered-business-locations 3 | Registered_Business_Locations_-_San_Francisco_fts_segdir | 7 | 0 | 1 | |
34 | registered-business-locations 3 | Registered_Business_Locations_-_San_Francisco_fts_docsize | 226184 | 0 | 1 | |
35 | registered-business-locations 3 | Registered_Business_Locations_-_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) );