This data as json, CSV (advanced)
id | uuid | groupid | category | owning_groupid | content_string | normalized_string ▼ | lookup_identifier |
---|---|---|---|---|---|---|---|
11186415 | D15F85D9-D70A-4182-AC30-BCA0EA2AF542 | 4854 | 12 | 0 | France | france | |
11329944 | 903AEA63-4A86-4092-A52E-3DBAC94E1CBF | 4854 | 12 | 0 | France | france | |
11374444 | 410DD7AF-B97A-4508-9240-B2B0F55DC2FD | 4854 | 12 | 0 | France | france | |
11440732 | 910061FF-8B93-4DF6-8580-F61F3AF655AC | 4854 | 12 | 0 | France | france | |
11500611 | 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 | 4854 | 12 | 0 | France | france | |
11517967 | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 4854 | 12 | 0 | France | france |
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]);