photos_with_apple_metadata (view)

12 rows where ZINTERACTIONSCORE = "0.009999999776482582" and "date" is on date 2019-09-15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ext, latitude, longitude, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, albums (array)

date (date) ✖

  • 2019-09-15 · 12 ✖

ZINTERACTIONSCORE ✖

  • 0.009999999776482582 · 12 ✖
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
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
448 74949E42-5A82-4CEE-93C6-3FF590F777CB 2019-09-15T13:14:14+00:00 
[
    "Public"
]
 
[]
 jpeg e32ee75d05e5052e8c6cb05455d521b92ba3d12e597c3063e6a7b59ec8c37603 7113473     1 0 0 0 0 0 0 0       74949E42-5A82-4CEE-93C6-3FF590F777CB 0.7529296875 0.75 0.0 0.06263980974677864 0.5051338076591492 -0.0006117820739746094 0.03955078125 0.006145477294921875 0.009999999776482582 0.39501953125 -0.06280517578125 0.167724609375 0.00557708740234375 -0.006488800048828125 0.007598876953125 0.0274658203125 0.143310546875 0.167236328125 0.165771484375 0.00952911376953125 -0.000843048095703125 0.0102081298828125 0.07489013671875 0.09228515625 -0.05126953125 0.416259765625 0.2978515625
469 99A0B8E1-22E2-4640-AC9D-0BBDCB9B02EC 2019-09-15T12:44:27+00:00 
[
    "Public"
]
 
[]
 jpeg ec4dd816bb647c7991e8a77e285528de6853973fbbcd88b3923939938e33b9fb 5720642     1 0 0 0 0 0 0 0       99A0B8E1-22E2-4640-AC9D-0BBDCB9B02EC 0.734375 0.75 0.0 0.06261696478792729 0.7050121426582336 -0.0007700920104980469 0.06378173828125 0.0025615692138671875 0.009999999776482582 0.69482421875 -0.04443359375 0.036102294921875 0.05499267578125 -0.00555419921875 0.00826263427734375 0.400146484375 0.35693359375 0.01678466796875 0.270263671875 0.039459228515625 0.005062103271484375 0.006717681884765625 0.4736328125 0.61376953125 0.20947265625 0.83740234375 0.48095703125
483 AF2D570F-C629-4894-BFC2-FB019F1DAF80 2019-09-15T12:42:31+00:00 
[
    "Public"
]
 
[]
 jpeg f5b01d7ffd018e078bb6e197a4528ba5f030f7504124b9506fd91bbf3f6caa2c 5159422     1 0 0 0 0 0 0 0       AF2D570F-C629-4894-BFC2-FB019F1DAF80 0.65283203125 0.75 0.0 0.061102877136405186 0.7046471834182739 -0.0009326934814453125 0.051116943359375 0.0029239654541015625 0.009999999776482582 0.62353515625 -0.03436279296875 0.024139404296875 0.0709228515625 -0.0136871337890625 0.0076904296875 0.364013671875 0.289794921875 0.014617919921875 0.22509765625 0.0343017578125 0.00511932373046875 0.006389617919921875 0.319091796875 0.295166015625 0.265625 0.8193359375 0.495361328125
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
258 F505A7F3-E583-46DE-8010-D8E6FE116376 2019-09-15T12:22:12+00:00 
[
    "Public"
]
 
[]
 jpeg 7de2e4e9f7166b348eeedac71aca8a8f54ef90c39cc1af6bd29b97356003a5c9 6065443     1 0 0 0 0 0 0 0       F505A7F3-E583-46DE-8010-D8E6FE116376 0.67724609375 0.75 0.0 0.061086160991028066 0.7049391865730286 -0.0007762908935546875 0.03778076171875 0.002208709716796875 0.009999999776482582 0.611328125 -0.03985595703125 0.0484619140625 0.0284881591796875 -0.006744384765625 0.00769805908203125 0.3466796875 0.34228515625 0.0125274658203125 0.1842041015625 0.021484375 0.003406524658203125 0.004398345947265625 0.54833984375 0.70458984375 0.219482421875 0.8525390625 0.417724609375

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