photos_with_apple_metadata (view)

19 rows where ZINTERACTIONSCORE = "0.03999999910593033" sorted by ZFAILURESCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, favorite, panorama, place_city, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, date (date), albums (array), persons (array)

place_state_province ✖

ZINTERACTIONSCORE ✖

  • 0.03999999910593033 · 19 ✖
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
9 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 2019-12-28T10:29:00+00:00 
[
    "Public"
]
 
[]
 heic 041612eaccc0c5724b4613995a12106e7dd7e1f68555c7db4924523c8d6bcde1 3060174 50.69708833 -3.18944667 1 0 0 0 0 0 0 0 Sidmouth England United Kingdom 6FDA5781-8D5F-4369-9F26-C605FF4ECFE4 0.55859375 0.75 0.0 0.8213740458129016 0.10000000149011612 -0.01358795166015625 -0.0102996826171875 0.0026836395263671875 0.03999999910593033 -0.194091796875 -0.09136962890625 0.0579833984375 0.01302337646484375 -0.09771728515625 -0.11468505859375 -0.486328125 -0.419189453125 0.2086181640625 -0.1304931640625 -0.003662109375 -0.0751953125 0.0038852691650390625 0.0029239654541015625 -0.1339111328125 -0.477783203125 -0.30859375 -0.1309814453125
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
38 1EAE7EE2-CBE6-491B-A8EF-337859628659 2017-11-05T23:05:44+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 1423536b7567da6562cd1e842bd93be31d8ebe84d797afe4a81644bac2a2c9e3 2979362 37.768975 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 1EAE7EE2-CBE6-491B-A8EF-337859628659 0.347900390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028896331787109375 0.01885986328125 0.004116058349609375 0.03999999910593033 0.1094970703125 -0.053192138671875 0.1767578125 0.00254058837890625 -0.019561767578125 -0.03076171875 -0.08697509765625 -0.03570556640625 0.029815673828125 0.0164794921875 0.00586700439453125 -0.00499725341796875 0.001926422119140625 0.037261962890625 -0.0113525390625 0.08465576171875 0.339599609375 0.105224609375
291 C8CCC8EE-382E-4265-8236-E2F30764A55C 2018-04-21T23:55:50+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 1719608 37.57926666666667 -122.3442 0 0 0 0 0 0 0 0 Burlingame CA United States C8CCC8EE-382E-4265-8236-E2F30764A55C 0.2325439453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028228759765625 -0.00146484375 0.0015306472778320312 0.03999999910593033 0.1011962890625 -0.07305908203125 0.1485595703125 0.006511688232421875 -0.046722412109375 -0.03564453125 -0.249755859375 -0.18994140625 0.0582275390625 -0.07696533203125 -0.0020275115966796875 -0.0162353515625 0.0019044876098632812 0.0194244384765625 -0.01031494140625 -0.405029296875 0.190185546875 -0.0648193359375
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
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
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
299 DD6E4630-85BD-41BF-A7B3-524C02942A65 2019-03-24T17:53:38+00:00 
[
    "Super bloom 2019",
    "Public"
]
 
[]
 heic 8f49702a9cdd8ab729df55e30f2394524312f7f972c3e6c1615fe457b6bac72c 9765384 34.738725 -118.38710833333333 0 0 0 0 0 0 0 1 Lancaster CA United States DD6E4630-85BD-41BF-A7B3-524C02942A65 0.61279296875 0.5 0.0 0.04201835029907809 0.503333330154419 -0.0020904541015625 0.115478515625 0.00547027587890625 0.03999999910593033 -0.006591796875 -0.040313720703125 0.2203369140625 0.0150146484375 -0.00392913818359375 0.002899169921875 0.1368408203125 0.185791015625 0.10894775390625 0.177490234375 0.031951904296875 0.001537322998046875 0.00453948974609375 0.251953125 0.67138671875 0.09588623046875 0.296142578125 0.0736083984375
41 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 2018-05-18T19:45:49+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 14efd697b9572b24b1853d1a3effab60609c0fcb477ad4739e85194c32afe8ba 1849449 37.0415695 -122.0726305 0 0 0 0 0 0 0 0 Felton CA United States 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 0.43701171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020503997802734375 0.0012054443359375 0.00266265869140625 0.03999999910593033 -0.0677490234375 -0.093505859375 0.361328125 0.0033111572265625 -0.01525115966796875 -0.0430908203125 -0.4287109375 -0.0633544921875 0.1295166015625 -0.07568359375 -0.00975799560546875 -0.01381683349609375 0.0014162063598632812 0.01934814453125 0.02264404296875 -0.5283203125 -0.20849609375 -0.10821533203125
152 A40BDBBE-2DC6-4385-8108-8C15F37610B4 2019-11-02T20:30:59+00:00 
[
    "Public"
]
 
[]
 jpeg 48e96bb66208e6f03b85428cde82ab3ae651d3134a078ef4ea1b4f32d1b4c02c 4629001     0 0 0 0 0 0 0 0       A40BDBBE-2DC6-4385-8108-8C15F37610B4 0.54931640625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.001918792724609375 -0.00484466552734375 0.002834320068359375 0.03999999910593033 0.165283203125 -0.04052734375 0.24755859375 0.0024623870849609375 -0.04595947265625 -0.04052734375 -0.1414794921875 -0.1551513671875 0.20751953125 -0.065673828125 -0.00061798095703125 -0.0300750732421875 0.005161285400390625 0.00844573974609375 -0.01395416259765625 -0.49267578125 0.1368408203125 -0.09515380859375
26 B19BB608-7B37-4094-AE9B-504B13660278 2018-01-14T23:22:43+00:00 
[
    "Public"
]
 
[]
 heic 0ecd701f9983b7f759eab2d53911b05de86cf0dfcde086d85c480c70cc8b8f43 3510677 37.76555333333334 -122.440025 0 0 0 0 0 0 0 0 San Francisco CA United States B19BB608-7B37-4094-AE9B-504B13660278 0.3291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016231536865234375 0.041717529296875 0.0011377334594726562 0.03999999910593033 -0.0711669921875 -0.0386962890625 0.30029296875 0.005199432373046875 -0.0154266357421875 0.0089111328125 0.0123291015625 0.0244140625 0.0794677734375 0.08740234375 0.020721435546875 -0.0150146484375 0.00274658203125 0.324462890625 0.397705078125 0.28076171875 0.62158203125 0.00057220458984375
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
339 DEA5349B-F370-47FA-97E1-5ABAEED723AD 2020-04-15T17:04:12+00:00 
[
    "Photography Homework April 16 2020",
    "Public"
]
 
[]
 jpeg a46d88c4fd16f02e47b319814f895096eafa231c6844565851d5071bdadddd37 4466223     1 0 0 0 0 0 0 0       DEA5349B-F370-47FA-97E1-5ABAEED723AD 0.81689453125 0.75 0.0 0.0626261907679434 0.5067639946937561 -0.0010900497436523438 0.0285491943359375 0.0036067962646484375 0.03999999910593033 0.5546875 -0.036285400390625 0.007415771484375 0.023773193359375 -0.021453857421875 0.0043182373046875 0.25830078125 0.052490234375 0.021087646484375 0.2227783203125 0.0179290771484375 0.0009918212890625 0.0090179443359375 0.1263427734375 0.0472412109375 0.2783203125 0.77734375 0.314453125
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
220 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 2015-10-05T14:55:32+00:00 
[
    "Museums",
    "Niche museums",
    "Public"
]
 
[]
 jpeg 6f0558a227b6c1acc2259af4e4d3d6aac4ce7148cda96ad212c4a6fd45ef36a1 2840560     0 0 0 0 0 0 0 0       BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 0.3583984375 0.5 0.0 0.038931297721298594 0.5039172768592834 -0.0008168220520019531 0.03851318359375 0.001949310302734375 0.03999999910593033 0.2958984375 -0.03314208984375 0.058319091796875 0.0271759033203125 -0.007038116455078125 0.0072479248046875 0.328125 0.2447509765625 0.01450347900390625 0.1962890625 0.0167236328125 0.000606536865234375 0.006488800048828125 0.58203125 0.58935546875 0.2381591796875 0.88427734375 0.1051025390625
161 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 2019-11-02T20:23:51+00:00 
[
    "Public"
]
 
[]
 jpeg 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 5127846     0 0 0 0 0 0 0 0       0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 0.6171875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0006799697875976562 0.0157928466796875 0.01085662841796875 0.03999999910593033 0.0447998046875 -0.04351806640625 0.267578125 0.0020503997802734375 -0.00844573974609375 -0.02105712890625 -0.161376953125 0.03826904296875 0.12213134765625 0.011474609375 0.0068359375 -0.0125885009765625 0.005706787109375 0.0153045654296875 0.002277374267578125 -0.194580078125 0.0333251953125 -0.00848388671875
159 BF9CEE04-8E45-4586-BC61-7E5921483763 2019-09-15T12:32:01+00:00 
[
    "Public"
]
 
[]
 jpeg 4d716099e85d3ba064b1cfbc236fc58381dc15b17ce4368141d10a39747b7998 4386363     1 0 0 0 0 0 0 0       BF9CEE04-8E45-4586-BC61-7E5921483763 0.712890625 0.75 0.0 0.06263033715823224 0.5045985579490662 -0.0006413459777832031 0.0499267578125 0.0026721954345703125 0.03999999910593033 0.54931640625 -0.041473388671875 0.035003662109375 0.0394287109375 -0.0082550048828125 0.00948333740234375 0.360107421875 0.301025390625 0.0127716064453125 0.260986328125 0.0268707275390625 0.00336456298828125 0.00653839111328125 0.37060546875 0.29248046875 0.223876953125 0.8359375 0.3427734375
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
437 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 2019-08-21T16:05:25+00:00 
[
    "Public"
]
 
[]
 jpeg dcf001e183e3e0ed9142c734eb751eb0992e7b14651845c9c3df40a491322b6d 7003984     1 0 0 0 0 0 0 0       23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 0.68896484375 0.75 0.0 0.061103805785870734 0.7047201991081238 -0.000583648681640625 0.0305023193359375 0.0018606185913085938 0.03999999910593033 0.79833984375 -0.047943115234375 0.031646728515625 0.0161590576171875 -0.0041351318359375 0.00727081298828125 0.41015625 0.318359375 0.01507568359375 0.22802734375 0.01171112060546875 0.00311279296875 0.006313323974609375 0.5595703125 0.74560546875 0.13330078125 0.8798828125 0.66357421875

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