labels

3 rows where category = 3 and owning_groupid = 11061

descending

id ▼	uuid	groupid	category	owning_groupid	content_string	normalized_string
11247597	13A4ED05-8B7F-4F49-A613-3B916B11555E	11062	3	11061	South Felton	south felton
11492717	5392047B-DF94-46CF-BA61-06ECE4D8CD9E	11062	3	11061	South Felton	south felton
11565302	4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C	11062	3	11061	South Felton	south felton

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