This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
23732 | 4989D148-E809-4B16-850E-E996339D7224 | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park | |
25098 | 973F76C4-33A5-4ADD-A896-8E9744AB177E | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park | |
65775 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park | |
66642 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park |
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]);