labels

5 rows where category = 3 and owning_groupid = 5648

descending

id ▼	uuid	groupid	category	owning_groupid	content_string	normalized_string
557374	40CFDB12-709C-4A22-BB3B-C17A6672C1E7	6266	3	5648	Marinship	marinship
558273	5EEC9ED6-BD95-4B4F-B364-DCCB49144A9B	6266	3	5648	Marinship	marinship
559078	82B5CEE0-0DCB-4E73-84BC-2536F0676B06	6266	3	5648	Marinship	marinship
559969	A9A5BE5B-A2FA-4224-A26D-6CE3A1AC02C7	6266	3	5648	Marinship	marinship
560702	D3AECF29-CF9B-4CA0-8A6D-39D21CFA3D54	6266	3	5648	Marinship	marinship

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