This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11247595 | 13A4ED05-8B7F-4F49-A613-3B916B11555E | 10466 | 7 | 8 | Santa Cruz | santa cruz | |
| 11492715 | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 10466 | 7 | 8 | Santa Cruz | santa cruz | |
| 11565300 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 10466 | 7 | 8 | Santa Cruz | santa cruz |
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]);