photos_with_apple_metadata (view)

1 row where "date" is on date 2018-04-22 and latitude = "37.57922" sorted by ZHARMONIOUSCOLORSCORE descending

✎ 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
274		E50B8F10-65AB-4938-AC6C-C8C35EB1C08C	2018-04-22T00:10:07+00:00	[ "Museums", "Public" ]	[]	heic	8433d50000ebdf053b128c12d529091ee99a847d47e0d6317c002969b5406fed	2209010	37.57922	-122.34410833333334	0	0	0	0	0	0	0	0	Burlingame	CA	United States	E50B8F10-65AB-4938-AC6C-C8C35EB1C08C	0.382080078125	0.5	0.0	0.038931297721298594	0.10000000149011612	-0.004364013671875	-0.00274658203125	0.0011339187622070312	0.009999999776482582	-0.724609375	-0.03436279296875	0.255615234375	0.0015430450439453125	-0.04595947265625	-0.07611083984375	-0.2100830078125	-0.1217041015625	0.07965087890625	-0.164306640625	-0.0077056884765625	-0.035980224609375	0.0015430450439453125	0.03314208984375	0.0018310546875	-0.0218505859375	0.1365966796875	-0.025054931640625

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;