photos_with_apple_metadata (view)

19 rows where ZINTERACTIONSCORE = "0.03999999910593033"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, favorite, panorama, place_city, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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