labels

73 rows where category = 1014 and normalized_string = "april"

View and edit SQL

normalized_string

  • april · 31

category

  • 1014 · 31
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
557367 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 4 1014 0 April april  
558266 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 4 1014 0 April april  
559071 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 4 1014 0 April april  
559962 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 4 1014 0 April april  
560695 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 4 1014 0 April april  
568877 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 4 1014 0 April april  
569284 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 4 1014 0 April april  
569838 93C7D5C0-E78B-47A0-8953-9A143D65597D 4 1014 0 April april  
570003 9B076964-9931-4790-AE2D-A06011B97CE7 4 1014 0 April april  
625807 8E150DC5-5E6A-4286-9110-44501EC99304 4 1014 0 April april  
625812 8FB56C6C-6557-43E8-AC87-EF6E54F7F346 4 1014 0 April april  
625817 91CFD354-BAD6-4367-9146-B5E214F7AED7 4 1014 0 April april  
625824 920D2FF3-BB4B-458A-B4B7-42D961777959 4 1014 0 April april  
626148 AC1D606E-185E-4B60-8213-782BE58B9DCE 4 1014 0 April april  
626623 DD2793EA-51C4-4196-AB34-12A665ACFF43 4 1014 0 April april  
627094 0C9E4525-4A55-463C-ADC3-6A3A56113ABD 4 1014 0 April april  
627102 0CEC9F87-56B8-4E82-885D-CE573A5A6733 4 1014 0 April april  
627659 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 4 1014 0 April april  
627986 50572BE9-4D25-4D5E-8C39-9C413FEAB7FE 4 1014 0 April april  
628048 52E83D4D-36AA-465B-818C-307DE872BF95 4 1014 0 April april  
628728 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 4 1014 0 April april  
628772 90D9702F-4A1D-4862-B287-00EB15F3D276 4 1014 0 April april  
628960 AA04E7D2-B517-4CA8-A331-7810A6902E2E 4 1014 0 April april  
629306 C0A58C86-B004-4413-855B-12A697F129D6 4 1014 0 April april  
629392 C73AB37A-CB52-43B4-900C-C734303BFE72 4 1014 0 April april  
630295 196FC9A9-00A1-4BD8-A215-59D8D8883690 4 1014 0 April april  
631281 7CAA23AF-5955-4DDD-9166-A7D332AEB893 4 1014 0 April april  
631741 A89C9F68-C6D7-4761-A4D3-3FEDBC1D6017 4 1014 0 April april  
632369 E14B53F1-B1B6-46E7-9871-FCB4ED1D1A85 4 1014 0 April april  
11162302 BF295F44-7050-4EF5-9D2D-597144A55C46 4 1014 0 April april  
11380401 D8019570-7130-477F-BDBD-199593CEC553 4 1014 0 April april  

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