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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
46 | 929CB2CD-A08E-43B2-AD9F-4B0FC40D9F34 | 2019-08-21T15:32:45+00:00 | [ "Public" ] |
[] |
jpeg | 1719c4a23f75227ab440e95d9e2cd54d6767a7883bbc850f174c5f1422839b31 | 7860631 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 929CB2CD-A08E-43B2-AD9F-4B0FC40D9F34 | 0.7001953125 | 0.75 | 0.0 | 0.061106777373161024 | 0.10000000149011612 | -0.016021728515625 | 0.0045623779296875 | 0.01073455810546875 | 0.009999999776482582 | -0.64111328125 | -0.1171875 | -0.0924072265625 | 0.0236968994140625 | -0.0299224853515625 | -0.05535888671875 | -0.56640625 | -0.4560546875 | 0.0191650390625 | -0.026458740234375 | -0.001277923583984375 | -0.010711669921875 | 0.0021915435791015625 | 0.003185272216796875 | -0.11077880859375 | -0.0277099609375 | -0.265380859375 | -0.0023651123046875 | ||||||
249 | DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F | 2018-04-21T23:55:29+00:00 | [ "Museums", "Public" ] |
[] |
heic | 798436ad6175c55c8785bfbc10c8ffe60913b521a52312735f138f37e3cb4d81 | 1173698 | 37.579053333333334 | -122.34420833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F | 0.27099609375 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.005279541015625 | 0.00095367431640625 | 0.00243377685546875 | 0.019999999552965164 | -0.41845703125 | -0.12200927734375 | 0.01702880859375 | 0.0144500732421875 | -0.038970947265625 | -0.09381103515625 | -0.54541015625 | -0.300048828125 | 0.050048828125 | -0.0985107421875 | -0.00109100341796875 | -0.01496124267578125 | 0.0021915435791015625 | 0.012237548828125 | -0.0482177734375 | -0.16259765625 | -0.0987548828125 | -0.0265350341796875 |
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;