labels

12 rows where category = 10 and content_string = "Louisiana"

View and edit SQL

content_string

  • Louisiana · 12

category

id ▼ uuid groupid category owning_groupid content_string normalized_string lookup_identifier
11219414 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 945 10 0 Louisiana louisiana  
11238681 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 945 10 0 Louisiana louisiana  
11272914 4C86821D-5061-4FAC-8CF9-CBCCA1ED4D55 945 10 0 Louisiana louisiana  
11276295 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 945 10 0 Louisiana louisiana  
11300603 43E95407-6F45-460A-830E-079C0F149D67 945 10 0 Louisiana louisiana  
11338086 F9F1DAD8-0DEC-4272-A0E5-39517811AF71 945 10 0 Louisiana louisiana  
11341796 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 945 10 0 Louisiana louisiana  
11382771 7E07EFBF-1F63-4142-8856-7DCD9F906811 945 10 0 Louisiana louisiana  
11484807 5896CD82-A625-4414-9D39-25EFE6E848C1 945 10 0 Louisiana louisiana  
11508779 46BAA089-F20D-40E3-8161-5C0FA28FAA90 945 10 0 Louisiana louisiana  
11538281 A34D9C15-11C6-488C-9E3C-910401A65132 945 10 0 Louisiana louisiana  
11563369 DA8753B5-BAFA-4A34-8DB6-7AC49AB86A6D 945 10 0 Louisiana louisiana  

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