photos_with_apple_metadata (view)

5 rows where "date" is on date 2017-11-05 sorted by ZIMMERSIVENESSSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: longitude, ZCURATIONSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZINTERACTIONSCORE, 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
132		F142B8D1-24B8-4108-AFB7-0C454C72E625	2017-11-05T23:06:49+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	3c189d4ca97d42b444c05d69f5f798f0ecb1c4066123d5f75d1d0d60e332a475	4231615	37.76921166666666	-122.46446166666666	0	0	0	0	0	0	0	0	San Francisco	CA	United States	F142B8D1-24B8-4108-AFB7-0C454C72E625	0.468017578125	0.6	0.0	0.04656488550755814	0.10000000149011612	-0.0019121170043945312	0.0162353515625	0.0016231536865234375	0.019999999552965164	-0.1405029296875	-0.0204925537109375	0.308349609375	0.0012693405151367188	-0.0310821533203125	-0.024505615234375	0.00177001953125	-0.03289794921875	0.05572509765625	-0.046142578125	0.0059814453125	-0.0129547119140625	0.0024623870849609375	0.11993408203125	0.04132080078125	0.31396484375	0.54833984375	-0.00934600830078125
218		3D7AE6D3-0FD4-4130-B713-44EB2C885A30	2017-11-05T23:05:51+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	6cd24772dbd1f463325dba1e5ab734ceb559741953324b590eb89d3497cda1f4	2789234	37.768953333333336	-122.464425	0	0	0	0	0	0	0	0	San Francisco	CA	United States	3D7AE6D3-0FD4-4130-B713-44EB2C885A30	0.373779296875	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.0011920928955078125	0.0150299072265625	0.0024242401123046875	0.009999999776482582	0.0262451171875	-0.05340576171875	0.35107421875	0.0018529891967773438	-0.01525115966796875	-0.019927978515625	-0.121337890625	-0.013916015625	0.078369140625	-0.033782958984375	-0.0024566650390625	-0.01345062255859375	0.0018177032470703125	0.0472412109375	0.041656494140625	-0.119140625	0.26513671875	-0.02508544921875
38		1EAE7EE2-CBE6-491B-A8EF-337859628659	2017-11-05T23:05:44+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	1423536b7567da6562cd1e842bd93be31d8ebe84d797afe4a81644bac2a2c9e3	2979362	37.768975	-122.46446166666666	0	0	0	0	0	0	0	0	San Francisco	CA	United States	1EAE7EE2-CBE6-491B-A8EF-337859628659	0.347900390625	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.0028896331787109375	0.01885986328125	0.004116058349609375	0.03999999910593033	0.1094970703125	-0.053192138671875	0.1767578125	0.00254058837890625	-0.019561767578125	-0.03076171875	-0.08697509765625	-0.03570556640625	0.029815673828125	0.0164794921875	0.00586700439453125	-0.00499725341796875	0.001926422119140625	0.037261962890625	-0.0113525390625	0.08465576171875	0.339599609375	0.105224609375
350		A92AF32A-7C12-48CC-B1C3-5C83D05B76AA	2017-11-05T23:06:58+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	a981be272530aba690ff4d6e292c3dbfeb1fee4c9fcca39346043012cf486e49	3639642	37.76914166666667	-122.46450833333333	0	0	0	0	0	0	0	0	San Francisco	CA	United States	A92AF32A-7C12-48CC-B1C3-5C83D05B76AA	0.4189453125	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.0011157989501953125	0.06903076171875	0.00734710693359375	0.019999999552965164	-0.3623046875	-0.03521728515625	0.1944580078125	0.0282135009765625	-0.01137542724609375	-0.0245361328125	-0.04638671875	0.085205078125	0.2430419921875	0.192626953125	0.03240966796875	-0.01221466064453125	0.01450347900390625	0.060516357421875	0.03424072265625	0.024658203125	0.1572265625	0.00374603271484375
458		AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A	2017-11-05T23:07:13+00:00	[ "Stolen monasteries", "Public" ]	[]	heic	e8984bb084f3dd58c57a1e2f8a1c8cdbb86c903cfc239f61916b3eb86f332655	3513964	37.769133333333336	-122.46440833333334	0	0	0	0	0	0	0	0	San Francisco	CA	United States	AC6610AB-FA5E-4B76-93B8-F91AC0ED2D8A	0.463623046875	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.0016040802001953125	0.06597900390625	0.047515869140625	0.009999999776482582	-0.026611328125	-0.0313720703125	0.0909423828125	0.00443267822265625	-0.00595855712890625	-0.0275115966796875	0.1474609375	-0.005859375	0.033905029296875	0.120361328125	0.016143798828125	0.02667236328125	0.007122039794921875	0.00669097900390625	-0.0003986358642578125	0.007114410400390625	-0.04931640625	0.012451171875

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;