This data as json, CSV (advanced)
Suggested facets: albums, favorite, ZCURATIONSCORE, ZINTERACTIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | ![]() |
F92B1415-1D5D-45A6-A736-54D988748BBF | 2020-01-25T19:32:06+00:00 | [ "Public" ] |
[] |
jpeg | 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a | 5851617 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F92B1415-1D5D-45A6-A736-54D988748BBF | 0.5068359375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.030731201171875 | 0.00522613525390625 | 0.00208282470703125 | 0.009999999776482582 | -0.45166015625 | -0.199951171875 | -0.006561279296875 | 0.033905029296875 | -0.04132080078125 | -0.09454345703125 | -0.6005859375 | -0.357666015625 | 0.0240936279296875 | -0.1298828125 | 0.002777099609375 | -0.021331787109375 | 0.0008692741394042969 | 0.020294189453125 | -0.1363525390625 | -0.057342529296875 | -0.0946044921875 | -0.033966064453125 | |||||
434 | ![]() |
C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 2020-01-25T19:22:04+00:00 | [ "Public" ] |
[] |
jpeg | db785fae4d60624d0a90c7fc24ec36f2b6b95f6d158b42d8973210f3cabba91a | 6428626 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 | 0.64501953125 | 0.75 | 0.0 | 0.06110269104251425 | 0.10000000149011612 | -0.001972198486328125 | 0.003810882568359375 | 0.00208282470703125 | 0.009999999776482582 | 0.3271484375 | -0.042022705078125 | 0.2122802734375 | 0.0031108856201171875 | -0.0309600830078125 | -0.0080718994140625 | -0.04730224609375 | -0.1087646484375 | 0.04803466796875 | -0.0256805419921875 | 2.288818359375e-05 | -0.01338958740234375 | 0.002704620361328125 | 0.039642333984375 | 0.016815185546875 | -0.213623046875 | 0.50048828125 | -0.026947021484375 | |||||
269 | ![]() |
7705FF4E-2F25-45B9-B795-EA58244F3273 | 2018-02-13T18:53:28+00:00 | [ "Geotaggable Photos geotagged", "Public" ] |
[] |
jpeg | 81f94d4de59b28e89df4ff8ac3a7250e624cbd261e7d93701e6a8cafeeeb971e | 5483241 | 25.737587971741938 | -111.09106443298224 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Mexico | 7705FF4E-2F25-45B9-B795-EA58244F3273 | 0.708984375 | 0.5 | 0.0 | 0.043553611249414106 | 0.10000000149011612 | -0.06915283203125 | -0.00589752197265625 | 0.00208282470703125 | 0.019999999552965164 | -0.390869140625 | -0.14306640625 | -0.1083984375 | 0.0775146484375 | -0.12322998046875 | -0.06463623046875 | -0.58837890625 | -0.66650390625 | 0.024566650390625 | -0.1026611328125 | -0.0028285980224609375 | -0.06109619140625 | 0.0018100738525390625 | 0.00464630126953125 | -0.52734375 | -0.286376953125 | -0.095458984375 | -0.10565185546875 |
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;