registry

Custom SQL query returning 101 rows (hide)

This data as json, CSV

iddatabase_idnamecounthas_ftsis_hiddenlabel_column
1 1 people 1421 0 0 name
2 1 members 2677 0 0  
3 1 categories 54 0 0  
4 1 items 1384575 1 0  
5 1 items_fts_segments 6223 0 1  
6 1 items_fts_segdir 1 0 1  
7 1 items_fts_docsize 1384575 0 1  
8 1 items_fts_stat 1 0 1 value
9 1 items_fts 0 1 1  
10 2 Applicant 131 0 0 value
11 2 FacilityType 2 0 0 value
12 2 block 414 0 0 value
13 2 Status 6 0 0 value
14 2 Mobile_Food_Facility_Permit 673 1 0  
15 2 Mobile_Food_Facility_Permit_fts 673 1 1  
16 2 Mobile_Food_Facility_Permit_fts_segments 28 0 1  
17 2 Mobile_Food_Facility_Permit_fts_segdir 1 0 1  
18 2 Mobile_Food_Facility_Permit_fts_docsize 673 0 1  
19 2 Mobile_Food_Facility_Permit_fts_stat 1 0 1 value
20 3 Mail City 2351 0 0 value
21 3 City 2413 0 0 value
22 3 NAICS Code Description 18 0 0 value
23 3 NAICS Code 653 0 0 value
24 3 State 61 0 0 value
25 3 Mail Zipcode 4081 0 0 value
26 3 Source Zipcode 3550 0 0 value
27 3 Neighborhoods - Analysis Boundaries 41 0 0 value
28 3 Business Corridor 10 0 0 value
29 3 Supervisor District 11 0 0 value
30 3 Registered_Business_Locations_-_San_Francisco 226184 1 0  
31 3 Registered_Business_Locations_-_San_Francisco_fts 226184 1 1  
32 3 Registered_Business_Locations_-_San_Francisco_fts_segments 2924 0 1  
33 3 Registered_Business_Locations_-_San_Francisco_fts_segdir 7 0 1  
34 3 Registered_Business_Locations_-_San_Francisco_fts_docsize 226184 0 1  
35 3 Registered_Business_Locations_-_San_Francisco_fts_stat 1 0 1 value
36 4 Title 307 0 0 value
37 4 Director 249 0 0 value
38 4 Writer 266 0 0 value
39 4 Release Year 75 0 0 value
40 4 Actors 551 0 0 value
41 4 Production Company 179 0 0 value
42 4 Distributor 119 0 0 value
43 4 Film_Locations_in_San_Francisco 1622 1 0  
44 4 Film_Locations_in_San_Francisco_fts 1622 1 1  
45 4 Film_Locations_in_San_Francisco_fts_segments 61 0 1  
46 4 Film_Locations_in_San_Francisco_fts_segdir 1 0 1  
47 4 Film_Locations_in_San_Francisco_fts_docsize 1622 0 1  
48 4 Film_Locations_in_San_Francisco_fts_stat 1 0 1 value
49 5 PlantType 3 0 0 value
50 5 qCaretaker 21 0 0 value
51 5 qSiteInfo 31 0 0 value
52 5 qSpecies 562 0 0 value
53 5 qCareAssistant 15 0 0 value
54 5 qLegalStatus 9 0 0 value
55 5 Street_Tree_List 189144 1 0  
56 5 Street_Tree_List_fts 189144 1 1  
57 5 Street_Tree_List_fts_segments 1570 0 1  
58 5 Street_Tree_List_fts_segdir 5 0 1  
59 5 Street_Tree_List_fts_docsize 189144 0 1  
60 5 Street_Tree_List_fts_stat 1 0 1 value
61 6 Applicant 131 0 0 value
62 6 FacilityType 2 0 0 value
63 6 block 414 0 0 value
64 6 Status 6 0 0 value
65 6 Mobile_Food_Facility_Permit 673 1 0  
66 6 Mobile_Food_Facility_Permit_fts 673 1 1  
67 6 Mobile_Food_Facility_Permit_fts_segments 28 0 1  
68 6 Mobile_Food_Facility_Permit_fts_segdir 1 0 1  
69 6 Mobile_Food_Facility_Permit_fts_docsize 673 0 1  
70 6 Mobile_Food_Facility_Permit_fts_stat 1 0 1 value
71 7 Mail City 2351 0 0 value
72 7 City 2413 0 0 value
73 7 NAICS Code Description 18 0 0 value
74 7 NAICS Code 653 0 0 value
75 7 State 61 0 0 value
76 7 Mail Zipcode 4081 0 0 value
77 7 Source Zipcode 3550 0 0 value
78 7 Neighborhoods - Analysis Boundaries 41 0 0 value
79 7 Business Corridor 10 0 0 value
80 7 Supervisor District 11 0 0 value
81 7 Registered_Business_Locations_-_San_Francisco 226184 1 0  
82 7 Registered_Business_Locations_-_San_Francisco_fts 226184 1 1  
83 7 Registered_Business_Locations_-_San_Francisco_fts_segments 2924 0 1  
84 7 Registered_Business_Locations_-_San_Francisco_fts_segdir 7 0 1  
85 7 Registered_Business_Locations_-_San_Francisco_fts_docsize 226184 0 1  
86 7 Registered_Business_Locations_-_San_Francisco_fts_stat 1 0 1 value
87 8 Title 307 0 0 value
88 8 Director 249 0 0 value
89 8 Writer 266 0 0 value
90 8 Release Year 75 0 0 value
91 8 Actors 551 0 0 value
92 8 Production Company 179 0 0 value
93 8 Distributor 119 0 0 value
94 8 Film_Locations_in_San_Francisco 1622 1 0  
95 8 Film_Locations_in_San_Francisco_fts 1622 1 1  
96 8 Film_Locations_in_San_Francisco_fts_segments 61 0 1  
97 8 Film_Locations_in_San_Francisco_fts_segdir 1 0 1  
98 8 Film_Locations_in_San_Francisco_fts_docsize 1622 0 1  
99 8 Film_Locations_in_San_Francisco_fts_stat 1 0 1 value
100 9 PlantType 3 0 0 value
101 9 qCaretaker 21 0 0 value
Powered by Datasette · Query took 1.074ms