This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11116971 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 1625 | 2039 | 0 | Arts & Entertainment | arts & entertainment | |
11116972 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 7466 | 2039 | 0 | Event Services | event services | |
11116973 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 1626 | 2039 | 0 | Performing Arts | performing arts | |
11116974 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 7464 | 2039 | 0 | Venue & Event Space | venue & event space | |
11116975 | 14B6764F-C911-4A53-8A56-28D1DE9F634A | 2523 | 2039 | 0 | Museum | 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]);