photos_with_apple_metadata (view)

33 rows where ZINTERACTIONSCORE = "0.019999999552965164" and ext = "jpeg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, favorite, place_city, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, date (date), albums (array)

ext ✖

  • jpeg · 33 ✖

ZINTERACTIONSCORE ✖

  • 0.019999999552965164 · 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
254 8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 2020-04-23T19:57:00+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg 7c22edd556267a6ee4b7016590064b1575aaaeb430dcfa674acfa5934eae85d9 8164899     1 0 0 0 0 0 0 0       8B61EC59-ABEC-4C3A-BCB4-2F11D02CD3A0 0.443115234375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.018951416015625 0.0059814453125 0.019999999552965164 -0.01611328125 -0.056549072265625 0.10302734375 0.011199951171875 -0.01525115966796875 -0.0132904052734375 -0.09503173828125 -0.0242919921875 0.06646728515625 0.053741455078125 0.005584716796875 -0.01021575927734375 0.00646209716796875 0.037689208984375 0.017913818359375 -0.04901123046875 0.292236328125 0.03363037109375
444 0CEC9F87-56B8-4E82-885D-CE573A5A6733 2020-04-23T19:26:40+00:00 
[
    "Photography homework composition April 2020",
    "Public"
]
 
[]
 jpeg e19325bdaa3af04606d769494a62518ac08b5978677831eae415b73e4d05ae0a 8097615     1 0 0 0 0 0 0 0       0CEC9F87-56B8-4E82-885D-CE573A5A6733 0.2744140625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00217437744140625 0.031585693359375 0.001789093017578125 0.019999999552965164 0.165283203125 -0.072265625 0.1336669921875 0.00885009765625 -0.01142120361328125 0.0089263916015625 0.01983642578125 0.08697509765625 0.036346435546875 0.1024169921875 -0.00299072265625 -0.00263214111328125 0.001964569091796875 0.2469482421875 0.583984375 0.1607666015625 0.599609375 0.2371826171875
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
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
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
74 3295CB6A-D459-45C2-8E45-9FBBDCF80266 2019-08-20T05:56:46+00:00 
[
    "To Instagram",
    "Public"
]
 
[]
 jpeg 21f932155ee348af51628849af6626b7a6f5ffafd5eda45b6196ada242ae647b 6094145     1 0 0 0 0 0 0 0       3295CB6A-D459-45C2-8E45-9FBBDCF80266 0.751953125 0.75 0.0 0.06263145190158872 0.5050121545791626 -0.0012111663818359375 0.043670654296875 0.00313568115234375 0.019999999552965164 0.640625 -0.046539306640625 0.0594482421875 0.0136871337890625 -0.0062408447265625 0.00662994384765625 0.28125 0.18310546875 0.03436279296875 0.207763671875 0.017669677734375 0.0028400421142578125 0.006145477294921875 0.2890625 0.537109375 0.179443359375 0.728515625 0.51416015625
358 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 2018-02-13T18:53:52+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg adc26d4f5ae813f2a5a6281653f515dc245ff351973f99c342bb23015a175d48 5176004 25.737328762300947 -111.09098016188648 0 0 0 0 0 0 0 0     Mexico 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 0.78125 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.0012254714965820312 0.042755126953125 0.00279998779296875 0.019999999552965164 -0.191650390625 -0.05987548828125 0.419189453125 0.00734710693359375 -0.013427734375 -0.05120849609375 -0.2137451171875 0.0130615234375 0.5712890625 0.00146484375 0.0055694580078125 -0.016815185546875 0.0070953369140625 0.0709228515625 0.15087890625 -0.163330078125 0.04150390625 -0.0222625732421875
269 7705FF4E-2F25-45B9-B795-EA58244F3273 2018-02-13T18:53:28+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 81f94d4de59b28e89df4ff8ac3a7250e624cbd261e7d93701e6a8cafeeeb971e 5483241 25.737587971741938 -111.09106443298224 0 0 0 0 0 0 0 0     Mexico 7705FF4E-2F25-45B9-B795-EA58244F3273 0.708984375 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.06915283203125 -0.00589752197265625 0.00208282470703125 0.019999999552965164 -0.390869140625 -0.14306640625 -0.1083984375 0.0775146484375 -0.12322998046875 -0.06463623046875 -0.58837890625 -0.66650390625 0.024566650390625 -0.1026611328125 -0.0028285980224609375 -0.06109619140625 0.0018100738525390625 0.00464630126953125 -0.52734375 -0.286376953125 -0.095458984375 -0.10565185546875
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
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
420 60198E20-708E-4125-B793-4466A87B2DDA 2017-06-16T00:56:17+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22 5956608 37.76925 -122.46415 0 0 0 0 0 0 0 0 San Francisco CA United States 60198E20-708E-4125-B793-4466A87B2DDA 0.392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00307464599609375 0.0094757080078125 0.001220703125 0.019999999552965164 0.1380615234375 -0.056854248046875 0.2802734375 0.00313568115234375 -0.04559326171875 -0.04010009765625 -0.107666015625 -0.0838623046875 0.048492431640625 -0.160400390625 0.00628662109375 -0.0150909423828125 0.0010166168212890625 0.060760498046875 0.06494140625 -0.0399169921875 0.345947265625 -0.05755615234375
438 57650917-1883-4D73-AD2B-B45C6A661534 2017-03-31T00:53:31+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c 4243346 37.769146666666664 -122.46449166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 57650917-1883-4D73-AD2B-B45C6A661534 0.3447265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0022525787353515625 0.00321197509765625 0.004627227783203125 0.019999999552965164 -0.00634765625 -0.1229248046875 0.0634765625 0.00844573974609375 -0.0203704833984375 -0.053375244140625 -0.448974609375 -0.152587890625 0.0966796875 -0.019805908203125 -0.00054168701171875 -0.01448822021484375 0.00441741943359375 0.0119171142578125 -0.027587890625 -0.298583984375 -0.009033203125 0.0059814453125
492 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 2017-03-31T00:48:54+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375 4984812 37.7692 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States D3CF77DA-B6DD-47F1-A69C-3E01122F133E 0.497314453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.002002716064453125 0.0117950439453125 0.002010345458984375 0.019999999552965164 -0.28369140625 -0.018341064453125 0.296630859375 0.002132415771484375 -0.038604736328125 -0.031494140625 -0.022735595703125 -0.041351318359375 0.188232421875 -0.038330078125 0.0035552978515625 -0.016143798828125 0.00455474853515625 0.07452392578125 0.034332275390625 0.2244873046875 0.4072265625 -0.01230621337890625
191 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2016-11-05T21:21:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5f9968989d0aad8a9dd9c6aabd5e495444a44a8714a1fa3296a96132b67de178 2555246 37.82716333333333 -122.52745833333333 0 0 0 0 0 0 0 0 Sausalito CA United States 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125
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
219 3C683CF5-1644-412C-AA01-F6A2EAE58319 2015-10-05T15:01:36+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6d2e02585f44104e7d40f2e1fc471bafe4fef77c91e130d09eb7fd2db8aba4b6 3487122 35.716544999999996 -83.50289333333333 0 0 0 0 0 0 0 0 Gatlinburg TN United States 3C683CF5-1644-412C-AA01-F6A2EAE58319 0.728515625 0.5 0.0 0.04353355223895939 0.10000000149011612 -0.00263214111328125 0.01399993896484375 0.001934051513671875 0.019999999552965164 0.07373046875 -0.137939453125 0.07965087890625 0.010406494140625 -0.01363372802734375 -0.016876220703125 -0.309814453125 -0.050537109375 0.0301513671875 0.03619384765625 0.0016632080078125 -0.00664520263671875 0.0018892288208007812 0.08282470703125 0.1552734375 -0.134521484375 0.359375 0.1292724609375
86 B426930E-FED6-4916-BBB9-73934393B5C8 2015-10-05T14:48:06+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 2512ce4ad5e082d62744af9268e903dde304867ff95f8782c0da3925835ff1ac 3416230     0 0 0 0 0 0 0 0       B426930E-FED6-4916-BBB9-73934393B5C8 0.3740234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.0109710693359375 0.0017137527465820312 0.019999999552965164 0.400390625 -0.044525146484375 0.01666259765625 0.030792236328125 -0.0701904296875 -0.0020904541015625 0.03350830078125 -0.1026611328125 0.021820068359375 0.078369140625 0.003688812255859375 -0.0031890869140625 0.004024505615234375 0.08648681640625 0.02398681640625 0.042236328125 0.68115234375 0.265869140625

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