tables

144 rows where database_id = 11

View and edit SQL

Suggested facets: has_fts, is_hidden

id ▼ database_id name count has_fts is_hidden label_column
137 MetObjects 11 Department 20 1 0 value
138 MetObjects 11 Department_value_fts 20 1 1  
139 MetObjects 11 Department_value_fts_segments 0 0 1  
140 MetObjects 11 Department_value_fts_segdir 1 0 1  
141 MetObjects 11 Department_value_fts_docsize 20 0 1  
142 MetObjects 11 Department_value_fts_stat 1 0 1 value
143 MetObjects 11 Object Name 27381 1 0 value
144 MetObjects 11 Object Name_value_fts 27381 1 1  
145 MetObjects 11 Object Name_value_fts_segments 97 0 1  
146 MetObjects 11 Object Name_value_fts_segdir 1 0 1  
147 MetObjects 11 Object Name_value_fts_docsize 27381 0 1  
148 MetObjects 11 Object Name_value_fts_stat 1 0 1 value
149 MetObjects 11 Culture 7132 1 0 value
150 MetObjects 11 Culture_value_fts 7132 1 1  
151 MetObjects 11 Culture_value_fts_segments 27 0 1  
152 MetObjects 11 Culture_value_fts_segdir 1 0 1  
153 MetObjects 11 Culture_value_fts_docsize 7132 0 1  
154 MetObjects 11 Culture_value_fts_stat 1 0 1 value
155 MetObjects 11 Dynasty 348 1 0 value
156 MetObjects 11 Dynasty_value_fts 348 1 1  
157 MetObjects 11 Dynasty_value_fts_segments 2 0 1  
158 MetObjects 11 Dynasty_value_fts_segdir 1 0 1  
159 MetObjects 11 Dynasty_value_fts_docsize 348 0 1  
160 MetObjects 11 Dynasty_value_fts_stat 1 0 1 value
161 MetObjects 11 Reign 366 1 0 value
162 MetObjects 11 Reign_value_fts 366 1 1  
163 MetObjects 11 Reign_value_fts_segments 2 0 1  
164 MetObjects 11 Reign_value_fts_segdir 1 0 1  
165 MetObjects 11 Reign_value_fts_docsize 366 0 1  
166 MetObjects 11 Reign_value_fts_stat 1 0 1 value
167 MetObjects 11 Portfolio 3044 1 0 value
168 MetObjects 11 Portfolio_value_fts 3044 1 1  
169 MetObjects 11 Portfolio_value_fts_segments 27 0 1  
170 MetObjects 11 Portfolio_value_fts_segdir 1 0 1  
171 MetObjects 11 Portfolio_value_fts_docsize 3044 0 1  
172 MetObjects 11 Portfolio_value_fts_stat 1 0 1 value
173 MetObjects 11 Artist Role 6090 1 0 value
174 MetObjects 11 Artist Role_value_fts 6090 1 1  
175 MetObjects 11 Artist Role_value_fts_segments 17 0 1  
176 MetObjects 11 Artist Role_value_fts_segdir 1 0 1  
177 MetObjects 11 Artist Role_value_fts_docsize 6090 0 1  
178 MetObjects 11 Artist Role_value_fts_stat 1 0 1 value
179 MetObjects 11 Artist Alpha Sort 59247 1 0 value
180 MetObjects 11 Artist Alpha Sort_value_fts 59247 1 1  
181 MetObjects 11 Artist Alpha Sort_value_fts_segments 405 0 1  
182 MetObjects 11 Artist Alpha Sort_value_fts_segdir 4 0 1  
183 MetObjects 11 Artist Alpha Sort_value_fts_docsize 59247 0 1  
184 MetObjects 11 Artist Alpha Sort_value_fts_stat 1 0 1 value
185 MetObjects 11 Artist Nationality 3806 1 0 value
186 MetObjects 11 Artist Nationality_value_fts 3806 1 1  
187 MetObjects 11 Artist Nationality_value_fts_segments 14 0 1  
188 MetObjects 11 Artist Nationality_value_fts_segdir 1 0 1  
189 MetObjects 11 Artist Nationality_value_fts_docsize 3806 0 1  
190 MetObjects 11 Artist Nationality_value_fts_stat 1 0 1 value
191 MetObjects 11 Medium 63888 1 0 value
192 MetObjects 11 Medium_value_fts 63888 1 1  
193 MetObjects 11 Medium_value_fts_segments 341 0 1  
194 MetObjects 11 Medium_value_fts_segdir 2 0 1  
195 MetObjects 11 Medium_value_fts_docsize 63888 0 1  
196 MetObjects 11 Medium_value_fts_stat 1 0 1 value
197 MetObjects 11 Geography Type 128 1 0 value
198 MetObjects 11 Geography Type_value_fts 128 1 1  
199 MetObjects 11 Geography Type_value_fts_segments 0 0 1  
200 MetObjects 11 Geography Type_value_fts_segdir 1 0 1  
201 MetObjects 11 Geography Type_value_fts_docsize 128 0 1  
202 MetObjects 11 Geography Type_value_fts_stat 1 0 1 value
203 MetObjects 11 City 2569 1 0 value
204 MetObjects 11 City_value_fts 2569 1 1  
205 MetObjects 11 City_value_fts_segments 8 0 1  
206 MetObjects 11 City_value_fts_segdir 1 0 1  
207 MetObjects 11 City_value_fts_docsize 2569 0 1  
208 MetObjects 11 City_value_fts_stat 1 0 1 value
209 MetObjects 11 State 103 1 0 value
210 MetObjects 11 State_value_fts 103 1 1  
211 MetObjects 11 State_value_fts_segments 0 0 1  
212 MetObjects 11 State_value_fts_segdir 1 0 1  
213 MetObjects 11 State_value_fts_docsize 103 0 1  
214 MetObjects 11 State_value_fts_stat 1 0 1 value
215 MetObjects 11 County 1139 1 0 value
216 MetObjects 11 County_value_fts 1139 1 1  
217 MetObjects 11 County_value_fts_segments 4 0 1  
218 MetObjects 11 County_value_fts_segdir 1 0 1  
219 MetObjects 11 County_value_fts_docsize 1139 0 1  
220 MetObjects 11 County_value_fts_stat 1 0 1 value
221 MetObjects 11 Country 1079 1 0 value
222 MetObjects 11 Country_value_fts 1079 1 1  
223 MetObjects 11 Country_value_fts_segments 4 0 1  
224 MetObjects 11 Country_value_fts_segdir 1 0 1  
225 MetObjects 11 Country_value_fts_docsize 1079 0 1  
226 MetObjects 11 Country_value_fts_stat 1 0 1 value
227 MetObjects 11 Region 788 1 0 value
228 MetObjects 11 Region_value_fts 788 1 1  
229 MetObjects 11 Region_value_fts_segments 3 0 1  
230 MetObjects 11 Region_value_fts_segdir 1 0 1  
231 MetObjects 11 Region_value_fts_docsize 788 0 1  
232 MetObjects 11 Region_value_fts_stat 1 0 1 value
233 MetObjects 11 Subregion 370 1 0 value
234 MetObjects 11 Subregion_value_fts 370 1 1  
235 MetObjects 11 Subregion_value_fts_segments 2 0 1  
236 MetObjects 11 Subregion_value_fts_segdir 1 0 1  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE tables (
            id integer PRIMARY KEY,
            database_id integer,
            name text,
            count integer,
            has_fts integer,
            is_hidden integer,
            label_column text,
            FOREIGN KEY (database_id) REFERENCES databases(id)
        );
Powered by Datasette · Query took 21.575ms