This data as json, CSV (advanced)
Suggested facets: groupid, content_string, normalized_string, lookup_identifier
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 64244 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 193 | 2021 | 0 | Simon Willison | simon willison | 000B9B44-5E9D-4D2F-81E3-4FDFEA05ADC8 |
| 5385483 | 17AF724E-5561-4DF0-877F-DE60DBBBA8B9 | 52 | 2021 | 0 | Natalie Downe | natalie downe | 01B4C24C-BD73-4E11-AD2D-2901E90D3F7C |
| 11338082 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 52 | 2021 | 0 | Natalie Downe | natalie downe | 01B4C24C-BD73-4E11-AD2D-2901E90D3F7C |
| 11532421 | 28933E0F-FEFC-498F-9F5D-873E0E48B1B9 | 52 | 2021 | 0 | Natalie Downe | natalie downe | 01B4C24C-BD73-4E11-AD2D-2901E90D3F7C |
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]);