This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11138619 | C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 | 12854 | 2038 | 0 | Rules (restaurant) | rules (restaurant) | |
11138620 | C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 | 12853 | 2038 | 0 | Big Easy | big easy | |
11138621 | C75D24F7-AB72-4E8F-BBBB-A07E77CC5B91 | 12855 | 2038 | 0 | Gourmet Burger Kitchen | gourmet burger kitchen |
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]);