labels

5 rows where category = 2027 and normalized_string = "dinner"

View and edit SQL

normalized_string

  • dinner · 5

category

  • 2027 · 5
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11147698 60198E20-708E-4125-B793-4466A87B2DDA 1637 2027 0 Dinner dinner  
11148908 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 1637 2027 0 Dinner dinner  
11156423 D735F0CE-A3D7-49CB-B83E-594604415A1C 1637 2027 0 Dinner dinner  
11156976 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 1637 2027 0 Dinner dinner  
11156998 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 1637 2027 0 Dinner dinner  

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