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