apple_photos_scores

14 rows where ZCURATIONSCORE = "0.6" sorted by rowid descending

descending

Link	rowid ▲	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
271	271	9C790AF0-D6F6-4CB6-8DB1-D74DF52754E5	0.3544921875	0.6	0.04656488550755814	0.10000000149011612	-0.0083770751953125	0.00119781494140625	0.004627227783203125	0.009999999776482582	-0.49560546875	-0.0994873046875	-0.05328369140625	0.04742431640625	-0.041534423828125	-0.05999755859375	-0.501953125	-0.37744140625	0.18798828125	-0.01983642578125	0.00074005126953125	-0.01611328125	0.00815582275390625	0.01085662841796875	-0.07183837890625	-0.10101318359375	-0.13720703125	-0.015838623046875
254	254	9420279A-6AF4-4998-B882-499A10CC0937	0.438720703125	0.6	0.04656488550755814	0.10000000149011612	-0.0129241943359375	0.01224517822265625	0.00424957275390625	0.009999999776482582	-0.68896484375	-0.100341796875	-0.024322509765625	0.036895751953125	-0.0202178955078125	-0.0260009765625	-0.416259765625	-0.241455078125	0.050811767578125	0.02716064453125	0.00119781494140625	-0.008331298828125	0.0027675628662109375	0.0384521484375	0.1044921875	-0.0093231201171875	-0.03961181640625	-0.00185394287109375
228	228	884202B6-0565-4E6B-9FDA-2AFA6467FC3A	0.51171875	0.6	0.8099236641335124	0.10000000149011612	-0.0007181167602539062	0.01419830322265625	0.0016040802001953125	0.009999999776482582	-0.1270751953125	-0.04217529296875	0.27978515625	0.0026721954345703125	-0.014617919921875	-0.02716064453125	-0.09185791015625	-0.02459716796875	0.1585693359375	-0.004638671875	0.00492095947265625	-0.024139404296875	0.006290435791015625	0.08929443359375	0.03363037109375	-0.05224609375	0.489013671875	-0.01068878173828125
223	223	84CA3880-9BC5-4FF0-9416-8AF1800985EC	0.321044921875	0.6	0.04656488550755814	0.10000000149011612	-0.00243377685546875	0.0157470703125	0.005535125732421875	0.07999999821186066	0.1326904296875	-0.06890869140625	0.02349853515625	0.042327880859375	-0.037689208984375	-0.036102294921875	-0.1865234375	-0.161376953125	0.09637451171875	0.042724609375	0.013031005859375	-0.007396697998046875	0.00679779052734375	0.019561767578125	-0.001312255859375	-0.07696533203125	0.11273193359375	0.023681640625
94	94	37E1743F-21C1-4EBF-A118-9AE8EDDF91D1	0.4443359375	0.6	0.04656488550755814	0.10000000149011612	-0.001155853271484375	0.018402099609375	0.0016546249389648438	0.009999999776482582	-0.06689453125	-0.03125	0.2587890625	0.00257110595703125	-0.01678466796875	-0.00225830078125	-0.004638671875	0.0	0.0869140625	0.03759765625	0.006435394287109375	-0.011322021484375	0.004085540771484375	0.1719970703125	0.11846923828125	0.126953125	0.595703125	-0.00284576416015625
37	37	14B6764F-C911-4A53-8A56-28D1DE9F634A	0.453125	0.6	0.04656488550755814	0.10000000149011612	-0.027069091796875	0.00571441650390625	0.01029205322265625	0.009999999776482582	-0.689453125	-0.0970458984375	-0.28955078125	0.05987548828125	-0.04949951171875	-0.03485107421875	-0.38720703125	-0.634765625	0.012237548828125	0.04443359375	0.0016651153564453125	-0.00444793701171875	0.0038547515869140625	0.0036640167236328125	-0.157470703125	0.002780914306640625	-0.08416748046875	0.01250457763671875
32	32	11C638ED-4C47-4D12-BF4C-4DF75D1508D2	0.2841796875	0.6	0.8099236641335124	0.10000000149011612	-0.0007791519165039062	0.06878662109375	0.06231689453125	0.009999999776482582	-0.0009765625	-0.0229339599609375	0.310302734375	0.0006265640258789062	-0.0035114288330078125	-0.03521728515625	0.0626220703125	0.063232421875	0.06292724609375	0.09722900390625	0.0171356201171875	-0.000911712646484375	0.00595855712890625	0.0089874267578125	-8.58306884765625e-05	0.01532745361328125	-0.065185546875	0.000820159912109375
5	5	03BA87C4-E783-44BC-9626-45983800AE72	0.50341796875	0.6	0.04656488550755814	0.10000000149011612	-0.005889892578125	-0.0104827880859375	0.002811431884765625	0.019999999552965164	-0.4658203125	-0.043121337890625	0.2430419921875	0.0018100738525390625	-0.06573486328125	-0.1309814453125	-0.382568359375	-0.1617431640625	0.2509765625	-0.2269287109375	-0.002628326416015625	-0.031951904296875	0.0022869110107421875	0.006122589111328125	-0.02349853515625	-0.289306640625	-0.37255859375	-0.0804443359375

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE apple_photos_scores(
  ZUUID TEXT,
  ZOVERALLAESTHETICSCORE REAL,
  ZCURATIONSCORE REAL,
  ZPROMOTIONSCORE REAL,
  ZHIGHLIGHTVISIBILITYSCORE REAL,
  ZBEHAVIORALSCORE REAL,
  ZFAILURESCORE REAL,
  ZHARMONIOUSCOLORSCORE REAL,
  ZIMMERSIVENESSSCORE REAL,
  ZINTERACTIONSCORE REAL,
  ZINTERESTINGSUBJECTSCORE REAL,
  ZINTRUSIVEOBJECTPRESENCESCORE REAL,
  ZLIVELYCOLORSCORE REAL,
  ZLOWLIGHT REAL,
  ZNOISESCORE REAL,
  ZPLEASANTCAMERATILTSCORE REAL,
  ZPLEASANTCOMPOSITIONSCORE REAL,
  ZPLEASANTLIGHTINGSCORE REAL,
  ZPLEASANTPATTERNSCORE REAL,
  ZPLEASANTPERSPECTIVESCORE REAL,
  ZPLEASANTPOSTPROCESSINGSCORE REAL,
  ZPLEASANTREFLECTIONSSCORE REAL,
  ZPLEASANTSYMMETRYSCORE REAL,
  ZSHARPLYFOCUSEDSUBJECTSCORE REAL,
  ZTASTEFULLYBLURREDSCORE REAL,
  ZWELLCHOSENSUBJECTSCORE REAL,
  ZWELLFRAMEDSUBJECTSCORE REAL,
  ZWELLTIMEDSHOTSCORE REAL
);
CREATE INDEX [idx_apple_photos_scores_ZUUID]
                ON [apple_photos_scores] ([ZUUID]);