apple_photos_scores

26 rows where ZCURATIONSCORE = "0.5" and ZINTERACTIONSCORE = "0.019999999552965164"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ZOVERALLAESTHETICSCORE, ZHIGHLIGHTVISIBILITYSCORE, ZBEHAVIORALSCORE, ZFAILURESCORE, ZIMMERSIVENESSSCORE, ZLOWLIGHT, ZNOISESCORE, ZWELLTIMEDSHOTSCORE

ZINTERACTIONSCORE ✖

  • 0.019999999552965164 · 26 ✖

ZCURATIONSCORE ✖

  • 0.5 · 26 ✖
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
62 62 25F1BCBC-3562-408E-9680-6FCEF1B81AA2 0.50244140625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.005535125732421875 0.004665374755859375 0.019999999552965164 -0.384033203125 -0.036773681640625 0.181396484375 0.0038852691650390625 -0.02947998046875 -0.0823974609375 -0.1904296875 -0.1136474609375 0.1702880859375 -0.056884765625 0.001659393310546875 -0.056396484375 0.006587982177734375 0.01467132568359375 -0.00415802001953125 -0.0748291015625 0.009765625 -0.01593017578125
103 103 3C683CF5-1644-412C-AA01-F6A2EAE58319 0.728515625 0.5 0.0 0.04353355223895939 0.10000000149011612 -0.00263214111328125 0.01399993896484375 0.001934051513671875 0.019999999552965164 0.07373046875 -0.137939453125 0.07965087890625 0.010406494140625 -0.01363372802734375 -0.016876220703125 -0.309814453125 -0.050537109375 0.0301513671875 0.03619384765625 0.0016632080078125 -0.00664520263671875 0.0018892288208007812 0.08282470703125 0.1552734375 -0.134521484375 0.359375 0.1292724609375
108 108 3E327FD2-CC19-4BF0-9D1B-9833A3D2F6B4 0.78125 0.5 0.0 0.04353485262120953 0.10000000149011612 -0.0012254714965820312 0.042755126953125 0.00279998779296875 0.019999999552965164 -0.191650390625 -0.05987548828125 0.419189453125 0.00734710693359375 -0.013427734375 -0.05120849609375 -0.2137451171875 0.0130615234375 0.5712890625 0.00146484375 0.0055694580078125 -0.016815185546875 0.0070953369140625 0.0709228515625 0.15087890625 -0.163330078125 0.04150390625 -0.0222625732421875
115 115 41CFBC2A-16F0-4F09-9A9F-5B83AA554B1D 0.70703125 0.5 0.0 0.043530952384453696 0.10000000149011612 -0.004364013671875 0.0061187744140625 0.004718780517578125 0.019999999552965164 -0.42724609375 -0.1483154296875 0.0650634765625 0.01332855224609375 -0.015838623046875 -0.08636474609375 -0.61962890625 -0.1812744140625 0.07196044921875 -0.0423583984375 -0.00017547607421875 -0.047637939453125 0.0026836395263671875 0.01016998291015625 -0.01580810546875 -0.1910400390625 -0.31103515625 -0.016571044921875
125 125 46ABC862-9837-404A-832B-4158270704FF 0.7314453125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.0031604766845703125 -0.007091522216796875 0.0027141571044921875 0.019999999552965164 0.05517578125 -0.057586669921875 0.1978759765625 0.004055023193359375 -0.05718994140625 -0.051116943359375 -0.272216796875 -0.1932373046875 0.1597900390625 -0.08160400390625 -0.00304412841796875 -0.0216217041015625 0.0029125213623046875 0.006717681884765625 -0.0247039794921875 -0.5302734375 -0.07275390625 -0.1270751953125
130 130 48EECE84-27A5-4AEC-9B09-6173F8700CEA 0.58349609375 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.004520416259765625 0.0024871826171875 0.00269317626953125 0.019999999552965164 -0.498291015625 -0.06878662109375 0.1837158203125 0.006931304931640625 -0.023101806640625 -0.06317138671875 -0.370361328125 -0.158447265625 0.11920166015625 -0.0765380859375 -0.003047943115234375 -0.0631103515625 0.0030155181884765625 0.021575927734375 0.007659912109375 -0.190673828125 -0.0775146484375 -0.033233642578125
157 157 57650917-1883-4D73-AD2B-B45C6A661534 0.3447265625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0022525787353515625 0.00321197509765625 0.004627227783203125 0.019999999552965164 -0.00634765625 -0.1229248046875 0.0634765625 0.00844573974609375 -0.0203704833984375 -0.053375244140625 -0.448974609375 -0.152587890625 0.0966796875 -0.019805908203125 -0.00054168701171875 -0.01448822021484375 0.00441741943359375 0.0119171142578125 -0.027587890625 -0.298583984375 -0.009033203125 0.0059814453125
159 159 57EAA6E6-990D-45CF-842D-E0DD2CE521A3 0.41064453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005138397216796875 0.0030517578125 0.0012159347534179688 0.019999999552965164 0.17138671875 -0.06451416015625 0.043548583984375 0.00955963134765625 -0.0836181640625 -0.022918701171875 -0.1002197265625 -0.2410888671875 0.0150146484375 -0.057891845703125 -0.0015716552734375 -0.009979248046875 0.0015850067138671875 0.051177978515625 -0.016876220703125 -0.0430908203125 0.5712890625 0.01898193359375
162 162 59FDAA51-7EF2-4D97-A110-7A42FA8AC018 0.44775390625 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00217437744140625 0.007617950439453125 0.00279998779296875 0.019999999552965164 0.0296630859375 -0.06707763671875 0.161865234375 0.005039215087890625 -0.02947998046875 -0.06591796875 -0.220458984375 -0.12347412109375 0.06634521484375 -0.047119140625 0.000492095947265625 -0.016754150390625 0.0034027099609375 0.0193023681640625 -0.02313232421875 -0.205810546875 0.237060546875 0.01519775390625
163 163 5A10AEF0-50DA-41BE-80F2-79E3367C343E 0.364501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.005428314208984375 -0.009002685546875 0.0024242401123046875 0.019999999552965164 -0.136962890625 -0.06658935546875 0.1895751953125 0.00661468505859375 -0.07861328125 -0.124267578125 -0.375244140625 -0.223388671875 0.31005859375 -0.18896484375 -0.0026531219482421875 -0.03070068359375 0.0036067962646484375 0.007518768310546875 -0.0423583984375 -0.465576171875 -0.2138671875 -0.1270751953125
174 174 60198E20-708E-4125-B793-4466A87B2DDA 0.392578125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.00307464599609375 0.0094757080078125 0.001220703125 0.019999999552965164 0.1380615234375 -0.056854248046875 0.2802734375 0.00313568115234375 -0.04559326171875 -0.04010009765625 -0.107666015625 -0.0838623046875 0.048492431640625 -0.160400390625 0.00628662109375 -0.0150909423828125 0.0010166168212890625 0.060760498046875 0.06494140625 -0.0399169921875 0.345947265625 -0.05755615234375
178 178 6274A881-9445-44D6-9E7C-776DAEF1C603 0.626953125 0.5 0.0 0.04200794951606343 0.10000000149011612 -0.002208709716796875 0.041107177734375 0.0035648345947265625 0.019999999552965164 0.14013671875 -0.07147216796875 0.12841796875 0.01009368896484375 -0.01061248779296875 -0.02294921875 0.0084228515625 -0.0406494140625 0.03143310546875 0.1263427734375 0.01114654541015625 -0.019287109375 0.005428314208984375 0.060211181640625 0.024200439453125 0.04046630859375 0.45068359375 0.143798828125
183 183 65600C73-CFBC-4FD9-AADE-9CA39F776FC2 0.70703125 0.5 0.0 0.04353076629056275 0.10000000149011612 -0.004070281982421875 0.00601959228515625 0.01132965087890625 0.019999999552965164 -0.5419921875 -0.152099609375 0.0072021484375 0.012725830078125 -0.01111602783203125 -0.11370849609375 -0.69384765625 -0.262939453125 0.1044921875 -0.0220947265625 0.00093841552734375 -0.0264434814453125 0.005039215087890625 0.0030517578125 -0.03656005859375 -0.08477783203125 -0.47119140625 -0.0071563720703125
203 203 7705FF4E-2F25-45B9-B795-EA58244F3273 0.708984375 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.06915283203125 -0.00589752197265625 0.00208282470703125 0.019999999552965164 -0.390869140625 -0.14306640625 -0.1083984375 0.0775146484375 -0.12322998046875 -0.06463623046875 -0.58837890625 -0.66650390625 0.024566650390625 -0.1026611328125 -0.0028285980224609375 -0.06109619140625 0.0018100738525390625 0.00464630126953125 -0.52734375 -0.286376953125 -0.095458984375 -0.10565185546875
221 221 8338977E-56F0-4A7D-A6FD-33C2B27C9364 0.36279296875 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012941360473632812 0.027679443359375 0.0012941360473632812 0.019999999552965164 -0.12005615234375 -0.033203125 0.3701171875 0.0015306472778320312 -0.00894927978515625 0.0038604736328125 -0.0025634765625 0.030609130859375 0.054412841796875 0.017578125 0.00809478759765625 -0.013641357421875 0.001628875732421875 0.26904296875 0.358642578125 0.220458984375 0.546875 -0.00630950927734375
291 291 A5DFB6E5-9DA4-4724-8439-AE9A800AD9EC 0.34521484375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0012254714965820312 0.0301361083984375 0.00919342041015625 0.019999999552965164 0.2430419921875 -0.0616455078125 -0.0184326171875 0.0119171142578125 -0.0135345458984375 -0.0247650146484375 0.134033203125 -0.022705078125 0.02532958984375 0.2529296875 0.0094757080078125 0.00237274169921875 0.0082855224609375 0.0211181640625 -0.0068359375 0.052947998046875 0.224609375 0.245361328125
301 301 A92AF32A-7C12-48CC-B1C3-5C83D05B76AA 0.4189453125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0011157989501953125 0.06903076171875 0.00734710693359375 0.019999999552965164 -0.3623046875 -0.03521728515625 0.1944580078125 0.0282135009765625 -0.01137542724609375 -0.0245361328125 -0.04638671875 0.085205078125 0.2430419921875 0.192626953125 0.03240966796875 -0.01221466064453125 0.01450347900390625 0.060516357421875 0.03424072265625 0.024658203125 0.1572265625 0.00374603271484375
312 312 ADE494D7-0048-491A-B410-D04C5C58B0DD 0.501953125 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0014553070068359375 0.0223541259765625 0.0022430419921875 0.019999999552965164 -0.1689453125 -0.0207672119140625 0.274169921875 0.0016107559204101562 -0.023284912109375 -0.021148681640625 0.013336181640625 -0.008758544921875 0.0755615234375 0.031982421875 0.0097198486328125 -0.0099945068359375 0.0033512115478515625 0.11163330078125 0.041748046875 0.31640625 0.488037109375 -0.00374603271484375
313 313 ADE9C25D-18D3-42C0-8BE9-CE2A30781B43 0.49755859375 0.5 0.0 0.038931297721298594 0.5044282078742981 -0.0012111663818359375 0.1588134765625 0.03533935546875 0.019999999552965164 0.2685546875 -0.026702880859375 0.157470703125 0.02484130859375 -0.007755279541015625 -0.00732421875 0.225341796875 0.22412109375 0.04132080078125 0.22412109375 0.09417724609375 0.01018524169921875 0.006511688232421875 0.0301055908203125 0.01500701904296875 0.05633544921875 0.040435791015625 0.058685302734375
333 333 B426930E-FED6-4916-BBB9-73934393B5C8 0.3740234375 0.5 0.0 0.038931297721298594 0.10000000149011612 -0.0023326873779296875 0.0109710693359375 0.0017137527465820312 0.019999999552965164 0.400390625 -0.044525146484375 0.01666259765625 0.030792236328125 -0.0701904296875 -0.0020904541015625 0.03350830078125 -0.1026611328125 0.021820068359375 0.078369140625 0.003688812255859375 -0.0031890869140625 0.004024505615234375 0.08648681640625 0.02398681640625 0.042236328125 0.68115234375 0.265869140625
375 375 CC3EF420-EAC4-4661-8D68-C2009F892C04 0.23974609375 0.5 0.0 0.038931297721298594 0.5029440522193909 -0.0008831024169921875 0.11505126953125 0.00395965576171875 0.019999999552965164 0.0281982421875 -0.0225067138671875 0.27880859375 0.01009368896484375 -0.0069580078125 0.039337158203125 0.1673583984375 0.260498046875 0.1424560546875 0.36865234375 0.142822265625 -0.00147247314453125 0.00600433349609375 0.501953125 0.66943359375 0.48828125 0.607421875 0.0160064697265625
402 402 E1468521-C7AB-4BA9-B4A9-D136FC9D4958 0.6083984375 0.5 0.0 0.04200813515495708 0.10000000149011612 -0.00974273681640625 0.00029754638671875 0.0013513565063476562 0.019999999552965164 -0.35498046875 -0.07879638671875 0.183349609375 0.004486083984375 -0.08526611328125 -0.072021484375 -0.189697265625 -0.219970703125 0.0309600830078125 -0.11846923828125 -0.09161376953125 -0.03326416015625 0.0009851455688476562 0.0284881591796875 -0.07403564453125 -0.1715087890625 0.30859375 -0.041015625
416 416 E77313F1-D351-4F1C-85BA-7D88CCE26FE7 0.71875 0.5 0.0 0.043553611249414106 0.10000000149011612 -0.006290435791015625 0.02703857421875 0.006122589111328125 0.019999999552965164 -0.939453125 -0.03192138671875 0.076416015625 0.00609588623046875 -0.005706787109375 -0.00545501708984375 -0.0206298828125 -0.045166015625 0.044342041015625 0.05059814453125 -0.043212890625 -0.005584716796875 0.004215240478515625 0.073974609375 0.135498046875 0.067138671875 0.154052734375 0.00299835205078125
439 439 F6F45595-4033-4C79-A9F9-86DCA9088C37 0.6103515625 0.5 0.0 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
447 447 FC01AB36-9465-4F95-8DC9-618FBC1405A6 0.76708984375 0.5 0.0 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
454 454 FF230430-EDD4-4E3F-83F9-C105A7EE7598 0.76220703125 0.5 0.0 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

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