photos_with_apple_metadata (view)

12 rows where ZCURATIONSCORE = "0.75" and "date" is on date 2019-11-02

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, ext, favorite, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, albums (array)

date (date) ✖

  • 2019-11-02 · 12 ✖

ZCURATIONSCORE ✖

  • 0.75 · 12 ✖
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
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
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
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
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
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
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
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
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 265.244ms · About: dogsheep/dogsheep-photos