labels

6 rows where normalized_string = 2015

View and edit SQL

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
612005 369683A6-C32A-4E2D-9492-25BD553B1B6E 19551 1015 0 2015 2015  
612145 3C683CF5-1644-412C-AA01-F6A2EAE58319 19551 1015 0 2015 2015  
612261 40AA745C-DB5B-47B8-A6A6-C8C941826009 19551 1015 0 2015 2015  
614442 B426930E-FED6-4916-BBB9-73934393B5C8 19551 1015 0 2015 2015  
614645 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 19551 1015 0 2015 2015  
11229658 062B182C-CD24-4EC8-8E27-420EECB14688 19551 1015 0 2015 2015  

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