This data as json, CSV (advanced)
| id | uuid ▼ | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 11269007 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 161 | 2055 | 0 | Favorites | favorites | |
| 11269008 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 1599 | 2024 | 0 | Branch | branch | |
| 11269009 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 397 | 2024 | 0 | Plant | plant | |
| 11269010 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 312 | 2024 | 0 | Animal | animal | |
| 11269011 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 313 | 2024 | 0 | Mammal | mammal | |
| 11269012 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 2818 | 2024 | 0 | Lemur | lemur | |
| 11269013 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 4850 | 2030 | 0 | Summer | summer | |
| 11269014 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 4851 | 1014 | 0 | August | august | |
| 11269015 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 2530 | 1015 | 0 | 2019 | 2019 | |
| 11269016 | 3295CB6A-D459-45C2-8E45-9FBBDCF80266 | 9707 | 2056 | 0 | IMG_9254.JPG | img_9254.jpg | |
| 11194746 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 1719 | 2027 | 0 | Trip | trip | |
| 11194747 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 1720 | 2027 | 0 | Travel | travel | |
| 11194748 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 3813 | 2024 | 0 | Pelican | pelican | |
| 11194749 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 981 | 2024 | 0 | Bird | bird | |
| 11194750 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 312 | 2024 | 0 | Animal | animal | |
| 11194751 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 317 | 2024 | 0 | Blue Sky | blue sky | |
| 11194752 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 296 | 2024 | 0 | Outdoor | outdoor | |
| 11194753 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 316 | 2024 | 0 | Sky | sky | |
| 11194754 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 976 | 2030 | 0 | Winter | winter | |
| 11194755 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 977 | 1014 | 0 | February | february | |
| 11194756 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 8073 | 1015 | 0 | 2018 | 2018 | |
| 11194757 | 32EAACCC-CDA4-4922-96FE-417F7F77F79E | 24312 | 2056 | 0 | IMG_2660.JPG | img_2660.jpg | |
| 339072 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 2 | 2046 | 0 | Live Photos | live photos | |
| 339073 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 515 | 2024 | 0 | Statue | statue | |
| 339074 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 331 | 2024 | 0 | Table | table | |
| 339075 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 338 | 2024 | 0 | Art | art | |
| 339076 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 332 | 2024 | 0 | Furniture | furniture | |
| 339077 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 286 | 2024 | 0 | People | people | |
| 339078 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 347 | 2024 | 0 | Adult | adult | |
| 339079 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 976 | 2030 | 0 | Winter | winter | |
| 339080 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 977 | 1014 | 0 | February | february | |
| 339081 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 8073 | 1015 | 0 | 2018 | 2018 | |
| 339082 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 3488 | 2056 | 0 | IMG_3074.HEIC | img_3074.heic | |
| 339083 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 7 | 12 | 0 | United States | united states | |
| 339084 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 8 | 10 | 7 | California | california | |
| 339085 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 9 | 7 | 0 | San Francisco | san francisco | |
| 339086 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 10 | 5 | 0 | San Francisco | san francisco | |
| 339087 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 339088 | 346ACDE4-6BD5-4C40-916B-04184921FAFA | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 11399251 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2165 | 2027 | 0 | Beach Activity | beach activity | |
| 11399252 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2166 | 2027 | 0 | Activity | activity | |
| 11399253 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 161 | 2055 | 0 | Favorites | favorites | |
| 11399254 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 397 | 2024 | 0 | Plant | plant | |
| 11399255 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 976 | 2030 | 0 | Winter | winter | |
| 11399256 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 2154 | 1014 | 0 | January | january | |
| 11399257 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 5 | 1015 | 0 | 2020 | 2020 | |
| 11399258 | 3504AC65-3614-451D-BE1A-F49B6CEB5E10 | 3148 | 2056 | 0 | IMG_0273.JPG | img_0273.jpg | |
| 624975 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 5003 | 2024 | 0 | Airplane | airplane | |
| 624976 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 286 | 2024 | 0 | People | people | |
| 624977 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 350 | 2024 | 0 | Interior Room | interior room | |
| 624978 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 303 | 2024 | 0 | Machine | machine | |
| 624979 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 304 | 2024 | 0 | Vehicle | vehicle | |
| 624980 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 5004 | 2024 | 0 | Aircraft | aircraft | |
| 624981 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 2960 | 2030 | 0 | Fall | fall | |
| 624982 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 3778 | 1014 | 0 | October | october | |
| 624983 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 20233 | 1015 | 0 | 2008 | 2008 | |
| 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 |
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]);