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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335 | 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 | 2020-01-25T19:22:55+00:00 | [ "Public" ] |
[] |
jpeg | a29c3a38ab84cb5a9158d2d1f5047f614c3065bc852042909e5ac09a59988275 | 5399639 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 | 0.46875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0006771087646484375 | 0.032440185546875 | 0.00464630126953125 | 0.009999999776482582 | -0.192138671875 | -0.0174407958984375 | 0.354248046875 | 0.001056671142578125 | -0.008544921875 | -0.00421142578125 | 0.0537109375 | 0.05224609375 | 0.07861328125 | 0.060516357421875 | 0.00852203369140625 | -0.0089111328125 | 0.00469970703125 | 0.08929443359375 | 0.027984619140625 | 0.271240234375 | 0.461181640625 | 0.0001983642578125 | ||||||
246 | 1CE89584-DE92-4290-91D3-EDDFD28FEC5D | 2019-09-15T12:51:42+00:00 | [ "Public" ] |
[] |
jpeg | 78e814db89cff24f2189151f2b080c7aba9dcaa1b05e0d0444ca8b8111b46966 | 5301232 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1CE89584-DE92-4290-91D3-EDDFD28FEC5D | 0.703125 | 0.75 | 0.0 | 0.06262847985930116 | 0.5045985579490662 | -0.0006413459777832031 | 0.021331787109375 | 0.0020351409912109375 | 0.05999999865889549 | 0.6328125 | -0.061309814453125 | 0.012725830078125 | 0.037109375 | -0.008544921875 | 0.0101776123046875 | 0.285888671875 | 0.2958984375 | 0.01242828369140625 | 0.1907958984375 | 0.0125732421875 | 0.001712799072265625 | 0.006122589111328125 | 0.441650390625 | 0.5263671875 | 0.0867919921875 | 0.86328125 | 0.423095703125 | ||||||
171 | 578C0EBB-DB86-40B7-9F4C-10156D8962CD | 2019-09-15T12:43:46+00:00 | [ "Public" ] |
[] |
jpeg | 57769019fe5b10d018767fca7528dffbfe2e3a1ba3d9acfdea5a284dfdf3b31e | 5089150 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 578C0EBB-DB86-40B7-9F4C-10156D8962CD | 0.67431640625 | 0.75 | 0.0 | 0.061102877136405186 | 0.5051581263542175 | -0.0007643699645996094 | 0.03277587890625 | 0.001941680908203125 | 0.10000000149011612 | 0.61767578125 | -0.061431884765625 | 0.02618408203125 | 0.039703369140625 | -0.008544921875 | 0.009307861328125 | 0.25048828125 | 0.242431640625 | 0.01287078857421875 | 0.1942138671875 | 0.0166015625 | 0.002025604248046875 | 0.004848480224609375 | 0.366943359375 | 0.433837890625 | 0.091552734375 | 0.8076171875 | 0.38623046875 | ||||||
278 | F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 | 2017-06-16T00:54:59+00:00 | [ "Stolen monasteries", "Public" ] |
[] |
jpeg | 85c32ecbb8b5b4e75514799212c4bdd8c51469269e931a1fb6aa53f87dc92676 | 4565297 | 37.76912 | -122.46459166666666 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 | 0.361572265625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10087591409683228 | -0.0004372596740722656 | 0.1085205078125 | 0.00908660888671875 | 0.009999999776482582 | -0.0367431640625 | -0.020172119140625 | 0.271484375 | 0.01512908935546875 | -0.008544921875 | 0.01593017578125 | 0.140869140625 | 0.227294921875 | 0.212890625 | 0.343505859375 | 0.08966064453125 | -0.0034332275390625 | 0.0169830322265625 | 0.10992431640625 | 0.03192138671875 | 0.1953125 | 0.363037109375 | 0.009735107421875 |
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;