photos_with_apple_metadata (view)

4 rows where "date" is on date 2018-02-11 sorted by ZIMMERSIVENESSSCORE descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZCURATIONSCORE, 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
103		E2880EC4-C3B5-46E6-B555-C78CF75895C2	2018-02-11T19:35:20+00:00	[ "Public" ]	[]	jpeg	30f37193cf87e00bc0a9b36bcf5fd6972f627f24fe37cbd828e52101303d0e14	3812669			0	0	0	0	0	0	0	0				E2880EC4-C3B5-46E6-B555-C78CF75895C2	0.78955078125	0.75	0.0	0.06263722718216991	0.10000000149011612	-0.0007791519165039062	0.03192138671875	0.007038116455078125	0.009999999776482582	0.1177978515625	-0.06866455078125	0.433837890625	0.0021820068359375	-0.006717681884765625	-0.027587890625	-0.263427734375	0.05645751953125	0.150634765625	-0.010467529296875	0.00214385986328125	-0.006992340087890625	0.00238800048828125	0.021240234375	0.0230712890625	-0.302978515625	-0.136962890625	-0.01300048828125
168		5DEBD78D-9E16-4991-A043-01941457D1B6	2018-02-11T19:35:21+00:00	[ "Public" ]	[]	jpeg	552cfb244a05a4402fa2076d3245ab3401c5fe745a60f6feaa61869b65133693	3866838			0	0	0	0	0	0	0	0				5DEBD78D-9E16-4991-A043-01941457D1B6	0.66357421875	0.5	0.0	0.04202652250537436	0.10000000149011612	-0.0006313323974609375	0.0293121337890625	0.00586700439453125	0.009999999776482582	0.1646728515625	-0.049224853515625	0.47216796875	0.0010776519775390625	-0.0070648193359375	-0.035919189453125	-0.1690673828125	0.03253173828125	0.09600830078125	-0.0128173828125	0.0029449462890625	-0.00699615478515625	0.002368927001953125	0.015899658203125	0.0003204345703125	-0.256103515625	0.0166015625	0.0220947265625
361		99FD949E-C3D2-41B0-97DA-7560E90251ED	2018-02-11T19:26:28+00:00	[ "Public" ]	[]	jpeg	afeb4e2620b3b678169b397e0b9d5fb103639e0ee409bbcefff12841a716a85c	6519197			0	0	0	0	0	0	0	0				99FD949E-C3D2-41B0-97DA-7560E90251ED	0.634765625	0.5	0.0	0.042004234918201246	0.10000000149011612	-0.00591278076171875	0.00647735595703125	0.004215240478515625	0.009999999776482582	-0.9482421875	-0.04351806640625	0.02557373046875	0.001972198486328125	-0.00930023193359375	-0.01512908935546875	-0.171875	-0.193359375	0.01374053955078125	0.0161590576171875	-0.023590087890625	-0.00858306884765625	0.0025119781494140625	0.0239105224609375	-0.04583740234375	0.084716796875	0.199951171875	-0.000225067138671875
257		B062A78F-5C95-4072-ADF2-007D436B0B7E	2018-02-11T19:26:29+00:00	[ "Public" ]	[]	jpeg	7d6b41e7ed116733ad90b7f35313cc9c33f78034df4d5194894a9a1cae2ca92d	6355439			0	0	0	0	0	0	0	0				B062A78F-5C95-4072-ADF2-007D436B0B7E	0.64306640625	0.5	0.0	0.0420040488243103	0.10000000149011612	-0.0019121170043945312	0.00333404541015625	0.0027256011962890625	0.009999999776482582	-0.85546875	-0.0301513671875	0.265380859375	0.0020904541015625	-0.01358795166015625	-0.0299530029296875	-0.193603515625	-0.072265625	0.0823974609375	-0.017425537109375	-0.021636962890625	-0.033935546875	0.0034160614013671875	0.0292510986328125	0.0034637451171875	-0.0279541015625	0.10302734375	-0.008270263671875

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;