labels

39 rows where category = 1014 and normalized_string = "august"

View and edit SQL

normalized_string

  • august · 39

category

  • 1014 · 39
id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11186412 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 4851 1014 0 August august  
11195166 538AC784-D7C1-4C11-8957-CFBAE86052DF 4851 1014 0 August august  
11211884 FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 4851 1014 0 August august  
11230911 6560AE2B-6571-400C-AE36-5249A5F7940D 4851 1014 0 August august  
11240831 379BF280-6D24-43EF-9DB2-0E497D08DD34 4851 1014 0 August august  
11252775 8D169BB8-BF13-4FE9-8196-10DA495ABA01 4851 1014 0 August august  
11258681 31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8 4851 1014 0 August august  
11262781 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 4851 1014 0 August august  
11265251 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 4851 1014 0 August august  
11268408 090FA0A0-01B9-4375-B319-C0712E6E2AAD 4851 1014 0 August august  
11269014 3295CB6A-D459-45C2-8E45-9FBBDCF80266 4851 1014 0 August august  
11281059 A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3 4851 1014 0 August august  
11287703 929CB2CD-A08E-43B2-AD9F-4B0FC40D9F34 4851 1014 0 August august  
11310295 FCBB3E33-8FF9-4811-B242-729555B01F28 4851 1014 0 August august  
11329941 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 4851 1014 0 August august  
11335004 0F308AB5-4F16-4C67-A84E-310F85B63E4E 4851 1014 0 August august  
11351554 B9265412-3353-4812-8BBA-E6FF72DC5718 4851 1014 0 August august  
11367530 411AAEA4-5064-4007-B18E-72D0E1111E59 4851 1014 0 August august  
11374441 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 4851 1014 0 August august  
11380170 CBDD4423-FA49-434C-907E-A6B49EF038B3 4851 1014 0 August august  
11391017 E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F 4851 1014 0 August august  
11421562 B2F26E79-7A85-497E-AD2F-D599633EA720 4851 1014 0 August august  
11427429 3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 4851 1014 0 August august  
11430585 071DED2E-2D2A-4519-A47A-FC37916025F1 4851 1014 0 August august  
11440729 910061FF-8B93-4DF6-8580-F61F3AF655AC 4851 1014 0 August august  
11443046 18939B2A-0A75-461C-B1D0-7ABD87282C2D 4851 1014 0 August august  
11456942 7CB33AD0-0953-4440-93D1-E1E67A227D7B 4851 1014 0 August august  
11471636 2A621F4B-A826-437E-91A4-6A0597D08134 4851 1014 0 August august  
11472161 4353C1BC-259D-4814-B113-8E5DBA65470D 4851 1014 0 August august  
11474362 C7714BF0-9654-4D2D-A5A4-032901EC2419 4851 1014 0 August august  
11477242 A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 4851 1014 0 August august  
11499073 E8D76832-D18D-461D-B6D4-33E7A1299297 4851 1014 0 August august  
11500608 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 4851 1014 0 August august  
11503670 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D 4851 1014 0 August august  
11509951 9A5B4E0C-DBD8-49C4-878A-F692E92CABE3 4851 1014 0 August august  
11517964 A3697779-FE08-47A2-A0F1-F72E5F253A9A 4851 1014 0 August august  
11543974 109A0EAD-3A58-4EFA-B2B4-AB59BA66D0F6 4851 1014 0 August august  
11551250 E4CFFA69-E229-42A9-B46B-83932303F2D4 4851 1014 0 August august  
11572930 54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE 4851 1014 0 August august  

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