labels

3 rows where category = 5 and owning_groupid = 10466

View and edit SQL

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11247596 13A4ED05-8B7F-4F49-A613-3B916B11555E 11061 5 10466 Felton felton  
11492716 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 11061 5 10466 Felton felton  
11565301 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 11061 5 10466 Felton felton  

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 48.162ms · About: dogsheep/dogsheep-photos