labels

21 rows where category = 1015 and groupid = 16630

View and edit SQL

groupid

  • 16630 · 21

category

  • 1015 · 21
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
482628 07509762-A841-4CEB-AA42-B65439E9C3DD 16630 1015 0 2016 2016  
483250 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 16630 1015 0 2016 2016  
483345 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 16630 1015 0 2016 2016  
484232 69C46054-1D8F-4FD6-ABC7-2369C79921F4 16630 1015 0 2016 2016  
486288 EECDD2BE-E93F-4830-8435-68681476E833 16630 1015 0 2016 2016  
514744 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 16630 1015 0 2016 2016  
517564 B1FADEF4-2284-4D74-B306-1ADB41409035 16630 1015 0 2016 2016  
557368 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 16630 1015 0 2016 2016  
558267 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 16630 1015 0 2016 2016  
559072 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 16630 1015 0 2016 2016  
559963 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 16630 1015 0 2016 2016  
560696 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 16630 1015 0 2016 2016  
568878 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 16630 1015 0 2016 2016  
569285 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 16630 1015 0 2016 2016  
569839 93C7D5C0-E78B-47A0-8953-9A143D65597D 16630 1015 0 2016 2016  
570004 9B076964-9931-4790-AE2D-A06011B97CE7 16630 1015 0 2016 2016  
575195 CF759040-2FAD-4203-8C0F-88DF33C894BC 16630 1015 0 2016 2016  
592160 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 16630 1015 0 2016 2016  
592498 C9AA2D9B-2CC7-43FC-8315-7CB184C5D490 16630 1015 0 2016 2016  
592921 E4D43462-07AB-4803-9DCB-02B8321D8D94 16630 1015 0 2016 2016  
11162303 BF295F44-7050-4EF5-9D2D-597144A55C46 16630 1015 0 2016 2016  

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