apple_photos_scores

19 rows where ZINTERACTIONSCORE = "0.03999999910593033" sorted by ZPLEASANTLIGHTINGSCORE

✎ View and edit SQL

This data as json, CSV (advanced)

ZINTERACTIONSCORE ✖

  • 0.03999999910593033 · 14 ✖
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
284 284 A40BDBBE-2DC6-4385-8108-8C15F37610B4 0.54931640625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.001918792724609375 -0.00484466552734375 0.002834320068359375 0.03999999910593033 0.165283203125 -0.04052734375 0.24755859375 0.0024623870849609375 -0.04595947265625 -0.04052734375 -0.1414794921875 -0.1551513671875 0.20751953125 -0.065673828125 -0.00061798095703125 -0.0300750732421875 0.005161285400390625 0.00844573974609375 -0.01395416259765625 -0.49267578125 0.1368408203125 -0.09515380859375
150 150 5392047B-DF94-46CF-BA61-06ECE4D8CD9E 0.43701171875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0020503997802734375 0.0012054443359375 0.00266265869140625 0.03999999910593033 -0.0677490234375 -0.093505859375 0.361328125 0.0033111572265625 -0.01525115966796875 -0.0430908203125 -0.4287109375 -0.0633544921875 0.1295166015625 -0.07568359375 -0.00975799560546875 -0.01381683349609375 0.0014162063598632812 0.01934814453125 0.02264404296875 -0.5283203125 -0.20849609375 -0.10821533203125
50 50 1EAE7EE2-CBE6-491B-A8EF-337859628659 0.347900390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0028896331787109375 0.01885986328125 0.004116058349609375 0.03999999910593033 0.1094970703125 -0.053192138671875 0.1767578125 0.00254058837890625 -0.019561767578125 -0.03076171875 -0.08697509765625 -0.03570556640625 0.029815673828125 0.0164794921875 0.00586700439453125 -0.00499725341796875 0.001926422119140625 0.037261962890625 -0.0113525390625 0.08465576171875 0.339599609375 0.105224609375
20 20 0C7F8BD3-7996-4FBD-A886-2D885AC7F618 0.5712890625 0.75 0.0 0.05801526718694745 0.10000000149011612 -0.0014781951904296875 0.016510009765625 0.008575439453125 0.03999999910593033 -0.235107421875 -0.05291748046875 0.2169189453125 0.00669097900390625 -0.01214599609375 -0.043487548828125 -0.1904296875 -0.03326416015625 0.430908203125 0.0216064453125 0.00054931640625 -0.0718994140625 0.0169830322265625 0.0224609375 0.0220794677734375 -0.1822509765625 -0.0218505859375 -0.0104827880859375
341 341 BA1C8565-7D1C-49E3-93BA-183B8D6B1270 0.84228515625 0.75 0.0 0.06261613123289501 0.10000000149011612 -0.0006117820739746094 0.0157012939453125 0.0020351409912109375 0.03999999910593033 0.599609375 -0.06622314453125 0.10491943359375 0.01009368896484375 -0.015838623046875 0.00726318359375 0.02276611328125 -0.0177001953125 0.07318115234375 0.0751953125 0.00572967529296875 -0.008392333984375 0.00867462158203125 0.0836181640625 0.047119140625 -0.158203125 0.68798828125 0.1689453125
216 216 801ECB04-F7C1-4D36-8B07-6B52B80E74A0 0.8330078125 0.75 0.0 0.06261723005134641 0.7075669169425964 -0.0026416778564453125 0.0203857421875 0.0023136138916015625 0.03999999910593033 0.49658203125 -0.09173583984375 -0.0142822265625 0.024993896484375 -0.0110321044921875 0.0013427734375 0.094482421875 0.013671875 0.0121002197265625 0.1624755859375 0.007904052734375 0.0004119873046875 0.0034427642822265625 0.149169921875 0.28857421875 0.085205078125 0.65380859375 0.52685546875
324 324 B19BB608-7B37-4094-AE9B-504B13660278 0.3291015625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0016231536865234375 0.041717529296875 0.0011377334594726562 0.03999999910593033 -0.0711669921875 -0.0386962890625 0.30029296875 0.005199432373046875 -0.0154266357421875 0.0089111328125 0.0123291015625 0.0244140625 0.0794677734375 0.08740234375 0.020721435546875 -0.0150146484375 0.00274658203125 0.324462890625 0.397705078125 0.28076171875 0.62158203125 0.00057220458984375
16 16 0A9EB544-AC29-4D70-BDD2-4DF2E53D6E1A 0.6171875 0.5 0.0 0.0420040488243103 0.10000000149011612 -0.0006799697875976562 0.0157928466796875 0.01085662841796875 0.03999999910593033 0.0447998046875 -0.04351806640625 0.267578125 0.0020503997802734375 -0.00844573974609375 -0.02105712890625 -0.161376953125 0.03826904296875 0.12213134765625 0.011474609375 0.0068359375 -0.0125885009765625 0.005706787109375 0.0153045654296875 0.002277374267578125 -0.194580078125 0.0333251953125 -0.00848388671875
400 400 DEA5349B-F370-47FA-97E1-5ABAEED723AD 0.81689453125 0.75 0.0 0.0626261907679434 0.5067639946937561 -0.0010900497436523438 0.0285491943359375 0.0036067962646484375 0.03999999910593033 0.5546875 -0.036285400390625 0.007415771484375 0.023773193359375 -0.021453857421875 0.0043182373046875 0.25830078125 0.052490234375 0.021087646484375 0.2227783203125 0.0179290771484375 0.0009918212890625 0.0090179443359375 0.1263427734375 0.0472412109375 0.2783203125 0.77734375 0.314453125
398 398 DD6E4630-85BD-41BF-A7B3-524C02942A65 0.61279296875 0.5 0.0 0.04201835029907809 0.503333330154419 -0.0020904541015625 0.115478515625 0.00547027587890625 0.03999999910593033 -0.006591796875 -0.040313720703125 0.2203369140625 0.0150146484375 -0.00392913818359375 0.002899169921875 0.1368408203125 0.185791015625 0.10894775390625 0.177490234375 0.031951904296875 0.001537322998046875 0.00453948974609375 0.251953125 0.67138671875 0.09588623046875 0.296142578125 0.0736083984375
91 91 36F88EBB-0DDF-423B-AEFB-A1A5FFE8202E 0.48486328125 0.75 0.0 0.05801526718694745 0.5043065547943115 -0.0008559226989746094 0.022125244140625 0.0018825531005859375 0.03999999910593033 0.58203125 -0.05633544921875 0.005279541015625 0.06903076171875 -0.01267242431640625 0.0079498291015625 0.2421875 0.242919921875 0.011505126953125 0.1534423828125 0.0126800537109375 0.001617431640625 0.005535125732421875 0.373291015625 0.41796875 0.06787109375 0.84716796875 0.3896484375
347 347 BD6B9CF4-90A4-4C00-BD17-473AAB3AE1A2 0.3583984375 0.5 0.0 0.038931297721298594 0.5039172768592834 -0.0008168220520019531 0.03851318359375 0.001949310302734375 0.03999999910593033 0.2958984375 -0.03314208984375 0.058319091796875 0.0271759033203125 -0.007038116455078125 0.0072479248046875 0.328125 0.2447509765625 0.01450347900390625 0.1962890625 0.0167236328125 0.000606536865234375 0.006488800048828125 0.58203125 0.58935546875 0.2381591796875 0.88427734375 0.1051025390625
353 353 BF9CEE04-8E45-4586-BC61-7E5921483763 0.712890625 0.75 0.0 0.06263033715823224 0.5045985579490662 -0.0006413459777832031 0.0499267578125 0.0026721954345703125 0.03999999910593033 0.54931640625 -0.041473388671875 0.035003662109375 0.0394287109375 -0.0082550048828125 0.00948333740234375 0.360107421875 0.301025390625 0.0127716064453125 0.260986328125 0.0268707275390625 0.00336456298828125 0.00653839111328125 0.37060546875 0.29248046875 0.223876953125 0.8359375 0.3427734375
60 60 23F1ACC2-DF35-42BD-9332-A3C51B9AA8C6 0.68896484375 0.75 0.0 0.061103805785870734 0.7047201991081238 -0.000583648681640625 0.0305023193359375 0.0018606185913085938 0.03999999910593033 0.79833984375 -0.047943115234375 0.031646728515625 0.0161590576171875 -0.0041351318359375 0.00727081298828125 0.41015625 0.318359375 0.01507568359375 0.22802734375 0.01171112060546875 0.00311279296875 0.006313323974609375 0.5595703125 0.74560546875 0.13330078125 0.8798828125 0.66357421875

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 3.69ms · About: dogsheep/dogsheep-photos