This data as json, CSV (advanced)
lookup_identifier ✖
| id | uuid ▼ | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11414456 | 08E42F94-41A8-4205-995A-9877453FAF92 | 161 | 2055 | 0 | Favorites | favorites | |
| 11414457 | 08E42F94-41A8-4205-995A-9877453FAF92 | 312 | 2024 | 0 | Animal | animal | |
| 11414458 | 08E42F94-41A8-4205-995A-9877453FAF92 | 313 | 2024 | 0 | Mammal | mammal | |
| 11414459 | 08E42F94-41A8-4205-995A-9877453FAF92 | 976 | 2030 | 0 | Winter | winter | |
| 11414460 | 08E42F94-41A8-4205-995A-9877453FAF92 | 2154 | 1014 | 0 | January | january | |
| 11414461 | 08E42F94-41A8-4205-995A-9877453FAF92 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11414462 | 08E42F94-41A8-4205-995A-9877453FAF92 | 3092 | 2056 | 0 | IMG_0259.JPG | img_0259.jpg | |
| 11438706 | 090F6409-3525-4789-A369-CB5290CA68E0 | 1719 | 2027 | 0 | Trip | trip | |
| 11438707 | 090F6409-3525-4789-A369-CB5290CA68E0 | 1720 | 2027 | 0 | Travel | travel | |
| 11438708 | 090F6409-3525-4789-A369-CB5290CA68E0 | 161 | 2055 | 0 | Favorites | favorites | |
| 11438709 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2 | 2046 | 0 | Live Photos | live photos | |
| 11438710 | 090F6409-3525-4789-A369-CB5290CA68E0 | 311 | 2024 | 0 | Grass | grass | |
| 11438711 | 090F6409-3525-4789-A369-CB5290CA68E0 | 474 | 2024 | 0 | Cloudy | cloudy | |
| 11438712 | 090F6409-3525-4789-A369-CB5290CA68E0 | 3115 | 2024 | 0 | Dirt Road | dirt road | |
| 11438713 | 090F6409-3525-4789-A369-CB5290CA68E0 | 316 | 2024 | 0 | Sky | sky | |
| 11438714 | 090F6409-3525-4789-A369-CB5290CA68E0 | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 11438715 | 090F6409-3525-4789-A369-CB5290CA68E0 | 397 | 2024 | 0 | Plant | plant | |
| 11438716 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2527 | 2024 | 0 | Monument | monument | |
| 11438717 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2528 | 2024 | 0 | Megalith | megalith | |
| 11438718 | 090F6409-3525-4789-A369-CB5290CA68E0 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11438719 | 090F6409-3525-4789-A369-CB5290CA68E0 | 295 | 2024 | 0 | Land | land | |
| 11438720 | 090F6409-3525-4789-A369-CB5290CA68E0 | 300 | 2024 | 0 | Road | road | |
| 11438721 | 090F6409-3525-4789-A369-CB5290CA68E0 | 3 | 2030 | 0 | Spring | spring | |
| 11438722 | 090F6409-3525-4789-A369-CB5290CA68E0 | 188 | 1014 | 0 | March | march | |
| 11438723 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11438724 | 090F6409-3525-4789-A369-CB5290CA68E0 | 17312 | 2056 | 0 | IMG_3325.HEIC | img_3325.heic | |
| 11438725 | 090F6409-3525-4789-A369-CB5290CA68E0 | 7 | 12 | 0 | United States | united states | |
| 11438726 | 090F6409-3525-4789-A369-CB5290CA68E0 | 8 | 10 | 7 | California | california | |
| 11438727 | 090F6409-3525-4789-A369-CB5290CA68E0 | 2964 | 7 | 8 | Los Angeles | los angeles | |
| 11438728 | 090F6409-3525-4789-A369-CB5290CA68E0 | 17313 | 5 | 2964 | Llano | llano | |
| 11438729 | 090F6409-3525-4789-A369-CB5290CA68E0 | 17314 | 2 | 0 | Pearblossom Hwy | pearblossom hwy | |
| 11268401 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 1719 | 2027 | 0 | Trip | trip | |
| 11268402 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 1720 | 2027 | 0 | Travel | travel | |
| 11268403 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 161 | 2055 | 0 | Favorites | favorites | |
| 11268404 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 2818 | 2024 | 0 | Lemur | lemur | |
| 11268405 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 312 | 2024 | 0 | Animal | animal | |
| 11268406 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 313 | 2024 | 0 | Mammal | mammal | |
| 11268407 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 4850 | 2030 | 0 | Summer | summer | |
| 11268408 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 4851 | 1014 | 0 | August | august | |
| 11268409 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11268410 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 9061 | 2056 | 0 | IMG_9538.JPG | img_9538.jpg | |
| 52158 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 981 | 2024 | 0 | Bird | bird | |
| 52159 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 3813 | 2024 | 0 | Pelican | pelican | |
| 52160 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 312 | 2024 | 0 | Animal | animal | |
| 52161 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2960 | 2030 | 0 | Fall | fall | |
| 52162 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2961 | 1014 | 0 | November | november | |
| 52163 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2530 | 1015 | 0 | 2019 | 2019 | |
| 52164 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 6282 | 2056 | 0 | IMG_0060.JPG | img_0060.jpg | |
| 381562 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 2 | 2046 | 0 | Live Photos | live photos | |
| 381563 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 338 | 2024 | 0 | Art | art | |
| 381564 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 515 | 2024 | 0 | Statue | statue | |
| 381565 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 976 | 2030 | 0 | Winter | winter | |
| 381566 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 2529 | 1014 | 0 | December | december | |
| 381567 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 12570 | 1015 | 0 | 2017 | 2017 | |
| 381568 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 6050 | 2056 | 0 | IMG_0901.HEIC | img_0901.heic | |
| 381569 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 7 | 12 | 0 | United States | united states | |
| 381570 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 8 | 10 | 7 | California | california | |
| 381571 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 951 | 7 | 8 | Santa Clara | santa clara | |
| 381572 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 25023 | 6 | 951 | Shasta Hanchett Park | shasta hanchett park | |
| 381573 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 10418 | 5 | 0 | San Jose | san jose | |
| 381574 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 25024 | 2 | 10418 | Naglee Ave | naglee ave | |
| 381575 | 0B9B2460-9D4D-421F-92C0-8F0921632AEC | 12861 | 1 | 0 | Rosicrucian Egyptian Museum | rosicrucian egyptian museum | |
| 11352624 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11352625 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 2166 | 2027 | 0 | Activity | activity | |
| 11352626 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 161 | 2055 | 0 | Favorites | favorites | |
| 11352627 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 2 | 2046 | 0 | Live Photos | live photos | |
| 11352628 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 306 | 2024 | 0 | Path | path | |
| 11352629 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 474 | 2024 | 0 | Cloudy | cloudy | |
| 11352630 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 316 | 2024 | 0 | Sky | sky | |
| 11352631 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 980 | 2024 | 0 | Hill | hill | |
| 11352632 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 286 | 2024 | 0 | People | people | |
| 11352633 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 295 | 2024 | 0 | Land | land | |
| 11352634 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 311 | 2024 | 0 | Grass | grass | |
| 11352635 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11352636 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 976 | 2030 | 0 | Winter | winter | |
| 11352637 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 2154 | 1014 | 0 | January | january | |
| 11352638 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11352639 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 3468 | 2056 | 0 | IMG_3110.HEIC | img_3110.heic | |
| 11352640 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 7 | 12 | 0 | United States | united states | |
| 11352641 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 8 | 10 | 7 | California | california | |
| 11352642 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 960 | 7 | 0 | San Mateo | san mateo | |
| 11352643 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 1596 | 5 | 960 | Pescadero | pescadero | |
| 11352644 | 0BE49C93-2ACC-4628-9C12-99566921EE00 | 1597 | 1 | 1596 | Año Nuevo Coast Natural Preserve | ano nuevo coast natural preserve | |
| 11292879 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11292880 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 2166 | 2027 | 0 | Activity | activity | |
| 11292881 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 161 | 2055 | 0 | Favorites | favorites | |
| 11292882 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 1591 | 2024 | 0 | Seal | seal | |
| 11292883 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 3469 | 2024 | 0 | Sand | sand | |
| 11292884 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 339 | 2024 | 0 | Water | water | |
| 11292885 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 415 | 2024 | 0 | Water Body | water body | |
| 11292886 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 1003 | 2024 | 0 | Ocean | ocean | |
| 11292887 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11292888 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 295 | 2024 | 0 | Land | land | |
| 11292889 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 1916 | 2024 | 0 | Beach | beach | |
| 11292890 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 312 | 2024 | 0 | Animal | animal | |
| 11292891 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 313 | 2024 | 0 | Mammal | mammal | |
| 11292892 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 976 | 2030 | 0 | Winter | winter | |
| 11292893 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 2154 | 1014 | 0 | January | january | |
| 11292894 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11292895 | 0C053200-BD3D-4E69-B987-97D9027357B6 | 3470 | 2056 | 0 | IMG_0182.JPG | img_0182.jpg |
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]);