apple_photos_scores

1 row where ZPLEASANTCAMERATILTSCORE = "-0.038543701171875"

View and edit SQL

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
215 7E21418A-1A30-43AB-B025-4D6576EA29CE 0.6044921875 0.75 0.0 0.06108839002274375 0.5067153573036194 -0.000720977783203125 0.05499267578125 0.0169219970703125 0.05999999865889549 0.2783203125 -0.059967041015625 0.048614501953125 0.007785797119140625 -0.00763702392578125 -0.038543701171875 0.0819091796875 0.0599365234375 0.04534912109375 0.256103515625 0.0198974609375 0.002166748046875 0.00844573974609375 0.0153045654296875 -0.000885009765625 0.0233612060546875 0.0638427734375 0.095703125

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);
Powered by Datasette · Query took 55.127ms · About: dogsheep/dogsheep-photos