photos_with_apple_metadata (view)

11 rows where ZBEHAVIORALSCORE = "0.10000000149011612" and "date" is on date 2019-09-15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, latitude, longitude, ZHIGHLIGHTVISIBILITYSCORE, ZHARMONIOUSCOLORSCORE, ZINTERACTIONSCORE, 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
277 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 2019-09-15T15:36:30+00:00 
[
    "Public"
]
 
[]
 heic 847b6ce3e30394f5485d356528eea16a644e0a2b54d1a7727c03011f8c54b554 1716536 30.24152 -89.67729166666666 1 0 0 0 0 0 0 0 Slidell LA United States 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 0.5712890625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.016510009765625 0.008575439453125 0.03999999910593033 -0.235107421875 -0.05291748046875 0.2169189453125 0.00669097900390625 -0.01214599609375 -0.043487548828125 -0.1904296875 -0.03326416015625 0.430908203125 0.0216064453125 0.00054931640625 -0.0718994140625 0.0169830322265625 0.0224609375 0.0220794677734375 -0.1822509765625 -0.0218505859375 -0.0104827880859375
309 A34D9C15-11C6-488C-9E3C-910401A65132 2019-09-15T15:16:37+00:00 
[
    "Public"
]
 
[]
 heic 95e2658b31ac920ea73e962755503af66a5a04ceade3f3c91313f8808380f753 3537285 30.243796666666668 -89.68113 1 0 0 0 0 0 0 0 Slidell LA United States A34D9C15-11C6-488C-9E3C-910401A65132 0.47021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0036792755126953125 -0.00623321533203125 0.004573822021484375 0.009999999776482582 -0.17138671875 -0.05450439453125 0.2073974609375 0.0028896331787109375 -0.039794921875 -0.1051025390625 -0.3232421875 -0.1912841796875 0.39306640625 -0.091552734375 -0.002368927001953125 -0.1004638671875 0.0066680908203125 0.0038089752197265625 -0.022735595703125 -0.396484375 -0.28955078125 -0.07501220703125
442 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 2019-09-15T15:15:38+00:00 
[
    "Public"
]
 
[]
 heic e0418d31b3a2b842b3514b954ac271355a51ba93194dc39cfadb7ee9ecb1acac 3794075 30.243286666666666 -89.68092166666666 1 0 0 0 0 0 0 0 Slidell LA United States 1EC4C590-FBD5-4D44-9FF8-0FAC3F1600D5 0.6689453125 0.75 0.0 0.061091547248927694 0.10000000149011612 -0.0002913475036621094 0.0178985595703125 0.0090179443359375 0.009999999776482582 0.0235595703125 -0.039947509765625 0.11279296875 0.0070953369140625 -0.006641387939453125 -0.013092041015625 0.019287109375 0.0228271484375 0.275390625 0.11358642578125 0.0069427490234375 -0.0308074951171875 0.04949951171875 0.0284423828125 0.0028171539306640625 -0.1083984375 0.3466796875 0.00666046142578125
423 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 2019-09-15T14:38:47+00:00 
[
    "Public"
]
 
[]
 heic d6f260ebe038a495c75f0bbc1c00606f894676a9ce2098c3d5733530dc0e8ec2 2699124 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 9B0C0741-55E0-4BB2-BC6B-BAB6804EE1A0 0.6171875 0.75 0.0 0.06110566308480183 0.10000000149011612 -0.00473785400390625 -0.0020599365234375 0.002208709716796875 0.009999999776482582 -0.5263671875 -0.0616455078125 0.07708740234375 0.00482940673828125 -0.040679931640625 -0.0740966796875 -0.298095703125 -0.294677734375 0.0792236328125 -0.0595703125 -0.004840850830078125 -0.1695556640625 0.00464630126953125 0.00841522216796875 -0.0238189697265625 -0.1800537109375 0.0487060546875 -0.02069091796875
225 5896CD82-A625-4414-9D39-25EFE6E848C1 2019-09-15T14:37:30+00:00 
[
    "Public"
]
 
[]
 heic 7104ebd9287ca4e5d2556496eafd7d34ada9901997cbff1dbdd7c33281d65566 2529275 30.234196666666666 -89.66815833333334 1 0 0 0 0 0 0 0 Slidell LA United States 5896CD82-A625-4414-9D39-25EFE6E848C1 0.6513671875 0.75 0.0 0.8244531118232785 0.10000000149011612 -0.0008897781372070312 0.02996826171875 0.030792236328125 0.009999999776482582 0.0899658203125 -0.07708740234375 0.011474609375 0.00933837890625 -0.00847625732421875 -0.0897216796875 -0.1318359375 -0.0404052734375 0.316162109375 0.26220703125 0.013916015625 -0.0034942626953125 0.03228759765625 0.008880615234375 -0.00472259521484375 -0.01678466796875 -0.072998046875 0.016571044921875
397 E8E3760C-6AA7-4E10-830A-1F54F6AA1DB1 2019-09-15T14:10:38+00:00 
[
    "Public"
]
 
[]
 jpeg c5ff4567d2b8823acc41ef686539055ca82fb17e9889de24621a623538ea0a7a 4943371     1 0 0 0 0 0 0 0       E8E3760C-6AA7-4E10-830A-1F54F6AA1DB1 0.7294921875 0.75 0.0 0.0626162217773554 0.10000000149011612 -0.001129150390625 0.04541015625 0.004718780517578125 0.009999999776482582 -0.1695556640625 -0.029541015625 0.1900634765625 0.0103302001953125 -0.0083160400390625 -0.002777099609375 0.113037109375 0.0458984375 0.0703125 0.11566162109375 0.01910400390625 -0.0452880859375 0.013275146484375 0.0880126953125 0.033050537109375 0.12371826171875 0.52001953125 0.01488494873046875
2 BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 2019-09-15T13:41:17+00:00 
[
    "Public"
]
 
[]
 jpeg 01aeec21c49bfddd0980785d24f6c5a269c2fae92bc49aa1dcb592d8442cf6fd 7719757     1 0 0 0 0 0 0 0       BDFD0BA5-1272-4F54-80CF-940CEBF0ACE8 0.478271484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.003185272216796875 0.006916046142578125 0.0082550048828125 0.009999999776482582 -0.205078125 -0.091552734375 0.0966796875 0.00734710693359375 -0.025177001953125 -0.085205078125 -0.5166015625 -0.11151123046875 0.08416748046875 -0.055389404296875 0.0017242431640625 -0.0091552734375 0.0018968582153320312 0.004718780517578125 -0.01261138916015625 -0.13525390625 -0.422119140625 -0.012481689453125
466 B1CC5925-B5D2-459D-A9E9-C478226311D8 2019-09-15T13:36:33+00:00 
[
    "Public"
]
 
[]
 jpeg eb0cf641d40ba636af3dc3d20e719211c23d2479ffa5ae69814f570e4df46603 4886735     1 0 0 0 0 0 0 0       B1CC5925-B5D2-459D-A9E9-C478226311D8 0.79052734375 0.75 0.0 0.06262733508612363 0.10000000149011612 -0.0009660720825195312 0.016510009765625 0.004299163818359375 0.009999999776482582 -0.2744140625 -0.0231475830078125 0.381591796875 0.001483917236328125 -0.0121917724609375 -0.03131103515625 -0.085693359375 0.003692626953125 0.345947265625 -0.013671875 0.0076446533203125 -0.02392578125 0.006877899169921875 0.043701171875 0.0267333984375 -0.0008544921875 0.11480712890625 -0.01465606689453125
488 7DDBAB14-E762-46B3-942A-BAD5AB6668A3 2019-09-15T13:14:03+00:00 
[
    "Public"
]
 
[]
 jpeg fb3e9dc60565ab6a9e492642843dba702d5a63c945420c0ec573610bdde8e9b8 6274468     1 0 0 0 0 0 0 0       7DDBAB14-E762-46B3-942A-BAD5AB6668A3 0.77392578125 0.75 0.0 0.062639624107885 0.10000000149011612 -0.001674652099609375 0.0215606689453125 0.0020503997802734375 0.019999999552965164 0.34423828125 -0.043609619140625 0.0489501953125 0.014556884765625 -0.0276947021484375 -0.00164794921875 0.08935546875 -0.0223388671875 0.029205322265625 0.149169921875 0.006847381591796875 -0.001789093017578125 0.00469970703125 0.10687255859375 0.05255126953125 0.12890625 0.65283203125 0.26171875
399 4FB52292-60F3-429B-971F-4843A2BD51B4 2019-09-15T12:53:03+00:00 
[
    "Public"
]
 
[]
 jpeg c708f463941e998c2a9d12854bed87d6e85f2235270312999b216c006a6fdeb1 7760105     1 0 0 0 0 0 0 0       4FB52292-60F3-429B-971F-4843A2BD51B4 0.447021484375 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0018177032470703125 0.027374267578125 0.02685546875 0.019999999552965164 -0.316650390625 -0.053497314453125 0.1463623046875 0.00428009033203125 -0.00894927978515625 -0.0819091796875 -0.28271484375 -0.04461669921875 0.1256103515625 0.0401611328125 0.00994873046875 -0.011474609375 0.00803375244140625 0.007373809814453125 -0.008026123046875 -0.03558349609375 -0.1982421875 -0.00734710693359375
409 0E4C238E-A542-4C53-B676-B76D06C19901 2019-09-15T12:41:34+00:00 
[
    "Public"
]
 
[]
 jpeg cc2a28a48388addca3f543818e440b4d21939a2475cc2d58cb2aa27bc3af747f 5113277     1 0 0 0 0 0 0 0       0E4C238E-A542-4C53-B676-B76D06C19901 0.7958984375 0.75 0.0 0.06262434893892012 0.10000000149011612 -0.014007568359375 0.01042938232421875 0.003482818603515625 0.009999999776482582 0.185791015625 -0.094482421875 -0.1400146484375 0.1470947265625 -0.048583984375 -0.00669097900390625 -0.086669921875 -0.36962890625 0.01029205322265625 0.0726318359375 0.00626373291015625 -0.002170562744140625 0.00426483154296875 0.048492431640625 -0.132568359375 0.046142578125 0.54052734375 0.27783203125

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