This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11116973 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 1626 | 2039 | 0 | Performing Arts | performing arts | |
11132231 | A91633D1-A015-4857-AFD6-C27279445751 | 1626 | 2039 | 0 | Performing Arts | performing arts | |
11132737 | C2CA0ADD-619E-4955-B88D-B5C7CB3005EB | 1626 | 2039 | 0 | Performing Arts | performing arts | |
11132986 | C72BFA8A-CE27-403A-B0C3-83D20CF6EB3C | 1626 | 2039 | 0 | Performing Arts | performing arts |
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]);