labels

45 rows where category = 1014 and normalized_string = "november"

View and edit SQL

normalized_string

  • november · 10

category

  • 1014 · 10
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
385927 1EAE7EE2-CBE6-491B-A8EF-337859628659 2961 1014 0 November november  
386404 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 2961 1014 0 November november  
388564 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 2961 1014 0 November november  
388608 AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 2961 1014 0 November november  
390003 F142B8D1-24B8-4108-AFB7-0C454C72E625 2961 1014 0 November november  
482627 07509762-A841-4CEB-AA42-B65439E9C3DD 2961 1014 0 November november  
483249 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2961 1014 0 November november  
483344 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 2961 1014 0 November november  
484231 69C46054-1D8F-4FD6-ABC7-2369C79921F4 2961 1014 0 November november  
486287 EECDD2BE-E93F-4830-8435-68681476E833 2961 1014 0 November november  

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