This data as json, CSV (advanced)
Suggested facets: ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
342 | E5CE20F5-1129-4B42-B765-D847EE083715 | 2018-04-22T00:15:27+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | a5e2d73b2ecb3c659734df6f3a73247ee4630cda0e44eade13e964894de7a03e | 695247 | 37.57915 | -122.3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | E5CE20F5-1129-4B42-B765-D847EE083715 | 0.354736328125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0029811859130859375 | -0.00356292724609375 | 0.003765106201171875 | 0.009999999776482582 | -0.5068359375 | -0.06512451171875 | 0.155029296875 | 0.0029239654541015625 | -0.027435302734375 | -0.134521484375 | -0.495849609375 | -0.180908203125 | 0.1697998046875 | -0.162353515625 | -0.0001468658447265625 | -0.0251922607421875 | 0.0031604766845703125 | 0.005889892578125 | -0.0141448974609375 | -0.1646728515625 | -0.341552734375 | -0.03619384765625 | |
439 | D6E497F5-7F93-4434-96D4-7927D358886A | 2018-04-22T00:11:18+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | decf63b8e7a30b93e080919d312b4d985736ca17678d96fa4fdd3ce81c84a721 | 1463975 | 37.57925 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | D6E497F5-7F93-4434-96D4-7927D358886A | 0.331787109375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0006289482116699219 | 0.033294677734375 | 0.0013942718505859375 | 0.009999999776482582 | 0.0574951171875 | -0.040771484375 | 0.29443359375 | 0.0038700103759765625 | -0.01107025146484375 | 0.030059814453125 | 0.014404296875 | 0.0875244140625 | 0.0965576171875 | 0.1214599609375 | 0.0136871337890625 | -0.009765625 | 0.0038394927978515625 | 0.333984375 | 0.30810546875 | 0.0755615234375 | 0.6279296875 | 0.008331298828125 | |
398 | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 2018-04-22T00:09:15+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb | 1643785 | 37.57917 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 8338977E-56F0-4A7D-A6FD-33C2B27C9364 | 0.36279296875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0012941360473632812 | 0.027679443359375 | 0.0012941360473632812 | 0.019999999552965164 | -0.12005615234375 | -0.033203125 | 0.3701171875 | 0.0015306472778320312 | -0.00894927978515625 | 0.0038604736328125 | -0.0025634765625 | 0.030609130859375 | 0.054412841796875 | 0.017578125 | 0.00809478759765625 | -0.013641357421875 | 0.001628875732421875 | 0.26904296875 | 0.358642578125 | 0.220458984375 | 0.546875 | -0.00630950927734375 | |
324 | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 2018-04-22T00:07:16+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 9dbef4fb7519b183da13d3ce4beb757618271e8a3b5805186c71c661d8979557 | 1922748 | 37.57928 | -122.344095 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 63D46A8E-CB33-48E1-A6A6-662AF9AD922D | 0.343017578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0009698867797851562 | 0.048065185546875 | 0.0038089752197265625 | 0.009999999776482582 | -0.1185302734375 | -0.0616455078125 | 0.208984375 | 0.01029205322265625 | -0.01132965087890625 | -0.01513671875 | -0.109130859375 | 0.07952880859375 | 0.1773681640625 | 0.173828125 | 0.0297088623046875 | -0.0113525390625 | 0.006565093994140625 | 0.1048583984375 | 0.1142578125 | 0.0379638671875 | 0.283447265625 | 0.007232666015625 | |
463 | 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 | 2018-04-21T23:56:51+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | e9c9c3b5d9d960e1586c1d0751ef30220af107ae28de70ddc52c7da5b37e36db | 1870385 | 37.57906666666667 | -122.34423 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 | 0.3544921875 | 0.6 | 0.0 | 0.04656488550755814 | 0.10000000149011612 | -0.0083770751953125 | 0.00119781494140625 | 0.004627227783203125 | 0.009999999776482582 | -0.49560546875 | -0.0994873046875 | -0.05328369140625 | 0.04742431640625 | -0.041534423828125 | -0.05999755859375 | -0.501953125 | -0.37744140625 | 0.18798828125 | -0.01983642578125 | 0.00074005126953125 | -0.01611328125 | 0.00815582275390625 | 0.01085662841796875 | -0.07183837890625 | -0.10101318359375 | -0.13720703125 | -0.015838623046875 |
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;