This data as json, CSV (advanced)
Suggested facets: albums, persons, favorite, place_state_province, place_country, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZINTERACTIONSCORE, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
407 | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 2019-08-24T13:59:14+00:00 | [ "Public" ] |
[] |
heic | cb68fc3efc0aea4f4b216de475ddeaacd084e89f4251821dda1021a96662e84e | 1763966 | 48.866238333333335 | 2.3550033333333333 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Paris | Île-de-France | France | A3697779-FE08-47A2-A0F1-F72E5F253A9A | 0.4736328125 | 0.75 | 0.0 | 0.05801526718694745 | 0.7040632367134094 | -0.0008969306945800781 | 0.05682373046875 | 0.0017414093017578125 | 0.009999999776482582 | 0.6640625 | -0.02880859375 | 0.1156005859375 | 0.00847625732421875 | -0.005260467529296875 | 0.00762176513671875 | 0.33642578125 | 0.2490234375 | 0.0131683349609375 | 0.2069091796875 | 0.023590087890625 | 0.0031070709228515625 | 0.0030517578125 | 0.58935546875 | 0.74755859375 | 0.3955078125 | 0.8681640625 | 0.488525390625 | |
410 | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 2018-04-22T00:18:11+00:00 | [ "Museums", "Public" ] |
[ "_UNKNOWN_", "_UNKNOWN_" ] |
heic | ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a | 1495272 | 37.57904666666667 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | F55C40DC-FF30-40F0-92BD-FBD1BD14B68B | 0.1875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.012054443359375 | -0.01104736328125 | 0.0017414093017578125 | 0.009999999776482582 | -0.1734619140625 | -0.09124755859375 | 0.07891845703125 | 0.010986328125 | -0.1014404296875 | -0.08251953125 | -0.462646484375 | -0.359130859375 | 0.07611083984375 | -0.150390625 | -0.00496673583984375 | -0.0238494873046875 | 0.0022335052490234375 | 0.007755279541015625 | -0.208251953125 | -0.61328125 | 0.0023193359375 | -0.1900634765625 | |
175 | 978E05B3-A903-4F27-A219-92603A4880B5 | 2018-02-20T22:37:35+00:00 | [ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ] |
[] |
heic | 58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f | 1770398 | 37.742308333333334 | -122.44956166666667 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 978E05B3-A903-4F27-A219-92603A4880B5 | 0.470458984375 | 0.75 | 0.0 | 0.05801526718694745 | 0.10000000149011612 | -0.0018892288208007812 | 0.009368896484375 | 0.0017414093017578125 | 0.009999999776482582 | -0.03662109375 | -0.103759765625 | 0.056243896484375 | 0.0068511962890625 | -0.015899658203125 | -0.037567138671875 | -0.27294921875 | -0.12939453125 | 0.02947998046875 | 0.02142333984375 | 0.001251220703125 | -0.0097808837890625 | 0.002620697021484375 | 0.03656005859375 | -0.001678466796875 | -0.088623046875 | 0.303466796875 | 0.0738525390625 |
JSON shape: default, array, newline-delimited
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;