labels

10 rows where category = 2027 and normalized_string = "hiking"

View and edit SQL

normalized_string

  • hiking · 10

category

  • 2027 · 10
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11215059 DD6E4630-85BD-41BF-A7B3-524C02942A65 2205 2027 0 Hiking hiking  
11219051 054B7914-B69B-4902-8F52-08CF6621BA5C 2205 2027 0 Hiking hiking  
11269992 7E21418A-1A30-43AB-B025-4D6576EA29CE 2205 2027 0 Hiking hiking  
11365155 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 2205 2027 0 Hiking hiking  
11422931 151812CC-3A4F-4023-B7B6-286EC7E222E9 2205 2027 0 Hiking hiking  
11423104 22351C00-1D6D-4B74-A13D-D25B8056C967 2205 2027 0 Hiking hiking  
11432099 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD 2205 2027 0 Hiking hiking  
11464461 594803D0-A127-49C5-9488-138742894DB0 2205 2027 0 Hiking hiking  
11533542 7243AA57-2BA0-446E-8ED2-5C4709A272FE 2205 2027 0 Hiking hiking  
11540132 1B036D9A-1FF2-48C2-94CF-2D78AA0A294B 2205 2027 0 Hiking hiking  

Advanced export

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

CSV options:

CREATE TABLE [labels] (
   [id] INTEGER PRIMARY KEY,
   [uuid] TEXT,
   [groupid] INTEGER,
   [category] INTEGER,
   [owning_groupid] INTEGER,
   [content_string] TEXT,
   [normalized_string] TEXT,
   [lookup_identifier] TEXT
);
CREATE INDEX [idx_labels_uuid]
                ON [labels] ([uuid]);
CREATE INDEX [idx_labels_normalized_string]
                ON [labels] ([normalized_string]);
Powered by Datasette · Query took 15.843ms · About: dogsheep/dogsheep-photos