This data as json, CSV (advanced)
Suggested facets: count, has_fts, is_hidden
id ▼ | database_id | name | count | has_fts | is_hidden | label_column |
---|---|---|---|---|---|---|
71 | registered-business-locations 7 | Mail City | 2351 | 0 | 0 | value |
72 | registered-business-locations 7 | City | 2413 | 0 | 0 | value |
73 | registered-business-locations 7 | NAICS Code Description | 18 | 0 | 0 | value |
74 | registered-business-locations 7 | NAICS Code | 653 | 0 | 0 | value |
75 | registered-business-locations 7 | State | 61 | 0 | 0 | value |
76 | registered-business-locations 7 | Mail Zipcode | 4081 | 0 | 0 | value |
77 | registered-business-locations 7 | Source Zipcode | 3550 | 0 | 0 | value |
78 | registered-business-locations 7 | Neighborhoods - Analysis Boundaries | 41 | 0 | 0 | value |
79 | registered-business-locations 7 | Business Corridor | 10 | 0 | 0 | value |
80 | registered-business-locations 7 | Supervisor District | 11 | 0 | 0 | value |
81 | registered-business-locations 7 | Registered_Business_Locations_-_San_Francisco | 226184 | 1 | 0 | |
82 | registered-business-locations 7 | Registered_Business_Locations_-_San_Francisco_fts | 226184 | 1 | 1 | |
83 | registered-business-locations 7 | Registered_Business_Locations_-_San_Francisco_fts_segments | 2924 | 0 | 1 | |
84 | registered-business-locations 7 | Registered_Business_Locations_-_San_Francisco_fts_segdir | 7 | 0 | 1 | |
85 | registered-business-locations 7 | Registered_Business_Locations_-_San_Francisco_fts_docsize | 226184 | 0 | 1 | |
86 | registered-business-locations 7 | 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) );