columns

26 rows where table_id = 30

descending

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

CREATE TABLE columns (
            id integer PRIMARY KEY,
            table_id integer,
            name text,
            FOREIGN KEY (table_id) REFERENCES tables(id)
        );