photos_with_apple_metadata (view)

4 rows where ZIMMERSIVENESSSCORE = "0.0016546249389648438"

View and edit SQL

Suggested facets: albums, favorite, place_city, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
123 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 2019-06-11T21:41:06+00:00
[
    "Museums",
    "Public"
]
[]
heic 3a6bbcb6f079e26dc3577577ee795523912c002627087c9cf658f757f690d989 2226634 37.78167 -122.40270333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 37E1743F-21C1-4EBF-A118-9AE8EDDF91D1 0.4443359375 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.001155853271484375 0.018402099609375 0.0016546249389648438 0.009999999776482582 -0.06689453125 -0.03125 0.2587890625 0.00257110595703125 -0.01678466796875 -0.00225830078125 -0.004638671875 0.0 0.0869140625 0.03759765625 0.006435394287109375 -0.011322021484375 0.004085540771484375 0.1719970703125 0.11846923828125 0.126953125 0.595703125 -0.00284576416015625
365 2C4C0C9B-AF5C-4F0F-BE45-9C70E7A4A898 2019-03-23T17:53:07+00:00
[
    "Super bloom 2019",
    "Public"
]
[]
heic b2eaa44367a25992bdd26676048e70221cbf9b6c858c38d274cb8c75956341c8 1557937     1 0 0 0 0 0 0 0       2C4C0C9B-AF5C-4F0F-BE45-9C70E7A4A898 0.414794921875 0.75 0.0 0.05801526718694745 0.10065693408250809 -0.0018177032470703125 0.04876708984375 0.0016546249389648438 0.009999999776482582 0.2822265625 -0.037261962890625 0.288330078125 0.00482940673828125 -0.0108184814453125 0.01113128662109375 0.07794189453125 0.097900390625 0.0283355712890625 0.0557861328125 0.04193115234375 -0.0036468505859375 0.0011339187622070312 0.410888671875 0.7607421875 0.5146484375 0.6669921875 0.03277587890625
356 F3DAB898-0907-410B-B796-9999D8E773A7 2018-04-22T00:15:46+00:00
[
    "Museums",
    "Public"
]
[]
heic ad9ef159b032c9390823705c5c527212864618c1f40128d3684b850dd5a27f96 857241 37.57923666666667 -122.34424666666666 0 0 0 0 0 0 0 0 Burlingame CA United States F3DAB898-0907-410B-B796-9999D8E773A7 0.322998046875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0035114288330078125 0.01099395751953125 0.0016546249389648438 0.009999999776482582 0.367431640625 -0.06573486328125 0.036834716796875 0.0202178955078125 -0.0823974609375 -0.026947021484375 -0.09014892578125 -0.134521484375 0.0221099853515625 0.0318603515625 0.001338958740234375 -0.00354766845703125 0.001934051513671875 0.037811279296875 -0.01739501953125 -0.032958984375 0.427734375 0.456298828125
474 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 2018-04-22T00:11:22+00:00
[
    "Museums",
    "Public"
]
[]
heic f2c7ee07ea7696e0578ff14d4b87dd76508999d46d251effe98dd0fa2093f429 1483372 37.57924166666667 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 8800AD7C-B9A7-4EC9-B543-8CC8892258F1 0.327392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.002414703369140625 -0.00057220458984375 0.0016546249389648438 0.009999999776482582 -0.30322265625 -0.090576171875 0.1556396484375 0.004573822021484375 -0.0360107421875 -0.1617431640625 -0.436767578125 -0.183349609375 0.146728515625 -0.2203369140625 -0.0005512237548828125 -0.0244903564453125 0.0032863616943359375 0.018585205078125 -0.017364501953125 -0.263916015625 -0.011474609375 -0.04461669921875

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