photos_with_apple_metadata (view)

45 rows where "date" is on date 2020-01-25

View and edit SQL

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

rowid photo uuid date albums persons ext sha256 size latitude longitude favorite portrait screenshot slow_mo time_lapse hdr selfie panorama place_city place_state_province place_country ZUUID ZOVERALLAESTHETICSCORE ZCURATIONSCORE ZPROMOTIONSCORE ZHIGHLIGHTVISIBILITYSCORE ZBEHAVIORALSCORE ZFAILURESCORE ZHARMONIOUSCOLORSCORE ZIMMERSIVENESSSCORE ZINTERACTIONSCORE ZINTERESTINGSUBJECTSCORE ZINTRUSIVEOBJECTPRESENCESCORE ZLIVELYCOLORSCORE ZLOWLIGHT ZNOISESCORE ZPLEASANTCAMERATILTSCORE ZPLEASANTCOMPOSITIONSCORE ZPLEASANTLIGHTINGSCORE ZPLEASANTPATTERNSCORE ZPLEASANTPERSPECTIVESCORE ZPLEASANTPOSTPROCESSINGSCORE ZPLEASANTREFLECTIONSSCORE ZPLEASANTSYMMETRYSCORE ZSHARPLYFOCUSEDSUBJECTSCORE ZTASTEFULLYBLURREDSCORE ZWELLCHOSENSUBJECTSCORE ZWELLFRAMEDSUBJECTSCORE ZWELLTIMEDSHOTSCORE
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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