photos_with_apple_metadata (view)

13 rows where favorite = 0 and persons = "["_UNKNOWN_"]"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: albums, ext, place_city, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZIMMERSIVENESSSCORE, ZINTERACTIONSCORE, ZPLEASANTSYMMETRYSCORE, 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
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 213.594ms · About: dogsheep/dogsheep-photos