photos_with_apple_metadata (view)

7 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.038931297721298594", ZINTERACTIONSCORE = "0.009999999776482582" and albums = "["Stolen monasteries", "Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, ZBEHAVIORALSCORE, ZPLEASANTPATTERNSCORE, 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
404 C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 2018-11-26T23:47:36+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic c8f40ecddd5157c98a12110e1a9e11a97b72940d1ba4555f73eb17d229559031 3821687 37.7672 -122.46752166666667 0 0 0 0 0 0 0 0 San Francisco CA United States C0BEA1F5-AAA4-4BCD-A9B0-1E4A91218800 0.457275390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.006877899169921875 -0.005374908447265625 0.0021076202392578125 0.009999999776482582 -0.27880859375 -0.1282958984375 0.11395263671875 0.0087432861328125 -0.042572021484375 -0.10498046875 -0.58642578125 -0.257080078125 0.08251953125 -0.16015625 -0.005096435546875 -0.02154541015625 0.0016355514526367188 0.010009765625 -0.08673095703125 -0.447509765625 -0.22705078125 -0.115234375
25 40C65283-9CB3-4FAE-A390-4FDC22BCC29F 2018-11-26T23:46:00+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 0daddeb8eb5e2b05b1b21bc51bf14355201de8303222502595c716f8e52b47fd 1789046 37.767125 -122.46747 0 0 0 0 0 0 0 0 San Francisco CA United States 40C65283-9CB3-4FAE-A390-4FDC22BCC29F 0.251708984375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.024383544921875 -0.0081024169921875 0.002834320068359375 0.009999999776482582 -0.47119140625 -0.1044921875 -0.090087890625 0.1077880859375 -0.1966552734375 -0.06512451171875 -0.67138671875 -0.5810546875 0.05145263671875 -0.09759521484375 -0.0024623870849609375 -0.0153656005859375 0.0017004013061523438 0.0024929046630859375 -0.1163330078125 -0.259765625 -0.4462890625 -0.08624267578125
458 AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 2017-11-05T23:07:13+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic e8984bb084f3dd58c57a1e2f8a1c8cdbb86c903cfc239f61916b3eb86f332655 3513964 37.769133333333336 -122.46440833333334 0 0 0 0 0 0 0 0 San Francisco CA United States AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A 0.463623046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016040802001953125 0.06597900390625 0.047515869140625 0.009999999776482582 -0.026611328125 -0.0313720703125 0.0909423828125 0.00443267822265625 -0.00595855712890625 -0.0275115966796875 0.1474609375 -0.005859375 0.033905029296875 0.120361328125 0.016143798828125 0.02667236328125 0.007122039794921875 0.00669097900390625 -0.0003986358642578125 0.007114410400390625 -0.04931640625 0.012451171875
218 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 2017-11-05T23:05:51+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 6cd24772dbd1f463325dba1e5ab734ceb559741953324b590eb89d3497cda1f4 2789234 37.768953333333336 -122.464425 0 0 0 0 0 0 0 0 San Francisco CA United States 3D7AE6D3-0FD4-4130-B713-44EB2C885A30 0.373779296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011920928955078125 0.0150299072265625 0.0024242401123046875 0.009999999776482582 0.0262451171875 -0.05340576171875 0.35107421875 0.0018529891967773438 -0.01525115966796875 -0.019927978515625 -0.121337890625 -0.013916015625 0.078369140625 -0.033782958984375 -0.0024566650390625 -0.01345062255859375 0.0018177032470703125 0.0472412109375 0.041656494140625 -0.119140625 0.26513671875 -0.02508544921875
278 F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 2017-06-16T00:54:59+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg 85c32ecbb8b5b4e75514799212c4bdd8c51469269e931a1fb6aa53f87dc92676 4565297 37.76912 -122.46459166666666 0 0 0 0 0 0 0 0 San Francisco CA United States F5F65BC1-8BD3-40A2-B283-EBA2E7657A20 0.361572265625 0.5 0.0 0.038931297721298594 0.10087591409683228 -0.0004372596740722656 0.1085205078125 0.00908660888671875 0.009999999776482582 -0.0367431640625 -0.020172119140625 0.271484375 0.01512908935546875 -0.008544921875 0.01593017578125 0.140869140625 0.227294921875 0.212890625 0.343505859375 0.08966064453125 -0.0034332275390625 0.0169830322265625 0.10992431640625 0.03192138671875 0.1953125 0.363037109375 0.009735107421875
105 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 2017-06-16T00:54:53+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg 318022d1b2b2e9804d550276366c3b8ad3a61fe5efaf79af0c59d0ae647ff195 5269532 37.76909666666667 -122.46451666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 8DDE7452-CF7B-4EA0-AFB4-89A15001F19F 0.431396484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0034961700439453125 -0.001842498779296875 0.0022335052490234375 0.009999999776482582 -0.29736328125 -0.0699462890625 -0.09381103515625 0.055206298828125 -0.091064453125 -0.052276611328125 -0.311767578125 -0.4609375 0.08251953125 -0.017852783203125 -0.001033782958984375 -0.0304718017578125 0.01137542724609375 0.01238250732421875 -0.03204345703125 -0.20263671875 0.256103515625 -0.00457763671875
394 1657E7D6-94E7-4344-BCFE-1F924546CE11 2017-03-31T00:48:44+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg c5b53e0765f828354402aad8d9de6be1c70b4c78cc0db97d30f31697b01fb591 4595669 37.76913 -122.46448666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 1657E7D6-94E7-4344-BCFE-1F924546CE11 0.482421875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0031108856201171875 0.0105438232421875 0.00511932373046875 0.009999999776482582 -0.958984375 -0.02056884765625 0.1424560546875 0.00046372413635253906 -0.00482940673828125 -0.00754547119140625 -0.01824951171875 -0.0391845703125 0.020599365234375 0.026031494140625 -0.02587890625 -0.005725860595703125 0.0027370452880859375 0.04779052734375 0.0046844482421875 0.154541015625 0.262451171875 -0.0001735687255859375

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