photos_with_apple_metadata (view)

24 rows where "date" is on date 2019-08-21

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZPLEASANTPATTERNSCORE, ZWELLFRAMEDSUBJECTSCORE, 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
136 C7714BF0-9654-4D2D-A5A4-032901EC2419 2019-08-21T16:10:02+00:00 
[
    "Public"
]
 
[]
 jpeg 3ed563ada4d69d6e5646209933fd179a95e4b1d13ac1aab3d671db4fab94dba9 6328113     1 0 0 0 0 0 0 0       C7714BF0-9654-4D2D-A5A4-032901EC2419 0.68212890625 0.75 0.0 0.061103434053086145 0.10000000149011612 -0.0013885498046875 0.02130126953125 0.0026836395263671875 0.019999999552965164 0.0869140625 -0.0867919921875 0.130126953125 0.00646209716796875 -0.0104522705078125 -0.006500244140625 -0.170654296875 0.044677734375 0.031982421875 0.054931640625 0.005218505859375 -0.004608154296875 0.0018463134765625 0.07611083984375 0.11651611328125 -0.04833984375 0.295166015625 0.1043701171875
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
485 379BF280-6D24-43EF-9DB2-0E497D08DD34 2019-08-21T16:08:21+00:00 
[
    "Public"
]
 
[]
 jpeg fa119150fd7f15dee753c4f9c609e7c0b84d349786b1ee52db4ba4b9b5508564 6961977     1 0 0 0 0 0 0 0       379BF280-6D24-43EF-9DB2-0E497D08DD34 0.6865234375 0.75 0.0 0.06110696301205468 0.7058150768280029 -0.0004494190216064453 0.06787109375 0.001964569091796875 0.019999999552965164 0.701171875 -0.028594970703125 0.143798828125 0.00653839111328125 -0.0026721954345703125 0.00968170166015625 0.40576171875 0.373291015625 0.0222015380859375 0.232177734375 0.02508544921875 0.004364013671875 0.004100799560546875 0.71484375 0.86328125 0.313232421875 0.8720703125 0.509765625
430 411AAEA4-5064-4007-B18E-72D0E1111E59 2019-08-21T16:08:21+00:00 
[
    "Public"
]
 
[]
 jpeg d95f7783f031052c8c2794c3054f46b6cfb042d58cec843cff63479ccbab4cc5 7056077     1 0 0 0 0 0 0 0       411AAEA4-5064-4007-B18E-72D0E1111E59 0.66943359375 0.75 0.0 0.061101948486939645 0.10000000149011612 -0.002269744873046875 0.0171966552734375 0.00243377685546875 0.23999999463558197 0.4453125 -0.097900390625 -0.053466796875 0.038604736328125 -0.01142120361328125 0.00177764892578125 0.116455078125 -0.044677734375 0.021087646484375 0.214599609375 0.0069427490234375 -0.000812530517578125 0.00809478759765625 0.183837890625 0.292236328125 0.0467529296875 0.73095703125 0.331787109375
382 3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 2019-08-21T16:06:06+00:00 
[
    "Public"
]
 
[]
 jpeg be83d91388b3a7f6df3475a9d0557e957e9aa49a7fc2690dd8942b52971b4af5 6115387     1 0 0 0 0 0 0 0       3C46B23E-EDE6-4CE9-97F6-FED24AF41F91 0.6962890625 0.75 0.0 0.06110547744590818 0.10000000149011612 -0.0008425712585449219 0.0278778076171875 0.003040313720703125 0.05999999865889549 0.2415771484375 -0.061767578125 0.2044677734375 0.0029125213623046875 -0.008880615234375 0.000732421875 -0.03826904296875 0.07666015625 0.0279083251953125 0.06536865234375 0.00994110107421875 -0.0045166015625 0.001949310302734375 0.09271240234375 0.0833740234375 0.048828125 0.43115234375 0.0914306640625
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
262 2A621F4B-A826-437E-91A4-6A0597D08134 2019-08-21T16:05:33+00:00 
[
    "Public"
]
 
[]
 jpeg 7f2931e3486143bc295f99a386810b08659dbdb8d5650e8ba4d729607902f383 6791599     1 0 0 0 0 0 0 0       2A621F4B-A826-437E-91A4-6A0597D08134 0.6923828125 0.75 0.0 0.06111884981621313 0.10000000149011612 -0.033599853515625 -0.001697540283203125 0.004608154296875 0.07999999821186066 -0.1505126953125 -0.06890869140625 0.0955810546875 0.00524139404296875 -0.0709228515625 -0.060699462890625 -0.274658203125 -0.281005859375 0.031982421875 -0.1253662109375 -0.002590179443359375 -0.0123138427734375 0.0016546249389648438 0.01137542724609375 -0.495849609375 -0.18505859375 0.1790771484375 -0.154052734375
64 8D169BB8-BF13-4FE9-8196-10DA495ABA01 2019-08-21T16:05:31+00:00 
[
    "Public"
]
 
[]
 jpeg 1d8f6e62965eb678ed412a9eb03bf1bcfd25803814540e560b2f0b675b99f3f2 6446517     1 0 0 0 0 0 0 0       8D169BB8-BF13-4FE9-8196-10DA495ABA01 0.69873046875 0.75 0.0 0.061116806878388386 0.10000000149011612 -0.0006289482116699219 0.03472900390625 0.0033111572265625 0.019999999552965164 0.323486328125 -0.04803466796875 0.275390625 0.001979827880859375 -0.01024627685546875 0.006317138671875 0.017578125 0.07647705078125 0.058563232421875 0.0870361328125 0.016082763671875 -0.0051422119140625 0.003063201904296875 0.09185791015625 0.062103271484375 0.1712646484375 0.52392578125 0.09039306640625
437 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 2019-08-21T16:05:25+00:00 
[
    "Public"
]
 
[]
 jpeg dcf001e183e3e0ed9142c734eb751eb0992e7b14651845c9c3df40a491322b6d 7003984     1 0 0 0 0 0 0 0       23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 0.68896484375 0.75 0.0 0.061103805785870734 0.7047201991081238 -0.000583648681640625 0.0305023193359375 0.0018606185913085938 0.03999999910593033 0.79833984375 -0.047943115234375 0.031646728515625 0.0161590576171875 -0.0041351318359375 0.00727081298828125 0.41015625 0.318359375 0.01507568359375 0.22802734375 0.01171112060546875 0.00311279296875 0.006313323974609375 0.5595703125 0.74560546875 0.13330078125 0.8798828125 0.66357421875
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
48 7CB33AD0-0953-4440-93D1-E1E67A227D7B 2019-08-21T15:32:05+00:00 
[
    "Public"
]
 
[]
 jpeg 1821e43e6f6a45b1a9701f777256dec1f11af076631cdfed6a5d312726500ca9 6723417     1 0 0 0 0 0 0 0       7CB33AD0-0953-4440-93D1-E1E67A227D7B 0.7607421875 0.75 0.0 0.06263442348887902 0.7047201991081238 -0.0006566047668457031 0.0491943359375 0.001918792724609375 0.07999999821186066 0.7900390625 -0.037384033203125 0.055145263671875 0.01384735107421875 -0.00391387939453125 0.00716400146484375 0.439453125 0.315673828125 0.0170440673828125 0.256103515625 0.01934814453125 0.0042572021484375 0.00582122802734375 0.5791015625 0.76171875 0.2646484375 0.88427734375 0.677734375
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
379 E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F 2019-08-21T15:27:59+00:00 
[
    "Public"
]
 
[]
 jpeg bd939e829e1f2bc97273efcf9fae6e0a8ac27aca2d43c3f470b8b5c78142674d 8000011     1 0 0 0 0 0 0 0       E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F 0.65771484375 0.75 0.0 0.06110622000148278 0.10000000149011612 -0.6279296875 -0.0198211669921875 0.01238250732421875 0.07999999821186066 -0.82373046875 -0.0999755859375 0.06378173828125 0.003692626953125 -0.11474609375 -0.2054443359375 -0.77197265625 -0.46337890625 0.028656005859375 -0.48583984375 -0.0035343170166015625 -0.0204010009765625 0.0005359649658203125 0.001094818115234375 -0.94091796875 -0.225341796875 -0.68701171875 -0.49853515625
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
128 B2F26E79-7A85-497E-AD2F-D599633EA720 2019-08-21T11:43:53+00:00 
[
    "Public"
]
 
[]
 jpeg 3bd461b7f1c5b8c4de844951f86168d510082ae55c2a23223b7cc5ada0ce29f5 7020346     1 0 0 0 0 0 0 0       B2F26E79-7A85-497E-AD2F-D599633EA720 0.57568359375 0.75 0.0 0.061105291352017234 0.10000000149011612 -0.005889892578125 0.0174102783203125 0.0021572113037109375 0.05999999865889549 -0.1673583984375 -0.08465576171875 0.066162109375 0.01282501220703125 -0.0211181640625 -0.022796630859375 -0.159423828125 -0.1455078125 0.0416259765625 0.03692626953125 0.0023956298828125 -0.00726318359375 0.0027904510498046875 0.0987548828125 0.1475830078125 0.02117919921875 0.413818359375 0.025848388671875
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 233.168ms · About: dogsheep/dogsheep-photos