This data as json, CSV (advanced)
lookup_identifier ✖
| id | uuid ▲ | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 54994 | FC01AB36-9465-4F95-8DC9-618FBC1405A6 | 6507 | 2056 | 0 | IMG_0065.JPG | img_0065.jpg | |
| 11211876 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 1719 | 2027 | 0 | Trip | trip | |
| 11211877 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 1720 | 2027 | 0 | Travel | travel | |
| 11211878 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 161 | 2055 | 0 | Favorites | favorites | |
| 11211879 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 312 | 2024 | 0 | Animal | animal | |
| 11211880 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 313 | 2024 | 0 | Mammal | mammal | |
| 11211881 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 397 | 2024 | 0 | Plant | plant | |
| 11211882 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 1599 | 2024 | 0 | Branch | branch | |
| 11211883 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 4850 | 2030 | 0 | Summer | summer | |
| 11211884 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 4851 | 1014 | 0 | August | august | |
| 11211885 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11211886 | FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 | 9011 | 2056 | 0 | IMG_9742.JPG | img_9742.jpg | |
| 16488 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 161 | 2055 | 0 | Favorites | favorites | |
| 16489 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 1591 | 2024 | 0 | Seal | seal | |
| 16490 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 313 | 2024 | 0 | Mammal | mammal | |
| 16491 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 312 | 2024 | 0 | Animal | animal | |
| 16492 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 976 | 2030 | 0 | Winter | winter | |
| 16493 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 977 | 1014 | 0 | February | february | |
| 16494 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 5 | 1015 | 0 | 2020 | 2020 | |
| 16495 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 2898 | 2056 | 0 | IMG_0406.JPG | img_0406.jpg | |
| 11338071 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 1719 | 2027 | 0 | Trip | trip | |
| 11338072 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 1720 | 2027 | 0 | Travel | travel | |
| 11338073 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 161 | 2055 | 0 | Favorites | favorites | |
| 11338074 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 2 | 2046 | 0 | Live Photos | live photos | |
| 11338075 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 350 | 2024 | 0 | Interior Room | interior room | |
| 11338076 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 347 | 2024 | 0 | Adult | adult | |
| 11338077 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 286 | 2024 | 0 | People | people | |
| 11338078 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 340 | 2024 | 0 | Clothing | clothing | |
| 11338079 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 2960 | 2030 | 0 | Fall | fall | |
| 11338080 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 4131 | 1014 | 0 | September | september | |
| 11338081 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11338082 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 52 | 2021 | 0 | Natalie Downe | natalie downe | 01B4C24C-BD73-4E11-AD2D-2901E90D3F7C |
| 11338083 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 8025 | 2056 | 0 | IMG_7216.HEIC | img_7216.heic | |
| 11338084 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 7 | 12 | 0 | United States | united states | |
| 11338085 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 1722 | 11 | 7 | LA | la | |
| 11338086 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 945 | 10 | 0 | Louisiana | louisiana | |
| 11338087 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 946 | 7 | 945 | Orleans | orleans | |
| 11338088 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 7807 | 6 | 946 | Central City | central city | |
| 11338089 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 947 | 5 | 0 | New Orleans | new orleans | |
| 11338090 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 4493 | 2 | 0 | Oretha Castle Haley Blvd | oretha castle haley blvd | |
| 11338091 | F9F1DAD8-0DEC-4272-A0E5-39517811AF71 | 4494 | 1 | 4493 | Southern Food & Beverage Museum | southern food & beverage museum | |
| 11478935 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 1719 | 2027 | 0 | Trip | trip | |
| 11478936 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 1720 | 2027 | 0 | Travel | travel | |
| 11478937 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 522 | 2024 | 0 | Rocks | rocks | |
| 11478938 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 3813 | 2024 | 0 | Pelican | pelican | |
| 11478939 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 312 | 2024 | 0 | Animal | animal | |
| 11478940 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 981 | 2024 | 0 | Bird | bird | |
| 11478941 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 976 | 2030 | 0 | Winter | winter | |
| 11478942 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 977 | 1014 | 0 | February | february | |
| 11478943 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11478944 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 24501 | 2056 | 0 | IMG_2631.JPG | img_2631.jpg | |
| 11446641 | F92B1415-1D5D-45A6-A736-54D988748BBF | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11446642 | F92B1415-1D5D-45A6-A736-54D988748BBF | 2166 | 2027 | 0 | Activity | activity | |
| 11446643 | F92B1415-1D5D-45A6-A736-54D988748BBF | 161 | 2055 | 0 | Favorites | favorites | |
| 11446644 | F92B1415-1D5D-45A6-A736-54D988748BBF | 396 | 2024 | 0 | Shrub | shrub | |
| 11446645 | F92B1415-1D5D-45A6-A736-54D988748BBF | 312 | 2024 | 0 | Animal | animal | |
| 11446646 | F92B1415-1D5D-45A6-A736-54D988748BBF | 313 | 2024 | 0 | Mammal | mammal | |
| 11446647 | F92B1415-1D5D-45A6-A736-54D988748BBF | 1591 | 2024 | 0 | Seal | seal | |
| 11446648 | F92B1415-1D5D-45A6-A736-54D988748BBF | 397 | 2024 | 0 | Plant | plant | |
| 11446649 | F92B1415-1D5D-45A6-A736-54D988748BBF | 976 | 2030 | 0 | Winter | winter | |
| 11446650 | F92B1415-1D5D-45A6-A736-54D988748BBF | 2154 | 1014 | 0 | January | january | |
| 11446651 | F92B1415-1D5D-45A6-A736-54D988748BBF | 5 | 1015 | 0 | 2020 | 2020 | |
| 11446652 | F92B1415-1D5D-45A6-A736-54D988748BBF | 3338 | 2056 | 0 | IMG_0224.JPG | img_0224.jpg | |
| 11299618 | F8A949C8-9034-4437-A685-765B42D87052 | 1719 | 2027 | 0 | Trip | trip | |
| 11299619 | F8A949C8-9034-4437-A685-765B42D87052 | 1720 | 2027 | 0 | Travel | travel | |
| 11299620 | F8A949C8-9034-4437-A685-765B42D87052 | 3813 | 2024 | 0 | Pelican | pelican | |
| 11299621 | F8A949C8-9034-4437-A685-765B42D87052 | 312 | 2024 | 0 | Animal | animal | |
| 11299622 | F8A949C8-9034-4437-A685-765B42D87052 | 981 | 2024 | 0 | Bird | bird | |
| 11299623 | F8A949C8-9034-4437-A685-765B42D87052 | 976 | 2030 | 0 | Winter | winter | |
| 11299624 | F8A949C8-9034-4437-A685-765B42D87052 | 977 | 1014 | 0 | February | february | |
| 11299625 | F8A949C8-9034-4437-A685-765B42D87052 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11299626 | F8A949C8-9034-4437-A685-765B42D87052 | 24500 | 2056 | 0 | IMG_2604.JPG | img_2604.jpg | |
| 399313 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 2 | 2046 | 0 | Live Photos | live photos | |
| 399314 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 286 | 2024 | 0 | People | people | |
| 399315 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 1324 | 2024 | 0 | Jeans | jeans | |
| 399316 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 2841 | 2024 | 0 | Sneaker | sneaker | |
| 399317 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 314 | 2024 | 0 | Canine | canine | |
| 399318 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 310 | 2024 | 0 | Dog | dog | |
| 399319 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 13641 | 2024 | 0 | Corgi | corgi | |
| 399320 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 312 | 2024 | 0 | Animal | animal | |
| 399321 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 313 | 2024 | 0 | Mammal | mammal | |
| 399322 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 340 | 2024 | 0 | Clothing | clothing | |
| 399323 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 2842 | 2024 | 0 | Footwear | footwear | |
| 399324 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 2843 | 2024 | 0 | Shoes | shoes | |
| 399325 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 2960 | 2030 | 0 | Fall | fall | |
| 399326 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 3778 | 1014 | 0 | October | october | |
| 399327 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 12570 | 1015 | 0 | 2017 | 2017 | |
| 399328 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 3104 | 2056 | 0 | IMG_0212.JPG | img_0212.jpg | |
| 399329 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 7 | 12 | 0 | United States | united states | |
| 399330 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 8 | 10 | 7 | California | california | |
| 399331 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 9 | 7 | 0 | San Francisco | san francisco | |
| 399332 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 10 | 5 | 0 | San Francisco | san francisco | |
| 399333 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 985 | 3 | 10 | Outer Richmond | outer richmond | |
| 399334 | F78D8339-34E9-4A9A-9BF8-6A73F52566EE | 986 | 1 | 0 | Ocean Beach | ocean beach | |
| 11145433 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 966 | 2027 | 0 | Dining | dining | |
| 11145434 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 1720 | 2027 | 0 | Travel | travel | |
| 11145435 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 2603 | 2027 | 0 | Lunch | lunch | |
| 11145436 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 1719 | 2027 | 0 | Trip | trip | |
| 11145437 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 3040 | 2039 | 0 | Seafood | seafood | |
| 11145438 | F6F45595-4033-4C79-A9F9-86DCA9088C37 | 3026 | 2039 | 0 | Burgers | burgers |
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]);