photos_with_apple_metadata (view)

12 rows where ZCURATIONSCORE = "0.75" and favorite = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date, albums, ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, ZPLEASANTCOMPOSITIONSCORE, 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
290 5C8A9E7C-62A9-4609-95C7-75826C03EF24 2019-11-02T20:32:13+00:00 
[
    "Public"
]
 
[]
 jpeg 8bc56b3f8a20e0370f225bd7e9016c5435f837cbd37a640ac89bc6fab6c88983 4783904     0 0 0 0 0 0 0 0       5C8A9E7C-62A9-4609-95C7-75826C03EF24 0.79833984375 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.001495361328125 0.00037384033203125 0.00605010986328125 0.009999999776482582 -0.36181640625 -0.0836181640625 0.255126953125 0.0031604766845703125 -0.01111602783203125 -0.10107421875 -0.560546875 -0.09552001953125 0.185546875 -0.0755615234375 -0.001712799072265625 -0.038970947265625 0.0036640167236328125 0.005619049072265625 -0.007110595703125 -0.341064453125 -0.450927734375 -0.048065185546875
59 E28B94C5-3FD9-4199-B291-5727F3D40053 2019-11-02T20:32:12+00:00 
[
    "Public"
]
 
[]
 jpeg 1bf6f978059091efb89907071b2796f19db07ba2994d6826fc794dcb1ce3d38a 4830969     0 0 0 0 0 0 0 0       E28B94C5-3FD9-4199-B291-5727F3D40053 0.7939453125 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.0024433135986328125 0.001224517822265625 0.0018033981323242188 0.009999999776482582 -0.83935546875 -0.09027099609375 0.05169677734375 0.002811431884765625 -0.011199951171875 -0.04876708984375 -0.432861328125 -0.2054443359375 0.03314208984375 -0.02099609375 -0.005584716796875 -0.0362548828125 0.00319671630859375 0.0261077880859375 -0.0133209228515625 -0.05126953125 0.1944580078125 -0.007366180419921875
321 429A1239-744D-4A61-A33B-1BF261584128 2019-11-02T20:32:07+00:00 
[
    "Public"
]
 
[]
 jpeg 9d0b55a181e5acc3dd658ac1c79c7000cde794058c3e93698d1337ca6d4e348a 4858397     0 0 0 0 0 0 0 0       429A1239-744D-4A61-A33B-1BF261584128 0.79833984375 0.75 0.0 0.06261464384675935 0.5030657052993774 -0.0016164779663085938 0.0750732421875 0.023284912109375 0.009999999776482582 0.1019287109375 -0.0784912109375 0.060943603515625 0.01861572265625 -0.006641387939453125 -0.039154052734375 -0.078125 0.118896484375 0.1488037109375 0.3134765625 0.04833984375 0.00243377685546875 0.00945281982421875 0.0250396728515625 0.049774169921875 0.0056610107421875 -0.05963134765625 0.049896240234375
50 B0F72802-C713-43D3-899A-81C4AED347DC 2019-11-02T20:32:07+00:00 
[
    "Public"
]
 
[]
 jpeg 18e73d3bafa71dfc897bb8f8059380c9895372347b59199a31c464bca7fba1d9 4949434     0 0 0 0 0 0 0 0       B0F72802-C713-43D3-899A-81C4AED347DC 0.79150390625 0.75 0.0 0.06261464384675935 0.10000000149011612 -0.0027790069580078125 -0.003040313720703125 0.0018463134765625 0.03999999910593033 0.2215576171875 -0.05780029296875 0.063232421875 0.00916290283203125 -0.085693359375 -0.040863037109375 -0.1737060546875 -0.291259765625 0.11456298828125 -0.05914306640625 -0.00067138671875 -0.021148681640625 0.00473785400390625 0.00933837890625 -0.023468017578125 -0.37060546875 0.235595703125 -0.053070068359375
148 4EC865F7-E05C-42A0-B43A-4D46235F6F9C 2019-11-02T20:31:34+00:00 
[
    "Public"
]
 
[]
 jpeg 4835c1442d65d55dedd5ab611d33201c41f5501a905cdc7decf0ff4563f423d8 4479783     0 0 0 0 0 0 0 0       4EC865F7-E05C-42A0-B43A-4D46235F6F9C 0.81201171875 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.001461029052734375 0.0098724365234375 0.003650665283203125 0.009999999776482582 -0.0167236328125 -0.056976318359375 0.482177734375 0.0022525787353515625 -0.01554107666015625 -0.09368896484375 -0.263427734375 -0.060302734375 0.33056640625 -0.10772705078125 0.000396728515625 -0.02008056640625 0.0036067962646484375 0.013275146484375 -0.0019073486328125 -0.37255859375 -0.12451171875 -0.07977294921875
230 D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 2019-11-02T20:31:30+00:00 
[
    "Public"
]
 
[]
 jpeg 71e43f92a0ac99ed5fa838e65f58a6976c1d3e80908eb4b0427e104da7f4d2e3 4531938     0 0 0 0 0 0 0 0       D28ACD11-B3D5-43BE-96C5-9CE7D39E95E1 0.84423828125 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0031719207763671875 -0.0098876953125 0.0023975372314453125 0.019999999552965164 -0.1708984375 -0.06890869140625 0.2208251953125 0.0024814605712890625 -0.05072021484375 -0.1019287109375 -0.407958984375 -0.1861572265625 0.199462890625 -0.140869140625 -0.0044708251953125 -0.032257080078125 0.002368927001953125 0.004848480224609375 -0.022552490234375 -0.53173828125 -0.293701171875 -0.13134765625
422 BA1C8565-7D1C-49E3-93BA-183B8D6B1270 2019-11-02T20:31:29+00:00 
[
    "Public"
]
 
[]
 jpeg d687723405fc71baa66683d64212af08b36f0db1cb5caa9e01c61c262d02cfc3 4246410     0 0 0 0 0 0 0 0       BA1C8565-7D1C-49E3-93BA-183B8D6B1270 0.84228515625 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0006117820739746094 0.0157012939453125 0.0020351409912109375 0.03999999910593033 0.599609375 -0.06622314453125 0.10491943359375 0.01009368896484375 -0.015838623046875 0.00726318359375 0.02276611328125 -0.0177001953125 0.07318115234375 0.0751953125 0.00572967529296875 -0.008392333984375 0.00867462158203125 0.0836181640625 0.047119140625 -0.158203125 0.68798828125 0.1689453125
201 5FCADAE8-4708-4E56-B6B0-F718EE9446F7 2019-11-02T20:31:19+00:00 
[
    "Public"
]
 
[]
 jpeg 64d4969938ae0359e40e8450801788ee372e29e5f755d3c5a1f671f2212bc809 4462558     0 0 0 0 0 0 0 0       5FCADAE8-4708-4E56-B6B0-F718EE9446F7 0.82177734375 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.002124786376953125 0.000396728515625 0.0029125213623046875 0.009999999776482582 -0.150390625 -0.09027099609375 0.29443359375 0.003376007080078125 -0.0162200927734375 -0.07568359375 -0.42333984375 -0.1134033203125 0.151123046875 -0.0860595703125 -0.005008697509765625 -0.04974365234375 0.0026836395263671875 0.01267242431640625 -0.005584716796875 -0.470947265625 -0.1773681640625 -0.07421875
270 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 2018-02-13T18:53:51+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 822075bc99101363c0c066542717adc5187c66b924e4a7e353e33f8e186614e6 4974082 25.73733306096472 -111.090981559417 0 0 0 0 0 0 0 0     Mexico 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 0.8330078125 0.75 0.0 0.06261723005134641 0.7075669169425964 -0.0026416778564453125 0.0203857421875 0.0023136138916015625 0.03999999910593033 0.49658203125 -0.09173583984375 -0.0142822265625 0.024993896484375 -0.0110321044921875 0.0013427734375 0.094482421875 0.013671875 0.0121002197265625 0.1624755859375 0.007904052734375 0.0004119873046875 0.0034427642822265625 0.149169921875 0.28857421875 0.085205078125 0.65380859375 0.52685546875
103 E2880EC4-C3B5-46E6-B555-C78CF75895C2 2018-02-11T19:35:20+00:00 
[
    "Public"
]
 
[]
 jpeg 30f37193cf87e00bc0a9b36bcf5fd6972f627f24fe37cbd828e52101303d0e14 3812669     0 0 0 0 0 0 0 0       E2880EC4-C3B5-46E6-B555-C78CF75895C2 0.78955078125 0.75 0.0 0.06263722718216991 0.10000000149011612 -0.0007791519165039062 0.03192138671875 0.007038116455078125 0.009999999776482582 0.1177978515625 -0.06866455078125 0.433837890625 0.0021820068359375 -0.006717681884765625 -0.027587890625 -0.263427734375 0.05645751953125 0.150634765625 -0.010467529296875 0.00214385986328125 -0.006992340087890625 0.00238800048828125 0.021240234375 0.0230712890625 -0.302978515625 -0.136962890625 -0.01300048828125
408 32EAACCC-CDA4-4922-96FE-417F7F77F79E 2018-02-09T17:41:47+00:00 
[
    "Public"
]
 
[]
 jpeg cbfe463f1a67e37a1d36c5db44f0159ef6f86a0d64a987b129b63b52e555f1af 4486603     0 0 0 0 0 0 0 0       32EAACCC-CDA4-4922-96FE-417F7F77F79E 0.8564453125 0.75 0.0 0.06263820133136429 0.10000000149011612 -0.0009326934814453125 0.042755126953125 0.00453948974609375 0.009999999776482582 -0.57568359375 -0.0283355712890625 0.2100830078125 0.0027790069580078125 -0.0059356689453125 -0.0073089599609375 0.05865478515625 0.0704345703125 0.0247955322265625 0.11260986328125 0.0017547607421875 -0.00522613525390625 0.003692626953125 0.11199951171875 0.034393310546875 0.1650390625 0.42724609375 0.00579833984375
14 521AC274-EDCB-4A51-BB46-96FE8A4D839F 2018-02-09T17:41:47+00:00 
[
    "Public"
]
 
[]
 jpeg 079eeabe823ae591e3038e2ba1b57cc3be2869376723af323806b6f67043f891 4267520     0 0 0 0 0 0 0 0       521AC274-EDCB-4A51-BB46-96FE8A4D839F 0.826171875 0.75 0.0 0.06263778182386442 0.10000000149011612 -0.00157928466796875 0.033843994140625 0.00679779052734375 0.009999999776482582 -0.9248046875 -0.0141143798828125 0.13134765625 0.001926422119140625 -0.0038394927978515625 -0.0030193328857421875 0.18359375 0.05108642578125 0.059661865234375 0.09136962890625 -0.02587890625 -0.003108978271484375 0.00974273681640625 0.10504150390625 0.0477294921875 0.2042236328125 0.431396484375 0.003818511962890625

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