This data as json, CSV (advanced)
| id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
|---|---|---|---|---|---|---|---|
| 335822 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 347 | 2024 | 0 | Adult | adult | |
| 335823 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 286 | 2024 | 0 | People | people | |
| 335824 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 333 | 2024 | 0 | Container | container | |
| 335825 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 976 | 2030 | 0 | Winter | winter | |
| 335826 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 977 | 1014 | 0 | February | february | |
| 335827 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335828 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 3465 | 2056 | 0 | IMG_3121.HEIC | img_3121.heic | |
| 335829 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 7 | 12 | 0 | United States | united states | |
| 335830 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 8 | 10 | 7 | California | california | |
| 335831 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 9 | 7 | 0 | San Francisco | san francisco | |
| 335832 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 10 | 5 | 0 | San Francisco | san francisco | |
| 335833 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335834 | 499ABED7-CDCD-4A72-B9FD-21DD54B6008F | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 335979 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 2 | 2046 | 0 | Live Photos | live photos | |
| 335980 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 350 | 2024 | 0 | Interior Room | interior room | |
| 335981 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 286 | 2024 | 0 | People | people | |
| 335982 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 3545 | 2024 | 0 | Skull | skull | |
| 335983 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 976 | 2030 | 0 | Winter | winter | |
| 335984 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 977 | 1014 | 0 | February | february | |
| 335985 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 335986 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 17574 | 2056 | 0 | IMG_3227.HEIC | img_3227.heic | |
| 335987 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 7 | 12 | 0 | United States | united states | |
| 335988 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 8 | 10 | 7 | California | california | |
| 335989 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 9 | 7 | 0 | San Francisco | san francisco | |
| 335990 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 10 | 5 | 0 | San Francisco | san francisco | |
| 335991 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 335992 | 55679037-0DCE-469C-A1B2-1ADD537FA1A6 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336072 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 2 | 2046 | 0 | Live Photos | live photos | |
| 336073 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 350 | 2024 | 0 | Interior Room | interior room | |
| 336074 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 312 | 2024 | 0 | Animal | animal | |
| 336075 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 982 | 2024 | 0 | Reptile | reptile | |
| 336076 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 4875 | 2024 | 0 | Dinosaur | dinosaur | |
| 336077 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 976 | 2030 | 0 | Winter | winter | |
| 336078 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 977 | 1014 | 0 | February | february | |
| 336079 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 336080 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 17619 | 2056 | 0 | IMG_3246.HEIC | img_3246.heic | |
| 336081 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 7 | 12 | 0 | United States | united states | |
| 336082 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 8 | 10 | 7 | California | california | |
| 336083 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 9 | 7 | 0 | San Francisco | san francisco | |
| 336084 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 10 | 5 | 0 | San Francisco | san francisco | |
| 336085 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 336086 | 5C55FD14-1786-4136-9026-FBBFFD74C4E3 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336219 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 2 | 2046 | 0 | Live Photos | live photos | |
| 336220 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 3545 | 2024 | 0 | Skull | skull | |
| 336221 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 286 | 2024 | 0 | People | people | |
| 336222 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 976 | 2030 | 0 | Winter | winter | |
| 336223 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 977 | 1014 | 0 | February | february | |
| 336224 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 336225 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 3138 | 2056 | 0 | IMG_3158.HEIC | img_3158.heic | |
| 336226 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 7 | 12 | 0 | United States | united states | |
| 336227 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 8 | 10 | 7 | California | california | |
| 336228 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 9 | 7 | 0 | San Francisco | san francisco | |
| 336229 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 10 | 5 | 0 | San Francisco | san francisco | |
| 336230 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 336231 | 62F1FD9A-238A-48F0-A160-D8161D869C62 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336269 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 2 | 2046 | 0 | Live Photos | live photos | |
| 336270 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 3545 | 2024 | 0 | Skull | skull | |
| 336271 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 286 | 2024 | 0 | People | people | |
| 336272 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 3616 | 2024 | 0 | Skeleton | skeleton | |
| 336273 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 338 | 2024 | 0 | Art | art | |
| 336274 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 976 | 2030 | 0 | Winter | winter | |
| 336275 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 977 | 1014 | 0 | February | february | |
| 336276 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 8073 | 1015 | 0 | 2018 | 2018 | |
| 336277 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 3468 | 2056 | 0 | IMG_3110.HEIC | img_3110.heic | |
| 336278 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 7 | 12 | 0 | United States | united states | |
| 336279 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 8 | 10 | 7 | California | california | |
| 336280 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 9 | 7 | 0 | San Francisco | san francisco | |
| 336281 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 10 | 5 | 0 | San Francisco | san francisco | |
| 336282 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 336283 | 64497F20-E0C5-4705-AF2E-3138AEF78655 | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336484 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 161 | 2055 | 0 | Favorites | favorites | |
| 336485 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 2 | 2046 | 0 | Live Photos | live photos | |
| 336486 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 976 | 2030 | 0 | Winter | winter | |
| 336487 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 977 | 1014 | 0 | February | february | |
| 336488 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 8073 | 1015 | 0 | 2018 | 2018 | |
| 336489 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 3544 | 2056 | 0 | IMG_3105.HEIC | img_3105.heic | |
| 336490 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 7 | 12 | 0 | United States | united states | |
| 336491 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 8 | 10 | 7 | California | california | |
| 336492 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 9 | 7 | 0 | San Francisco | san francisco | |
| 336493 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 10 | 5 | 0 | San Francisco | san francisco | |
| 336494 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 336495 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336606 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 2 | 2046 | 0 | Live Photos | live photos | |
| 336607 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 280 | 2024 | 0 | Document | document | |
| 336608 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 283 | 2024 | 0 | Printed Page | printed page | |
| 336609 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 3545 | 2024 | 0 | Skull | skull | |
| 336610 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 286 | 2024 | 0 | People | people | |
| 336611 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 976 | 2030 | 0 | Winter | winter | |
| 336612 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 977 | 1014 | 0 | February | february | |
| 336613 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 8073 | 1015 | 0 | 2018 | 2018 | |
| 336614 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 3324 | 2056 | 0 | IMG_3175.HEIC | img_3175.heic | |
| 336615 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 7 | 12 | 0 | United States | united states | |
| 336616 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 8 | 10 | 7 | California | california | |
| 336617 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 9 | 7 | 0 | San Francisco | san francisco | |
| 336618 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 10 | 5 | 0 | San Francisco | san francisco | |
| 336619 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 6113 | 3 | 0 | Miraloma Park | miraloma park | |
| 336620 | 7A98496A-6D5F-4DE6-AD5D-E39097D7596D | 12085 | 2 | 6113 | Evelyn Way | evelyn way | |
| 336675 | 8331EEF1-9BBD-4F19-82BC-D3C1598AE23A | 2 | 2046 | 0 | Live Photos | live photos | |
| 336676 | 8331EEF1-9BBD-4F19-82BC-D3C1598AE23A | 976 | 2030 | 0 | Winter | winter | |
| 336677 | 8331EEF1-9BBD-4F19-82BC-D3C1598AE23A | 977 | 1014 | 0 | February | february |
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]);