This data as json, CSV (advanced)
Suggested facets: persons, latitude, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (array)
rowid | photo | uuid | date | albums | persons | ext | sha256 | size | latitude | longitude | favorite | portrait | screenshot | slow_mo | time_lapse | hdr | selfie | panorama | place_city | place_state_province | place_country | ZUUID | ZOVERALLAESTHETICSCORE | ZCURATIONSCORE | ZPROMOTIONSCORE | ZHIGHLIGHTVISIBILITYSCORE | ZBEHAVIORALSCORE | ZFAILURESCORE | ZHARMONIOUSCOLORSCORE | ZIMMERSIVENESSSCORE | ZINTERACTIONSCORE | ZINTERESTINGSUBJECTSCORE | ZINTRUSIVEOBJECTPRESENCESCORE | ZLIVELYCOLORSCORE | ZLOWLIGHT | ZNOISESCORE | ZPLEASANTCAMERATILTSCORE | ZPLEASANTCOMPOSITIONSCORE | ZPLEASANTLIGHTINGSCORE | ZPLEASANTPATTERNSCORE | ZPLEASANTPERSPECTIVESCORE | ZPLEASANTPOSTPROCESSINGSCORE | ZPLEASANTREFLECTIONSSCORE | ZPLEASANTSYMMETRYSCORE | ZSHARPLYFOCUSEDSUBJECTSCORE | ZTASTEFULLYBLURREDSCORE | ZWELLCHOSENSUBJECTSCORE | ZWELLFRAMEDSUBJECTSCORE | ZWELLTIMEDSHOTSCORE |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85 | AB43E9CF-7846-4218-AB2E-191D1BA9844E | 2018-04-22T00:28:56+00:00 | [ "Museums", "Public" ] |
[] |
heic | 2505fedb3a6c4adda57f5fafeeb29bbbe3447a7da7bf09c014addd6f79ba756e | 1200228 | 37.57899666666667 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | AB43E9CF-7846-4218-AB2E-191D1BA9844E | 0.2392578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0087432861328125 | -0.003875732421875 | 0.0011968612670898438 | 0.009999999776482582 | -0.47119140625 | -0.08758544921875 | 0.234130859375 | 0.0017957687377929688 | -0.04638671875 | -0.11126708984375 | -0.45068359375 | -0.13720703125 | 0.04486083984375 | -0.26708984375 | -0.00777435302734375 | -0.0256500244140625 | 0.0005702972412109375 | 0.02215576171875 | -0.038177490234375 | -0.321533203125 | -0.126708984375 | -0.12396240234375 | |
256 | 12AB4E54-7810-428D-A275-7CB631F2E33A | 2018-04-22T00:28:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 7d55d7d466216fbc80457ea3e500d95d876bd57e356d6cd1b286763c18830a3a | 1663615 | 37.579253333333334 | -122.34427833333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 12AB4E54-7810-428D-A275-7CB631F2E33A | 0.4423828125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.049224853515625 | 0.0011749267578125 | 0.00530242919921875 | 0.009999999776482582 | -0.5498046875 | -0.0706787109375 | -0.1641845703125 | 0.075439453125 | -0.18798828125 | -0.06243896484375 | -0.378173828125 | -0.595703125 | 0.022674560546875 | -0.04718017578125 | -0.002899169921875 | -0.0088348388671875 | 0.0022525787353515625 | 0.0029582977294921875 | -0.265625 | -0.010894775390625 | -0.1243896484375 | 0.035186767578125 | |
83 | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 2018-04-22T00:19:14+00:00 | [ "Museums", "Public" ] |
[] |
heic | 246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410 | 1382543 | 37.57926666666667 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 0.44775390625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00217437744140625 | 0.007617950439453125 | 0.00279998779296875 | 0.019999999552965164 | 0.0296630859375 | -0.06707763671875 | 0.161865234375 | 0.005039215087890625 | -0.02947998046875 | -0.06591796875 | -0.220458984375 | -0.12347412109375 | 0.06634521484375 | -0.047119140625 | 0.000492095947265625 | -0.016754150390625 | 0.0034027099609375 | 0.0193023681640625 | -0.02313232421875 | -0.205810546875 | 0.237060546875 | 0.01519775390625 | |
183 | 2B9169E5-91EE-4E3C-8B1D-DAFF93D38079 | 2018-04-22T00:19:03+00:00 | [ "Museums", "Public" ] |
[] |
heic | 5a49d99dca4b4f1b4838d83ab1b8544b00c59242fda2d05092208ba0fb0fce77 | 649257 | 37.579258333333335 | -122.34417833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 2B9169E5-91EE-4E3C-8B1D-DAFF93D38079 | 0.443359375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00128936767578125 | 0.01422882080078125 | 0.0014896392822265625 | 0.009999999776482582 | -0.364990234375 | -0.06549072265625 | 0.05987548828125 | 0.010009765625 | -0.0121917724609375 | -0.009185791015625 | -0.06787109375 | -0.0714111328125 | 0.03948974609375 | 0.119384765625 | 0.00177764892578125 | -0.017974853515625 | 0.007175445556640625 | 0.17041015625 | 0.0899658203125 | 0.02398681640625 | 0.697265625 | 0.01007843017578125 | |
410 | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 2018-04-22T00:18:11+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a | 1495272 | 37.57904666666667 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 0.1875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.012054443359375 | -0.01104736328125 | 0.0017414093017578125 | 0.009999999776482582 | -0.1734619140625 | -0.09124755859375 | 0.07891845703125 | 0.010986328125 | -0.1014404296875 | -0.08251953125 | -0.462646484375 | -0.359130859375 | 0.07611083984375 | -0.150390625 | -0.00496673583984375 | -0.0238494873046875 | 0.0022335052490234375 | 0.007755279541015625 | -0.208251953125 | -0.61328125 | 0.0023193359375 | -0.1900634765625 | |
289 | 277756C5-6924-4E30-877D-CD2CE30630FD | 2018-04-22T00:17:52+00:00 | [ "Museums", "Public" ] |
[] |
heic | 8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af | 1177569 | 37.579096666666665 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 277756C5-6924-4E30-877D-CD2CE30630FD | 0.266357421875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.003795623779296875 | -0.0030517578125 | 0.0010366439819335938 | 0.009999999776482582 | -0.449951171875 | -0.03875732421875 | 0.1923828125 | 0.00323486328125 | -0.07781982421875 | -0.06396484375 | -0.1732177734375 | -0.1572265625 | 0.07476806640625 | -0.1436767578125 | -0.00726318359375 | -0.03466796875 | 0.0022602081298828125 | 0.035736083984375 | -0.0068206787109375 | -0.1612548828125 | 0.345703125 | -0.03826904296875 | |
481 | 3CEC2620-AD7D-45EC-A746-FDCADB335D44 | 2018-04-22T00:17:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | f580d10cba72fc669695ff3085997ee5f65672ae53c3ef0af3d6fa9e6ce9f508 | 1111271 | 37.57918 | -122.34427 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 3CEC2620-AD7D-45EC-A746-FDCADB335D44 | 0.10760498046875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0048675537109375 | -0.0013580322265625 | 0.0026111602783203125 | 0.05999999865889549 | 0.0594482421875 | -0.04840087890625 | 0.0380859375 | 0.025421142578125 | -0.11553955078125 | -0.04345703125 | -0.164306640625 | -0.293212890625 | 0.13671875 | -0.05029296875 | -7.2479248046875e-05 | -0.016326904296875 | 0.007122039794921875 | 0.0154876708984375 | -0.04864501953125 | -0.261474609375 | 0.332275390625 | -0.03924560546875 | |
356 | F3DAB898-0907-410B-B796-9999D8E773A7 | 2018-04-22T00:15:46+00:00 | [ "Museums", "Public" ] |
[] |
heic | ad9ef159b032c9390823705c5c527212864618c1f40128d3684b850dd5a27f96 | 857241 | 37.57923666666667 | -122.34424666666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | F3DAB898-0907-410B-B796-9999D8E773A7 | 0.322998046875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0035114288330078125 | 0.01099395751953125 | 0.0016546249389648438 | 0.009999999776482582 | 0.367431640625 | -0.06573486328125 | 0.036834716796875 | 0.0202178955078125 | -0.0823974609375 | -0.026947021484375 | -0.09014892578125 | -0.134521484375 | 0.0221099853515625 | 0.0318603515625 | 0.001338958740234375 | -0.00354766845703125 | 0.001934051513671875 | 0.037811279296875 | -0.01739501953125 | -0.032958984375 | 0.427734375 | 0.456298828125 | |
387 | 7A635293-467F-4C79-A04D-68A1C0250EB7 | 2018-04-22T00:15:41+00:00 | [ "Museums", "Public" ] |
[] |
heic | c2d8185df63eb139b856d3af911ee0006353b369ca2c37fc5983b4bfd073e700 | 821992 | 37.579195 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 7A635293-467F-4C79-A04D-68A1C0250EB7 | 0.38720703125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0255584716796875 | -0.002437591552734375 | 0.0027675628662109375 | 0.009999999776482582 | -0.60009765625 | -0.060089111328125 | -0.1300048828125 | 0.034942626953125 | -0.1910400390625 | -0.08111572265625 | -0.3076171875 | -0.5458984375 | 0.03265380859375 | -0.103759765625 | -0.002201080322265625 | -0.0175628662109375 | 0.004886627197265625 | 0.012054443359375 | -0.27099609375 | -0.03704833984375 | 0.268310546875 | -0.0233612060546875 | |
342 | E5CE20F5-1129-4B42-B765-D847EE083715 | 2018-04-22T00:15:27+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | a5e2d73b2ecb3c659734df6f3a73247ee4630cda0e44eade13e964894de7a03e | 695247 | 37.57915 | -122.3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | E5CE20F5-1129-4B42-B765-D847EE083715 | 0.354736328125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0029811859130859375 | -0.00356292724609375 | 0.003765106201171875 | 0.009999999776482582 | -0.5068359375 | -0.06512451171875 | 0.155029296875 | 0.0029239654541015625 | -0.027435302734375 | -0.134521484375 | -0.495849609375 | -0.180908203125 | 0.1697998046875 | -0.162353515625 | -0.0001468658447265625 | -0.0251922607421875 | 0.0031604766845703125 | 0.005889892578125 | -0.0141448974609375 | -0.1646728515625 | -0.341552734375 | -0.03619384765625 | |
315 | 9D1D2C1F-5BBF-4142-AABF-36F7DE028FA4 | 2018-04-22T00:15:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 99ce831cc3b5b6b9023d6175b29b6a234da11ec5f93beb38bc24d9d979f4d789 | 1660836 | 37.579175 | -122.34421666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 9D1D2C1F-5BBF-4142-AABF-36F7DE028FA4 | 0.370849609375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0017681121826171875 | 0.00678253173828125 | 0.0013561248779296875 | 0.009999999776482582 | -0.24658203125 | -0.0560302734375 | 0.31787109375 | 0.0022258758544921875 | -0.0206451416015625 | -0.05078125 | -0.2069091796875 | -0.0521240234375 | 0.11614990234375 | -0.126220703125 | -0.00042724609375 | -0.046661376953125 | 0.0025806427001953125 | 0.072509765625 | 0.055511474609375 | -0.2056884765625 | 0.286376953125 | -0.03350830078125 | |
75 | C4953733-B5AE-4410-B654-834DABC67F07 | 2018-04-22T00:13:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 2200c12e3a9702e7af07f66a41157f143b9441d5212bd6622b548c19064e3a6c | 1721928 | 37.579105 | -122.34422166666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | C4953733-B5AE-4410-B654-834DABC67F07 | 0.32861328125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00621795654296875 | 0.000286102294921875 | 0.0015668869018554688 | 0.009999999776482582 | 0.0181884765625 | -0.0751953125 | 0.048980712890625 | 0.01363372802734375 | -0.130615234375 | -0.0806884765625 | -0.282958984375 | -0.25732421875 | 0.0384521484375 | -0.126220703125 | -0.0027008056640625 | -0.011932373046875 | 0.0015850067138671875 | 0.01422882080078125 | -0.0546875 | -0.243408203125 | 0.141357421875 | 0.03662109375 | |
156 | EAA0FF98-970A-42AA-9938-75D632855967 | 2018-04-22T00:13:03+00:00 | [ "Museums", "Public" ] |
[] |
heic | 4b71652896076d2275b7de1855133d12f0e83e72e3f2df5eebccd312ee7801b2 | 1878279 | 37.5793 | -122.34407833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | EAA0FF98-970A-42AA-9938-75D632855967 | 0.22021484375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0008726119995117188 | 0.0216522216796875 | 0.004665374755859375 | 0.009999999776482582 | -0.7421875 | -0.0177764892578125 | 0.07159423828125 | 0.002704620361328125 | -0.00577545166015625 | -0.000347137451171875 | 0.2333984375 | 0.09246826171875 | 0.0205230712890625 | 0.12335205078125 | -0.00478363037109375 | -0.0034275054931640625 | 0.008575439453125 | 0.1749267578125 | 0.048919677734375 | 0.32470703125 | 0.72216796875 | 0.01009368896484375 | |
169 | EDD0562E-B010-44B3-9AA8-509F494351E1 | 2018-04-22T00:12:02+00:00 | [ "Museums", "Public" ] |
[] |
heic | 55a68d0f58176b06688b769b6be687ac460615526ed1d52affde448f153bba50 | 1024968 | 37.57923666666667 | -122.34407 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | EDD0562E-B010-44B3-9AA8-509F494351E1 | 0.272216796875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00806427001953125 | -0.00696563720703125 | 0.0023136138916015625 | 0.009999999776482582 | -0.1865234375 | -0.09136962890625 | 0.036529541015625 | 0.0190582275390625 | -0.0872802734375 | -0.07037353515625 | -0.467529296875 | -0.372314453125 | 0.133544921875 | -0.09869384765625 | -0.002712249755859375 | -0.031402587890625 | 0.00323486328125 | 0.0060272216796875 | -0.0687255859375 | -0.426513671875 | -0.1707763671875 | -0.10101318359375 | |
94 | 11842992-CE7D-4301-9925-A29B440C9C0E | 2018-04-22T00:11:30+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 29d25816cf8e645abe0cc1d731d8ab025a67e89a5058a98452eb2247900b17b3 | 1607783 | 37.57924166666667 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 11842992-CE7D-4301-9925-A29B440C9C0E | 0.414306640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.006641387939453125 | 0.0281524658203125 | 0.0015306472778320312 | 0.009999999776482582 | 0.0723876953125 | -0.04803466796875 | 0.3828125 | 0.01132965087890625 | -0.0234222412109375 | -0.0240478515625 | -0.040771484375 | -0.181884765625 | 0.03125 | -0.04730224609375 | -0.005859375 | -0.13427734375 | 0.002323150634765625 | 0.06610107421875 | 0.042755126953125 | -0.17333984375 | 0.408935546875 | -0.0148162841796875 | |
474 | 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 | 2018-04-22T00:11:22+00:00 | [ "Museums", "Public" ] |
[] |
heic | f2c7ee07ea7696e0578ff14d4b87dd76508999d46d251effe98dd0fa2093f429 | 1483372 | 37.57924166666667 | -122.34420833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 | 0.327392578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.002414703369140625 | -0.00057220458984375 | 0.0016546249389648438 | 0.009999999776482582 | -0.30322265625 | -0.090576171875 | 0.1556396484375 | 0.004573822021484375 | -0.0360107421875 | -0.1617431640625 | -0.436767578125 | -0.183349609375 | 0.146728515625 | -0.2203369140625 | -0.0005512237548828125 | -0.0244903564453125 | 0.0032863616943359375 | 0.018585205078125 | -0.017364501953125 | -0.263916015625 | -0.011474609375 | -0.04461669921875 | |
439 | D6E497F5-7F93-4434-96D4-7927D358886A | 2018-04-22T00:11:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | decf63b8e7a30b93e080919d312b4d985736ca17678d96fa4fdd3ce81c84a721 | 1463975 | 37.57925 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | D6E497F5-7F93-4434-96D4-7927D358886A | 0.331787109375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0006289482116699219 | 0.033294677734375 | 0.0013942718505859375 | 0.009999999776482582 | 0.0574951171875 | -0.040771484375 | 0.29443359375 | 0.0038700103759765625 | -0.01107025146484375 | 0.030059814453125 | 0.014404296875 | 0.0875244140625 | 0.0965576171875 | 0.1214599609375 | 0.0136871337890625 | -0.009765625 | 0.0038394927978515625 | 0.333984375 | 0.30810546875 | 0.0755615234375 | 0.6279296875 | 0.008331298828125 | |
125 | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 2018-04-22T00:11:12+00:00 | [ "Museums", "Public" ] |
[] |
heic | 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d | 1565205 | 37.57926666666667 | -122.34417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 0.23974609375 | 0.5 | 0.0 | 0.038931297721298594 | 0.5029440522193909 | -0.0008831024169921875 | 0.11505126953125 | 0.00395965576171875 | 0.019999999552965164 | 0.0281982421875 | -0.0225067138671875 | 0.27880859375 | 0.01009368896484375 | -0.0069580078125 | 0.039337158203125 | 0.1673583984375 | 0.260498046875 | 0.1424560546875 | 0.36865234375 | 0.142822265625 | -0.00147247314453125 | 0.00600433349609375 | 0.501953125 | 0.66943359375 | 0.48828125 | 0.607421875 | 0.0160064697265625 | |
392 | 2072695E-48EC-4C6E-9AFE-61F6590F67D5 | 2018-04-22T00:10:18+00:00 | [ "Museums", "Public" ] |
[] |
heic | c51fccdae579f930cf5e5523b5dd56c5e35900718a323b2451014d6c6b01ba42 | 1310899 | 37.57915 | -122.3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 2072695E-48EC-4C6E-9AFE-61F6590F67D5 | 0.340576171875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.00443267822265625 | -0.00213623046875 | 0.0015916824340820312 | 0.009999999776482582 | -0.85986328125 | -0.03253173828125 | 0.2386474609375 | 0.0009365081787109375 | -0.022247314453125 | -0.043243408203125 | -0.1949462890625 | -0.1187744140625 | 0.07342529296875 | -0.06146240234375 | -0.0161895751953125 | -0.0694580078125 | 0.001956939697265625 | 0.02508544921875 | 0.0008697509765625 | 0.0228271484375 | 0.1063232421875 | -0.014068603515625 | |
274 | E50B8F10-65AB-4938-AC6C-C8C35EB1C08C | 2018-04-22T00:10:07+00:00 | [ "Museums", "Public" ] |
[] |
heic | 8433d50000ebdf053b128c12d529091ee99a847d47e0d6317c002969b5406fed | 2209010 | 37.57922 | -122.34410833333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | E50B8F10-65AB-4938-AC6C-C8C35EB1C08C | 0.382080078125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.004364013671875 | -0.00274658203125 | 0.0011339187622070312 | 0.009999999776482582 | -0.724609375 | -0.03436279296875 | 0.255615234375 | 0.0015430450439453125 | -0.04595947265625 | -0.07611083984375 | -0.2100830078125 | -0.1217041015625 | 0.07965087890625 | -0.164306640625 | -0.0077056884765625 | -0.035980224609375 | 0.0015430450439453125 | 0.03314208984375 | 0.0018310546875 | -0.0218505859375 | 0.1365966796875 | -0.025054931640625 | |
3 | 625815AF-B061-4180-BFC5-CAC29E4C6C00 | 2018-04-22T00:09:55+00:00 | [ "Museums", "Public" ] |
[] |
heic | 026d54092af52aaf23fc7e1ed1c3c8077e7216791f262bbd80bf3d088dff4189 | 1858021 | 37.57933333333333 | -122.34430833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 625815AF-B061-4180-BFC5-CAC29E4C6C00 | 0.26025390625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0023975372314453125 | 0.019317626953125 | 0.006877899169921875 | 0.009999999776482582 | -0.95849609375 | -0.013427734375 | 0.1240234375 | 0.0006093978881835938 | -0.00399017333984375 | -0.0031070709228515625 | 0.12335205078125 | 0.0186767578125 | 0.01678466796875 | 0.05133056640625 | -0.034423828125 | -0.003108978271484375 | 0.003650665283203125 | 0.0794677734375 | 0.0251922607421875 | 0.23486328125 | 0.36328125 | 0.002391815185546875 | |
471 | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 2018-04-22T00:09:26+00:00 | [ "Museums", "Public" ] |
[] |
heic | ee05096b1dc7fa7fd6edc60c359f64e39652dff2b649169295cd2851fd1534f4 | 1519197 | 37.57923 | -122.34417833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | F5B3B67A-BE7F-4138-847F-A985B790A1D8 | 0.37353515625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.002132415771484375 | 0.0230255126953125 | 0.006565093994140625 | 0.009999999776482582 | -0.95654296875 | -0.01490020751953125 | 0.1636962890625 | 0.0006070137023925781 | -0.003376007080078125 | -0.0041961669921875 | 0.087890625 | 0.0185546875 | 0.0226287841796875 | 0.050140380859375 | -0.03076171875 | -0.003383636474609375 | 0.0035648345947265625 | 0.0706787109375 | 0.022705078125 | 0.1737060546875 | 0.287353515625 | 0.0017080307006835938 | |
319 | 2FBB5984-3AAC-4565-9233-9B05EF887714 | 2018-04-22T00:09:19+00:00 | [ "Museums", "Public" ] |
[] |
heic | 9bfa1e978780e33d9a9f007e41b3a57f6b57f2cfe5c9a5dff2486a1ccbd1d68d | 1272884 | 37.579208333333334 | -122.34419166666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 2FBB5984-3AAC-4565-9233-9B05EF887714 | 0.4208984375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.10968017578125 | -0.01126861572265625 | 0.0083770751953125 | 0.009999999776482582 | -0.4384765625 | -0.077392578125 | -0.07342529296875 | 0.03912353515625 | -0.236572265625 | -0.06561279296875 | -0.578125 | -0.57568359375 | 0.07489013671875 | -0.11090087890625 | -0.004486083984375 | -0.012664794921875 | 0.002208709716796875 | 0.0013303756713867188 | -0.6240234375 | -0.270751953125 | -0.458740234375 | -0.2105712890625 | |
398 | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 2018-04-22T00:09:15+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb | 1643785 | 37.57917 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 0.36279296875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0012941360473632812 | 0.027679443359375 | 0.0012941360473632812 | 0.019999999552965164 | -0.12005615234375 | -0.033203125 | 0.3701171875 | 0.0015306472778320312 | -0.00894927978515625 | 0.0038604736328125 | -0.0025634765625 | 0.030609130859375 | 0.054412841796875 | 0.017578125 | 0.00809478759765625 | -0.013641357421875 | 0.001628875732421875 | 0.26904296875 | 0.358642578125 | 0.220458984375 | 0.546875 | -0.00630950927734375 | |
333 | 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC | 2018-04-22T00:09:10+00:00 | [ "Museums", "Public" ] |
[] |
heic | a1c2d7f8756e2101b0239087ebb5d55c79665b49f2e5800fd492e41afa56e8ba | 1348018 | 37.579005 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 74FF69CF-A6F6-42CA-A2C1-1FBBB4F22EEC | 0.336181640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0013408660888671875 | 0.0460205078125 | 0.00714874267578125 | 0.009999999776482582 | -0.91552734375 | -0.01094818115234375 | 0.233154296875 | 0.0013990402221679688 | -0.0037212371826171875 | -0.003269195556640625 | 0.16455078125 | 0.0635986328125 | 0.07611083984375 | 0.074462890625 | -0.036651611328125 | -0.0025501251220703125 | 0.007724761962890625 | 0.0885009765625 | 0.035003662109375 | 0.19482421875 | 0.328857421875 | 0.0035648345947265625 | |
324 | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 2018-04-22T00:07:16+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 9dbef4fb7519b183da13d3ce4beb757618271e8a3b5805186c71c661d8979557 | 1922748 | 37.57928 | -122.344095 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 0.343017578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0009698867797851562 | 0.048065185546875 | 0.0038089752197265625 | 0.009999999776482582 | -0.1185302734375 | -0.0616455078125 | 0.208984375 | 0.01029205322265625 | -0.01132965087890625 | -0.01513671875 | -0.109130859375 | 0.07952880859375 | 0.1773681640625 | 0.173828125 | 0.0297088623046875 | -0.0113525390625 | 0.006565093994140625 | 0.1048583984375 | 0.1142578125 | 0.0379638671875 | 0.283447265625 | 0.007232666015625 | |
311 | 01FA701A-92D3-4818-934F-50FA0562366C | 2018-04-22T00:05:51+00:00 | [ "Museums", "Public" ] |
[] |
heic | 96fb0f6d09e9f87f06302d22cf26737a25371c0c18822ca26c593820c668a15e | 1098048 | 37.57925 | -122.34414666666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 01FA701A-92D3-4818-934F-50FA0562366C | 0.2005615234375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0199127197265625 | -0.001682281494140625 | 0.0020198822021484375 | 0.009999999776482582 | -0.62646484375 | -0.093017578125 | -0.0875244140625 | 0.03533935546875 | -0.09088134765625 | -0.07763671875 | -0.431640625 | -0.4853515625 | 0.045196533203125 | -0.1025390625 | -0.002063751220703125 | -0.023529052734375 | 0.00428009033203125 | 0.02215576171875 | -0.2459716796875 | -0.09869384765625 | 0.213134765625 | -0.024993896484375 | |
263 | 0EC5864B-16CC-4B6C-B890-330ADF4998BD | 2018-04-22T00:05:41+00:00 | [ "Museums", "Public" ] |
[] |
heic | 7f541fc393d29c06197b005642f20cbc519a3b2eedb36eb33aeedb64fec2a9a4 | 1547943 | 37.57927166666666 | -122.34417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 0EC5864B-16CC-4B6C-B890-330ADF4998BD | 0.12451171875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.003765106201171875 | 0.008758544921875 | 0.0016422271728515625 | 0.009999999776482582 | -0.1055908203125 | -0.080078125 | 0.202392578125 | 0.00679779052734375 | -0.0211181640625 | -0.021209716796875 | -0.2249755859375 | -0.0849609375 | 0.0831298828125 | -0.0423583984375 | -0.0029449462890625 | -0.016387939453125 | 0.0023975372314453125 | 0.08416748046875 | 0.1640625 | -0.219482421875 | 0.373046875 | -0.02490234375 | |
292 | 9FA3546D-056E-4B3F-BBAC-AD74DEA303C4 | 2018-04-22T00:04:35+00:00 | [ "Museums", "Public" ] |
[] |
heic | 8d672867493a2635c0ce87db82e6bb9558101a21240edf4046975c067f2c7ccf | 977952 | 37.57924666666667 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 9FA3546D-056E-4B3F-BBAC-AD74DEA303C4 | 0.321533203125 | 0.5 | 0.0 | 0.038931297721298594 | 0.5035279989242554 | -0.0008831024169921875 | 0.027801513671875 | 0.0017070770263671875 | 0.009999999776482582 | 0.28515625 | -0.0247039794921875 | 0.1964111328125 | 0.00605010986328125 | -0.0131683349609375 | 0.01238250732421875 | 0.126220703125 | 0.086181640625 | 0.06793212890625 | 0.0987548828125 | 0.015655517578125 | -0.003993988037109375 | 0.004924774169921875 | 0.382080078125 | 0.468017578125 | 0.25732421875 | 0.76025390625 | 0.03424072265625 | |
265 | B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E | 2018-04-22T00:04:28+00:00 | [ "Museums", "Public" ] |
[] |
heic | 7ff235acd3b220a7af4ba71085813dcdce87ec322760ed6582ce5e4b4fb3230c | 816374 | 37.57928 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | B95E6DC5-8DFC-4B5B-86DC-68D7616C8C0E | 0.312255859375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0012998580932617188 | 0.0130767822265625 | 0.0015974044799804688 | 0.009999999776482582 | -0.0648193359375 | -0.0279083251953125 | 0.3154296875 | 0.0017547607421875 | -0.0207672119140625 | -0.0150146484375 | -0.02239990234375 | -0.03936767578125 | 0.07696533203125 | -0.02813720703125 | 0.003704071044921875 | -0.0173797607421875 | 0.003223419189453125 | 0.09466552734375 | 0.042572021484375 | 0.090087890625 | 0.52490234375 | -0.01253509521484375 | |
71 | 545CBF13-E5F7-4578-91E5-9CA7B023C4C5 | 2018-04-22T00:03:54+00:00 | [ "Museums", "Public" ] |
[] |
heic | 20691171064e414f4bfd70079cbf95f8e0fd8e2ab16607a9e42cf54dfe9ef556 | 1917741 | 37.579186666666665 | -122.34416166666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 545CBF13-E5F7-4578-91E5-9CA7B023C4C5 | 0.27587890625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0015850067138671875 | 0.0015106201171875 | 0.0026416778564453125 | 0.009999999776482582 | 0.0125732421875 | -0.049224853515625 | 0.2352294921875 | 0.00524139404296875 | -0.0283355712890625 | -0.026763916015625 | -0.180908203125 | -0.09490966796875 | 0.1695556640625 | -0.0295867919921875 | -0.003448486328125 | -0.0282135009765625 | 0.004791259765625 | 0.019561767578125 | 0.0013427734375 | -0.396728515625 | 0.2037353515625 | -0.0394287109375 | |
42 | E7C46C63-F84B-4535-86A7-A5028CC63E4B | 2018-04-22T00:03:12+00:00 | [ "Museums", "Public" ] |
[] |
heic | 15b45da65030853a16ffc5e9a54b126d8e1929e82845475fd96f7cf4459758b6 | 2320879 | 37.57927 | -122.34416166666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | E7C46C63-F84B-4535-86A7-A5028CC63E4B | 0.36865234375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00518035888671875 | 0.01081085205078125 | 0.004924774169921875 | 0.009999999776482582 | -0.9609375 | -0.0221099853515625 | 0.053680419921875 | 0.0009508132934570312 | -0.0069580078125 | -0.00634002685546875 | 0.0328369140625 | -0.09417724609375 | 0.012969970703125 | 0.037017822265625 | -0.029510498046875 | -0.00531768798828125 | 0.003223419189453125 | 0.051177978515625 | -0.01397705078125 | 0.2305908203125 | 0.384765625 | 0.0015316009521484375 | |
484 | 75D227E6-3F2B-41A8-9977-E9B55255C861 | 2018-04-22T00:03:04+00:00 | [ "Museums", "Public" ] |
[] |
heic | f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378 | 1924547 | 37.57926166666667 | -122.34416166666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 75D227E6-3F2B-41A8-9977-E9B55255C861 | 0.17236328125 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.00536346435546875 | 0.003108978271484375 | 0.004718780517578125 | 0.009999999776482582 | -0.2900390625 | -0.139892578125 | -0.10870361328125 | 0.0699462890625 | -0.03338623046875 | -0.060302734375 | -0.52392578125 | -0.42333984375 | 0.15771484375 | 0.0250244140625 | 0.0015716552734375 | -0.01311492919921875 | 0.0117340087890625 | 0.009521484375 | -0.08758544921875 | -0.118408203125 | -0.0535888671875 | 0.0139007568359375 | |
486 | 5A10AEF0-50DA-41BE-80F2-79E3367C343E | 2018-04-22T00:02:59+00:00 | [ "Museums", "Public" ] |
[] |
heic | fa48b9304c0a1de7f0cc8a3512c76452dc458964ea0394ea346740ed8b71eee9 | 1657904 | 37.579253333333334 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 5A10AEF0-50DA-41BE-80F2-79E3367C343E | 0.364501953125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.005428314208984375 | -0.009002685546875 | 0.0024242401123046875 | 0.019999999552965164 | -0.136962890625 | -0.06658935546875 | 0.1895751953125 | 0.00661468505859375 | -0.07861328125 | -0.124267578125 | -0.375244140625 | -0.223388671875 | 0.31005859375 | -0.18896484375 | -0.0026531219482421875 | -0.03070068359375 | 0.0036067962646484375 | 0.007518768310546875 | -0.0423583984375 | -0.465576171875 | -0.2138671875 | -0.1270751953125 | |
464 | 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC | 2018-04-22T00:00:15+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | e9ca2c634c5bd6c32b8b1eff0a8e907e16256a4245af095292831a5ba124ffa0 | 1480015 | 37.57921666666667 | -122.34423833333334 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC | 0.420166015625 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.0068511962890625 | 0.015228271484375 | 0.0059356689453125 | 0.009999999776482582 | -0.2369384765625 | -0.09124755859375 | -0.0821533203125 | 0.04107666015625 | -0.034027099609375 | -0.052093505859375 | -0.26123046875 | -0.32080078125 | 0.0325927734375 | 0.0858154296875 | 0.006381988525390625 | -0.004791259765625 | 0.004364013671875 | 0.01036834716796875 | -0.05767822265625 | 0.0079803466796875 | 0.0189208984375 | 0.0738525390625 |
JSON shape: default, array, newline-delimited
CREATE VIEW photos_with_apple_metadata AS select apple_photos.rowid, json_object( 'img_src', 'https://photos.simonwillison.net/i/' || uploads.sha256 || '.' || uploads.ext || '?w=600' ) as photo, apple_photos.uuid, apple_photos.date, apple_photos.albums, apple_photos.persons, uploads.ext, uploads.sha256, uploads.size, latitude, longitude, favorite, portrait, screenshot, slow_mo, time_lapse, hdr, selfie, panorama, place_city, place_state_province, place_country, apple_photos_scores.* from apple_photos join uploads on apple_photos.sha256 = uploads.sha256 left join apple_photos_scores on apple_photos.uuid = apple_photos_scores.ZUUID order by apple_photos.date desc;