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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
413 | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 2018-02-20T22:16:37+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783 | 1481901 | 37.74236666666667 | -122.44930333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C | 0.36376953125 | 0.75 | 0.0 | 0.05801526718694745 | 0.5043308734893799 | -0.0011920928955078125 | 0.028045654296875 | 0.00394439697265625 | 0.009999999776482582 | 0.51904296875 | -0.039642333984375 | -0.0184326171875 | 0.0164031982421875 | -0.0162811279296875 | -0.0003814697265625 | 0.305419921875 | 0.0206298828125 | 0.0170440673828125 | 0.26611328125 | 0.00893402099609375 | 0.001964569091796875 | 0.00948333740234375 | 0.09234619140625 | 0.0183258056640625 | 0.170654296875 | 0.6982421875 | 0.43212890625 | |
214 | E2A17559-5121-45E2-9FAB-6CF7C38F3F50 | 2018-02-09T17:37:37+00:00 | [ "Public" ] |
[] |
jpeg | 69e98fd0fb8cb4a36d9feb83957fb0415c54a63bcef3c27720300496bfb8267c | 4877381 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E2A17559-5121-45E2-9FAB-6CF7C38F3F50 | 0.76171875 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.000720977783203125 | -0.004779815673828125 | 0.0038242340087890625 | 0.009999999776482582 | 0.07135009765625 | -0.047515869140625 | 0.39404296875 | 0.0005726814270019531 | -0.0162811279296875 | -0.06329345703125 | -0.25390625 | -0.0662841796875 | 0.2359619140625 | -0.07958984375 | -0.0005092620849609375 | -0.0269012451171875 | 0.0033893585205078125 | 0.005138397216796875 | -0.0037364959716796875 | -0.5478515625 | -0.17724609375 | -0.1026611328125 |
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;