This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 2018-02-09T17:34:17+00:00 | [ "Public" ] |
[] |
jpeg | e45462e175fd04ec7b1f37d8c3e8ebe7fd783d07a6e2c4895bd67e594d5f2693 | 4663245 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | B1990C93-1159-4EFF-BE2C-72FFFFAA7CFB | 0.76953125 | 0.75 | 0.0 | 0.06261473575621161 | 0.10000000149011612 | -0.0027370452880859375 | 0.0142059326171875 | 0.010986328125 | 0.009999999776482582 | -0.451171875 | -0.072265625 | 0.030364990234375 | 0.016021728515625 | -0.018096923828125 | -0.13037109375 | -0.3876953125 | -0.20703125 | 0.1900634765625 | 0.0311279296875 | 0.00605010986328125 | -0.039947509765625 | 0.0119171142578125 | 0.005199432373046875 | -0.0121917724609375 | -0.03753662109375 | -0.2171630859375 | -0.001007080078125 | ||||||
337 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 2018-02-09T17:31:04+00:00 | [ "Public" ] |
[] |
jpeg | a444857c4ac71ceae6af5192c8acc5ac35934ed589259136df0ed11295dbb085 | 4738644 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 365D28C9-AF11-425E-A648-3C3479A5CDE4 | 0.8291015625 | 0.75 | 0.0 | 0.06263034170820513 | 0.504890501499176 | -0.0005297660827636719 | 0.1136474609375 | 0.005641937255859375 | 0.009999999776482582 | 0.0384521484375 | -0.005428314208984375 | 0.36669921875 | 0.0032482147216796875 | -0.00841522216796875 | 0.00429534912109375 | 0.256591796875 | 0.1605224609375 | 0.056121826171875 | 0.144775390625 | 0.046630859375 | 0.00334930419921875 | 0.006877899169921875 | 0.1749267578125 | 0.0360107421875 | 0.68701171875 | 0.6845703125 | 0.037322998046875 | ||||||
95 | A4CA92F3-A131-498E-8205-62E1BF5A4EF4 | 2018-02-09T17:12:24+00:00 | [ "Public" ] |
[] |
jpeg | 2bb66fd402f278b2d94fe7858cc0433d75c10ae4b7dad602fea6f6d8c3cdb57f | 6153631 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A4CA92F3-A131-498E-8205-62E1BF5A4EF4 | 0.60595703125 | 0.75 | 0.0 | 0.06109619049625542 | 0.10000000149011612 | -0.0016813278198242188 | -0.0042266845703125 | 0.002834320068359375 | 0.019999999552965164 | -0.5615234375 | -0.033599853515625 | 0.300048828125 | 0.001220703125 | -0.0206451416015625 | -0.06109619140625 | -0.2479248046875 | -0.1029052734375 | 0.1707763671875 | -0.0718994140625 | -0.003936767578125 | -0.048583984375 | 0.004070281982421875 | 0.0121917724609375 | -0.003787994384765625 | -0.199462890625 | -0.051025390625 | -0.02569580078125 | ||||||
31 | 620F538F-0190-4AD6-8EAA-9E274EC04BD7 | 2018-02-09T17:09:13+00:00 | [ "Public" ] |
[] |
jpeg | 12f9020c547f61512034092d35272e60e2c076da78016ef8ae7b229e04dbc479 | 5772763 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 620F538F-0190-4AD6-8EAA-9E274EC04BD7 | 0.73876953125 | 0.75 | 0.0 | 0.06261715042682095 | 0.10000000149011612 | -0.0023059844970703125 | 0.0190277099609375 | 0.006072998046875 | 0.009999999776482582 | -0.93701171875 | -0.0162200927734375 | 0.12213134765625 | 0.0006799697875976562 | -0.004055023193359375 | -0.00333404541015625 | 0.11285400390625 | 0.0120849609375 | 0.0164031982421875 | 0.052642822265625 | -0.0272674560546875 | -0.003326416015625 | 0.00359344482421875 | 0.08477783203125 | 0.0305023193359375 | 0.2288818359375 | 0.40283203125 | 0.0032062530517578125 | ||||||
338 | 9C0E4F98-A2A8-45F8-8078-792720435621 | 2018-02-09T17:09:09+00:00 | [ "Public" ] |
[] |
jpeg | a4613c06f65f7d13e8c36a1c59025b23caf787d4775a44945e6ae2f5e7fd3929 | 5496634 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9C0E4F98-A2A8-45F8-8078-792720435621 | 0.74267578125 | 0.75 | 0.0 | 0.06261882208685839 | 0.10000000149011612 | -0.001964569091796875 | 0.00035858154296875 | 0.0014209747314453125 | 0.009999999776482582 | -0.379638671875 | -0.055511474609375 | 0.37548828125 | 0.001094818115234375 | -0.01751708984375 | -0.0670166015625 | -0.27587890625 | -0.0677490234375 | 0.0838623046875 | -0.1505126953125 | -0.00411224365234375 | -0.0555419921875 | 0.0017614364624023438 | 0.040679931640625 | 0.0148162841796875 | -0.3125 | 0.1396484375 | -0.047760009765625 | ||||||
325 | 51BEC73B-C230-4B0F-8174-7EFD498DBC9B | 2018-02-09T17:09:05+00:00 | [ "Public" ] |
[] |
jpeg | 9decc7b3b382c0f79961f2d54c6928822549d21c10d503811ea31ce39ce28e45 | 4940822 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 51BEC73B-C230-4B0F-8174-7EFD498DBC9B | 0.8017578125 | 0.75 | 0.0 | 0.0626148303956476 | 0.10000000149011612 | -0.0026836395263671875 | 0.02777099609375 | 0.007205963134765625 | 0.009999999776482582 | -0.9072265625 | -0.01861572265625 | 0.1287841796875 | 0.001956939697265625 | -0.00530242919921875 | -0.005096435546875 | 0.09722900390625 | 0.00592041015625 | 0.042388916015625 | 0.06536865234375 | -0.02935791015625 | -0.0037250518798828125 | 0.00591278076171875 | 0.06927490234375 | 0.0316162109375 | 0.158935546875 | 0.318115234375 | 0.0050048828125 | ||||||
239 | 11D38304-FE06-43AD-B3F0-18FCB7697365 | 2018-02-09T17:08:15+00:00 | [ "Public" ] |
[] |
jpeg | 75acbbcbf1e97c8a33742aff62ac0255ed9eb67de35bcae0d51d9176a4f6ffe7 | 4604119 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11D38304-FE06-43AD-B3F0-18FCB7697365 | 0.7958984375 | 0.75 | 0.0 | 0.06264114652881185 | 0.10000000149011612 | -0.0010042190551757812 | 0.0269622802734375 | 0.001483917236328125 | 0.009999999776482582 | -0.148681640625 | -0.04345703125 | 0.1900634765625 | 0.005405426025390625 | -0.00974273681640625 | 0.0116119384765625 | 0.0089111328125 | 0.07745361328125 | 0.054901123046875 | 0.1292724609375 | 0.01070404052734375 | -0.00806427001953125 | 0.0035381317138671875 | 0.342041015625 | 0.37939453125 | 0.143798828125 | 0.662109375 | 0.0079345703125 | ||||||
455 | 5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E | 2018-02-09T17:08:14+00:00 | [ "Public" ] |
[] |
jpeg | e740c4271b7e85d680e53c1d4ea48662b8636d0586027b866de11f5532eb4250 | 4467400 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5EAEC101-FEF6-40C8-A727-EB2C7B2EFD1E | 0.82470703125 | 0.75 | 0.0 | 0.06263840062017659 | 0.10000000149011612 | -0.00391387939453125 | 0.0081329345703125 | 0.006439208984375 | 0.009999999776482582 | -0.93212890625 | -0.037689208984375 | 0.02410888671875 | 0.0015363693237304688 | -0.007549285888671875 | -0.0147247314453125 | -0.1170654296875 | -0.140625 | 0.018341064453125 | 0.036651611328125 | -0.01104736328125 | -0.00743865966796875 | 0.00391387939453125 | 0.0247039794921875 | -0.02410888671875 | 0.0745849609375 | 0.177001953125 | 0.0007457733154296875 | ||||||
326 | 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 2018-02-09T17:07:59+00:00 | [ "Public" ] |
[] |
jpeg | 9e06275e7fa0e4f84d6a1e7a8ae97c27a59eebc6f3769f5b0129e492bf9c40c1 | 5328743 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5E551A21-53F1-450B-BCEE-7A2C7CCB3C11 | 0.6591796875 | 0.75 | 0.0 | 0.06111104934270145 | 0.10000000149011612 | -0.0221099853515625 | -0.0023956298828125 | 0.00266265869140625 | 0.009999999776482582 | -0.417236328125 | -0.0574951171875 | 0.162353515625 | 0.003185272216796875 | -0.055206298828125 | -0.064208984375 | -0.300048828125 | -0.2000732421875 | 0.036712646484375 | -0.1666259765625 | -0.0035400390625 | -0.01611328125 | 0.0010690689086914062 | 0.017303466796875 | -0.206787109375 | -0.138916015625 | 0.03955078125 | -0.0994873046875 | ||||||
173 | 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 | 2017-12-16T11:51:14+00:00 | [ "Public" ] |
[] |
heic | 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 | 2072848 | 51.503303333333335 | -0.1321805 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | London | England | United Kingdom | 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 | 0.5703125 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0008358955383300781 | 0.032989501953125 | 0.00313568115234375 | 0.009999999776482582 | -0.45654296875 | -0.043121337890625 | 0.239501953125 | 0.0038547515869140625 | -0.00919342041015625 | -0.02197265625 | -0.1068115234375 | 0.0599365234375 | 0.09857177734375 | 0.10504150390625 | 0.00670623779296875 | -0.011199951171875 | 0.004467010498046875 | 0.097900390625 | 0.051239013671875 | 0.05975341796875 | 0.29052734375 | -8.392333984375e-05 | |
351 | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 2017-12-03T22:40:16+00:00 | [ "Museums", "Public" ] |
[] |
heic | a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd | 1734045 | 37.333511666666666 | -121.92306333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Jose | CA | United States | 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 | 0.477294921875 | 0.75 | 0.0 | 0.058022878381587165 | 0.10000000149011612 | -0.0005526542663574219 | 0.027008056640625 | 0.0082855224609375 | 0.019999999552965164 | -0.37451171875 | -0.041778564453125 | 0.27587890625 | 0.004364013671875 | -0.006565093994140625 | -0.048553466796875 | -0.1864013671875 | -0.00262451171875 | 0.31640625 | 0.05841064453125 | 0.00191497802734375 | -0.0159454345703125 | 0.0174407958984375 | 0.0215301513671875 | 0.001140594482421875 | -0.11749267578125 | 0.0311279296875 | -0.0047607421875 | |
349 | 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB | 2017-03-31T00:53:36+00:00 | [ "Stolen monasteries", "Public" ] |
[] |
jpeg | a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc | 4502080 | 37.76918 | -122.46453833333334 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB | 0.5263671875 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.006122589111328125 | -0.00547027587890625 | 0.0029125213623046875 | 0.009999999776482582 | -0.5576171875 | -0.057373046875 | 0.273681640625 | 0.001956939697265625 | -0.0379638671875 | -0.159912109375 | -0.435791015625 | -0.146240234375 | 0.11676025390625 | -0.2406005859375 | -0.0036716461181640625 | -0.045989990234375 | 0.0017681121826171875 | 0.00930023193359375 | -0.03497314453125 | -0.2568359375 | -0.277587890625 | -0.07403564453125 | |
475 | 062B182C-CD24-4EC8-8E27-420EECB14688 | 2015-12-18T13:39:58+00:00 | [ "Novelty Automation", "Museums", "Public" ] |
[] |
jpeg | f35f5580cec4289b90eb9ceebec27f017a5b5911a0b087d7e25efbf86a13b2d0 | 2073560 | 51.51998 | -0.11689166666666666 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | London | England | United Kingdom | 062B182C-CD24-4EC8-8E27-420EECB14688 | 0.33544921875 | 0.75 | 0.0 | 0.05801862506693556 | 0.50620436668396 | -0.00033283233642578125 | 0.044891357421875 | 0.0087432861328125 | 0.009999999776482582 | 0.45703125 | -0.047698974609375 | 0.134521484375 | 0.005344390869140625 | -0.004100799560546875 | 0.001739501953125 | 0.175048828125 | 0.1627197265625 | 0.04742431640625 | 0.1656494140625 | 0.015380859375 | 0.02105712890625 | 0.0125274658203125 | 0.043701171875 | 0.010101318359375 | -0.0157470703125 | 0.335693359375 | 0.1339111328125 |
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;