This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11496844 | 5BD1D973-19F4-48F1-AB13-A214B0B98452 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11502090 | A8B85D87-3E69-402E-A1EA-3DD819270531 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11506403 | BF2AFBD2-0A38-4101-AAAC-DD1B3FBF26CC | 5 | 1015 | 0 | 2020 | 2020 | |
| 11509613 | 82A06650-7B8E-4201-B971-3DE78335B82C | 5 | 1015 | 0 | 2020 | 2020 | |
| 11516620 | 5677D0CE-249B-4A35-BAF8-385BFC257924 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11519141 | EA3A8FC2-1DB9-4906-B822-6FF0EABF625F | 5 | 1015 | 0 | 2020 | 2020 | |
| 11522284 | 92BCC6F0-0144-4501-A78D-778B3E48BF39 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11540330 | 2693563F-47A0-44FB-8AAA-5C550F793ACF | 5 | 1015 | 0 | 2020 | 2020 | |
| 11549016 | 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11551484 | F367069B-2C5A-4C2E-BFCE-29AE79C72E73 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11552601 | 3A19DB48-E962-4B82-9E26-57BDA6F34B8C | 5 | 1015 | 0 | 2020 | 2020 | |
| 11568778 | 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11571041 | BB3FF61C-1AE0-4B7F-AD0E-822267EE277A | 5 | 1015 | 0 | 2020 | 2020 |
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]);