This data as json, CSV (advanced)
Suggested facets: date, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZHARMONIOUSCOLORSCORE, ZINTERACTIONSCORE, ZLOWLIGHT, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 | ||||||
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 |
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;