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