This data as json, CSV (advanced)
Suggested facets: ZCURATIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
168 | 5DEBD78D-9E16-4991-A043-01941457D1B6 | 2018-02-11T19:35:21+00:00 | [ "Public" ] |
[] |
jpeg | 552cfb244a05a4402fa2076d3245ab3401c5fe745a60f6feaa61869b65133693 | 3866838 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5DEBD78D-9E16-4991-A043-01941457D1B6 | 0.66357421875 | 0.5 | 0.0 | 0.04202652250537436 | 0.10000000149011612 | -0.0006313323974609375 | 0.0293121337890625 | 0.00586700439453125 | 0.009999999776482582 | 0.1646728515625 | -0.049224853515625 | 0.47216796875 | 0.0010776519775390625 | -0.0070648193359375 | -0.035919189453125 | -0.1690673828125 | 0.03253173828125 | 0.09600830078125 | -0.0128173828125 | 0.0029449462890625 | -0.00699615478515625 | 0.002368927001953125 | 0.015899658203125 | 0.0003204345703125 | -0.256103515625 | 0.0166015625 | 0.0220947265625 | ||||||
103 | E2880EC4-C3B5-46E6-B555-C78CF75895C2 | 2018-02-11T19:35:20+00:00 | [ "Public" ] |
[] |
jpeg | 30f37193cf87e00bc0a9b36bcf5fd6972f627f24fe37cbd828e52101303d0e14 | 3812669 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | E2880EC4-C3B5-46E6-B555-C78CF75895C2 | 0.78955078125 | 0.75 | 0.0 | 0.06263722718216991 | 0.10000000149011612 | -0.0007791519165039062 | 0.03192138671875 | 0.007038116455078125 | 0.009999999776482582 | 0.1177978515625 | -0.06866455078125 | 0.433837890625 | 0.0021820068359375 | -0.006717681884765625 | -0.027587890625 | -0.263427734375 | 0.05645751953125 | 0.150634765625 | -0.010467529296875 | 0.00214385986328125 | -0.006992340087890625 | 0.00238800048828125 | 0.021240234375 | 0.0230712890625 | -0.302978515625 | -0.136962890625 | -0.01300048828125 | ||||||
257 | B062A78F-5C95-4072-ADF2-007D436B0B7E | 2018-02-11T19:26:29+00:00 | [ "Public" ] |
[] |
jpeg | 7d6b41e7ed116733ad90b7f35313cc9c33f78034df4d5194894a9a1cae2ca92d | 6355439 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B062A78F-5C95-4072-ADF2-007D436B0B7E | 0.64306640625 | 0.5 | 0.0 | 0.0420040488243103 | 0.10000000149011612 | -0.0019121170043945312 | 0.00333404541015625 | 0.0027256011962890625 | 0.009999999776482582 | -0.85546875 | -0.0301513671875 | 0.265380859375 | 0.0020904541015625 | -0.01358795166015625 | -0.0299530029296875 | -0.193603515625 | -0.072265625 | 0.0823974609375 | -0.017425537109375 | -0.021636962890625 | -0.033935546875 | 0.0034160614013671875 | 0.0292510986328125 | 0.0034637451171875 | -0.0279541015625 | 0.10302734375 | -0.008270263671875 | ||||||
361 | 99FD949E-C3D2-41B0-97DA-7560E90251ED | 2018-02-11T19:26:28+00:00 | [ "Public" ] |
[] |
jpeg | afeb4e2620b3b678169b397e0b9d5fb103639e0ee409bbcefff12841a716a85c | 6519197 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 99FD949E-C3D2-41B0-97DA-7560E90251ED | 0.634765625 | 0.5 | 0.0 | 0.042004234918201246 | 0.10000000149011612 | -0.00591278076171875 | 0.00647735595703125 | 0.004215240478515625 | 0.009999999776482582 | -0.9482421875 | -0.04351806640625 | 0.02557373046875 | 0.001972198486328125 | -0.00930023193359375 | -0.01512908935546875 | -0.171875 | -0.193359375 | 0.01374053955078125 | 0.0161590576171875 | -0.023590087890625 | -0.00858306884765625 | 0.0025119781494140625 | 0.0239105224609375 | -0.04583740234375 | 0.084716796875 | 0.199951171875 | -0.000225067138671875 |
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;