labels

123 rows where category = 1014 and normalized_string = "february"

View and edit SQL

normalized_string

  • february · 23

category

  • 1014 · 23
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11434918 16243B99-6AFB-4401-9E29-90CAFB201343 977 1014 0 February february  
11440324 7885377D-DA52-436F-A3B7-803C7E3A1EAC 977 1014 0 February february  
11448203 620F538F-0190-4AD6-8EAA-9E274EC04BD7 977 1014 0 February february  
11450859 0CE448B6-E909-49F0-B97C-1F2408D08970 977 1014 0 February february  
11459590 365D28C9-AF11-425E-A648-3C3479A5CDE4 977 1014 0 February february  
11466645 E77313F1-D351-4F1C-85BA-7D88CCE26FE7 977 1014 0 February february  
11471676 2B30643F-7BEC-4E40-8C9F-BF0994C38197 977 1014 0 February february  
11478942 F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 977 1014 0 February february  
11489617 A25F2FB5-0F1A-4D15-812A-6A05493B8B1B 977 1014 0 February february  
11497346 7705FF4E-2F25-45B9-B795-EA58244F3273 977 1014 0 February february  
11514732 D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 977 1014 0 February february  
11517275 7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 977 1014 0 February february  
11523146 E2378A42-70B5-42A2-B8D8-CFE99DBCE627 977 1014 0 February february  
11527040 D034B554-9E55-4646-AE6D-D80CB5027AC5 977 1014 0 February february  
11530202 9C0E4F98-A2A8-45F8-8078-792720435621 977 1014 0 February february  
11533125 5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E 977 1014 0 February february  
11543172 D034D20E-18D9-4AD1-9769-370479278F00 977 1014 0 February february  
11545853 8A4D8382-B56E-4B87-8185-3702FA3AC0CF 977 1014 0 February february  
11546559 BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 977 1014 0 February february  
11547600 FC705948-B3D8-4B7A-90A6-E617B3ED80F6 977 1014 0 February february  
11550744 C04ECCFD-2679-4E64-823F-290C47A16396 977 1014 0 February february  
11554340 A9CC4A89-22E0-42B3-8026-B07334120C45 977 1014 0 February february  
11559388 E2880EC4-C3B5-46E6-B555-C78CF75895C2 977 1014 0 February february  

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