This data as json, CSV (advanced)
Suggested facets: ZBEHAVIORALSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
268 | 421867A7-CC19-4B0A-944C-26AE521DE430 | 2019-09-15T13:17:56+00:00 | [ "Public" ] |
[] |
jpeg | 81afbe147b314b8d2080199a263d9d31e68d9bf8379123faf2c4a849b6d3b13e | 6002543 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 421867A7-CC19-4B0A-944C-26AE521DE430 | 0.6416015625 | 0.75 | 0.0 | 0.061092475898393235 | 0.5047202110290527 | -0.0017004013061523438 | 0.0198974609375 | 0.0017614364624023438 | 0.019999999552965164 | 0.5556640625 | -0.060638427734375 | -0.023101806640625 | 0.07574462890625 | -0.0147857666015625 | 0.0053863525390625 | 0.2314453125 | 0.096923828125 | 0.009674072265625 | 0.1575927734375 | 0.010589599609375 | 0.00057220458984375 | 0.0058441162109375 | 0.36328125 | 0.4619140625 | 0.09844970703125 | 0.86572265625 | 0.349609375 | ||||||
472 | 466CB5A7-6675-48D2-B7BF-9A2C0F83250E | 2019-09-15T13:36:15+00:00 | [ "Public" ] |
[] |
jpeg | f096c284469eab7364bc93f0e6b1a172fdf8f6221a7e27ef76b5bedc6720302a | 6232116 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 466CB5A7-6675-48D2-B7BF-9A2C0F83250E | 0.794921875 | 0.75 | 0.0 | 0.06417663634278392 | 0.5046228766441345 | -0.0013885498046875 | 0.034088134765625 | 0.0020198822021484375 | 0.019999999552965164 | 0.54296875 | -0.03759765625 | 0.03155517578125 | 0.062225341796875 | -0.0127716064453125 | 0.008453369140625 | 0.302978515625 | 0.265625 | 0.018585205078125 | 0.195556640625 | 0.0266571044921875 | 0.003116607666015625 | 0.005428314208984375 | 0.5380859375 | 0.73583984375 | 0.2452392578125 | 0.85302734375 | 0.337890625 | ||||||
488 | 7DDBAB14-E762-46B3-942A-BAD5AB6668A3 | 2019-09-15T13:14:03+00:00 | [ "Public" ] |
[] |
jpeg | fb3e9dc60565ab6a9e492642843dba702d5a63c945420c0ec573610bdde8e9b8 | 6274468 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7DDBAB14-E762-46B3-942A-BAD5AB6668A3 | 0.77392578125 | 0.75 | 0.0 | 0.062639624107885 | 0.10000000149011612 | -0.001674652099609375 | 0.0215606689453125 | 0.0020503997802734375 | 0.019999999552965164 | 0.34423828125 | -0.043609619140625 | 0.0489501953125 | 0.014556884765625 | -0.0276947021484375 | -0.00164794921875 | 0.08935546875 | -0.0223388671875 | 0.029205322265625 | 0.149169921875 | 0.006847381591796875 | -0.001789093017578125 | 0.00469970703125 | 0.10687255859375 | 0.05255126953125 | 0.12890625 | 0.65283203125 | 0.26171875 | ||||||
452 | 27A4F78F-FC94-4E45-9512-0E89A13E33E5 | 2019-09-15T12:42:33+00:00 | [ "Public" ] |
[] |
jpeg | e467e2655deced8d78b20667ebdf52cb3a325c2723ce0d8fed423f9fe8401ce7 | 4946963 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 27A4F78F-FC94-4E45-9512-0E89A13E33E5 | 0.6513671875 | 0.75 | 0.0 | 0.061090990332246735 | 0.5056204199790955 | -0.00266265869140625 | 0.042999267578125 | 0.0033512115478515625 | 0.019999999552965164 | 0.52978515625 | -0.063232421875 | -0.0672607421875 | 0.2841796875 | -0.025421142578125 | 0.0031890869140625 | 0.1854248046875 | 0.0341796875 | 0.0261993408203125 | 0.2314453125 | 0.040435791015625 | 0.00331878662109375 | 0.0094146728515625 | 0.143798828125 | 0.1871337890625 | 0.10595703125 | 0.6787109375 | 0.377197265625 | ||||||
131 | D755ECF0-4954-461A-8523-2BCA917DA37C | 2019-09-15T14:11:18+00:00 | [ "Public" ] |
[] |
jpeg | 3bff710e021160610debf1cef0002dd77afc78694c1ad1373c2bc5a0c244658e | 4403069 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | D755ECF0-4954-461A-8523-2BCA917DA37C | 0.75732421875 | 0.75 | 0.0 | 0.0626162217773554 | 0.1004379540681839 | -0.00033545494079589844 | 0.03814697265625 | 0.0197906494140625 | 0.019999999552965164 | 0.0579833984375 | -0.0255126953125 | 0.1129150390625 | 0.0137939453125 | -0.00600433349609375 | 0.0106964111328125 | 0.27734375 | 0.2056884765625 | 0.258544921875 | 0.2041015625 | 0.016815185546875 | -0.001556396484375 | 0.0751953125 | 0.08770751953125 | 0.0274658203125 | -0.0262451171875 | 0.48876953125 | 0.01727294921875 | ||||||
399 | 4FB52292-60F3-429B-971F-4843A2BD51B4 | 2019-09-15T12:53:03+00:00 | [ "Public" ] |
[] |
jpeg | c708f463941e998c2a9d12854bed87d6e85f2235270312999b216c006a6fdeb1 | 7760105 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4FB52292-60F3-429B-971F-4843A2BD51B4 | 0.447021484375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0018177032470703125 | 0.027374267578125 | 0.02685546875 | 0.019999999552965164 | -0.316650390625 | -0.053497314453125 | 0.1463623046875 | 0.00428009033203125 | -0.00894927978515625 | -0.0819091796875 | -0.28271484375 | -0.04461669921875 | 0.1256103515625 | 0.0401611328125 | 0.00994873046875 | -0.011474609375 | 0.00803375244140625 | 0.007373809814453125 | -0.008026123046875 | -0.03558349609375 | -0.1982421875 | -0.00734710693359375 |
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;