This data as json, CSV (advanced)
Suggested facets: ext, ZINTERACTIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
107 | 8A1CFD4F-AF9F-4018-A451-4709416FAEA0 | 2019-11-02T20:39:44+00:00 | [ "Public" ] |
[] |
jpeg | 3345e08925ea68ce3808102dce8f4b4e08f6c65a77d405c8b7a4741c322e0c68 | 4263841 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8A1CFD4F-AF9F-4018-A451-4709416FAEA0 | 0.7177734375 | 0.75 | 0.0 | 0.06262569391090451 | 0.10000000149011612 | -0.0007410049438476562 | 0.0189056396484375 | 0.0011157989501953125 | 0.019999999552965164 | -0.064697265625 | -0.046905517578125 | 0.2431640625 | 0.0034160614013671875 | -0.01358795166015625 | 0.0128173828125 | -0.04541015625 | 0.04571533203125 | 0.055206298828125 | 0.05841064453125 | 0.003330230712890625 | -0.0134429931640625 | 0.0029582977294921875 | 0.242919921875 | 0.160888671875 | -0.0233154296875 | 0.61572265625 | 0.01202392578125 | ||||||
87 | F6C8C0BE-AC14-43D9-93DD-ABBE269505DC | 2019-11-02T20:32:08+00:00 | [ "Public" ] |
[] |
jpeg | 25ec2f2b497ddc05179526c0bc05ba1f553cce0e43638d01223a39f1b092a890 | 4871874 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | F6C8C0BE-AC14-43D9-93DD-ABBE269505DC | 0.77783203125 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.0036067962646484375 | -0.00318145751953125 | 0.002521514892578125 | 0.009999999776482582 | -0.092529296875 | -0.1480712890625 | 0.102783203125 | 0.00926971435546875 | -0.024383544921875 | -0.09161376953125 | -0.60888671875 | -0.254638671875 | 0.10968017578125 | -0.09063720703125 | -0.0031261444091796875 | -0.0168914794921875 | 0.0022335052490234375 | 0.0059814453125 | -0.056488037109375 | -0.429443359375 | -0.284912109375 | -0.06451416015625 | ||||||
90 | 9D0280F7-D619-4D2C-B323-B21CAEBA92EF | 2019-11-02T20:31:31+00:00 | [ "Public" ] |
[] |
jpeg | 277b4b361f6df02e423d1000b4d2a98c758f29a027c4bff347000b3ee93de2ed | 4596329 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9D0280F7-D619-4D2C-B323-B21CAEBA92EF | 0.8193359375 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.001941680908203125 | 0.004848480224609375 | 0.0013561248779296875 | 0.009999999776482582 | -0.90771484375 | -0.10125732421875 | 0.0489501953125 | 0.003635406494140625 | -0.00595855712890625 | -0.0113525390625 | -0.378173828125 | -0.061279296875 | 0.017303466796875 | 0.031341552734375 | -0.0163116455078125 | -0.0170745849609375 | 0.002140045166015625 | 0.134033203125 | 0.1602783203125 | -0.002685546875 | 0.431396484375 | -0.00119781494140625 | ||||||
297 | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 2019-11-02T19:10:14+00:00 | [ "Public" ] |
[] |
heic | 8e863e558a9bcd65dbfe5add8c6bc8fc5150358449cc9036d6fa9c428e7ba8ee | 2239399 | 37.456428329999994 | -122.10851949999999 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Palo Alto | CA | United States | 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 | 0.38037109375 | 0.75 | 0.0 | 0.05801763419659083 | 0.10000000149011612 | -0.002208709716796875 | 0.01380157470703125 | 0.0165252685546875 | 0.009999999776482582 | -0.21142578125 | -0.06890869140625 | 0.142333984375 | 0.006389617919921875 | -0.012481689453125 | -0.0638427734375 | -0.425537109375 | -0.05072021484375 | 0.202880859375 | -0.01123046875 | 0.0060272216796875 | -0.01305389404296875 | 0.004810333251953125 | 0.005062103271484375 | -0.00335693359375 | -0.10638427734375 | -0.413818359375 | -0.01690673828125 |
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;