photos_with_apple_metadata (view)

45 rows where "date" is on date 2020-01-25 sorted by ZIMMERSIVENESSSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

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

date (date) ✖

  • 2020-01-25 · 45 ✖
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
287 745C8ADF-08E9-48D1-98A7-01D16E49635C 2020-01-25T18:05:50+00:00 
[
    "Public"
]
 
[]
 heic 8a2c43b2888b0777a9ffa4679f13011b3bd91cd57c4fe34a5b612c1bc4ceb147 4185659 37.11481117 -122.32784167 1 0 0 0 0 0 0 0 Pescadero CA United States 745C8ADF-08E9-48D1-98A7-01D16E49635C 0.59765625 0.75 0.0 0.06111754988896028 0.10000000149011612 -0.0016870498657226562 0.003696441650390625 0.0010652542114257812 0.009999999776482582 -0.16259765625 -0.04876708984375 0.318115234375 0.0017547607421875 -0.020294189453125 -0.01739501953125 -0.154541015625 -0.04669189453125 0.061187744140625 -0.082275390625 -0.002925872802734375 -0.0231170654296875 0.0016040802001953125 0.0889892578125 0.076416015625 -0.24853515625 0.37939453125 -0.03521728515625
221 F367069B-2C5A-4C2E-BFCE-29AE79C72E73 2020-01-25T18:58:11+00:00 
[
    "Public"
]
 
[]
 jpeg 6f2595c2865301e8535ba3dee97fcb6ac321414e7989762856016992175c511f 6005431     1 0 0 0 0 0 0 0       F367069B-2C5A-4C2E-BFCE-29AE79C72E73 0.5732421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.002521514892578125 0.002841949462890625 0.0012941360473632812 0.009999999776482582 0.147705078125 -0.06756591796875 0.1873779296875 0.00473785400390625 -0.037384033203125 -0.025177001953125 -0.1666259765625 -0.1290283203125 0.04595947265625 -0.0789794921875 -0.00115203857421875 -0.01421356201171875 0.0018749237060546875 0.049041748046875 0.020660400390625 -0.311767578125 0.4150390625 -0.03570556640625
216 8482D147-E926-4B79-9264-533A31F5DF2D 2020-01-25T18:14:27+00:00 
[
    "Public"
]
 
[]
 heic 6b8ef6a1de38c5e897e740c407caa88bbe307b561dac970ccd9b58f870a1f85e 4030633 37.11621117 -122.32977999999999 1 0 0 0 0 0 0 0 Pescadero CA United States 8482D147-E926-4B79-9264-533A31F5DF2D 0.5576171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.003749847412109375 0.00057220458984375 0.0013990402221679688 0.009999999776482582 -0.48095703125 -0.0635986328125 -0.033203125 0.02685546875 -0.08740234375 -0.08880615234375 -0.287841796875 -0.361572265625 0.049224853515625 -0.068603515625 -0.0012836456298828125 -0.0191650390625 0.005321502685546875 0.0258636474609375 -0.032928466796875 -0.10052490234375 0.369873046875 -0.0089263916015625
340 B2D7A748-4171-43EA-8561-917E3A1007D4 2020-01-25T19:22:41+00:00 
[
    "Public"
]
 
[]
 jpeg a4e1151738c54fb914d1be6b4dbd1a9a73724b36e64024e2e9193257ea6aeeed 5058245     1 0 0 0 0 0 0 0       B2D7A748-4171-43EA-8561-917E3A1007D4 0.6318359375 0.75 0.0 0.06111624950671014 0.10000000149011612 -0.0035381317138671875 -0.002574920654296875 0.0014047622680664062 0.009999999776482582 0.32080078125 -0.0775146484375 0.0428466796875 0.0234222412109375 -0.06756591796875 -0.0242462158203125 -0.2017822265625 -0.34521484375 0.061187744140625 -0.03875732421875 -0.002887725830078125 -0.016510009765625 0.0034694671630859375 0.015960693359375 -0.0357666015625 -0.447265625 0.332763671875 -0.0322265625
10 87585FA7-EF4D-4028-97D2-21631F66A32D 2020-01-25T19:17:10+00:00 
[
    "Public"
]
 
[]
 jpeg 04646192855eb795b440552ad953dd63ed7ef4adece0bb85d42b19586a6e2c59 5296462     1 0 0 0 0 0 0 0       87585FA7-EF4D-4028-97D2-21631F66A32D 0.5302734375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0020751953125 -0.00121307373046875 0.0015010833740234375 0.009999999776482582 0.32666015625 -0.06439208984375 0.1422119140625 0.012054443359375 -0.056121826171875 -0.03155517578125 -0.16259765625 -0.2366943359375 0.092041015625 -0.05120849609375 -0.0021514892578125 -0.017608642578125 0.0036640167236328125 0.0169830322265625 -0.0141448974609375 -0.45458984375 0.3212890625 -0.041168212890625
322 AEFB3049-40B6-41FD-81AA-571B369B79DB 2020-01-25T19:12:52+00:00 
[
    "Public"
]
 
[]
 heic 9d24f646179a5110b384061d7911acf849957530304e5ac141b86edab4b7b3a0 3931472 37.11494717 -122.32808 1 0 0 0 0 0 0 0 Pescadero CA United States AEFB3049-40B6-41FD-81AA-571B369B79DB 0.57421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0116424560546875 -0.0101776123046875 0.0015544891357421875 0.009999999776482582 -0.122314453125 -0.060638427734375 0.0396728515625 0.01312255859375 -0.190673828125 -0.05352783203125 -0.320556640625 -0.4072265625 0.078369140625 -0.11199951171875 -0.00426483154296875 -0.020172119140625 0.0020503997802734375 0.005706787109375 -0.09417724609375 -0.496337890625 -0.0115966796875 -0.14990234375
190 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 2020-01-25T17:38:42+00:00 
[
    "Public"
]
 
[]
 heic 5f5bcb376b8fea54df152f57917140d8d71ea6528cb2582259967a6614077048 2742993 37.114983329999994 -122.32553833000001 1 0 0 0 0 0 0 0 Pescadero CA United States 20B906EB-2A5F-4660-AEF7-6E64D1C9D727 0.4208984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0012493133544921875 0.0186309814453125 0.0016107559204101562 0.009999999776482582 0.235107421875 -0.0975341796875 0.1732177734375 0.0165252685546875 -0.0266571044921875 -0.0413818359375 -0.244384765625 -0.07073974609375 0.09234619140625 -0.02294921875 0.00799560546875 -0.012939453125 0.0030879974365234375 0.048309326171875 0.033538818359375 -0.25537109375 0.279541015625 0.024658203125
186 EF60300F-550E-4921-BA04-EA972EEFF269 2020-01-25T18:07:06+00:00 
[
    "Public"
]
 
[]
 heic 5d27b85ff783a2fa1c9e9533157ffd680c06cb957206054aa25ee5786e49ba84 3606179 37.1148555 -122.32795000000002 1 0 0 0 0 0 0 0 Pescadero CA United States EF60300F-550E-4921-BA04-EA972EEFF269 0.3896484375 0.75 0.0 0.8213740458129016 0.10000000149011612 -0.0005860328674316406 0.007633209228515625 0.0016422271728515625 0.009999999776482582 0.35302734375 -0.04132080078125 0.366943359375 0.0018825531005859375 -0.0141143798828125 -0.004425048828125 -0.0386962890625 -0.04632568359375 0.0894775390625 -0.0194854736328125 0.0001678466796875 -0.024871826171875 0.0039005279541015625 0.047088623046875 0.019256591796875 -0.33984375 0.515625 -0.01910400390625
78 92BCC6F0-0144-4501-A78D-778B3E48BF39 2020-01-25T20:09:19+00:00 
[
    "Public"
]
 
[]
 jpeg 22772bd05c0d6e769ea86ebaa1b58ed1645b4eabc9dcc9fea052196954438fdc 7751570     1 0 0 0 0 0 0 0       92BCC6F0-0144-4501-A78D-778B3E48BF39 0.46826171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0017681121826171875 -0.00048828125 0.0016937255859375 0.07999999821186066 0.163818359375 -0.08270263671875 0.21875 0.006412506103515625 -0.0310821533203125 -0.04290771484375 -0.2724609375 -0.14111328125 0.205078125 -0.07684326171875 -0.002254486083984375 -0.0218658447265625 0.0035648345947265625 0.021820068359375 0.0149688720703125 -0.49609375 0.0904541015625 -0.0667724609375
197 3A19DB48-E962-4B82-9E26-57BDA6F34B8C 2020-01-25T16:58:40+00:00 
[
    "Public"
]
 
[]
 heic 63caca87e01761366f47b8c7e1a68dadb7b10d983c10a7df91e1ec945df987ac 877404 37.118902829999996 -122.30718833 1 0 0 0 0 0 0 0 Pescadero CA United States 3A19DB48-E962-4B82-9E26-57BDA6F34B8C 0.2022705078125 0.75 0.0 0.0580211847110559 0.10000000149011612 -0.0019044876098632812 0.0064697265625 0.0017271041870117188 0.009999999776482582 -0.8447265625 -0.050048828125 0.228759765625 0.0011692047119140625 -0.00878143310546875 -0.018585205078125 -0.230224609375 -0.0233154296875 0.042327880859375 -0.012542724609375 -0.0212860107421875 -0.01364898681640625 0.0016231536865234375 0.09515380859375 0.086669921875 0.0186767578125 0.28076171875 -0.0091094970703125
196 111A61B2-82D2-4D3D-8B38-7D6C4806C604 2020-01-25T19:07:18+00:00 
[
    "Public"
]
 
[]
 jpeg 639ea88d6253c88b10ff8b131e1845d276be62531c8c520b791f34fe905796bf 6193450     1 0 0 0 0 0 0 0       111A61B2-82D2-4D3D-8B38-7D6C4806C604 0.454345703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00359344482421875 -0.002674102783203125 0.0018243789672851562 0.009999999776482582 0.2333984375 -0.062103271484375 0.07958984375 0.0154266357421875 -0.09039306640625 -0.044921875 -0.182861328125 -0.30029296875 0.105224609375 -0.06201171875 -0.0027313232421875 -0.018280029296875 0.00424957275390625 0.0118255615234375 -0.038177490234375 -0.403076171875 0.25341796875 -0.0418701171875
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
310 F92B1415-1D5D-45A6-A736-54D988748BBF 2020-01-25T19:32:06+00:00 
[
    "Public"
]
 
[]
 jpeg 96bc3134c1bd2553c164f1eee6971a22ed15893dc5dabcc717fc1f72317e044a 5851617     1 0 0 0 0 0 0 0       F92B1415-1D5D-45A6-A736-54D988748BBF 0.5068359375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.030731201171875 0.00522613525390625 0.00208282470703125 0.009999999776482582 -0.45166015625 -0.199951171875 -0.006561279296875 0.033905029296875 -0.04132080078125 -0.09454345703125 -0.6005859375 -0.357666015625 0.0240936279296875 -0.1298828125 0.002777099609375 -0.021331787109375 0.0008692741394042969 0.020294189453125 -0.1363525390625 -0.057342529296875 -0.0946044921875 -0.033966064453125
434 C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 2020-01-25T19:22:04+00:00 
[
    "Public"
]
 
[]
 jpeg db785fae4d60624d0a90c7fc24ec36f2b6b95f6d158b42d8973210f3cabba91a 6428626     1 0 0 0 0 0 0 0       C9BFB4C2-DB70-4AA0-AC70-27DED1EB7C29 0.64501953125 0.75 0.0 0.06110269104251425 0.10000000149011612 -0.001972198486328125 0.003810882568359375 0.00208282470703125 0.009999999776482582 0.3271484375 -0.042022705078125 0.2122802734375 0.0031108856201171875 -0.0309600830078125 -0.0080718994140625 -0.04730224609375 -0.1087646484375 0.04803466796875 -0.0256805419921875 2.288818359375e-05 -0.01338958740234375 0.002704620361328125 0.039642333984375 0.016815185546875 -0.213623046875 0.50048828125 -0.026947021484375
47 40743ED8-8D41-4EF9-92A9-2194CFE8D5BA 2020-01-25T19:17:45+00:00 
[
    "Public"
]
 
[]
 jpeg 172d1ef80b625f543d4d1f38221735167d59f81d5d07bdaeca64d92dc916745d 10907342     1 0 0 0 0 0 0 0       40743ED8-8D41-4EF9-92A9-2194CFE8D5BA 0.6494140625 0.75 0.0 0.061120150198463265 0.10000000149011612 -0.005279541015625 0.01611328125 0.0020999908447265625 0.009999999776482582 -0.60986328125 -0.060089111328125 -0.115478515625 0.1246337890625 -0.05718994140625 -0.0340576171875 -0.120361328125 -0.29638671875 0.0265045166015625 0.1781005859375 0.006404876708984375 -0.00860595703125 0.0068511962890625 0.062225341796875 -0.011566162109375 0.0928955078125 0.46533203125 0.02056884765625
139 665B18F1-6E4A-436B-A415-11622E442B2C 2020-01-25T19:39:28+00:00 
[
    "Public"
]
 
[]
 jpeg 42819b1d0b26b476c552433396fecaf1be936248ced47197a9eed334600c24e1 5033561     1 0 0 0 0 0 0 0       665B18F1-6E4A-436B-A415-11622E442B2C 0.5908203125 0.75 0.0 0.06110454879644263 0.10000000149011612 -0.0010690689086914062 0.0222320556640625 0.0021991729736328125 0.07999999821186066 0.3505859375 -0.0982666015625 0.031463623046875 0.01016998291015625 -0.00809478759765625 -0.0009613037109375 -0.026611328125 0.0654296875 0.0167236328125 0.1898193359375 0.01091766357421875 -0.001750946044921875 0.0030040740966796875 0.1026611328125 0.107666015625 0.0660400390625 0.53173828125 0.270751953125
177 22ADB1EE-854B-43F0-96D1-32CB598C0738 2020-01-25T18:37:22+00:00 
[
    "Public"
]
 
[]
 heic 59340b9b577670a6302885117a05ce7103e612748d3de0908dcc7dd3abb232c9 2491863 37.11635832999999 -122.33049667 1 0 0 0 0 0 0 0 Pescadero CA United States 22ADB1EE-854B-43F0-96D1-32CB598C0738 0.51220703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0011739730834960938 0.01096343994140625 0.0024814605712890625 0.009999999776482582 -0.0811767578125 -0.0809326171875 0.170654296875 0.0035648345947265625 -0.015777587890625 -0.05615234375 -0.2587890625 -0.0595703125 0.10723876953125 -0.0213623046875 0.0020751953125 -0.01378631591796875 0.004100799560546875 0.042236328125 0.01824951171875 -0.154296875 0.2166748046875 -0.0029296875
441 BCAEC510-5871-42B9-9A19-C5FB587F61FA 2020-01-25T16:57:07+00:00 
[
    "Public"
]
 
[]
 heic e02df647bbc0ccc62c05a275c54edeb0529fc7032b182ec91a69556b70a7fa8e 1304263 37.11899167 -122.307175 1 0 0 0 0 0 0 0 Pescadero CA United States BCAEC510-5871-42B9-9A19-C5FB587F61FA 0.46435546875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0182342529296875 0.000316619873046875 0.0025310516357421875 0.009999999776482582 -0.9462890625 -0.08282470703125 -0.208740234375 0.009857177734375 -0.0316162109375 -0.032440185546875 -0.36083984375 -0.591796875 0.01029205322265625 0.003509521484375 -0.006435394287109375 -0.0160064697265625 0.0036067962646484375 0.01024627685546875 -0.20556640625 0.047607421875 0.187744140625 -0.0001983642578125
377 82A06650-7B8E-4201-B971-3DE78335B82C 2020-01-25T19:22:02+00:00 
[
    "Public"
]
 
[]
 jpeg b95d5a4455b8a51754ee4967c137988efd1e2044ee15e2a5439b7efbde4de662 5892329     1 0 0 0 0 0 0 0       82A06650-7B8E-4201-B971-3DE78335B82C 0.6015625 0.75 0.0 0.06112200749739436 0.10000000149011612 -0.0011119842529296875 0.0006866455078125 0.0025501251220703125 0.009999999776482582 -0.0550537109375 -0.09332275390625 0.181640625 0.00455474853515625 -0.019195556640625 -0.06591796875 -0.392578125 -0.126220703125 0.131103515625 -0.0633544921875 -0.0030670166015625 -0.030914306640625 0.0038394927978515625 0.01322174072265625 -0.00286865234375 -0.4267578125 -0.038818359375 -0.038116455078125
147 3504AC65-3614-451D-BE1A-F49B6CEB5E10 2020-01-25T19:58:43+00:00 
[
    "Public"
]
 
[]
 jpeg 4680cd4fb84a80defcdf6d6f65856a9b4a2e530096bfc0589f4a86c60ee56b2c 7103284     1 0 0 0 0 0 0 0       3504AC65-3614-451D-BE1A-F49B6CEB5E10 0.6123046875 0.75 0.0 0.06111884981621313 0.5063990354537964 -0.0011882781982421875 0.048492431640625 0.002620697021484375 0.009999999776482582 0.62109375 -0.040985107421875 0.092041015625 0.06536865234375 -0.0310211181640625 0.0171356201171875 0.1435546875 0.16357421875 0.03594970703125 0.1630859375 0.0496826171875 0.00411224365234375 0.00455474853515625 0.168212890625 0.1630859375 0.2236328125 0.705078125 0.43408203125
227 E087C09F-9D37-4E2E-8E42-215F0C773369 2020-01-25T18:48:02+00:00 
[
    "Public"
]
 
[]
 jpeg 719b12e1e7cef678ca95d941874adad4e0759d0fcdc4563ac3f40150e0a1813c 8366614     1 0 0 0 0 0 0 0       E087C09F-9D37-4E2E-8E42-215F0C773369 0.751953125 0.75 0.0 0.06264426735521272 0.10000000149011612 -0.0008625984191894531 0.01242828369140625 0.002811431884765625 0.009999999776482582 -0.403564453125 -0.02838134765625 0.1259765625 0.0038394927978515625 -0.01422882080078125 -0.005523681640625 0.0184326171875 -0.00054931640625 0.06866455078125 0.0753173828125 0.000644683837890625 -0.01145172119140625 0.00809478759765625 0.1044921875 0.032470703125 0.108154296875 0.58837890625 0.003204345703125
53 9AEC59F0-3F75-4204-B714-152B697AD6F0 2020-01-25T19:20:41+00:00 
[
    "Public"
]
 
[]
 jpeg 1a002a90928b3ebf1cfc5e4a2e274f9e8a14345a634cb05751ad1ce3da6b7c52 5012912     1 0 0 0 0 0 0 0       9AEC59F0-3F75-4204-B714-152B697AD6F0 0.62548828125 0.75 0.0 0.06110454879644263 0.10000000149011612 -0.00263214111328125 -0.005542755126953125 0.0029010772705078125 0.03999999910593033 -0.005126953125 -0.08978271484375 0.12939453125 0.00646209716796875 -0.04327392578125 -0.09356689453125 -0.4306640625 -0.2392578125 0.1856689453125 -0.10101318359375 -0.0021648406982421875 -0.0205535888671875 0.0036220550537109375 0.0050201416015625 -0.02783203125 -0.452880859375 -0.1956787109375 -0.0889892578125
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
416 2E3925D6-FB1F-49E4-A256-7D25B38E5E77 2020-01-25T19:37:50+00:00 
[
    "Public"
]
 
[]
 jpeg d23b781c34e27fe18532881ee293166328d8e1836ab6b50b1f70ea312b5e0aab 5532065     1 0 0 0 0 0 0 0       2E3925D6-FB1F-49E4-A256-7D25B38E5E77 0.5263671875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0017681121826171875 0.003124237060546875 0.003376007080078125 0.009999999776482582 -0.63232421875 -0.03753662109375 0.183837890625 0.001972198486328125 -0.0239105224609375 -0.08551025390625 -0.23046875 -0.079833984375 0.1666259765625 -0.06610107421875 -0.001552581787109375 -0.053802490234375 0.005344390869140625 0.02069091796875 0.00113677978515625 -0.03753662109375 0.025390625 -0.0134429931640625
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
323 CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC 2020-01-25T18:47:26+00:00 
[
    "Public"
]
 
[]
 jpeg 9d89e3a7d469140bbf6ce7d5aa86fd38aa0e2c9040182ad6dae708950826bd77 9009661     1 0 0 0 0 0 0 0       CDF1C18C-EAA3-4CEE-BEA5-2F772129E7EC 0.607421875 0.75 0.0 0.06111792116674758 0.10000000149011612 -0.0007948875427246094 0.0190582275390625 0.0035381317138671875 0.009999999776482582 -0.314208984375 -0.0230712890625 0.072021484375 0.01137542724609375 -0.015777587890625 -0.0007476806640625 0.154541015625 -0.005859375 0.1446533203125 0.1470947265625 0.0025482177734375 -0.00957489013671875 0.0276947021484375 0.1357421875 0.039886474609375 0.13623046875 0.7275390625 0.00957489013671875
328 270D8B7F-B413-477E-8B8A-E176CD4CFAAB 2020-01-25T20:14:58+00:00 
[
    "Public"
]
 
[]
 jpeg 9fd526078cb07a71f8c943f036ec2853498eb58be7aa1794a7a13b92e3cee893 7385215     1 0 0 0 0 0 0 0       270D8B7F-B413-477E-8B8A-E176CD4CFAAB 0.6982421875 0.75 0.0 0.06111773552785393 0.10000000149011612 -0.0006070137023925781 0.01513671875 0.0037078857421875 0.009999999776482582 -0.47802734375 -0.0216217041015625 0.1534423828125 0.00243377685546875 -0.0120086669921875 -0.0123443603515625 0.04833984375 0.00738525390625 0.0953369140625 0.0992431640625 0.002025604248046875 -0.015899658203125 0.01229095458984375 0.0753173828125 0.009674072265625 0.1370849609375 0.5419921875 0.001552581787109375
362 ECCE503B-E993-4A85-B489-BC54DB8A3B40 2020-01-25T18:59:11+00:00 
[
    "Public"
]
 
[]
 jpeg b1cd0517ea1ec79061b0bb36dc4edde23bc047fa51f4f9296094eb62998bb343 6220683     1 0 0 0 0 0 0 0       ECCE503B-E993-4A85-B489-BC54DB8A3B40 0.6611328125 0.75 0.0 0.06112145012571611 0.10000000149011612 -0.0010366439819335938 0.0161285400390625 0.00394439697265625 0.009999999776482582 0.1468505859375 -0.06097412109375 0.2861328125 0.005279541015625 -0.016021728515625 -0.028533935546875 -0.1756591796875 -0.028564453125 0.2139892578125 -0.005523681640625 -0.0040130615234375 -0.0117950439453125 0.004810333251953125 0.021453857421875 0.0137176513671875 -0.29931640625 0.0784912109375 0.01190185546875
327 4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 2020-01-25T19:45:34+00:00 
[
    "Public"
]
 
[]
 jpeg 9f498cd0be0d5dcd46726651f0a3124f26218483c8dea3749507a4867ab325bd 5827512     1 0 0 0 0 0 0 0       4ABA19BB-4FAA-4A65-A79E-BAEE455ACA00 0.6240234375 0.75 0.0 0.06109860516686476 0.10000000149011612 -0.00034737586975097656 0.0128173828125 0.00395965576171875 0.009999999776482582 -0.19140625 -0.0374755859375 0.2568359375 0.0023784637451171875 -0.007843017578125 -0.013397216796875 -0.09765625 0.03204345703125 0.2281494140625 0.043853759765625 0.000957489013671875 -0.0231170654296875 0.01348114013671875 0.04534912109375 0.0098876953125 -0.172607421875 0.347412109375 -0.00164031982421875
52 BB3FF61C-1AE0-4B7F-AD0E-822267EE277A 2020-01-25T20:15:08+00:00 
[
    "Public"
]
 
[]
 jpeg 19ced52283f89efaa5aa883ab9394006f5416650b6e68de75775e449886fffeb 6758602     1 0 0 0 0 0 0 0       BB3FF61C-1AE0-4B7F-AD0E-822267EE277A 0.65625 0.75 0.0 0.06111754988896028 0.10000000149011612 -0.0011653900146484375 0.03643798828125 0.004573822021484375 0.009999999776482582 0.135009765625 -0.07904052734375 0.26708984375 0.0185394287109375 -0.0115966796875 -0.039031982421875 -0.2294921875 -0.0472412109375 0.18505859375 0.02667236328125 -0.00054931640625 -0.0209503173828125 0.00812530517578125 0.0225067138671875 0.0020751953125 -0.340576171875 0.122802734375 0.04376220703125
335 9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 2020-01-25T19:22:55+00:00 
[
    "Public"
]
 
[]
 jpeg a29c3a38ab84cb5a9158d2d1f5047f614c3065bc852042909e5ac09a59988275 5399639     1 0 0 0 0 0 0 0       9B1D1359-1267-42DE-BB2C-6DB3B885D3E0 0.46875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0006771087646484375 0.032440185546875 0.00464630126953125 0.009999999776482582 -0.192138671875 -0.0174407958984375 0.354248046875 0.001056671142578125 -0.008544921875 -0.00421142578125 0.0537109375 0.05224609375 0.07861328125 0.060516357421875 0.00852203369140625 -0.0089111328125 0.00469970703125 0.08929443359375 0.027984619140625 0.271240234375 0.461181640625 0.0001983642578125
352 26FB982C-7AE2-44C4-8743-4611F9FA8EE8 2020-01-25T19:00:21+00:00 
[
    "Public"
]
 
[]
 jpeg ab3b4adfb99b25cc51317bf712fff9c137adb06f2b3e7708b358c999dc2cad7d 7746045     1 0 0 0 0 0 0 0       26FB982C-7AE2-44C4-8743-4611F9FA8EE8 0.59130859375 0.75 0.0 0.06111754988896028 0.10000000149011612 -0.0016231536865234375 0.019073486328125 0.00494384765625 0.009999999776482582 -0.0460205078125 -0.06744384765625 0.25634765625 0.00867462158203125 -0.0177154541015625 -0.03045654296875 -0.246826171875 -0.0267333984375 0.1591796875 -0.001983642578125 -0.013824462890625 -0.009918212890625 0.0037364959716796875 0.022247314453125 0.0163421630859375 -0.27490234375 -0.0108642578125 0.011962890625
130 BA466D66-989B-4E8B-9553-85D91421A124 2020-01-25T19:29:49+00:00 
[
    "Public"
]
 
[]
 jpeg 3bfaee669a60e68459cd2a6301cbd8f919a22c8aa8b16c9bcf922b00684bacca 6274922     1 0 0 0 0 0 0 0       BA466D66-989B-4E8B-9553-85D91421A124 0.70263671875 0.75 0.0 0.06262606564368911 0.10000000149011612 -0.00208282470703125 0.003932952880859375 0.004962921142578125 0.009999999776482582 -0.748046875 -0.021697998046875 0.1973876953125 0.0006666183471679688 -0.0141754150390625 -0.015594482421875 -0.07763671875 -0.0440673828125 0.04986572265625 -0.003753662109375 -0.0113983154296875 -0.0113372802734375 0.00307464599609375 0.0268096923828125 5.340576171875e-05 0.09686279296875 0.214599609375 -0.007381439208984375
465 4B150041-A82D-498B-9C21-A3664E3EE796 2020-01-25T19:42:30+00:00 
[
    "Public"
]
 
[]
 jpeg eadaf1d75482cf7d03028aef7ddaf7e9586a0b5d45065ec002823411d525deb4 5951301     1 0 0 0 0 0 0 0       4B150041-A82D-498B-9C21-A3664E3EE796 0.65625 0.75 0.0 0.061110306332129556 0.10000000149011612 -0.001941680908203125 0.01409912109375 0.0059814453125 0.009999999776482582 -0.35302734375 -0.10284423828125 0.001708984375 0.02288818359375 -0.0110321044921875 -0.0158233642578125 -0.2626953125 -0.07421875 0.0318603515625 0.0841064453125 0.00275421142578125 -0.01221466064453125 0.006389617919921875 0.044677734375 0.029083251953125 -0.051971435546875 0.247802734375 0.024688720703125
154 5677D0CE-249B-4A35-BAF8-385BFC257924 2020-01-25T18:10:45+00:00 
[
    "Public"
]
 
[]
 heic 4a622a5c958ecba31c02dfdeff721c261c59b7d3d08124e50d4add1e85f5e5d4 6296397 37.11521117 -122.32787167 1 0 0 0 0 0 0 0 Pescadero CA United States 5677D0CE-249B-4A35-BAF8-385BFC257924 0.7021484375 0.75 0.0 0.06264965361311235 0.10000000149011612 -0.00263214111328125 0.04296875 0.007289886474609375 0.009999999776482582 0.060546875 -0.0701904296875 0.12158203125 0.09771728515625 -0.023651123046875 -0.031158447265625 -0.310791015625 0.005859375 0.15625 0.0482177734375 0.025909423828125 -0.00234222412109375 0.004467010498046875 0.018768310546875 0.0256195068359375 -0.12890625 -0.16357421875 0.046478271484375
202 0C053200-BD3D-4E69-B987-97D9027357B6 2020-01-25T19:03:32+00:00 
[
    "Public"
]
 
[]
 jpeg 65b2d4d5f0693ef127465fad373af915e4db5df063dababcb0fb9a1b12e0a351 5218889     1 0 0 0 0 0 0 0       0C053200-BD3D-4E69-B987-97D9027357B6 0.5869140625 0.75 0.0 0.06111996410457232 0.10000000149011612 -0.0009965896606445312 0.03253173828125 0.007518768310546875 0.009999999776482582 -0.417236328125 -0.061981201171875 0.10888671875 0.0135345458984375 -0.0104522705078125 -0.09515380859375 -0.2369384765625 -0.03076171875 0.224365234375 0.1480712890625 0.0130462646484375 -0.02838134765625 0.01525115966796875 0.0216217041015625 0.00318145751953125 -0.028045654296875 -0.00390625 0.00098419189453125
446 918F5128-ED51-4B1D-AA2C-2F14620312D9 2020-01-25T19:33:14+00:00 
[
    "Public"
]
 
[]
 jpeg e2b0909125998e92b5706502750d803bc015626f46245dc6200485596ceaa9fd 6170843     1 0 0 0 0 0 0 0       918F5128-ED51-4B1D-AA2C-2F14620312D9 0.57861328125 0.75 0.0 0.061101019837474096 0.10000000149011612 -0.004070281982421875 0.000705718994140625 0.00806427001953125 0.009999999776482582 -0.56787109375 -0.0638427734375 0.0030517578125 0.00989532470703125 -0.042724609375 -0.07275390625 -0.401611328125 -0.247314453125 0.1795654296875 -0.01953125 -0.0017490386962890625 -0.0150146484375 0.00806427001953125 0.00579833984375 -0.0257415771484375 -0.0660400390625 -0.209228515625 -0.00969696044921875
418 EA3A8FC2-1DB9-4906-B822-6FF0EABF625F 2020-01-25T18:52:28+00:00 
[
    "Public"
]
 
[]
 jpeg d3f48a9446d71b64f463675a11cfab4ef085b6896b185b7120daa151b946bb79 5676312     1 0 0 0 0 0 0 0       EA3A8FC2-1DB9-4906-B822-6FF0EABF625F 0.5693359375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001926422119140625 0.0110931396484375 0.00881195068359375 0.009999999776482582 -0.0911865234375 -0.039642333984375 0.021240234375 0.01302337646484375 -0.0330810546875 -0.01708984375 -0.04541015625 -0.11285400390625 0.0360107421875 0.04541015625 0.003551483154296875 -0.00506591796875 0.006313323974609375 0.0164642333984375 -0.00704193115234375 0.0286865234375 0.219970703125 0.03277587890625
32 A8B85D87-3E69-402E-A1EA-3DD819270531 2020-01-25T18:09:33+00:00 
[
    "Public"
]
 
[]
 heic 1307ecb271a8f7357b7151de2cd5cbec2e7232d91a2404daa5a716c0d96b4fc9 5610042 37.115119500000006 -122.32771333000001 1 0 0 0 0 0 0 0 Pescadero CA United States A8B85D87-3E69-402E-A1EA-3DD819270531 0.5947265625 0.75 0.0 0.06265151091204345 0.5026764273643494 -0.00031256675720214844 0.032470703125 0.00885009765625 0.009999999776482582 0.29931640625 -0.046112060546875 0.037750244140625 0.01751708984375 -0.00701141357421875 0.006439208984375 0.2320556640625 0.2288818359375 0.0635986328125 0.2149658203125 0.01354217529296875 0.0011444091796875 0.0219879150390625 0.08123779296875 0.023406982421875 0.01483154296875 0.54931640625 0.11541748046875
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
39 B5AC8228-D496-43B3-9F69-69BFB2BFF177 2020-01-25T18:16:15+00:00 
[
    "Public"
]
 
[]
 heic 14620230b833ea022fdbed283eae903ae8e82fe27e943d5fc1fe0f502f6e9e6e 3583698 37.11623049999999 -122.33001667 1 0 0 0 0 0 0 0 Pescadero CA United States B5AC8228-D496-43B3-9F69-69BFB2BFF177 0.62109375 0.75 0.0 0.061121264486822466 0.10000000149011612 -0.0017480850219726562 0.048736572265625 0.0202484130859375 0.009999999776482582 -0.248046875 -0.0305633544921875 0.20751953125 0.00482940673828125 -0.00885009765625 -0.03643798828125 -0.0546875 0.0264892578125 0.11395263671875 0.09771728515625 0.022735595703125 -0.008148193359375 0.007373809814453125 0.0240478515625 0.01015472412109375 0.0221405029296875 -0.02423095703125 -0.0031585693359375
27 2693563F-47A0-44FB-8AAA-5C550F793ACF 2020-01-25T18:59:12+00:00 
[
    "Public"
]
 
[]
 jpeg 10be54c63218a152006e95a6dd30016c39928fbf3bf7ae688bf4fc251a018e7b 6476888     1 0 0 0 0 0 0 0       2693563F-47A0-44FB-8AAA-5C550F793ACF 0.58251953125 0.75 0.0 0.06111754988896028 0.5025790929794312 -0.00014770030975341797 0.029327392578125 0.02423095703125 0.009999999776482582 0.461181640625 -0.023956298828125 0.04034423828125 0.00864410400390625 -0.00582122802734375 0.0140380859375 0.442626953125 0.154052734375 0.34912109375 0.380859375 0.01399993896484375 -0.0012359619140625 0.2022705078125 0.06829833984375 0.00632476806640625 0.01263427734375 0.6279296875 0.01904296875
127 A7B4A20F-E043-4229-A913-6EE1B2679D8C 2020-01-25T18:59:14+00:00 
[
    "Public"
]
 
[]
 jpeg 3bc6d33c08d4a70a442c7b1cee387f841108de0b8a242f6df8d13796c179051a 5930965     1 0 0 0 0 0 0 0       A7B4A20F-E043-4229-A913-6EE1B2679D8C 0.5947265625 0.75 0.0 0.06110269104251425 0.5034793019294739 -0.0003936290740966797 0.054351806640625 0.0374755859375 0.009999999776482582 0.0087890625 -0.02685546875 0.2066650390625 0.0034160614013671875 -0.004573822021484375 -0.012481689453125 0.110595703125 0.1519775390625 0.2254638671875 0.191650390625 0.0245208740234375 -0.00310516357421875 0.0289764404296875 0.0272674560546875 0.00542449951171875 0.007781982421875 0.11492919921875 0.0066986083984375
295 75769611-9E07-4AD8-B4E5-EADBB49A24B6 2020-01-25T19:24:51+00:00 
[
    "Public"
]
 
[]
 jpeg 8e11c96572a7adaf0336e8c28efda0bd88625e1d52f599edf3ec18e8ef6c3e6a 6477627     1 0 0 0 0 0 0 0       75769611-9E07-4AD8-B4E5-EADBB49A24B6 0.62890625 0.75 0.0 0.06112145012571611 0.5028467178344727 -0.0005154609680175781 0.04217529296875 0.047698974609375 0.009999999776482582 0.0521240234375 -0.0273284912109375 0.1328125 0.006168365478515625 -0.006744384765625 -0.007568359375 0.1033935546875 0.180908203125 0.2493896484375 0.1846923828125 0.030029296875 -0.00054931640625 0.0313720703125 0.0229339599609375 0.007598876953125 0.000762939453125 0.05804443359375 0.01450347900390625
15 4DC7BCE0-2E5D-49CC-8E53-7925D151C515 2020-01-25T18:52:36+00:00 
[
    "Public"
]
 
[]
 jpeg 080ccfeebd505833d5594b97dcb6cc3a5150d21b67dfe52cd7dbd3107f42adb7 7302323     1 0 0 0 0 0 0 0       4DC7BCE0-2E5D-49CC-8E53-7925D151C515 0.57666015625 0.75 0.0 0.06111699251728203 0.10051094740629196 -0.00010973215103149414 0.051239013671875 0.05572509765625 0.009999999776482582 0.53125 -0.0179901123046875 0.040679931640625 0.007205963134765625 -0.00313568115234375 0.0148162841796875 0.59716796875 0.264892578125 0.55712890625 0.5400390625 0.02410888671875 0.00438690185546875 0.33642578125 0.0709228515625 0.01120758056640625 0.038970947265625 0.4921875 0.0167999267578125

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