photos_with_apple_metadata (view)

30 rows where ZINTERACTIONSCORE = "0.019999999552965164" and albums = "["Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, favorite, place_city, place_state_province, place_country, ZOVERALLAESTHETICSCORE, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZPLEASANTSYMMETRYSCORE, 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
223 B29AB28B-D604-408A-923C-45D779BCB380 2020-01-25T19:57:50+00:00 
[
    "Public"
]
 
[]
 jpeg 6f92ecbbc9835eedeb6c95e828fe99398a85ead6c52dd116bd953cf4a26dafb6 5776484     1 0 0 0 0 0 0 0       B29AB28B-D604-408A-923C-45D779BCB380 0.599609375 0.75 0.0 0.06111792116674758 0.10000000149011612 -0.0009255409240722656 0.0242462158203125 0.0034694671630859375 0.019999999552965164 0.38623046875 -0.0982666015625 0.058197021484375 0.018096923828125 -0.0121002197265625 0.000335693359375 -0.111572265625 0.11328125 0.03155517578125 0.118896484375 0.00444793701171875 -0.00079345703125 0.0035648345947265625 0.06500244140625 0.06536865234375 -0.10003662109375 0.36474609375 0.423583984375
417 08E42F94-41A8-4205-995A-9877453FAF92 2020-01-25T19:56:23+00:00 
[
    "Public"
]
 
[]
 jpeg d3e53a733fe399fa38178513d64414c8d65639d4191cefb94ec2b7f4741dd67c 6550072     1 0 0 0 0 0 0 0       08E42F94-41A8-4205-995A-9877453FAF92 0.53515625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0009889602661132812 0.0112152099609375 0.0030155181884765625 0.019999999552965164 -0.4736328125 -0.0181884765625 0.410888671875 0.0008263587951660156 -0.01422882080078125 -0.03338623046875 -0.06829833984375 -0.012237548828125 0.1614990234375 -0.030914306640625 -0.000240325927734375 -0.0221405029296875 0.004039764404296875 0.040313720703125 0.0086822509765625 0.0670166015625 0.204833984375 -0.01134490966796875
7 5BD1D973-19F4-48F1-AB13-A214B0B98452 2020-01-25T18:18:00+00:00 
[
    "Public"
]
 
[]
 heic 03bd641c31961be01b3f491a7414ccacb2c57dece64fd6fd8e4be6384643ef8e 2939606 37.11606667000001 -122.330475 1 0 0 0 0 0 0 0 Pescadero CA United States 5BD1D973-19F4-48F1-AB13-A214B0B98452 0.4609375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00885009765625 0.0035858154296875 0.01512908935546875 0.019999999552965164 -0.51416015625 -0.0567626953125 0.0233154296875 0.029815673828125 -0.047515869140625 -0.06463623046875 -0.453369140625 -0.25146484375 0.134033203125 -0.031097412109375 0.00135040283203125 -0.0153350830078125 0.00577545166015625 0.004383087158203125 -0.039459228515625 -0.0838623046875 -0.360107421875 -0.022308349609375
252 0BE49C93-2ACC-4628-9C12-99566921EE00 2020-01-25T18:11:18+00:00 
[
    "Public"
]
 
[]
 heic 7ad35f068121f446574a8c950f35017b34cbc4e6dd25c72be8a71b9234bb1e7a 3541580 37.115291670000005 -122.32810333 1 0 0 0 0 0 0 0 Pescadero CA United States 0BE49C93-2ACC-4628-9C12-99566921EE00 0.499267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 0.0284423828125 0.0020751953125 0.019999999552965164 0.091552734375 -0.055206298828125 0.0228271484375 0.1646728515625 -0.0496826171875 -0.010345458984375 -0.0771484375 -0.1522216796875 0.047515869140625 0.07708740234375 0.0098876953125 -0.006160736083984375 0.006072998046875 0.0849609375 0.03167724609375 -0.0933837890625 0.5546875 0.07440185546875
93 45CD64EE-9C93-48EA-89F8-8F9C849543F6 2019-12-18T15:26:39+00:00 
[
    "Public"
]
 
[]
 heic 2914d77166bd3d96058e8c4994e7840b61fc4f42a2be6c67cf2f6dbba96861fb 1517951 51.51231333 -0.09033617000000002 1 0 0 0 0 0 0 0 London England United Kingdom 45CD64EE-9C93-48EA-89F8-8F9C849543F6 0.6953125 0.75 0.0 0.058028268450089085 0.7025303840637207 -0.0003597736358642578 0.112548828125 0.005344390869140625 0.019999999552965164 0.80517578125 -0.0253753662109375 0.1171875 0.0162811279296875 -0.004314422607421875 0.01824951171875 0.52001953125 0.43359375 0.043121337890625 0.350341796875 0.045166015625 0.056427001953125 0.01332855224609375 0.2529296875 0.1829833984375 0.2476806640625 0.771484375 0.8681640625
298 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 2019-12-13T23:52:03+00:00 
[
    "Public"
]
 
[]
 heic 8e935af3c408ee0013c7d05f82ae8592f12aa341f455cc15534ae2db1ead05ef 2663392 34.11846667000001 -118.30060500000002 1 0 0 0 0 0 0 0 Los Angeles CA United States 3C3089C2-BA72-45E8-90B9-2974D8D2DB36 0.289794921875 0.75 0.0 0.05801763419659083 0.10000000149011612 -0.0009660720825195312 -0.00296783447265625 0.0020580291748046875 0.019999999552965164 0.148681640625 -0.0546875 0.416748046875 0.0016613006591796875 -0.0190887451171875 -0.022308349609375 -0.1881103515625 -0.056060791015625 0.286865234375 -0.05364990234375 -0.00543212890625 -0.0264129638671875 0.0034027099609375 0.0214080810546875 0.0212860107421875 -0.6259765625 0.081787109375 -0.1051025390625
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
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
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
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
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
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
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00 
[
    "Public"
]
 
[]
 heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125
131 D755ECF0-4954-461A-8523-2BCA917DA37C 2019-09-15T14:11:18+00:00 
[
    "Public"
]
 
[]
 jpeg 3bff710e021160610debf1cef0002dd77afc78694c1ad1373c2bc5a0c244658e 4403069     1 0 0 0 0 0 0 0       D755ECF0-4954-461A-8523-2BCA917DA37C 0.75732421875 0.75 0.0 0.0626162217773554 0.1004379540681839 -0.00033545494079589844 0.03814697265625 0.0197906494140625 0.019999999552965164 0.0579833984375 -0.0255126953125 0.1129150390625 0.0137939453125 -0.00600433349609375 0.0106964111328125 0.27734375 0.2056884765625 0.258544921875 0.2041015625 0.016815185546875 -0.001556396484375 0.0751953125 0.08770751953125 0.0274658203125 -0.0262451171875 0.48876953125 0.01727294921875
472 466CB5A7-6675-48D2-B7BF-9A2C0F83250E 2019-09-15T13:36:15+00:00 
[
    "Public"
]
 
[]
 jpeg f096c284469eab7364bc93f0e6b1a172fdf8f6221a7e27ef76b5bedc6720302a 6232116     1 0 0 0 0 0 0 0       466CB5A7-6675-48D2-B7BF-9A2C0F83250E 0.794921875 0.75 0.0 0.06417663634278392 0.5046228766441345 -0.0013885498046875 0.034088134765625 0.0020198822021484375 0.019999999552965164 0.54296875 -0.03759765625 0.03155517578125 0.062225341796875 -0.0127716064453125 0.008453369140625 0.302978515625 0.265625 0.018585205078125 0.195556640625 0.0266571044921875 0.003116607666015625 0.005428314208984375 0.5380859375 0.73583984375 0.2452392578125 0.85302734375 0.337890625
268 421867A7-CC19-4B0A-944C-26AE521DE430 2019-09-15T13:17:56+00:00 
[
    "Public"
]
 
[]
 jpeg 81afbe147b314b8d2080199a263d9d31e68d9bf8379123faf2c4a849b6d3b13e 6002543     1 0 0 0 0 0 0 0       421867A7-CC19-4B0A-944C-26AE521DE430 0.6416015625 0.75 0.0 0.061092475898393235 0.5047202110290527 -0.0017004013061523438 0.0198974609375 0.0017614364624023438 0.019999999552965164 0.5556640625 -0.060638427734375 -0.023101806640625 0.07574462890625 -0.0147857666015625 0.0053863525390625 0.2314453125 0.096923828125 0.009674072265625 0.1575927734375 0.010589599609375 0.00057220458984375 0.0058441162109375 0.36328125 0.4619140625 0.09844970703125 0.86572265625 0.349609375
488 7DDBAB14-E762-46B3-942A-BAD5AB6668A3 2019-09-15T13:14:03+00:00 
[
    "Public"
]
 
[]
 jpeg fb3e9dc60565ab6a9e492642843dba702d5a63c945420c0ec573610bdde8e9b8 6274468     1 0 0 0 0 0 0 0       7DDBAB14-E762-46B3-942A-BAD5AB6668A3 0.77392578125 0.75 0.0 0.062639624107885 0.10000000149011612 -0.001674652099609375 0.0215606689453125 0.0020503997802734375 0.019999999552965164 0.34423828125 -0.043609619140625 0.0489501953125 0.014556884765625 -0.0276947021484375 -0.00164794921875 0.08935546875 -0.0223388671875 0.029205322265625 0.149169921875 0.006847381591796875 -0.001789093017578125 0.00469970703125 0.10687255859375 0.05255126953125 0.12890625 0.65283203125 0.26171875
399 4FB52292-60F3-429B-971F-4843A2BD51B4 2019-09-15T12:53:03+00:00 
[
    "Public"
]
 
[]
 jpeg c708f463941e998c2a9d12854bed87d6e85f2235270312999b216c006a6fdeb1 7760105     1 0 0 0 0 0 0 0       4FB52292-60F3-429B-971F-4843A2BD51B4 0.447021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018177032470703125 0.027374267578125 0.02685546875 0.019999999552965164 -0.316650390625 -0.053497314453125 0.1463623046875 0.00428009033203125 -0.00894927978515625 -0.0819091796875 -0.28271484375 -0.04461669921875 0.1256103515625 0.0401611328125 0.00994873046875 -0.011474609375 0.00803375244140625 0.007373809814453125 -0.008026123046875 -0.03558349609375 -0.1982421875 -0.00734710693359375
452 27A4F78F-FC94-4E45-9512-0E89A13E33E5 2019-09-15T12:42:33+00:00 
[
    "Public"
]
 
[]
 jpeg e467e2655deced8d78b20667ebdf52cb3a325c2723ce0d8fed423f9fe8401ce7 4946963     1 0 0 0 0 0 0 0       27A4F78F-FC94-4E45-9512-0E89A13E33E5 0.6513671875 0.75 0.0 0.061090990332246735 0.5056204199790955 -0.00266265869140625 0.042999267578125 0.0033512115478515625 0.019999999552965164 0.52978515625 -0.063232421875 -0.0672607421875 0.2841796875 -0.025421142578125 0.0031890869140625 0.1854248046875 0.0341796875 0.0261993408203125 0.2314453125 0.040435791015625 0.00331878662109375 0.0094146728515625 0.143798828125 0.1871337890625 0.10595703125 0.6787109375 0.377197265625
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
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
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
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
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
480 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 2017-12-16T11:52:26+00:00 
[
    "Public"
]
 
[]
 heic f574eaa689ab82870f62f702593725ed4a8e7a9f6c67a1ba31c79d57089f9e62 2274468 51.5034 -0.13202216666666666 0 0 0 0 0 0 0 0 London England United Kingdom E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
385 F6F45595-4033-4C79-A9F9-86DCA9088C37 2017-12-16T11:52:13+00:00 
[
    "Public"
]
 
[]
 heic bfe920659a1e209114e738c58fcc9e1df8cdd1eaed6ac7af4721f05865ba8935 2341576 51.50340333333333 -0.13203616666666668 0 0 0 0 0 0 0 0 London England United Kingdom F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 0.8053669137809113 0.10000000149011612 -0.00572967529296875 -0.000789642333984375 0.0010814666748046875 0.019999999552965164 0.0447998046875 -0.095703125 0.048583984375 0.01238250732421875 -0.08880615234375 -0.05389404296875 -0.29736328125 -0.29248046875 0.0289306640625 -0.12152099609375 -0.001251220703125 -0.0276031494140625 0.0015192031860351562 0.022796630859375 -0.032806396484375 -0.325439453125 0.28076171875 -0.0489501953125
135 6274A881-9445-44D6-9E7C-776DAEF1C603 2017-12-16T11:51:31+00:00 
[
    "Public"
]
 
[]
 heic 3eb13ed43499313a2db919adf2b109b55dd49377096ac3edc35444b735a95b69 2120984 51.503355 -0.13211666666666666 0 0 0 0 0 0 0 0 London England United Kingdom 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
415 48EECE84-27A5-4AEC-9B09-6173F8700CEA 2017-12-16T11:51:09+00:00 
[
    "Public"
]
 
[]
 heic d1f5ff1dc55f467cc316d31897840e7ab50a1894823780b56c36e9ee6bda5c08 1806032 51.503303333333335 -0.1321805 0 0 0 0 0 0 0 0 London England United Kingdom 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375

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