This data as json, CSV (advanced)
Suggested facets: persons, ext, ZINTERACTIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
181 | ![]() |
3E20BE4D-619A-42EC-9CAA-6F67508892E4 | 2017-10-27T20:41:30+00:00 | [ "Museums", "Public" ] |
[] |
heic | 5a3a4b0ffc8de931dd6dd0c977df4b444421a404c820c795346c8faffc984ffa | 1744396 | 37.809145 | -122.42119666666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 3E20BE4D-619A-42EC-9CAA-6F67508892E4 | 0.49169921875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0024929046630859375 | -0.006275177001953125 | 0.003692626953125 | 0.009999999776482582 | -0.309814453125 | -0.0948486328125 | 0.2303466796875 | 0.0018968582153320312 | -0.022247314453125 | -0.13623046875 | -0.5966796875 | -0.132568359375 | 0.188232421875 | -0.1619873046875 | -0.0025348663330078125 | -0.020538330078125 | 0.0019044876098632812 | 0.004505157470703125 | -0.01824951171875 | -0.40283203125 | -0.51416015625 | -0.1053466796875 |
395 | ![]() |
82B5CEE0-0DCB-4E73-84BC-2536F0676B06 | 2016-04-19T22:24:36+00:00 | [ "Museums", "Public" ] |
[] |
jpeg | c5da768a066d3ed8487b4cf7520c8960f46510357e13edb68729cd3b0565fcbb | 2044936 | 37.863186666666664 | -122.49463666666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Sausalito | CA | United States | 82B5CEE0-0DCB-4E73-84BC-2536F0676B06 | 0.331298828125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0018033981323242188 | 0.00077056884765625 | 0.0028667449951171875 | 0.009999999776482582 | -0.32421875 | -0.03790283203125 | 0.44921875 | 0.0005192756652832031 | -0.016845703125 | -0.1064453125 | -0.2491455078125 | -0.05010986328125 | 0.149169921875 | -0.19384765625 | 0.000110626220703125 | -0.04498291015625 | 0.0019044876098632812 | 0.0162811279296875 | 0.00072479248046875 | -0.204833984375 | -0.1358642578125 | -0.047576904296875 |
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;