This data as json, CSV (advanced)
| id ▲ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11399255 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 976 | 2030 | 0 | Winter | winter | |
| 11399254 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 397 | 2024 | 0 | Plant | plant | |
| 11399253 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 161 | 2055 | 0 | Favorites | favorites | |
| 11399252 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2166 | 2027 | 0 | Activity | activity | |
| 11399251 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11397389 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 24588 | 2056 | 0 | IMG_2589.JPG | img_2589.jpg | |
| 11397388 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11397387 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 977 | 1014 | 0 | February | february | |
| 11397386 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 976 | 2030 | 0 | Winter | winter | |
| 11397385 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 981 | 2024 | 0 | Bird | bird | |
| 11397384 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 312 | 2024 | 0 | Animal | animal | |
| 11397383 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 316 | 2024 | 0 | Sky | sky | |
| 11397382 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11397381 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 11397380 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 3813 | 2024 | 0 | Pelican | pelican | |
| 11397379 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 1720 | 2027 | 0 | Travel | travel | |
| 11397378 | C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 | 1719 | 2027 | 0 | Trip | trip | |
| 11396346 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 986 | 1 | 0 | Ocean Beach | ocean beach | |
| 11396345 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 10 | 5 | 0 | San Francisco | san francisco | |
| 11396344 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 9 | 7 | 0 | San Francisco | san francisco | |
| 11396343 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 8 | 10 | 7 | California | california | |
| 11396342 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 7 | 12 | 0 | United States | united states | |
| 11396341 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 22891 | 2056 | 0 | IMG_4590.HEIC | img_4590.heic | |
| 11396340 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 5 | 1015 | 0 | 2020 | 2020 | |
| 11396339 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 6230 | 1014 | 0 | May | may | |
| 11396338 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 3 | 2030 | 0 | Spring | spring | |
| 11396337 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11396336 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 11396335 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 316 | 2024 | 0 | Sky | sky | |
| 11396334 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 286 | 2024 | 0 | People | people | |
| 11396333 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 347 | 2024 | 0 | Adult | adult | |
| 11396332 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 5068 | 2024 | 0 | Daytime | daytime | |
| 11396331 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 2 | 2046 | 0 | Live Photos | live photos | |
| 11396330 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 568 | 2054 | 0 | Selfies | selfies | |
| 11396329 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 161 | 2055 | 0 | Favorites | favorites | |
| 11396328 | 770F12EC-83BE-42CC-B811-A3E111CEDECD | 1 | 2020 | 0 | Home | home | |
| 11393922 | BA466D66-989B-4E8B-9553-85D91421A124 | 3299 | 2056 | 0 | IMG_0220.JPG | img_0220.jpg | |
| 11393921 | BA466D66-989B-4E8B-9553-85D91421A124 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11393920 | BA466D66-989B-4E8B-9553-85D91421A124 | 2154 | 1014 | 0 | January | january | |
| 11393919 | BA466D66-989B-4E8B-9553-85D91421A124 | 976 | 2030 | 0 | Winter | winter | |
| 11393918 | BA466D66-989B-4E8B-9553-85D91421A124 | 1591 | 2024 | 0 | Seal | seal | |
| 11393917 | BA466D66-989B-4E8B-9553-85D91421A124 | 313 | 2024 | 0 | Mammal | mammal | |
| 11393916 | BA466D66-989B-4E8B-9553-85D91421A124 | 312 | 2024 | 0 | Animal | animal | |
| 11393915 | BA466D66-989B-4E8B-9553-85D91421A124 | 161 | 2055 | 0 | Favorites | favorites | |
| 11393914 | BA466D66-989B-4E8B-9553-85D91421A124 | 2166 | 2027 | 0 | Activity | activity | |
| 11393913 | BA466D66-989B-4E8B-9553-85D91421A124 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11393571 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 24411 | 2056 | 0 | IMG_2640.JPG | img_2640.jpg | |
| 11393570 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11393569 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 977 | 1014 | 0 | February | february | |
| 11393568 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 976 | 2030 | 0 | Winter | winter | |
| 11393567 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 3813 | 2024 | 0 | Pelican | pelican | |
| 11393566 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 981 | 2024 | 0 | Bird | bird | |
| 11393565 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 312 | 2024 | 0 | Animal | animal | |
| 11393564 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 1720 | 2027 | 0 | Travel | travel | |
| 11393563 | A1095B7D-7675-4585-BEAE-C9A072A793C7 | 1719 | 2027 | 0 | Trip | trip | |
| 11391019 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 9268 | 2056 | 0 | IMG_9565.JPG | img_9565.jpg | |
| 11391018 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11391017 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 4851 | 1014 | 0 | August | august | |
| 11391016 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 4850 | 2030 | 0 | Summer | summer | |
| 11391015 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 397 | 2024 | 0 | Plant | plant | |
| 11391014 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 161 | 2055 | 0 | Favorites | favorites | |
| 11391013 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 1720 | 2027 | 0 | Travel | travel | |
| 11391012 | E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F | 1719 | 2027 | 0 | Trip | trip | |
| 11390559 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 3665 | 2056 | 0 | IMG_0204.JPG | img_0204.jpg | |
| 11390558 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11390557 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 2154 | 1014 | 0 | January | january | |
| 11390556 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 976 | 2030 | 0 | Winter | winter | |
| 11390555 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 397 | 2024 | 0 | Plant | plant | |
| 11390554 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 313 | 2024 | 0 | Mammal | mammal | |
| 11390553 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 312 | 2024 | 0 | Animal | animal | |
| 11390552 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 1593 | 2024 | 0 | Sea Lion | sea lion | |
| 11390551 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 396 | 2024 | 0 | Shrub | shrub | |
| 11390550 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 1591 | 2024 | 0 | Seal | seal | |
| 11390549 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 161 | 2055 | 0 | Favorites | favorites | |
| 11390548 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 2166 | 2027 | 0 | Activity | activity | |
| 11390547 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11390149 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 24430 | 2056 | 0 | IMG_2642.JPG | img_2642.jpg | |
| 11390148 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11390147 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 977 | 1014 | 0 | February | february | |
| 11390146 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 976 | 2030 | 0 | Winter | winter | |
| 11390145 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 312 | 2024 | 0 | Animal | animal | |
| 11390144 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 3813 | 2024 | 0 | Pelican | pelican | |
| 11390143 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 981 | 2024 | 0 | Bird | bird | |
| 11390142 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 161 | 2055 | 0 | Favorites | favorites | |
| 11390141 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 1720 | 2027 | 0 | Travel | travel | |
| 11390140 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 1719 | 2027 | 0 | Trip | trip | |
| 11386506 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 24386 | 2056 | 0 | IMG_2645.JPG | img_2645.jpg | |
| 11386505 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11386504 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 977 | 1014 | 0 | February | february | |
| 11386503 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 976 | 2030 | 0 | Winter | winter | |
| 11386502 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 312 | 2024 | 0 | Animal | animal | |
| 11386501 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 522 | 2024 | 0 | Rocks | rocks | |
| 11386500 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 981 | 2024 | 0 | Bird | bird | |
| 11386499 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 3813 | 2024 | 0 | Pelican | pelican | |
| 11386498 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 1720 | 2027 | 0 | Travel | travel | |
| 11386497 | 89820B37-8A27-49A7-BDDF-B64253FD23FA | 1719 | 2027 | 0 | Trip | trip | |
| 11385581 | 521AC274-EDCB-4A51-BB46-96FE8A4D839F | 24341 | 2056 | 0 | IMG_2659.JPG | img_2659.jpg | |
| 11385580 | 521AC274-EDCB-4A51-BB46-96FE8A4D839F | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11385579 | 521AC274-EDCB-4A51-BB46-96FE8A4D839F | 977 | 1014 | 0 | February | february | |
| 11385578 | 521AC274-EDCB-4A51-BB46-96FE8A4D839F | 976 | 2030 | 0 | Winter | winter |
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]);