This data as json, CSV (advanced)
Suggested facets: ext, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 406 | ![]() |
84CA3880-9BC5-4FF0-9416-8AF1800985EC | 2018-04-21T23:58:06+00:00 | [
"Museums",
"Public"
] |
[] |
heic | ca6c89425c6d03f3b3f62a708c74f4708339166080dde1b289d842d142c8fd3f | 936298 | 37.57915833333333 | -122.344155 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 84CA3880-9BC5-4FF0-9416-8AF1800985EC | 0.321044921875 | 0.6 | 0.0 | 0.04656488550755814 | 0.10000000149011612 | -0.00243377685546875 | 0.0157470703125 | 0.005535125732421875 | 0.07999999821186066 | 0.1326904296875 | -0.06890869140625 | 0.02349853515625 | 0.042327880859375 | -0.037689208984375 | -0.036102294921875 | -0.1865234375 | -0.161376953125 | 0.09637451171875 | 0.042724609375 | 0.013031005859375 | -0.007396697998046875 | 0.00679779052734375 | 0.019561767578125 | -0.001312255859375 | -0.07696533203125 | 0.11273193359375 | 0.023681640625 |
| 213 | ![]() |
FC705948-B3D8-4B7A-90A6-E617B3ED80F6 | 2018-02-09T17:07:31+00:00 | [
"Public"
] |
[] |
jpeg | 69c533c4c5bfc739e1eced0562e7a2945919176fa7e13a432e5a0ee5731a59ae | 5878523 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FC705948-B3D8-4B7A-90A6-E617B3ED80F6 | 0.58740234375 | 0.5 | 0.0 | 0.04203098011380844 | 0.10000000149011612 | -0.00243377685546875 | 0.008056640625 | 0.0013408660888671875 | 0.009999999776482582 | -0.2054443359375 | -0.036285400390625 | 0.333740234375 | 0.0038547515869140625 | -0.02337646484375 | -0.02716064453125 | -0.0999755859375 | -0.0706787109375 | 0.161376953125 | -0.068359375 | 0.001575469970703125 | -0.10321044921875 | 0.003795623779296875 | 0.07476806640625 | 0.0780029296875 | -0.124755859375 | 0.33203125 | -0.0229339599609375 | |||||
| 433 | ![]() |
351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 2008-10-12T11:08:24+00:00 | [
"Museums",
"Saved from Flickr",
"Public"
] |
[] |
jpeg | d9f59c4c2c01c61648d6f674daf87ead919acf6c9590869ff095163f2458d70f | 2842517 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 351DAFC9-ABE1-41B8-8613-E1A73CE951B0 | 0.47998046875 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.00243377685546875 | 0.01280975341796875 | 0.010650634765625 | 0.009999999776482582 | -0.415771484375 | -0.11578369140625 | -0.0576171875 | 0.022674560546875 | -0.0143890380859375 | -0.07208251953125 | -0.44140625 | -0.229736328125 | 0.0592041015625 | 0.10528564453125 | 0.0046234130859375 | -0.0079498291015625 | 0.00800323486328125 | 0.006771087646484375 | -0.0199127197265625 | -0.0235748291015625 | -0.1326904296875 | 0.02508544921875 |
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;