This data as json, CSV (advanced)
Suggested facets: ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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 | ||||||
19 | 92A798FF-8270-42BA-967F-41C0B3CB86DF | 2020-02-22T23:13:29+00:00 | [ "Public" ] |
[] |
jpeg | 0b24f2bad1807570b0002dc93e276fc5fd0de5c6843995acb7e5e9705cf0f58b | 4905665 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 92A798FF-8270-42BA-967F-41C0B3CB86DF | 0.67236328125 | 0.75 | 0.0 | 0.061114206568885394 | 0.10000000149011612 | -0.005199432373046875 | 0.019317626953125 | 0.006771087646484375 | 0.009999999776482582 | -0.2607421875 | -0.0455322265625 | -0.009613037109375 | 0.0224609375 | -0.042236328125 | -0.035186767578125 | -0.074462890625 | -0.1593017578125 | 0.034423828125 | 0.1011962890625 | 0.0055694580078125 | -0.0029449462890625 | 0.004505157470703125 | 0.015960693359375 | -0.031402587890625 | 0.06549072265625 | 0.1290283203125 | 0.101806640625 | ||||||
443 | DE8F9059-EB54-45DD-A749-75E2D53718E9 | 2020-02-22T23:11:21+00:00 | [ "Public" ] |
[] |
jpeg | e08f58b7b6bc615bef999d35a047478dee8cdb5e92a7c7271d92edc9d4c9cdc2 | 5083752 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | DE8F9059-EB54-45DD-A749-75E2D53718E9 | 0.65380859375 | 0.75 | 0.0 | 0.06112145012571611 | 0.10000000149011612 | -0.0013303756713867188 | 0.026123046875 | 0.009521484375 | 0.009999999776482582 | -0.83984375 | -0.03228759765625 | 0.009796142578125 | 0.00397491455078125 | -0.003551483154296875 | -0.003574371337890625 | 0.2080078125 | 0.0872802734375 | 0.015838623046875 | 0.165283203125 | -0.00489044189453125 | -0.00196075439453125 | 0.00905609130859375 | 0.09075927734375 | 0.0265350341796875 | 0.12548828125 | 0.457763671875 | 0.0152740478515625 | ||||||
226 | A5465C85-C13E-47D5-98DF-212727654FF1 | 2020-02-22T23:09:29+00:00 | [ "Public" ] |
[] |
jpeg | 710ca46687daa7c41cf926a06fbb8f2202d7fd7275ff00fdd5e8c824bb6c1b87 | 7302953 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A5465C85-C13E-47D5-98DF-212727654FF1 | 0.71044921875 | 0.75 | 0.0 | 0.06417581370768656 | 0.10000000149011612 | -0.00131988525390625 | 0.045562744140625 | 0.048858642578125 | 0.009999999776482582 | -0.1243896484375 | -0.033538818359375 | 0.084716796875 | 0.004680633544921875 | -0.007373809814453125 | -0.0306854248046875 | 0.0333251953125 | 0.0322265625 | 0.05242919921875 | 0.12646484375 | 0.0185699462890625 | 0.00091552734375 | 0.00891876220703125 | 0.0074310302734375 | -0.0020847320556640625 | 0.01313018798828125 | -0.06329345703125 | 0.01189422607421875 | ||||||
222 | A05FA28C-4192-4430-A597-21FC5A10BEEE | 2020-02-22T23:09:17+00:00 | [ "Public" ] |
[] |
jpeg | 6f78d9316fea65c2ec229415af66627a2f106b91e79e3a59cb621ce0ef6a8996 | 6011023 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A05FA28C-4192-4430-A597-21FC5A10BEEE | 0.5107421875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0018243789672851562 | -0.00043487548828125 | 0.0027141571044921875 | 0.009999999776482582 | -0.068359375 | -0.07720947265625 | 0.170166015625 | 0.0079345703125 | -0.029144287109375 | -0.047027587890625 | -0.339111328125 | -0.1475830078125 | 0.125244140625 | -0.048248291015625 | -0.0052490234375 | -0.03662109375 | 0.00464630126953125 | 0.0173797607421875 | -0.0086822509765625 | -0.49267578125 | 0.0789794921875 | -0.03973388671875 | ||||||
176 | FC80510B-1BFF-4750-9C67-DEB2E8605F0A | 2020-02-22T23:06:38+00:00 | [ "Public" ] |
[] |
jpeg | 58ae5c3c9e69215d3da0e32a4beb6cf8e1c9a76a98d2b522dee8cff9481a17b5 | 4706974 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FC80510B-1BFF-4750-9C67-DEB2E8605F0A | 0.6640625 | 0.75 | 0.0 | 0.06109934817743665 | 0.10000000149011612 | -0.0016937255859375 | 0.007720947265625 | 0.0015430450439453125 | 0.009999999776482582 | 0.28173828125 | -0.06982421875 | 0.02960205078125 | 0.01483917236328125 | -0.0411376953125 | -0.01397705078125 | -0.0816650390625 | -0.1513671875 | 0.0300445556640625 | 0.03460693359375 | 0.00135040283203125 | -0.0078125 | 0.00392913818359375 | 0.058441162109375 | 0.0114898681640625 | -0.08734130859375 | 0.57080078125 | 0.10546875 | ||||||
251 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 2020-02-22T23:06:07+00:00 | [ "Public" ] |
[] |
jpeg | 79d06475debc6729f906db1c693cea812ccfbf486e0c78b63e6495cd05e9aee2 | 6788509 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D | 0.73193359375 | 0.75 | 0.0 | 0.06262569391090451 | 0.10000000149011612 | -0.006511688232421875 | 0.0002899169921875 | 0.00974273681640625 | 0.009999999776482582 | -0.2392578125 | -0.0738525390625 | -0.01568603515625 | 0.025909423828125 | -0.05126953125 | -0.1153564453125 | -0.42578125 | -0.3837890625 | 0.26318359375 | -0.060211181640625 | 0.0015583038330078125 | -0.026519775390625 | 0.011199951171875 | 0.0028228759765625 | -0.053009033203125 | -0.11895751953125 | -0.261474609375 | -0.023162841796875 | ||||||
411 | 1DD0EDC6-1E06-4801-A630-4231CA2F7264 | 2020-02-22T23:06:05+00:00 | [ "Public" ] |
[] |
jpeg | cd593541060230f92db29d633f56a083b417bf57597d53cb7b742d257616fb7a | 6670170 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1DD0EDC6-1E06-4801-A630-4231CA2F7264 | 0.71337890625 | 0.75 | 0.0 | 0.06262978024155129 | 0.10041362792253494 | -0.00075531005859375 | 0.1123046875 | 0.004055023193359375 | 0.009999999776482582 | 0.54248046875 | -0.023193359375 | 0.254638671875 | 0.007785797119140625 | -0.00555419921875 | 0.0187225341796875 | 0.2294921875 | 0.33154296875 | 0.02606201171875 | 0.176025390625 | 0.2381591796875 | 0.0111236572265625 | 0.002140045166015625 | 0.53125 | 0.76513671875 | 0.7060546875 | 0.7119140625 | 0.08050537109375 | ||||||
378 | 2671C060-6A75-4201-87B4-D3CA56B95433 | 2020-02-22T23:05:23+00:00 | [ "Public" ] |
[] |
jpeg | bacce858078574660f0eb8f7838b6bb57701b4ccaa5c9d66ec90851ac59b41fa | 6495626 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2671C060-6A75-4201-87B4-D3CA56B95433 | 0.6650390625 | 0.75 | 0.0 | 0.06111606386781649 | 0.10000000149011612 | -0.0010166168212890625 | 0.0106048583984375 | 0.00524139404296875 | 0.009999999776482582 | -0.09130859375 | -0.04949951171875 | 0.139404296875 | 0.005664825439453125 | -0.0217437744140625 | -0.08648681640625 | -0.18896484375 | -0.1002197265625 | 0.277099609375 | -0.004638671875 | 0.004932403564453125 | -0.017608642578125 | 0.0118255615234375 | 0.0153656005859375 | -0.001708984375 | -0.0948486328125 | 0.03277587890625 | -0.00916290283203125 | ||||||
204 | 870ADED8-302A-4D9F-9A99-C0AB7E132703 | 2020-02-22T22:49:08+00:00 | [ "Public" ] |
[] |
jpeg | 65ce0a3532954a8ae4bb4a89a7db165e25e79ddec45202df906e5167e997dfd6 | 6170081 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 870ADED8-302A-4D9F-9A99-C0AB7E132703 | 0.66845703125 | 0.75 | 0.0 | 0.061118664177319475 | 0.10000000149011612 | -0.0017337799072265625 | 0.01067352294921875 | 0.007488250732421875 | 0.009999999776482582 | -0.50439453125 | -0.085693359375 | -0.055084228515625 | 0.01242828369140625 | -0.011871337890625 | -0.07513427734375 | -0.25390625 | -0.2568359375 | 0.08868408203125 | 0.145263671875 | 0.0030231475830078125 | -0.025115966796875 | 0.020965576171875 | 0.01467132568359375 | -0.0213775634765625 | -0.0164031982421875 | 0.12408447265625 | 0.006683349609375 | ||||||
63 | 68C635B0-7852-48E4-B3A6-72A86E9D9927 | 2020-02-22T22:48:07+00:00 | [ "Public" ] |
[] |
jpeg | 1d4fd094ba9b844bdc06d286de3ae07c0fba3af08d8978b1e7cdcdf90c8eafa2 | 6136682 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68C635B0-7852-48E4-B3A6-72A86E9D9927 | 0.62109375 | 0.75 | 0.0 | 0.061114206568885394 | 0.10000000149011612 | -0.001934051513671875 | 0.002864837646484375 | 0.0015192031860351562 | 0.009999999776482582 | -0.79833984375 | -0.10284423828125 | -0.0792236328125 | 0.0090179443359375 | -0.0165863037109375 | -0.0738525390625 | -0.375 | -0.3759765625 | 0.0259552001953125 | 0.0443115234375 | -0.0015544891357421875 | -0.032318115234375 | 0.00821685791015625 | 0.028106689453125 | -0.032562255859375 | -0.00848388671875 | 0.494873046875 | 0.00072479248046875 |
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;