This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 52480 | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 951 | 7 | 8 | Santa Clara | santa clara | |
| 53760 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 951 | 7 | 8 | Santa Clara | santa clara | |
| 381362 | 03BA87C4-E783-44BC-9626-45983800AE72 | 951 | 7 | 8 | Santa Clara | santa clara | |
| 381571 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 951 | 7 | 8 | Santa Clara | santa clara | |
| 382593 | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 951 | 7 | 8 | Santa Clara | santa clara |
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]);