photos_with_apple_metadata (view)

4 rows where ZPLEASANTSYMMETRYSCORE = "0.0035381317138671875"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, ext, favorite, hdr, ZCURATIONSCORE, 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
253		410DD7AF-B97A-4508-9240-B2B0F55DC2FD	2019-08-24T12:32:07+00:00	[ "Public" ]	[]	heic	7b98967bbbe92bf81cdc9adcee4fb623eb6691579bfc7b84636e9f4f172e9458	2400763	48.86095	2.342538333333333	1	0	0	0	0	0	0	0	Paris	Île-de-France	France	410DD7AF-B97A-4508-9240-B2B0F55DC2FD	0.3662109375	0.75	0.0	0.05801526718694745	0.10000000149011612	-0.0092315673828125	0.02105712890625	0.00626373291015625	0.009999999776482582	-0.17333984375	-0.09271240234375	-0.000732421875	0.0139007568359375	-0.00609588623046875	-0.00481414794921875	-0.09033203125	-0.0902099609375	0.0135345458984375	0.09149169921875	0.00372314453125	-0.0022525787353515625	0.0035381317138671875	0.09466552734375	0.0888671875	0.042938232421875	0.44677734375	0.119384765625
307		CE82D764-5190-4817-8027-18562D6C4E44	2018-02-09T17:09:01+00:00	[ "Public" ]	[]	jpeg	9482db6d0ad87c6629f59ad3a1952b14be4efe363fc7f6b7d52d9d63c6c5529b	4737344			0	0	0	0	0	0	0	0				CE82D764-5190-4817-8027-18562D6C4E44	0.7080078125	0.5	0.0	0.043530951929456406	0.10000000149011612	-0.00106048583984375	0.00131988525390625	0.0025310516357421875	0.009999999776482582	0.1129150390625	-0.0872802734375	0.288330078125	0.0020198822021484375	-0.0216217041015625	-0.09893798828125	-0.33544921875	-0.074951171875	0.2939453125	-0.1087646484375	-0.0019989013671875	-0.0322265625	0.0035381317138671875	0.01049041748046875	-0.00115203857421875	-0.4990234375	-0.13134765625	-0.06817626953125
239		11D38304-FE06-43AD-B3F0-18FCB7697365	2018-02-09T17:08:15+00:00	[ "Public" ]	[]	jpeg	75acbbcbf1e97c8a33742aff62ac0255ed9eb67de35bcae0d51d9176a4f6ffe7	4604119			1	0	0	0	0	0	0	0				11D38304-FE06-43AD-B3F0-18FCB7697365	0.7958984375	0.75	0.0	0.06264114652881185	0.10000000149011612	-0.0010042190551757812	0.0269622802734375	0.001483917236328125	0.009999999776482582	-0.148681640625	-0.04345703125	0.1900634765625	0.005405426025390625	-0.00974273681640625	0.0116119384765625	0.0089111328125	0.07745361328125	0.054901123046875	0.1292724609375	0.01070404052734375	-0.00806427001953125	0.0035381317138671875	0.342041015625	0.37939453125	0.143798828125	0.662109375	0.0079345703125
240		6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C	2016-04-09T20:12:10+00:00	[ "Public" ]	[ "_UNKNOWN_", "_UNKNOWN_" ]	jpeg	75d306a807f0c9b8a89eb726ca2ea4e226812e347ad1b70a0d7806ca2c9111c8	2689457	37.78550333333333	-122.43043666666667	0	0	0	0	0	1	0	0	San Francisco	CA	United States	6E7773AA-EE8C-4DB8-A8B8-7440B0BB0F3C	0.486572265625	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.004314422607421875	-0.00701141357421875	0.002452850341796875	0.009999999776482582	-0.121826171875	-0.1026611328125	0.11175537109375	0.005619049072265625	-0.0521240234375	-0.133544921875	-0.4990234375	-0.270263671875	0.165283203125	-0.1573486328125	-0.0026302337646484375	-0.0262451171875	0.0035381317138671875	0.00557708740234375	-0.07470703125	-0.5068359375	-0.1641845703125	-0.1171875

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;