photos_with_apple_metadata (view)

5 rows where albums = "["Public"]" and persons contains "_UNKNOWN_"

View and edit SQL

Suggested facets: date, persons, ext, latitude, longitude, favorite, hdr, place_city, place_state_province, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, 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
116 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 2019-09-16T16:27:24+00:00
[
    "Public"
]
[
    "_UNKNOWN_"
]
heic 38c5c9797285ca569d63a524a7a217b562c289e2b8068122e5dd7329348cfe4c 1987600 37.449821666666665 -122.18592 1 0 0 0 0 0 0 0 Menlo Park CA United States 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 0.443115234375 0.75 0.0 0.9740458015380925 0.10000000149011612 -0.000743865966796875 0.0360107421875 0.0125732421875 0.009999999776482582 0.1959228515625 -0.08599853515625 0.06207275390625 0.020965576171875 -0.00963592529296875 -0.040130615234375 -0.1871337890625 0.0689697265625 0.23583984375 0.19287109375 0.013458251953125 -0.00125885009765625 0.0169219970703125 0.0169219970703125 0.00560760498046875 -0.0806884765625 -0.0244140625 0.116943359375
282 7E07EFBF-1F63-4142-8856-7DCD9F906811 2019-09-14T16:27:56+00:00
[
    "Public"
]
[
    "_UNKNOWN_"
]
heic 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 1699486 29.941283333333335 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 7E07EFBF-1F63-4142-8856-7DCD9F906811 0.361328125 0.75 0.0 0.05801526718694745 0.5045255422592163 -0.0028228759765625 0.0236358642578125 0.002521514892578125 0.009999999776482582 0.42626953125 -0.0970458984375 -0.021026611328125 0.04168701171875 -0.00844573974609375 0.00287628173828125 0.1065673828125 0.0474853515625 0.01049041748046875 0.16552734375 0.0140838623046875 -7.2479248046875e-05 0.0039005279541015625 0.2330322265625 0.47900390625 0.10040283203125 0.71728515625 0.31689453125
61 910061FF-8B93-4DF6-8580-F61F3AF655AC 2019-08-24T12:37:43+00:00
[
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
heic 1cbea14450726bc646e838673ea29b8223c53c5d312f0a111c3be48a4a7e7e5a 1385613 48.860908333333334 2.3425616666666667 1 0 0 0 0 0 0 0 Paris Île-de-France France 910061FF-8B93-4DF6-8580-F61F3AF655AC 0.3134765625 0.75 0.0 0.8213740458129016 0.7066909670829773 -0.0004093647003173828 0.09881591796875 0.002216339111328125 0.009999999776482582 0.8076171875 -0.0236053466796875 0.1300048828125 0.01242828369140625 -0.0027141571044921875 0.011077880859375 0.4990234375 0.466796875 0.0186920166015625 0.310302734375 0.064453125 0.0083770751953125 0.005062103271484375 0.78662109375 0.89404296875 0.48291015625 0.91259765625 0.58984375
240 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 2016-04-09T20:12:10+00:00
[
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
jpeg 75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8 2689457 37.78550333333333 -122.43043666666667 0 0 0 0 0 1 0 0 San Francisco CA United States 6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C 0.486572265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.004314422607421875 -0.00701141357421875 0.002452850341796875 0.009999999776482582 -0.121826171875 -0.1026611328125 0.11175537109375 0.005619049072265625 -0.0521240234375 -0.133544921875 -0.4990234375 -0.270263671875 0.165283203125 -0.1573486328125 -0.0026302337646484375 -0.0262451171875 0.0035381317138671875 0.00557708740234375 -0.07470703125 -0.5068359375 -0.1641845703125 -0.1171875
346 9B076964-9931-4790-AE2D-A06011B97CE7 2016-04-09T20:12:10+00:00
[
    "Public"
]
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
jpeg a7e181d3b3705db1b852705de9a92e0449fbb1b98b70e366bab316b554dafd6e 2665460 37.78550333333333 -122.43043666666667 0 0 0 0 0 0 0 0 San Francisco CA United States 9B076964-9931-4790-AE2D-A06011B97CE7 0.434326171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014209747314453125 0.0190582275390625 0.0013408660888671875 0.009999999776482582 0.150634765625 -0.06256103515625 0.31884765625 0.0022869110107421875 -0.01666259765625 -0.009002685546875 -0.1044921875 -0.00030517578125 0.0293121337890625 -0.04010009765625 0.001861572265625 -0.00848388671875 0.0009546279907226562 0.10015869140625 0.10113525390625 -0.07080078125 0.4228515625 0.02374267578125

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