This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
160 | 536F85D8-60B3-4728-A836-04663A86DC6B | 2019-09-15T13:08:42+00:00 | [ "Public" ] |
[] |
jpeg | 4da99e1ec6bac9b6ab7f26b8aeda078259305b460e2fa33810b485c1760725ad | 5423408 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 536F85D8-60B3-4728-A836-04663A86DC6B | 0.80859375 | 0.75 | 0.0 | 0.06261790617731691 | 0.5048418641090393 | -0.0010204315185546875 | 0.0242462158203125 | 0.001941680908203125 | 0.07999999821186066 | 0.55126953125 | -0.057708740234375 | -0.000274658203125 | 0.0999755859375 | -0.01384735107421875 | 0.0078887939453125 | 0.22412109375 | 0.2369384765625 | 0.0125732421875 | 0.159912109375 | 0.0168914794921875 | 0.001590728759765625 | 0.005687713623046875 | 0.363525390625 | 0.435546875 | 0.07342529296875 | 0.83544921875 | 0.35693359375 | ||||||
126 | A967087A-B06E-4B0E-A1E6-015C61FD460E | 2019-09-15T13:14:09+00:00 | [ "Public" ] |
[] |
jpeg | 3bb9961495d7ee420b248a932ddd3335ea67e7eed4bfae3b586f75e7883f80fc | 5799222 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A967087A-B06E-4B0E-A1E6-015C61FD460E | 0.79052734375 | 0.75 | 0.0 | 0.0626213627917166 | 0.5045498609542847 | -0.001461029052734375 | 0.03533935546875 | 0.0022869110107421875 | 0.07999999821186066 | 0.5009765625 | -0.044769287109375 | 0.01611328125 | 0.06634521484375 | -0.0104522705078125 | 0.007366180419921875 | 0.31103515625 | 0.2568359375 | 0.0154266357421875 | 0.212646484375 | 0.02606201171875 | 0.002635955810546875 | 0.00577545166015625 | 0.495849609375 | 0.69287109375 | 0.215087890625 | 0.83984375 | 0.302978515625 |
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;