labels

11 rows where category = 1 and normalized_string = "ano nuevo coast natural preserve"

View and edit SQL

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11276018 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11277081 745C8ADF-08E9-48D1-98A7-01D16E49635C 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11322759 8482D147-E926-4B79-9264-533A31F5DF2D 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11352644 0BE49C93-2ACC-4628-9C12-99566921EE00 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11413320 B5AC8228-D496-43B3-9F69-69BFB2BFF177 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11423128 22ADB1EE-854B-43F0-96D1-32CB598C0738 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11461754 AEFB3049-40B6-41FD-81AA-571B369B79DB 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11462685 EF60300F-550E-4921-BA04-EA972EEFF269 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11496850 5BD1D973-19F4-48F1-AB13-A214B0B98452 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11502096 A8B85D87-3E69-402E-A1EA-3DD819270531 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  
11516626 5677D0CE-249B-4A35-BAF8-385BFC257924 1597 1 1596 Año Nuevo Coast Natural Preserve ano nuevo coast natural preserve  

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