photos_with_apple_metadata (view)

10 rows where ZINTERACTIONSCORE = "0.07999999821186066"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, favorite, ZCURATIONSCORE, ZBEHAVIORALSCORE, ZINTRUSIVEOBJECTPRESENCESCORE, 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
78 92BCC6F0-0144-4501-A78D-778B3E48BF39 2020-01-25T20:09:19+00:00 
[
    "Public"
]
 
[]
 jpeg 22772bd05c0d6e769ea86ebaa1b58ed1645b4eabc9dcc9fea052196954438fdc 7751570     1 0 0 0 0 0 0 0       92BCC6F0-0144-4501-A78D-778B3E48BF39 0.46826171875 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0017681121826171875 -0.00048828125 0.0016937255859375 0.07999999821186066 0.163818359375 -0.08270263671875 0.21875 0.006412506103515625 -0.0310821533203125 -0.04290771484375 -0.2724609375 -0.14111328125 0.205078125 -0.07684326171875 -0.002254486083984375 -0.0218658447265625 0.0035648345947265625 0.021820068359375 0.0149688720703125 -0.49609375 0.0904541015625 -0.0667724609375
139 665B18F1-6E4A-436B-A415-11622E442B2C 2020-01-25T19:39:28+00:00 
[
    "Public"
]
 
[]
 jpeg 42819b1d0b26b476c552433396fecaf1be936248ced47197a9eed334600c24e1 5033561     1 0 0 0 0 0 0 0       665B18F1-6E4A-436B-A415-11622E442B2C 0.5908203125 0.75 0.0 0.06110454879644263 0.10000000149011612 -0.0010690689086914062 0.0222320556640625 0.0021991729736328125 0.07999999821186066 0.3505859375 -0.0982666015625 0.031463623046875 0.01016998291015625 -0.00809478759765625 -0.0009613037109375 -0.026611328125 0.0654296875 0.0167236328125 0.1898193359375 0.01091766357421875 -0.001750946044921875 0.0030040740966796875 0.1026611328125 0.107666015625 0.0660400390625 0.53173828125 0.270751953125
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
250 2C40753A-80EB-4B9E-B0C4-678E61A06C55 2019-11-02T20:31:46+00:00 
[
    "Public"
]
 
[]
 jpeg 79c147d029b433c3ef13a29afe060dfa4866b928c64f375788df5ecc2a2d0e65 4392510     0 0 0 0 0 0 0 0       2C40753A-80EB-4B9E-B0C4-678E61A06C55 0.6650390625 0.5 0.0 0.042004234918201246 0.10000000149011612 -0.0025310516357421875 0.00339508056640625 0.00257110595703125 0.07999999821186066 -0.0814208984375 -0.115966796875 0.0992431640625 0.00766754150390625 -0.0218658447265625 -0.06072998046875 -0.459228515625 -0.179931640625 0.043853759765625 -0.04547119140625 -0.0023193359375 -0.020782470703125 0.001926422119140625 0.010009765625 -0.0220947265625 -0.298095703125 -0.0684814453125 0.0150146484375
126 A967087A-B06E-4B0E-A1E6-015C61FD460E 2019-09-15T13:14:09+00:00 
[
    "Public"
]
 
[]
 jpeg 3bb9961495d7ee420b248a932ddd3335ea67e7eed4bfae3b586f75e7883f80fc 5799222     1 0 0 0 0 0 0 0       A967087A-B06E-4B0E-A1E6-015C61FD460E 0.79052734375 0.75 0.0 0.0626213627917166 0.5045498609542847 -0.001461029052734375 0.03533935546875 0.0022869110107421875 0.07999999821186066 0.5009765625 -0.044769287109375 0.01611328125 0.06634521484375 -0.0104522705078125 0.007366180419921875 0.31103515625 0.2568359375 0.0154266357421875 0.212646484375 0.02606201171875 0.002635955810546875 0.00577545166015625 0.495849609375 0.69287109375 0.215087890625 0.83984375 0.302978515625
160 536F85D8-60B3-4728-A836-04663A86DC6B 2019-09-15T13:08:42+00:00 
[
    "Public"
]
 
[]
 jpeg 4da99e1ec6bac9b6ab7f26b8aeda078259305b460e2fa33810b485c1760725ad 5423408     1 0 0 0 0 0 0 0       536F85D8-60B3-4728-A836-04663A86DC6B 0.80859375 0.75 0.0 0.06261790617731691 0.5048418641090393 -0.0010204315185546875 0.0242462158203125 0.001941680908203125 0.07999999821186066 0.55126953125 -0.057708740234375 -0.000274658203125 0.0999755859375 -0.01384735107421875 0.0078887939453125 0.22412109375 0.2369384765625 0.0125732421875 0.159912109375 0.0168914794921875 0.001590728759765625 0.005687713623046875 0.363525390625 0.435546875 0.07342529296875 0.83544921875 0.35693359375
262 2A621F4B-A826-437E-91A4-6A0597D08134 2019-08-21T16:05:33+00:00 
[
    "Public"
]
 
[]
 jpeg 7f2931e3486143bc295f99a386810b08659dbdb8d5650e8ba4d729607902f383 6791599     1 0 0 0 0 0 0 0       2A621F4B-A826-437E-91A4-6A0597D08134 0.6923828125 0.75 0.0 0.06111884981621313 0.10000000149011612 -0.033599853515625 -0.001697540283203125 0.004608154296875 0.07999999821186066 -0.1505126953125 -0.06890869140625 0.0955810546875 0.00524139404296875 -0.0709228515625 -0.060699462890625 -0.274658203125 -0.281005859375 0.031982421875 -0.1253662109375 -0.002590179443359375 -0.0123138427734375 0.0016546249389648438 0.01137542724609375 -0.495849609375 -0.18505859375 0.1790771484375 -0.154052734375
48 7CB33AD0-0953-4440-93D1-E1E67A227D7B 2019-08-21T15:32:05+00:00 
[
    "Public"
]
 
[]
 jpeg 1821e43e6f6a45b1a9701f777256dec1f11af076631cdfed6a5d312726500ca9 6723417     1 0 0 0 0 0 0 0       7CB33AD0-0953-4440-93D1-E1E67A227D7B 0.7607421875 0.75 0.0 0.06263442348887902 0.7047201991081238 -0.0006566047668457031 0.0491943359375 0.001918792724609375 0.07999999821186066 0.7900390625 -0.037384033203125 0.055145263671875 0.01384735107421875 -0.00391387939453125 0.00716400146484375 0.439453125 0.315673828125 0.0170440673828125 0.256103515625 0.01934814453125 0.0042572021484375 0.00582122802734375 0.5791015625 0.76171875 0.2646484375 0.88427734375 0.677734375
379 E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F 2019-08-21T15:27:59+00:00 
[
    "Public"
]
 
[]
 jpeg bd939e829e1f2bc97273efcf9fae6e0a8ac27aca2d43c3f470b8b5c78142674d 8000011     1 0 0 0 0 0 0 0       E3B35625-BFB0-4B60-8AF0-DCC73FFDA62F 0.65771484375 0.75 0.0 0.06110622000148278 0.10000000149011612 -0.6279296875 -0.0198211669921875 0.01238250732421875 0.07999999821186066 -0.82373046875 -0.0999755859375 0.06378173828125 0.003692626953125 -0.11474609375 -0.2054443359375 -0.77197265625 -0.46337890625 0.028656005859375 -0.48583984375 -0.0035343170166015625 -0.0204010009765625 0.0005359649658203125 0.001094818115234375 -0.94091796875 -0.225341796875 -0.68701171875 -0.49853515625
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

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