photos_with_apple_metadata (view)

3 rows where ZIMMERSIVENESSSCORE = "0.002834320068359375"

View and edit SQL

Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, 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
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
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
95 A4CA92F3-A131-498E-8205-62E1BF5A4EF4 2018-02-09T17:12:24+00:00
[
    "Public"
]
[]
jpeg 2bb66fd402f278b2d94fe7858cc0433d75c10ae4b7dad602fea6f6d8c3cdb57f 6153631     1 0 0 0 0 0 0 0       A4CA92F3-A131-498E-8205-62E1BF5A4EF4 0.60595703125 0.75 0.0 0.06109619049625542 0.10000000149011612 -0.0016813278198242188 -0.0042266845703125 0.002834320068359375 0.019999999552965164 -0.5615234375 -0.033599853515625 0.300048828125 0.001220703125 -0.0206451416015625 -0.06109619140625 -0.2479248046875 -0.1029052734375 0.1707763671875 -0.0718994140625 -0.003936767578125 -0.048583984375 0.004070281982421875 0.0121917724609375 -0.003787994384765625 -0.199462890625 -0.051025390625 -0.02569580078125

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