photos_with_apple_metadata (view)

11 rows where ZINTERACTIONSCORE = "0.03999999910593033" and ext = "jpeg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, date (date), albums (array)

ext ✖

  • jpeg · 11 ✖

ZINTERACTIONSCORE ✖

  • 0.03999999910593033 · 11 ✖
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
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
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
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
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 204.005ms · About: dogsheep/dogsheep-photos