This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11194387 | 14DB49A6-91E2-4F08-A51A-8AE01FC04F78 | 1 | 2020 | 0 | Home | home | |
| 11289537 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 1 | 2020 | 0 | Home | home | |
| 11315649 | 8735875A-1DBA-47EA-A36D-5E5ACC2CF77B | 1 | 2020 | 0 | Home | home | |
| 11380394 | D8019570-7130-477F-BDBD-199593CEC553 | 1 | 2020 | 0 | Home | home | |
| 11396328 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 1 | 2020 | 0 | Home | home | |
| 11467533 | 2C109667-F30E-4231-AC69-9EA681E53E68 | 1 | 2020 | 0 | Home | home | |
| 11506395 | BF2AFBD2-0A38-4101-AAAC-DD1B3FBF26CC | 1 | 2020 | 0 | Home | home |
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]);