apple_photos_scores

213 rows where ZCURATIONSCORE = "0.5"

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
435	435	F5B3B67A-BE7F-4138-847F-A985B790A1D8	0.37353515625	0.5	0.038931297721298594	0.10000000149011612	-0.002132415771484375	0.0230255126953125	0.006565093994140625	0.009999999776482582	-0.95654296875	-0.01490020751953125	0.1636962890625	0.0006070137023925781	-0.003376007080078125	-0.0041961669921875	0.087890625	0.0185546875	0.0226287841796875	0.050140380859375	-0.03076171875	-0.003383636474609375	0.0035648345947265625	0.0706787109375	0.022705078125	0.1737060546875	0.287353515625	0.0017080307006835938
436	436	F5F65BC1-8BD3-40A2-B283-EBA2E7657A20	0.361572265625	0.5	0.038931297721298594	0.10087591409683228	-0.0004372596740722656	0.1085205078125	0.00908660888671875	0.009999999776482582	-0.0367431640625	-0.020172119140625	0.271484375	0.01512908935546875	-0.008544921875	0.01593017578125	0.140869140625	0.227294921875	0.212890625	0.343505859375	0.08966064453125	-0.0034332275390625	0.0169830322265625	0.10992431640625	0.03192138671875	0.1953125	0.363037109375	0.009735107421875
438	438	F6D98A32-C5E8-4C04-A876-8D316F22B319	0.33642578125	0.5	0.038931297721298594	0.5044525265693665	-0.0018968582153320312	0.030242919921875	0.0022335052490234375	0.009999999776482582	0.386474609375	-0.06683349609375	0.02520751953125	0.018157958984375	-0.007694244384765625	0.00339508056640625	0.1480712890625	0.0789794921875	0.0169219970703125	0.1650390625	0.016448974609375	-3.4332275390625e-05	0.0036067962646484375	0.241455078125	0.46826171875	0.177978515625	0.68798828125	0.2203369140625
439	439	F6F45595-4033-4C79-A9F9-86DCA9088C37	0.6103515625	0.5	0.8053669137809113	0.10000000149011612	-0.00572967529296875	-0.000789642333984375	0.0010814666748046875	0.019999999552965164	0.0447998046875	-0.095703125	0.048583984375	0.01238250732421875	-0.08880615234375	-0.05389404296875	-0.29736328125	-0.29248046875	0.0289306640625	-0.12152099609375	-0.001251220703125	-0.0276031494140625	0.0015192031860351562	0.022796630859375	-0.032806396484375	-0.325439453125	0.28076171875	-0.0489501953125
440	440	F78D8339-34E9-4A9A-9BF8-6A73F52566EE	0.53271484375	0.5	0.038931297721298594	0.10000000149011612	-0.00037550926208496094	0.03216552734375	0.01073455810546875	0.009999999776482582	-0.34033203125	-0.0699462890625	0.1435546875	0.00524139404296875	-0.00469970703125	-0.0418701171875	-0.28076171875	0.1400146484375	0.11181640625	0.1612548828125	0.0097198486328125	-0.0096893310546875	0.0101318359375	0.026763916015625	0.0047454833984375	-0.07196044921875	-0.0020751953125	0.010009765625
441	441	F8A949C8-9034-4437-A685-765B42D87052	0.76318359375	0.5	0.043549711012658275	0.10000000149011612	-0.002758026123046875	0.007160186767578125	0.0054473876953125	0.009999999776482582	-0.9423828125	-0.0203704833984375	0.2205810546875	0.0003936290740966797	-0.006511688232421875	-0.0133209228515625	-0.08416748046875	-0.04241943359375	0.036834716796875	0.005096435546875	-0.0263824462890625	-0.00873565673828125	0.00243377685546875	0.0274810791015625	-0.0011138916015625	0.096923828125	0.10662841796875	-0.0027599334716796875
443	443	F94D1238-6FB5-4289-B15F-9AF9F0BFDD6E	0.52978515625	0.5	0.038931297721298594	0.10000000149011612	-0.0015249252319335938	-0.0049591064453125	0.004039764404296875	0.009999999776482582	-0.37744140625	-0.07696533203125	0.2646484375	0.0016355514526367188	-0.01751708984375	-0.0535888671875	-0.484130859375	-0.067626953125	0.138916015625	-0.064453125	-0.0138397216796875	-0.0174102783203125	0.001926422119140625	0.00930023193359375	-0.00273895263671875	-0.4765625	-0.3681640625	-0.083740234375
447	447	FC01AB36-9465-4F95-8DC9-618FBC1405A6	0.76708984375	0.5	0.04353076629056275	0.10000000149011612	-0.0016355514526367188	0.00383758544921875	0.00473785400390625	0.019999999552965164	-0.46875	-0.10015869140625	0.09564208984375	0.0033111572265625	-0.011871337890625	-0.065673828125	-0.497802734375	-0.1065673828125	0.06732177734375	-0.025115966796875	-0.002429962158203125	-0.0179290771484375	0.003040313720703125	0.0097808837890625	-0.01000213623046875	-0.1546630859375	-0.1719970703125	-0.0113983154296875
448	448	FC705948-B3D8-4B7A-90A6-E617B3ED80F6	0.58740234375	0.5	0.04203098011380844	0.10000000149011612	-0.00243377685546875	0.008056640625	0.0013408660888671875	0.009999999776482582	-0.2054443359375	-0.036285400390625	0.333740234375	0.0038547515869140625	-0.02337646484375	-0.02716064453125	-0.0999755859375	-0.0706787109375	0.161376953125	-0.068359375	0.001575469970703125	-0.10321044921875	0.003795623779296875	0.07476806640625	0.0780029296875	-0.124755859375	0.33203125	-0.0229339599609375
451	451	FCC0BF2E-D8AB-4A77-AAF5-427E15978F82	0.410400390625	0.5	0.038931297721298594	0.504355251789093	-0.0009813308715820312	0.0352783203125	0.0033245086669921875	0.009999999776482582	0.5791015625	-0.05072021484375	0.011474609375	0.01395416259765625	-0.01090240478515625	0.0034027099609375	0.27734375	0.0919189453125	0.018768310546875	0.28759765625	0.01300048828125	0.001827239990234375	0.006984710693359375	0.1353759765625	0.0806884765625	0.176513671875	0.6982421875	0.464599609375
453	453	FF1D2E63-A1A2-4C67-A49B-090C603F8346	0.7490234375	0.5	0.04353466698231588	0.10000000149011612	-0.0016937255859375	0.0145416259765625	0.006744384765625	0.009999999776482582	-0.91455078125	-0.021575927734375	0.235107421875	0.0006165504455566406	-0.004886627197265625	-0.01410675048828125	-0.0574951171875	-0.023193359375	0.051849365234375	0.025177001953125	-0.02044677734375	-0.007793426513671875	0.00443267822265625	0.0311431884765625	-0.0015411376953125	0.08612060546875	0.1700439453125	-0.0013217926025390625
454	454	FF230430-EDD4-4E3F-83F9-C105A7EE7598	0.76220703125	0.5	0.04353076629056275	0.10000000149011612	-0.0017681121826171875	-0.0049896240234375	0.002349853515625	0.019999999552965164	0.139404296875	-0.047515869140625	0.317626953125	0.00147247314453125	-0.0364990234375	-0.051422119140625	-0.1719970703125	-0.1263427734375	0.1759033203125	-0.0941162109375	-0.0011386871337890625	-0.03131103515625	0.003223419189453125	0.0094146728515625	-0.01128387451171875	-0.53125	0.0823974609375	-0.117431640625
455	455	FFD294F1-59BE-4B75-9180-B6318671CDEC	0.463134765625	0.5	0.038931297721298594	0.10000000149011612	-0.0136871337890625	0.0124969482421875	0.005641937255859375	0.009999999776482582	-0.440673828125	-0.2271728515625	-0.118408203125	0.0216522216796875	-0.01262664794921875	-0.07830810546875	-0.51513671875	-0.475830078125	0.0117340087890625	0.0494384765625	0.001789093017578125	-0.0160064697265625	0.0021572113037109375	0.006072998046875	-0.148681640625	-0.00510406494140625	-0.097412109375	0.07403564453125

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]);