This data as json, CSV (advanced)
Suggested facets: ZCURATIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
50 | B0F72802-C713-43D3-899A-81C4AED347DC | 2019-11-02T20:32:07+00:00 | [ "Public" ] |
[] |
jpeg | 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 | 4949434 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B0F72802-C713-43D3-899A-81C4AED347DC | 0.79150390625 | 0.75 | 0.0 | 0.06261464384675935 | 0.10000000149011612 | -0.0027790069580078125 | -0.003040313720703125 | 0.0018463134765625 | 0.03999999910593033 | 0.2215576171875 | -0.05780029296875 | 0.063232421875 | 0.00916290283203125 | -0.085693359375 | -0.040863037109375 | -0.1737060546875 | -0.291259765625 | 0.11456298828125 | -0.05914306640625 | -0.00067138671875 | -0.021148681640625 | 0.00473785400390625 | 0.00933837890625 | -0.023468017578125 | -0.37060546875 | 0.235595703125 | -0.053070068359375 | ||||||
422 | BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 2019-11-02T20:31:29+00:00 | [ "Public" ] |
[] |
jpeg | d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 | 4246410 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | BA1C8565-7D1C-49E3-93BA-183B8D6B1270 | 0.84228515625 | 0.75 | 0.0 | 0.06261613123289501 | 0.10000000149011612 | -0.0006117820739746094 | 0.0157012939453125 | 0.0020351409912109375 | 0.03999999910593033 | 0.599609375 | -0.06622314453125 | 0.10491943359375 | 0.01009368896484375 | -0.015838623046875 | 0.00726318359375 | 0.02276611328125 | -0.0177001953125 | 0.07318115234375 | 0.0751953125 | 0.00572967529296875 | -0.008392333984375 | 0.00867462158203125 | 0.0836181640625 | 0.047119140625 | -0.158203125 | 0.68798828125 | 0.1689453125 | ||||||
152 | A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 2019-11-02T20:30:59+00:00 | [ "Public" ] |
[] |
jpeg | 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c | 4629001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A40BDBBE-2DC6-4385-8108-8C15F37610B4 | 0.54931640625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.001918792724609375 | -0.00484466552734375 | 0.002834320068359375 | 0.03999999910593033 | 0.165283203125 | -0.04052734375 | 0.24755859375 | 0.0024623870849609375 | -0.04595947265625 | -0.04052734375 | -0.1414794921875 | -0.1551513671875 | 0.20751953125 | -0.065673828125 | -0.00061798095703125 | -0.0300750732421875 | 0.005161285400390625 | 0.00844573974609375 | -0.01395416259765625 | -0.49267578125 | 0.1368408203125 | -0.09515380859375 | ||||||
161 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 2019-11-02T20:23:51+00:00 | [ "Public" ] |
[] |
jpeg | 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 | 5127846 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A | 0.6171875 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0006799697875976562 | 0.0157928466796875 | 0.01085662841796875 | 0.03999999910593033 | 0.0447998046875 | -0.04351806640625 | 0.267578125 | 0.0020503997802734375 | -0.00844573974609375 | -0.02105712890625 | -0.161376953125 | 0.03826904296875 | 0.12213134765625 | 0.011474609375 | 0.0068359375 | -0.0125885009765625 | 0.005706787109375 | 0.0153045654296875 | 0.002277374267578125 | -0.194580078125 | 0.0333251953125 | -0.00848388671875 |
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;