This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11113998 | A421A342-2706-4A6E-B993-38426E52421B | 2581 | 2029 | 0 | Christmas Eve | christmas eve | |
| 11432097 | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 2204 | 2029 | 0 | Martin Luther King, Jr. Day | martin luther king, jr. day | |
| 11575007 | EB0F670F-3DE5-4917-840A-1C84BE9C570D | 5296 | 2029 | 0 | International Day of Friendship | international day of friendship |
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]);