This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
612005 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 19551 | 1015 | 0 | 2015 | 2015 | |
612145 | 3C683CF5-1644-412C-AA01-F6A2EAE58319 | 19551 | 1015 | 0 | 2015 | 2015 | |
612261 | 40AA745C-DB5B-47B8-A6A6-C8C941826009 | 19551 | 1015 | 0 | 2015 | 2015 | |
614442 | B426930E-FED6-4916-BBB9-73934393B5C8 | 19551 | 1015 | 0 | 2015 | 2015 | |
614645 | BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 19551 | 1015 | 0 | 2015 | 2015 | |
11229658 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 19551 | 1015 | 0 | 2015 | 2015 |
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]);