photos_with_apple_metadata (view)

8 rows where ZINTERACTIONSCORE = "0.019999999552965164" and place_city = "San Francisco"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, date (date), albums (array)

place_city ✖

  • San Francisco · 8 ✖

ZINTERACTIONSCORE ✖

  • 0.019999999552965164 · 8 ✖
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
141 ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 2018-02-20T23:28:04+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 4343b8b78aceac81aafddb11d751033ab74b55a41ed0b075e238d272fcfd100c 1495974 37.74249666666667 -122.44919666666667 0 0 0 0 0 0 0 0 San Francisco CA United States ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 0.49755859375 0.5 0.0 0.038931297721298594 0.5044282078742981 -0.0012111663818359375 0.1588134765625 0.03533935546875 0.019999999552965164 0.2685546875 -0.026702880859375 0.157470703125 0.02484130859375 -0.007755279541015625 -0.00732421875 0.225341796875 0.22412109375 0.04132080078125 0.22412109375 0.09417724609375 0.01018524169921875 0.006511688232421875 0.0301055908203125 0.01500701904296875 0.05633544921875 0.040435791015625 0.058685302734375
37 A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 2018-02-20T23:05:22+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[]
 heic 1410392329d163954b764fbf466079c543add302f7fccd5eb9158c132ca093d4 1570524 37.742808333333336 -122.449255 0 0 0 0 0 0 0 0 San Francisco CA United States A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 0.34521484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012254714965820312 0.0301361083984375 0.00919342041015625 0.019999999552965164 0.2430419921875 -0.0616455078125 -0.0184326171875 0.0119171142578125 -0.0135345458984375 -0.0247650146484375 0.134033203125 -0.022705078125 0.02532958984375 0.2529296875 0.0094757080078125 0.00237274169921875 0.0082855224609375 0.0211181640625 -0.0068359375 0.052947998046875 0.224609375 0.245361328125
350 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 2017-11-05T23:06:58+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic a981be272530aba690ff4d6e292c3dbfeb1fee4c9fcca39346043012cf486e49 3639642 37.76914166666667 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 0.4189453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011157989501953125 0.06903076171875 0.00734710693359375 0.019999999552965164 -0.3623046875 -0.03521728515625 0.1944580078125 0.0282135009765625 -0.01137542724609375 -0.0245361328125 -0.04638671875 0.085205078125 0.2430419921875 0.192626953125 0.03240966796875 -0.01221466064453125 0.01450347900390625 0.060516357421875 0.03424072265625 0.024658203125 0.1572265625 0.00374603271484375
132 F142B8D1-24B8-4108-AFB7-0C454C72E625 2017-11-05T23:06:49+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 heic 3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475 4231615 37.76921166666666 -122.46446166666666 0 0 0 0 0 0 0 0 San Francisco CA United States F142B8D1-24B8-4108-AFB7-0C454C72E625 0.468017578125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.0019121170043945312 0.0162353515625 0.0016231536865234375 0.019999999552965164 -0.1405029296875 -0.0204925537109375 0.308349609375 0.0012693405151367188 -0.0310821533203125 -0.024505615234375 0.00177001953125 -0.03289794921875 0.05572509765625 -0.046142578125 0.0059814453125 -0.0129547119140625 0.0024623870849609375 0.11993408203125 0.04132080078125 0.31396484375 0.54833984375 -0.00934600830078125
420 60198E20-708E-4125-B793-4466A87B2DDA 2017-06-16T00:56:17+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg d553261ef8ec0fc2d81eb04e584491dfcba6d4d58b8455cc741c362ec21eea22 5956608 37.76925 -122.46415 0 0 0 0 0 0 0 0 San Francisco CA United States 60198E20-708E-4125-B793-4466A87B2DDA 0.392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00307464599609375 0.0094757080078125 0.001220703125 0.019999999552965164 0.1380615234375 -0.056854248046875 0.2802734375 0.00313568115234375 -0.04559326171875 -0.04010009765625 -0.107666015625 -0.0838623046875 0.048492431640625 -0.160400390625 0.00628662109375 -0.0150909423828125 0.0010166168212890625 0.060760498046875 0.06494140625 -0.0399169921875 0.345947265625 -0.05755615234375
438 57650917-1883-4D73-AD2B-B45C6A661534 2017-03-31T00:53:31+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg ddea960de035d2fc5726dd94a94692f90f7dc60c7e28e19b45fcc765e2d0813c 4243346 37.769146666666664 -122.46449166666666 0 0 0 0 0 0 0 0 San Francisco CA United States 57650917-1883-4D73-AD2B-B45C6A661534 0.3447265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0022525787353515625 0.00321197509765625 0.004627227783203125 0.019999999552965164 -0.00634765625 -0.1229248046875 0.0634765625 0.00844573974609375 -0.0203704833984375 -0.053375244140625 -0.448974609375 -0.152587890625 0.0966796875 -0.019805908203125 -0.00054168701171875 -0.01448822021484375 0.00441741943359375 0.0119171142578125 -0.027587890625 -0.298583984375 -0.009033203125 0.0059814453125
492 D3CF77DA-B6DD-47F1-A69C-3E01122F133E 2017-03-31T00:48:54+00:00 
[
    "Stolen monasteries",
    "Public"
]
 
[]
 jpeg fe7c5489ffa8c070183fe2c559c00b6d5880a6b9a9c53f807962166ec96c4375 4984812 37.7692 -122.46450833333333 0 0 0 0 0 0 0 0 San Francisco CA United States D3CF77DA-B6DD-47F1-A69C-3E01122F133E 0.497314453125 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.002002716064453125 0.0117950439453125 0.002010345458984375 0.019999999552965164 -0.28369140625 -0.018341064453125 0.296630859375 0.002132415771484375 -0.038604736328125 -0.031494140625 -0.022735595703125 -0.041351318359375 0.188232421875 -0.038330078125 0.0035552978515625 -0.016143798828125 0.00455474853515625 0.07452392578125 0.034332275390625 0.2244873046875 0.4072265625 -0.01230621337890625
288 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 2016-04-09T20:10:29+00:00 
[
    "Public"
]
 
[]
 jpeg 8a3115b8c82c630e48b0ac70eb94d8201721937c4697a667916e1632a5063001 3046776 37.78546166666667 -122.43050333333333 0 0 0 0 0 0 0 0 San Francisco CA United States 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375

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