photos_with_apple_metadata (view)

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

✎ 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 ▼
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
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
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
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
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
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
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
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
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
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
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

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 269.268ms · About: dogsheep/dogsheep-photos