This data as json, CSV (advanced)
Suggested facets: albums, favorite, ZCURATIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
400 | 2B30643F-7BEC-4E40-8C9F-BF0994C38197 | 2018-02-13T18:55:11+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | c737f0db8b99bd2bff7581902d55319005ce8f7557654af7d985e66e91bfdb85 | 5545619 | 25.73648106575451 | -111.09070456885036 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 2B30643F-7BEC-4E40-8C9F-BF0994C38197 | 0.5947265625 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.0022602081298828125 | -0.00171661376953125 | 0.00908660888671875 | 0.009999999776482582 | -0.2548828125 | -0.059112548828125 | 0.2274169921875 | 0.0010442733764648438 | -0.01751708984375 | -0.12164306640625 | -0.4638671875 | -0.110595703125 | 0.2010498046875 | -0.132080078125 | 0.0008869171142578125 | -0.0180816650390625 | 0.00266265869140625 | 0.002521514892578125 | -0.0098876953125 | -0.1746826171875 | -0.50390625 | -0.057098388671875 | |||
402 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 2018-02-09T17:27:30+00:00 | [ "Public" ] |
[] |
jpeg | c7f136a2c859e0cf4683e9c496fb21501ba2d22b326f91ee68a61b048d3cf75d | 6152857 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E | 0.52978515625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0015249252319335938 | -0.0049591064453125 | 0.004039764404296875 | 0.009999999776482582 | -0.37744140625 | -0.07696533203125 | 0.2646484375 | 0.0016355514526367188 | -0.01751708984375 | -0.0535888671875 | -0.484130859375 | -0.067626953125 | 0.138916015625 | -0.064453125 | -0.0138397216796875 | -0.0174102783203125 | 0.001926422119140625 | 0.00930023193359375 | -0.00273895263671875 | -0.4765625 | -0.3681640625 | -0.083740234375 | ||||||
338 | 9C0E4F98-A2A8-45F8-8078-792720435621 | 2018-02-09T17:09:09+00:00 | [ "Public" ] |
[] |
jpeg | a4613c06f65f7d13e8c36a1c59025b23caf787d4775a44945e6ae2f5e7fd3929 | 5496634 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9C0E4F98-A2A8-45F8-8078-792720435621 | 0.74267578125 | 0.75 | 0.0 | 0.06261882208685839 | 0.10000000149011612 | -0.001964569091796875 | 0.00035858154296875 | 0.0014209747314453125 | 0.009999999776482582 | -0.379638671875 | -0.055511474609375 | 0.37548828125 | 0.001094818115234375 | -0.01751708984375 | -0.0670166015625 | -0.27587890625 | -0.0677490234375 | 0.0838623046875 | -0.1505126953125 | -0.00411224365234375 | -0.0555419921875 | 0.0017614364624023438 | 0.040679931640625 | 0.0148162841796875 | -0.3125 | 0.1396484375 | -0.047760009765625 |
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;