photos_with_apple_metadata (view)

17 rows where persons = "["_UNKNOWN_"]" sorted by ZPROMOTIONSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, favorite, place_city, place_state_province, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZNOISESCORE, ZPLEASANTSYMMETRYSCORE, date (date), albums (array), persons (array)

persons ✖

  • ["_UNKNOWN_"] · 17 ✖

hdr ✖

  • 0 17
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
116 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 2019-09-16T16:27:24+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 38c5c9797285ca569d63a524a7a217b562c289e2b8068122e5dd7329348cfe4c 1987600 37.449821666666665 -122.18592 1 0 0 0 0 0 0 0 Menlo Park CA United States 159FCAD3-7088-4AEB-929A-7BCDFF4A628A 0.443115234375 0.75 0.0 0.9740458015380925 0.10000000149011612 -0.000743865966796875 0.0360107421875 0.0125732421875 0.009999999776482582 0.1959228515625 -0.08599853515625 0.06207275390625 0.020965576171875 -0.00963592529296875 -0.040130615234375 -0.1871337890625 0.0689697265625 0.23583984375 0.19287109375 0.013458251953125 -0.00125885009765625 0.0169219970703125 0.0169219970703125 0.00560760498046875 -0.0806884765625 -0.0244140625 0.116943359375
282 7E07EFBF-1F63-4142-8856-7DCD9F906811 2019-09-14T16:27:56+00:00 
[
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 86e8a0932628c6450de3649297ab0295831bb3963b186b262d8ff4bfdf9cfef0 1699486 29.941283333333335 -90.07913883333333 1 0 0 0 0 0 0 0 New Orleans LA United States 7E07EFBF-1F63-4142-8856-7DCD9F906811 0.361328125 0.75 0.0 0.05801526718694745 0.5045255422592163 -0.0028228759765625 0.0236358642578125 0.002521514892578125 0.009999999776482582 0.42626953125 -0.0970458984375 -0.021026611328125 0.04168701171875 -0.00844573974609375 0.00287628173828125 0.1065673828125 0.0474853515625 0.01049041748046875 0.16552734375 0.0140838623046875 -7.2479248046875e-05 0.0039005279541015625 0.2330322265625 0.47900390625 0.10040283203125 0.71728515625 0.31689453125
212 46BAA089-F20D-40E3-8161-5C0FA28FAA90 2019-09-11T16:31:25+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 6952898f95114d886494ec5e9df99510a745a0d1ef1fef61d7d924234284f687 1910261 29.934663333333333 -90.06162216666667 1 0 0 0 0 0 0 0 New Orleans LA United States 46BAA089-F20D-40E3-8161-5C0FA28FAA90 0.57666015625 0.75 0.0 0.0580211847110559 0.10000000149011612 -0.00044083595275878906 0.00860595703125 0.0017414093017578125 0.14000000059604645 0.34814453125 -0.051177978515625 0.31787109375 0.0015125274658203125 -0.01107025146484375 0.000823974609375 -0.06640625 -0.00482177734375 0.06878662109375 -0.014892578125 0.00110626220703125 -0.015899658203125 0.0032978057861328125 0.0634765625 0.028564453125 -0.33447265625 0.505859375 -0.003997802734375
419 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 2018-05-18T20:39:03+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic d4d2ad853a4bbb3b4ffd93c582b6567943b3edbc0daf7400754740b61b09a755 1884793 37.04161116666667 -122.07271666666666 1 0 0 0 0 0 0 0 Felton CA United States 4730CC47-5D37-4A64-A6D2-D44CDF5F5B0C 0.385009765625 0.75 0.0 0.05802466925091416 0.10000000149011612 -0.0021572113037109375 -0.0006103515625 0.0034160614013671875 0.009999999776482582 -0.064208984375 -0.09930419921875 0.287109375 0.004180908203125 -0.016845703125 -0.0426025390625 -0.50341796875 -0.06573486328125 0.1298828125 -0.06414794921875 -0.007534027099609375 -0.0122222900390625 0.0013456344604492188 0.01177978515625 0.0101470947265625 -0.53271484375 -0.367919921875 -0.1138916015625
342 E5CE20F5-1129-4B42-B765-D847EE083715 2018-04-22T00:15:27+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic a5e2d73b2ecb3c659734df6f3a73247ee4630cda0e44eade13e964894de7a03e 695247 37.57915 -122.3441 0 0 0 0 0 0 0 0 Burlingame CA United States E5CE20F5-1129-4B42-B765-D847EE083715 0.354736328125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0029811859130859375 -0.00356292724609375 0.003765106201171875 0.009999999776482582 -0.5068359375 -0.06512451171875 0.155029296875 0.0029239654541015625 -0.027435302734375 -0.134521484375 -0.495849609375 -0.180908203125 0.1697998046875 -0.162353515625 -0.0001468658447265625 -0.0251922607421875 0.0031604766845703125 0.005889892578125 -0.0141448974609375 -0.1646728515625 -0.341552734375 -0.03619384765625
439 D6E497F5-7F93-4434-96D4-7927D358886A 2018-04-22T00:11:18+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic decf63b8e7a30b93e080919d312b4d985736ca17678d96fa4fdd3ce81c84a721 1463975 37.57925 -122.34418666666667 0 0 0 0 0 0 0 0 Burlingame CA United States D6E497F5-7F93-4434-96D4-7927D358886A 0.331787109375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0006289482116699219 0.033294677734375 0.0013942718505859375 0.009999999776482582 0.0574951171875 -0.040771484375 0.29443359375 0.0038700103759765625 -0.01107025146484375 0.030059814453125 0.014404296875 0.0875244140625 0.0965576171875 0.1214599609375 0.0136871337890625 -0.009765625 0.0038394927978515625 0.333984375 0.30810546875 0.0755615234375 0.6279296875 0.008331298828125
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
324 63D46A8E-CB33-48E1-A6A6-662AF9AD922D 2018-04-22T00:07:16+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 9dbef4fb7519b183da13d3ce4beb757618271e8a3b5805186c71c661d8979557 1922748 37.57928 -122.344095 0 0 0 0 0 0 0 0 Burlingame CA United States 63D46A8E-CB33-48E1-A6A6-662AF9AD922D 0.343017578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0009698867797851562 0.048065185546875 0.0038089752197265625 0.009999999776482582 -0.1185302734375 -0.0616455078125 0.208984375 0.01029205322265625 -0.01132965087890625 -0.01513671875 -0.109130859375 0.07952880859375 0.1773681640625 0.173828125 0.0297088623046875 -0.0113525390625 0.006565093994140625 0.1048583984375 0.1142578125 0.0379638671875 0.283447265625 0.007232666015625
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
354 A6C2C9FE-D032-450F-B0FC-AF6191226FA9 2018-02-20T23:15:38+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic abb62ed287656b13ebdd9963dcb71d17831ccb5501f9523c0bfa2e556e8805c2 1898626 37.74283833333333 -122.44926333333333 0 0 0 0 0 0 0 0 San Francisco CA United States A6C2C9FE-D032-450F-B0FC-AF6191226FA9 0.50341796875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0165863037109375 0.020751953125 0.00646209716796875 0.009999999776482582 -0.52392578125 -0.09600830078125 -0.0655517578125 0.039276123046875 -0.01322174072265625 -0.01092529296875 -0.2071533203125 -0.216064453125 0.0210113525390625 0.0928955078125 0.00466156005859375 -0.0024623870849609375 0.0027904510498046875 0.049224853515625 0.1353759765625 0.01953125 0.07037353515625 0.038360595703125
332 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 2018-02-20T22:59:09+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic a1c242e31c11211b88364db77fd8fb313aa9cdd5bbc4136c84731685c0763ecc 1632132 37.742763333333336 -122.44917166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 8D9702F9-ACED-47C4-B09C-19F9F72F17D4 0.414306640625 0.5 0.0 0.8022900763472528 0.10000000149011612 -0.00323486328125 0.0179290771484375 0.00926971435546875 0.009999999776482582 -0.119873046875 -0.08538818359375 -0.0933837890625 0.020843505859375 -0.015899658203125 -0.0323486328125 -0.0849609375 -0.21923828125 0.024658203125 0.19921875 0.005413055419921875 -0.001407623291015625 0.00800323486328125 0.0139007568359375 -0.0426025390625 0.01751708984375 0.11553955078125 0.1260986328125
108 499ABED7-CDCD-4A72-B9FD-21DD54B6008F 2018-02-20T22:21:26+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 35466149067766d36bc97080600b0a469758eeab0b3eb1db2faf12a080486102 1814157 37.74257166666666 -122.44925 0 0 0 0 0 0 0 0 San Francisco CA United States 499ABED7-CDCD-4A72-B9FD-21DD54B6008F 0.2783203125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00130462646484375 0.03997802734375 0.01049041748046875 0.009999999776482582 0.36865234375 -0.07586669921875 -0.04473876953125 0.01142120361328125 -0.0103302001953125 -0.03631591796875 0.1702880859375 -0.0628662109375 0.0207977294921875 0.326171875 0.01084136962890625 0.00504302978515625 0.00864410400390625 0.016845703125 -0.0132598876953125 0.038330078125 0.1710205078125 0.299560546875
245 44477DDB-EA24-427E-ACD0-8EFFAD9D167F 2018-02-20T22:07:06+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 78a1f825ca163f4213539e9b525ea2b144b36f0987592fde7ca24d3043d63fb5 1746321 37.742175 -122.44953 0 0 0 0 0 0 0 0 San Francisco CA United States 44477DDB-EA24-427E-ACD0-8EFFAD9D167F 0.4375 0.5 0.0 0.038931297721298594 0.704501211643219 -0.0008625984191894531 0.0537109375 0.00243377685546875 0.009999999776482582 0.703125 -0.030853271484375 0.0823974609375 0.011871337890625 -0.0097808837890625 0.0075225830078125 0.32470703125 0.1927490234375 0.015899658203125 0.2098388671875 0.02374267578125 0.004673004150390625 0.00400543212890625 0.292724609375 0.306396484375 0.3408203125 0.78125 0.54736328125
478 346ACDE4-6BD5-4C40-916B-04184921FAFA 2018-02-20T22:03:31+00:00 
[
    "Ray Bandar for Niche Museums",
    "Ray Bandar's Bone Palace",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic f4a9910714b612db6be14d8250aaf6468e2baa81bbe7a3171ed5fe6e20bb5242 1580411 37.74218833333333 -122.44960833333333 0 0 0 0 0 0 0 0 San Francisco CA United States 346ACDE4-6BD5-4C40-916B-04184921FAFA 0.4892578125 0.5 0.0 0.038931297721298594 0.5053771138191223 -0.0009288787841796875 0.035919189453125 0.0027370452880859375 0.009999999776482582 0.380859375 -0.0526123046875 0.118896484375 0.007232666015625 -0.00937652587890625 0.009307861328125 0.09869384765625 0.156982421875 0.033721923828125 0.1531982421875 0.01126861572265625 0.000446319580078125 0.0031604766845703125 0.16015625 0.21435546875 0.137451171875 0.58447265625 0.38427734375
121 76336F73-88DA-4E89-8E57-4A38FEA2986B 2017-10-27T20:53:21+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 heic 39fd5df732f4fb55c94fc2d90bbe3abcf8e5a748d6b5800817d063c4f1a5e0c5 1735752 37.80936166666667 -122.42176166666667 0 0 0 0 0 0 0 0 San Francisco CA United States 76336F73-88DA-4E89-8E57-4A38FEA2986B 0.413818359375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0007381439208984375 0.0229949951171875 0.0022258758544921875 0.009999999776482582 -0.254638671875 -0.0230255126953125 0.07403564453125 0.00905609130859375 -0.01450347900390625 0.0073089599609375 0.19091796875 0.10369873046875 0.03436279296875 0.240478515625 0.0076141357421875 -0.003936767578125 0.0083160400390625 0.33203125 0.13232421875 0.221435546875 0.76416015625 0.01605224609375
470 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 2017-07-23T22:13:38+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg edcd504a5dc67013013c8de46adbc2f586d9d56e572d634d594390fd81b20a95 2233683 37.84250333333333 -122.27778666666667 0 0 0 0 0 0 0 0 Oakland CA United States 20AF6E7C-F979-40F6-9808-71FD59CAE1B8 0.405517578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0017681121826171875 -0.00296783447265625 0.0022258758544921875 0.009999999776482582 -0.478271484375 -0.06671142578125 0.252685546875 0.0009074211120605469 -0.0202178955078125 -0.118896484375 -0.44580078125 -0.0966796875 0.0823974609375 -0.167724609375 -0.0023097991943359375 -0.034423828125 0.0016355514526367188 0.01061248779296875 -0.007694244384765625 -0.294677734375 -0.1962890625 -0.0555419921875
432 69C46054-1D8F-4FD6-ABC7-2369C79921F4 2016-11-05T20:55:46+00:00 
[
    "Museums",
    "Public"
]
 
[
    "_UNKNOWN_"
]
 jpeg d966b699790953594f2be6cc03c5e5b3d478ebf27122037a7dc022db7642411e 2299000 37.828136666666666 -122.52736666666667 0 0 0 0 0 0 0 0 Sausalito CA United States 69C46054-1D8F-4FD6-ABC7-2369C79921F4 0.4814453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0009508132934570312 0.047760009765625 0.05499267578125 0.009999999776482582 -0.06640625 -0.043701171875 0.10211181640625 0.0026111602783203125 -0.004505157470703125 -0.045806884765625 0.0196533203125 0.0323486328125 0.05194091796875 0.1417236328125 0.0133056640625 0.00213623046875 0.00971221923828125 0.00661468505859375 -0.0017147064208984375 -0.00029754638671875 -0.0811767578125 0.0098724365234375

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