labels

15 rows where category = 1014 and normalized_string = "october"

View and edit SQL

normalized_string

  • october · 15

category

  • 1014 · 15
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
53755 9ABD9958-31BE-4B9D-9480-7E3342B601FD 3778 1014 0 October october  
391564 3E20BE4D-619A-42EC-9CAA-6F67508892E4 3778 1014 0 October october  
392650 76336F73-88DA-4E89-8E57-4A38FEA2986B 3778 1014 0 October october  
393401 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 3778 1014 0 October october  
393624 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 3778 1014 0 October october  
396312 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 3778 1014 0 October october  
397948 A3621F93-93FE-4025-8C7A-ECC62CA9F326 3778 1014 0 October october  
399326 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 3778 1014 0 October october  
612004 369683A6-C32A-4E2D-9492-25BD553B1B6E 3778 1014 0 October october  
612144 3C683CF5-1644-412C-AA01-F6A2EAE58319 3778 1014 0 October october  
612260 40AA745C-DB5B-47B8-A6A6-C8C941826009 3778 1014 0 October october  
614441 B426930E-FED6-4916-BBB9-73934393B5C8 3778 1014 0 October october  
614644 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 3778 1014 0 October october  
624982 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 3778 1014 0 October october  
11111833 48576FF3-4790-4A9E-957C-5B7AD552679D 3778 1014 0 October october  

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