photos_with_apple_metadata (view)

39 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.05801526718694745" and albums = "["Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, longitude, place_city, place_state_province, place_country, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array), persons (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
222 A05FA28C-4192-4430-A597-21FC5A10BEEE 2020-02-22T23:09:17+00:00 
[
    "Public"
]
 
[]
 jpeg 6f78d9316fea65c2ec229415af66627a2f106b91e79e3a59cb621ce0ef6a8996 6011023     1 0 0 0 0 0 0 0       A05FA28C-4192-4430-A597-21FC5A10BEEE 0.5107421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018243789672851562 -0.00043487548828125 0.0027141571044921875 0.009999999776482582 -0.068359375 -0.07720947265625 0.170166015625 0.0079345703125 -0.029144287109375 -0.047027587890625 -0.339111328125 -0.1475830078125 0.125244140625 -0.048248291015625 -0.0052490234375 -0.03662109375 0.00464630126953125 0.0173797607421875 -0.0086822509765625 -0.49267578125 0.0789794921875 -0.03973388671875
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
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
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
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
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
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
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
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
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
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
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
49 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD 2020-01-21T01:14:26+00:00 
[
    "Public"
]
 
[]
 heic 18c0aa96d3614e986218af43cfd9a9cb3ae1806270091d1c8d4ea7f7f0b736d6 2215697 37.38205333 -122.193895 1 0 0 0 0 0 0 0 Portola Valley CA United States 5F1D5E64-6DEB-4F8B-8A93-F57514B2EDDD 0.53076171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0163421630859375 -0.0016937255859375 0.0035381317138671875 0.009999999776482582 -0.1805419921875 -0.1402587890625 -0.05560302734375 0.0472412109375 -0.06829833984375 -0.10205078125 -0.60107421875 -0.4970703125 0.058349609375 -0.0872802734375 -0.0017242431640625 -0.0164794921875 0.002216339111328125 0.002704620361328125 -0.192626953125 -0.203857421875 -0.286376953125 -0.0118408203125
118 973F76C4-33A5-4ADD-A896-8E9744AB177E 2020-01-14T05:40:24+00:00 
[
    "Public"
]
 
[]
 heic 38ed150fe0aaf4dfded5f144abecab5de247760a6bb2d41526b2dd8de0b11397 1391787 37.45085333 -122.18125833000002 1 0 0 0 0 0 0 0 Menlo Park CA United States 973F76C4-33A5-4ADD-A896-8E9744AB177E 0.43603515625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001674652099609375 0.00955963134765625 0.0020275115966796875 0.009999999776482582 -0.219970703125 -0.03985595703125 0.158935546875 0.02685546875 -0.037689208984375 -0.018951416015625 -0.11468505859375 -0.1063232421875 0.1466064453125 0.00421142578125 0.000213623046875 -0.04766845703125 0.0087432861328125 0.060302734375 0.0248260498046875 -0.19091796875 0.416748046875 -0.009124755859375
234 4989D148-E809-4B16-850E-E996339D7224 2020-01-14T05:38:46+00:00 
[
    "Public"
]
 
[]
 heic 73491bc0d6fe19177e620c11f66a2e70f417d5ed17210c64804f5362803946f4 1324680 37.450846670000004 -122.18125333 1 0 0 0 0 0 0 0 Menlo Park CA United States 4989D148-E809-4B16-850E-E996339D7224 0.40771484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006587982177734375 0.001239776611328125 0.0015249252319335938 0.05999999865889549 -0.5263671875 -0.08660888671875 -0.05682373046875 0.0310211181640625 -0.05224609375 -0.07977294921875 -0.3095703125 -0.477783203125 0.050323486328125 -0.04034423828125 -0.0011138916015625 -0.12060546875 0.00757598876953125 0.0194549560546875 -0.0555419921875 -0.09417724609375 0.325439453125 -0.0064544677734375
217 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 2019-12-29T10:40:51+00:00 
[
    "Public"
]
 
[]
 heic 6c260ecb0219bf7808f1a8ebf5e35aaaa15d395592a2ca050bebc42c703f7217 1711662 51.49035 -0.6723333300000001 1 0 0 0 0 0 0 0 Windsor England United Kingdom B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 0.472900390625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0006313323974609375 0.019256591796875 0.0034961700439453125 0.009999999776482582 -0.31689453125 -0.03521728515625 0.08013916015625 0.0169830322265625 -0.011688232421875 0.007171630859375 0.0731201171875 0.10430908203125 0.150390625 0.1519775390625 0.00537872314453125 -0.01264190673828125 0.0199432373046875 0.16650390625 0.100830078125 0.037353515625 0.6376953125 0.01389312744140625
487 BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 2019-12-28T10:55:13+00:00 
[
    "Public"
]
 
[]
 heic faec04a4c5576d2de8af17460c22c79fd1926e889e3d0073ea188994c82507ac 3569228 50.697155 -3.19187 1 0 0 0 0 0 0 0 Sidmouth England United Kingdom BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 0.49267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.024658203125 0.0289764404296875 0.009999999776482582 -0.22119140625 -0.033905029296875 0.13232421875 0.00392913818359375 -0.00916290283203125 -0.0421142578125 -0.09619140625 0.0260009765625 0.2198486328125 0.092041015625 0.010162353515625 -0.0087127685546875 0.0165863037109375 0.0103302001953125 -0.000217437744140625 -0.0215911865234375 -0.09661865234375 0.00095367431640625
164 659F6A3E-8547-476F-B2AA-883117C53253 2019-12-17T10:05:40+00:00 
[
    "Public"
]
 
[]
 heic 51f4b1c7d3691bd32170d7f1f343c25e4ce687a3474675501e5295fb8de1e233 2625105 51.52467832999999 -0.11347499999999999 1 0 0 0 0 0 0 0 London England United Kingdom 659F6A3E-8547-476F-B2AA-883117C53253 0.33251953125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006488800048828125 -0.0045318603515625 0.0008692741394042969 0.03999999910593033 0.53564453125 -0.09771728515625 -0.21630859375 0.0849609375 -0.233154296875 -0.0269775390625 -0.2191162109375 -0.67626953125 0.0322265625 -0.0523681640625 -0.0008630752563476562 -0.0160675048828125 0.0057525634765625 0.01142120361328125 -0.115234375 -0.48876953125 0.54541015625 -0.01934814453125
318 9ABD9958-31BE-4B9D-9480-7E3342B601FD 2019-10-30T20:34:50+00:00 
[
    "Public"
]
 
[]
 heic 9b4affb8f608930ee6f1b83fc86c66162c372a8e21ef4d2d4010fabaa627bec1 2376821 37.42704667 -122.167795 1 0 0 0 0 0 0 0 Stanford CA United States 9ABD9958-31BE-4B9D-9480-7E3342B601FD 0.377197265625 0.75 0.0 0.05801526718694745 0.7046471834182739 -0.0006589889526367188 0.09112548828125 0.00400543212890625 0.009999999776482582 0.572265625 -0.030670166015625 0.0860595703125 0.023651123046875 -0.006122589111328125 0.015655517578125 0.41943359375 0.34716796875 0.02691650390625 0.36865234375 0.0670166015625 0.014129638671875 0.0083465576171875 0.385986328125 0.37841796875 0.373779296875 0.78515625 0.341796875
36 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 2019-09-16T16:26:37+00:00 
[
    "Public"
]
 
[]
 heic 14101f33adc465139279ae9a80118d2b388f4350c9b1b5ed06596282646d000b 2027028 37.44983333333333 -122.1864 1 0 0 0 0 0 0 0 Menlo Park CA United States 5C91B5A8-1A4C-4406-B5E6-11883EFC714E 0.300048828125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.032806396484375 0.0007948875427246094 0.019999999552965164 -0.158447265625 -0.049957275390625 0.421630859375 0.0026721954345703125 -0.007904052734375 0.01885986328125 -0.05377197265625 0.057647705078125 0.08465576171875 0.02484130859375 0.0040283203125 -0.014495849609375 0.001934051513671875 0.43359375 0.56494140625 0.025390625 0.62744140625 -0.0088653564453125
277 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 2019-09-15T15:36:30+00:00 
[
    "Public"
]
 
[]
 heic 847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554 1716536 30.24152 -89.67729166666666 1 0 0 0 0 0 0 0 Slidell LA United States 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 0.5712890625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.016510009765625 0.008575439453125 0.03999999910593033 -0.235107421875 -0.05291748046875 0.2169189453125 0.00669097900390625 -0.01214599609375 -0.043487548828125 -0.1904296875 -0.03326416015625 0.430908203125 0.0216064453125 0.00054931640625 -0.0718994140625 0.0169830322265625 0.0224609375 0.0220794677734375 -0.1822509765625 -0.0218505859375 -0.0104827880859375
309 A34D9C15-11C6-488C-9E3C-910401A65132 2019-09-15T15:16:37+00:00 
[
    "Public"
]
 
[]
 heic 95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753 3537285 30.243796666666668 -89.68113 1 0 0 0 0 0 0 0 Slidell LA United States A34D9C15-11C6-488C-9E3C-910401A65132 0.47021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0036792755126953125 -0.00623321533203125 0.004573822021484375 0.009999999776482582 -0.17138671875 -0.05450439453125 0.2073974609375 0.0028896331787109375 -0.039794921875 -0.1051025390625 -0.3232421875 -0.1912841796875 0.39306640625 -0.091552734375 -0.002368927001953125 -0.1004638671875 0.0066680908203125 0.0038089752197265625 -0.022735595703125 -0.396484375 -0.28955078125 -0.07501220703125
2 BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 2019-09-15T13:41:17+00:00 
[
    "Public"
]
 
[]
 jpeg 01aeec21c49bfddd0980785d24f6c5a269c2fae92bc49aa1dcb592d8442cf6fd 7719757     1 0 0 0 0 0 0 0       BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 0.478271484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.003185272216796875 0.006916046142578125 0.0082550048828125 0.009999999776482582 -0.205078125 -0.091552734375 0.0966796875 0.00734710693359375 -0.025177001953125 -0.085205078125 -0.5166015625 -0.11151123046875 0.08416748046875 -0.055389404296875 0.0017242431640625 -0.0091552734375 0.0018968582153320312 0.004718780517578125 -0.01261138916015625 -0.13525390625 -0.422119140625 -0.012481689453125
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
184 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E 2019-09-15T12:44:16+00:00 
[
    "Public"
]
 
[]
 jpeg 5b2f88615086a37d0dcf66c5e60375212ed0f3927e8e720159524729f873bd41 5313920     1 0 0 0 0 0 0 0       36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E 0.48486328125 0.75 0.0 0.05801526718694745 0.5043065547943115 -0.0008559226989746094 0.022125244140625 0.0018825531005859375 0.03999999910593033 0.58203125 -0.05633544921875 0.005279541015625 0.06903076171875 -0.01267242431640625 0.0079498291015625 0.2421875 0.242919921875 0.011505126953125 0.1534423828125 0.0126800537109375 0.001617431640625 0.005535125732421875 0.373291015625 0.41796875 0.06787109375 0.84716796875 0.3896484375
282 7E07EFBF-1F63-4142-8856-7DCD9F906811 2019-09-14T16:27:56+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 1699486 29.941283333333335 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 7E07EFBF-1F63-4142-8856-7DCD9F906811 0.361328125 0.75 0.0 0.05801526718694745 0.5045255422592163 -0.0028228759765625 0.0236358642578125 0.002521514892578125 0.009999999776482582 0.42626953125 -0.0970458984375 -0.021026611328125 0.04168701171875 -0.00844573974609375 0.00287628173828125 0.1065673828125 0.0474853515625 0.01049041748046875 0.16552734375 0.0140838623046875 -7.2479248046875e-05 0.0039005279541015625 0.2330322265625 0.47900390625 0.10040283203125 0.71728515625 0.31689453125
493 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 2019-09-14T16:22:47+00:00 
[
    "Public"
]
 
[]
 heic febc9309036eecd044283deed4492854256af6ad195f9c71165e60928633e57f 2389075 29.940883333333332 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 43214F71-0B9A-4F8A-AA37-BD30EBF549AA 0.38916015625 0.75 0.0 0.05801526718694745 0.5048418641090393 -0.0014162063598632812 0.0150604248046875 0.0013723373413085938 0.009999999776482582 0.6552734375 -0.06805419921875 -0.011138916015625 0.07666015625 -0.019012451171875 0.007720947265625 0.179931640625 0.1343994140625 0.010650634765625 0.14306640625 0.01058197021484375 0.000843048095703125 0.00424957275390625 0.370849609375 0.54052734375 0.04827880859375 0.83251953125 0.434326171875
308 43E95407-6F45-460A-830E-079C0F149D67 2019-09-08T02:10:46+00:00 
[
    "Public"
]
 
[]
 heic 952749cd5456be2452b60fc372a814e81c62f4627a0e34b58983b575ca297be4 999594 29.950541666666666 -90.0704945 1 0 0 0 0 0 0 0 New Orleans LA United States 43E95407-6F45-460A-830E-079C0F149D67 0.1934814453125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.07598876953125 -0.00316619873046875 0.007232666015625 0.009999999776482582 -0.708984375 -0.033599853515625 0.02911376953125 0.006587982177734375 -0.15673828125 -0.042510986328125 -0.26220703125 -0.35888671875 0.0234222412109375 -0.09771728515625 -0.0074005126953125 -0.0184173583984375 0.0007762908935546875 0.0030994415283203125 -0.169189453125 0.00262451171875 -0.27099609375 -0.047454833984375
468 D15F85D9-D70A-4182-AC30-BCA0EA2AF542 2019-08-25T12:13:59+00:00 
[
    "Public"
]
 
[]
 heic ec3603bcb38d0cd7d2f90c7ba44de83f2f149c0a36a57cae9a5e7aff638327a8 1887278 48.84311666666667 2.3632866666666668 1 0 0 0 0 0 0 0 Paris Île-de-France France D15F85D9-D70A-4182-AC30-BCA0EA2AF542 0.53662109375 0.75 0.0 0.05801526718694745 0.10090024769306183 -0.00025725364685058594 0.05633544921875 0.0023326873779296875 0.009999999776482582 0.12109375 -0.0265045166015625 0.24267578125 0.00345611572265625 -0.004451751708984375 0.0234375 0.2171630859375 0.20166015625 0.062103271484375 0.302490234375 0.01715087890625 -0.00290679931640625 0.00841522216796875 0.40625 0.1768798828125 0.2003173828125 0.763671875 0.025787353515625
51 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 2019-08-25T12:11:16+00:00 
[
    "Public"
]
 
[]
 heic 19c6fb53d4e0d62e743651ee7b4db539f58a7df17fe71dd144eadbe5267108d0 2177706 48.843205 2.3633866666666665 1 0 0 0 0 0 0 0 Paris Île-de-France France 51F8F5EC-2C01-4C2C-A167-93BBF9244B92 0.5732421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0016231536865234375 0.0084075927734375 0.006488800048828125 0.009999999776482582 -0.1419677734375 -0.0634765625 0.18408203125 0.00530242919921875 -0.0189361572265625 -0.04681396484375 -0.325439453125 -0.05267333984375 0.10992431640625 -0.022247314453125 -0.00017547607421875 -0.01253509521484375 0.0037078857421875 0.013275146484375 -0.0039825439453125 -0.2388916015625 -0.103271484375 -0.020904541015625
407 A3697779-FE08-47A2-A0F1-F72E5F253A9A 2019-08-24T13:59:14+00:00 
[
    "Public"
]
 
[]
 heic cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e 1763966 48.866238333333335 2.3550033333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France A3697779-FE08-47A2-A0F1-F72E5F253A9A 0.4736328125 0.75 0.0 0.05801526718694745 0.7040632367134094 -0.0008969306945800781 0.05682373046875 0.0017414093017578125 0.009999999776482582 0.6640625 -0.02880859375 0.1156005859375 0.00847625732421875 -0.005260467529296875 0.00762176513671875 0.33642578125 0.2490234375 0.0131683349609375 0.2069091796875 0.023590087890625 0.0031070709228515625 0.0030517578125 0.58935546875 0.74755859375 0.3955078125 0.8681640625 0.488525390625
137 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 2019-08-24T12:33:18+00:00 
[
    "Public"
]
 
[]
 heic 3ef3e28be7d606d9972c1a4303285a75703ade48e48c138f3ca9936251811cab 2035365 48.860925 2.342713333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France 903AEA63-4A86-4092-A52E-3DBAC94E1CBF 0.460205078125 0.75 0.0 0.05801526718694745 0.7073236107826233 -0.0009288787841796875 0.039306640625 0.0035114288330078125 0.009999999776482582 0.4736328125 -0.057586669921875 0.147216796875 0.004070281982421875 -0.0070648193359375 0.003509521484375 0.09234619140625 0.1043701171875 0.0207672119140625 0.1585693359375 0.00849151611328125 -0.00032806396484375 0.003337860107421875 0.11029052734375 0.07025146484375 0.09613037109375 0.6220703125 0.442626953125
253 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 2019-08-24T12:32:07+00:00 
[
    "Public"
]
 
[]
 heic 7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458 2400763 48.86095 2.342538333333333 1 0 0 0 0 0 0 0 Paris Île-de-France France 410DD7AF-B97A-4508-9240-B2B0F55DC2FD 0.3662109375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0092315673828125 0.02105712890625 0.00626373291015625 0.009999999776482582 -0.17333984375 -0.09271240234375 -0.000732421875 0.0139007568359375 -0.00609588623046875 -0.00481414794921875 -0.09033203125 -0.0902099609375 0.0135345458984375 0.09149169921875 0.00372314453125 -0.0022525787353515625 0.0035381317138671875 0.09466552734375 0.0888671875 0.042938232421875 0.44677734375 0.119384765625
173 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 2017-12-16T11:51:14+00:00 
[
    "Public"
]
 
[]
 heic 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 2072848 51.503303333333335 -0.1321805 1 0 0 0 0 0 0 0 London England United Kingdom 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 0.5703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008358955383300781 0.032989501953125 0.00313568115234375 0.009999999776482582 -0.45654296875 -0.043121337890625 0.239501953125 0.0038547515869140625 -0.00919342041015625 -0.02197265625 -0.1068115234375 0.0599365234375 0.09857177734375 0.10504150390625 0.00670623779296875 -0.011199951171875 0.004467010498046875 0.097900390625 0.051239013671875 0.05975341796875 0.29052734375 -8.392333984375e-05

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