This data as json, CSV (advanced)
ZINTERACTIONSCORE ✖
| Link | rowid ▼ | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32 | 32 | 11C638ED-4C47-4D12-BF4C-4DF75D1508D2 | 0.2841796875 | 0.6 | 0.0 | 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 |
| 228 | 228 | 884202B6-0565-4E6B-9FDA-2AFA6467FC3A | 0.51171875 | 0.6 | 0.0 | 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 |
| 379 | 379 | CECB8318-5241-46BB-AABF-8CF8A3B72890 | 0.50390625 | 0.6 | 0.0 | 0.8099236641335124 | 0.10000000149011612 | -0.0006070137023925781 | 0.0191497802734375 | 0.0021572113037109375 | 0.009999999776482582 | -0.14599609375 | -0.0272216796875 | 0.1993408203125 | 0.0025119781494140625 | -0.01560211181640625 | 0.00469970703125 | 0.0372314453125 | 0.05133056640625 | 0.06842041015625 | 0.1199951171875 | 0.005828857421875 | -0.007843017578125 | 0.0053863525390625 | 0.1773681640625 | 0.05712890625 | 0.1580810546875 | 0.6240234375 | 0.0072479248046875 |
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]);