photos_with_apple_metadata (view)

6 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.05801526718694745" and place_state_province = "England"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, place_city, ZINTERACTIONSCORE, 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
217 B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 2019-12-29T10:40:51+00:00 
[
    "Public"
]
 
[]
 heic 6c260ecb0219bf7808f1a8ebf5e35aaaa15d395592a2ca050bebc42c703f7217 1711662 51.49035 -0.6723333300000001 1 0 0 0 0 0 0 0 Windsor England United Kingdom B21AA170-9F4B-49A4-A3B4-F77AB2E3CDFA 0.472900390625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0006313323974609375 0.019256591796875 0.0034961700439453125 0.009999999776482582 -0.31689453125 -0.03521728515625 0.08013916015625 0.0169830322265625 -0.011688232421875 0.007171630859375 0.0731201171875 0.10430908203125 0.150390625 0.1519775390625 0.00537872314453125 -0.01264190673828125 0.0199432373046875 0.16650390625 0.100830078125 0.037353515625 0.6376953125 0.01389312744140625
487 BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 2019-12-28T10:55:13+00:00 
[
    "Public"
]
 
[]
 heic faec04a4c5576d2de8af17460c22c79fd1926e889e3d0073ea188994c82507ac 3569228 50.697155 -3.19187 1 0 0 0 0 0 0 0 Sidmouth England United Kingdom BA5C0E8F-0086-47CD-9E8E-DAD96A494C5A 0.49267578125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008935928344726562 0.024658203125 0.0289764404296875 0.009999999776482582 -0.22119140625 -0.033905029296875 0.13232421875 0.00392913818359375 -0.00916290283203125 -0.0421142578125 -0.09619140625 0.0260009765625 0.2198486328125 0.092041015625 0.010162353515625 -0.0087127685546875 0.0165863037109375 0.0103302001953125 -0.000217437744140625 -0.0215911865234375 -0.09661865234375 0.00095367431640625
164 659F6A3E-8547-476F-B2AA-883117C53253 2019-12-17T10:05:40+00:00 
[
    "Public"
]
 
[]
 heic 51f4b1c7d3691bd32170d7f1f343c25e4ce687a3474675501e5295fb8de1e233 2625105 51.52467832999999 -0.11347499999999999 1 0 0 0 0 0 0 0 London England United Kingdom 659F6A3E-8547-476F-B2AA-883117C53253 0.33251953125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.006488800048828125 -0.0045318603515625 0.0008692741394042969 0.03999999910593033 0.53564453125 -0.09771728515625 -0.21630859375 0.0849609375 -0.233154296875 -0.0269775390625 -0.2191162109375 -0.67626953125 0.0322265625 -0.0523681640625 -0.0008630752563476562 -0.0160675048828125 0.0057525634765625 0.01142120361328125 -0.115234375 -0.48876953125 0.54541015625 -0.01934814453125
316 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 2018-09-04T15:40:35+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 9ab8a8f8d0d8d62ecf5411bdb5ed26b1e5b7fa9df793f0ff21f7080e0163eb64 1813574 50.656758333333336 -4.251725 1 0 0 0 0 0 0 0 Lifton England United Kingdom 1CCB0CD8-DDD9-40A5-AEBC-015C873A2A09 0.390380859375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.07696533203125 -0.000335693359375 0.004608154296875 0.009999999776482582 -0.849609375 -0.08062744140625 -0.108642578125 0.049407958984375 -0.07196044921875 -0.044647216796875 -0.5185546875 -0.53076171875 0.0211639404296875 -0.06842041015625 -0.00606536865234375 -0.01552581787109375 0.001483917236328125 0.007122039794921875 -0.378173828125 -0.017852783203125 -0.19140625 -0.0211181640625
383 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC 2018-09-04T14:39:55+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic bf353867bc1597a9f89dbc4de8af7d755095da20198147e47c69c35f6ebf0b36 1758797 50.656525 -4.251916666666666 1 0 0 0 0 0 0 0 Lifton England United Kingdom 8A9FED20-BDE8-46E0-8583-C8FF1C7D3BFC 0.403564453125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.00555419921875 0.0181884765625 0.0021991729736328125 0.009999999776482582 -0.20703125 -0.05340576171875 -0.00537109375 0.05780029296875 -0.03240966796875 -0.006561279296875 -0.0440673828125 -0.14306640625 0.0265045166015625 0.084228515625 0.00756072998046875 -0.00572967529296875 0.00392913818359375 0.1265869140625 0.167724609375 0.06036376953125 0.489013671875 0.0262451171875
173 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 2017-12-16T11:51:14+00:00 
[
    "Public"
]
 
[]
 heic 57da25cee1c32557167b6d5458ac3ea56f683150c2611d6d8ad6a9b6dbb27276 2072848 51.503303333333335 -0.1321805 1 0 0 0 0 0 0 0 London England United Kingdom 4E152F37-5FF2-43B0-BB98-FE9B6802BF55 0.5703125 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0008358955383300781 0.032989501953125 0.00313568115234375 0.009999999776482582 -0.45654296875 -0.043121337890625 0.239501953125 0.0038547515869140625 -0.00919342041015625 -0.02197265625 -0.1068115234375 0.0599365234375 0.09857177734375 0.10504150390625 0.00670623779296875 -0.011199951171875 0.004467010498046875 0.097900390625 0.051239013671875 0.05975341796875 0.29052734375 -8.392333984375e-05

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