This data as json, CSV (advanced)
| id | uuid ▼ | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 624984 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 29868 | 2056 | 0 | 2949747439_2e44412047_o.jpg | 2949747439_2e44412047_o.jpg | |
| 339095 | 3545F3EF-615B-4178-A146-9121E629DE90 | 2 | 2046 | 0 | Live Photos | live photos | |
| 339096 | 3545F3EF-615B-4178-A146-9121E629DE90 | 3545 | 2024 | 0 | Skull | skull | |
| 339097 | 3545F3EF-615B-4178-A146-9121E629DE90 | 286 | 2024 | 0 | People | people | |
| 339098 | 3545F3EF-615B-4178-A146-9121E629DE90 | 976 | 2030 | 0 | Winter | winter | |
| 339099 | 3545F3EF-615B-4178-A146-9121E629DE90 | 977 | 1014 | 0 | February | february | |
| 339100 | 3545F3EF-615B-4178-A146-9121E629DE90 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 339101 | 3545F3EF-615B-4178-A146-9121E629DE90 | 3664 | 2056 | 0 | IMG_3072.HEIC | img_3072.heic | |
| 339102 | 3545F3EF-615B-4178-A146-9121E629DE90 | 7 | 12 | 0 | United States | united states | |
| 339103 | 3545F3EF-615B-4178-A146-9121E629DE90 | 8 | 10 | 7 | California | california | |
| 339104 | 3545F3EF-615B-4178-A146-9121E629DE90 | 9 | 7 | 0 | San Francisco | san francisco | |
| 339105 | 3545F3EF-615B-4178-A146-9121E629DE90 | 10 | 5 | 0 | San Francisco | san francisco | |
| 339106 | 3545F3EF-615B-4178-A146-9121E629DE90 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 339107 | 3545F3EF-615B-4178-A146-9121E629DE90 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 11459582 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 1719 | 2027 | 0 | Trip | trip | |
| 11459583 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 1720 | 2027 | 0 | Travel | travel | |
| 11459584 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 161 | 2055 | 0 | Favorites | favorites | |
| 11459585 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 3813 | 2024 | 0 | Pelican | pelican | |
| 11459586 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11459587 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 312 | 2024 | 0 | Animal | animal | |
| 11459588 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 981 | 2024 | 0 | Bird | bird | |
| 11459589 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 976 | 2030 | 0 | Winter | winter | |
| 11459590 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 977 | 1014 | 0 | February | february | |
| 11459591 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11459592 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 24314 | 2056 | 0 | IMG_2638.JPG | img_2638.jpg | |
| 612002 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 350 | 2024 | 0 | Interior Room | interior room | |
| 612003 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 2960 | 2030 | 0 | Fall | fall | |
| 612004 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 3778 | 1014 | 0 | October | october | |
| 612005 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 19551 | 1015 | 0 | 2015 | 2015 | |
| 612006 | 369683A6-C32A-4E2D-9492-25BD553B1B6E | 29150 | 2056 | 0 | DSC_0232.JPG | dsc_0232.jpg | |
| 11290121 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 1719 | 2027 | 0 | Trip | trip | |
| 11290122 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 1720 | 2027 | 0 | Travel | travel | |
| 11290123 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 161 | 2055 | 0 | Favorites | favorites | |
| 11290124 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 312 | 2024 | 0 | Animal | animal | |
| 11290125 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 982 | 2024 | 0 | Reptile | reptile | |
| 11290126 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 4475 | 2024 | 0 | Alligator Crocodile | alligator crocodile | |
| 11290127 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 347 | 2024 | 0 | Adult | adult | |
| 11290128 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 286 | 2024 | 0 | People | people | |
| 11290129 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 2960 | 2030 | 0 | Fall | fall | |
| 11290130 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 4131 | 1014 | 0 | September | september | |
| 11290131 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11290132 | 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E | 7848 | 2056 | 0 | IMG_9872.JPG | img_9872.jpg | |
| 11293551 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 1719 | 2027 | 0 | Trip | trip | |
| 11293552 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 1720 | 2027 | 0 | Travel | travel | |
| 11293553 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 161 | 2055 | 0 | Favorites | favorites | |
| 11293554 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 295 | 2024 | 0 | Land | land | |
| 11293555 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 311 | 2024 | 0 | Grass | grass | |
| 11293556 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 11293557 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2527 | 2024 | 0 | Monument | monument | |
| 11293558 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2528 | 2024 | 0 | Megalith | megalith | |
| 11293559 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11293560 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 316 | 2024 | 0 | Sky | sky | |
| 11293561 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 976 | 2030 | 0 | Winter | winter | |
| 11293562 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2529 | 1014 | 0 | December | december | |
| 11293563 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11293564 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 4995 | 2056 | 0 | IMG_1673.HEIC | img_1673.heic | |
| 11293565 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2531 | 12 | 0 | United Kingdom | united kingdom | |
| 11293566 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2532 | 10 | 2531 | England | england | |
| 11293567 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2533 | 7 | 2532 | Wiltshire | wiltshire | |
| 11293568 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 4946 | 5 | 2533 | Amesbury | amesbury | |
| 11293569 | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2540 | 1 | 0 | Stonehenge | stonehenge | |
| 11240825 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 1719 | 2027 | 0 | Trip | trip | |
| 11240826 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 1720 | 2027 | 0 | Travel | travel | |
| 11240827 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 161 | 2055 | 0 | Favorites | favorites | |
| 11240828 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 312 | 2024 | 0 | Animal | animal | |
| 11240829 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 313 | 2024 | 0 | Mammal | mammal | |
| 11240830 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 4850 | 2030 | 0 | Summer | summer | |
| 11240831 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 4851 | 1014 | 0 | August | august | |
| 11240832 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11240833 | 379BF280-6D24-43EF-9DB2-0E497D08DD34 | 8825 | 2056 | 0 | IMG_9739.JPG | img_9739.jpg | |
| 145737 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 2 | 2046 | 0 | Live Photos | live photos | |
| 145738 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 306 | 2024 | 0 | Path | path | |
| 145739 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 145740 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 348 | 2024 | 0 | Window | window | |
| 145741 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 316 | 2024 | 0 | Sky | sky | |
| 145742 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 296 | 2024 | 0 | Outdoor | outdoor | |
| 145743 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 295 | 2024 | 0 | Land | land | |
| 145744 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 300 | 2024 | 0 | Road | road | |
| 145745 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 7206 | 2024 | 0 | Scooter | scooter | |
| 145746 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 303 | 2024 | 0 | Machine | machine | |
| 145747 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 304 | 2024 | 0 | Vehicle | vehicle | |
| 145748 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 305 | 2024 | 0 | Automobile | automobile | |
| 145749 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 299 | 2024 | 0 | Car | car | |
| 145750 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 4850 | 2030 | 0 | Summer | summer | |
| 145751 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 5934 | 1014 | 0 | June | june | |
| 145752 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 145753 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 69 | 2056 | 0 | IMG_4324.HEIC | img_4324.heic | |
| 145754 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 7 | 12 | 0 | United States | united states | |
| 145755 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 8 | 10 | 7 | California | california | |
| 145756 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 9 | 7 | 0 | San Francisco | san francisco | |
| 145757 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 10 | 5 | 0 | San Francisco | san francisco | |
| 145758 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 320 | 3 | 0 | SOMA | soma | |
| 145759 | 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 | 15293 | 2 | 320 | Clementina St | clementina st | |
| 154667 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 311 | 2024 | 0 | Grass | grass | |
| 154668 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 1782 | 2024 | 0 | Road Other | road other | |
| 154669 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 13641 | 2024 | 0 | Corgi | corgi | |
| 154670 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 314 | 2024 | 0 | Canine | canine | |
| 154671 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 310 | 2024 | 0 | Dog | dog | |
| 154672 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 411 | 2024 | 0 | Cord | cord | |
| 154673 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 408 | 2024 | 0 | Leash | leash |
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]);