columns

1,690 rows

descending

id ▼	table_id	name
1	people 1	id
2	people 1	name
3	members 2	id
4	members 2	name
5	members 2	person_id
6	categories 3	id
7	categories 3	type
8	categories 3	name
9	items 4	hash
10	items 4	item
11	items 4	category_id
12	items 4	date
13	items 4	member_id
14	items 4	person_id
15	items 4	sort_order
16	items 4	record_id
17	items_fts_segments 5	blockid
18	items_fts_segments 5	block
19	items_fts_segdir 6	level
20	items_fts_segdir 6	idx
21	items_fts_segdir 6	start_block
22	items_fts_segdir 6	leaves_end_block
23	items_fts_segdir 6	end_block
24	items_fts_segdir 6	root
25	items_fts_docsize 7	docid
26	items_fts_docsize 7	size
27	items_fts_stat 8	id
28	items_fts_stat 8	value
29	items_fts 9	item
30	items_fts 9	person_name
31	Applicant 10	id
32	Applicant 10	value
33	FacilityType 11	id
34	FacilityType 11	value
35	block 12	id
36	block 12	value
37	Status 13	id
38	Status 13	value
39	Mobile_Food_Facility_Permit 14	locationid
40	Mobile_Food_Facility_Permit 14	Applicant
41	Mobile_Food_Facility_Permit 14	FacilityType
42	Mobile_Food_Facility_Permit 14	cnn
43	Mobile_Food_Facility_Permit 14	LocationDescription
44	Mobile_Food_Facility_Permit 14	Address
45	Mobile_Food_Facility_Permit 14	blocklot
46	Mobile_Food_Facility_Permit 14	block
47	Mobile_Food_Facility_Permit 14	lot
48	Mobile_Food_Facility_Permit 14	permit
49	Mobile_Food_Facility_Permit 14	Status
50	Mobile_Food_Facility_Permit 14	FoodItems
51	Mobile_Food_Facility_Permit 14	X
52	Mobile_Food_Facility_Permit 14	Y
53	Mobile_Food_Facility_Permit 14	Latitude
54	Mobile_Food_Facility_Permit 14	Longitude
55	Mobile_Food_Facility_Permit 14	Schedule
56	Mobile_Food_Facility_Permit 14	dayshours
57	Mobile_Food_Facility_Permit 14	NOISent
58	Mobile_Food_Facility_Permit 14	Approved
59	Mobile_Food_Facility_Permit 14	Received
60	Mobile_Food_Facility_Permit 14	PriorPermit
61	Mobile_Food_Facility_Permit 14	ExpirationDate
62	Mobile_Food_Facility_Permit 14	Location
63	Mobile_Food_Facility_Permit_fts 15	Applicant
64	Mobile_Food_Facility_Permit_fts 15	FacilityType
65	Mobile_Food_Facility_Permit_fts 15	Address
66	Mobile_Food_Facility_Permit_fts 15	LocationDescription
67	Mobile_Food_Facility_Permit_fts 15	FoodItems
68	Mobile_Food_Facility_Permit_fts_segments 16	blockid
69	Mobile_Food_Facility_Permit_fts_segments 16	block
70	Mobile_Food_Facility_Permit_fts_segdir 17	level
71	Mobile_Food_Facility_Permit_fts_segdir 17	idx
72	Mobile_Food_Facility_Permit_fts_segdir 17	start_block
73	Mobile_Food_Facility_Permit_fts_segdir 17	leaves_end_block
74	Mobile_Food_Facility_Permit_fts_segdir 17	end_block
75	Mobile_Food_Facility_Permit_fts_segdir 17	root
76	Mobile_Food_Facility_Permit_fts_docsize 18	docid
77	Mobile_Food_Facility_Permit_fts_docsize 18	size
78	Mobile_Food_Facility_Permit_fts_stat 19	id
79	Mobile_Food_Facility_Permit_fts_stat 19	value
80	Mail City 20	id
81	Mail City 20	value
82	City 21	id
83	City 21	value
84	NAICS Code Description 22	id
85	NAICS Code Description 22	value
86	NAICS Code 23	id
87	NAICS Code 23	value
88	State 24	id
89	State 24	value
90	Mail Zipcode 25	id
91	Mail Zipcode 25	value
92	Source Zipcode 26	id
93	Source Zipcode 26	value
94	Neighborhoods - Analysis Boundaries 27	id
95	Neighborhoods - Analysis Boundaries 27	value
96	Business Corridor 28	id
97	Business Corridor 28	value
98	Supervisor District 29	id
99	Supervisor District 29	value
100	Registered_Business_Locations_-_San_Francisco 30	Location 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)
        );