This data as json, CSV (advanced)
Suggested facets: persons, latitude, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
83 | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 2018-04-22T00:19:14+00:00 | [ "Museums", "Public" ] |
[] |
heic | 246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410 | 1382543 | 37.57926666666667 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 | 0.44775390625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00217437744140625 | 0.007617950439453125 | 0.00279998779296875 | 0.019999999552965164 | 0.0296630859375 | -0.06707763671875 | 0.161865234375 | 0.005039215087890625 | -0.02947998046875 | -0.06591796875 | -0.220458984375 | -0.12347412109375 | 0.06634521484375 | -0.047119140625 | 0.000492095947265625 | -0.016754150390625 | 0.0034027099609375 | 0.0193023681640625 | -0.02313232421875 | -0.205810546875 | 0.237060546875 | 0.01519775390625 | |
125 | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 2018-04-22T00:11:12+00:00 | [ "Museums", "Public" ] |
[] |
heic | 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d | 1565205 | 37.57926666666667 | -122.34417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 0.23974609375 | 0.5 | 0.0 | 0.038931297721298594 | 0.5029440522193909 | -0.0008831024169921875 | 0.11505126953125 | 0.00395965576171875 | 0.019999999552965164 | 0.0281982421875 | -0.0225067138671875 | 0.27880859375 | 0.01009368896484375 | -0.0069580078125 | 0.039337158203125 | 0.1673583984375 | 0.260498046875 | 0.1424560546875 | 0.36865234375 | 0.142822265625 | -0.00147247314453125 | 0.00600433349609375 | 0.501953125 | 0.66943359375 | 0.48828125 | 0.607421875 | 0.0160064697265625 | |
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 | |
486 | 5A10AEF0-50DA-41BE-80F2-79E3367C343E | 2018-04-22T00:02:59+00:00 | [ "Museums", "Public" ] |
[] |
heic | fa48b9304c0a1de7f0cc8a3512c76452dc458964ea0394ea346740ed8b71eee9 | 1657904 | 37.579253333333334 | -122.34418666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 5A10AEF0-50DA-41BE-80F2-79E3367C343E | 0.364501953125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.005428314208984375 | -0.009002685546875 | 0.0024242401123046875 | 0.019999999552965164 | -0.136962890625 | -0.06658935546875 | 0.1895751953125 | 0.00661468505859375 | -0.07861328125 | -0.124267578125 | -0.375244140625 | -0.223388671875 | 0.31005859375 | -0.18896484375 | -0.0026531219482421875 | -0.03070068359375 | 0.0036067962646484375 | 0.007518768310546875 | -0.0423583984375 | -0.465576171875 | -0.2138671875 | -0.1270751953125 | |
249 | DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F | 2018-04-21T23:55:29+00:00 | [ "Museums", "Public" ] |
[] |
heic | 798436ad6175c55c8785bfbc10c8ffe60913b521a52312735f138f37e3cb4d81 | 1173698 | 37.579053333333334 | -122.34420833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F | 0.27099609375 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.005279541015625 | 0.00095367431640625 | 0.00243377685546875 | 0.019999999552965164 | -0.41845703125 | -0.12200927734375 | 0.01702880859375 | 0.0144500732421875 | -0.038970947265625 | -0.09381103515625 | -0.54541015625 | -0.300048828125 | 0.050048828125 | -0.0985107421875 | -0.00109100341796875 | -0.01496124267578125 | 0.0021915435791015625 | 0.012237548828125 | -0.0482177734375 | -0.16259765625 | -0.0987548828125 | -0.0265350341796875 |
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;