labels

107 rows where category = 1

View and edit SQL

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11516626 5677D0CE-249B-4A35-BAF8-385BFC257924 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11517973 A3697779-FE08-47A2-A0F1-F72E5F253A9A 4867 1 0 Musée des Arts et Métiers musee des arts et metiers  
11517974 A3697779-FE08-47A2-A0F1-F72E5F253A9A 4868 1 0 Conservatoire National Des Arts & Métiers conservatoire national des arts & metiers  
11526993 CE0B0837-963E-4427-8C83-23D6DC01DFEC 7175 1 7174 Cabazon Dinosaurs cabazon dinosaurs  
11532429 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 2949 1 0 Bank of England Museum bank of england museum  
11552608 3A19DB48-E962-4B82-9E26-57BDA6F34B8C 2168 1 2167 Año Nuevo State Park ano nuevo state park  
11563374 DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D 4494 1 4493 Southern Food & Beverage Museum southern food & beverage museum  

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