photos_with_apple_metadata (view)

11 rows where "date" is on date 2020-02-22 sorted by ZIMMERSIVENESSSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, albums (array)

date (date) ✖

  • 2020-02-22 · 11 ✖
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
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
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
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
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
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
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
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
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
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
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

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