photos_with_apple_metadata (view)

33 rows where "date" is on date 2019-11-02 sorted by ZINTRUSIVEOBJECTPRESENCESCORE

✎ View and edit SQL

This data as json, CSV (advanced)

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

date (date) ✖

  • 2019-11-02 · 33 ✖
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
341 65600C73-CFBC-4FD9-AADE-9CA39F776FC2 2019-11-02T20:30:31+00:00 
[
    "Public"
]
 
[]
 jpeg a50d3c5dc31188f36a8f2f6176c6469a5b62cb270962ba63737b3bfc5c9462f8 4837662     0 0 0 0 0 0 0 0       65600C73-CFBC-4FD9-AADE-9CA39F776FC2 0.70703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.004070281982421875 0.00601959228515625 0.01132965087890625 0.019999999552965164 -0.5419921875 -0.152099609375 0.0072021484375 0.012725830078125 -0.01111602783203125 -0.11370849609375 -0.69384765625 -0.262939453125 0.1044921875 -0.0220947265625 0.00093841552734375 -0.0264434814453125 0.005039215087890625 0.0030517578125 -0.03656005859375 -0.08477783203125 -0.47119140625 -0.0071563720703125
286 41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D 2019-11-02T20:30:04+00:00 
[
    "Public"
]
 
[]
 jpeg 88cb2bf7299d65b53c69b24b13848fa2daeaeeeab75f98affaccf522c0dc7d42 4484642     0 0 0 0 0 0 0 0       41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D 0.70703125 0.5 0.0 0.043530952384453696 0.10000000149011612 -0.004364013671875 0.0061187744140625 0.004718780517578125 0.019999999552965164 -0.42724609375 -0.1483154296875 0.0650634765625 0.01332855224609375 -0.015838623046875 -0.08636474609375 -0.61962890625 -0.1812744140625 0.07196044921875 -0.0423583984375 -0.00017547607421875 -0.047637939453125 0.0026836395263671875 0.01016998291015625 -0.01580810546875 -0.1910400390625 -0.31103515625 -0.016571044921875
87 F6C8C0BE-AC14-43D9-93DD-ABBE269505DC 2019-11-02T20:32:08+00:00 
[
    "Public"
]
 
[]
 jpeg 25ec2f2b497ddc05179526c0bc05ba1f553cce0e43638d01223a39f1b092a890 4871874     1 0 0 0 0 0 0 0       F6C8C0BE-AC14-43D9-93DD-ABBE269505DC 0.77783203125 0.75 0.0 0.06261473575621161 0.10000000149011612 -0.0036067962646484375 -0.00318145751953125 0.002521514892578125 0.009999999776482582 -0.092529296875 -0.1480712890625 0.102783203125 0.00926971435546875 -0.024383544921875 -0.09161376953125 -0.60888671875 -0.254638671875 0.10968017578125 -0.09063720703125 -0.0031261444091796875 -0.0168914794921875 0.0022335052490234375 0.0059814453125 -0.056488037109375 -0.429443359375 -0.284912109375 -0.06451416015625
142 A6FB150E-71C0-4524-8344-57CF59FE1B9E 2019-11-02T20:30:45+00:00 
[
    "Public"
]
 
[]
 jpeg 4360afbd37be230bf9fd6afcc48245e76bf9c81786713400653b2c81fb63f9e7 4649025     0 0 0 0 0 0 0 0       A6FB150E-71C0-4524-8344-57CF59FE1B9E 0.671875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0011243820190429688 0.0157928466796875 0.004364013671875 0.009999999776482582 -0.005615234375 -0.12188720703125 0.214599609375 0.00577545166015625 -0.0089874267578125 -0.04571533203125 -0.452880859375 -0.0048828125 0.090087890625 -0.01739501953125 4.57763671875e-05 -0.017822265625 0.002590179443359375 0.0214080810546875 0.0196380615234375 -0.337646484375 -0.1243896484375 0.0
331 1B6765D2-F281-48DB-A23A-C081FFAC69DC 2019-11-02T20:31:26+00:00 
[
    "Public"
]
 
[]
 jpeg a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 4561109     0 0 0 0 0 0 0 0       1B6765D2-F281-48DB-A23A-C081FFAC69DC 0.7705078125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0023326873779296875 -0.00392913818359375 0.00217437744140625 0.009999999776482582 -0.1573486328125 -0.11859130859375 0.0679931640625 0.00864410400390625 -0.030670166015625 -0.083984375 -0.52197265625 -0.2744140625 0.12139892578125 -0.083740234375 -0.001941680908203125 -0.02880859375 0.004199981689453125 0.00841522216796875 -0.029266357421875 -0.431396484375 -0.082763671875 -0.0531005859375
250 2C40753A-80EB-4B9E-B0C4-678E61A06C55 2019-11-02T20:31:46+00:00 
[
    "Public"
]
 
[]
 jpeg 79c147d029b433c3ef13a29afe060dfa4866b928c64f375788df5ecc2a2d0e65 4392510     0 0 0 0 0 0 0 0       2C40753A-80EB-4B9E-B0C4-678E61A06C55 0.6650390625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0025310516357421875 0.00339508056640625 0.00257110595703125 0.07999999821186066 -0.0814208984375 -0.115966796875 0.0992431640625 0.00766754150390625 -0.0218658447265625 -0.06072998046875 -0.459228515625 -0.179931640625 0.043853759765625 -0.04547119140625 -0.0023193359375 -0.020782470703125 0.001926422119140625 0.010009765625 -0.0220947265625 -0.298095703125 -0.0684814453125 0.0150146484375
421 6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 2019-11-02T20:23:27+00:00 
[
    "Public"
]
 
[]
 jpeg d597f6879722f4f91e3558f509a859171132b60d7df319ba3fea358fa175d704 4948411     0 0 0 0 0 0 0 0       6DD60E1B-A93F-431C-BEE5-E7B2AEF430BE 0.599609375 0.25 0.0 0.02292342267873633 0.10000000149011612 -0.0014667510986328125 0.0130157470703125 0.00669097900390625 0.05999999865889549 -0.1693115234375 -0.10723876953125 0.125732421875 0.0100555419921875 -0.01029205322265625 -0.053619384765625 -0.46923828125 -0.0592041015625 0.12359619140625 0.00830078125 0.00091552734375 -0.0198974609375 0.005260467529296875 0.01262664794921875 -0.0024566650390625 -0.2452392578125 -0.17578125 0.0079345703125
259 08D18A51-8004-4F00-B79E-4AA1628FB111 2019-11-02T20:30:15+00:00 
[
    "Public"
]
 
[]
 jpeg 7e284f6fd7631015c32f82d4f57454941dc145fa608e510ccc84fea71b09cab1 4289135     0 0 0 0 0 0 0 0       08D18A51-8004-4F00-B79E-4AA1628FB111 0.78125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.8681640625 -0.032379150390625 0.00734710693359375 0.009999999776482582 -0.82080078125 -0.10614013671875 0.03277587890625 0.0027370452880859375 -0.3720703125 -0.317626953125 -0.8310546875 -0.62158203125 0.019683837890625 -0.69287109375 -0.003093719482421875 -0.026031494140625 0.0002472400665283203 0.00030541419982910156 -0.98193359375 -0.50048828125 -0.818359375 -0.8115234375
90 9D0280F7-D619-4D2C-B323-B21CAEBA92EF 2019-11-02T20:31:31+00:00 
[
    "Public"
]
 
[]
 jpeg 277b4b361f6df02e423d1000b4d2a98c758f29a027c4bff347000b3ee93de2ed 4596329     1 0 0 0 0 0 0 0       9D0280F7-D619-4D2C-B323-B21CAEBA92EF 0.8193359375 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.001941680908203125 0.004848480224609375 0.0013561248779296875 0.009999999776482582 -0.90771484375 -0.10125732421875 0.0489501953125 0.003635406494140625 -0.00595855712890625 -0.0113525390625 -0.378173828125 -0.061279296875 0.017303466796875 0.031341552734375 -0.0163116455078125 -0.0170745849609375 0.002140045166015625 0.134033203125 0.1602783203125 -0.002685546875 0.431396484375 -0.00119781494140625
65 FC01AB36-9465-4F95-8DC9-618FBC1405A6 2019-11-02T20:30:03+00:00 
[
    "Public"
]
 
[]
 jpeg 1da3b02a32b8235544f503965aa55528896aa637e79e12bdf6493c8541967cea 4491789     0 0 0 0 0 0 0 0       FC01AB36-9465-4F95-8DC9-618FBC1405A6 0.76708984375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0016355514526367188 0.00383758544921875 0.00473785400390625 0.019999999552965164 -0.46875 -0.10015869140625 0.09564208984375 0.0033111572265625 -0.011871337890625 -0.065673828125 -0.497802734375 -0.1065673828125 0.06732177734375 -0.025115966796875 -0.002429962158203125 -0.0179290771484375 0.003040313720703125 0.0097808837890625 -0.01000213623046875 -0.1546630859375 -0.1719970703125 -0.0113983154296875
59 E28B94C5-3FD9-4199-B291-5727F3D40053 2019-11-02T20:32:12+00:00 
[
    "Public"
]
 
[]
 jpeg 1bf6f978059091efb89907071b2796f19db07ba2994d6826fc794dcb1ce3d38a 4830969     0 0 0 0 0 0 0 0       E28B94C5-3FD9-4199-B291-5727F3D40053 0.7939453125 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.0024433135986328125 0.001224517822265625 0.0018033981323242188 0.009999999776482582 -0.83935546875 -0.09027099609375 0.05169677734375 0.002811431884765625 -0.011199951171875 -0.04876708984375 -0.432861328125 -0.2054443359375 0.03314208984375 -0.02099609375 -0.005584716796875 -0.0362548828125 0.00319671630859375 0.0261077880859375 -0.0133209228515625 -0.05126953125 0.1944580078125 -0.007366180419921875
201 5FCADAE8-4708-4E56-B6B0-F718EE9446F7 2019-11-02T20:31:19+00:00 
[
    "Public"
]
 
[]
 jpeg 64d4969938ae0359e40e8450801788ee372e29e5f755d3c5a1f671f2212bc809 4462558     0 0 0 0 0 0 0 0       5FCADAE8-4708-4E56-B6B0-F718EE9446F7 0.82177734375 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.002124786376953125 0.000396728515625 0.0029125213623046875 0.009999999776482582 -0.150390625 -0.09027099609375 0.29443359375 0.003376007080078125 -0.0162200927734375 -0.07568359375 -0.42333984375 -0.1134033203125 0.151123046875 -0.0860595703125 -0.005008697509765625 -0.04974365234375 0.0026836395263671875 0.01267242431640625 -0.005584716796875 -0.470947265625 -0.1773681640625 -0.07421875
290 5C8A9E7C-62A9-4609-95C7-75826C03EF24 2019-11-02T20:32:13+00:00 
[
    "Public"
]
 
[]
 jpeg 8bc56b3f8a20e0370f225bd7e9016c5435f837cbd37a640ac89bc6fab6c88983 4783904     0 0 0 0 0 0 0 0       5C8A9E7C-62A9-4609-95C7-75826C03EF24 0.79833984375 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.001495361328125 0.00037384033203125 0.00605010986328125 0.009999999776482582 -0.36181640625 -0.0836181640625 0.255126953125 0.0031604766845703125 -0.01111602783203125 -0.10107421875 -0.560546875 -0.09552001953125 0.185546875 -0.0755615234375 -0.001712799072265625 -0.038970947265625 0.0036640167236328125 0.005619049072265625 -0.007110595703125 -0.341064453125 -0.450927734375 -0.048065185546875
366 A4F38147-CE20-41A8-8811-583623ABE085 2019-11-02T20:32:27+00:00 
[
    "Public"
]
 
[]
 jpeg b35aff17400287b860379849efbfab739524ed040f0b5d59cebbe71021ac32f6 5028634     0 0 0 0 0 0 0 0       A4F38147-CE20-41A8-8811-583623ABE085 0.7412109375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0028553009033203125 0.00070953369140625 0.0025806427001953125 0.07999999821186066 0.11181640625 -0.07879638671875 0.07183837890625 0.01450347900390625 -0.046112060546875 -0.03326416015625 -0.28515625 -0.2376708984375 0.050811767578125 -0.037841796875 -0.001598358154296875 -0.0120697021484375 0.0027141571044921875 0.012969970703125 -0.021575927734375 -0.32666015625 0.1380615234375 -0.026336669921875
321 429A1239-744D-4A61-A33B-1BF261584128 2019-11-02T20:32:07+00:00 
[
    "Public"
]
 
[]
 jpeg 9d0b55a181e5acc3dd658ac1c79c7000cde794058c3e93698d1337ca6d4e348a 4858397     0 0 0 0 0 0 0 0       429A1239-744D-4A61-A33B-1BF261584128 0.79833984375 0.75 0.0 0.06261464384675935 0.5030657052993774 -0.0016164779663085938 0.0750732421875 0.023284912109375 0.009999999776482582 0.1019287109375 -0.0784912109375 0.060943603515625 0.01861572265625 -0.006641387939453125 -0.039154052734375 -0.078125 0.118896484375 0.1488037109375 0.3134765625 0.04833984375 0.00243377685546875 0.00945281982421875 0.0250396728515625 0.049774169921875 0.0056610107421875 -0.05963134765625 0.049896240234375
230 D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 2019-11-02T20:31:30+00:00 
[
    "Public"
]
 
[]
 jpeg 71e43f92a0ac99ed5fa838e65f58a6976c1d3e80908eb4b0427e104da7f4d2e3 4531938     0 0 0 0 0 0 0 0       D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 0.84423828125 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0031719207763671875 -0.0098876953125 0.0023975372314453125 0.019999999552965164 -0.1708984375 -0.06890869140625 0.2208251953125 0.0024814605712890625 -0.05072021484375 -0.1019287109375 -0.407958984375 -0.1861572265625 0.199462890625 -0.140869140625 -0.0044708251953125 -0.032257080078125 0.002368927001953125 0.004848480224609375 -0.022552490234375 -0.53173828125 -0.293701171875 -0.13134765625
297 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 2019-11-02T19:10:14+00:00 
[
    "Public"
]
 
[]
 heic 8e863e558a9bcd65dbfe5add8c6bc8fc5150358449cc9036d6fa9c428e7ba8ee 2239399 37.456428329999994 -122.10851949999999 1 0 0 0 0 0 0 0 Palo Alto CA United States 2D40FEB4-03ED-4C06-BEAF-F54E0523D909 0.38037109375 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.002208709716796875 0.01380157470703125 0.0165252685546875 0.009999999776482582 -0.21142578125 -0.06890869140625 0.142333984375 0.006389617919921875 -0.012481689453125 -0.0638427734375 -0.425537109375 -0.05072021484375 0.202880859375 -0.01123046875 0.0060272216796875 -0.01305389404296875 0.004810333251953125 0.005062103271484375 -0.00335693359375 -0.10638427734375 -0.413818359375 -0.01690673828125
422 BA1C8565-7D1C-49E3-93BA-183B8D6B1270 2019-11-02T20:31:29+00:00 
[
    "Public"
]
 
[]
 jpeg d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 4246410     0 0 0 0 0 0 0 0       BA1C8565-7D1C-49E3-93BA-183B8D6B1270 0.84228515625 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0006117820739746094 0.0157012939453125 0.0020351409912109375 0.03999999910593033 0.599609375 -0.06622314453125 0.10491943359375 0.01009368896484375 -0.015838623046875 0.00726318359375 0.02276611328125 -0.0177001953125 0.07318115234375 0.0751953125 0.00572967529296875 -0.008392333984375 0.00867462158203125 0.0836181640625 0.047119140625 -0.158203125 0.68798828125 0.1689453125
50 B0F72802-C713-43D3-899A-81C4AED347DC 2019-11-02T20:32:07+00:00 
[
    "Public"
]
 
[]
 jpeg 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 4949434     0 0 0 0 0 0 0 0       B0F72802-C713-43D3-899A-81C4AED347DC 0.79150390625 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.0027790069580078125 -0.003040313720703125 0.0018463134765625 0.03999999910593033 0.2215576171875 -0.05780029296875 0.063232421875 0.00916290283203125 -0.085693359375 -0.040863037109375 -0.1737060546875 -0.291259765625 0.11456298828125 -0.05914306640625 -0.00067138671875 -0.021148681640625 0.00473785400390625 0.00933837890625 -0.023468017578125 -0.37060546875 0.235595703125 -0.053070068359375
44 46ABC862-9837-404A-832B-4158270704FF 2019-11-02T20:32:16+00:00 
[
    "Public"
]
 
[]
 jpeg 169984801ec60631b48ca4acac75c2c745951a72024d7145f7803a2978e59267 4760871     0 0 0 0 0 0 0 0       46ABC862-9837-404A-832B-4158270704FF 0.7314453125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0031604766845703125 -0.007091522216796875 0.0027141571044921875 0.019999999552965164 0.05517578125 -0.057586669921875 0.1978759765625 0.004055023193359375 -0.05718994140625 -0.051116943359375 -0.272216796875 -0.1932373046875 0.1597900390625 -0.08160400390625 -0.00304412841796875 -0.0216217041015625 0.0029125213623046875 0.006717681884765625 -0.0247039794921875 -0.5302734375 -0.07275390625 -0.1270751953125
148 4EC865F7-E05C-42A0-B43A-4D46235F6F9C 2019-11-02T20:31:34+00:00 
[
    "Public"
]
 
[]
 jpeg 4835c1442d65d55dedd5ab611d33201c41f5501a905cdc7decf0ff4563f423d8 4479783     0 0 0 0 0 0 0 0       4EC865F7-E05C-42A0-B43A-4D46235F6F9C 0.81201171875 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.001461029052734375 0.0098724365234375 0.003650665283203125 0.009999999776482582 -0.0167236328125 -0.056976318359375 0.482177734375 0.0022525787353515625 -0.01554107666015625 -0.09368896484375 -0.263427734375 -0.060302734375 0.33056640625 -0.10772705078125 0.000396728515625 -0.02008056640625 0.0036067962646484375 0.013275146484375 -0.0019073486328125 -0.37255859375 -0.12451171875 -0.07977294921875
479 FF230430-EDD4-4E3F-83F9-C105A7EE7598 2019-11-02T20:31:02+00:00 
[
    "Public"
]
 
[]
 jpeg f5540186893e81abf2b46cb2108caa981d5a1e063e184f7242709e6287437911 4817123     0 0 0 0 0 0 0 0       FF230430-EDD4-4E3F-83F9-C105A7EE7598 0.76220703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0017681121826171875 -0.0049896240234375 0.002349853515625 0.019999999552965164 0.139404296875 -0.047515869140625 0.317626953125 0.00147247314453125 -0.0364990234375 -0.051422119140625 -0.1719970703125 -0.1263427734375 0.1759033203125 -0.0941162109375 -0.0011386871337890625 -0.03131103515625 0.003223419189453125 0.0094146728515625 -0.01128387451171875 -0.53125 0.0823974609375 -0.117431640625
107 8A1CFD4F-AF9F-4018-A451-4709416FAEA0 2019-11-02T20:39:44+00:00 
[
    "Public"
]
 
[]
 jpeg 3345e08925ea68ce3808102dce8f4b4e08f6c65a77d405c8b7a4741c322e0c68 4263841     1 0 0 0 0 0 0 0       8A1CFD4F-AF9F-4018-A451-4709416FAEA0 0.7177734375 0.75 0.0 0.06262569391090451 0.10000000149011612 -0.0007410049438476562 0.0189056396484375 0.0011157989501953125 0.019999999552965164 -0.064697265625 -0.046905517578125 0.2431640625 0.0034160614013671875 -0.01358795166015625 0.0128173828125 -0.04541015625 0.04571533203125 0.055206298828125 0.05841064453125 0.003330230712890625 -0.0134429931640625 0.0029582977294921875 0.242919921875 0.160888671875 -0.0233154296875 0.61572265625 0.01202392578125
161 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 2019-11-02T20:23:51+00:00 
[
    "Public"
]
 
[]
 jpeg 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 5127846     0 0 0 0 0 0 0 0       0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 0.6171875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0006799697875976562 0.0157928466796875 0.01085662841796875 0.03999999910593033 0.0447998046875 -0.04351806640625 0.267578125 0.0020503997802734375 -0.00844573974609375 -0.02105712890625 -0.161376953125 0.03826904296875 0.12213134765625 0.011474609375 0.0068359375 -0.0125885009765625 0.005706787109375 0.0153045654296875 0.002277374267578125 -0.194580078125 0.0333251953125 -0.00848388671875
114 4E45EBA2-F531-4076-8741-A6D18656D677 2019-11-02T20:23:08+00:00 
[
    "Public"
]
 
[]
 jpeg 37f9819e71d4e2ae622f37fb8f1ad0c4d03c6fbe5653f79a5e14ce551ad9a818 5085402     0 0 0 0 0 0 0 0       4E45EBA2-F531-4076-8741-A6D18656D677 0.5927734375 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0017414093017578125 -0.00809478759765625 0.0035247802734375 0.05999999865889549 -0.463134765625 -0.041839599609375 0.4140625 0.0005507469177246094 -0.016845703125 -0.0992431640625 -0.37353515625 -0.07208251953125 0.2237548828125 -0.1409912109375 -0.0031261444091796875 -0.0285491943359375 0.0023136138916015625 0.007232666015625 -0.00624847412109375 -0.316162109375 -0.35888671875 -0.059173583984375
111 7C21930F-62A8-4540-91C4-E080707A4CC5 2019-11-02T20:31:20+00:00 
[
    "Public"
]
 
[]
 jpeg 36e9d2b9e79747b29aba0606d0b8a6a563111ad6a8213a36e618b33d5ee41b51 4685234     0 0 0 0 0 0 0 0       7C21930F-62A8-4540-91C4-E080707A4CC5 0.779296875 0.5 0.0 0.043530951929456406 0.1007542610168457 -0.0011835098266601562 0.025787353515625 0.0009326934814453125 0.05999999865889549 0.278076171875 -0.04083251953125 0.369140625 0.0016613006591796875 -0.0106964111328125 0.01271820068359375 0.024322509765625 0.04644775390625 0.0217742919921875 0.004058837890625 0.014617919921875 -0.00887298583984375 0.0007381439208984375 0.381103515625 0.61376953125 0.31591796875 0.67724609375 -0.0018157958984375
152 A40BDBBE-2DC6-4385-8108-8C15F37610B4 2019-11-02T20:30:59+00:00 
[
    "Public"
]
 
[]
 jpeg 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c 4629001     0 0 0 0 0 0 0 0       A40BDBBE-2DC6-4385-8108-8C15F37610B4 0.54931640625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.001918792724609375 -0.00484466552734375 0.002834320068359375 0.03999999910593033 0.165283203125 -0.04052734375 0.24755859375 0.0024623870849609375 -0.04595947265625 -0.04052734375 -0.1414794921875 -0.1551513671875 0.20751953125 -0.065673828125 -0.00061798095703125 -0.0300750732421875 0.005161285400390625 0.00844573974609375 -0.01395416259765625 -0.49267578125 0.1368408203125 -0.09515380859375
91 B47D9214-ACC0-4A75-8837-8DCA2E7F0D28 2019-11-02T20:22:51+00:00 
[
    "Public"
]
 
[]
 jpeg 27ae6d9cd414eca3aa086919a529fd63f550fefc6964ab92515be63b486de62e 4517624     0 0 0 0 0 0 0 0       B47D9214-ACC0-4A75-8837-8DCA2E7F0D28 0.5869140625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0007295608520507812 0.031158447265625 0.0016937255859375 0.009999999776482582 -0.067138671875 -0.03131103515625 0.1988525390625 0.004608154296875 -0.012969970703125 0.0157470703125 0.07708740234375 0.0693359375 0.07708740234375 0.1923828125 0.013427734375 -0.0103607177734375 0.00591278076171875 0.296142578125 0.18017578125 0.2158203125 0.68310546875 0.009979248046875
67 E38B4879-580E-454E-A06C-65335EDEBEB1 2019-11-02T20:23:18+00:00 
[
    "Public"
]
 
[]
 jpeg 1eb091d77226738cc72f75ec19792182635c5a0ecc5dc77cac70f36c17bb0a54 5444495     0 0 0 0 0 0 0 0       E38B4879-580E-454E-A06C-65335EDEBEB1 0.6572265625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016937255859375 -0.00299835205078125 0.0031604766845703125 0.009999999776482582 -0.61767578125 -0.0261993408203125 0.310302734375 0.0011653900146484375 -0.0207977294921875 -0.05755615234375 -0.1907958984375 -0.0826416015625 0.33056640625 -0.05499267578125 -0.004913330078125 -0.036773681640625 0.00595855712890625 0.01306915283203125 -0.00167083740234375 -0.10516357421875 -0.0482177734375 -0.0196990966796875
271 01CEBCA2-922B-407C-A726-95D9E0EAB31C 2019-11-02T20:30:31+00:00 
[
    "Public"
]
 
[]
 jpeg 83667863dcd289d0c96e5d3ed3eb5dfe7ea399203b6cf00bc3e9c3566e7ac705 4810940     0 0 0 0 0 0 0 0       01CEBCA2-922B-407C-A726-95D9E0EAB31C 0.6572265625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.004085540771484375 0.0172119140625 0.0053863525390625 0.009999999776482582 -0.9560546875 -0.022674560546875 0.058502197265625 0.0011653900146484375 -0.00498199462890625 -0.00559234619140625 0.06793212890625 -0.06787109375 0.0125274658203125 0.052642822265625 -0.02593994140625 -0.0042877197265625 0.0035247802734375 0.05975341796875 -0.001373291015625 0.2047119140625 0.375732421875 0.00261688232421875
106 A9DA3A99-BD48-48F2-9F5A-2328329D320E 2019-11-02T20:22:53+00:00 
[
    "Public"
]
 
[]
 jpeg 332ae7b6996628d3cf858e9bccf07d4bc9a2e710417d39f9dd6765a3ef3da0b9 4865133     0 0 0 0 0 0 0 0       A9DA3A99-BD48-48F2-9F5A-2328329D320E 0.60498046875 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0038089752197265625 0.004974365234375 0.0094146728515625 0.009999999776482582 -0.93798828125 -0.020294189453125 0.125 0.00047278404235839844 -0.01049041748046875 -0.01259613037109375 -0.08746337890625 -0.06536865234375 0.0180511474609375 0.003448486328125 -0.0253753662109375 -0.0078582763671875 0.0019121170043945312 0.0136871337890625 -0.0081939697265625 0.07769775390625 0.00811767578125 -0.0020694732666015625
167 2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 2019-11-02T20:23:10+00:00 
[
    "Public"
]
 
[]
 jpeg 54c548a1c0f7e162558828db6bba845c2e9687cb148e877c58e975c9b2dfac61 5175607     0 0 0 0 0 0 0 0       2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 0.62353515625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.00208282470703125 0.03045654296875 0.011199951171875 0.009999999776482582 -0.8740234375 -0.018096923828125 0.0810546875 0.0029582977294921875 -0.00634002685546875 -0.005580902099609375 0.163330078125 0.01617431640625 0.044677734375 0.0885009765625 -0.023895263671875 -0.0026531219482421875 0.00945281982421875 0.049774169921875 0.007781982421875 0.151611328125 0.307861328125 0.00909423828125
185 398058A8-F11E-4306-8272-05A438B6E523 2019-11-02T20:30:21+00:00 
[
    "Public"
]
 
[]
 jpeg 5bad707a8d2196bdb37eaea0501f8745535af125cc5bf5725451258a6247847d 4283013     0 0 0 0 0 0 0 0       398058A8-F11E-4306-8272-05A438B6E523 0.74365234375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0008935928344726562 0.0330810546875 0.0116424560546875 0.009999999776482582 -0.833984375 -0.0160980224609375 0.050872802734375 0.0024433135986328125 -0.0033245086669921875 -0.001247406005859375 0.362548828125 0.1444091796875 0.02447509765625 0.1607666015625 -0.00890350341796875 -0.001003265380859375 0.01433563232421875 0.11376953125 0.025970458984375 0.2293701171875 0.56982421875 0.01476287841796875

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