labels

1,968 rows where category = 2024 sorted by normalized_string descending

View and edit SQL

category

  • 2024 · 1,968
id uuid groupid category owning_groupid content_string normalized_string ▲ lookup_identifier
11500604 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 348 2024 0 Window window  
11492704 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 348 2024 0 Window window  
11229654 062B182C-CD24-4EC8-8E27-420EECB14688 348 2024 0 Window window  
11104667 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 348 2024 0 Window window  
633661 61139074-357E-4DB6-B179-0DA87E0BA367 348 2024 0 Window window  
392648 76336F73-88DA-4E89-8E57-4A38FEA2986B 348 2024 0 Window window  
381346 03BA87C4-E783-44BC-9626-45983800AE72 348 2024 0 Window window  
342165 FFD294F1-59BE-4B75-9180-B6318671CDEC 348 2024 0 Window window  
339261 44477DDB-EA24-427E-ACD0-8EFFAD9D167F 348 2024 0 Window window  
145740 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 348 2024 0 Window window  
65766 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 348 2024 0 Window window  
625822 920D2FF3-BB4B-458A-B4B7-42D961777959 1228 2024 0 Whisk whisk  
486285 EECDD2BE-E93F-4830-8435-68681476E833 1818 2024 0 Wheel wheel  
630867 56A360C6-C931-4589-B8A6-D34181EF6C7A 2008 2024 0 Weimaraner weimaraner  
11352115 E6BE07D8-2034-485F-9362-F9E0EC53453A 528 2024 0 Watercraft watercraft  
630182 100F0542-94D4-43F8-9C76-7D93589E3E09 528 2024 0 Watercraft watercraft  
11568770 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 415 2024 0 Water Body water body  
11496835 5BD1D973-19F4-48F1-AB13-A214B0B98452 415 2024 0 Water Body water body  
11484798 5896CD82-A625-4414-9D39-25EFE6E848C1 415 2024 0 Water Body water body  
11450856 0CE448B6-E909-49F0-B97C-1F2408D08970 415 2024 0 Water Body water body  
11379598 A945D44B-B701-4FD6-B264-0D4F5683EA2A 415 2024 0 Water Body water body  
11309147 B2D7A748-4171-43EA-8561-917E3A1007D4 415 2024 0 Water Body water body  
11292885 0C053200-BD3D-4E69-B987-97D9027357B6 415 2024 0 Water Body water body  
630186 100F0542-94D4-43F8-9C76-7D93589E3E09 415 2024 0 Water Body water body  
53298 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 415 2024 0 Water Body water body  
15383 A05FA28C-4192-4430-A597-21FC5A10BEEE 415 2024 0 Water Body water body  
14617 68C635B0-7852-48E4-B3A6-72A86E9D9927 415 2024 0 Water Body water body  
11568771 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 339 2024 0 Water water  
11496836 5BD1D973-19F4-48F1-AB13-A214B0B98452 339 2024 0 Water water  
11484797 5896CD82-A625-4414-9D39-25EFE6E848C1 339 2024 0 Water water  
11450855 0CE448B6-E909-49F0-B97C-1F2408D08970 339 2024 0 Water water  
11379597 A945D44B-B701-4FD6-B264-0D4F5683EA2A 339 2024 0 Water water  
11328103 111A61B2-82D2-4D3D-8B38-7D6C4806C604 339 2024 0 Water water  
11322750 8482D147-E926-4B79-9264-533A31F5DF2D 339 2024 0 Water water  
11309149 B2D7A748-4171-43EA-8561-917E3A1007D4 339 2024 0 Water water  
11292884 0C053200-BD3D-4E69-B987-97D9027357B6 339 2024 0 Water water  
11176965 232FAC16-A5A7-4CF0-9E01-2B6DAE88795D 339 2024 0 Water water  
630185 100F0542-94D4-43F8-9C76-7D93589E3E09 339 2024 0 Water water  
560692 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 339 2024 0 Water water  
557365 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 339 2024 0 Water water  
53299 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 339 2024 0 Water water  
15385 A05FA28C-4192-4430-A597-21FC5A10BEEE 339 2024 0 Water water  
14622 68C635B0-7852-48E4-B3A6-72A86E9D9927 339 2024 0 Water water  
11545332 659F6A3E-8547-476F-B2AA-883117C53253 304 2024 0 Vehicle vehicle  
11492707 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 304 2024 0 Vehicle vehicle  
11365157 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 304 2024 0 Vehicle vehicle  
11352114 E6BE07D8-2034-485F-9362-F9E0EC53453A 304 2024 0 Vehicle vehicle  
11114011 A421A342-2706-4A6E-B993-38426E52421B 304 2024 0 Vehicle vehicle  
633887 74A39A6F-13E4-464D-9597-C6FCC1688D29 304 2024 0 Vehicle vehicle  
633651 61139074-357E-4DB6-B179-0DA87E0BA367 304 2024 0 Vehicle vehicle  
630181 100F0542-94D4-43F8-9C76-7D93589E3E09 304 2024 0 Vehicle vehicle  
624979 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 304 2024 0 Vehicle vehicle  
486281 EECDD2BE-E93F-4830-8435-68681476E833 304 2024 0 Vehicle vehicle  
145747 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 304 2024 0 Vehicle vehicle  
11219405 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 1329 2024 0 Vegetation vegetation  
11157006 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 1329 2024 0 Vegetation vegetation  
11147703 60198E20-708E-4125-B793-4466A87B2DDA 1329 2024 0 Vegetation vegetation  
11421560 B2F26E79-7A85-497E-AD2F-D599633EA720 381 2024 0 Vegetable vegetable  
628725 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 7343 2024 0 Vacuum vacuum  
628041 52E83D4D-36AA-465B-818C-307DE872BF95 288 2024 0 Utensil utensil  
627090 0C9E4525-4A55-463C-ADC3-6A3A56113ABD 288 2024 0 Utensil utensil  
625821 920D2FF3-BB4B-458A-B4B7-42D961777959 288 2024 0 Utensil utensil  
11219055 054B7914-B69B-4902-8F52-08CF6621BA5C 17309 2024 0 Tulip tulip  
11532416 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 1253 2024 0 Trophy trophy  
11194391 14DB49A6-91E2-4F08-A51A-8AE01FC04F78 2257 2024 0 Tripod tripod  
11538273 A34D9C15-11C6-488C-9E3C-910401A65132 1328 2024 0 Tree tree  
11532892 4FB52292-60F3-429B-971F-4843A2BD51B4 1328 2024 0 Tree tree  
11374125 277A0A26-444D-4384-8C97-794E66861E96 1328 2024 0 Tree tree  
11219404 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 1328 2024 0 Tree tree  
381344 03BA87C4-E783-44BC-9626-45983800AE72 1328 2024 0 Tree tree  
11215067 DD6E4630-85BD-41BF-A7B3-524C02942A65 1882 2024 0 Trail trail  
441052 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 1882 2024 0 Trail trail  
439147 57650917-1883-4D73-AD2B-B45C6A661534 1882 2024 0 Trail trail  
11380396 D8019570-7130-477F-BDBD-199593CEC553 409 2024 0 Toy toy  
632366 E14B53F1-B1B6-46E7-9871-FCB4ED1D1A85 409 2024 0 Toy toy  
612142 3C683CF5-1644-412C-AA01-F6A2EAE58319 409 2024 0 Toy toy  
517561 B1FADEF4-2284-4D74-B306-1ADB41409035 409 2024 0 Toy toy  
321623 F3DAB898-0907-410B-B796-9999D8E773A7 409 2024 0 Toy toy  
321143 D6E497F5-7F93-4434-96D4-7927D358886A 409 2024 0 Toy toy  
320821 CC3EF420-EAC4-4661-8D68-C2009F892C04 409 2024 0 Toy toy  
320706 C4953733-B5AE-4410-B654-834DABC67F07 409 2024 0 Toy toy  
320256 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 409 2024 0 Toy toy  
319909 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 409 2024 0 Toy toy  
319833 84CA3880-9BC5-4FF0-9416-8AF1800985EC 409 2024 0 Toy toy  
319820 8338977E-56F0-4A7D-A6FD-33C2B27C9364 409 2024 0 Toy toy  
319631 7A635293-467F-4C79-A04D-68A1C0250EB7 409 2024 0 Toy toy  
319557 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC 409 2024 0 Toy toy  
631530 9D52CBF1-ACD2-45B4-B3EB-A3D37C098D40 2681 2024 0 Tower tower  
486282 EECDD2BE-E93F-4830-8435-68681476E833 352 2024 0 Tool tool  
483246 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 352 2024 0 Tool tool  
486278 EECDD2BE-E93F-4830-8435-68681476E833 1817 2024 0 Tire tire  
558264 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 5493 2024 0 Timepiece timepiece  
482621 07509762-A841-4CEB-AA42-B65439E9C3DD 5800 2024 0 Telescope telescope  
628042 52E83D4D-36AA-465B-818C-307DE872BF95 287 2024 0 Tableware tableware  
627081 0C9E4525-4A55-463C-ADC3-6A3A56113ABD 287 2024 0 Tableware tableware  
11382757 7E07EFBF-1F63-4142-8856-7DCD9F906811 331 2024 0 Table table  
11104669 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 331 2024 0 Table table  
627098 0CEC9F87-56B8-4E82-885D-CE573A5A6733 331 2024 0 Table table  
392641 76336F73-88DA-4E89-8E57-4A38FEA2986B 331 2024 0 Table table  
339074 346ACDE4-6BD5-4C40-916B-04184921FAFA 331 2024 0 Table table  

Next page

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