labels

235 rows where category = 7

View and edit SQL

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
339162 3C7116A2-1C14-450A-84AB-4109C7D719AA 9 7 0 San Francisco san francisco  
339273 44477DDB-EA24-427E-ACD0-8EFFAD9D167F 9 7 0 San Francisco san francisco  
339855 6BC8E43D-D175-4C2C-9811-620B706BA25C 9 7 0 San Francisco san francisco  
340119 7C8CA810-91EB-45A1-AFAE-F331714EBA56 9 7 0 San Francisco san francisco  
340763 A488C119-AE20-4F8F-8C37-58B66BAFD78F 9 7 0 San Francisco san francisco  
340889 AE5BD628-AB44-4D2F-A03F-88422F509482 9 7 0 San Francisco san francisco  
341272 C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 9 7 0 San Francisco san francisco  
342124 FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 9 7 0 San Francisco san francisco  
342173 FFD294F1-59BE-4B75-9180-B6318671CDEC 9 7 0 San Francisco san francisco  
366423 B19BB608-7B37-4094-AE9B-504B13660278 9 7 0 San Francisco san francisco  
381362 03BA87C4-E783-44BC-9626-45983800AE72 951 7 8 Santa Clara santa clara  
381571 0B9B2460-9D4D-421F-92C0-8F0921632AEC 951 7 8 Santa Clara santa clara  
382593 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 951 7 8 Santa Clara santa clara  
385932 1EAE7EE2-CBE6-491B-A8EF-337859628659 9 7 0 San Francisco san francisco  
386409 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 9 7 0 San Francisco san francisco  
388569 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 9 7 0 San Francisco san francisco  
388613 AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 9 7 0 San Francisco san francisco  
390008 F142B8D1-24B8-4108-AFB7-0C454C72E625 9 7 0 San Francisco san francisco  
391569 3E20BE4D-619A-42EC-9CAA-6F67508892E4 9 7 0 San Francisco san francisco  
392656 76336F73-88DA-4E89-8E57-4A38FEA2986B 9 7 0 San Francisco san francisco  
393407 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 9 7 0 San Francisco san francisco  
393630 AC4419FA-ED22-473F-8FB0-15B647BB2FBD 9 7 0 San Francisco san francisco  
396317 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 9 7 0 San Francisco san francisco  
397953 A3621F93-93FE-4025-8C7A-ECC62CA9F326 9 7 0 San Francisco san francisco  
399331 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 9 7 0 San Francisco san francisco  
413606 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 1630 7 0 Alameda alameda  
415025 82A5EDE6-0455-46D5-82C4-0FF4E355D8FC 1630 7 0 Alameda alameda  
415342 97F0AC20-F45C-40F3-BA5F-66210B77A487 1630 7 0 Alameda alameda  
415703 ADE494D7-0048-491A-B410-D04C5C58B0DD 1630 7 0 Alameda alameda  
438111 1657E7D6-94E7-4344-BCFE-1F924546CE11 9 7 0 San Francisco san francisco  
438409 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 9 7 0 San Francisco san francisco  
439157 57650917-1883-4D73-AD2B-B45C6A661534 9 7 0 San Francisco san francisco  
440929 CECB8318-5241-46BB-AABF-8CF8A3B72890 9 7 0 San Francisco san francisco  
441061 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 9 7 0 San Francisco san francisco  
482633 07509762-A841-4CEB-AA42-B65439E9C3DD 5647 7 0 Marin marin  
483255 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 5647 7 0 Marin marin  
483350 2DA58E9D-038C-49B2-ABCB-2185E57E8F68 5647 7 0 Marin marin  
484237 69C46054-1D8F-4FD6-ABC7-2369C79921F4 5647 7 0 Marin marin  
486293 EECDD2BE-E93F-4830-8435-68681476E833 5647 7 0 Marin marin  
514748 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 9 7 0 San Francisco san francisco  
517568 B1FADEF4-2284-4D74-B306-1ADB41409035 9 7 0 San Francisco san francisco  
557372 40CFDB12-709C-4A22-BB3B-C17A6672C1E7 5647 7 0 Marin marin  
558271 5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B 5647 7 0 Marin marin  
559076 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 5647 7 0 Marin marin  
559967 A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7 5647 7 0 Marin marin  
560700 D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54 5647 7 0 Marin marin  
568882 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 9 7 0 San Francisco san francisco  
569289 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 9 7 0 San Francisco san francisco  
569843 93C7D5C0-E78B-47A0-8953-9A143D65597D 9 7 0 San Francisco san francisco  
570008 9B076964-9931-4790-AE2D-A06011B97CE7 9 7 0 San Francisco san francisco  
575199 CF759040-2FAD-4203-8C0F-88DF33C894BC 9 7 0 San Francisco san francisco  
592164 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 9 7 0 San Francisco san francisco  
592925 E4D43462-07AB-4803-9DCB-02B8321D8D94 9 7 0 San Francisco san francisco  
612150 3C683CF5-1644-412C-AA01-F6A2EAE58319 19897 7 19896 Sevier sevier  
628965 AA04E7D2-B517-4CA8-A331-7810A6902E2E 9 7 0 San Francisco san francisco  
635577 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 960 7 0 San Mateo san mateo  
5385264 70B3C358-DA0D-469F-B667-F0045F445AC6 9 7 0 San Francisco san francisco  
11104677 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 2554 7 2532 Windsor and Maidenhead windsor and maidenhead  
11111838 48576FF3-4790-4A9E-957C-5B7AD552679D 6540 7 0 Cuyahoga cuyahoga  
11113419 8B27D87D-8FB6-4251-9E6A-68540AC7532B 8354 7 8353 Clark clark  
11114024 A421A342-2706-4A6E-B993-38426E52421B 8363 7 6544 Yamhill yamhill  
11116984 14B6764F-C911-4A53-8A56-28D1DE9F634A 9 7 0 San Francisco san francisco  
11122791 0D23847A-0863-4F18-938A-9839C8E28B91 2558 7 0 London london  
11129757 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2558 7 0 London london  
11129970 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 2558 7 0 London london  
11132242 A91633D1-A015-4857-AFD6-C27279445751 9 7 0 San Francisco san francisco  
11132748 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 9 7 0 San Francisco san francisco  
11132997 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 9 7 0 San Francisco san francisco  
11135628 6274A881-9445-44D6-9E7C-776DAEF1C603 2558 7 0 London london  
11135890 6CE10468-228C-4110-AB0B-663558FCF258 2558 7 0 London london  
11136754 8876C417-C39E-453A-A865-2A997A6DAAF0 2558 7 0 London london  
11137540 A5E3DEAF-E22B-454C-9543-CF68191F349A 2558 7 0 London london  
11138126 B78C4087-CE43-411C-AEAF-16C585DF6D67 2558 7 0 London london  
11138604 C6E6907A-2118-47E3-A696-CFF7F0B4CC3F 2558 7 0 London london  
11138633 C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 2558 7 0 London london  
11145039 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2558 7 0 London london  
11145459 F6F45595-4033-4C79-A9F9-86DCA9088C37 2558 7 0 London london  
11147711 60198E20-708E-4125-B793-4466A87B2DDA 9 7 0 San Francisco san francisco  
11148924 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 9 7 0 San Francisco san francisco  
11156439 D735F0CE-A3D7-49CB-B83E-594604415A1C 9 7 0 San Francisco san francisco  
11156992 F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 9 7 0 San Francisco san francisco  
11157014 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 9 7 0 San Francisco san francisco  
11162307 BF295F44-7050-4EF5-9D2D-597144A55C46 9 7 0 San Francisco san francisco  
11186417 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 4856 7 4855 Paris paris  
11215076 DD6E4630-85BD-41BF-A7B3-524C02942A65 2964 7 8 Los Angeles los angeles  
11219415 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 4476 7 945 St. Tammany st. tammany  
11229662 062B182C-CD24-4EC8-8E27-420EECB14688 2558 7 0 London london  
11238682 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 4476 7 945 St. Tammany st. tammany  
11239953 F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 4525 7 0 West Devon west devon  
11247595 13A4ED05-8B7F-4F49-A613-3B916B11555E 10466 7 8 Santa Cruz santa cruz  
11251653 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2964 7 8 Los Angeles los angeles  
11272915 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 946 7 945 Orleans orleans  
11276016 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 960 7 0 San Mateo san mateo  
11276296 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 946 7 945 Orleans orleans  
11277079 745C8ADF-08E9-48D1-98A7-01D16E49635C 960 7 0 San Mateo san mateo  
11282745 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 4525 7 0 West Devon west devon  
11293567 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A 2533 7 2532 Wiltshire wiltshire  
11300604 43E95407-6F45-460A-830E-079C0F149D67 946 7 945 Orleans orleans  
11301339 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 4239 7 2532 East Devon east devon  
11315670 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 9 7 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 6.64ms · About: dogsheep/dogsheep-photos