photos_with_apple_metadata (view)

16 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.05801526718694745" and "date" is on date 2020-01-25

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, ZFAILURESCORE, 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
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

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