photos_with_apple_metadata (view)

11 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.04353076629056275"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, date (date), albums (array)

place_country ✖

ZHIGHLIGHTVISIBILITYSCORE ✖

  • 0.04353076629056275 · 11 ✖

place_state_province ✖

place_city ✖

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
366 A4F38147-CE20-41A8-8811-583623ABE085 2019-11-02T20:32:27+00:00 
[
    "Public"
]
 
[]
 jpeg b35aff17400287b860379849efbfab739524ed040f0b5d59cebbe71021ac32f6 5028634     0 0 0 0 0 0 0 0       A4F38147-CE20-41A8-8811-583623ABE085 0.7412109375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0028553009033203125 0.00070953369140625 0.0025806427001953125 0.07999999821186066 0.11181640625 -0.07879638671875 0.07183837890625 0.01450347900390625 -0.046112060546875 -0.03326416015625 -0.28515625 -0.2376708984375 0.050811767578125 -0.037841796875 -0.001598358154296875 -0.0120697021484375 0.0027141571044921875 0.012969970703125 -0.021575927734375 -0.32666015625 0.1380615234375 -0.026336669921875
44 46ABC862-9837-404A-832B-4158270704FF 2019-11-02T20:32:16+00:00 
[
    "Public"
]
 
[]
 jpeg 169984801ec60631b48ca4acac75c2c745951a72024d7145f7803a2978e59267 4760871     0 0 0 0 0 0 0 0       46ABC862-9837-404A-832B-4158270704FF 0.7314453125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0031604766845703125 -0.007091522216796875 0.0027141571044921875 0.019999999552965164 0.05517578125 -0.057586669921875 0.1978759765625 0.004055023193359375 -0.05718994140625 -0.051116943359375 -0.272216796875 -0.1932373046875 0.1597900390625 -0.08160400390625 -0.00304412841796875 -0.0216217041015625 0.0029125213623046875 0.006717681884765625 -0.0247039794921875 -0.5302734375 -0.07275390625 -0.1270751953125
331 1B6765D2-F281-48DB-A23A-C081FFAC69DC 2019-11-02T20:31:26+00:00 
[
    "Public"
]
 
[]
 jpeg a12312146b3a13e844481394def7506dbc27b794f150796b466c07c65e2d77b0 4561109     0 0 0 0 0 0 0 0       1B6765D2-F281-48DB-A23A-C081FFAC69DC 0.7705078125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0023326873779296875 -0.00392913818359375 0.00217437744140625 0.009999999776482582 -0.1573486328125 -0.11859130859375 0.0679931640625 0.00864410400390625 -0.030670166015625 -0.083984375 -0.52197265625 -0.2744140625 0.12139892578125 -0.083740234375 -0.001941680908203125 -0.02880859375 0.004199981689453125 0.00841522216796875 -0.029266357421875 -0.431396484375 -0.082763671875 -0.0531005859375
479 FF230430-EDD4-4E3F-83F9-C105A7EE7598 2019-11-02T20:31:02+00:00 
[
    "Public"
]
 
[]
 jpeg f5540186893e81abf2b46cb2108caa981d5a1e063e184f7242709e6287437911 4817123     0 0 0 0 0 0 0 0       FF230430-EDD4-4E3F-83F9-C105A7EE7598 0.76220703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0017681121826171875 -0.0049896240234375 0.002349853515625 0.019999999552965164 0.139404296875 -0.047515869140625 0.317626953125 0.00147247314453125 -0.0364990234375 -0.051422119140625 -0.1719970703125 -0.1263427734375 0.1759033203125 -0.0941162109375 -0.0011386871337890625 -0.03131103515625 0.003223419189453125 0.0094146728515625 -0.01128387451171875 -0.53125 0.0823974609375 -0.117431640625
341 65600C73-CFBC-4FD9-AADE-9CA39F776FC2 2019-11-02T20:30:31+00:00 
[
    "Public"
]
 
[]
 jpeg a50d3c5dc31188f36a8f2f6176c6469a5b62cb270962ba63737b3bfc5c9462f8 4837662     0 0 0 0 0 0 0 0       65600C73-CFBC-4FD9-AADE-9CA39F776FC2 0.70703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.004070281982421875 0.00601959228515625 0.01132965087890625 0.019999999552965164 -0.5419921875 -0.152099609375 0.0072021484375 0.012725830078125 -0.01111602783203125 -0.11370849609375 -0.69384765625 -0.262939453125 0.1044921875 -0.0220947265625 0.00093841552734375 -0.0264434814453125 0.005039215087890625 0.0030517578125 -0.03656005859375 -0.08477783203125 -0.47119140625 -0.0071563720703125
185 398058A8-F11E-4306-8272-05A438B6E523 2019-11-02T20:30:21+00:00 
[
    "Public"
]
 
[]
 jpeg 5bad707a8d2196bdb37eaea0501f8745535af125cc5bf5725451258a6247847d 4283013     0 0 0 0 0 0 0 0       398058A8-F11E-4306-8272-05A438B6E523 0.74365234375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0008935928344726562 0.0330810546875 0.0116424560546875 0.009999999776482582 -0.833984375 -0.0160980224609375 0.050872802734375 0.0024433135986328125 -0.0033245086669921875 -0.001247406005859375 0.362548828125 0.1444091796875 0.02447509765625 0.1607666015625 -0.00890350341796875 -0.001003265380859375 0.01433563232421875 0.11376953125 0.025970458984375 0.2293701171875 0.56982421875 0.01476287841796875
259 08D18A51-8004-4F00-B79E-4AA1628FB111 2019-11-02T20:30:15+00:00 
[
    "Public"
]
 
[]
 jpeg 7e284f6fd7631015c32f82d4f57454941dc145fa608e510ccc84fea71b09cab1 4289135     0 0 0 0 0 0 0 0       08D18A51-8004-4F00-B79E-4AA1628FB111 0.78125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.8681640625 -0.032379150390625 0.00734710693359375 0.009999999776482582 -0.82080078125 -0.10614013671875 0.03277587890625 0.0027370452880859375 -0.3720703125 -0.317626953125 -0.8310546875 -0.62158203125 0.019683837890625 -0.69287109375 -0.003093719482421875 -0.026031494140625 0.0002472400665283203 0.00030541419982910156 -0.98193359375 -0.50048828125 -0.818359375 -0.8115234375
65 FC01AB36-9465-4F95-8DC9-618FBC1405A6 2019-11-02T20:30:03+00:00 
[
    "Public"
]
 
[]
 jpeg 1da3b02a32b8235544f503965aa55528896aa637e79e12bdf6493c8541967cea 4491789     0 0 0 0 0 0 0 0       FC01AB36-9465-4F95-8DC9-618FBC1405A6 0.76708984375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0016355514526367188 0.00383758544921875 0.00473785400390625 0.019999999552965164 -0.46875 -0.10015869140625 0.09564208984375 0.0033111572265625 -0.011871337890625 -0.065673828125 -0.497802734375 -0.1065673828125 0.06732177734375 -0.025115966796875 -0.002429962158203125 -0.0179290771484375 0.003040313720703125 0.0097808837890625 -0.01000213623046875 -0.1546630859375 -0.1719970703125 -0.0113983154296875
279 A8949702-A151-4ACD-8F3C-D5957F481E5A 2018-02-13T18:55:13+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg 85d802ffe4def2a666fed10fe1da638ef804d8e499a8899c23471705df60163c 5342238 25.736453769238338 -111.09069569453112 0 0 0 0 0 0 0 0     Mexico A8949702-A151-4ACD-8F3C-D5957F481E5A 0.72412109375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0010480880737304688 0.025848388671875 0.0018033981323242188 0.009999999776482582 -0.166748046875 -0.020172119140625 0.36181640625 0.0021991729736328125 -0.016845703125 0.00335693359375 0.013946533203125 0.0294189453125 0.1356201171875 0.03472900390625 0.0109405517578125 -0.019073486328125 0.00391387939453125 0.1959228515625 0.1380615234375 0.236572265625 0.525390625 -0.006011962890625
329 D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 2018-02-13T18:53:48+00:00 
[
    "Geotaggable Photos geotagged",
    "Public"
]
 
[]
 jpeg a02327731c68afc82e3f442932167fd2a273ea95c0fa968b0199a73141dd99f4 5960871 25.737367127877967 -111.09099263484735 0 0 0 0 0 0 0 0     Mexico D2E8BA79-361D-4888-BCE6-80E7DEE2D5D8 0.76025390625 0.5 0.0 0.04353076629056275 0.10111922025680542 -0.00070953369140625 0.08514404296875 0.003692626953125 0.05999999865889549 0.16162109375 -0.01812744140625 0.403076171875 0.00274658203125 -0.0069580078125 0.005615234375 0.1458740234375 0.09783935546875 0.054290771484375 0.1104736328125 0.02960205078125 -0.00168609619140625 0.00441741943359375 0.157958984375 0.078125 0.41064453125 0.6162109375 0.0361328125
390 C721AC7F-4D2E-447B-A789-B605FA9B9D99 2018-02-09T17:33:32+00:00 
[
    "Public"
]
 
[]
 jpeg c3f1191b7ce8e4f4643e3ec3efb3040e0668e42bb966e6b90c5b4e7b36e8ecfd 5895146     0 0 0 0 0 0 0 0       C721AC7F-4D2E-447B-A789-B605FA9B9D99 0.734375 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.002704620361328125 0.00797271728515625 0.0014047622680664062 0.009999999776482582 -0.296875 -0.040252685546875 0.11865234375 0.00586700439453125 -0.060211181640625 -0.05859375 -0.097412109375 -0.121826171875 0.0604248046875 -0.057373046875 0.002368927001953125 -0.017059326171875 0.0032100677490234375 0.06634521484375 0.012908935546875 0.12347412109375 0.464111328125 -0.00754547119140625

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