tables

16 rows where database_id = 3

View and edit SQL

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

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.37ms