photos_with_apple_metadata (view)

33 rows where "date" is on date 2019-11-02

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, favorite, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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