photos_with_apple_metadata (view)

17 rows where ZINTERACTIONSCORE = "0.009999999776482582" and "date" is on date 2019-11-02

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, favorite, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZLOWLIGHT, ZPLEASANTPATTERNSCORE, ZPLEASANTSYMMETRYSCORE, albums (array)

date (date) ✖

  • 2019-11-02 · 17 ✖

ZINTERACTIONSCORE ✖

  • 0.009999999776482582 · 17 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;
Powered by Datasette · Query took 323.053ms · About: dogsheep/dogsheep-photos