This data as json, CSV (advanced)
id | uuid | groupid | category | owning_groupid | content_string ▼ | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
11215059 | DD6E4630-85BD-41BF-A7B3-524C02942A65 | 2205 | 2027 | 0 | Hiking | hiking | |
11219051 | 054B7914-B69B-4902-8F52-08CF6621BA5C | 2205 | 2027 | 0 | Hiking | hiking | |
11269992 | 7E21418A-1A30-43AB-B025-4D6576EA29CE | 2205 | 2027 | 0 | Hiking | hiking | |
11365155 | 9A7D9C6D-9566-4DAF-BDF6-84DE9FFAC1E1 | 2205 | 2027 | 0 | Hiking | hiking | |
11422931 | 151812CC-3A4F-4023-B7B6-286EC7E222E9 | 2205 | 2027 | 0 | Hiking | hiking | |
11423104 | 22351C00-1D6D-4B74-A13D-D25B8056C967 | 2205 | 2027 | 0 | Hiking | hiking | |
11432099 | 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD | 2205 | 2027 | 0 | Hiking | hiking | |
11464461 | 594803D0-A127-49C5-9488-138742894DB0 | 2205 | 2027 | 0 | Hiking | hiking | |
11533542 | 7243AA57-2BA0-446E-8ED2-5C4709A272FE | 2205 | 2027 | 0 | Hiking | hiking | |
11540132 | 1B036D9A-1FF2-48C2-94CF-2D78AA0A294B | 2205 | 2027 | 0 | Hiking | hiking |
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]);