This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11219415 | 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 | 4476 | 7 | 945 | St. Tammany | st. tammany | |
11238682 | 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 | 4476 | 7 | 945 | St. Tammany | st. tammany | |
11341797 | 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 | 4476 | 7 | 945 | St. Tammany | st. tammany | |
11484808 | 5896CD82-A625-4414-9D39-25EFE6E848C1 | 4476 | 7 | 945 | St. Tammany | st. tammany | |
11538282 | A34D9C15-11C6-488C-9E3C-910401A65132 | 4476 | 7 | 945 | St. Tammany | st. tammany |
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]);