photos_with_apple_metadata (view)

7 rows where ZCURATIONSCORE = "0.75" and albums contains "Ray Bandar's Bone Palace" sorted by ZHARMONIOUSCOLORSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: longitude, panorama, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZPLEASANTPERSPECTIVESCORE, date (date)

albums (array) ✖

ZCURATIONSCORE ✖

  • 0.75 · 7 ✖
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
175 978E05B3-A903-4F27-A219-92603A4880B5 2018-02-20T22:37:35+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f 1770398 37.742308333333334 -122.44956166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 978E05B3-A903-4F27-A219-92603A4880B5 0.470458984375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018892288208007812 0.009368896484375 0.0017414093017578125 0.009999999776482582 -0.03662109375 -0.103759765625 0.056243896484375 0.0068511962890625 -0.015899658203125 -0.037567138671875 -0.27294921875 -0.12939453125 0.02947998046875 0.02142333984375 0.001251220703125 -0.0097808837890625 0.002620697021484375 0.03656005859375 -0.001678466796875 -0.088623046875 0.303466796875 0.0738525390625
491 2489642F-D29D-47EC-918A-63D1E2CEDF98 2018-02-20T23:04:00+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic fdc3052b1eb0fc7ebf3511145fa1744be8a22de793c74f9d89f98ffca730df5b 1690162 37.74257166666666 -122.44921166666667 1 0 0 0 0 0 0 0 San Francisco CA United States 2489642F-D29D-47EC-918A-63D1E2CEDF98 0.529296875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.001129150390625 0.0247955322265625 0.0087432861328125 0.009999999776482582 0.038818359375 -0.07354736328125 -0.028564453125 0.0169830322265625 -0.01085662841796875 -0.02056884765625 0.00927734375 0.0140380859375 0.0294189453125 0.26611328125 0.00890350341796875 -0.00035858154296875 0.00916290283203125 0.02691650390625 -0.004119873046875 0.0243988037109375 0.219970703125 0.1761474609375
429 3BE3193F-45AF-4787-B445-A6260393657C 2018-02-20T23:18:32+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic d95f2e03676af786d523f3c360046daade8b99f2e3a69bdaa24c27b7467512ad 5038686 37.742305 -122.44933333333333 1 0 0 0 0 0 0 1 San Francisco CA United States 3BE3193F-45AF-4787-B445-A6260393657C 0.4404296875 0.75 0.0 0.05801952050159906 0.10000000149011612 -0.0016937255859375 0.025726318359375 0.005161285400390625 0.009999999776482582 0.0986328125 -0.134033203125 -0.08038330078125 0.054901123046875 -0.00971221923828125 -0.021026611328125 -0.12890625 -0.1240234375 0.0153656005859375 0.198974609375 0.009490966796875 -0.000732421875 0.00731658935546875 0.02880859375 -0.0065765380859375 -0.01116943359375 0.2578125 0.1834716796875
413 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C 2018-02-20T22:16:37+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783 1481901 37.74236666666667 -122.44930333333333 1 0 0 0 0 0 0 0 San Francisco CA United States 73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C 0.36376953125 0.75 0.0 0.05801526718694745 0.5043308734893799 -0.0011920928955078125 0.028045654296875 0.00394439697265625 0.009999999776482582 0.51904296875 -0.039642333984375 -0.0184326171875 0.0164031982421875 -0.0162811279296875 -0.0003814697265625 0.305419921875 0.0206298828125 0.0170440673828125 0.26611328125 0.00893402099609375 0.001964569091796875 0.00948333740234375 0.09234619140625 0.0183258056640625 0.170654296875 0.6982421875 0.43212890625
16 C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A 2018-02-20T22:10:33+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 087562510b302c2c3e8095b7e5ed455ff4b178e909ec46bde09d50c8500ec26d 1743702 37.74223666666666 -122.44941666666666 1 0 0 0 0 0 0 0 San Francisco CA United States C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A 0.353759765625 0.75 0.0 0.05801526718694745 0.5041119456291199 -0.0015249252319335938 0.0284576416015625 0.005062103271484375 0.009999999776482582 0.384765625 -0.07489013671875 -0.036285400390625 0.025909423828125 -0.00908660888671875 -0.00229644775390625 0.187744140625 0.02294921875 0.0174407958984375 0.23681640625 0.01068115234375 0.001995086669921875 0.00760650634765625 0.08404541015625 0.0736083984375 0.04827880859375 0.458984375 0.26806640625
80 3A952955-7B08-4DEE-809D-C08685BDC3BF 2018-02-20T22:52:16+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 232c6b6414de60758ae544a8323123a9d651d32c0769f5ad9aa8533b8635051b 1628032 37.742355 -122.44944666666666 1 0 0 0 0 0 0 0 San Francisco CA United States 3A952955-7B08-4DEE-809D-C08685BDC3BF 0.4873046875 0.75 0.0 0.05802354995758479 0.10000000149011612 -0.0007977485656738281 0.04168701171875 0.0129241943359375 0.009999999776482582 -0.1112060546875 -0.0271759033203125 0.07489013671875 0.00844573974609375 -0.00844573974609375 -0.0066680908203125 0.165771484375 0.1026611328125 0.054290771484375 0.19189453125 0.0194854736328125 -0.001277923583984375 0.012725830078125 0.046905517578125 0.00926971435546875 0.125244140625 0.337158203125 0.0272674560546875
17 AE5BD628-AB44-4D2F-A03F-88422F509482 2018-02-20T22:10:36+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 097370f3405ad0e8a22a859ef107130273fd5fe2138128ffd6e7fc18c39fa000 1644874 37.742225 -122.44941666666666 1 0 0 0 0 0 0 0 San Francisco CA United States AE5BD628-AB44-4D2F-A03F-88422F509482 0.461669921875 0.75 0.0 0.05801526718694745 0.504501223564148 -0.0012645721435546875 0.047088623046875 0.005279541015625 0.009999999776482582 0.197021484375 -0.07904052734375 0.021148681640625 0.014007568359375 -0.004451751708984375 0.0032806396484375 0.183837890625 0.1884765625 0.0261077880859375 0.34716796875 0.019775390625 0.0006866455078125 0.006168365478515625 0.1915283203125 0.32861328125 0.09649658203125 0.496826171875 0.1983642578125

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