This data as json, CSV (advanced)
Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZINTERACTIONSCORE, date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
285 | ![]() |
3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 | 2020-04-23T23:18:02+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 888f348b246e038ce7f950f3e5aca8169910d6bf144219c1e0dc80cd8117a2dd | 8485248 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 | 0.47900390625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.004718780517578125 | 0.0163421630859375 | 0.00473785400390625 | 0.009999999776482582 | -0.95166015625 | -0.0276336669921875 | 0.07867431640625 | 0.0016422271728515625 | -0.00577545166015625 | -0.00798797607421875 | -0.0096435546875 | -0.08978271484375 | 0.01934814453125 | 0.0404052734375 | -0.0308837890625 | -0.005924224853515625 | 0.0034027099609375 | 0.050994873046875 | -0.00604248046875 | 0.1451416015625 | 0.304443359375 | 0.001800537109375 | |||||
298 | ![]() |
3C3089C2-BA72-45E8-90B9-2974D8D2DB36 | 2019-12-13T23:52:03+00:00 | [ "Public" ] |
[] |
heic | 8e935af3c408ee0013c7d05f82ae8592f12aa341f455cc15534ae2db1ead05ef | 2663392 | 34.11846667000001 | -118.30060500000002 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Los Angeles | CA | United States | 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 | 0.289794921875 | 0.75 | 0.0 | 0.05801763419659083 | 0.10000000149011612 | -0.0009660720825195312 | -0.00296783447265625 | 0.0020580291748046875 | 0.019999999552965164 | 0.148681640625 | -0.0546875 | 0.416748046875 | 0.0016613006591796875 | -0.0190887451171875 | -0.022308349609375 | -0.1881103515625 | -0.056060791015625 | 0.286865234375 | -0.05364990234375 | -0.00543212890625 | -0.0264129638671875 | 0.0034027099609375 | 0.0214080810546875 | 0.0212860107421875 | -0.6259765625 | 0.081787109375 | -0.1051025390625 |
124 | ![]() |
090FA0A0-01B9-4375-B319-C0712E6E2AAD | 2019-08-21T11:41:32+00:00 | [ "Public" ] |
[] |
jpeg | 3adc4ce462f12a3e7890ad51a7e150a675f776d8b63dd5dde154bfff98b4b1d7 | 8719520 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 090FA0A0-01B9-4375-B319-C0712E6E2AAD | 0.91943359375 | 0.75 | 0.0 | 0.0626326999591507 | 0.10000000149011612 | -0.004100799560546875 | 0.026763916015625 | 0.0028781890869140625 | 0.009999999776482582 | 0.2200927734375 | -0.08648681640625 | 0.0179443359375 | 0.015899658203125 | -0.009521484375 | -0.00226593017578125 | 0.0335693359375 | -0.0333251953125 | 0.01751708984375 | 0.14501953125 | 0.007572174072265625 | -0.001499176025390625 | 0.0034027099609375 | 0.145263671875 | 0.27490234375 | 0.10626220703125 | 0.603515625 | 0.276123046875 | |||||
83 | ![]() |
59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 2018-04-22T00:19:14+00:00 | [ "Museums", "Public" ] |
[] |
heic | 246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410 | 1382543 | 37.57926666666667 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 0.44775390625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00217437744140625 | 0.007617950439453125 | 0.00279998779296875 | 0.019999999552965164 | 0.0296630859375 | -0.06707763671875 | 0.161865234375 | 0.005039215087890625 | -0.02947998046875 | -0.06591796875 | -0.220458984375 | -0.12347412109375 | 0.06634521484375 | -0.047119140625 | 0.000492095947265625 | -0.016754150390625 | 0.0034027099609375 | 0.0193023681640625 | -0.02313232421875 | -0.205810546875 | 0.237060546875 | 0.01519775390625 |
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;