photos_with_apple_metadata (view)

39 rows where "date" is on date 2018-02-09

✎ View and edit SQL

This data as json, CSV (advanced)

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

date (date) ✖

  • 2018-02-09 · 39 ✖
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
272 D034B554-9E55-4646-AE6D-D80CB5027AC5 2018-02-09T17:37:43+00:00 
[
    "Public"
]
 
[]
 jpeg 8377d9d938dd5f9a4b177099a3d97dcf7c44d14e221ca20cb2104b7f5651ea10 4534870     0 0 0 0 0 0 0 0       D034B554-9E55-4646-AE6D-D80CB5027AC5 0.697265625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.00669097900390625 0.0089111328125 0.004199981689453125 0.009999999776482582 -0.60546875 -0.0970458984375 0.046295166015625 0.0242767333984375 -0.0191192626953125 -0.0679931640625 -0.4130859375 -0.2392578125 0.148193359375 -0.00360107421875 0.00032806396484375 -0.127197265625 0.007259368896484375 0.0204925537109375 0.0147705078125 -0.0806884765625 -0.080322265625 -0.00780487060546875
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
66 8E27300C-9123-40E7-B4CF-E796FC0C5B35 2018-02-09T17:37:30+00:00 
[
    "Public"
]
 
[]
 jpeg 1e75e97d2e8a1ffe1ab3980856b20b05b648af8fb1c0ab19aa3a097597f39ae3 5924049     0 0 0 0 0 0 0 0       8E27300C-9123-40E7-B4CF-E796FC0C5B35 0.70849609375 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.003780364990234375 0.0531005859375 0.00319671630859375 0.009999999776482582 -0.8896484375 -0.0182647705078125 0.3046875 0.026702880859375 -0.023468017578125 -0.014251708984375 -0.03143310546875 -0.0396728515625 0.094482421875 0.0289306640625 -0.1292724609375 -0.00994110107421875 0.0037364959716796875 0.062103271484375 0.02972412109375 0.12115478515625 0.18701171875 -0.0015716552734375
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
384 FF1D2E63-A1A2-4C67-A49B-090C603F8346 2018-02-09T17:35:20+00:00 
[
    "Public"
]
 
[]
 jpeg bf76ef31bcc06d65e439b74f09c7c7bfa3bfeaa4d463972520c658db7c59b061 4526609     0 0 0 0 0 0 0 0       FF1D2E63-A1A2-4C67-A49B-090C603F8346 0.7490234375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0016937255859375 0.0145416259765625 0.006744384765625 0.009999999776482582 -0.91455078125 -0.021575927734375 0.235107421875 0.0006165504455566406 -0.004886627197265625 -0.01410675048828125 -0.0574951171875 -0.023193359375 0.051849365234375 0.025177001953125 -0.02044677734375 -0.007793426513671875 0.00443267822265625 0.0311431884765625 -0.0015411376953125 0.08612060546875 0.1700439453125 -0.0013217926025390625
435 7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 2018-02-09T17:34:45+00:00 
[
    "Public"
]
 
[]
 jpeg dccff810ab672e497ad4c6cf850a9093a2b7caec871f3f8bd212af56bc935f40 6095738     0 0 0 0 0 0 0 0       7A0D6ABC-4F33-4FEA-9660-2A8594C2B5F8 0.76806640625 0.5 0.0 0.043546182053689736 0.10000000149011612 -0.0016613006591796875 0.02593994140625 0.00881195068359375 0.009999999776482582 -0.9111328125 -0.0190582275390625 0.1021728515625 0.002452850341796875 -0.00469970703125 -0.00550079345703125 0.1080322265625 0.03466796875 0.08251953125 0.08984375 -0.01934814453125 -0.00405120849609375 0.0110321044921875 0.06744384765625 0.03228759765625 0.1116943359375 0.28125 0.0033588409423828125
20 89820B37-8A27-49A7-BDDF-B64253FD23FA 2018-02-09T17:34:42+00:00 
[
    "Public"
]
 
[]
 jpeg 0be986eb6ca9a9770d1c8fceecaa6d30f1c7b7514ac226b22ca2acff432e096b 5741137     0 0 0 0 0 0 0 0       89820B37-8A27-49A7-BDDF-B64253FD23FA 0.74267578125 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0011692047119140625 0.02850341796875 0.0276336669921875 0.009999999776482582 -0.180419921875 -0.037261962890625 0.343017578125 0.0012445449829101562 -0.00714874267578125 -0.06915283203125 -0.2344970703125 -0.00421142578125 0.1766357421875 -0.0137939453125 0.005542755126953125 -0.00787353515625 0.005039215087890625 0.004962921142578125 -0.0036334991455078125 -0.069580078125 -0.296630859375 -0.0173797607421875
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
112 558FFB4E-06B0-4782-962A-FA28C8F0B415 2018-02-09T17:34:26+00:00 
[
    "Public"
]
 
[]
 jpeg 370c4f936c1cb84f1bbeea091005103b5fa94d264733dc20d24371b1ea9fb27a 6150089     0 0 0 0 0 0 0 0       558FFB4E-06B0-4782-962A-FA28C8F0B415 0.576171875 0.5 0.0 0.04201630736125334 0.1015571802854538 -0.0010004043579101562 0.081298828125 0.002208709716796875 0.009999999776482582 0.1552734375 -0.026702880859375 0.27734375 0.011962890625 -0.00885009765625 0.02862548828125 0.1475830078125 0.19580078125 0.09979248046875 0.2252197265625 0.06927490234375 -0.00176239013671875 0.00482940673828125 0.493408203125 0.671875 0.397216796875 0.70751953125 0.040496826171875
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
390 C721AC7F-4D2E-447B-A789-B605FA9B9D99 2018-02-09T17:33:32+00:00 
[
    "Public"
]
 
[]
 jpeg c3f1191b7ce8e4f4643e3ec3efb3040e0668e42bb966e6b90c5b4e7b36e8ecfd 5895146     0 0 0 0 0 0 0 0       C721AC7F-4D2E-447B-A789-B605FA9B9D99 0.734375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.002704620361328125 0.00797271728515625 0.0014047622680664062 0.009999999776482582 -0.296875 -0.040252685546875 0.11865234375 0.00586700439453125 -0.060211181640625 -0.05859375 -0.097412109375 -0.121826171875 0.0604248046875 -0.057373046875 0.002368927001953125 -0.017059326171875 0.0032100677490234375 0.06634521484375 0.012908935546875 0.12347412109375 0.464111328125 -0.00754547119140625
229 A1095B7D-7675-4585-BEAE-C9A072A793C7 2018-02-09T17:31:07+00:00 
[
    "Public"
]
 
[]
 jpeg 71e3566c31cd0e96cb2c336357d709242c5c1f87d8ef11934c0b49a558ca4604 4511956     0 0 0 0 0 0 0 0       A1095B7D-7675-4585-BEAE-C9A072A793C7 0.7509765625 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0017547607421875 0.03582763671875 0.00714874267578125 0.009999999776482582 -0.87255859375 -0.034820556640625 0.05584716796875 0.004116058349609375 -0.0030517578125 -0.004730224609375 0.11669921875 0.052490234375 0.0301055908203125 0.1285400390625 -0.0123748779296875 -0.0027141571044921875 0.0074615478515625 0.097412109375 0.06146240234375 0.08624267578125 0.35400390625 0.010589599609375
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
92 C04ECCFD-2679-4E64-823F-290C47A16396 2018-02-09T17:31:04+00:00 
[
    "Public"
]
 
[]
 jpeg 28615e09f1a3d49a3392d0a8c61397d75d9dd1a6224389328565692def29b678 4471977     0 0 0 0 0 0 0 0       C04ECCFD-2679-4E64-823F-290C47A16396 0.7802734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0010280609130859375 0.040283203125 0.001949310302734375 0.009999999776482582 -0.0384521484375 -0.0369873046875 0.30859375 0.0029697418212890625 -0.0143890380859375 -0.0029296875 -0.00372314453125 0.03985595703125 0.10302734375 0.10400390625 0.02288818359375 -0.016357421875 0.003749847412109375 0.1630859375 0.1119384765625 0.253173828125 0.52294921875 0.0050048828125
96 628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 2018-02-09T17:30:59+00:00 
[
    "Public"
]
 
[]
 jpeg 2be9ea6baf18726f34da4e447a5851b4c072fe24c12989f969d8d356009003eb 4475373     0 0 0 0 0 0 0 0       628C1DF6-48DA-40FA-B6B7-BFB0AA99103B 0.7734375 0.5 0.0 0.04353466698231588 0.10000000149011612 -0.0020580291748046875 0.00391387939453125 0.0029811859130859375 0.009999999776482582 -0.59130859375 -0.08465576171875 0.1370849609375 0.0033111572265625 -0.0184783935546875 -0.150390625 -0.458740234375 -0.140380859375 0.11199951171875 -0.11077880859375 -0.00164031982421875 -0.049957275390625 0.0035800933837890625 0.01312255859375 -0.007232666015625 -0.1181640625 -0.14794921875 -0.0172882080078125
149 8A4D8382-B56E-4B87-8185-3702FA3AC0CF 2018-02-09T17:30:50+00:00 
[
    "Public"
]
 
[]
 jpeg 4864ce041cb9789b351bee246199845dbd66866c44576a409c755995327bf070 4978336     0 0 0 0 0 0 0 0       8A4D8382-B56E-4B87-8185-3702FA3AC0CF 0.6328125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016613006591796875 0.0130462646484375 0.0018100738525390625 0.009999999776482582 -0.320556640625 -0.032470703125 0.2236328125 0.0037078857421875 -0.0207977294921875 -0.024261474609375 -0.063720703125 -0.041015625 0.10992431640625 -0.00274658203125 0.005218505859375 -0.05413818359375 0.00498199462890625 0.092529296875 0.05181884765625 0.07879638671875 0.434326171875 -0.007740020751953125
402 F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 2018-02-09T17:27:30+00:00 
[
    "Public"
]
 
[]
 jpeg c7f136a2c859e0cf4683e9c496fb21501ba2d22b326f91ee68a61b048d3cf75d 6152857     0 0 0 0 0 0 0 0       F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E 0.52978515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0015249252319335938 -0.0049591064453125 0.004039764404296875 0.009999999776482582 -0.37744140625 -0.07696533203125 0.2646484375 0.0016355514526367188 -0.01751708984375 -0.0535888671875 -0.484130859375 -0.067626953125 0.138916015625 -0.064453125 -0.0138397216796875 -0.0174102783203125 0.001926422119140625 0.00930023193359375 -0.00273895263671875 -0.4765625 -0.3681640625 -0.083740234375
248 E6BE07D8-2034-485F-9362-F9E0EC53453A 2018-02-09T17:25:46+00:00 
[
    "Public"
]
 
[]
 jpeg 793d55151710ba958b585f1956ba22787bcd2ec91882beeb20ff432bb287ce52 5996815     0 0 0 0 0 0 0 0       E6BE07D8-2034-485F-9362-F9E0EC53453A 0.525390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.05792236328125 -0.006591796875 0.0074310302734375 0.009999999776482582 -0.513671875 -0.09503173828125 -0.1875 0.07080078125 -0.16259765625 -0.070556640625 -0.57177734375 -0.6787109375 0.093994140625 -0.0762939453125 -0.002361297607421875 -0.0206298828125 0.005535125732421875 0.0016679763793945312 -0.44384765625 -0.1187744140625 -0.3017578125 -0.049591064453125
372 B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 2018-02-09T17:22:44+00:00 
[
    "Public"
]
 
[]
 jpeg b693381f085f8eccc64d6d4a372870542ed55390621b48e7f0acdd878de466ee 4447612     0 0 0 0 0 0 0 0       B2AF6A23-95AB-462A-9AF9-AA5792FE43A0 0.71044921875 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.0005679130554199219 0.01261138916015625 0.002521514892578125 0.009999999776482582 -0.0411376953125 -0.042388916015625 0.340087890625 0.00147247314453125 -0.007175445556640625 -0.0174560546875 -0.077880859375 -0.019287109375 0.1181640625 -0.009429931640625 0.0051727294921875 -0.160888671875 0.007488250732421875 0.049224853515625 0.01480865478515625 -0.186279296875 0.419921875 -0.0118408203125
284 A9CC4A89-22E0-42B3-8026-B07334120C45 2018-02-09T17:21:25+00:00 
[
    "Public"
]
 
[]
 jpeg 8887d5b42995cb3e6d0959d3cabca4a4b9a4ef9658de25a72ad232b282ca9f99 4911035     0 0 0 0 0 0 0 0       A9CC4A89-22E0-42B3-8026-B07334120C45 0.68212890625 0.5 0.0 0.04201816466018444 0.10000000149011612 -0.0282745361328125 -0.006748199462890625 0.0014162063598632812 0.009999999776482582 -0.4091796875 -0.08990478515625 -0.07373046875 0.057373046875 -0.342041015625 -0.06829833984375 -0.51513671875 -0.55810546875 0.0455322265625 -0.142822265625 -0.0050048828125 -0.01666259765625 0.0017747879028320312 0.00646209716796875 -0.19921875 -0.36328125 -0.099609375 -0.1099853515625
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
117 E1D818E2-89E8-4AA6-9D53-BA54F32F332B 2018-02-09T17:09:57+00:00 
[
    "Public"
]
 
[]
 jpeg 38d2cbc031e651476e9e6f76a9771e6fa9a50ca34841f6e4dab9ca5479932f11 5452392     0 0 0 0 0 0 0 0       E1D818E2-89E8-4AA6-9D53-BA54F32F332B 0.6748046875 0.5 0.0 0.042008692071638036 0.10000000149011612 -0.0063629150390625 0.00811004638671875 0.0115509033203125 0.009999999776482582 -0.20556640625 -0.03875732421875 0.03302001953125 0.0517578125 -0.062103271484375 -0.0701904296875 -0.25439453125 -0.26416015625 0.3876953125 -0.01654052734375 0.00994873046875 -0.02093505859375 0.01348114013671875 0.004314422607421875 -0.0185546875 -0.0633544921875 -0.2301025390625 -0.01535797119140625
293 F8A949C8-9034-4437-A685-765B42D87052 2018-02-09T17:09:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8d72f82e8b04528c211dca24f9cb846e4b5f6aca72b7047714bd04eb5bdfed70 5236836     0 0 0 0 0 0 0 0       F8A949C8-9034-4437-A685-765B42D87052 0.76318359375 0.5 0.0 0.043549711012658275 0.10000000149011612 -0.002758026123046875 0.007160186767578125 0.0054473876953125 0.009999999776482582 -0.9423828125 -0.0203704833984375 0.2205810546875 0.0003936290740966797 -0.006511688232421875 -0.0133209228515625 -0.08416748046875 -0.04241943359375 0.036834716796875 0.005096435546875 -0.0263824462890625 -0.00873565673828125 0.00243377685546875 0.0274810791015625 -0.0011138916015625 0.096923828125 0.10662841796875 -0.0027599334716796875
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
307 CE82D764-5190-4817-8027-18562D6C4E44 2018-02-09T17:09:01+00:00 
[
    "Public"
]
 
[]
 jpeg 9482db6d0ad87c6629f59ad3a1952b14be4efe363fc7f6b7d52d9d63c6c5529b 4737344     0 0 0 0 0 0 0 0       CE82D764-5190-4817-8027-18562D6C4E44 0.7080078125 0.5 0.0 0.043530951929456406 0.10000000149011612 -0.00106048583984375 0.00131988525390625 0.0025310516357421875 0.009999999776482582 0.1129150390625 -0.0872802734375 0.288330078125 0.0020198822021484375 -0.0216217041015625 -0.09893798828125 -0.33544921875 -0.074951171875 0.2939453125 -0.1087646484375 -0.0019989013671875 -0.0322265625 0.0035381317138671875 0.01049041748046875 -0.00115203857421875 -0.4990234375 -0.13134765625 -0.06817626953125
276 16243B99-6AFB-4401-9E29-90CAFB201343 2018-02-09T17:08:34+00:00 
[
    "Public"
]
 
[]
 jpeg 8476e9f946979ae2b0f1a8c1a06165e123b700464986ca846f91595a7825728a 4595280     0 0 0 0 0 0 0 0       16243B99-6AFB-4401-9E29-90CAFB201343 0.71142578125 0.5 0.0 0.04354488212643689 0.10000000149011612 -0.0030269622802734375 0.020294189453125 0.0089874267578125 0.009999999776482582 -0.92431640625 -0.0231475830078125 0.01873779296875 0.00243377685546875 -0.0050201416015625 -0.003948211669921875 0.1689453125 -0.0125732421875 0.015838623046875 0.093505859375 -0.0188446044921875 -0.002872467041015625 0.0068511962890625 0.07159423828125 0.012542724609375 0.1868896484375 0.427490234375 0.00797271728515625
138 78EDF691-C593-4162-B20C-F96D5675DA46 2018-02-09T17:08:28+00:00 
[
    "Public"
]
 
[]
 jpeg 3f52e7508a28417a832fb8d369adc520002ad808bc8bf480e5fca9134d16d616 4432185     0 0 0 0 0 0 0 0       78EDF691-C593-4162-B20C-F96D5675DA46 0.74755859375 0.5 0.0 0.04354636769258339 0.10000000149011612 -0.0011119842529296875 0.03460693359375 0.0135345458984375 0.009999999776482582 -0.77978515625 -0.01467132568359375 0.1280517578125 0.004772186279296875 -0.006931304931640625 -0.00461578369140625 0.178955078125 0.076171875 0.1982421875 0.11798095703125 -0.01154327392578125 -0.003734588623046875 0.025421142578125 0.06451416015625 0.024993896484375 0.1263427734375 0.33251953125 0.00576019287109375
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
22 E77313F1-D351-4F1C-85BA-7D88CCE26FE7 2018-02-09T17:08:14+00:00 
[
    "Public"
]
 
[]
 jpeg 0cbc72959305698cc602c5aa38a7b95b7cd3e3c7411273d63bfb3db481edffcd 4757357     0 0 0 0 0 0 0 0       E77313F1-D351-4F1C-85BA-7D88CCE26FE7 0.71875 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.006290435791015625 0.02703857421875 0.006122589111328125 0.019999999552965164 -0.939453125 -0.03192138671875 0.076416015625 0.00609588623046875 -0.005706787109375 -0.00545501708984375 -0.0206298828125 -0.045166015625 0.044342041015625 0.05059814453125 -0.043212890625 -0.005584716796875 0.004215240478515625 0.073974609375 0.135498046875 0.067138671875 0.154052734375 0.00299835205078125
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
215 C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 2018-02-09T17:07:45+00:00 
[
    "Public"
]
 
[]
 jpeg 6b5b1aca3fb2810239c1f3003ce4a0c538c9aa9ac9a9eaf0549ad24ab255ad49 5800574     0 0 0 0 0 0 0 0       C31ED7C1-DD52-46A6-8EA2-B41A8B6D6302 0.63037109375 0.5 0.0 0.04202726551594625 0.10000000149011612 -0.0227203369140625 -0.009124755859375 0.00536346435546875 0.009999999776482582 -0.3115234375 -0.061309814453125 -0.0322265625 0.0345458984375 -0.1669921875 -0.059539794921875 -0.443359375 -0.478515625 0.1287841796875 -0.07940673828125 -0.0029850006103515625 -0.0196990966796875 0.004180908203125 0.00243377685546875 -0.163330078125 -0.285400390625 -0.2890625 -0.097900390625
213 FC705948-B3D8-4B7A-90A6-E617B3ED80F6 2018-02-09T17:07:31+00:00 
[
    "Public"
]
 
[]
 jpeg 69c533c4c5bfc739e1eced0562e7a2945919176fa7e13a432e5a0ee5731a59ae 5878523     0 0 0 0 0 0 0 0       FC705948-B3D8-4B7A-90A6-E617B3ED80F6 0.58740234375 0.5 0.0 0.04203098011380844 0.10000000149011612 -0.00243377685546875 0.008056640625 0.0013408660888671875 0.009999999776482582 -0.2054443359375 -0.036285400390625 0.333740234375 0.0038547515869140625 -0.02337646484375 -0.02716064453125 -0.0999755859375 -0.0706787109375 0.161376953125 -0.068359375 0.001575469970703125 -0.10321044921875 0.003795623779296875 0.07476806640625 0.0780029296875 -0.124755859375 0.33203125 -0.0229339599609375

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