labels

3 rows where category = 2027 and normalized_string = "breakfast"

descending

id ▼	uuid	groupid	category	content_string	normalized_string
11104657	B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA	967	2027	Breakfast	breakfast
11372658	A8B386D0-B156-4594-886A-44207E4C0EA8	967	2027	Breakfast	breakfast
11545327	659F6A3E-8547-476F-B2AA-883117C53253	967	2027	Breakfast	breakfast

Advanced export

JSON shape: default, array, newline-delimited, object

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]);