This data as json, CSV (advanced)
Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZBEHAVIORALSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
353 | C0471BD8-EBE8-49F4-A9BB-D6C067279A87 | 2020-02-22T23:13:39+00:00 | [ "Public" ] |
[] |
jpeg | ab7c204eddcf3e5af89f6d55ca9d174684fb5350b6c013117efe3a801c6e2e42 | 6247543 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C0471BD8-EBE8-49F4-A9BB-D6C067279A87 | 0.65673828125 | 0.75 | 0.0 | 0.06110306277529884 | 0.10000000149011612 | -0.0009546279907226562 | 0.01290130615234375 | 0.00395965576171875 | 0.009999999776482582 | -0.064453125 | -0.03662109375 | 0.233642578125 | 0.0014104843139648438 | -0.01363372802734375 | -0.0123443603515625 | -0.0489501953125 | 0.00372314453125 | 0.048675537109375 | 0.005401611328125 | 0.00226593017578125 | -0.0153045654296875 | 0.0026721954345703125 | 0.0391845703125 | 0.016632080078125 | 0.0863037109375 | 0.330810546875 | -0.0025634765625 | ||||||
327 | 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 | 2020-01-25T19:45:34+00:00 | [ "Public" ] |
[] |
jpeg | 9f498cd0be0d5dcd46726651f0a3124f26218483c8dea3749507a4867ab325bd | 5827512 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 | 0.6240234375 | 0.75 | 0.0 | 0.06109860516686476 | 0.10000000149011612 | -0.00034737586975097656 | 0.0128173828125 | 0.00395965576171875 | 0.009999999776482582 | -0.19140625 | -0.0374755859375 | 0.2568359375 | 0.0023784637451171875 | -0.007843017578125 | -0.013397216796875 | -0.09765625 | 0.03204345703125 | 0.2281494140625 | 0.043853759765625 | 0.000957489013671875 | -0.0231170654296875 | 0.01348114013671875 | 0.04534912109375 | 0.0098876953125 | -0.172607421875 | 0.347412109375 | -0.00164031982421875 | ||||||
125 | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 2018-04-22T00:11:12+00:00 | [ "Museums", "Public" ] |
[] |
heic | 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d | 1565205 | 37.57926666666667 | -122.34417 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | CC3EF420-EAC4-4661-8D68-C2009F892C04 | 0.23974609375 | 0.5 | 0.0 | 0.038931297721298594 | 0.5029440522193909 | -0.0008831024169921875 | 0.11505126953125 | 0.00395965576171875 | 0.019999999552965164 | 0.0281982421875 | -0.0225067138671875 | 0.27880859375 | 0.01009368896484375 | -0.0069580078125 | 0.039337158203125 | 0.1673583984375 | 0.260498046875 | 0.1424560546875 | 0.36865234375 | 0.142822265625 | -0.00147247314453125 | 0.00600433349609375 | 0.501953125 | 0.66943359375 | 0.48828125 | 0.607421875 | 0.0160064697265625 |
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;