This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11239954 | F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 | 21469 | 5 | 4525 | Stowford | stowford | |
11282746 | 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 | 21469 | 5 | 4525 | Stowford | stowford | |
11420770 | 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC | 21469 | 5 | 4525 | Stowford | stowford | |
11570473 | 9420279A-6AF4-4998-B882-499A10CC0937 | 21469 | 5 | 4525 | Stowford | stowford |
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]);