photos_with_apple_metadata (view)

14 rows where ZINTERACTIONSCORE = "0.009999999776482582" and "date" is on date 2019-08-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, albums (array)

date (date) ✖

  • 2019-08-21 · 14 ✖

ZINTERACTIONSCORE ✖

  • 0.009999999776482582 · 14 ✖
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
367 FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 2019-08-21T16:08:36+00:00 
[
    "Public"
]
 
[]
 jpeg b3b8e4d655d448f18fc3d956a3c3b4e20f271fd3b322677398c463aaab074513 6496552     1 0 0 0 0 0 0 0       FAEAD169-EC68-4B11-9BFB-FB3E5651A5A8 0.74658203125 0.75 0.0 0.06263479476666632 0.10000000149011612 -0.0006413459777832031 0.0292510986328125 0.0032863616943359375 0.009999999776482582 -0.1097412109375 -0.0272674560546875 0.344970703125 0.0013246536254882812 -0.01238250732421875 -0.01556396484375 -0.00274658203125 0.03643798828125 0.0753173828125 0.050537109375 0.0078887939453125 -0.009368896484375 0.0037078857421875 0.081787109375 0.0205841064453125 0.1483154296875 0.41943359375 -0.000244140625
208 54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE 2019-08-21T16:06:05+00:00 
[
    "Public"
]
 
[]
 jpeg 68070b02b60b38af0180db8311ecd10bf80a84ce18379978bf22029e6931f10d 6119986     1 0 0 0 0 0 0 0       54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE 0.6669921875 0.75 0.0 0.06110566308480183 0.70737224817276 -0.0009851455688476562 0.04791259765625 0.003147125244140625 0.009999999776482582 0.515625 -0.045867919921875 0.12353515625 0.01146697998046875 -0.012237548828125 0.013671875 0.1416015625 0.17041015625 0.0258636474609375 0.18505859375 0.03948974609375 0.000732421875 0.0031719207763671875 0.2000732421875 0.236328125 0.301513671875 0.669921875 0.287841796875
388 B9265412-3353-4812-8BBA-E6FF72DC5718 2019-08-21T16:05:33+00:00 
[
    "Public"
]
 
[]
 jpeg c2d88a3854c6bb06ebdedec26082e81bb4b47eaf629ae3c72a9a94550e715336 6764565     1 0 0 0 0 0 0 0       B9265412-3353-4812-8BBA-E6FF72DC5718 0.720703125 0.75 0.0 0.06263200881826969 0.10000000149011612 -0.0012845993041992188 0.0119476318359375 0.00690460205078125 0.009999999776482582 0.1044921875 -0.053009033203125 0.203857421875 0.0021076202392578125 -0.0117340087890625 -0.011871337890625 -0.11676025390625 0.00732421875 0.100341796875 0.016571044921875 0.003482818603515625 -0.009002685546875 0.005039215087890625 0.037811279296875 0.025299072265625 -0.1329345703125 0.2939453125 0.00823974609375
334 A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3 2019-08-21T16:05:23+00:00 
[
    "Public"
]
 
[]
 jpeg a284e8b493923f1e58d3f442ec2d9e436c7ccdda77208fa93b2442dab8307190 6854024     1 0 0 0 0 0 0 0       A5CCE865-901A-4FF0-A0DA-5DECE6E7C3A3 0.6572265625 0.75 0.0 0.061107891661520225 0.10000000149011612 -0.0012350082397460938 0.012664794921875 0.0008935928344726562 0.009999999776482582 -0.0721435546875 -0.10467529296875 0.15185546875 0.004299163818359375 -0.0193023681640625 -0.0438232421875 -0.2216796875 -0.05712890625 0.056854248046875 -0.02685546875 0.00257110595703125 -0.0220184326171875 0.0029010772705078125 0.131591796875 0.0865478515625 -0.09033203125 0.5576171875 0.014892578125
368 071DED2E-2D2A-4519-A47A-FC37916025F1 2019-08-21T16:03:37+00:00 
[
    "Public"
]
 
[]
 jpeg b46e8e49eed203530d061274284253c2c95b1d7c6ea3a9aa7cac6d85f1afa813 5829855     1 0 0 0 0 0 0 0       071DED2E-2D2A-4519-A47A-FC37916025F1 0.68115234375 0.75 0.0 0.06110547744590818 0.7048904895782471 -0.0009288787841796875 0.043670654296875 0.002208709716796875 0.009999999776482582 0.681640625 -0.04296875 0.08575439453125 0.01348114013671875 -0.006565093994140625 0.0111083984375 0.27099609375 0.231689453125 0.03326416015625 0.2171630859375 0.020111083984375 0.0029048919677734375 0.004848480224609375 0.4287109375 0.68408203125 0.1844482421875 0.7802734375 0.5263671875
453 9A5B4E0C-DBD8-49C4-878A-F692E92CABE3 2019-08-21T16:01:55+00:00 
[
    "Public"
]
 
[]
 jpeg e4a475130d9d185c3797abb121814401d600fec9991a2497eec85bec5f814bba 6755458     1 0 0 0 0 0 0 0       9A5B4E0C-DBD8-49C4-878A-F692E92CABE3 0.796875 0.75 0.0 0.06263741373105813 0.10000000149011612 -0.0261077880859375 0.004749298095703125 0.006744384765625 0.009999999776482582 -0.324462890625 -0.1190185546875 -0.1165771484375 0.037322998046875 -0.0457763671875 -0.0516357421875 -0.3974609375 -0.4609375 0.0274810791015625 0.00830078125 0.00215911865234375 -0.00732421875 0.004608154296875 0.011962890625 -0.451171875 -0.018585205078125 0.126708984375 0.03955078125
79 E4CFFA69-E229-42A9-B46B-83932303F2D4 2019-08-21T15:56:23+00:00 
[
    "Public"
]
 
[]
 jpeg 22b4fde7bc2ede179077d2612af2fa32bfa3379df816187998eb1a1267321277 6775857     1 0 0 0 0 0 0 0       E4CFFA69-E229-42A9-B46B-83932303F2D4 0.697265625 0.75 0.0 0.061099533816330306 0.7051094770431519 -0.0007467269897460938 0.045440673828125 0.0027141571044921875 0.009999999776482582 0.68212890625 -0.053985595703125 0.055694580078125 0.0125274658203125 -0.00254058837890625 0.00714111328125 0.3740234375 0.31005859375 0.02484130859375 0.2427978515625 0.014862060546875 0.0030269622802734375 0.006641387939453125 0.51025390625 0.779296875 0.11602783203125 0.8037109375 0.51513671875
12 538AC784-D7C1-4C11-8957-CFBAE86052DF 2019-08-21T15:55:33+00:00 
[
    "Public"
]
 
[]
 jpeg 05fdce0c4c029df59c64ec887dbb4bdd60cdf9189e136f6c9b869d3b5d390d27 6259001     1 0 0 0 0 0 0 0       538AC784-D7C1-4C11-8957-CFBAE86052DF 0.80224609375 0.75 0.0 0.06263517423440482 0.5054258108139038 -0.001178741455078125 0.036895751953125 0.0028896331787109375 0.009999999776482582 0.6728515625 -0.05645751953125 0.0186767578125 0.023651123046875 -0.007518768310546875 0.0084991455078125 0.3154296875 0.2030029296875 0.027435302734375 0.27783203125 0.0184173583984375 0.0030612945556640625 0.00763702392578125 0.3037109375 0.50439453125 0.177490234375 0.78564453125 0.60595703125
391 E8D76832-D18D-461D-B6D4-33E7A1299297 2019-08-21T15:45:39+00:00 
[
    "Public"
]
 
[]
 jpeg c4ff3ff12ade7d1f5e3aa4612e9dcd435f3fe6ef0901f3af0b08e0e76208cb53 7344560     1 0 0 0 0 0 0 0       E8D76832-D18D-461D-B6D4-33E7A1299297 0.6953125 0.75 0.0 0.06110269104251425 0.5065693259239197 -0.0010900497436523438 0.037689208984375 0.0022525787353515625 0.009999999776482582 0.58837890625 -0.038543701171875 0.0579833984375 0.011199951171875 -0.0057525634765625 0.005428314208984375 0.322021484375 0.197021484375 0.01238250732421875 0.1907958984375 0.01300811767578125 0.001773834228515625 0.004215240478515625 0.444580078125 0.5966796875 0.2310791015625 0.8291015625 0.384521484375
28 14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D 2019-08-21T15:33:02+00:00 
[
    "Public"
]
 
[]
 jpeg 10fbcfa8d9bde9eea951ffd25147dfcca838591911ffa1c2b4b5ada2cc73bf7c 6692650     1 0 0 0 0 0 0 0       14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D 0.6298828125 0.75 0.0 0.06110566308480183 0.7047688364982605 -0.00042057037353515625 0.060150146484375 0.00217437744140625 0.009999999776482582 0.78271484375 -0.0309600830078125 0.0841064453125 0.010009765625 -0.0027256011962890625 0.00811004638671875 0.48193359375 0.420166015625 0.017242431640625 0.26513671875 0.02313232421875 0.00504302978515625 0.00530242919921875 0.67822265625 0.82177734375 0.273193359375 0.88427734375 0.67822265625
46 929CB2CD-A08E-43B2-AD9F-4B0FC40D9F34 2019-08-21T15:32:45+00:00 
[
    "Public"
]
 
[]
 jpeg 1719c4a23f75227ab440e95d9e2cd54d6767a7883bbc850f174c5f1422839b31 7860631     1 0 0 0 0 0 0 0       929CB2CD-A08E-43B2-AD9F-4B0FC40D9F34 0.7001953125 0.75 0.0 0.061106777373161024 0.10000000149011612 -0.016021728515625 0.0045623779296875 0.01073455810546875 0.009999999776482582 -0.64111328125 -0.1171875 -0.0924072265625 0.0236968994140625 -0.0299224853515625 -0.05535888671875 -0.56640625 -0.4560546875 0.0191650390625 -0.026458740234375 -0.001277923583984375 -0.010711669921875 0.0021915435791015625 0.003185272216796875 -0.11077880859375 -0.0277099609375 -0.265380859375 -0.0023651123046875
29 31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8 2019-08-21T15:29:14+00:00 
[
    "Public"
]
 
[]
 jpeg 1144f98ed47578c71f87da25e6e3876a734109666c4086e1de53ddfd03e620d6 7538509     1 0 0 0 0 0 0 0       31E610B0-66E8-4C5E-9B9C-CE0EAAFDC3D8 0.77197265625 0.75 0.0 0.06263405221109172 0.7047201991081238 -0.00046563148498535156 0.06231689453125 0.002452850341796875 0.009999999776482582 0.7431640625 -0.034820556640625 0.09368896484375 0.0095977783203125 -0.00263214111328125 0.00769805908203125 0.441162109375 0.376220703125 0.0200653076171875 0.240966796875 0.021728515625 0.004425048828125 0.00547027587890625 0.59375 0.76513671875 0.2301025390625 0.85009765625 0.57958984375
97 109A0EAD-3A58-4EFA-B2B4-AB59BA66D0F6 2019-08-21T11:45:12+00:00 
[
    "Public"
]
 
[]
 jpeg 2cefc7b20e89728c1ce1c209d80f42276d2437e0bc526a9eb6c1b53f688234b3 8002733     1 0 0 0 0 0 0 0       109A0EAD-3A58-4EFA-B2B4-AB59BA66D0F6 0.80224609375 0.75 0.0 0.06263256118497776 0.5053771138191223 -0.0008492469787597656 0.04388427734375 0.0023975372314453125 0.009999999776482582 0.564453125 -0.050048828125 0.0792236328125 0.012237548828125 -0.00498199462890625 0.00885009765625 0.26220703125 0.2296142578125 0.03155517578125 0.213134765625 0.01551055908203125 0.0021228790283203125 0.00511932373046875 0.380859375 0.61328125 0.13916015625 0.7412109375 0.40380859375
124 090FA0A0-01B9-4375-B319-C0712E6E2AAD 2019-08-21T11:41:32+00:00 
[
    "Public"
]
 
[]
 jpeg 3adc4ce462f12a3e7890ad51a7e150a675f776d8b63dd5dde154bfff98b4b1d7 8719520     1 0 0 0 0 0 0 0       090FA0A0-01B9-4375-B319-C0712E6E2AAD 0.91943359375 0.75 0.0 0.0626326999591507 0.10000000149011612 -0.004100799560546875 0.026763916015625 0.0028781890869140625 0.009999999776482582 0.2200927734375 -0.08648681640625 0.0179443359375 0.015899658203125 -0.009521484375 -0.00226593017578125 0.0335693359375 -0.0333251953125 0.01751708984375 0.14501953125 0.007572174072265625 -0.001499176025390625 0.0034027099609375 0.145263671875 0.27490234375 0.10626220703125 0.603515625 0.276123046875

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