This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 339161 | 3C7116A2-1C14-450A-84AB-4109C7D719AA | 8 | 10 | 7 | California | california | |
| 339162 | 3C7116A2-1C14-450A-84AB-4109C7D719AA | 9 | 7 | 0 | San Francisco | san francisco | |
| 339163 | 3C7116A2-1C14-450A-84AB-4109C7D719AA | 10 | 5 | 0 | San Francisco | san francisco | |
| 339164 | 3C7116A2-1C14-450A-84AB-4109C7D719AA | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 339165 | 3C7116A2-1C14-450A-84AB-4109C7D719AA | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 339258 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 2 | 2046 | 0 | Live Photos | live photos | |
| 339259 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 313 | 2024 | 0 | Mammal | mammal | |
| 339260 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 347 | 2024 | 0 | Adult | adult | |
| 339261 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 348 | 2024 | 0 | Window | window | |
| 339262 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 312 | 2024 | 0 | Animal | animal | |
| 339263 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 515 | 2024 | 0 | Statue | statue | |
| 339264 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 350 | 2024 | 0 | Interior Room | interior room | |
| 339265 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 286 | 2024 | 0 | People | people | |
| 339266 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 338 | 2024 | 0 | Art | art | |
| 339267 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 976 | 2030 | 0 | Winter | winter | |
| 339268 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 977 | 1014 | 0 | February | february | |
| 339269 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 8073 | 1015 | 0 | 2018 | 2018 | |
| 339270 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 3486 | 2056 | 0 | IMG_3087.HEIC | img_3087.heic | |
| 339271 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 7 | 12 | 0 | United States | united states | |
| 339272 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 8 | 10 | 7 | California | california | |
| 339273 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 9 | 7 | 0 | San Francisco | san francisco | |
| 339274 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 10 | 5 | 0 | San Francisco | san francisco | |
| 339275 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 339276 | 44477DDB-EA24-427E-ACD0-8EFFAD9D167F | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 339846 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 2 | 2046 | 0 | Live Photos | live photos | |
| 339847 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 286 | 2024 | 0 | People | people | |
| 339848 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 340 | 2024 | 0 | Clothing | clothing | |
| 339849 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 976 | 2030 | 0 | Winter | winter | |
| 339850 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 977 | 1014 | 0 | February | february | |
| 339851 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 8073 | 1015 | 0 | 2018 | 2018 | |
| 339852 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 3549 | 2056 | 0 | IMG_3115.HEIC | img_3115.heic | |
| 339853 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 7 | 12 | 0 | United States | united states | |
| 339854 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 8 | 10 | 7 | California | california | |
| 339855 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 9 | 7 | 0 | San Francisco | san francisco | |
| 339856 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 10 | 5 | 0 | San Francisco | san francisco | |
| 339857 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 339858 | 6BC8E43D-D175-4C2C-9811-620B706BA25C | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 340111 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 2 | 2046 | 0 | Live Photos | live photos | |
| 340112 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 312 | 2024 | 0 | Animal | animal | |
| 340113 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 976 | 2030 | 0 | Winter | winter | |
| 340114 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 977 | 1014 | 0 | February | february | |
| 340115 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 340116 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 3653 | 2056 | 0 | IMG_3077.HEIC | img_3077.heic | |
| 340117 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 7 | 12 | 0 | United States | united states | |
| 340118 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 8 | 10 | 7 | California | california | |
| 340119 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 9 | 7 | 0 | San Francisco | san francisco | |
| 340120 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 10 | 5 | 0 | San Francisco | san francisco | |
| 340121 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 340122 | 7C8CA810-91EB-45A1-AFAE-F331714EBA56 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 340753 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 2 | 2046 | 0 | Live Photos | live photos | |
| 340754 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 312 | 2024 | 0 | Animal | animal | |
| 340755 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 982 | 2024 | 0 | Reptile | reptile | |
| 340756 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 4875 | 2024 | 0 | Dinosaur | dinosaur | |
| 340757 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 976 | 2030 | 0 | Winter | winter | |
| 340758 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 977 | 1014 | 0 | February | february | |
| 340759 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 8073 | 1015 | 0 | 2018 | 2018 | |
| 340760 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 3513 | 2056 | 0 | IMG_3079.HEIC | img_3079.heic | |
| 340761 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 7 | 12 | 0 | United States | united states | |
| 340762 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 8 | 10 | 7 | California | california | |
| 340763 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 9 | 7 | 0 | San Francisco | san francisco | |
| 340764 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 10 | 5 | 0 | San Francisco | san francisco | |
| 340765 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 340766 | A488C119-AE20-4F8F-8C37-58B66BAFD78F | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 340881 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 161 | 2055 | 0 | Favorites | favorites | |
| 340882 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 2 | 2046 | 0 | Live Photos | live photos | |
| 340883 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 976 | 2030 | 0 | Winter | winter | |
| 340884 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 977 | 1014 | 0 | February | february | |
| 340885 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 340886 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 3579 | 2056 | 0 | IMG_3094.HEIC | img_3094.heic | |
| 340887 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 7 | 12 | 0 | United States | united states | |
| 340888 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 8 | 10 | 7 | California | california | |
| 340889 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 9 | 7 | 0 | San Francisco | san francisco | |
| 340890 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 10 | 5 | 0 | San Francisco | san francisco | |
| 340891 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 340892 | AE5BD628-AB44-4D2F-A03F-88422F509482 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 341262 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 2 | 2046 | 0 | Live Photos | live photos | |
| 341263 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 337 | 2024 | 0 | Painting | painting | |
| 341264 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 350 | 2024 | 0 | Interior Room | interior room | |
| 341265 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 338 | 2024 | 0 | Art | art | |
| 341266 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 976 | 2030 | 0 | Winter | winter | |
| 341267 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 977 | 1014 | 0 | February | february | |
| 341268 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 341269 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 3679 | 2056 | 0 | IMG_3071.HEIC | img_3071.heic | |
| 341270 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 7 | 12 | 0 | United States | united states | |
| 341271 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 8 | 10 | 7 | California | california | |
| 341272 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 9 | 7 | 0 | San Francisco | san francisco | |
| 341273 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 10 | 5 | 0 | San Francisco | san francisco | |
| 341274 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 341275 | C818CC9A-2E85-48A7-A66D-DC3D4E53BB89 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 342110 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 2 | 2046 | 0 | Live Photos | live photos | |
| 342111 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 312 | 2024 | 0 | Animal | animal | |
| 342112 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 981 | 2024 | 0 | Bird | bird | |
| 342113 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 350 | 2024 | 0 | Interior Room | interior room | |
| 342114 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 338 | 2024 | 0 | Art | art | |
| 342115 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 337 | 2024 | 0 | Painting | painting | |
| 342116 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 286 | 2024 | 0 | People | people | |
| 342117 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 347 | 2024 | 0 | Adult | adult | |
| 342118 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 976 | 2030 | 0 | Winter | winter | |
| 342119 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 977 | 1014 | 0 | February | february | |
| 342120 | FCC0BF2E-D8AB-4A77-AAF5-427E15978F82 | 8073 | 1015 | 0 | 2018 | 2018 |
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]);