This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11147698 | 60198E20-708E-4125-B793-4466A87B2DDA | 1637 | 2027 | 0 | Dinner | dinner | |
11148908 | 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F | 1637 | 2027 | 0 | Dinner | dinner | |
11156423 | D735F0CE-A3D7-49CB-B83E-594604415A1C | 1637 | 2027 | 0 | Dinner | dinner | |
11156976 | F19B5D7D-EFD0-4BE6-B335-CBE309FABB41 | 1637 | 2027 | 0 | Dinner | dinner | |
11156998 | F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 | 1637 | 2027 | 0 | Dinner | dinner |
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]);