labels

235 rows where category = 7 sorted by content_string

View and edit SQL

Suggested facets: groupid, owning_groupid, content_string, normalized_string

category

id uuid groupid category owning_groupid content_string ▼ normalized_string lookup_identifier
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  
11113419 8B27D87D-8FB6-4251-9E6A-68540AC7532B 8354 7 8353 Clark clark  
11111838 48576FF3-4790-4A9E-957C-5B7AD552679D 6540 7 0 Cuyahoga cuyahoga  
11301339 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 4239 7 2532 East Devon east devon  
11409382 BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 4239 7 2532 East Devon east devon  
11365170 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 7190 7 8 Kern kern  
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  
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  
11229662 062B182C-CD24-4EC8-8E27-420EECB14688 2558 7 0 London london  
11349790 45CD64EE-9C93-48EA-89F8-8F9C849543F6 2558 7 0 London london  
11372670 A8B386D0-B156-4594-886A-44207E4C0EA8 2558 7 0 London london  
11532425 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 2558 7 0 London london  
11545339 659F6A3E-8547-476F-B2AA-883117C53253 2558 7 0 London london  
11215076 DD6E4630-85BD-41BF-A7B3-524C02942A65 2964 7 8 Los Angeles los angeles  
11251653 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2964 7 8 Los Angeles los angeles  
11422944 151812CC-3A4F-4023-B7B6-286EC7E222E9 2964 7 8 Los Angeles los angeles  
11438727 090F6409-3525-4789-A369-CB5290CA68E0 2964 7 8 Los Angeles los angeles  
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  
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  
11272915 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 946 7 945 Orleans orleans  
11276296 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 946 7 945 Orleans orleans  
11300604 43E95407-6F45-460A-830E-079C0F149D67 946 7 945 Orleans orleans  
11338087 F9F1DAD8-0DEC-4272-A0E5-39517811AF71 946 7 945 Orleans orleans  
11382772 7E07EFBF-1F63-4142-8856-7DCD9F906811 946 7 945 Orleans orleans  
11508780 46BAA089-F20D-40E3-8161-5C0FA28FAA90 946 7 945 Orleans orleans  
11563370 DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D 946 7 945 Orleans orleans  
11186417 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 4856 7 4855 Paris paris  
11329946 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 4856 7 4855 Paris paris  
11374446 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 4856 7 4855 Paris paris  
11440734 910061FF-8B93-4DF6-8580-F61F3AF655AC 4856 7 4855 Paris paris  
11500613 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 4856 7 4855 Paris paris  
11517969 A3697779-FE08-47A2-A0F1-F72E5F253A9A 4856 7 4855 Paris paris  
11480311 43A4A851-4821-4125-A673-C1E9FCF2F9AC 2179 7 0 Sacramento sacramento  
64248 B03FB29E-EB36-434D-91D2-C6A2C625A252 9 7 0 San Francisco san francisco  
145756 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 9 7 0 San Francisco san francisco  
151899 2BE0CB22-929B-463E-B20C-83A518787BB4 9 7 0 San Francisco san francisco  
210464 40C65283-9CB3-4FAE-A390-4FDC22BCC29F 9 7 0 San Francisco san francisco  
212510 C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 9 7 0 San Francisco san francisco  
334953 011CE4D0-49CE-46BA-B506-D1B4C3745778 9 7 0 San Francisco san francisco  
334986 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 9 7 0 San Francisco san francisco  
335064 05F7112C-C7CE-4866-8964-29C94481B135 9 7 0 San Francisco san francisco  
335150 0E41A645-44E6-4251-BFDD-456129BC8849 9 7 0 San Francisco san francisco  
335385 2489642F-D29D-47EC-918A-63D1E2CEDF98 9 7 0 San Francisco san francisco  
335648 3A952955-7B08-4DEE-809D-C08685BDC3BF 9 7 0 San Francisco san francisco  
335672 3BE3193F-45AF-4787-B445-A6260393657C 9 7 0 San Francisco san francisco  
335831 499ABED7-CDCD-4A72-B9FD-21DD54B6008F 9 7 0 San Francisco san francisco  
335989 55679037-0DCE-469C-A1B2-1ADD537FA1A6 9 7 0 San Francisco san francisco  
336083 5C55FD14-1786-4136-9026-FBBFFD74C4E3 9 7 0 San Francisco san francisco  
336228 62F1FD9A-238A-48F0-A160-D8161D869C62 9 7 0 San Francisco san francisco  
336280 64497F20-E0C5-4705-AF2E-3138AEF78655 9 7 0 San Francisco san francisco  
336492 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C 9 7 0 San Francisco san francisco  
336617 7A98496A-6D5F-4DE6-AD5D-E39097D7596D 9 7 0 San Francisco san francisco  
336682 8331EEF1-9BBD-4F19-82BC-D3C1598AE23A 9 7 0 San Francisco san francisco  
336851 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 9 7 0 San Francisco san francisco  
336867 8E749F41-CDCA-439E-835F-14053B963103 9 7 0 San Francisco san francisco  
336920 9468663F-697C-4833-BBEA-9756226529DB 9 7 0 San Francisco san francisco  
336940 94FA185C-0ED1-47C5-80F3-71BFDE7F280A 9 7 0 San Francisco san francisco  
336984 978E05B3-A903-4F27-A219-92603A4880B5 9 7 0 San Francisco san francisco  
337025 9AC32575-E912-415A-B8B4-337F609BE59D 9 7 0 San Francisco san francisco  
337111 A14342D2-8636-440D-BE26-FE49B0D74CEE 9 7 0 San Francisco san francisco  
337184 A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 9 7 0 San Francisco san francisco  
337197 A5F7470B-9015-4627-B3D1-3CD07B8A4587 9 7 0 San Francisco san francisco  
337210 A6C2C9FE-D032-450F-B0FC-AF6191226FA9 9 7 0 San Francisco san francisco  
337260 A9E26555-0DE9-4416-8C3E-54992AF7AB10 9 7 0 San Francisco san francisco  
337293 ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 9 7 0 San Francisco san francisco  
337306 AFA5F010-1F6E-4DFE-AC2B-4CFA07C9B231 9 7 0 San Francisco san francisco  
337476 B6387674-6F2C-43D6-9B8F-FE44DF4E2FB0 9 7 0 San Francisco san francisco  
337501 BB4A90B3-D3CA-4E17-B54E-C736B625DDA7 9 7 0 San Francisco san francisco  
337557 BDB6EAE2-6466-411E-B51C-7829B8405E97 9 7 0 San Francisco san francisco  
337570 BE2B51A3-13CC-4D1F-B5D5-759928A0B613 9 7 0 San Francisco san francisco  
337625 C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A 9 7 0 San Francisco san francisco  
337656 C27C5D9A-2461-411A-BB8B-E26B50B84EED 9 7 0 San Francisco san francisco  
337879 D382083C-7911-43C1-92C6-851050CD2A85 9 7 0 San Francisco san francisco  
337925 D5731038-247C-482A-942D-CD75A0824FA6 9 7 0 San Francisco san francisco  
337986 DA6D5F58-3726-4C96-9E0B-9C6097A56582 9 7 0 San Francisco san francisco  
338151 E59AB8B3-7305-4E25-85C9-820169986138 9 7 0 San Francisco san francisco  
338215 EA45776D-2CCA-41EB-A0C4-CCF0D416720C 9 7 0 San Francisco san francisco  
338301 F6D98A32-C5E8-4C04-A876-8D316F22B319 9 7 0 San Francisco san francisco  
338448 05D17529-1F2A-4F49-8EE5-A70A31666D62 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 46.216ms · About: dogsheep/dogsheep-photos