photos_with_apple_metadata (view)

2 rows where ZPLEASANTPATTERNSCORE = "0.07476806640625" and albums = "["Museums", "Public"]"

✎ View and edit SQL

Suggested facets: 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
289 277756C5-6924-4E30-877D-CD2CE30630FD 2018-04-22T00:17:52+00:00
[
    "Museums",
    "Public"
]
[]
heic 8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af 1177569 37.579096666666665 -122.34413833333333 0 0 0 0 0 0 0 0 Burlingame CA United States 277756C5-6924-4E30-877D-CD2CE30630FD 0.266357421875 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.003795623779296875 -0.0030517578125 0.0010366439819335938 0.009999999776482582 -0.449951171875 -0.03875732421875 0.1923828125 0.00323486328125 -0.07781982421875 -0.06396484375 -0.1732177734375 -0.1572265625 0.07476806640625 -0.1436767578125 -0.00726318359375 -0.03466796875 0.0022602081298828125 0.035736083984375 -0.0068206787109375 -0.1612548828125 0.345703125 -0.03826904296875
211 E4D43462-07AB-4803-9DCB-02B8321D8D94 2016-01-13T20:30:46+00:00
[
    "Museums",
    "Public"
]
[]
jpeg 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 2259762 37.78168 -122.411025 0 0 0 0 0 0 0 0 San Francisco CA United States E4D43462-07AB-4803-9DCB-02B8321D8D94 0.22265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007615089416503906 0.0242156982421875 0.0022258758544921875 0.009999999776482582 -0.11474609375 -0.08343505859375 0.0714111328125 0.0144500732421875 -0.01009368896484375 -0.0028076171875 -0.100341796875 0.0386962890625 0.07476806640625 0.2037353515625 0.00543975830078125 -0.00792694091796875 0.008575439453125 0.1524658203125 0.10986328125 -0.04443359375 0.56005859375 0.039520263671875

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