This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 289 | ![]() |
277756C5-6924-4E30-877D-CD2CE30630FD | 2018-04-22T00:17:52+00:00 | [
"Museums",
"Public"
] |
[] |
heic | 8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af | 1177569 | 37.579096666666665 | -122.34413833333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Burlingame | CA | United States | 277756C5-6924-4E30-877D-CD2CE30630FD | 0.266357421875 | 0.25 | 0.0 | 0.019847328255649742 | 0.10000000149011612 | -0.003795623779296875 | -0.0030517578125 | 0.0010366439819335938 | 0.009999999776482582 | -0.449951171875 | -0.03875732421875 | 0.1923828125 | 0.00323486328125 | -0.07781982421875 | -0.06396484375 | -0.1732177734375 | -0.1572265625 | 0.07476806640625 | -0.1436767578125 | -0.00726318359375 | -0.03466796875 | 0.0022602081298828125 | 0.035736083984375 | -0.0068206787109375 | -0.1612548828125 | 0.345703125 | -0.03826904296875 |
| 211 | ![]() |
E4D43462-07AB-4803-9DCB-02B8321D8D94 | 2016-01-13T20:30:46+00:00 | [
"Museums",
"Public"
] |
[] |
jpeg | 692e3b73c2d9297f354c7b9827d05cd697fd4b83885747a869b2478ec44632c5 | 2259762 | 37.78168 | -122.411025 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | E4D43462-07AB-4803-9DCB-02B8321D8D94 | 0.22265625 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0007615089416503906 | 0.0242156982421875 | 0.0022258758544921875 | 0.009999999776482582 | -0.11474609375 | -0.08343505859375 | 0.0714111328125 | 0.0144500732421875 | -0.01009368896484375 | -0.0028076171875 | -0.100341796875 | 0.0386962890625 | 0.07476806640625 | 0.2037353515625 | 0.00543975830078125 | -0.00792694091796875 | 0.008575439453125 | 0.1524658203125 | 0.10986328125 | -0.04443359375 | 0.56005859375 | 0.039520263671875 |
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;