This data as json, CSV (advanced)
Suggested facets: albums, persons, ext, ZBEHAVIORALSCORE, date (date), albums (array), persons (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 2018-05-18T19:45:49+00:00 | [ "Museums", "Public" ] |
[] |
heic | 14efd697b9572b24b1853d1a3effab60609c0fcb477ad4739e85194c32afe8ba | 1849449 | 37.0415695 | -122.0726305 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Felton | CA | United States | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 0.43701171875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0020503997802734375 | 0.0012054443359375 | 0.00266265869140625 | 0.03999999910593033 | -0.0677490234375 | -0.093505859375 | 0.361328125 | 0.0033111572265625 | -0.01525115966796875 | -0.0430908203125 | -0.4287109375 | -0.0633544921875 | 0.1295166015625 | -0.07568359375 | -0.00975799560546875 | -0.01381683349609375 | 0.0014162063598632812 | 0.01934814453125 | 0.02264404296875 | -0.5283203125 | -0.20849609375 | -0.10821533203125 | |
291 | C8CCC8EE-382E-4265-8236-E2F30764A55C | 2018-04-21T23:55:50+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 | 1719608 | 37.57926666666667 | -122.3442 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | C8CCC8EE-382E-4265-8236-E2F30764A55C | 0.2325439453125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0028228759765625 | -0.00146484375 | 0.0015306472778320312 | 0.03999999910593033 | 0.1011962890625 | -0.07305908203125 | 0.1485595703125 | 0.006511688232421875 | -0.046722412109375 | -0.03564453125 | -0.249755859375 | -0.18994140625 | 0.0582275390625 | -0.07696533203125 | -0.0020275115966796875 | -0.0162353515625 | 0.0019044876098632812 | 0.0194244384765625 | -0.01031494140625 | -0.405029296875 | 0.190185546875 | -0.0648193359375 | |
220 | BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 2015-10-05T14:55:32+00:00 | [ "Museums", "Niche museums", "Public" ] |
[] |
jpeg | 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 | 2840560 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 | 0.3583984375 | 0.5 | 0.0 | 0.038931297721298594 | 0.5039172768592834 | -0.0008168220520019531 | 0.03851318359375 | 0.001949310302734375 | 0.03999999910593033 | 0.2958984375 | -0.03314208984375 | 0.058319091796875 | 0.0271759033203125 | -0.007038116455078125 | 0.0072479248046875 | 0.328125 | 0.2447509765625 | 0.01450347900390625 | 0.1962890625 | 0.0167236328125 | 0.000606536865234375 | 0.006488800048828125 | 0.58203125 | 0.58935546875 | 0.2381591796875 | 0.88427734375 | 0.1051025390625 |
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;