photos_with_apple_metadata (view)

6 rows where "date" is on date 2018-04-21 sorted by ZINTRUSIVEOBJECTPRESENCESCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, latitude, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, albums (array), persons (array)

date (date) ✖

  • 2018-04-21 · 6 ✖
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
249 DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 2018-04-21T23:55:29+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 798436ad6175c55c8785bfbc10c8ffe60913b521a52312735f138f37e3cb4d81 1173698 37.579053333333334 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States DAEEB402-23FC-4CFB-9C40-75DF9B7C0E8F 0.27099609375 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.005279541015625 0.00095367431640625 0.00243377685546875 0.019999999552965164 -0.41845703125 -0.12200927734375 0.01702880859375 0.0144500732421875 -0.038970947265625 -0.09381103515625 -0.54541015625 -0.300048828125 0.050048828125 -0.0985107421875 -0.00109100341796875 -0.01496124267578125 0.0021915435791015625 0.012237548828125 -0.0482177734375 -0.16259765625 -0.0987548828125 -0.0265350341796875
463 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 2018-04-21T23:56:51+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic e9c9c3b5d9d960e1586c1d0751ef30220af107ae28de70ddc52c7da5b37e36db 1870385 37.57906666666667 -122.34423 0 0 0 0 0 0 0 0 Burlingame CA United States 9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5 0.3544921875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.0083770751953125 0.00119781494140625 0.004627227783203125 0.009999999776482582 -0.49560546875 -0.0994873046875 -0.05328369140625 0.04742431640625 -0.041534423828125 -0.05999755859375 -0.501953125 -0.37744140625 0.18798828125 -0.01983642578125 0.00074005126953125 -0.01611328125 0.00815582275390625 0.01085662841796875 -0.07183837890625 -0.10101318359375 -0.13720703125 -0.015838623046875
291 C8CCC8EE-382E-4265-8236-E2F30764A55C 2018-04-21T23:55:50+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_",
    "_UNKNOWN_"
]
 heic 8d0760a255defeab12023c2ad8704cab6b5bd9d20c69bd325ea242a6b22402a9 1719608 37.57926666666667 -122.3442 0 0 0 0 0 0 0 0 Burlingame CA United States C8CCC8EE-382E-4265-8236-E2F30764A55C 0.2325439453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028228759765625 -0.00146484375 0.0015306472778320312 0.03999999910593033 0.1011962890625 -0.07305908203125 0.1485595703125 0.006511688232421875 -0.046722412109375 -0.03564453125 -0.249755859375 -0.18994140625 0.0582275390625 -0.07696533203125 -0.0020275115966796875 -0.0162353515625 0.0019044876098632812 0.0194244384765625 -0.01031494140625 -0.405029296875 0.190185546875 -0.0648193359375
406 84CA3880-9BC5-4FF0-9416-8AF1800985EC 2018-04-21T23:58:06+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic ca6c89425c6d03f3b3f62a708c74f4708339166080dde1b289d842d142c8fd3f 936298 37.57915833333333 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 84CA3880-9BC5-4FF0-9416-8AF1800985EC 0.321044921875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.00243377685546875 0.0157470703125 0.005535125732421875 0.07999999821186066 0.1326904296875 -0.06890869140625 0.02349853515625 0.042327880859375 -0.037689208984375 -0.036102294921875 -0.1865234375 -0.161376953125 0.09637451171875 0.042724609375 0.013031005859375 -0.007396697998046875 0.00679779052734375 0.019561767578125 -0.001312255859375 -0.07696533203125 0.11273193359375 0.023681640625
210 B0DD56EB-03F6-4362-8DAA-DE8580838F78 2018-04-21T23:55:28+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 68b5459d668a8a495c751e177b6c405f27b6e5506502fdd305a6eb0950230854 1265702 37.579053333333334 -122.34420833333333 0 0 0 0 0 0 0 0 Burlingame CA United States B0DD56EB-03F6-4362-8DAA-DE8580838F78 0.229736328125 0.25 0.0 0.019847328255649742 0.10000000149011612 -0.0028553009033203125 0.0131378173828125 0.0029125213623046875 0.009999999776482582 -0.3740234375 -0.05340576171875 0.189697265625 0.00734710693359375 -0.0302734375 -0.09271240234375 -0.25390625 -0.08935546875 0.1517333984375 -0.0830078125 0.006061553955078125 -0.0220489501953125 0.0037212371826171875 0.035888671875 0.0182952880859375 -0.04473876953125 0.0482177734375 -0.020416259765625
374 C82E683C-DE86-4E9F-A083-C236C315D363 2018-04-21T23:55:53+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic b6f0f6ee850459ec2a1cfdd50429c601d1d0ef426d99844c14e8b688b157609e 1850107 37.579258333333335 -122.3442 0 0 0 0 0 0 0 0 Burlingame CA United States C82E683C-DE86-4E9F-A083-C236C315D363 0.30419921875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.005489349365234375 0.0068511962890625 0.004070281982421875 0.009999999776482582 -0.95947265625 -0.0225372314453125 0.0740966796875 0.0007853507995605469 -0.00948333740234375 -0.008514404296875 -0.02099609375 -0.1151123046875 0.01337432861328125 0.018035888671875 -0.030487060546875 -0.007198333740234375 0.0024242401123046875 0.038238525390625 -0.0186309814453125 0.2127685546875 0.32666015625 -0.000232696533203125

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