This data as json, CSV (advanced)
Suggested facets: ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZPLEASANTLIGHTINGSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199 | AC1D606E-185E-4B60-8213-782BE58B9DCE | 2020-04-23T23:29:15+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 6416af8c3fbce9295cc68411b2710c23ed8736a4ff4e23dd59627b960839241d | 8772563 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | AC1D606E-185E-4B60-8213-782BE58B9DCE | 0.4287109375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0013885498046875 | 0.024078369140625 | 0.0015668869018554688 | 0.009999999776482582 | -0.280517578125 | -0.0966796875 | 0.0313720703125 | 0.01837158203125 | -0.006389617919921875 | 0.0133056640625 | -0.011474609375 | 0.121826171875 | 0.034027099609375 | 0.306640625 | 0.01020050048828125 | -0.005748748779296875 | 0.0057525634765625 | 0.456298828125 | 0.650390625 | 0.0997314453125 | 0.7548828125 | 0.040557861328125 | ||||||
13 | 8FB56C6C-6557-43E8-AC87-EF6E54F7F346 | 2020-04-23T23:28:23+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 0762b5e844628b9e0b2a663a651df274d556c4f22705447e13546406cd779215 | 8341604 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8FB56C6C-6557-43E8-AC87-EF6E54F7F346 | 0.378662109375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0014324188232421875 | 0.005527496337890625 | 0.0009217262268066406 | 0.009999999776482582 | -0.455322265625 | -0.1181640625 | 0.0677490234375 | 0.0192413330078125 | -0.00981903076171875 | -0.0017242431640625 | -0.345703125 | -0.0826416015625 | 0.0384521484375 | 0.024566650390625 | -0.005931854248046875 | -0.02398681640625 | 0.004024505615234375 | 0.2054443359375 | 0.29541015625 | -0.298828125 | 0.59765625 | -0.00146484375 | ||||||
467 | DD2793EA-51C4-4196-AB34-12A665ACFF43 | 2020-04-23T23:25:49+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | eb9a25b29f51de5866383837f752a823eb39fcd7c6948af08970efbec9a117ee | 9031772 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DD2793EA-51C4-4196-AB34-12A665ACFF43 | 0.3916015625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0023975372314453125 | 0.040679931640625 | 0.004055023193359375 | 0.009999999776482582 | 0.01025390625 | -0.07598876953125 | 0.065185546875 | 0.011688232421875 | -0.004924774169921875 | 0.00323486328125 | 0.0611572265625 | 0.137451171875 | 0.0294189453125 | 0.222900390625 | 0.011871337890625 | -0.0007877349853515625 | 0.00392913818359375 | 0.2490234375 | 0.5400390625 | 0.0853271484375 | 0.525390625 | 0.1787109375 | ||||||
436 | 920D2FF3-BB4B-458A-B4B7-42D961777959 | 2020-04-23T23:23:27+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | dcdeb1800b9dff39a7b9b898cf72194e497608be08a212ea5eb0c707c2111dc8 | 7961248 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 920D2FF3-BB4B-458A-B4B7-42D961777959 | 0.5087890625 | 0.75 | 0.0 | 0.05801526718694745 | 0.5029926896095276 | -0.0018033981323242188 | 0.038604736328125 | 0.0033512115478515625 | 0.009999999776482582 | 0.19921875 | -0.0640869140625 | 0.0626220703125 | 0.01214599609375 | -0.005218505859375 | 0.00536346435546875 | 0.1387939453125 | 0.170166015625 | 0.028594970703125 | 0.214599609375 | 0.01074981689453125 | 0.00038909912109375 | 0.004085540771484375 | 0.28076171875 | 0.568359375 | 0.0885009765625 | 0.5859375 | 0.28515625 | ||||||
375 | 91CFD354-BAD6-4367-9146-B5E214F7AED7 | 2020-04-23T23:21:22+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | b8a2541f7d0a3a7ba42e82810ff7409a0c4bb2e62d1ed0350f35ce2d47f6eaba | 8662294 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 91CFD354-BAD6-4367-9146-B5E214F7AED7 | 0.2109375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.001674652099609375 | 0.0701904296875 | 0.00586700439453125 | 0.009999999776482582 | -0.2425537109375 | -0.05291748046875 | 0.0955810546875 | 0.009674072265625 | -0.0018825531005859375 | 0.002086639404296875 | 0.17578125 | 0.209716796875 | 0.07366943359375 | 0.24951171875 | 0.01739501953125 | 0.0 | 0.006717681884765625 | 0.33154296875 | 0.740234375 | 0.060089111328125 | 0.349853515625 | 0.033599853515625 | ||||||
357 | 8E150DC5-5E6A-4286-9110-44501EC99304 | 2020-04-23T23:20:00+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | ada4f24e3ed43ef25da0ae2be782edc1bd9330d15661a67614cbafccb3277d63 | 7711907 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8E150DC5-5E6A-4286-9110-44501EC99304 | 0.50390625 | 0.75 | 0.0 | 0.05801526718694745 | 0.7075425386428833 | -0.0005192756652832031 | 0.07769775390625 | 0.006824493408203125 | 0.009999999776482582 | 0.3955078125 | -0.041839599609375 | 0.260009765625 | 0.0034694671630859375 | -0.004791259765625 | 0.0063018798828125 | 0.1600341796875 | 0.209716796875 | 0.025177001953125 | 0.13916015625 | 0.0210418701171875 | 0.00106048583984375 | 0.003376007080078125 | 0.11297607421875 | 0.06793212890625 | 0.1895751953125 | 0.517578125 | 0.210205078125 | ||||||
285 | 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 | 2020-04-23T23:18:02+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 888f348b246e038ce7f950f3e5aca8169910d6bf144219c1e0dc80cd8117a2dd | 8485248 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3BBBA8C5-62F9-4BFE-9DB6-CC38EAF11461 | 0.47900390625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.004718780517578125 | 0.0163421630859375 | 0.00473785400390625 | 0.009999999776482582 | -0.95166015625 | -0.0276336669921875 | 0.07867431640625 | 0.0016422271728515625 | -0.00577545166015625 | -0.00798797607421875 | -0.0096435546875 | -0.08978271484375 | 0.01934814453125 | 0.0404052734375 | -0.0308837890625 | -0.005924224853515625 | 0.0034027099609375 | 0.050994873046875 | -0.00604248046875 | 0.1451416015625 | 0.304443359375 | 0.001800537109375 | ||||||
254 | 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 | 2020-04-23T19:57:00+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 7c22edd556267a6ee4b7016590064b1575aaaeb430dcfa674acfa5934eae85d9 | 8164899 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 | 0.443115234375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0014781951904296875 | 0.018951416015625 | 0.0059814453125 | 0.019999999552965164 | -0.01611328125 | -0.056549072265625 | 0.10302734375 | 0.011199951171875 | -0.01525115966796875 | -0.0132904052734375 | -0.09503173828125 | -0.0242919921875 | 0.06646728515625 | 0.053741455078125 | 0.005584716796875 | -0.01021575927734375 | 0.00646209716796875 | 0.037689208984375 | 0.017913818359375 | -0.04901123046875 | 0.292236328125 | 0.03363037109375 | ||||||
444 | 0CEC9F87-56B8-4E82-885D-CE573A5A6733 | 2020-04-23T19:26:40+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | e19325bdaa3af04606d769494a62518ac08b5978677831eae415b73e4d05ae0a | 8097615 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0CEC9F87-56B8-4E82-885D-CE573A5A6733 | 0.2744140625 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.00217437744140625 | 0.031585693359375 | 0.001789093017578125 | 0.019999999552965164 | 0.165283203125 | -0.072265625 | 0.1336669921875 | 0.00885009765625 | -0.01142120361328125 | 0.0089263916015625 | 0.01983642578125 | 0.08697509765625 | 0.036346435546875 | 0.1024169921875 | -0.00299072265625 | -0.00263214111328125 | 0.001964569091796875 | 0.2469482421875 | 0.583984375 | 0.1607666015625 | 0.599609375 | 0.2371826171875 | ||||||
207 | 52E83D4D-36AA-465B-818C-307DE872BF95 | 2020-04-23T19:25:14+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 679f4717f5d0fd9be0f0f39be3a1387b1ad828b30405f5a6f9acb3ffdc046911 | 8312828 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52E83D4D-36AA-465B-818C-307DE872BF95 | 0.42724609375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.053192138671875 | 0.00365447998046875 | 0.0082855224609375 | 0.009999999776482582 | -0.53271484375 | -0.049407958984375 | -0.058380126953125 | 0.0460205078125 | -0.1201171875 | -0.037750244140625 | -0.2880859375 | -0.47265625 | 0.017913818359375 | -0.052459716796875 | 0.001800537109375 | -0.016693115234375 | 0.0013885498046875 | 0.003780364990234375 | -0.1241455078125 | 0.0040130615234375 | -0.17236328125 | -0.018096923828125 | ||||||
70 | C0A58C86-B004-4413-855B-12A697F129D6 | 2020-04-23T19:19:34+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 1fb3b73785ed9eb8ed706f9a7714d46c5508fcc0cf36c8212c9f88dd07d8640c | 5960171 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | C0A58C86-B004-4413-855B-12A697F129D6 | 0.384521484375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.1927490234375 | -0.00449371337890625 | 0.00555419921875 | 0.009999999776482582 | -0.49853515625 | -0.0809326171875 | -0.1781005859375 | 0.060638427734375 | -0.2347412109375 | -0.032470703125 | -0.41845703125 | -0.6962890625 | 0.01267242431640625 | -0.06781005859375 | -0.0036258697509765625 | -0.01239776611328125 | 0.0015974044799804688 | 0.00313568115234375 | -0.78173828125 | -0.075439453125 | -0.02978515625 | -0.1043701171875 | ||||||
314 | 0C9E4525-4A55-463C-ADC3-6A3A56113ABD | 2020-04-23T19:17:34+00:00 | [ "Photography homework composition April 2020", "Public" ] |
[] |
jpeg | 9971057ac89f7bdaf9c714d5391e7b2abab2c6cc92640f7806088a593c713f80 | 6475710 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0C9E4525-4A55-463C-ADC3-6A3A56113ABD | 0.448974609375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0018463134765625 | 0.01727294921875 | 0.0021152496337890625 | 0.009999999776482582 | -0.411376953125 | -0.053497314453125 | 0.1123046875 | 0.0083770751953125 | -0.0191650390625 | -0.01861572265625 | -0.139404296875 | -0.0224609375 | 0.0299835205078125 | 0.05865478515625 | 0.0028533935546875 | -0.0088653564453125 | 0.00254058837890625 | 0.09808349609375 | 0.055267333984375 | 0.04888916015625 | 0.394287109375 | 0.007568359375 |
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;