This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
232 | E2378A42-70B5-42A2-B8D8-CFE99DBCE627 | 2018-02-09T17:37:26+00:00 | [ "Public" ] |
[] |
jpeg | 723a6e638a563a37ff666683b28f4190a29777475aca5428660fa22d5cff5a07 | 5948701 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E2378A42-70B5-42A2-B8D8-CFE99DBCE627 | 0.66845703125 | 0.75 | 0.0 | 0.06111104934270145 | 0.10000000149011612 | -0.0024051666259765625 | 0.013336181640625 | 0.005619049072265625 | 0.009999999776482582 | -0.91796875 | -0.020965576171875 | 0.1314697265625 | 0.0007791519165039062 | -0.00600433349609375 | -0.007549285888671875 | 0.01007080078125 | -0.02764892578125 | 0.0210418701171875 | 0.03363037109375 | -0.0223388671875 | -0.005645751953125 | 0.00313568115234375 | 0.044769287109375 | 0.005462646484375 | 0.16259765625 | 0.283935546875 | 0.00146484375 | ||||||
326 | 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 2018-02-09T17:07:59+00:00 | [ "Public" ] |
[] |
jpeg | 9e06275e7fa0e4f84d6a1e7a8ae97c27a59eebc6f3769f5b0129e492bf9c40c1 | 5328743 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 0.6591796875 | 0.75 | 0.0 | 0.06111104934270145 | 0.10000000149011612 | -0.0221099853515625 | -0.0023956298828125 | 0.00266265869140625 | 0.009999999776482582 | -0.417236328125 | -0.0574951171875 | 0.162353515625 | 0.003185272216796875 | -0.055206298828125 | -0.064208984375 | -0.300048828125 | -0.2000732421875 | 0.036712646484375 | -0.1666259765625 | -0.0035400390625 | -0.01611328125 | 0.0010690689086914062 | 0.017303466796875 | -0.206787109375 | -0.138916015625 | 0.03955078125 | -0.0994873046875 |
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;