photos_with_apple_metadata (view)

16 rows where ZCURATIONSCORE = "0.75" and "date" is on date 2018-02-09

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, favorite, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, albums (array)

date (date) ✖

  • 2018-02-09 · 16 ✖

ZCURATIONSCORE ✖

  • 0.75 · 16 ✖
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
381 7A352102-8F91-43F5-9DCF-683E8C791770 2018-02-09T17:41:49+00:00 
[
    "Public"
]
 
[]
 jpeg be4aca64fad3eb60b3f84489e945095e76f3765ea7cf293b408edbae0746a252 4322453     1 0 0 0 0 0 0 0       7A352102-8F91-43F5-9DCF-683E8C791770 0.828125 0.75 0.0 0.06263840062017659 0.10000000149011612 -0.0007295608520507812 0.02154541015625 0.0028781890869140625 0.009999999776482582 0.0172119140625 -0.034759521484375 0.355712890625 0.002216339111328125 -0.00714874267578125 -0.002471923828125 -0.01806640625 0.0067138671875 0.12158203125 0.011474609375 0.014862060546875 -0.18603515625 0.007785797119140625 0.0704345703125 0.03546142578125 -0.0577392578125 0.45947265625 -0.0081939697265625
408 32EAACCC-CDA4-4922-96FE-417F7F77F79E 2018-02-09T17:41:47+00:00 
[
    "Public"
]
 
[]
 jpeg cbfe463f1a67e37a1d36c5db44f0159ef6f86a0d64a987b129b63b52e555f1af 4486603     0 0 0 0 0 0 0 0       32EAACCC-CDA4-4922-96FE-417F7F77F79E 0.8564453125 0.75 0.0 0.06263820133136429 0.10000000149011612 -0.0009326934814453125 0.042755126953125 0.00453948974609375 0.009999999776482582 -0.57568359375 -0.0283355712890625 0.2100830078125 0.0027790069580078125 -0.0059356689453125 -0.0073089599609375 0.05865478515625 0.0704345703125 0.0247955322265625 0.11260986328125 0.0017547607421875 -0.00522613525390625 0.003692626953125 0.11199951171875 0.034393310546875 0.1650390625 0.42724609375 0.00579833984375
14 521AC274-EDCB-4A51-BB46-96FE8A4D839F 2018-02-09T17:41:47+00:00 
[
    "Public"
]
 
[]
 jpeg 079eeabe823ae591e3038e2ba1b57cc3be2869376723af323806b6f67043f891 4267520     0 0 0 0 0 0 0 0       521AC274-EDCB-4A51-BB46-96FE8A4D839F 0.826171875 0.75 0.0 0.06263778182386442 0.10000000149011612 -0.00157928466796875 0.033843994140625 0.00679779052734375 0.009999999776482582 -0.9248046875 -0.0141143798828125 0.13134765625 0.001926422119140625 -0.0038394927978515625 -0.0030193328857421875 0.18359375 0.05108642578125 0.059661865234375 0.09136962890625 -0.02587890625 -0.003108978271484375 0.00974273681640625 0.10504150390625 0.0477294921875 0.2042236328125 0.431396484375 0.003818511962890625
214 E2A17559-5121-45E2-9FAB-6CF7C38F3F50 2018-02-09T17:37:37+00:00 
[
    "Public"
]
 
[]
 jpeg 69e98fd0fb8cb4a36d9feb83957fb0415c54a63bcef3c27720300496bfb8267c 4877381     1 0 0 0 0 0 0 0       E2A17559-5121-45E2-9FAB-6CF7C38F3F50 0.76171875 0.75 0.0 0.06261473575621161 0.10000000149011612 -0.000720977783203125 -0.004779815673828125 0.0038242340087890625 0.009999999776482582 0.07135009765625 -0.047515869140625 0.39404296875 0.0005726814270019531 -0.0162811279296875 -0.06329345703125 -0.25390625 -0.0662841796875 0.2359619140625 -0.07958984375 -0.0005092620849609375 -0.0269012451171875 0.0033893585205078125 0.005138397216796875 -0.0037364959716796875 -0.5478515625 -0.17724609375 -0.1026611328125
232 E2378A42-70B5-42A2-B8D8-CFE99DBCE627 2018-02-09T17:37:26+00:00 
[
    "Public"
]
 
[]
 jpeg 723a6e638a563a37ff666683b28f4190a29777475aca5428660fa22d5cff5a07 5948701     1 0 0 0 0 0 0 0       E2378A42-70B5-42A2-B8D8-CFE99DBCE627 0.66845703125 0.75 0.0 0.06111104934270145 0.10000000149011612 -0.0024051666259765625 0.013336181640625 0.005619049072265625 0.009999999776482582 -0.91796875 -0.020965576171875 0.1314697265625 0.0007791519165039062 -0.00600433349609375 -0.007549285888671875 0.01007080078125 -0.02764892578125 0.0210418701171875 0.03363037109375 -0.0223388671875 -0.005645751953125 0.00313568115234375 0.044769287109375 0.005462646484375 0.16259765625 0.283935546875 0.00146484375
336 B70635AD-65F3-462C-993A-C13F0CA868D3 2018-02-09T17:35:32+00:00 
[
    "Public"
]
 
[]
 jpeg a3dbd04c291b7218a634d6b0c960a80cb44a3fab625fbd7129547e61ee61dd72 4293844     1 0 0 0 0 0 0 0       B70635AD-65F3-462C-993A-C13F0CA868D3 0.7548828125 0.75 0.0 0.06261863644796474 0.10000000149011612 -0.006587982177734375 0.00927734375 0.02386474609375 0.009999999776482582 -0.357421875 -0.03594970703125 -0.0675048828125 0.0537109375 -0.06671142578125 -0.08197021484375 -0.20751953125 -0.3515625 0.27001953125 0.02850341796875 0.005828857421875 -0.01332855224609375 0.023956298828125 0.0029811859130859375 -0.0265045166015625 -0.02191162109375 -0.1678466796875 -0.0030670166015625
306 BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 2018-02-09T17:34:41+00:00 
[
    "Public"
]
 
[]
 jpeg 945618e1454a17db6e8f66f5a72266b3e47c4c14f99a38c9792e9b10133e55bd 5522490     1 0 0 0 0 0 0 0       BE3BA24B-AB7E-4F85-A6E9-AC1F229E634A 0.65625 0.75 0.0 0.06109191898171228 0.10000000149011612 -0.0017137527465820312 0.021484375 0.0060272216796875 0.009999999776482582 -0.91748046875 -0.021331787109375 0.2049560546875 0.0011119842529296875 -0.0050201416015625 -0.0079498291015625 -0.02685546875 0.02593994140625 0.0287628173828125 0.036224365234375 -0.029022216796875 -0.0055999755859375 0.0026836395263671875 0.050811767578125 0.01702880859375 0.08807373046875 0.1494140625 0.0010223388671875
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;
Powered by Datasette · Query took 244.17ms · About: dogsheep/dogsheep-photos