labels

13 rows where category = 12 and content_string = "Mexico"

View and edit SQL

content_string

  • Mexico · 13

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11175137 B0B115AB-2687-46D9-96F5-AC20AFCC2DE3 12066 12 0 Mexico mexico  
11176972 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D 12066 12 0 Mexico mexico  
11193158 A8949702-A151-4ACD-8F3C-D5957F481E5A 12066 12 0 Mexico mexico  
11206630 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 12066 12 0 Mexico mexico  
11236139 DBF7A6F2-B2FF-40F5-9F28-0341ED45C1A6 12066 12 0 Mexico mexico  
11251668 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 12066 12 0 Mexico mexico  
11299931 12BFF8C2-D12C-48D7-B752-EFA7AB1B30AF 12066 12 0 Mexico mexico  
11379606 A945D44B-B701-4FD6-B264-0D4F5683EA2A 12066 12 0 Mexico mexico  
11450862 0CE448B6-E909-49F0-B97C-1F2408D08970 12066 12 0 Mexico mexico  
11471679 2B30643F-7BEC-4E40-8C9F-BF0994C38197 12066 12 0 Mexico mexico  
11497349 7705FF4E-2F25-45B9-B795-EA58244F3273 12066 12 0 Mexico mexico  
11514735 D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 12066 12 0 Mexico mexico  
11543175 D034D20E-18D9-4AD1-9769-370479278F00 12066 12 0 Mexico mexico  

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