labels

21 rows where category = 2024 and content_string = "Dog"

View and edit SQL

content_string

  • Dog · 21

category

  • 2024 · 21
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
151891 2BE0CB22-929B-463E-B20C-83A518787BB4 310 2024 0 Dog dog  
154671 39333D7D-3020-4A1B-970D-44F2DD6D5C52 310 2024 0 Dog dog  
172641 6D5FD270-8DB3-46AE-8B1E-99C575B2885C 310 2024 0 Dog dog  
366415 B19BB608-7B37-4094-AE9B-504B13660278 310 2024 0 Dog dog  
396309 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 310 2024 0 Dog dog  
397945 A3621F93-93FE-4025-8C7A-ECC62CA9F326 310 2024 0 Dog dog  
399318 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 310 2024 0 Dog dog  
514737 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 310 2024 0 Dog dog  
517558 B1FADEF4-2284-4D74-B306-1ADB41409035 310 2024 0 Dog dog  
568870 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 310 2024 0 Dog dog  
569276 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 310 2024 0 Dog dog  
569825 93C7D5C0-E78B-47A0-8953-9A143D65597D 310 2024 0 Dog dog  
569997 9B076964-9931-4790-AE2D-A06011B97CE7 310 2024 0 Dog dog  
575188 CF759040-2FAD-4203-8C0F-88DF33C894BC 310 2024 0 Dog dog  
627980 50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 310 2024 0 Dog dog  
628767 90D9702F-4A1D-4862-B287-00EB15F3D276 310 2024 0 Dog dog  
629386 C73AB37A-CB52-43B4-900C-C734303BFE72 310 2024 0 Dog dog  
630865 56A360C6-C931-4589-B8A6-D34181EF6C7A 310 2024 0 Dog dog  
635805 1FADC083-2278-4D40-A8A0-45AF6D47458F 310 2024 0 Dog dog  
11162292 BF295F44-7050-4EF5-9D2D-597144A55C46 310 2024 0 Dog dog  
11315663 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 310 2024 0 Dog dog  

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