public

Custom SQL query returning 5 rows (hide)

select 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 from photos_with_apple_metadata where "ZHIGHLIGHTVISIBILITYSCORE" = :p0 and date("date") = :p1 limit 101

Query parameters

This data as json, CSV

rowid	uuid	date	albums	persons	ext	sha256	size	latitude	longitude	favorite	place_city	place_state_province	place_country	ZUUID	ZOVERALLAESTHETICSCORE	ZCURATIONSCORE	ZHIGHLIGHTVISIBILITYSCORE	ZBEHAVIORALSCORE	ZFAILURESCORE	ZHARMONIOUSCOLORSCORE	ZIMMERSIVENESSSCORE	ZINTERACTIONSCORE	ZINTERESTINGSUBJECTSCORE	ZINTRUSIVEOBJECTPRESENCESCORE	ZLIVELYCOLORSCORE	ZLOWLIGHT	ZNOISESCORE	ZPLEASANTCAMERATILTSCORE	ZPLEASANTCOMPOSITIONSCORE	ZPLEASANTLIGHTINGSCORE	ZPLEASANTPATTERNSCORE	ZPLEASANTPERSPECTIVESCORE	ZPLEASANTPOSTPROCESSINGSCORE	ZPLEASANTREFLECTIONSSCORE	ZPLEASANTSYMMETRYSCORE	ZSHARPLYFOCUSEDSUBJECTSCORE	ZTASTEFULLYBLURREDSCORE	ZWELLCHOSENSUBJECTSCORE	ZWELLFRAMEDSUBJECTSCORE	ZWELLTIMEDSHOTSCORE
491	2489642F-D29D-47EC-918A-63D1E2CEDF98	2018-02-20T23:04:00+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	fdc3052b1eb0fc7ebf3511145fa1744be8a22de793c74f9d89f98ffca730df5b	1690162	37.74257166666666	-122.44921166666667	1	San Francisco	CA	United States	2489642F-D29D-47EC-918A-63D1E2CEDF98	0.529296875	0.75	0.05801526718694745	0.10000000149011612	-0.001129150390625	0.0247955322265625	0.0087432861328125	0.009999999776482582	0.038818359375	-0.07354736328125	-0.028564453125	0.0169830322265625	-0.01085662841796875	-0.02056884765625	0.00927734375	0.0140380859375	0.0294189453125	0.26611328125	0.00890350341796875	-0.00035858154296875	0.00916290283203125	0.02691650390625	-0.004119873046875	0.0243988037109375	0.219970703125	0.1761474609375
175	978E05B3-A903-4F27-A219-92603A4880B5	2018-02-20T22:37:35+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	58aaabde35000d8e8e205450afb85f50f7aa66fcfe7ccd67fa873f6a1f32e60f	1770398	37.742308333333334	-122.44956166666667	1	San Francisco	CA	United States	978E05B3-A903-4F27-A219-92603A4880B5	0.470458984375	0.75	0.05801526718694745	0.10000000149011612	-0.0018892288208007812	0.009368896484375	0.0017414093017578125	0.009999999776482582	-0.03662109375	-0.103759765625	0.056243896484375	0.0068511962890625	-0.015899658203125	-0.037567138671875	-0.27294921875	-0.12939453125	0.02947998046875	0.02142333984375	0.001251220703125	-0.0097808837890625	0.002620697021484375	0.03656005859375	-0.001678466796875	-0.088623046875	0.303466796875	0.0738525390625
413	73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C	2018-02-20T22:16:37+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	d0d20aaa9ea3d8f1f7a5ceee5548a5545a35a00ba7503f80168dd5f65a903783	1481901	37.74236666666667	-122.44930333333333	1	San Francisco	CA	United States	73A384D3-8CE8-4B6A-9CCE-DFFA67A8138C	0.36376953125	0.75	0.05801526718694745	0.5043308734893799	-0.0011920928955078125	0.028045654296875	0.00394439697265625	0.009999999776482582	0.51904296875	-0.039642333984375	-0.0184326171875	0.0164031982421875	-0.0162811279296875	-0.0003814697265625	0.305419921875	0.0206298828125	0.0170440673828125	0.26611328125	0.00893402099609375	0.001964569091796875	0.00948333740234375	0.09234619140625	0.0183258056640625	0.170654296875	0.6982421875	0.43212890625
17	AE5BD628-AB44-4D2F-A03F-88422F509482	2018-02-20T22:10:36+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	097370f3405ad0e8a22a859ef107130273fd5fe2138128ffd6e7fc18c39fa000	1644874	37.742225	-122.44941666666666	1	San Francisco	CA	United States	AE5BD628-AB44-4D2F-A03F-88422F509482	0.461669921875	0.75	0.05801526718694745	0.504501223564148	-0.0012645721435546875	0.047088623046875	0.005279541015625	0.009999999776482582	0.197021484375	-0.07904052734375	0.021148681640625	0.014007568359375	-0.004451751708984375	0.0032806396484375	0.183837890625	0.1884765625	0.0261077880859375	0.34716796875	0.019775390625	0.0006866455078125	0.006168365478515625	0.1915283203125	0.32861328125	0.09649658203125	0.496826171875	0.1983642578125
16	C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A	2018-02-20T22:10:33+00:00	[ "Ray Bandar for Niche Museums", "Ray Bandar's Bone Palace", "Public" ]	[]	heic	087562510b302c2c3e8095b7e5ed455ff4b178e909ec46bde09d50c8500ec26d	1743702	37.74223666666666	-122.44941666666666	1	San Francisco	CA	United States	C1858E6C-13BB-4C1B-A8AB-1A5B2129C19A	0.353759765625	0.75	0.05801526718694745	0.5041119456291199	-0.0015249252319335938	0.0284576416015625	0.005062103271484375	0.009999999776482582	0.384765625	-0.07489013671875	-0.036285400390625	0.025909423828125	-0.00908660888671875	-0.00229644775390625	0.187744140625	0.02294921875	0.0174407958984375	0.23681640625	0.01068115234375	0.001995086669921875	0.00760650634765625	0.08404541015625	0.0736083984375	0.04827880859375	0.458984375	0.26806640625