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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 133 | ![]() |
1C4D17B1-29D7-42D3-BB59-DBBFA42AA9D0 | 2018-02-20T22:05:11+00:00 | [
"Ray Bandar for Niche Museums",
"Ray Bandar's Bone Palace",
"Public"
] |
[] |
heic | 3cb0c61cacd8c727a5faa98a5ad09f5356d85a069a57e001e0cb016cd0355f81 | 1652414 | 37.74209666666667 | -122.44973 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | San Francisco | CA | United States | 1C4D17B1-29D7-42D3-BB59-DBBFA42AA9D0 | 0.375 | 0.5 | 0.0 | 0.038931297721298594 | 0.10000000149011612 | -0.0018463134765625 | 0.0224456787109375 | 0.0029926300048828125 | 0.009999999776482582 | -0.027099609375 | -0.053009033203125 | 0.00555419921875 | 0.0261993408203125 | -0.00905609130859375 | 0.003292083740234375 | 0.1695556640625 | 0.0897216796875 | 0.02508544921875 | 0.171142578125 | 0.0092010498046875 | -0.00160980224609375 | 0.00690460205078125 | 0.303955078125 | 0.486572265625 | 0.1103515625 | 0.6923828125 | 0.06658935546875 |
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;