This data as json, CSV (advanced)
Suggested facets: ZBEHAVIORALSCORE, date (date), albums (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
300 | ![]() |
563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 | 2019-08-02T07:32:43+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 8fa3f67420480063a09ea4134c1dae4e8d67262f38433e3a41a2f6eb6aa47bf8 | 5402536 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473 | 0.68701171875 | 0.75 | 0.0 | 0.061090618599462146 | 0.10000000149011612 | -0.0045928955078125 | 0.059783935546875 | 0.024139404296875 | 0.009999999776482582 | -0.1326904296875 | -0.041778564453125 | 0.0091552734375 | 0.01763916015625 | -0.00948333740234375 | -0.0116119384765625 | 0.140625 | 0.001708984375 | 0.047698974609375 | 0.205810546875 | 0.0234832763671875 | 0.00275421142578125 | 0.007122039794921875 | 0.03289794921875 | 0.05401611328125 | 0.03717041015625 | 0.03765869140625 | 0.039886474609375 | |||||
313 | ![]() |
4353C1BC-259D-4814-B113-8E5DBA65470D | 2019-08-02T07:31:01+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 97c5b33f1ede95e3610b213858a47deb2d9b6e84edbc484348eb318234b1725e | 6764077 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4353C1BC-259D-4814-B113-8E5DBA65470D | 0.65869140625 | 0.75 | 0.0 | 0.061090990332246735 | 0.5033819675445557 | -0.0008330345153808594 | 0.05767822265625 | 0.001918792724609375 | 0.009999999776482582 | 0.077880859375 | -0.054107666015625 | 0.08892822265625 | 0.02947998046875 | -0.005535125732421875 | 0.0120697021484375 | 0.1839599609375 | 0.213623046875 | 0.035888671875 | 0.275146484375 | 0.02435302734375 | -0.001705169677734375 | 0.006824493408203125 | 0.44580078125 | 0.517578125 | 0.144287109375 | 0.7705078125 | 0.065185546875 | |||||
243 | ![]() |
18939B2A-0A75-461C-B1D0-7ABD87282C2D | 2019-08-02T07:06:42+00:00 | [ "To Instagram", "Public" ] |
[] |
jpeg | 77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9 | 4601240 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18939B2A-0A75-461C-B1D0-7ABD87282C2D | 0.73486328125 | 0.75 | 0.0 | 0.06263108016880414 | 0.10000000149011612 | -0.00131988525390625 | 0.0268707275390625 | 0.0013151168823242188 | 0.009999999776482582 | -0.0050048828125 | -0.04803466796875 | 0.258544921875 | 0.005138397216796875 | -0.014617919921875 | 0.016845703125 | -0.0245361328125 | 0.05230712890625 | 0.06939697265625 | 0.068603515625 | 0.00927734375 | -0.009765625 | 0.002590179443359375 | 0.316650390625 | 0.431640625 | 0.0804443359375 | 0.6259765625 | 0.010986328125 |
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;