This data as json, CSV (advanced)
| id ▲ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 212514 | C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 | 1025 | 1 | 0 | Golden Gate Park | golden gate park | |
| 212513 | C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 | 8720 | 1 | 0 | San Francisco Botanical Garden | san francisco botanical garden | |
| 210468 | 40C65283-9CB3-4FAE-A390-4FDC22BCC29F | 1025 | 1 | 0 | Golden Gate Park | golden gate park | |
| 210467 | 40C65283-9CB3-4FAE-A390-4FDC22BCC29F | 8720 | 1 | 0 | San Francisco Botanical Garden | san francisco botanical garden | |
| 53764 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 954 | 1 | 0 | Stanford University | stanford university | |
| 53763 | 9ABD9958-31BE-4B9D-9480-7E3342B601FD | 3782 | 1 | 0 | Cecil H. Green Library | cecil h. green library | |
| 52483 | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 3815 | 1 | 0 | Baylands Nature Preserve | baylands nature preserve |
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]);