photos_with_apple_metadata (view)

9 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.0420040488243103"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, ZOVERALLAESTHETICSCORE, ZHARMONIOUSCOLORSCORE, ZINTERACTIONSCORE, ZLOWLIGHT, ZNOISESCORE, 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
142 A6FB150E-71C0-4524-8344-57CF59FE1B9E 2019-11-02T20:30:45+00:00 
[
    "Public"
]
 
[]
 jpeg 4360afbd37be230bf9fd6afcc48245e76bf9c81786713400653b2c81fb63f9e7 4649025     0 0 0 0 0 0 0 0       A6FB150E-71C0-4524-8344-57CF59FE1B9E 0.671875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0011243820190429688 0.0157928466796875 0.004364013671875 0.009999999776482582 -0.005615234375 -0.12188720703125 0.214599609375 0.00577545166015625 -0.0089874267578125 -0.04571533203125 -0.452880859375 -0.0048828125 0.090087890625 -0.01739501953125 4.57763671875e-05 -0.017822265625 0.002590179443359375 0.0214080810546875 0.0196380615234375 -0.337646484375 -0.1243896484375 0.0
271 01CEBCA2-922B-407C-A726-95D9E0EAB31C 2019-11-02T20:30:31+00:00 
[
    "Public"
]
 
[]
 jpeg 83667863dcd289d0c96e5d3ed3eb5dfe7ea399203b6cf00bc3e9c3566e7ac705 4810940     0 0 0 0 0 0 0 0       01CEBCA2-922B-407C-A726-95D9E0EAB31C 0.6572265625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.004085540771484375 0.0172119140625 0.0053863525390625 0.009999999776482582 -0.9560546875 -0.022674560546875 0.058502197265625 0.0011653900146484375 -0.00498199462890625 -0.00559234619140625 0.06793212890625 -0.06787109375 0.0125274658203125 0.052642822265625 -0.02593994140625 -0.0042877197265625 0.0035247802734375 0.05975341796875 -0.001373291015625 0.2047119140625 0.375732421875 0.00261688232421875
161 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 2019-11-02T20:23:51+00:00 
[
    "Public"
]
 
[]
 jpeg 4f164a611976a9ab84deac5a5aeb875bac3cfdbcb21852a8e4bcbdf8e38e7e90 5127846     0 0 0 0 0 0 0 0       0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 0.6171875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0006799697875976562 0.0157928466796875 0.01085662841796875 0.03999999910593033 0.0447998046875 -0.04351806640625 0.267578125 0.0020503997802734375 -0.00844573974609375 -0.02105712890625 -0.161376953125 0.03826904296875 0.12213134765625 0.011474609375 0.0068359375 -0.0125885009765625 0.005706787109375 0.0153045654296875 0.002277374267578125 -0.194580078125 0.0333251953125 -0.00848388671875
67 E38B4879-580E-454E-A06C-65335EDEBEB1 2019-11-02T20:23:18+00:00 
[
    "Public"
]
 
[]
 jpeg 1eb091d77226738cc72f75ec19792182635c5a0ecc5dc77cac70f36c17bb0a54 5444495     0 0 0 0 0 0 0 0       E38B4879-580E-454E-A06C-65335EDEBEB1 0.6572265625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016937255859375 -0.00299835205078125 0.0031604766845703125 0.009999999776482582 -0.61767578125 -0.0261993408203125 0.310302734375 0.0011653900146484375 -0.0207977294921875 -0.05755615234375 -0.1907958984375 -0.0826416015625 0.33056640625 -0.05499267578125 -0.004913330078125 -0.036773681640625 0.00595855712890625 0.01306915283203125 -0.00167083740234375 -0.10516357421875 -0.0482177734375 -0.0196990966796875
167 2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 2019-11-02T20:23:10+00:00 
[
    "Public"
]
 
[]
 jpeg 54c548a1c0f7e162558828db6bba845c2e9687cb148e877c58e975c9b2dfac61 5175607     0 0 0 0 0 0 0 0       2B4AD4FE-BEB7-4E86-84B4-2BEBA79615F7 0.62353515625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.00208282470703125 0.03045654296875 0.011199951171875 0.009999999776482582 -0.8740234375 -0.018096923828125 0.0810546875 0.0029582977294921875 -0.00634002685546875 -0.005580902099609375 0.163330078125 0.01617431640625 0.044677734375 0.0885009765625 -0.023895263671875 -0.0026531219482421875 0.00945281982421875 0.049774169921875 0.007781982421875 0.151611328125 0.307861328125 0.00909423828125
114 4E45EBA2-F531-4076-8741-A6D18656D677 2019-11-02T20:23:08+00:00 
[
    "Public"
]
 
[]
 jpeg 37f9819e71d4e2ae622f37fb8f1ad0c4d03c6fbe5653f79a5e14ce551ad9a818 5085402     0 0 0 0 0 0 0 0       4E45EBA2-F531-4076-8741-A6D18656D677 0.5927734375 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0017414093017578125 -0.00809478759765625 0.0035247802734375 0.05999999865889549 -0.463134765625 -0.041839599609375 0.4140625 0.0005507469177246094 -0.016845703125 -0.0992431640625 -0.37353515625 -0.07208251953125 0.2237548828125 -0.1409912109375 -0.0031261444091796875 -0.0285491943359375 0.0023136138916015625 0.007232666015625 -0.00624847412109375 -0.316162109375 -0.35888671875 -0.059173583984375
257 B062A78F-5C95-4072-ADF2-007D436B0B7E 2018-02-11T19:26:29+00:00 
[
    "Public"
]
 
[]
 jpeg 7d6b41e7ed116733ad90b7f35313cc9c33f78034df4d5194894a9a1cae2ca92d 6355439     0 0 0 0 0 0 0 0       B062A78F-5C95-4072-ADF2-007D436B0B7E 0.64306640625 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0019121170043945312 0.00333404541015625 0.0027256011962890625 0.009999999776482582 -0.85546875 -0.0301513671875 0.265380859375 0.0020904541015625 -0.01358795166015625 -0.0299530029296875 -0.193603515625 -0.072265625 0.0823974609375 -0.017425537109375 -0.021636962890625 -0.033935546875 0.0034160614013671875 0.0292510986328125 0.0034637451171875 -0.0279541015625 0.10302734375 -0.008270263671875
149 8A4D8382-B56E-4B87-8185-3702FA3AC0CF 2018-02-09T17:30:50+00:00 
[
    "Public"
]
 
[]
 jpeg 4864ce041cb9789b351bee246199845dbd66866c44576a409c755995327bf070 4978336     0 0 0 0 0 0 0 0       8A4D8382-B56E-4B87-8185-3702FA3AC0CF 0.6328125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0016613006591796875 0.0130462646484375 0.0018100738525390625 0.009999999776482582 -0.320556640625 -0.032470703125 0.2236328125 0.0037078857421875 -0.0207977294921875 -0.024261474609375 -0.063720703125 -0.041015625 0.10992431640625 -0.00274658203125 0.005218505859375 -0.05413818359375 0.00498199462890625 0.092529296875 0.05181884765625 0.07879638671875 0.434326171875 -0.007740020751953125
30 8876C417-C39E-453A-A865-2A997A6DAAF0 2017-12-16T11:51:05+00:00 
[
    "Public"
]
 
[]
 heic 11b66e49de0d6187d44d38601aefce96dfa29f419444d201b1e03422bd76dc14 1999722 51.503296666666664 -0.13221116666666666 0 0 0 0 0 0 0 0 London England United Kingdom 8876C417-C39E-453A-A865-2A997A6DAAF0 0.65673828125 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.01029205322265625 -0.0067291259765625 0.0014553070068359375 0.009999999776482582 -0.26220703125 -0.10125732421875 0.0670166015625 0.006984710693359375 -0.120361328125 -0.1640625 -0.50146484375 -0.361328125 0.06671142578125 -0.2410888671875 -0.0035266876220703125 -0.053955078125 0.0016489028930664062 0.005344390869140625 -0.1005859375 -0.46533203125 -0.158203125 -0.1329345703125

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