This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11215076 | DD6E4630-85BD-41BF-A7B3-524C02942A65 | 2964 | 7 | 8 | Los Angeles | los angeles | |
11251653 | 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 | 2964 | 7 | 8 | Los Angeles | los angeles | |
11422944 | 151812CC-3A4F-4023-B7B6-286EC7E222E9 | 2964 | 7 | 8 | Los Angeles | los angeles | |
11438727 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2964 | 7 | 8 | Los Angeles | los angeles |
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]);