This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 321655 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 7 | 12 | 0 | United States | united states | |
| 321656 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 8 | 10 | 7 | California | california | |
| 321657 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 960 | 7 | 0 | San Mateo | san mateo | |
| 321658 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 11311 | 5 | 960 | Burlingame | burlingame | |
| 321659 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 11312 | 3 | 11311 | Downtown Burlingame | downtown burlingame | |
| 321660 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 11313 | 2 | 11312 | California Dr | california dr | |
| 334944 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 2 | 2046 | 0 | Live Photos | live photos | |
| 334945 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 286 | 2024 | 0 | People | people | |
| 334946 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 3616 | 2024 | 0 | Skeleton | skeleton | |
| 334947 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 976 | 2030 | 0 | Winter | winter | |
| 334948 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 977 | 1014 | 0 | February | february | |
| 334949 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 334950 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 17681 | 2056 | 0 | IMG_3235.HEIC | img_3235.heic | |
| 334951 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 7 | 12 | 0 | United States | united states | |
| 334952 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 8 | 10 | 7 | California | california | |
| 334953 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 9 | 7 | 0 | San Francisco | san francisco | |
| 334954 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 10 | 5 | 0 | San Francisco | san francisco | |
| 334955 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 334956 | 011CE4D0-49CE-46BA-B506-D1B4C3745778 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 334977 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 2 | 2046 | 0 | Live Photos | live photos | |
| 334978 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 3545 | 2024 | 0 | Skull | skull | |
| 334979 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 286 | 2024 | 0 | People | people | |
| 334980 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 976 | 2030 | 0 | Winter | winter | |
| 334981 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 977 | 1014 | 0 | February | february | |
| 334982 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 334983 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 17837 | 2056 | 0 | IMG_3190.HEIC | img_3190.heic | |
| 334984 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 7 | 12 | 0 | United States | united states | |
| 334985 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 8 | 10 | 7 | California | california | |
| 334986 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 9 | 7 | 0 | San Francisco | san francisco | |
| 334987 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 10 | 5 | 0 | San Francisco | san francisco | |
| 334988 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 334989 | 0173EE6B-1D43-4B54-B6DF-F9542D40BFE4 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335057 | 05F7112C-C7CE-4866-8964-29C94481B135 | 2 | 2046 | 0 | Live Photos | live photos | |
| 335058 | 05F7112C-C7CE-4866-8964-29C94481B135 | 976 | 2030 | 0 | Winter | winter | |
| 335059 | 05F7112C-C7CE-4866-8964-29C94481B135 | 977 | 1014 | 0 | February | february | |
| 335060 | 05F7112C-C7CE-4866-8964-29C94481B135 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335061 | 05F7112C-C7CE-4866-8964-29C94481B135 | 17539 | 2056 | 0 | IMG_3256.HEIC | img_3256.heic | |
| 335062 | 05F7112C-C7CE-4866-8964-29C94481B135 | 7 | 12 | 0 | United States | united states | |
| 335063 | 05F7112C-C7CE-4866-8964-29C94481B135 | 8 | 10 | 7 | California | california | |
| 335064 | 05F7112C-C7CE-4866-8964-29C94481B135 | 9 | 7 | 0 | San Francisco | san francisco | |
| 335065 | 05F7112C-C7CE-4866-8964-29C94481B135 | 10 | 5 | 0 | San Francisco | san francisco | |
| 335066 | 05F7112C-C7CE-4866-8964-29C94481B135 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335067 | 05F7112C-C7CE-4866-8964-29C94481B135 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335139 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 2 | 2046 | 0 | Live Photos | live photos | |
| 335140 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 350 | 2024 | 0 | Interior Room | interior room | |
| 335141 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 340 | 2024 | 0 | Clothing | clothing | |
| 335142 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 2842 | 2024 | 0 | Footwear | footwear | |
| 335143 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 2843 | 2024 | 0 | Shoes | shoes | |
| 335144 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 976 | 2030 | 0 | Winter | winter | |
| 335145 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 977 | 1014 | 0 | February | february | |
| 335146 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335147 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 17891 | 2056 | 0 | IMG_3212.HEIC | img_3212.heic | |
| 335148 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 7 | 12 | 0 | United States | united states | |
| 335149 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 8 | 10 | 7 | California | california | |
| 335150 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 9 | 7 | 0 | San Francisco | san francisco | |
| 335151 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 10 | 5 | 0 | San Francisco | san francisco | |
| 335152 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335153 | 0E41A645-44E6-4251-BFDD-456129BC8849 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335377 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 161 | 2055 | 0 | Favorites | favorites | |
| 335378 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 2 | 2046 | 0 | Live Photos | live photos | |
| 335379 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 976 | 2030 | 0 | Winter | winter | |
| 335380 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 977 | 1014 | 0 | February | february | |
| 335381 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335382 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 17554 | 2056 | 0 | IMG_3247.HEIC | img_3247.heic | |
| 335383 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 7 | 12 | 0 | United States | united states | |
| 335384 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 8 | 10 | 7 | California | california | |
| 335385 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 9 | 7 | 0 | San Francisco | san francisco | |
| 335386 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 10 | 5 | 0 | San Francisco | san francisco | |
| 335387 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335388 | 2489642F-D29D-47EC-918A-63D1E2CEDF98 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335636 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 161 | 2055 | 0 | Favorites | favorites | |
| 335637 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 2 | 2046 | 0 | Live Photos | live photos | |
| 335638 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 2843 | 2024 | 0 | Shoes | shoes | |
| 335639 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 2841 | 2024 | 0 | Sneaker | sneaker | |
| 335640 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 340 | 2024 | 0 | Clothing | clothing | |
| 335641 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 2842 | 2024 | 0 | Footwear | footwear | |
| 335642 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 976 | 2030 | 0 | Winter | winter | |
| 335643 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 977 | 1014 | 0 | February | february | |
| 335644 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335645 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 17627 | 2056 | 0 | IMG_3214.HEIC | img_3214.heic | |
| 335646 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 7 | 12 | 0 | United States | united states | |
| 335647 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 8 | 10 | 7 | California | california | |
| 335648 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 9 | 7 | 0 | San Francisco | san francisco | |
| 335649 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 10 | 5 | 0 | San Francisco | san francisco | |
| 335650 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335651 | 3A952955-7B08-4DEE-809D-C08685BDC3BF | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335665 | 3BE3193F-45AF-4787-B445-A6260393657C | 161 | 2055 | 0 | Favorites | favorites | |
| 335666 | 3BE3193F-45AF-4787-B445-A6260393657C | 976 | 2030 | 0 | Winter | winter | |
| 335667 | 3BE3193F-45AF-4787-B445-A6260393657C | 977 | 1014 | 0 | February | february | |
| 335668 | 3BE3193F-45AF-4787-B445-A6260393657C | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335669 | 3BE3193F-45AF-4787-B445-A6260393657C | 17758 | 2056 | 0 | IMG_3275.HEIC | img_3275.heic | |
| 335670 | 3BE3193F-45AF-4787-B445-A6260393657C | 7 | 12 | 0 | United States | united states | |
| 335671 | 3BE3193F-45AF-4787-B445-A6260393657C | 8 | 10 | 7 | California | california | |
| 335672 | 3BE3193F-45AF-4787-B445-A6260393657C | 9 | 7 | 0 | San Francisco | san francisco | |
| 335673 | 3BE3193F-45AF-4787-B445-A6260393657C | 10 | 5 | 0 | San Francisco | san francisco | |
| 335674 | 3BE3193F-45AF-4787-B445-A6260393657C | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335675 | 3BE3193F-45AF-4787-B445-A6260393657C | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335820 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 2 | 2046 | 0 | Live Photos | live photos | |
| 335821 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 3838 | 2024 | 0 | Cardboard Box | cardboard box | |
| 335822 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 347 | 2024 | 0 | Adult | adult |
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]);