This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
381366 | 03BA87C4-E783-44BC-9626-45983800AE72 | 12861 | 1 | 0 | Rosicrucian Egyptian Museum | rosicrucian egyptian museum | |
381575 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 12861 | 1 | 0 | Rosicrucian Egyptian Museum | rosicrucian egyptian museum | |
382597 | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 12861 | 1 | 0 | Rosicrucian Egyptian Museum | rosicrucian egyptian museum |
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]);