This data as json, CSV (advanced)
id | uuid | groupid | category | owning_groupid ▼ | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11104657 | B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA | 967 | 2027 | 0 | Breakfast | breakfast | |
11372658 | A8B386D0-B156-4594-886A-44207E4C0EA8 | 967 | 2027 | 0 | Breakfast | breakfast | |
11545327 | 659F6A3E-8547-476F-B2AA-883117C53253 | 967 | 2027 | 0 | Breakfast | breakfast |
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]);