This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11186416 | D15F85D9-D70A-4182-AC30-BCA0EA2AF542 | 4855 | 10 | 4854 | Île-de-France | ile-de-france | |
| 11329945 | 903AEA63-4A86-4092-A52E-3DBAC94E1CBF | 4855 | 10 | 4854 | Île-de-France | ile-de-france | |
| 11374445 | 410DD7AF-B97A-4508-9240-B2B0F55DC2FD | 4855 | 10 | 4854 | Île-de-France | ile-de-france | |
| 11440733 | 910061FF-8B93-4DF6-8580-F61F3AF655AC | 4855 | 10 | 4854 | Île-de-France | ile-de-france | |
| 11500612 | 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 | 4855 | 10 | 4854 | Île-de-France | ile-de-france | |
| 11517968 | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 4855 | 10 | 4854 | Île-de-France | ile-de-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]);