This data as json, CSV (advanced)
Suggested facets: ext, favorite, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, albums (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44 | ![]() |
46ABC862-9837-404A-832B-4158270704FF | 2019-11-02T20:32:16+00:00 | [ "Public" ] |
[] |
jpeg | 169984801ec60631b48ca4acac75c2c745951a72024d7145f7803a2978e59267 | 4760871 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 46ABC862-9837-404A-832B-4158270704FF | 0.7314453125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0031604766845703125 | -0.007091522216796875 | 0.0027141571044921875 | 0.019999999552965164 | 0.05517578125 | -0.057586669921875 | 0.1978759765625 | 0.004055023193359375 | -0.05718994140625 | -0.051116943359375 | -0.272216796875 | -0.1932373046875 | 0.1597900390625 | -0.08160400390625 | -0.00304412841796875 | -0.0216217041015625 | 0.0029125213623046875 | 0.006717681884765625 | -0.0247039794921875 | -0.5302734375 | -0.07275390625 | -0.1270751953125 | |||||
50 | ![]() |
B0F72802-C713-43D3-899A-81C4AED347DC | 2019-11-02T20:32:07+00:00 | [ "Public" ] |
[] |
jpeg | 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 | 4949434 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B0F72802-C713-43D3-899A-81C4AED347DC | 0.79150390625 | 0.75 | 0.0 | 0.06261464384675935 | 0.10000000149011612 | -0.0027790069580078125 | -0.003040313720703125 | 0.0018463134765625 | 0.03999999910593033 | 0.2215576171875 | -0.05780029296875 | 0.063232421875 | 0.00916290283203125 | -0.085693359375 | -0.040863037109375 | -0.1737060546875 | -0.291259765625 | 0.11456298828125 | -0.05914306640625 | -0.00067138671875 | -0.021148681640625 | 0.00473785400390625 | 0.00933837890625 | -0.023468017578125 | -0.37060546875 | 0.235595703125 | -0.053070068359375 | |||||
59 | ![]() |
E28B94C5-3FD9-4199-B291-5727F3D40053 | 2019-11-02T20:32:12+00:00 | [ "Public" ] |
[] |
jpeg | 1bf6f978059091efb89907071b2796f19db07ba2994d6826fc794dcb1ce3d38a | 4830969 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E28B94C5-3FD9-4199-B291-5727F3D40053 | 0.7939453125 | 0.75 | 0.0 | 0.06261464384675935 | 0.10000000149011612 | -0.0024433135986328125 | 0.001224517822265625 | 0.0018033981323242188 | 0.009999999776482582 | -0.83935546875 | -0.09027099609375 | 0.05169677734375 | 0.002811431884765625 | -0.011199951171875 | -0.04876708984375 | -0.432861328125 | -0.2054443359375 | 0.03314208984375 | -0.02099609375 | -0.005584716796875 | -0.0362548828125 | 0.00319671630859375 | 0.0261077880859375 | -0.0133209228515625 | -0.05126953125 | 0.1944580078125 | -0.007366180419921875 | |||||
65 | ![]() |
FC01AB36-9465-4F95-8DC9-618FBC1405A6 | 2019-11-02T20:30:03+00:00 | [ "Public" ] |
[] |
jpeg | 1da3b02a32b8235544f503965aa55528896aa637e79e12bdf6493c8541967cea | 4491789 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FC01AB36-9465-4F95-8DC9-618FBC1405A6 | 0.76708984375 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0016355514526367188 | 0.00383758544921875 | 0.00473785400390625 | 0.019999999552965164 | -0.46875 | -0.10015869140625 | 0.09564208984375 | 0.0033111572265625 | -0.011871337890625 | -0.065673828125 | -0.497802734375 | -0.1065673828125 | 0.06732177734375 | -0.025115966796875 | -0.002429962158203125 | -0.0179290771484375 | 0.003040313720703125 | 0.0097808837890625 | -0.01000213623046875 | -0.1546630859375 | -0.1719970703125 | -0.0113983154296875 | |||||
67 | ![]() |
E38B4879-580E-454E-A06C-65335EDEBEB1 | 2019-11-02T20:23:18+00:00 | [ "Public" ] |
[] |
jpeg | 1eb091d77226738cc72f75ec19792182635c5a0ecc5dc77cac70f36c17bb0a54 | 5444495 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E38B4879-580E-454E-A06C-65335EDEBEB1 | 0.6572265625 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0016937255859375 | -0.00299835205078125 | 0.0031604766845703125 | 0.009999999776482582 | -0.61767578125 | -0.0261993408203125 | 0.310302734375 | 0.0011653900146484375 | -0.0207977294921875 | -0.05755615234375 | -0.1907958984375 | -0.0826416015625 | 0.33056640625 | -0.05499267578125 | -0.004913330078125 | -0.036773681640625 | 0.00595855712890625 | 0.01306915283203125 | -0.00167083740234375 | -0.10516357421875 | -0.0482177734375 | -0.0196990966796875 | |||||
87 | ![]() |
F6C8C0BE-AC14-43D9-93DD-ABBE269505DC | 2019-11-02T20:32:08+00:00 | [ "Public" ] |
[] |
jpeg | 25ec2f2b497ddc05179526c0bc05ba1f553cce0e43638d01223a39f1b092a890 | 4871874 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F6C8C0BE-AC14-43D9-93DD-ABBE269505DC | 0.77783203125 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.0036067962646484375 | -0.00318145751953125 | 0.002521514892578125 | 0.009999999776482582 | -0.092529296875 | -0.1480712890625 | 0.102783203125 | 0.00926971435546875 | -0.024383544921875 | -0.09161376953125 | -0.60888671875 | -0.254638671875 | 0.10968017578125 | -0.09063720703125 | -0.0031261444091796875 | -0.0168914794921875 | 0.0022335052490234375 | 0.0059814453125 | -0.056488037109375 | -0.429443359375 | -0.284912109375 | -0.06451416015625 | |||||
90 | ![]() |
9D0280F7-D619-4D2C-B323-B21CAEBA92EF | 2019-11-02T20:31:31+00:00 | [ "Public" ] |
[] |
jpeg | 277b4b361f6df02e423d1000b4d2a98c758f29a027c4bff347000b3ee93de2ed | 4596329 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9D0280F7-D619-4D2C-B323-B21CAEBA92EF | 0.8193359375 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.001941680908203125 | 0.004848480224609375 | 0.0013561248779296875 | 0.009999999776482582 | -0.90771484375 | -0.10125732421875 | 0.0489501953125 | 0.003635406494140625 | -0.00595855712890625 | -0.0113525390625 | -0.378173828125 | -0.061279296875 | 0.017303466796875 | 0.031341552734375 | -0.0163116455078125 | -0.0170745849609375 | 0.002140045166015625 | 0.134033203125 | 0.1602783203125 | -0.002685546875 | 0.431396484375 | -0.00119781494140625 | |||||
91 | ![]() |
B47D9214-ACC0-4A75-8837-8DCA2E7F0D28 | 2019-11-02T20:22:51+00:00 | [ "Public" ] |
[] |
jpeg | 27ae6d9cd414eca3aa086919a529fd63f550fefc6964ab92515be63b486de62e | 4517624 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B47D9214-ACC0-4A75-8837-8DCA2E7F0D28 | 0.5869140625 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.0007295608520507812 | 0.031158447265625 | 0.0016937255859375 | 0.009999999776482582 | -0.067138671875 | -0.03131103515625 | 0.1988525390625 | 0.004608154296875 | -0.012969970703125 | 0.0157470703125 | 0.07708740234375 | 0.0693359375 | 0.07708740234375 | 0.1923828125 | 0.013427734375 | -0.0103607177734375 | 0.00591278076171875 | 0.296142578125 | 0.18017578125 | 0.2158203125 | 0.68310546875 | 0.009979248046875 | |||||
106 | ![]() |
A9DA3A99-BD48-48F2-9F5A-2328329D320E | 2019-11-02T20:22:53+00:00 | [ "Public" ] |
[] |
jpeg | 332ae7b6996628d3cf858e9bccf07d4bc9a2e710417d39f9dd6765a3ef3da0b9 | 4865133 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A9DA3A99-BD48-48F2-9F5A-2328329D320E | 0.60498046875 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.0038089752197265625 | 0.004974365234375 | 0.0094146728515625 | 0.009999999776482582 | -0.93798828125 | -0.020294189453125 | 0.125 | 0.00047278404235839844 | -0.01049041748046875 | -0.01259613037109375 | -0.08746337890625 | -0.06536865234375 | 0.0180511474609375 | 0.003448486328125 | -0.0253753662109375 | -0.0078582763671875 | 0.0019121170043945312 | 0.0136871337890625 | -0.0081939697265625 | 0.07769775390625 | 0.00811767578125 | -0.0020694732666015625 | |||||
107 | ![]() |
8A1CFD4F-AF9F-4018-A451-4709416FAEA0 | 2019-11-02T20:39:44+00:00 | [ "Public" ] |
[] |
jpeg | 3345e08925ea68ce3808102dce8f4b4e08f6c65a77d405c8b7a4741c322e0c68 | 4263841 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8A1CFD4F-AF9F-4018-A451-4709416FAEA0 | 0.7177734375 | 0.75 | 0.0 | 0.06262569391090451 | 0.10000000149011612 | -0.0007410049438476562 | 0.0189056396484375 | 0.0011157989501953125 | 0.019999999552965164 | -0.064697265625 | -0.046905517578125 | 0.2431640625 | 0.0034160614013671875 | -0.01358795166015625 | 0.0128173828125 | -0.04541015625 | 0.04571533203125 | 0.055206298828125 | 0.05841064453125 | 0.003330230712890625 | -0.0134429931640625 | 0.0029582977294921875 | 0.242919921875 | 0.160888671875 | -0.0233154296875 | 0.61572265625 | 0.01202392578125 | |||||
111 | ![]() |
7C21930F-62A8-4540-91C4-E080707A4CC5 | 2019-11-02T20:31:20+00:00 | [ "Public" ] |
[] |
jpeg | 36e9d2b9e79747b29aba0606d0b8a6a563111ad6a8213a36e618b33d5ee41b51 | 4685234 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7C21930F-62A8-4540-91C4-E080707A4CC5 | 0.779296875 | 0.5 | 0.0 | 0.043530951929456406 | 0.1007542610168457 | -0.0011835098266601562 | 0.025787353515625 | 0.0009326934814453125 | 0.05999999865889549 | 0.278076171875 | -0.04083251953125 | 0.369140625 | 0.0016613006591796875 | -0.0106964111328125 | 0.01271820068359375 | 0.024322509765625 | 0.04644775390625 | 0.0217742919921875 | 0.004058837890625 | 0.014617919921875 | -0.00887298583984375 | 0.0007381439208984375 | 0.381103515625 | 0.61376953125 | 0.31591796875 | 0.67724609375 | -0.0018157958984375 | |||||
114 | ![]() |
4E45EBA2-F531-4076-8741-A6D18656D677 | 2019-11-02T20:23:08+00:00 | [ "Public" ] |
[] |
jpeg | 37f9819e71d4e2ae622f37fb8f1ad0c4d03c6fbe5653f79a5e14ce551ad9a818 | 5085402 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4E45EBA2-F531-4076-8741-A6D18656D677 | 0.5927734375 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0017414093017578125 | -0.00809478759765625 | 0.0035247802734375 | 0.05999999865889549 | -0.463134765625 | -0.041839599609375 | 0.4140625 | 0.0005507469177246094 | -0.016845703125 | -0.0992431640625 | -0.37353515625 | -0.07208251953125 | 0.2237548828125 | -0.1409912109375 | -0.0031261444091796875 | -0.0285491943359375 | 0.0023136138916015625 | 0.007232666015625 | -0.00624847412109375 | -0.316162109375 | -0.35888671875 | -0.059173583984375 | |||||
142 | ![]() |
A6FB150E-71C0-4524-8344-57CF59FE1B9E | 2019-11-02T20:30:45+00:00 | [ "Public" ] |
[] |
jpeg | 4360afbd37be230bf9fd6afcc48245e76bf9c81786713400653b2c81fb63f9e7 | 4649025 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A6FB150E-71C0-4524-8344-57CF59FE1B9E | 0.671875 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0011243820190429688 | 0.0157928466796875 | 0.004364013671875 | 0.009999999776482582 | -0.005615234375 | -0.12188720703125 | 0.214599609375 | 0.00577545166015625 | -0.0089874267578125 | -0.04571533203125 | -0.452880859375 | -0.0048828125 | 0.090087890625 | -0.01739501953125 | 4.57763671875e-05 | -0.017822265625 | 0.002590179443359375 | 0.0214080810546875 | 0.0196380615234375 | -0.337646484375 | -0.1243896484375 | 0.0 | |||||
148 | ![]() |
4EC865F7-E05C-42A0-B43A-4D46235F6F9C | 2019-11-02T20:31:34+00:00 | [ "Public" ] |
[] |
jpeg | 4835c1442d65d55dedd5ab611d33201c41f5501a905cdc7decf0ff4563f423d8 | 4479783 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4EC865F7-E05C-42A0-B43A-4D46235F6F9C | 0.81201171875 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.001461029052734375 | 0.0098724365234375 | 0.003650665283203125 | 0.009999999776482582 | -0.0167236328125 | -0.056976318359375 | 0.482177734375 | 0.0022525787353515625 | -0.01554107666015625 | -0.09368896484375 | -0.263427734375 | -0.060302734375 | 0.33056640625 | -0.10772705078125 | 0.000396728515625 | -0.02008056640625 | 0.0036067962646484375 | 0.013275146484375 | -0.0019073486328125 | -0.37255859375 | -0.12451171875 | -0.07977294921875 | |||||
152 | ![]() |
A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 2019-11-02T20:30:59+00:00 | [ "Public" ] |
[] |
jpeg | 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c | 4629001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 0.54931640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.001918792724609375 | -0.00484466552734375 | 0.002834320068359375 | 0.03999999910593033 | 0.165283203125 | -0.04052734375 | 0.24755859375 | 0.0024623870849609375 | -0.04595947265625 | -0.04052734375 | -0.1414794921875 | -0.1551513671875 | 0.20751953125 | -0.065673828125 | -0.00061798095703125 | -0.0300750732421875 | 0.005161285400390625 | 0.00844573974609375 | -0.01395416259765625 | -0.49267578125 | 0.1368408203125 | -0.09515380859375 | |||||
161 | ![]() |
0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2019-11-02T20:23:51+00:00 | [ "Public" ] |
[] |
jpeg | 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 | 5127846 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 0.6171875 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0006799697875976562 | 0.0157928466796875 | 0.01085662841796875 | 0.03999999910593033 | 0.0447998046875 | -0.04351806640625 | 0.267578125 | 0.0020503997802734375 | -0.00844573974609375 | -0.02105712890625 | -0.161376953125 | 0.03826904296875 | 0.12213134765625 | 0.011474609375 | 0.0068359375 | -0.0125885009765625 | 0.005706787109375 | 0.0153045654296875 | 0.002277374267578125 | -0.194580078125 | 0.0333251953125 | -0.00848388671875 | |||||
167 | ![]() |
2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 | 2019-11-02T20:23:10+00:00 | [ "Public" ] |
[] |
jpeg | 54c548a1c0f7e162558828db6bba845c2e9687cb148e877c58e975c9b2dfac61 | 5175607 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 | 0.62353515625 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.00208282470703125 | 0.03045654296875 | 0.011199951171875 | 0.009999999776482582 | -0.8740234375 | -0.018096923828125 | 0.0810546875 | 0.0029582977294921875 | -0.00634002685546875 | -0.005580902099609375 | 0.163330078125 | 0.01617431640625 | 0.044677734375 | 0.0885009765625 | -0.023895263671875 | -0.0026531219482421875 | 0.00945281982421875 | 0.049774169921875 | 0.007781982421875 | 0.151611328125 | 0.307861328125 | 0.00909423828125 | |||||
185 | ![]() |
398058A8-F11E-4306-8272-05A438B6E523 | 2019-11-02T20:30:21+00:00 | [ "Public" ] |
[] |
jpeg | 5bad707a8d2196bdb37eaea0501f8745535af125cc5bf5725451258a6247847d | 4283013 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 398058A8-F11E-4306-8272-05A438B6E523 | 0.74365234375 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0008935928344726562 | 0.0330810546875 | 0.0116424560546875 | 0.009999999776482582 | -0.833984375 | -0.0160980224609375 | 0.050872802734375 | 0.0024433135986328125 | -0.0033245086669921875 | -0.001247406005859375 | 0.362548828125 | 0.1444091796875 | 0.02447509765625 | 0.1607666015625 | -0.00890350341796875 | -0.001003265380859375 | 0.01433563232421875 | 0.11376953125 | 0.025970458984375 | 0.2293701171875 | 0.56982421875 | 0.01476287841796875 | |||||
201 | ![]() |
5FCADAE8-4708-4E56-B6B0-F718EE9446F7 | 2019-11-02T20:31:19+00:00 | [ "Public" ] |
[] |
jpeg | 64d4969938ae0359e40e8450801788ee372e29e5f755d3c5a1f671f2212bc809 | 4462558 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5FCADAE8-4708-4E56-B6B0-F718EE9446F7 | 0.82177734375 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.002124786376953125 | 0.000396728515625 | 0.0029125213623046875 | 0.009999999776482582 | -0.150390625 | -0.09027099609375 | 0.29443359375 | 0.003376007080078125 | -0.0162200927734375 | -0.07568359375 | -0.42333984375 | -0.1134033203125 | 0.151123046875 | -0.0860595703125 | -0.005008697509765625 | -0.04974365234375 | 0.0026836395263671875 | 0.01267242431640625 | -0.005584716796875 | -0.470947265625 | -0.1773681640625 | -0.07421875 | |||||
230 | ![]() |
D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 | 2019-11-02T20:31:30+00:00 | [ "Public" ] |
[] |
jpeg | 71e43f92a0ac99ed5fa838e65f58a6976c1d3e80908eb4b0427e104da7f4d2e3 | 4531938 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 | 0.84423828125 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.0031719207763671875 | -0.0098876953125 | 0.0023975372314453125 | 0.019999999552965164 | -0.1708984375 | -0.06890869140625 | 0.2208251953125 | 0.0024814605712890625 | -0.05072021484375 | -0.1019287109375 | -0.407958984375 | -0.1861572265625 | 0.199462890625 | -0.140869140625 | -0.0044708251953125 | -0.032257080078125 | 0.002368927001953125 | 0.004848480224609375 | -0.022552490234375 | -0.53173828125 | -0.293701171875 | -0.13134765625 | |||||
250 | ![]() |
2C40753A-80EB-4B9E-B0C4-678E61A06C55 | 2019-11-02T20:31:46+00:00 | [ "Public" ] |
[] |
jpeg | 79c147d029b433c3ef13a29afe060dfa4866b928c64f375788df5ecc2a2d0e65 | 4392510 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2C40753A-80EB-4B9E-B0C4-678E61A06C55 | 0.6650390625 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.0025310516357421875 | 0.00339508056640625 | 0.00257110595703125 | 0.07999999821186066 | -0.0814208984375 | -0.115966796875 | 0.0992431640625 | 0.00766754150390625 | -0.0218658447265625 | -0.06072998046875 | -0.459228515625 | -0.179931640625 | 0.043853759765625 | -0.04547119140625 | -0.0023193359375 | -0.020782470703125 | 0.001926422119140625 | 0.010009765625 | -0.0220947265625 | -0.298095703125 | -0.0684814453125 | 0.0150146484375 | |||||
259 | ![]() |
08D18A51-8004-4F00-B79E-4AA1628FB111 | 2019-11-02T20:30:15+00:00 | [ "Public" ] |
[] |
jpeg | 7e284f6fd7631015c32f82d4f57454941dc145fa608e510ccc84fea71b09cab1 | 4289135 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 08D18A51-8004-4F00-B79E-4AA1628FB111 | 0.78125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.8681640625 | -0.032379150390625 | 0.00734710693359375 | 0.009999999776482582 | -0.82080078125 | -0.10614013671875 | 0.03277587890625 | 0.0027370452880859375 | -0.3720703125 | -0.317626953125 | -0.8310546875 | -0.62158203125 | 0.019683837890625 | -0.69287109375 | -0.003093719482421875 | -0.026031494140625 | 0.0002472400665283203 | 0.00030541419982910156 | -0.98193359375 | -0.50048828125 | -0.818359375 | -0.8115234375 | |||||
271 | ![]() |
01CEBCA2-922B-407C-A726-95D9E0EAB31C | 2019-11-02T20:30:31+00:00 | [ "Public" ] |
[] |
jpeg | 83667863dcd289d0c96e5d3ed3eb5dfe7ea399203b6cf00bc3e9c3566e7ac705 | 4810940 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 01CEBCA2-922B-407C-A726-95D9E0EAB31C | 0.6572265625 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.004085540771484375 | 0.0172119140625 | 0.0053863525390625 | 0.009999999776482582 | -0.9560546875 | -0.022674560546875 | 0.058502197265625 | 0.0011653900146484375 | -0.00498199462890625 | -0.00559234619140625 | 0.06793212890625 | -0.06787109375 | 0.0125274658203125 | 0.052642822265625 | -0.02593994140625 | -0.0042877197265625 | 0.0035247802734375 | 0.05975341796875 | -0.001373291015625 | 0.2047119140625 | 0.375732421875 | 0.00261688232421875 | |||||
286 | ![]() |
41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D | 2019-11-02T20:30:04+00:00 | [ "Public" ] |
[] |
jpeg | 88cb2bf7299d65b53c69b24b13848fa2daeaeeeab75f98affaccf522c0dc7d42 | 4484642 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D | 0.70703125 | 0.5 | 0.0 | 0.043530952384453696 | 0.10000000149011612 | -0.004364013671875 | 0.0061187744140625 | 0.004718780517578125 | 0.019999999552965164 | -0.42724609375 | -0.1483154296875 | 0.0650634765625 | 0.01332855224609375 | -0.015838623046875 | -0.08636474609375 | -0.61962890625 | -0.1812744140625 | 0.07196044921875 | -0.0423583984375 | -0.00017547607421875 | -0.047637939453125 | 0.0026836395263671875 | 0.01016998291015625 | -0.01580810546875 | -0.1910400390625 | -0.31103515625 | -0.016571044921875 | |||||
290 | ![]() |
5C8A9E7C-62A9-4609-95C7-75826C03EF24 | 2019-11-02T20:32:13+00:00 | [ "Public" ] |
[] |
jpeg | 8bc56b3f8a20e0370f225bd7e9016c5435f837cbd37a640ac89bc6fab6c88983 | 4783904 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5C8A9E7C-62A9-4609-95C7-75826C03EF24 | 0.79833984375 | 0.75 | 0.0 | 0.06261464384675935 | 0.10000000149011612 | -0.001495361328125 | 0.00037384033203125 | 0.00605010986328125 | 0.009999999776482582 | -0.36181640625 | -0.0836181640625 | 0.255126953125 | 0.0031604766845703125 | -0.01111602783203125 | -0.10107421875 | -0.560546875 | -0.09552001953125 | 0.185546875 | -0.0755615234375 | -0.001712799072265625 | -0.038970947265625 | 0.0036640167236328125 | 0.005619049072265625 | -0.007110595703125 | -0.341064453125 | -0.450927734375 | -0.048065185546875 | |||||
297 | ![]() |
2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 2019-11-02T19:10:14+00:00 | [ "Public" ] |
[] |
heic | 8e863e558a9bcd65dbfe5add8c6bc8fc5150358449cc9036d6fa9c428e7ba8ee | 2239399 | 37.456428329999994 | -122.10851949999999 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Palo Alto | CA | United States | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 0.38037109375 | 0.75 | 0.0 | 0.05801763419659083 | 0.10000000149011612 | -0.002208709716796875 | 0.01380157470703125 | 0.0165252685546875 | 0.009999999776482582 | -0.21142578125 | -0.06890869140625 | 0.142333984375 | 0.006389617919921875 | -0.012481689453125 | -0.0638427734375 | -0.425537109375 | -0.05072021484375 | 0.202880859375 | -0.01123046875 | 0.0060272216796875 | -0.01305389404296875 | 0.004810333251953125 | 0.005062103271484375 | -0.00335693359375 | -0.10638427734375 | -0.413818359375 | -0.01690673828125 |
321 | ![]() |
429A1239-744D-4A61-A33B-1BF261584128 | 2019-11-02T20:32:07+00:00 | [ "Public" ] |
[] |
jpeg | 9d0b55a181e5acc3dd658ac1c79c7000cde794058c3e93698d1337ca6d4e348a | 4858397 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 429A1239-744D-4A61-A33B-1BF261584128 | 0.79833984375 | 0.75 | 0.0 | 0.06261464384675935 | 0.5030657052993774 | -0.0016164779663085938 | 0.0750732421875 | 0.023284912109375 | 0.009999999776482582 | 0.1019287109375 | -0.0784912109375 | 0.060943603515625 | 0.01861572265625 | -0.006641387939453125 | -0.039154052734375 | -0.078125 | 0.118896484375 | 0.1488037109375 | 0.3134765625 | 0.04833984375 | 0.00243377685546875 | 0.00945281982421875 | 0.0250396728515625 | 0.049774169921875 | 0.0056610107421875 | -0.05963134765625 | 0.049896240234375 | |||||
331 | ![]() |
1B6765D2-F281-48DB-A23A-C081FFAC69DC | 2019-11-02T20:31:26+00:00 | [ "Public" ] |
[] |
jpeg | a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 | 4561109 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1B6765D2-F281-48DB-A23A-C081FFAC69DC | 0.7705078125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0023326873779296875 | -0.00392913818359375 | 0.00217437744140625 | 0.009999999776482582 | -0.1573486328125 | -0.11859130859375 | 0.0679931640625 | 0.00864410400390625 | -0.030670166015625 | -0.083984375 | -0.52197265625 | -0.2744140625 | 0.12139892578125 | -0.083740234375 | -0.001941680908203125 | -0.02880859375 | 0.004199981689453125 | 0.00841522216796875 | -0.029266357421875 | -0.431396484375 | -0.082763671875 | -0.0531005859375 | |||||
341 | ![]() |
65600C73-CFBC-4FD9-AADE-9CA39F776FC2 | 2019-11-02T20:30:31+00:00 | [ "Public" ] |
[] |
jpeg | a50d3c5dc31188f36a8f2f6176c6469a5b62cb270962ba63737b3bfc5c9462f8 | 4837662 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 65600C73-CFBC-4FD9-AADE-9CA39F776FC2 | 0.70703125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.004070281982421875 | 0.00601959228515625 | 0.01132965087890625 | 0.019999999552965164 | -0.5419921875 | -0.152099609375 | 0.0072021484375 | 0.012725830078125 | -0.01111602783203125 | -0.11370849609375 | -0.69384765625 | -0.262939453125 | 0.1044921875 | -0.0220947265625 | 0.00093841552734375 | -0.0264434814453125 | 0.005039215087890625 | 0.0030517578125 | -0.03656005859375 | -0.08477783203125 | -0.47119140625 | -0.0071563720703125 | |||||
366 | ![]() |
A4F38147-CE20-41A8-8811-583623ABE085 | 2019-11-02T20:32:27+00:00 | [ "Public" ] |
[] |
jpeg | b35aff17400287b860379849efbfab739524ed040f0b5d59cebbe71021ac32f6 | 5028634 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A4F38147-CE20-41A8-8811-583623ABE085 | 0.7412109375 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0028553009033203125 | 0.00070953369140625 | 0.0025806427001953125 | 0.07999999821186066 | 0.11181640625 | -0.07879638671875 | 0.07183837890625 | 0.01450347900390625 | -0.046112060546875 | -0.03326416015625 | -0.28515625 | -0.2376708984375 | 0.050811767578125 | -0.037841796875 | -0.001598358154296875 | -0.0120697021484375 | 0.0027141571044921875 | 0.012969970703125 | -0.021575927734375 | -0.32666015625 | 0.1380615234375 | -0.026336669921875 | |||||
421 | ![]() |
6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE | 2019-11-02T20:23:27+00:00 | [ "Public" ] |
[] |
jpeg | d597f6879722f4f91e3558f509a859171132b60d7df319ba3fea358fa175d704 | 4948411 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE | 0.599609375 | 0.25 | 0.0 | 0.02292342267873633 | 0.10000000149011612 | -0.0014667510986328125 | 0.0130157470703125 | 0.00669097900390625 | 0.05999999865889549 | -0.1693115234375 | -0.10723876953125 | 0.125732421875 | 0.0100555419921875 | -0.01029205322265625 | -0.053619384765625 | -0.46923828125 | -0.0592041015625 | 0.12359619140625 | 0.00830078125 | 0.00091552734375 | -0.0198974609375 | 0.005260467529296875 | 0.01262664794921875 | -0.0024566650390625 | -0.2452392578125 | -0.17578125 | 0.0079345703125 | |||||
422 | ![]() |
BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 2019-11-02T20:31:29+00:00 | [ "Public" ] |
[] |
jpeg | d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 | 4246410 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 0.84228515625 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.0006117820739746094 | 0.0157012939453125 | 0.0020351409912109375 | 0.03999999910593033 | 0.599609375 | -0.06622314453125 | 0.10491943359375 | 0.01009368896484375 | -0.015838623046875 | 0.00726318359375 | 0.02276611328125 | -0.0177001953125 | 0.07318115234375 | 0.0751953125 | 0.00572967529296875 | -0.008392333984375 | 0.00867462158203125 | 0.0836181640625 | 0.047119140625 | -0.158203125 | 0.68798828125 | 0.1689453125 | |||||
479 | ![]() |
FF230430-EDD4-4E3F-83F9-C105A7EE7598 | 2019-11-02T20:31:02+00:00 | [ "Public" ] |
[] |
jpeg | f5540186893e81abf2b46cb2108caa981d5a1e063e184f7242709e6287437911 | 4817123 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FF230430-EDD4-4E3F-83F9-C105A7EE7598 | 0.76220703125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0017681121826171875 | -0.0049896240234375 | 0.002349853515625 | 0.019999999552965164 | 0.139404296875 | -0.047515869140625 | 0.317626953125 | 0.00147247314453125 | -0.0364990234375 | -0.051422119140625 | -0.1719970703125 | -0.1263427734375 | 0.1759033203125 | -0.0941162109375 | -0.0011386871337890625 | -0.03131103515625 | 0.003223419189453125 | 0.0094146728515625 | -0.01128387451171875 | -0.53125 | 0.0823974609375 | -0.117431640625 |
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;