labels

4 rows where category = 2 and normalized_string = "post st"

descending

id ▼	uuid	groupid	category	content_string	normalized_string
568886	57EAA6E6-990D-45CF-842D-E0DD2CE521A3	1376	2	Post St	post st
569293	6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C	1376	2	Post St	post st
569847	93C7D5C0-E78B-47A0-8953-9A143D65597D	1376	2	Post St	post st
570012	9B076964-9931-4790-AE2D-A06011B97CE7	1376	2	Post St	post st

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