labels

16 rows where category = 3 and owning_groupid = 10

View and edit SQL

Suggested facets: groupid, content_string, normalized_string

owning_groupid

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
64250 B03FB29E-EB36-434D-91D2-C6A2C625A252 2160 3 10 Castro castro  
151901 2BE0CB22-929B-463E-B20C-83A518787BB4 11 3 10 Hayes Valley hayes valley  
396319 4BCA66D4-BF92-4060-BF82-85FAEF3033C9 985 3 10 Outer Richmond outer richmond  
397955 A3621F93-93FE-4025-8C7A-ECC62CA9F326 985 3 10 Outer Richmond outer richmond  
399333 F78D8339-34E9-4A9A-9BF8-6A73F52566EE 985 3 10 Outer Richmond outer richmond  
568884 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 993 3 10 Japantown japantown  
569291 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 993 3 10 Japantown japantown  
569845 93C7D5C0-E78B-47A0-8953-9A143D65597D 993 3 10 Japantown japantown  
570010 9B076964-9931-4790-AE2D-A06011B97CE7 993 3 10 Japantown japantown  
592166 B3EDB403-A948-4ABA-BFE4-2C504A636F7A 2190 3 10 Tenderloin tenderloin  
592927 E4D43462-07AB-4803-9DCB-02B8321D8D94 2190 3 10 Tenderloin tenderloin  
11116986 14B6764F-C911-4A53-8A56-28D1DE9F634A 11592 3 10 Balboa Terrace balboa terrace  
11132244 A91633D1-A015-4857-AFD6-C27279445751 11592 3 10 Balboa Terrace balboa terrace  
11132750 C2CA0ADD-619E-4955-B88D-B5C7CB3005EB 11592 3 10 Balboa Terrace balboa terrace  
11132999 C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C 11592 3 10 Balboa Terrace balboa terrace  
11315672 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B 11 3 10 Hayes Valley hayes valley  

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