photos_with_apple_metadata (view)

2 rows where ZHIGHLIGHTVISIBILITYSCORE = "0.06110566308480183" and "date" is on date 2019-08-21 sorted by ZIMMERSIVENESSSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
28		14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D	2019-08-21T15:33:02+00:00	[ "Public" ]	[]	jpeg	10fbcfa8d9bde9eea951ffd25147dfcca838591911ffa1c2b4b5ada2cc73bf7c	6692650			1	0	0	0	0	0	0	0				14CFCD9C-EBFE-4C4A-ABF8-299A57F5206D	0.6298828125	0.75	0.0	0.06110566308480183	0.7047688364982605	-0.00042057037353515625	0.060150146484375	0.00217437744140625	0.009999999776482582	0.78271484375	-0.0309600830078125	0.0841064453125	0.010009765625	-0.0027256011962890625	0.00811004638671875	0.48193359375	0.420166015625	0.017242431640625	0.26513671875	0.02313232421875	0.00504302978515625	0.00530242919921875	0.67822265625	0.82177734375	0.273193359375	0.88427734375	0.67822265625
208		54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE	2019-08-21T16:06:05+00:00	[ "Public" ]	[]	jpeg	68070b02b60b38af0180db8311ecd10bf80a84ce18379978bf22029e6931f10d	6119986			1	0	0	0	0	0	0	0				54F1F5C1-A8AF-4731-81C6-0F0ED204D8EE	0.6669921875	0.75	0.0	0.06110566308480183	0.70737224817276	-0.0009851455688476562	0.04791259765625	0.003147125244140625	0.009999999776482582	0.515625	-0.045867919921875	0.12353515625	0.01146697998046875	-0.012237548828125	0.013671875	0.1416015625	0.17041015625	0.0258636474609375	0.18505859375	0.03948974609375	0.000732421875	0.0031719207763671875	0.2000732421875	0.236328125	0.301513671875	0.669921875	0.287841796875

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;