This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
392653 | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 15496 | 14 | 0 | San Francisco Bay | san francisco bay | |
393404 | 9FAD352B-5A8E-4A93-B84D-5EB5D0A6C409 | 15496 | 14 | 0 | San Francisco Bay | san francisco bay | |
393627 | AC4419FA-ED22-473F-8FB0-15B647BB2FBD | 15496 | 14 | 0 | San Francisco Bay | san francisco bay |
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]);