columns

1,690 rows

View and edit SQL

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

Next page

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 13.046ms