public

Custom SQL query returning 3 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 "ZBEHAVIORALSCORE" = :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_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
180	0F308AB5-4F16-4C67-A84E-310F85B63E4E	2019-08-02T09:31:50+00:00	[ "To Instagram", "Public" ]	[]	heic	59acef10149934e3af1e1078d07b77cb367d6227ca00cf93d93d7576b5bf2525	1082591	-12.526836666666666	49.17201166666667	1	Antsiranana	Madagascar	0F308AB5-4F16-4C67-A84E-310F85B63E4E	0.5078125	0.75	0.05801526718694745	0.10000000149011612	-0.004100799560546875	0.06683349609375	0.01395416259765625	0.009999999776482582	-0.1656494140625	-0.035400390625	0.06732177734375	0.048309326171875	-0.0202178955078125	-0.016998291015625	0.005615234375	0.0098876953125	0.06610107421875	0.1409912109375	0.04559326171875	0.00055694580078125	0.00555419921875	0.030914306640625	0.030181884765625	0.06134033203125	0.038818359375	0.02703857421875
300	563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473	2019-08-02T07:32:43+00:00	[ "To Instagram", "Public" ]	[]	jpeg	8fa3f67420480063a09ea4134c1dae4e8d67262f38433e3a41a2f6eb6aa47bf8	5402536			1			563D4862-8FC2-4BD9-BAD0-E9B2DC5DB473	0.68701171875	0.75	0.061090618599462146	0.10000000149011612	-0.0045928955078125	0.059783935546875	0.024139404296875	0.009999999776482582	-0.1326904296875	-0.041778564453125	0.0091552734375	0.01763916015625	-0.00948333740234375	-0.0116119384765625	0.140625	0.001708984375	0.047698974609375	0.205810546875	0.0234832763671875	0.00275421142578125	0.007122039794921875	0.03289794921875	0.05401611328125	0.03717041015625	0.03765869140625	0.039886474609375
243	18939B2A-0A75-461C-B1D0-7ABD87282C2D	2019-08-02T07:06:42+00:00	[ "To Instagram", "Public" ]	[]	jpeg	77bff818519fbcb9928b5259e5865f7f16a90fca872e7372a6bb06be7ac89fd9	4601240			1			18939B2A-0A75-461C-B1D0-7ABD87282C2D	0.73486328125	0.75	0.06263108016880414	0.10000000149011612	-0.00131988525390625	0.0268707275390625	0.0013151168823242188	0.009999999776482582	-0.0050048828125	-0.04803466796875	0.258544921875	0.005138397216796875	-0.014617919921875	0.016845703125	-0.0245361328125	0.05230712890625	0.06939697265625	0.068603515625	0.00927734375	-0.009765625	0.002590179443359375	0.316650390625	0.431640625	0.0804443359375	0.6259765625	0.010986328125