columns

1,690 rows

descending

id ▼	table_id	name
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
126	Registered_Business_Locations_-_San_Francisco_fts 31	Ownership Name
127	Registered_Business_Locations_-_San_Francisco_fts 31	DBA Name
128	Registered_Business_Locations_-_San_Francisco_fts 31	Street Address
129	Registered_Business_Locations_-_San_Francisco_fts 31	City
130	Registered_Business_Locations_-_San_Francisco_fts 31	State
131	Registered_Business_Locations_-_San_Francisco_fts 31	NAICS Code Description
132	Registered_Business_Locations_-_San_Francisco_fts 31	Neighborhoods - Analysis Boundaries
133	Registered_Business_Locations_-_San_Francisco_fts 31	Business Corridor
134	Registered_Business_Locations_-_San_Francisco_fts_segments 32	blockid
135	Registered_Business_Locations_-_San_Francisco_fts_segments 32	block
136	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	level
137	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	idx
138	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	start_block
139	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	leaves_end_block
140	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	end_block
141	Registered_Business_Locations_-_San_Francisco_fts_segdir 33	root
142	Registered_Business_Locations_-_San_Francisco_fts_docsize 34	docid
143	Registered_Business_Locations_-_San_Francisco_fts_docsize 34	size
144	Registered_Business_Locations_-_San_Francisco_fts_stat 35	id
145	Registered_Business_Locations_-_San_Francisco_fts_stat 35	value
146	Title 36	id
147	Title 36	value
148	Director 37	id
149	Director 37	value
150	Writer 38	id
151	Writer 38	value
152	Release Year 39	id
153	Release Year 39	value
154	Actors 40	id
155	Actors 40	value
156	Production Company 41	id
157	Production Company 41	value
158	Distributor 42	id
159	Distributor 42	value
160	Film_Locations_in_San_Francisco 43	Title
161	Film_Locations_in_San_Francisco 43	Release Year
162	Film_Locations_in_San_Francisco 43	Locations
163	Film_Locations_in_San_Francisco 43	Fun Facts
164	Film_Locations_in_San_Francisco 43	Production Company
165	Film_Locations_in_San_Francisco 43	Distributor
166	Film_Locations_in_San_Francisco 43	Director
167	Film_Locations_in_San_Francisco 43	Writer
168	Film_Locations_in_San_Francisco 43	Actor 1
169	Film_Locations_in_San_Francisco 43	Actor 2
170	Film_Locations_in_San_Francisco 43	Actor 3
171	Film_Locations_in_San_Francisco_fts 44	Title
172	Film_Locations_in_San_Francisco_fts 44	Production Company
173	Film_Locations_in_San_Francisco_fts 44	Director
174	Film_Locations_in_San_Francisco_fts 44	Writer
175	Film_Locations_in_San_Francisco_fts 44	Actor 1
176	Film_Locations_in_San_Francisco_fts 44	Actor 2
177	Film_Locations_in_San_Francisco_fts 44	Actor 3
178	Film_Locations_in_San_Francisco_fts 44	Locations
179	Film_Locations_in_San_Francisco_fts 44	Fun Facts
180	Film_Locations_in_San_Francisco_fts_segments 45	blockid
181	Film_Locations_in_San_Francisco_fts_segments 45	block
182	Film_Locations_in_San_Francisco_fts_segdir 46	level
183	Film_Locations_in_San_Francisco_fts_segdir 46	idx
184	Film_Locations_in_San_Francisco_fts_segdir 46	start_block
185	Film_Locations_in_San_Francisco_fts_segdir 46	leaves_end_block
186	Film_Locations_in_San_Francisco_fts_segdir 46	end_block
187	Film_Locations_in_San_Francisco_fts_segdir 46	root
188	Film_Locations_in_San_Francisco_fts_docsize 47	docid
189	Film_Locations_in_San_Francisco_fts_docsize 47	size
190	Film_Locations_in_San_Francisco_fts_stat 48	id
191	Film_Locations_in_San_Francisco_fts_stat 48	value
192	PlantType 49	id
193	PlantType 49	value
194	qCaretaker 50	id
195	qCaretaker 50	value
196	qSiteInfo 51	id
197	qSiteInfo 51	value
198	qSpecies 52	id
199	qSpecies 52	value
200	qCareAssistant 53	id

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