This data as json, CSV (advanced)
lookup_identifier ✖
| id | uuid ▼ | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 338445 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 3471 | 2056 | 0 | IMG_3091.HEIC | img_3091.heic | |
| 338446 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 7 | 12 | 0 | United States | united states | |
| 338447 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 8 | 10 | 7 | California | california | |
| 338448 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 9 | 7 | 0 | San Francisco | san francisco | |
| 338449 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 10 | 5 | 0 | San Francisco | san francisco | |
| 338450 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 338451 | 05D17529-1F2A-4F49-8EE5-A70A31666D62 | 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 | |
| 11229647 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 966 | 2027 | 0 | Dining | dining | |
| 11229648 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 1720 | 2027 | 0 | Travel | travel | |
| 11229649 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2603 | 2027 | 0 | Lunch | lunch | |
| 11229650 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 1719 | 2027 | 0 | Trip | trip | |
| 11229651 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 161 | 2055 | 0 | Favorites | favorites | |
| 11229652 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2 | 2046 | 0 | Live Photos | live photos | |
| 11229653 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2286 | 2024 | 0 | Lamp | lamp | |
| 11229654 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 348 | 2024 | 0 | Window | window | |
| 11229655 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 1813 | 2024 | 0 | Light | light | |
| 11229656 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 976 | 2030 | 0 | Winter | winter | |
| 11229657 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2529 | 1014 | 0 | December | december | |
| 11229658 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 19551 | 1015 | 0 | 2015 | 2015 | |
| 11229659 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 27509 | 2056 | 0 | IMG_1114.JPG | img_1114.jpg | |
| 11229660 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2531 | 12 | 0 | United Kingdom | united kingdom | |
| 11229661 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2532 | 10 | 2531 | England | england | |
| 11229662 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2558 | 7 | 0 | London | london | |
| 11229663 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 4954 | 5 | 2558 | Camden | camden | |
| 11229664 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2956 | 3 | 0 | Bloomsbury | bloomsbury | |
| 11229665 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2957 | 2 | 2956 | Princeton Street | princeton street | |
| 11430581 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 1719 | 2027 | 0 | Trip | trip | |
| 11430582 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 1720 | 2027 | 0 | Travel | travel | |
| 11430583 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 161 | 2055 | 0 | Favorites | favorites | |
| 11430584 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 4850 | 2030 | 0 | Summer | summer | |
| 11430585 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 4851 | 1014 | 0 | August | august | |
| 11430586 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11430587 | 071DED2E-2D2A-4519-A47A-FC37916025F1 | 8765 | 2056 | 0 | IMG_9712.JPG | img_9712.jpg | |
| 482617 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 2 | 2046 | 0 | Live Photos | live photos | |
| 482618 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 980 | 2024 | 0 | Hill | hill | |
| 482619 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 295 | 2024 | 0 | Land | land | |
| 482620 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 311 | 2024 | 0 | Grass | grass | |
| 482621 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 5800 | 2024 | 0 | Telescope | telescope | |
| 482622 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 376 | 2024 | 0 | Optical Equipment | optical equipment | |
| 482623 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 296 | 2024 | 0 | Outdoor | outdoor | |
| 482624 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 316 | 2024 | 0 | Sky | sky | |
| 482625 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 482626 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 2960 | 2030 | 0 | Fall | fall | |
| 482627 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 2961 | 1014 | 0 | November | november | |
| 482628 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 16630 | 1015 | 0 | 2016 | 2016 | |
| 482629 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 27535 | 2056 | 0 | IMG_1257.JPG | img_1257.jpg | |
| 482630 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 7 | 12 | 0 | United States | united states | |
| 482631 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 8 | 10 | 7 | California | california | |
| 482632 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 16694 | 9 | 8 | Marin Headlands | marin headlands | |
| 482633 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 5647 | 7 | 0 | Marin | marin | |
| 482634 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 5648 | 5 | 5647 | Sausalito | sausalito | |
| 482635 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 11022 | 1 | 0 | Nike Missile Site SF-88 | nike missile site sf-88 | |
| 482636 | 07509762-A841-4CEB-AA42-B65439E9C3DD | 11023 | 1 | 0 | Fort Barry | fort barry | |
| 11289537 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 1 | 2020 | 0 | Home | home | |
| 11289538 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 161 | 2055 | 0 | Favorites | favorites | |
| 11289539 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 312 | 2024 | 0 | Animal | animal | |
| 11289540 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 981 | 2024 | 0 | Bird | bird | |
| 11289541 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 4999 | 2024 | 0 | Raven | raven | |
| 11289542 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 3 | 2030 | 0 | Spring | spring | |
| 11289543 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 6230 | 1014 | 0 | May | may | |
| 11289544 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11289545 | 082D6DE0-BA33-4AAE-9378-5AF447E7DF31 | 27526 | 2056 | 0 | IMG_1099.JPG | img_1099.jpg | |
| 635563 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 161 | 2055 | 0 | Favorites | favorites | |
| 635564 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 2 | 2046 | 0 | Live Photos | live photos | |
| 635565 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 2703 | 2024 | 0 | Squirrel | squirrel | |
| 635566 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 313 | 2024 | 0 | Mammal | mammal | |
| 635567 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 2453 | 2024 | 0 | Rodent | rodent | |
| 635568 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 635569 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 522 | 2024 | 0 | Rocks | rocks | |
| 635570 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 312 | 2024 | 0 | Animal | animal | |
| 635571 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 3 | 2030 | 0 | Spring | spring | |
| 635572 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 6230 | 1014 | 0 | May | may | |
| 635573 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 5 | 1015 | 0 | 2020 | 2020 | |
| 635574 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 22817 | 2056 | 0 | IMG_4731.HEIC | img_4731.heic | |
| 635575 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 7 | 12 | 0 | United States | united states | |
| 635576 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 8 | 10 | 7 | California | california | |
| 635577 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 960 | 7 | 0 | San Mateo | san mateo | |
| 635578 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 5665 | 5 | 960 | Pacifica | pacifica | |
| 635579 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 20506 | 3 | 5665 | Rockaway | rockaway | |
| 635580 | 086ADA1B-8C59-41F1-88C3-49A6ABEEDF60 | 20507 | 2 | 20506 | San Marlo Way | san marlo way | |
| 52151 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 3813 | 2024 | 0 | Pelican | pelican | |
| 52152 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 312 | 2024 | 0 | Animal | animal | |
| 52153 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 981 | 2024 | 0 | Bird | bird | |
| 52154 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 2960 | 2030 | 0 | Fall | fall | |
| 52155 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 2961 | 1014 | 0 | November | november | |
| 52156 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 52157 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 6281 | 2056 | 0 | IMG_0067.JPG | img_0067.jpg | |
| 11414454 | 08E42F94-41A8-4205-995A-9877453FAF92 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11414455 | 08E42F94-41A8-4205-995A-9877453FAF92 | 2166 | 2027 | 0 | Activity | activity |
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]);