photos_with_apple_metadata (view)

11 rows where "date" is on date 2020-02-22, panorama = 0 and screenshot = 0

View and edit SQL

Suggested facets: 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
353 C0471BD8-EBE8-49F4-A9BB-D6C067279A87 2020-02-22T23:13:39+00:00
[
    "Public"
]
[]
jpeg ab7c204eddcf3e5af89f6d55ca9d174684fb5350b6c013117efe3a801c6e2e42 6247543     1 0 0 0 0 0 0 0       C0471BD8-EBE8-49F4-A9BB-D6C067279A87 0.65673828125 0.75 0.0 0.06110306277529884 0.10000000149011612 -0.0009546279907226562 0.01290130615234375 0.00395965576171875 0.009999999776482582 -0.064453125 -0.03662109375 0.233642578125 0.0014104843139648438 -0.01363372802734375 -0.0123443603515625 -0.0489501953125 0.00372314453125 0.048675537109375 0.005401611328125 0.00226593017578125 -0.0153045654296875 0.0026721954345703125 0.0391845703125 0.016632080078125 0.0863037109375 0.330810546875 -0.0025634765625
19 92A798FF-8270-42BA-967F-41C0B3CB86DF 2020-02-22T23:13:29+00:00
[
    "Public"
]
[]
jpeg 0b24f2bad1807570b0002dc93e276fc5fd0de5c6843995acb7e5e9705cf0f58b 4905665     1 0 0 0 0 0 0 0       92A798FF-8270-42BA-967F-41C0B3CB86DF 0.67236328125 0.75 0.0 0.061114206568885394 0.10000000149011612 -0.005199432373046875 0.019317626953125 0.006771087646484375 0.009999999776482582 -0.2607421875 -0.0455322265625 -0.009613037109375 0.0224609375 -0.042236328125 -0.035186767578125 -0.074462890625 -0.1593017578125 0.034423828125 0.1011962890625 0.0055694580078125 -0.0029449462890625 0.004505157470703125 0.015960693359375 -0.031402587890625 0.06549072265625 0.1290283203125 0.101806640625
443 DE8F9059-EB54-45DD-A749-75E2D53718E9 2020-02-22T23:11:21+00:00
[
    "Public"
]
[]
jpeg e08f58b7b6bc615bef999d35a047478dee8cdb5e92a7c7271d92edc9d4c9cdc2 5083752     1 0 0 0 0 0 0 0       DE8F9059-EB54-45DD-A749-75E2D53718E9 0.65380859375 0.75 0.0 0.06112145012571611 0.10000000149011612 -0.0013303756713867188 0.026123046875 0.009521484375 0.009999999776482582 -0.83984375 -0.03228759765625 0.009796142578125 0.00397491455078125 -0.003551483154296875 -0.003574371337890625 0.2080078125 0.0872802734375 0.015838623046875 0.165283203125 -0.00489044189453125 -0.00196075439453125 0.00905609130859375 0.09075927734375 0.0265350341796875 0.12548828125 0.457763671875 0.0152740478515625
226 A5465C85-C13E-47D5-98DF-212727654FF1 2020-02-22T23:09:29+00:00
[
    "Public"
]
[]
jpeg 710ca46687daa7c41cf926a06fbb8f2202d7fd7275ff00fdd5e8c824bb6c1b87 7302953     1 0 0 0 0 0 0 0       A5465C85-C13E-47D5-98DF-212727654FF1 0.71044921875 0.75 0.0 0.06417581370768656 0.10000000149011612 -0.00131988525390625 0.045562744140625 0.048858642578125 0.009999999776482582 -0.1243896484375 -0.033538818359375 0.084716796875 0.004680633544921875 -0.007373809814453125 -0.0306854248046875 0.0333251953125 0.0322265625 0.05242919921875 0.12646484375 0.0185699462890625 0.00091552734375 0.00891876220703125 0.0074310302734375 -0.0020847320556640625 0.01313018798828125 -0.06329345703125 0.01189422607421875
222 A05FA28C-4192-4430-A597-21FC5A10BEEE 2020-02-22T23:09:17+00:00
[
    "Public"
]
[]
jpeg 6f78d9316fea65c2ec229415af66627a2f106b91e79e3a59cb621ce0ef6a8996 6011023     1 0 0 0 0 0 0 0       A05FA28C-4192-4430-A597-21FC5A10BEEE 0.5107421875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018243789672851562 -0.00043487548828125 0.0027141571044921875 0.009999999776482582 -0.068359375 -0.07720947265625 0.170166015625 0.0079345703125 -0.029144287109375 -0.047027587890625 -0.339111328125 -0.1475830078125 0.125244140625 -0.048248291015625 -0.0052490234375 -0.03662109375 0.00464630126953125 0.0173797607421875 -0.0086822509765625 -0.49267578125 0.0789794921875 -0.03973388671875
176 FC80510B-1BFF-4750-9C67-DEB2E8605F0A 2020-02-22T23:06:38+00:00
[
    "Public"
]
[]
jpeg 58ae5c3c9e69215d3da0e32a4beb6cf8e1c9a76a98d2b522dee8cff9481a17b5 4706974     1 0 0 0 0 0 0 0       FC80510B-1BFF-4750-9C67-DEB2E8605F0A 0.6640625 0.75 0.0 0.06109934817743665 0.10000000149011612 -0.0016937255859375 0.007720947265625 0.0015430450439453125 0.009999999776482582 0.28173828125 -0.06982421875 0.02960205078125 0.01483917236328125 -0.0411376953125 -0.01397705078125 -0.0816650390625 -0.1513671875 0.0300445556640625 0.03460693359375 0.00135040283203125 -0.0078125 0.00392913818359375 0.058441162109375 0.0114898681640625 -0.08734130859375 0.57080078125 0.10546875
251 FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D 2020-02-22T23:06:07+00:00
[
    "Public"
]
[]
jpeg 79d06475debc6729f906db1c693cea812ccfbf486e0c78b63e6495cd05e9aee2 6788509     1 0 0 0 0 0 0 0       FAA1F532-605C-4C8E-BBF8-2E5DF201CB1D 0.73193359375 0.75 0.0 0.06262569391090451 0.10000000149011612 -0.006511688232421875 0.0002899169921875 0.00974273681640625 0.009999999776482582 -0.2392578125 -0.0738525390625 -0.01568603515625 0.025909423828125 -0.05126953125 -0.1153564453125 -0.42578125 -0.3837890625 0.26318359375 -0.060211181640625 0.0015583038330078125 -0.026519775390625 0.011199951171875 0.0028228759765625 -0.053009033203125 -0.11895751953125 -0.261474609375 -0.023162841796875
411 1DD0EDC6-1E06-4801-A630-4231CA2F7264 2020-02-22T23:06:05+00:00
[
    "Public"
]
[]
jpeg cd593541060230f92db29d633f56a083b417bf57597d53cb7b742d257616fb7a 6670170     1 0 0 0 0 0 0 0       1DD0EDC6-1E06-4801-A630-4231CA2F7264 0.71337890625 0.75 0.0 0.06262978024155129 0.10041362792253494 -0.00075531005859375 0.1123046875 0.004055023193359375 0.009999999776482582 0.54248046875 -0.023193359375 0.254638671875 0.007785797119140625 -0.00555419921875 0.0187225341796875 0.2294921875 0.33154296875 0.02606201171875 0.176025390625 0.2381591796875 0.0111236572265625 0.002140045166015625 0.53125 0.76513671875 0.7060546875 0.7119140625 0.08050537109375
378 2671C060-6A75-4201-87B4-D3CA56B95433 2020-02-22T23:05:23+00:00
[
    "Public"
]
[]
jpeg bacce858078574660f0eb8f7838b6bb57701b4ccaa5c9d66ec90851ac59b41fa 6495626     1 0 0 0 0 0 0 0       2671C060-6A75-4201-87B4-D3CA56B95433 0.6650390625 0.75 0.0 0.06111606386781649 0.10000000149011612 -0.0010166168212890625 0.0106048583984375 0.00524139404296875 0.009999999776482582 -0.09130859375 -0.04949951171875 0.139404296875 0.005664825439453125 -0.0217437744140625 -0.08648681640625 -0.18896484375 -0.1002197265625 0.277099609375 -0.004638671875 0.004932403564453125 -0.017608642578125 0.0118255615234375 0.0153656005859375 -0.001708984375 -0.0948486328125 0.03277587890625 -0.00916290283203125
204 870ADED8-302A-4D9F-9A99-C0AB7E132703 2020-02-22T22:49:08+00:00
[
    "Public"
]
[]
jpeg 65ce0a3532954a8ae4bb4a89a7db165e25e79ddec45202df906e5167e997dfd6 6170081     1 0 0 0 0 0 0 0       870ADED8-302A-4D9F-9A99-C0AB7E132703 0.66845703125 0.75 0.0 0.061118664177319475 0.10000000149011612 -0.0017337799072265625 0.01067352294921875 0.007488250732421875 0.009999999776482582 -0.50439453125 -0.085693359375 -0.055084228515625 0.01242828369140625 -0.011871337890625 -0.07513427734375 -0.25390625 -0.2568359375 0.08868408203125 0.145263671875 0.0030231475830078125 -0.025115966796875 0.020965576171875 0.01467132568359375 -0.0213775634765625 -0.0164031982421875 0.12408447265625 0.006683349609375
63 68C635B0-7852-48E4-B3A6-72A86E9D9927 2020-02-22T22:48:07+00:00
[
    "Public"
]
[]
jpeg 1d4fd094ba9b844bdc06d286de3ae07c0fba3af08d8978b1e7cdcdf90c8eafa2 6136682     1 0 0 0 0 0 0 0       68C635B0-7852-48E4-B3A6-72A86E9D9927 0.62109375 0.75 0.0 0.061114206568885394 0.10000000149011612 -0.001934051513671875 0.002864837646484375 0.0015192031860351562 0.009999999776482582 -0.79833984375 -0.10284423828125 -0.0792236328125 0.0090179443359375 -0.0165863037109375 -0.0738525390625 -0.375 -0.3759765625 0.0259552001953125 0.0443115234375 -0.0015544891357421875 -0.032318115234375 0.00821685791015625 0.028106689453125 -0.032562255859375 -0.00848388671875 0.494873046875 0.00072479248046875

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