photos_with_apple_metadata (view)

32 rows where "date" is on date 2020-01-25 and ext = "jpeg" sorted by ZPLEASANTREFLECTIONSSCORE descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

ext ✖

  • jpeg · 32 ✖

date (date) ✖

  • 2020-01-25 · 32 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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