photos_with_apple_metadata (view)

8 rows where ZINTERACTIONSCORE = "0.03999999910593033", favorite = 1 and hdr = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, place_state_province, place_country, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
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
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

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