This data as json, CSV (advanced)
Suggested facets: ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 2018-05-18T19:45:49+00:00 | [ "Museums", "Public" ] |
[] |
heic | 14efd697b9572b24b1853d1a3effab60609c0fcb477ad4739e85194c32afe8ba | 1849449 | 37.0415695 | -122.0726305 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Felton | CA | United States | 5392047B-DF94-46CF-BA61-06ECE4D8CD9E | 0.43701171875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0020503997802734375 | 0.0012054443359375 | 0.00266265869140625 | 0.03999999910593033 | -0.0677490234375 | -0.093505859375 | 0.361328125 | 0.0033111572265625 | -0.01525115966796875 | -0.0430908203125 | -0.4287109375 | -0.0633544921875 | 0.1295166015625 | -0.07568359375 | -0.00975799560546875 | -0.01381683349609375 | 0.0014162063598632812 | 0.01934814453125 | 0.02264404296875 | -0.5283203125 | -0.20849609375 | -0.10821533203125 | |
244 | BB4A90B3-D3CA-4E17-B54E-C736B625DDA7 | 2018-02-20T23:13:01+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 787c5bc73010b0a6c630900e95ca3a8921ad9104dec5cd2fe647510660e7f5d7 | 1663642 | 37.74267 | -122.44931666666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | BB4A90B3-D3CA-4E17-B54E-C736B625DDA7 | 0.266357421875 | 0.5 | 0.0 | 0.038931297721298594 | 0.5024574398994446 | -0.0007853507995605469 | 0.035736083984375 | 0.00266265869140625 | 0.009999999776482582 | 0.58984375 | -0.0574951171875 | 0.03900146484375 | 0.0142822265625 | -0.005489349365234375 | 0.0088958740234375 | 0.298828125 | 0.258056640625 | 0.0185394287109375 | 0.2476806640625 | 0.0126800537109375 | 0.002330780029296875 | 0.005619049072265625 | 0.3330078125 | 0.459228515625 | 0.145263671875 | 0.78955078125 | 0.5693359375 | |
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;