photos_with_apple_metadata (view)
7 rows where ZINTERACTIONSCORE = "0.019999999552965164" and "date" is on date 2019-11-02 sorted by ZPROMOTIONSCORE
This data as json, CSV (advanced)
Suggested facets: favorite, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||
| 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 | |||||
| 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 | |||||
| 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 | |||||
| 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 | |||||
| 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 |
Advanced export
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;