This data as json, CSV (advanced)
id ▼ | uuid | groupid | category | owning_groupid | content_string | normalized_string | lookup_identifier |
---|---|---|---|---|---|---|---|
55077 | FF230430-EDD4-4E3F-83F9-C105A7EE7598 | 2530 | 1015 | 0 | 2019 | 2019 | |
55078 | FF230430-EDD4-4E3F-83F9-C105A7EE7598 | 6513 | 2056 | 0 | IMG_0074.JPG | img_0074.jpg | |
64234 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 161 | 2055 | 0 | Favorites | favorites | |
64235 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 1373 | 2053 | 0 | Portrait | portrait | |
64236 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 340 | 2024 | 0 | Clothing | clothing | |
64237 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 377 | 2024 | 0 | Eyeglasses | eyeglasses | |
64238 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 376 | 2024 | 0 | Optical Equipment | optical equipment | |
64239 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 286 | 2024 | 0 | People | people | |
64240 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 347 | 2024 | 0 | Adult | adult | |
64241 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 2960 | 2030 | 0 | Fall | fall | |
64242 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 4131 | 1014 | 0 | September | september | |
64243 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 2530 | 1015 | 0 | 2019 | 2019 | |
64244 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 193 | 2021 | 0 | Simon Willison | simon willison | 000B9B44-5E9D-4D2F-81E3-4FDFEA05ADC8 |
64245 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 7355 | 2056 | 0 | IMG_0007.HEIC | img_0007.heic | |
64246 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 7 | 12 | 0 | United States | united states | |
64247 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 8 | 10 | 7 | California | california | |
64248 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 9 | 7 | 0 | San Francisco | san francisco | |
64249 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 10 | 5 | 0 | San Francisco | san francisco | |
64250 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 2160 | 3 | 10 | Castro | castro | |
64251 | B03FB29E-EB36-434D-91D2-C6A2C625A252 | 4469 | 2 | 0 | 21st St | 21st st | |
65763 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 161 | 2055 | 0 | Favorites | favorites | |
65764 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2314 | 2051 | 0 | Animated | animated | |
65765 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2 | 2046 | 0 | Live Photos | live photos | |
65766 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 348 | 2024 | 0 | Window | window | |
65767 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2960 | 2030 | 0 | Fall | fall | |
65768 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 4131 | 1014 | 0 | September | september | |
65769 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 2530 | 1015 | 0 | 2019 | 2019 | |
65770 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 7501 | 2056 | 0 | IMG_7336.HEIC | img_7336.heic | |
65771 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 7 | 12 | 0 | United States | united states | |
65772 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 8 | 10 | 7 | California | california | |
65773 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 960 | 7 | 0 | San Mateo | san mateo | |
65774 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 961 | 5 | 960 | Menlo Park | menlo park | |
65775 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park | |
65776 | 159FCAD3-7088-4AEB-929A-7BCDFF4A628A | 1642 | 2 | 962 | Santa Cruz Ave | santa cruz ave | |
66632 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 161 | 2055 | 0 | Favorites | favorites | |
66633 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 2 | 2046 | 0 | Live Photos | live photos | |
66634 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 2960 | 2030 | 0 | Fall | fall | |
66635 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 4131 | 1014 | 0 | September | september | |
66636 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 2530 | 1015 | 0 | 2019 | 2019 | |
66637 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 7572 | 2056 | 0 | IMG_7333.HEIC | img_7333.heic | |
66638 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 7 | 12 | 0 | United States | united states | |
66639 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 8 | 10 | 7 | California | california | |
66640 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 960 | 7 | 0 | San Mateo | san mateo | |
66641 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 961 | 5 | 960 | Menlo Park | menlo park | |
66642 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 962 | 3 | 961 | Downtown Menlo Park | downtown menlo park | |
66643 | 5C91B5A8-1A4C-4406-B5E6-11883EFC714E | 1642 | 2 | 962 | Santa Cruz Ave | santa cruz ave | |
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 | |
151888 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 312 | 2024 | 0 | Animal | animal | |
151889 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 313 | 2024 | 0 | Mammal | mammal | |
151890 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 314 | 2024 | 0 | Canine | canine | |
151891 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 310 | 2024 | 0 | Dog | dog | |
151892 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 13641 | 2024 | 0 | Corgi | corgi | |
151893 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 3 | 2030 | 0 | Spring | spring | |
151894 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 6230 | 1014 | 0 | May | may | |
151895 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 2530 | 1015 | 0 | 2019 | 2019 | |
151896 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 1259 | 2056 | 0 | IMG_4038.HEIC | img_4038.heic | |
151897 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 7 | 12 | 0 | United States | united states | |
151898 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 8 | 10 | 7 | California | california | |
151899 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 9 | 7 | 0 | San Francisco | san francisco | |
151900 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 10 | 5 | 0 | San Francisco | san francisco | |
151901 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 11 | 3 | 10 | Hayes Valley | hayes valley | |
151902 | 2BE0CB22-929B-463E-B20C-83A518787BB4 | 107 | 2 | 0 | Hayes St | hayes 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 | |
154674 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 312 | 2024 | 0 | Animal | animal | |
154675 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 313 | 2024 | 0 | Mammal | mammal | |
154676 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 300 | 2024 | 0 | Road | road | |
154677 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 296 | 2024 | 0 | Outdoor | outdoor | |
154678 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 295 | 2024 | 0 | Land | land | |
154679 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 3 | 2030 | 0 | Spring | spring | |
154680 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 6230 | 1014 | 0 | May | may | |
154681 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 2530 | 1015 | 0 | 2019 | 2019 | |
154682 | 39333D7D-3020-4A1B-970D-44F2DD6D5C52 | 15859 | 2056 | 0 | IMG_5990.JPG | img_5990.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]);