This data as json, CSV (advanced)
Suggested facets: ext, favorite, place_city, place_state_province, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZNOISESCORE, date (date), 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
212 | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 2019-09-11T16:31:25+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 | 1910261 | 29.934663333333333 | -90.06162216666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | New Orleans | LA | United States | 46BAA089-F20D-40E3-8161-5C0FA28FAA90 | 0.57666015625 | 0.75 | 0.0 | 0.0580211847110559 | 0.10000000149011612 | -0.00044083595275878906 | 0.00860595703125 | 0.0017414093017578125 | 0.14000000059604645 | 0.34814453125 | -0.051177978515625 | 0.31787109375 | 0.0015125274658203125 | -0.01107025146484375 | 0.000823974609375 | -0.06640625 | -0.00482177734375 | 0.06878662109375 | -0.014892578125 | 0.00110626220703125 | -0.015899658203125 | 0.0032978057861328125 | 0.0634765625 | 0.028564453125 | -0.33447265625 | 0.505859375 | -0.003997802734375 | |
419 | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 2018-05-18T20:39:03+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 | 1884793 | 37.04161116666667 | -122.07271666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Felton | CA | United States | 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C | 0.385009765625 | 0.75 | 0.0 | 0.05802466925091416 | 0.10000000149011612 | -0.0021572113037109375 | -0.0006103515625 | 0.0034160614013671875 | 0.009999999776482582 | -0.064208984375 | -0.09930419921875 | 0.287109375 | 0.004180908203125 | -0.016845703125 | -0.0426025390625 | -0.50341796875 | -0.06573486328125 | 0.1298828125 | -0.06414794921875 | -0.007534027099609375 | -0.0122222900390625 | 0.0013456344604492188 | 0.01177978515625 | 0.0101470947265625 | -0.53271484375 | -0.367919921875 | -0.1138916015625 | |
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 | |
121 | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 2017-10-27T20:53:21+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
heic | 39fd5df732f4fb55c94fc2d90bbe3abcf8e5a748d6b5800817d063c4f1a5e0c5 | 1735752 | 37.80936166666667 | -122.42176166666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 76336F73-88DA-4E89-8E57-4A38FEA2986B | 0.413818359375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0007381439208984375 | 0.0229949951171875 | 0.0022258758544921875 | 0.009999999776482582 | -0.254638671875 | -0.0230255126953125 | 0.07403564453125 | 0.00905609130859375 | -0.01450347900390625 | 0.0073089599609375 | 0.19091796875 | 0.10369873046875 | 0.03436279296875 | 0.240478515625 | 0.0076141357421875 | -0.003936767578125 | 0.0083160400390625 | 0.33203125 | 0.13232421875 | 0.221435546875 | 0.76416015625 | 0.01605224609375 | |
470 | 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 | 2017-07-23T22:13:38+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
jpeg | edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 | 2233683 | 37.84250333333333 | -122.27778666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Oakland | CA | United States | 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 | 0.405517578125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0017681121826171875 | -0.00296783447265625 | 0.0022258758544921875 | 0.009999999776482582 | -0.478271484375 | -0.06671142578125 | 0.252685546875 | 0.0009074211120605469 | -0.0202178955078125 | -0.118896484375 | -0.44580078125 | -0.0966796875 | 0.0823974609375 | -0.167724609375 | -0.0023097991943359375 | -0.034423828125 | 0.0016355514526367188 | 0.01061248779296875 | -0.007694244384765625 | -0.294677734375 | -0.1962890625 | -0.0555419921875 | |
432 | 69C46054-1D8F-4FD6-ABC7-2369C79921F4 | 2016-11-05T20:55:46+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_" ] |
jpeg | d966b699790953594f2be6cc03c5e5b3d478ebf27122037a7dc022db7642411e | 2299000 | 37.828136666666666 | -122.52736666666667 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Sausalito | CA | United States | 69C46054-1D8F-4FD6-ABC7-2369C79921F4 | 0.4814453125 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0009508132934570312 | 0.047760009765625 | 0.05499267578125 | 0.009999999776482582 | -0.06640625 | -0.043701171875 | 0.10211181640625 | 0.0026111602783203125 | -0.004505157470703125 | -0.045806884765625 | 0.0196533203125 | 0.0323486328125 | 0.05194091796875 | 0.1417236328125 | 0.0133056640625 | 0.00213623046875 | 0.00971221923828125 | 0.00661468505859375 | -0.0017147064208984375 | -0.00029754638671875 | -0.0811767578125 | 0.0098724365234375 |
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;