labels

5 rows where owning_groupid = 951

View and edit SQL

Suggested facets: groupid, category, content_string, normalized_string

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
52481 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 6297 5 951 East Palo Alto east palo alto  
53761 9ABD9958-31BE-4B9D-9480-7E3342B601FD 952 5 951 Stanford stanford  
381363 03BA87C4-E783-44BC-9626-45983800AE72 25023 6 951 Shasta Hanchett Park shasta hanchett park  
381572 0B9B2460-9D4D-421F-92C0-8F0921632AEC 25023 6 951 Shasta Hanchett Park shasta hanchett park  
382594 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 25023 6 951 Shasta Hanchett Park shasta hanchett park  

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