photos_with_apple_metadata (view)

3 rows where ZNOISESCORE = "-0.0120086669921875"

View and edit SQL

Suggested facets: ext, favorite, ZCURATIONSCORE, ZPLEASANTCOMPOSITIONSCORE, 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
328 270D8B7F-B413-477E-8B8A-E176CD4CFAAB 2020-01-25T20:14:58+00:00
[
    "Public"
]
[]
jpeg 9fd526078cb07a71f8c943f036ec2853498eb58be7aa1794a7a13b92e3cee893 7385215     1 0 0 0 0 0 0 0       270D8B7F-B413-477E-8B8A-E176CD4CFAAB 0.6982421875 0.75 0.0 0.06111773552785393 0.10000000149011612 -0.0006070137023925781 0.01513671875 0.0037078857421875 0.009999999776482582 -0.47802734375 -0.0216217041015625 0.1534423828125 0.00243377685546875 -0.0120086669921875 -0.0123443603515625 0.04833984375 0.00738525390625 0.0953369140625 0.0992431640625 0.002025604248046875 -0.015899658203125 0.01229095458984375 0.0753173828125 0.009674072265625 0.1370849609375 0.5419921875 0.001552581787109375
266 EB0F670F-3DE5-4917-840A-1C84BE9C570D 2019-07-30T12:22:03+00:00
[
    "To Instagram",
    "Public"
]
[]
jpeg 80c39df47ef66d49231ae15a6a0dcd036881b7310ebc344e9b8677da479ee070 5096405     1 0 0 0 0 0 0 0       EB0F670F-3DE5-4917-840A-1C84BE9C570D 0.75927734375 0.75 0.0 0.06262309405639882 0.10000000149011612 -0.0026721954345703125 0.040374755859375 0.0038242340087890625 0.009999999776482582 -0.53515625 -0.0248870849609375 0.30224609375 0.00426483154296875 -0.0120086669921875 -0.01177978515625 -0.03497314453125 0.03985595703125 0.091064453125 0.054443359375 0.0120697021484375 -0.018310546875 0.0028781890869140625 0.12890625 0.1641845703125 0.1927490234375 0.2381591796875 -0.004730224609375
170 D382083C-7911-43C1-92C6-851050CD2A85 2018-02-20T22:40:44+00:00
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
[]
heic 561df5b88b9b2f15322135b94a627a3d87fd42b112ebe28ea48d8f0eaa55f583 805481 37.742428333333336 -122.449425 0 0 0 0 0 0 0 0 San Francisco CA United States D382083C-7911-43C1-92C6-851050CD2A85 0.53759765625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0030517578125 0.032196044921875 0.02752685546875 0.009999999776482582 -0.15478515625 -0.0809326171875 -0.0926513671875 0.023773193359375 -0.0120086669921875 -0.0382080078125 0.04833984375 -0.1563720703125 0.01678466796875 0.24853515625 0.0092926025390625 0.01267242431640625 0.00841522216796875 0.006717681884765625 -0.0152740478515625 0.008392333984375 -0.022735595703125 0.1077880859375

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