labels

241 rows where category = 5

View and edit SQL

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
339274 44477DDB-EA24-427E-ACD0-8EFFAD9D167F 10 5 0 San Francisco san francisco  
339856 6BC8E43D-D175-4C2C-9811-620B706BA25C 10 5 0 San Francisco san francisco  
340120 7C8CA810-91EB-45A1-AFAE-F331714EBA56 10 5 0 San Francisco san francisco  
340764 A488C119-AE20-4F8F-8C37-58B66BAFD78F 10 5 0 San Francisco san francisco  
340890 AE5BD628-AB44-4D2F-A03F-88422F509482 10 5 0 San Francisco san francisco  
341273 C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 10 5 0 San Francisco san francisco  
342125 FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 10 5 0 San Francisco san francisco  
342174 FFD294F1-59BE-4B75-9180-B6318671CDEC 10 5 0 San Francisco san francisco  
366424 B19BB608-7B37-4094-AE9B-504B13660278 10 5 0 San Francisco san francisco  
381364 03BA87C4-E783-44BC-9626-45983800AE72 10418 5 0 San Jose san jose  
381573 0B9B2460-9D4D-421F-92C0-8F0921632AEC 10418 5 0 San Jose san jose  
382595 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 10418 5 0 San Jose san jose  
385933 1EAE7EE2-CBE6-491B-A8EF-337859628659 10 5 0 San Francisco san francisco  
386410 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 10 5 0 San Francisco san francisco  
388570 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 10 5 0 San Francisco san francisco  
388614 AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 10 5 0 San Francisco san francisco  
390009 F142B8D1-24B8-4108-AFB7-0C454C72E625 10 5 0 San Francisco san francisco  
391570 3E20BE4D-619A-42EC-9CAA-6F67508892E4 10 5 0 San Francisco san francisco  
392657 76336F73-88DA-4E89-8E57-4A38FEA2986B 10 5 0 San Francisco san francisco  
393408 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 10 5 0 San Francisco san francisco  
393631 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 10 5 0 San Francisco san francisco  
396318 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 10 5 0 San Francisco san francisco  
397954 A3621F93-93FE-4025-8C7A-ECC62CA9F326 10 5 0 San Francisco san francisco  
399332 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 10 5 0 San Francisco san francisco  
413607 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 1631 5 0 Oakland oakland  
415026 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 1631 5 0 Oakland oakland  
415343 97F0AC20-F45C-40F3-BA5F-66210B77A487 1631 5 0 Oakland oakland  
415704 ADE494D7-0048-491A-B410-D04C5C58B0DD 1631 5 0 Oakland oakland  
438112 1657E7D6-94E7-4344-BCFE-1F924546CE11 10 5 0 San Francisco san francisco  
438410 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 10 5 0 San Francisco san francisco  
439158 57650917-1883-4D73-AD2B-B45C6A661534 10 5 0 San Francisco san francisco  
440930 CECB8318-5241-46BB-AABF-8CF8A3B72890 10 5 0 San Francisco san francisco  
441062 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 10 5 0 San Francisco san francisco  
482634 07509762-A841-4CEB-AA42-B65439E9C3DD 5648 5 5647 Sausalito sausalito  
483256 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 5648 5 5647 Sausalito sausalito  
483351 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 5648 5 5647 Sausalito sausalito  
484238 69C46054-1D8F-4FD6-ABC7-2369C79921F4 5648 5 5647 Sausalito sausalito  
486294 EECDD2BE-E93F-4830-8435-68681476E833 5648 5 5647 Sausalito sausalito  
514749 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 10 5 0 San Francisco san francisco  
517569 B1FADEF4-2284-4D74-B306-1ADB41409035 10 5 0 San Francisco san francisco  
557373 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 5648 5 5647 Sausalito sausalito  
558272 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 5648 5 5647 Sausalito sausalito  
559077 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 5648 5 5647 Sausalito sausalito  
559968 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 5648 5 5647 Sausalito sausalito  
560701 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 5648 5 5647 Sausalito sausalito  
568883 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 10 5 0 San Francisco san francisco  
569290 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 10 5 0 San Francisco san francisco  
569844 93C7D5C0-E78B-47A0-8953-9A143D65597D 10 5 0 San Francisco san francisco  
570009 9B076964-9931-4790-AE2D-A06011B97CE7 10 5 0 San Francisco san francisco  
575200 CF759040-2FAD-4203-8C0F-88DF33C894BC 10 5 0 San Francisco san francisco  
592165 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 10 5 0 San Francisco san francisco  
592926 E4D43462-07AB-4803-9DCB-02B8321D8D94 10 5 0 San Francisco san francisco  
612151 3C683CF5-1644-412C-AA01-F6A2EAE58319 19898 5 19897 Gatlinburg gatlinburg  
628966 AA04E7D2-B517-4CA8-A331-7810A6902E2E 10 5 0 San Francisco san francisco  
635578 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 5665 5 960 Pacifica pacifica  
5385265 70B3C358-DA0D-469F-B667-F0045F445AC6 10 5 0 San Francisco san francisco  
11104678 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 4160 5 2554 Bray bray  
11111840 48576FF3-4790-4A9E-957C-5B7AD552679D 6541 5 0 Cleveland cleveland  
11113420 8B27D87D-8FB6-4251-9E6A-68540AC7532B 8355 5 8354 Vancouver vancouver  
11114025 A421A342-2706-4A6E-B993-38426E52421B 8364 5 8363 McMinnville mcminnville  
11116985 14B6764F-C911-4A53-8A56-28D1DE9F634A 10 5 0 San Francisco san francisco  
11122792 0D23847A-0863-4F18-938A-9839C8E28B91 4929 5 2558 Westminster westminster  
11129758 48EECE84-27A5-4AEC-9B09-6173F8700CEA 4929 5 2558 Westminster westminster  
11129971 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 4929 5 2558 Westminster westminster  
11132243 A91633D1-A015-4857-AFD6-C27279445751 10 5 0 San Francisco san francisco  
11132749 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 10 5 0 San Francisco san francisco  
11132998 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 10 5 0 San Francisco san francisco  
11135629 6274A881-9445-44D6-9E7C-776DAEF1C603 4929 5 2558 Westminster westminster  
11135891 6CE10468-228C-4110-AB0B-663558FCF258 4929 5 2558 Westminster westminster  
11136755 8876C417-C39E-453A-A865-2A997A6DAAF0 4929 5 2558 Westminster westminster  
11137541 A5E3DEAF-E22B-454C-9543-CF68191F349A 4929 5 2558 Westminster westminster  
11138127 B78C4087-CE43-411C-AEAF-16C585DF6D67 4929 5 2558 Westminster westminster  
11138605 C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 4929 5 2558 Westminster westminster  
11138634 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 4929 5 2558 Westminster westminster  
11145040 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 4929 5 2558 Westminster westminster  
11145460 F6F45595-4033-4C79-A9F9-86DCA9088C37 4929 5 2558 Westminster westminster  
11147712 60198E20-708E-4125-B793-4466A87B2DDA 10 5 0 San Francisco san francisco  
11148925 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 10 5 0 San Francisco san francisco  
11156440 D735F0CE-A3D7-49CB-B83E-594604415A1C 10 5 0 San Francisco san francisco  
11156993 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 10 5 0 San Francisco san francisco  
11157015 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 10 5 0 San Francisco san francisco  
11162308 BF295F44-7050-4EF5-9D2D-597144A55C46 10 5 0 San Francisco san francisco  
11186418 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 4857 5 4856 Paris paris  
11201243 FE1BAAE9-C33D-4933-88F0-9BCDA86F2D5B 11010 5 0 Mendoza mendoza  
11215077 DD6E4630-85BD-41BF-A7B3-524C02942A65 7187 5 2964 Lancaster lancaster  
11219416 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 4477 5 4476 Slidell slidell  
11229663 062B182C-CD24-4EC8-8E27-420EECB14688 4954 5 2558 Camden camden  
11238683 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 4477 5 4476 Slidell slidell  
11239954 F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 21469 5 4525 Stowford stowford  
11247596 13A4ED05-8B7F-4F49-A613-3B916B11555E 11061 5 10466 Felton felton  
11251654 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2969 5 0 Los Angeles los angeles  
11272917 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 947 5 0 New Orleans new orleans  
11276017 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 1596 5 960 Pescadero pescadero  
11276298 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 947 5 0 New Orleans new orleans  
11277080 745C8ADF-08E9-48D1-98A7-01D16E49635C 1596 5 960 Pescadero pescadero  
11282746 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 21469 5 4525 Stowford stowford  
11293568 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 4946 5 2533 Amesbury amesbury  
11300605 43E95407-6F45-460A-830E-079C0F149D67 947 5 0 New Orleans new orleans  
11301340 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 2550 5 0 Sidmouth sidmouth  
11315671 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 10 5 0 San Francisco san francisco  

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