photos_with_apple_metadata (view)

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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 282.873ms · About: dogsheep/dogsheep-photos