labels

18 rows where category = 2024 and groupid = 3545

View and edit SQL

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
334978 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 3545 2024 0 Skull skull  
335982 55679037-0DCE-469C-A1B2-1ADD537FA1A6 3545 2024 0 Skull skull  
336220 62F1FD9A-238A-48F0-A160-D8161D869C62 3545 2024 0 Skull skull  
336270 64497F20-E0C5-4705-AF2E-3138AEF78655 3545 2024 0 Skull skull  
336609 7A98496A-6D5F-4DE6-AD5D-E39097D7596D 3545 2024 0 Skull skull  
336840 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 3545 2024 0 Skull skull  
336857 8E749F41-CDCA-439E-835F-14053B963103 3545 2024 0 Skull skull  
336975 978E05B3-A903-4F27-A219-92603A4880B5 3545 2024 0 Skull skull  
337015 9AC32575-E912-415A-B8B4-337F609BE59D 3545 2024 0 Skull skull  
337102 A14342D2-8636-440D-BE26-FE49B0D74CEE 3545 2024 0 Skull skull  
337252 A9E26555-0DE9-4416-8C3E-54992AF7AB10 3545 2024 0 Skull skull  
337298 AFA5F010-1F6E-4DFE-AC2B-4CFA07C9B231 3545 2024 0 Skull skull  
337562 BE2B51A3-13CC-4D1F-B5D5-759928A0B613 3545 2024 0 Skull skull  
337872 D382083C-7911-43C1-92C6-851050CD2A85 3545 2024 0 Skull skull  
337978 DA6D5F58-3726-4C96-9E0B-9C6097A56582 3545 2024 0 Skull skull  
338144 E59AB8B3-7305-4E25-85C9-820169986138 3545 2024 0 Skull skull  
338294 F6D98A32-C5E8-4C04-A876-8D316F22B319 3545 2024 0 Skull skull  
339096 3545F3EF-615B-4178-A146-9121E629DE90 3545 2024 0 Skull skull  

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