photos_with_apple_metadata (view)

10 rows where ZINTERACTIONSCORE = "0.019999999552965164" and albums = "["Museums", "Public"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, latitude, longitude, favorite, place_city, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZNOISESCORE, date (date), albums (array), persons (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
43 A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 2019-08-07T06:22:37+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 1698c710dab87f0f6aeee3f3ef95a0c7f1296abc949dc5d602cdff89c6ec63c5 2233828 -18.907088333333334 47.518475 1 0 0 0 0 0 0 0 Antananarivo Antananarivo Madagascar A06B7B8E-4BF6-4906-A1E6-0CA4CF0E28E8 0.32763671875 0.75 0.0 0.05801763419659083 0.7049635052680969 -0.0004305839538574219 0.07659912109375 0.002471923828125 0.019999999552965164 0.728515625 -0.0227203369140625 0.0977783203125 0.01422882080078125 -0.004398345947265625 0.0112457275390625 0.47314453125 0.401123046875 0.0261077880859375 0.326416015625 0.042083740234375 0.005859375 0.007038116455078125 0.63232421875 0.70458984375 0.4091796875 0.88330078125 0.5439453125
83 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 2018-04-22T00:19:14+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 246821387b2f48b22aa5207af43e16cf8ce0745ae5c68b969804449ebdb0b410 1382543 37.57926666666667 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 0.44775390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00217437744140625 0.007617950439453125 0.00279998779296875 0.019999999552965164 0.0296630859375 -0.06707763671875 0.161865234375 0.005039215087890625 -0.02947998046875 -0.06591796875 -0.220458984375 -0.12347412109375 0.06634521484375 -0.047119140625 0.000492095947265625 -0.016754150390625 0.0034027099609375 0.0193023681640625 -0.02313232421875 -0.205810546875 0.237060546875 0.01519775390625
125 CC3EF420-EAC4-4661-8D68-C2009F892C04 2018-04-22T00:11:12+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic 3b435a93ced7320d53ff8a654508641529d82949253df7256c3baeb6a919385d 1565205 37.57926666666667 -122.34417 0 0 0 0 0 0 0 0 Burlingame CA United States CC3EF420-EAC4-4661-8D68-C2009F892C04 0.23974609375 0.5 0.0 0.038931297721298594 0.5029440522193909 -0.0008831024169921875 0.11505126953125 0.00395965576171875 0.019999999552965164 0.0281982421875 -0.0225067138671875 0.27880859375 0.01009368896484375 -0.0069580078125 0.039337158203125 0.1673583984375 0.260498046875 0.1424560546875 0.36865234375 0.142822265625 -0.00147247314453125 0.00600433349609375 0.501953125 0.66943359375 0.48828125 0.607421875 0.0160064697265625
398 8338977E-56F0-4A7D-A6FD-33C2B27C9364 2018-04-22T00:09:15+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic c606432853e9ab78870a8e725fce86c80a79e443fa99313d69105bfe367a0ebb 1643785 37.57917 -122.344155 0 0 0 0 0 0 0 0 Burlingame CA United States 8338977E-56F0-4A7D-A6FD-33C2B27C9364 0.36279296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012941360473632812 0.027679443359375 0.0012941360473632812 0.019999999552965164 -0.12005615234375 -0.033203125 0.3701171875 0.0015306472778320312 -0.00894927978515625 0.0038604736328125 -0.0025634765625 0.030609130859375 0.054412841796875 0.017578125 0.00809478759765625 -0.013641357421875 0.001628875732421875 0.26904296875 0.358642578125 0.220458984375 0.546875 -0.00630950927734375
486 5A10AEF0-50DA-41BE-80F2-79E3367C343E 2018-04-22T00:02:59+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic fa48b9304c0a1de7f0cc8a3512c76452dc458964ea0394ea346740ed8b71eee9 1657904 37.579253333333334 -122.34418666666667 0 0 0 0 0 0 0 0 Burlingame CA United States 5A10AEF0-50DA-41BE-80F2-79E3367C343E 0.364501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 -0.009002685546875 0.0024242401123046875 0.019999999552965164 -0.136962890625 -0.06658935546875 0.1895751953125 0.00661468505859375 -0.07861328125 -0.124267578125 -0.375244140625 -0.223388671875 0.31005859375 -0.18896484375 -0.0026531219482421875 -0.03070068359375 0.0036067962646484375 0.007518768310546875 -0.0423583984375 -0.465576171875 -0.2138671875 -0.1270751953125
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
351 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 2017-12-03T22:40:16+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic a99406f355b55e1d8c5bf18f8d85761ef703d75b862e715f9e9751c5e0a8bacd 1734045 37.333511666666666 -121.92306333333333 1 0 0 0 0 0 0 0 San Jose CA United States 47AC9BA3-C29C-46BA-855E-829C0EC59FF5 0.477294921875 0.75 0.0 0.058022878381587165 0.10000000149011612 -0.0005526542663574219 0.027008056640625 0.0082855224609375 0.019999999552965164 -0.37451171875 -0.041778564453125 0.27587890625 0.004364013671875 -0.006565093994140625 -0.048553466796875 -0.1864013671875 -0.00262451171875 0.31640625 0.05841064453125 0.00191497802734375 -0.0159454345703125 0.0174407958984375 0.0215301513671875 0.001140594482421875 -0.11749267578125 0.0311279296875 -0.0047607421875
459 03BA87C4-E783-44BC-9626-45983800AE72 2017-12-03T21:29:30+00:00 
[
    "Museums",
    "Public"
]
 
[]
 heic e8b97c85b48fe094964dd0e016e92f71f506e3d8586861f4bd8fe243365b9fe7 2062821 37.333938333333336 -121.92302 0 0 0 0 0 0 0 0 San Jose CA United States 03BA87C4-E783-44BC-9626-45983800AE72 0.50341796875 0.6 0.0 0.04656488550755814 0.10000000149011612 -0.005889892578125 -0.0104827880859375 0.002811431884765625 0.019999999552965164 -0.4658203125 -0.043121337890625 0.2430419921875 0.0018100738525390625 -0.06573486328125 -0.1309814453125 -0.382568359375 -0.1617431640625 0.2509765625 -0.2269287109375 -0.002628326416015625 -0.031951904296875 0.0022869110107421875 0.006122589111328125 -0.02349853515625 -0.289306640625 -0.37255859375 -0.0804443359375
62 ADE494D7-0048-491A-B410-D04C5C58B0DD 2017-07-23T22:20:34+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 1cfb72be21bffca1c026c49845045769dc2791f7844d85d14e74257325d83b23 1988831 37.84245 -122.27783333333333 0 0 0 0 0 0 0 0 Oakland CA United States ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
191 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 2016-11-05T21:21:05+00:00 
[
    "Museums",
    "Public"
]
 
[]
 jpeg 5f9968989d0aad8a9dd9c6aabd5e495444a44a8714a1fa3296a96132b67de178 2555246 37.82716333333333 -122.52745833333333 0 0 0 0 0 0 0 0 Sausalito CA United States 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125

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