photos_with_apple_metadata (view)

11 rows where favorite = 1 and place_city = "San Francisco"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, persons, ext, longitude, panorama, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZPLEASANTPERSPECTIVESCORE, date (date), albums (array), persons (array)

place_state_province ✖

place_country ✖

place_city ✖

  • San Francisco · 11 ✖

favorite ✖

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
163 70B3C358-DA0D-469F-B667-F0045F445AC6 2020-05-19T04:31:43+00:00 
[
    "Public"
]
 
[]
 heic 502fbb347dc72fbffbddb7b92326f6ddbeb6d27a77d9761fb5406bd5ab43d445 1070208 37.770916670000005 -122.47696667 1 0 0 0 0 0 0 0 San Francisco CA United States                                                        
241 AA04E7D2-B517-4CA8-A331-7810A6902E2E 2020-04-26T22:03:31+00:00 
[
    "Public"
]
 
[]
 heic 76d0f468ebbc94845b6b2b23f44201b04f6dce627ae15f70f016c02be7336175 3842036 37.790321670000004 -122.46161666999998 1 0 0 0 0 0 0 0 San Francisco CA United States                                                        
45 B03FB29E-EB36-434D-91D2-C6A2C625A252 2019-09-21T23:04:44+00:00 
[
    "Public"
]
 
[
    "Simon Willison"
]
 heic 169d469221f7b3672924dad826b6e064adef8d2156cbac42694bf6574a6ee942 2127841 37.75691167 -122.42811666999998 1 0 0 0 0 0 0 0 San Francisco CA United States B03FB29E-EB36-434D-91D2-C6A2C625A252 0.6005859375 0.900544417500496 0.0 0.06950898268295609 0.10000000149011612 -0.0010814666748046875 -0.004852294921875 0.0018529891967773438 0.009999999776482582 0.0074462890625 -0.049041748046875 0.4072265625 0.0010652542114257812 -0.021484375 -0.060638427734375 -0.2181396484375 -0.08575439453125 0.2110595703125 -0.1009521484375 -0.0017833709716796875 -0.05633544921875 0.00323486328125 0.01229095458984375 -0.0018157958984375 -0.56298828125 0.023193359375 -0.08587646484375
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
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
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
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
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
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
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
349 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 2017-03-31T00:53:36+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg a93401fea4842b551132a24a707ae8e30d646d4830c5c32c3ce7c1ddcdd61bbc 4502080 37.76918 -122.46453833333334 1 0 0 0 0 0 0 0 San Francisco CA United States 1F3A99DA-FBB6-4FDC-B84D-AE15DE0846BB 0.5263671875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006122589111328125 -0.00547027587890625 0.0029125213623046875 0.009999999776482582 -0.5576171875 -0.057373046875 0.273681640625 0.001956939697265625 -0.0379638671875 -0.159912109375 -0.435791015625 -0.146240234375 0.11676025390625 -0.2406005859375 -0.0036716461181640625 -0.045989990234375 0.0017681121826171875 0.00930023193359375 -0.03497314453125 -0.2568359375 -0.277587890625 -0.07403564453125

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