labels

24 rows where category = 1014 and normalized_string = "march"

View and edit SQL

normalized_string

  • march · 24

category

  • 1014 · 24
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
172644 6D5FD270-8DB3-46AE-8B1E-99C575B2885C 188 1014 0 March march  
438106 1657E7D6-94E7-4344-BCFE-1F924546CE11 188 1014 0 March march  
438404 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 188 1014 0 March march  
439152 57650917-1883-4D73-AD2B-B45C6A661534 188 1014 0 March march  
440924 CECB8318-5241-46BB-AABF-8CF8A3B72890 188 1014 0 March march  
441056 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 188 1014 0 March march  
575194 CF759040-2FAD-4203-8C0F-88DF33C894BC 188 1014 0 March march  
11116979 14B6764F-C911-4A53-8A56-28D1DE9F634A 188 1014 0 March march  
11132237 A91633D1-A015-4857-AFD6-C27279445751 188 1014 0 March march  
11132743 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 188 1014 0 March march  
11132992 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 188 1014 0 March march  
11215071 DD6E4630-85BD-41BF-A7B3-524C02942A65 188 1014 0 March march  
11219057 054B7914-B69B-4902-8F52-08CF6621BA5C 188 1014 0 March march  
11270002 7E21418A-1A30-43AB-B025-4D6576EA29CE 188 1014 0 March march  
11365165 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 188 1014 0 March march  
11374129 277A0A26-444D-4384-8C97-794E66861E96 188 1014 0 March march  
11422939 151812CC-3A4F-4023-B7B6-286EC7E222E9 188 1014 0 March march  
11423109 22351C00-1D6D-4B74-A13D-D25B8056C967 188 1014 0 March march  
11438722 090F6409-3525-4789-A369-CB5290CA68E0 188 1014 0 March march  
11464464 594803D0-A127-49C5-9488-138742894DB0 188 1014 0 March march  
11526986 CE0B0837-963E-4427-8C83-23D6DC01DFEC 188 1014 0 March march  
11533550 7243AA57-2BA0-446E-8ED2-5C4709A272FE 188 1014 0 March march  
11540138 1B036D9A-1FF2-48C2-94CF-2D78AA0A294B 188 1014 0 March march  
11548419 2C4C0C9B-AF5C-4F0F-BE45-9C70E7A4A898 188 1014 0 March march  

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