columns

26 rows where table_id = 30

View and edit SQL

id ▼ table_id name
100 Registered_Business_Locations_-_San_Francisco 30 Location Id
101 Registered_Business_Locations_-_San_Francisco 30 Business Account Number
102 Registered_Business_Locations_-_San_Francisco 30 Ownership Name
103 Registered_Business_Locations_-_San_Francisco 30 DBA Name
104 Registered_Business_Locations_-_San_Francisco 30 Street Address
105 Registered_Business_Locations_-_San_Francisco 30 City
106 Registered_Business_Locations_-_San_Francisco 30 State
107 Registered_Business_Locations_-_San_Francisco 30 Source Zipcode
108 Registered_Business_Locations_-_San_Francisco 30 Business Start Date
109 Registered_Business_Locations_-_San_Francisco 30 Business End Date
110 Registered_Business_Locations_-_San_Francisco 30 Location Start Date
111 Registered_Business_Locations_-_San_Francisco 30 Location End Date
112 Registered_Business_Locations_-_San_Francisco 30 Mail Address
113 Registered_Business_Locations_-_San_Francisco 30 Mail City
114 Registered_Business_Locations_-_San_Francisco 30 Mail Zipcode
115 Registered_Business_Locations_-_San_Francisco 30 Mail State
116 Registered_Business_Locations_-_San_Francisco 30 NAICS Code
117 Registered_Business_Locations_-_San_Francisco 30 NAICS Code Description
118 Registered_Business_Locations_-_San_Francisco 30 Parking Tax
119 Registered_Business_Locations_-_San_Francisco 30 Transient Occupancy Tax
120 Registered_Business_Locations_-_San_Francisco 30 LIC Code
121 Registered_Business_Locations_-_San_Francisco 30 LIC Code Description
122 Registered_Business_Locations_-_San_Francisco 30 Supervisor District
123 Registered_Business_Locations_-_San_Francisco 30 Neighborhoods - Analysis Boundaries
124 Registered_Business_Locations_-_San_Francisco 30 Business Corridor
125 Registered_Business_Locations_-_San_Francisco 30 Business Location

Advanced export

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

CSV options:

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );
Powered by Datasette · Query took 8.618ms