This data as json, CSV (advanced)
Suggested facets: ext, favorite, panorama, ZCURATIONSCORE, ZBEHAVIORALSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99 | ![]() |
373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 2019-12-21T10:01:09+00:00 | [ "Public" ] |
[] |
heic | 2f6b03abdcfe2f4c21f60485ddd9206bc4313e77f9b06e72eb38050d9978685b | 7211598 | 51.17876333 | -1.8266950000000002 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | Salisbury | England | United Kingdom | 373EBDEF-0DF5-4AD6-A2C0-8EAF5BBF1E5A | 0.638671875 | 0.75 | 0.0 | 0.06109879080575841 | 0.10000000149011612 | -0.0005421638488769531 | 0.03216552734375 | 0.00217437744140625 | 0.009999999776482582 | 0.0615234375 | -0.049041748046875 | 0.1693115234375 | 0.006389617919921875 | -0.0068511962890625 | 0.0143280029296875 | 0.0623779296875 | 0.139404296875 | 0.044769287109375 | 0.1705322265625 | 0.008758544921875 | -0.00537872314453125 | 0.005260467529296875 | 0.2900390625 | 0.2193603515625 | 0.0245361328125 | 0.66064453125 | 0.036163330078125 |
331 | ![]() |
1B6765D2-F281-48DB-A23A-C081FFAC69DC | 2019-11-02T20:31:26+00:00 | [ "Public" ] |
[] |
jpeg | a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 | 4561109 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1B6765D2-F281-48DB-A23A-C081FFAC69DC | 0.7705078125 | 0.5 | 0.0 | 0.04353076629056275 | 0.10000000149011612 | -0.0023326873779296875 | -0.00392913818359375 | 0.00217437744140625 | 0.009999999776482582 | -0.1573486328125 | -0.11859130859375 | 0.0679931640625 | 0.00864410400390625 | -0.030670166015625 | -0.083984375 | -0.52197265625 | -0.2744140625 | 0.12139892578125 | -0.083740234375 | -0.001941680908203125 | -0.02880859375 | 0.004199981689453125 | 0.00841522216796875 | -0.029266357421875 | -0.431396484375 | -0.082763671875 | -0.0531005859375 | |||||
28 | ![]() |
14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D | 2019-08-21T15:33:02+00:00 | [ "Public" ] |
[] |
jpeg | 10fbcfa8d9bde9eea951ffd25147dfcca838591911ffa1c2b4b5ada2cc73bf7c | 6692650 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D | 0.6298828125 | 0.75 | 0.0 | 0.06110566308480183 | 0.7047688364982605 | -0.00042057037353515625 | 0.060150146484375 | 0.00217437744140625 | 0.009999999776482582 | 0.78271484375 | -0.0309600830078125 | 0.0841064453125 | 0.010009765625 | -0.0027256011962890625 | 0.00811004638671875 | 0.48193359375 | 0.420166015625 | 0.017242431640625 | 0.26513671875 | 0.02313232421875 | 0.00504302978515625 | 0.00530242919921875 | 0.67822265625 | 0.82177734375 | 0.273193359375 | 0.88427734375 | 0.67822265625 |
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;