photos_with_apple_metadata (view)

5 rows where ZCURATIONSCORE = "0.25" and "date" is on date 2018-04-22 sorted by ZPLEASANTPATTERNSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: persons, longitude, ZINTRUSIVEOBJECTPRESENCESCORE, 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
464		61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC	2018-04-22T00:00:15+00:00	[ "Museums", "Public" ]	[ "_UNKNOWN_", "_UNKNOWN_" ]	heic	e9ca2c634c5bd6c32b8b1eff0a8e907e16256a4245af095292831a5ba124ffa0	1480015	37.57921666666667	-122.34423833333334	0	0	0	0	0	0	0	0	Burlingame	CA	United States	61A142C7-A526-4AE1-A1B5-C6FB3CE73EBC	0.420166015625	0.25	0.0	0.019847328255649742	0.10000000149011612	-0.0068511962890625	0.015228271484375	0.0059356689453125	0.009999999776482582	-0.2369384765625	-0.09124755859375	-0.0821533203125	0.04107666015625	-0.034027099609375	-0.052093505859375	-0.26123046875	-0.32080078125	0.0325927734375	0.0858154296875	0.006381988525390625	-0.004791259765625	0.004364013671875	0.01036834716796875	-0.05767822265625	0.0079803466796875	0.0189208984375	0.0738525390625
392		2072695E-48EC-4C6E-9AFE-61F6590F67D5	2018-04-22T00:10:18+00:00	[ "Museums", "Public" ]	[]	heic	c51fccdae579f930cf5e5523b5dd56c5e35900718a323b2451014d6c6b01ba42	1310899	37.57915	-122.3441	0	0	0	0	0	0	0	0	Burlingame	CA	United States	2072695E-48EC-4C6E-9AFE-61F6590F67D5	0.340576171875	0.25	0.0	0.019847328255649742	0.10000000149011612	-0.00443267822265625	-0.00213623046875	0.0015916824340820312	0.009999999776482582	-0.85986328125	-0.03253173828125	0.2386474609375	0.0009365081787109375	-0.022247314453125	-0.043243408203125	-0.1949462890625	-0.1187744140625	0.07342529296875	-0.06146240234375	-0.0161895751953125	-0.0694580078125	0.001956939697265625	0.02508544921875	0.0008697509765625	0.0228271484375	0.1063232421875	-0.014068603515625
289		277756C5-6924-4E30-877D-CD2CE30630FD	2018-04-22T00:17:52+00:00	[ "Museums", "Public" ]	[]	heic	8badd750c2e09ba7e96fe2d48833f66990b14e348cda9269ebd0444d6694b2af	1177569	37.579096666666665	-122.34413833333333	0	0	0	0	0	0	0	0	Burlingame	CA	United States	277756C5-6924-4E30-877D-CD2CE30630FD	0.266357421875	0.25	0.0	0.019847328255649742	0.10000000149011612	-0.003795623779296875	-0.0030517578125	0.0010366439819335938	0.009999999776482582	-0.449951171875	-0.03875732421875	0.1923828125	0.00323486328125	-0.07781982421875	-0.06396484375	-0.1732177734375	-0.1572265625	0.07476806640625	-0.1436767578125	-0.00726318359375	-0.03466796875	0.0022602081298828125	0.035736083984375	-0.0068206787109375	-0.1612548828125	0.345703125	-0.03826904296875
410		F55C40DC-FF30-40F0-92BD-FBD1BD14B68B	2018-04-22T00:18:11+00:00	[ "Museums", "Public" ]	[ "_UNKNOWN_", "_UNKNOWN_" ]	heic	ccd368e8a772e5ac1a2ebf1ddebf143dbd84c871ebaaedc39c24b4266ee08e7a	1495272	37.57904666666667	-122.34413833333333	0	0	0	0	0	0	0	0	Burlingame	CA	United States	F55C40DC-FF30-40F0-92BD-FBD1BD14B68B	0.1875	0.25	0.0	0.019847328255649742	0.10000000149011612	-0.012054443359375	-0.01104736328125	0.0017414093017578125	0.009999999776482582	-0.1734619140625	-0.09124755859375	0.07891845703125	0.010986328125	-0.1014404296875	-0.08251953125	-0.462646484375	-0.359130859375	0.07611083984375	-0.150390625	-0.00496673583984375	-0.0238494873046875	0.0022335052490234375	0.007755279541015625	-0.208251953125	-0.61328125	0.0023193359375	-0.1900634765625
484		75D227E6-3F2B-41A8-9977-E9B55255C861	2018-04-22T00:03:04+00:00	[ "Museums", "Public" ]	[]	heic	f8daca217ac8cad995c653260c325158ac80e59e5379ab8be5c339a304cd3378	1924547	37.57926166666667	-122.34416166666666	0	0	0	0	0	0	0	0	Burlingame	CA	United States	75D227E6-3F2B-41A8-9977-E9B55255C861	0.17236328125	0.25	0.0	0.019847328255649742	0.10000000149011612	-0.00536346435546875	0.003108978271484375	0.004718780517578125	0.009999999776482582	-0.2900390625	-0.139892578125	-0.10870361328125	0.0699462890625	-0.03338623046875	-0.060302734375	-0.52392578125	-0.42333984375	0.15771484375	0.0250244140625	0.0015716552734375	-0.01311492919921875	0.0117340087890625	0.009521484375	-0.08758544921875	-0.118408203125	-0.0535888671875	0.0139007568359375

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;