photos_with_apple_metadata (view)

4 rows where ZIMMERSIVENESSSCORE = "0.002208709716796875"

View and edit SQL

Suggested facets: ext, favorite, ZCURATIONSCORE, 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
423 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 2019-09-15T14:38:47+00:00
[
    "Public"
]
[]
heic d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2 2699124 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 0.6171875 0.75 0.0 0.06110566308480183 0.10000000149011612 -0.00473785400390625 -0.0020599365234375 0.002208709716796875 0.009999999776482582 -0.5263671875 -0.0616455078125 0.07708740234375 0.00482940673828125 -0.040679931640625 -0.0740966796875 -0.298095703125 -0.294677734375 0.0792236328125 -0.0595703125 -0.004840850830078125 -0.1695556640625 0.00464630126953125 0.00841522216796875 -0.0238189697265625 -0.1800537109375 0.0487060546875 -0.02069091796875
258 F505A7F3-E583-46DE-8010-D8E6FE116376 2019-09-15T12:22:12+00:00
[
    "Public"
]
[]
jpeg 7de2e4e9f7166b348eeedac71aca8a8f54ef90c39cc1af6bd29b97356003a5c9 6065443     1 0 0 0 0 0 0 0       F505A7F3-E583-46DE-8010-D8E6FE116376 0.67724609375 0.75 0.0 0.061086160991028066 0.7049391865730286 -0.0007762908935546875 0.03778076171875 0.002208709716796875 0.009999999776482582 0.611328125 -0.03985595703125 0.0484619140625 0.0284881591796875 -0.006744384765625 0.00769805908203125 0.3466796875 0.34228515625 0.0125274658203125 0.1842041015625 0.021484375 0.003406524658203125 0.004398345947265625 0.54833984375 0.70458984375 0.219482421875 0.8525390625 0.417724609375
368 071DED2E-2D2A-4519-A47A-FC37916025F1 2019-08-21T16:03:37+00:00
[
    "Public"
]
[]
jpeg b46e8e49eed203530d061274284253c2c95b1d7c6ea3a9aa7cac6d85f1afa813 5829855     1 0 0 0 0 0 0 0       071DED2E-2D2A-4519-A47A-FC37916025F1 0.68115234375 0.75 0.0 0.06110547744590818 0.7048904895782471 -0.0009288787841796875 0.043670654296875 0.002208709716796875 0.009999999776482582 0.681640625 -0.04296875 0.08575439453125 0.01348114013671875 -0.006565093994140625 0.0111083984375 0.27099609375 0.231689453125 0.03326416015625 0.2171630859375 0.020111083984375 0.0029048919677734375 0.004848480224609375 0.4287109375 0.68408203125 0.1844482421875 0.7802734375 0.5263671875
112 558FFB4E-06B0-4782-962A-FA28C8F0B415 2018-02-09T17:34:26+00:00
[
    "Public"
]
[]
jpeg 370c4f936c1cb84f1bbeea091005103b5fa94d264733dc20d24371b1ea9fb27a 6150089     0 0 0 0 0 0 0 0       558FFB4E-06B0-4782-962A-FA28C8F0B415 0.576171875 0.5 0.0 0.04201630736125334 0.1015571802854538 -0.0010004043579101562 0.081298828125 0.002208709716796875 0.009999999776482582 0.1552734375 -0.026702880859375 0.27734375 0.011962890625 -0.00885009765625 0.02862548828125 0.1475830078125 0.19580078125 0.09979248046875 0.2252197265625 0.06927490234375 -0.00176239013671875 0.00482940673828125 0.493408203125 0.671875 0.397216796875 0.70751953125 0.040496826171875

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