photos_with_apple_metadata (view)

3 rows where ZNOISESCORE = "-0.013427734375"

View and edit SQL

Suggested facets: ext, place_country, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, 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
174 48576FF3-4790-4A9E-957C-5B7AD552679D 2018-10-12T15:54:17+00:00
[
    "Museums",
    "Public"
]
[]
heic 5836d0fba69ea497978edbccd58076b3fc522e82b30fb5bf1ac8a9129621be90 1754726 41.50468333333333 -81.68949166666667 0 0 0 0 0 0 0 0 Cleveland OH United States 48576FF3-4790-4A9E-957C-5B7AD552679D 0.349853515625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0010242462158203125 -0.00017547607421875 0.00426483154296875 0.009999999776482582 0.0140380859375 -0.050994873046875 0.448486328125 0.0006747245788574219 -0.013427734375 -0.05816650390625 -0.263427734375 -0.0338134765625 0.293212890625 -0.0966796875 0.000362396240234375 -0.018096923828125 0.0025615692138671875 0.0103302001953125 0.004547119140625 -0.442138671875 -0.228515625 -0.10748291015625
166 A9E26555-0DE9-4416-8C3E-54992AF7AB10 2018-02-20T23:02:11+00:00
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
[]
heic 54525e90a3fda130db87d551bb7a10208980d0d1960ca9b83bac61d2499a67d8 1535168 37.74260833333334 -122.44934166666667 0 0 0 0 0 0 0 0 San Francisco CA United States A9E26555-0DE9-4416-8C3E-54992AF7AB10 0.37646484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0025501251220703125 0.01739501953125 0.00669097900390625 0.009999999776482582 0.058837890625 -0.08062744140625 0.12646484375 0.003692626953125 -0.013427734375 -0.08441162109375 -0.201171875 -0.169189453125 0.0401611328125 -0.0177001953125 0.004955291748046875 -0.036102294921875 0.003482818603515625 0.007724761962890625 -0.0174560546875 -0.05755615234375 0.0003662109375 0.0176849365234375
358 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 2018-02-13T18:53:52+00:00
[
    "Geotaggable Photos geotagged",
    "Public"
]
[]
jpeg adc26d4f5ae813f2a5a6281653f515dc245ff351973f99c342bb23015a175d48 5176004 25.737328762300947 -111.09098016188648 0 0 0 0 0 0 0 0     Mexico 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 0.78125 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.0012254714965820312 0.042755126953125 0.00279998779296875 0.019999999552965164 -0.191650390625 -0.05987548828125 0.419189453125 0.00734710693359375 -0.013427734375 -0.05120849609375 -0.2137451171875 0.0130615234375 0.5712890625 0.00146484375 0.0055694580078125 -0.016815185546875 0.0070953369140625 0.0709228515625 0.15087890625 -0.163330078125 0.04150390625 -0.0222625732421875

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