tables

16 rows where database_id = 7

View and edit SQL

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

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
        );
Powered by Datasette · Query took 12.763ms