photos_with_apple_metadata (view)

4 rows where albums = "["Museums", "Public"]" and place_state_province = "England"

View and edit SQL

Suggested facets: latitude, favorite, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, 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
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
6 F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 2018-09-04T14:29:33+00:00
[
    "Museums",
    "Public"
]
[]
heic 03546cdc3eb2bd9bb65aa3004efbb8e1ca942ba52a6e860582f7c7f725f7a624 2302711 50.65674666666666 -4.251666666666667 0 0 0 0 0 0 0 0 Lifton England United Kingdom F38B3C90-9701-4460-A9D7-EDCFFAD8CFB2 0.365966796875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.01322174072265625 0.014678955078125 0.00653839111328125 0.009999999776482582 -0.32958984375 -0.170654296875 -0.1690673828125 0.0567626953125 -0.017852783203125 -0.037261962890625 -0.337890625 -0.43310546875 0.01495361328125 0.1483154296875 0.0036945343017578125 -0.00209808349609375 0.004055023193359375 0.01061248779296875 -0.17578125 0.00453948974609375 0.00518798828125 0.1861572265625
165 9420279A-6AF4-4998-B882-499A10CC0937 2018-09-04T13:56:50+00:00
[
    "Museums",
    "Public"
]
[]
heic 53606e5b7d92fe96e74baa5721c4638c5fc5956c7e9409fcf2fda0d14a1aec55 1767292 50.656525 -4.251813333333334 0 0 0 0 0 0 0 0 Lifton England United Kingdom 9420279A-6AF4-4998-B882-499A10CC0937 0.438720703125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.0129241943359375 0.01224517822265625 0.00424957275390625 0.009999999776482582 -0.68896484375 -0.100341796875 -0.024322509765625 0.036895751953125 -0.0202178955078125 -0.0260009765625 -0.416259765625 -0.241455078125 0.050811767578125 0.02716064453125 0.00119781494140625 -0.008331298828125 0.0027675628662109375 0.0384521484375 0.1044921875 -0.0093231201171875 -0.03961181640625 -0.00185394287109375

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