Column descriptions

group_session
The group session ID
player_1_id
Player 1's participant ID
player_2_id
Player 2's participant ID
player_3_id
Player 3's participant ID
timestamp_unix
Unix timestamp of the observation
timestamp_iso8601
ISO-8601 timestamp of the observation.
task_started
Whether the task has started (1) or not (0).
seconds
The number of seconds left in the game (not shown to participants).
ball_position_x
The x-coordinate of the ball.
ball_position_y
The y-coordinate of the ball.
player_1_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 1's paddle.
player_1_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 1's paddle.
player_2_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 2's paddle.
player_2_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 2's paddle.
player_3_paddle_position_x
The x-coordinate of the pixel at the top left corner of player 3's paddle.
player_3_paddle_position_y
The y-coordinate of the pixel at the top left corner of player 3's paddle.
ai_paddle_position_x
The x-coordinate of the pixel at the top left corner of the AI player's paddle.
ai_paddle_position_y
The y-coordinate of the pixel at the top left corner of the AI player's paddle.
team_score
The team's score.
ai_score
The score of the AI player.

where player_2_id = 152

View and edit SQL

Suggested facets: task_started, team_score, ai_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_3_id timestamp_unix timestamp_iso8601 task_started seconds ball_position_x ball_position_y player_1_paddle_position_x player_1_paddle_position_y player_2_paddle_position_x player_2_paddle_position_y player_3_paddle_position_x player_3_paddle_position_y ai_paddle_position_x ai_paddle_position_y team_score ai_score
exp_2023_04_28_10 144 152 162 1682707282.695705 2023-04-28T18:41:22.695705+00:00 0 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_04_28_10 144 152 162 1682707282.7121885 2023-04-28T18:41:22.712188+00:00 0 10 1285 725 880 536 880 594 880 674 1660 476 0 0
exp_2023_04_28_10 144 152 162 1682707282.7284107 2023-04-28T18:41:22.728411+00:00 0 10 1285 725 880 536 880 594 880 674 1660 488 0 0
exp_2023_04_28_10 144 152 162 1682707282.7436304 2023-04-28T18:41:22.743630+00:00 0 10 1285 725 880 536 880 594 880 674 1660 500 0 0
exp_2023_04_28_10 144 152 162 1682707282.759857 2023-04-28T18:41:22.759857+00:00 0 10 1285 725 880 536 880 594 880 674 1660 512 0 0
exp_2023_04_28_10 144 152 162 1682707282.7760515 2023-04-28T18:41:22.776052+00:00 0 10 1285 725 880 536 880 594 880 674 1660 524 0 0
exp_2023_04_28_10 144 152 162 1682707282.7922635 2023-04-28T18:41:22.792264+00:00 0 10 1285 725 880 536 880 594 880 674 1660 536 0 0
exp_2023_04_28_10 144 152 162 1682707282.8084767 2023-04-28T18:41:22.808477+00:00 0 10 1285 725 880 536 880 594 880 674 1660 548 0 0
exp_2023_04_28_10 144 152 162 1682707282.8236659 2023-04-28T18:41:22.823666+00:00 0 10 1285 725 880 536 880 594 880 674 1660 548 0 0
exp_2023_04_28_10 144 152 162 1682707282.8398688 2023-04-28T18:41:22.839869+00:00 0 10 1285 725 880 536 880 594 880 674 1660 560 0 0
exp_2023_04_28_10 144 152 162 1682707282.8560827 2023-04-28T18:41:22.856083+00:00 0 10 1285 725 880 536 880 594 880 674 1660 572 0 0
exp_2023_04_28_10 144 152 162 1682707282.872275 2023-04-28T18:41:22.872275+00:00 0 10 1285 725 880 536 880 594 880 674 1660 584 0 0
exp_2023_04_28_10 144 152 162 1682707282.8884866 2023-04-28T18:41:22.888487+00:00 0 10 1285 725 880 536 880 594 880 674 1660 596 0 0
exp_2023_04_28_10 144 152 162 1682707282.9036882 2023-04-28T18:41:22.903688+00:00 0 10 1285 725 880 536 880 594 880 674 1660 608 0 0
exp_2023_04_28_10 144 152 162 1682707282.9199038 2023-04-28T18:41:22.919904+00:00 0 10 1285 725 880 536 880 594 880 674 1660 620 0 0
exp_2023_04_28_10 144 152 162 1682707282.936161 2023-04-28T18:41:22.936161+00:00 0 10 1285 725 880 536 880 594 880 674 1660 632 0 0
exp_2023_04_28_10 144 152 162 1682707282.9523988 2023-04-28T18:41:22.952399+00:00 0 10 1285 725 880 536 880 594 880 674 1660 632 0 0
exp_2023_04_28_10 144 152 162 1682707282.967665 2023-04-28T18:41:22.967665+00:00 0 10 1285 725 880 536 880 594 880 674 1660 644 0 0
exp_2023_04_28_10 144 152 162 1682707282.9838834 2023-04-28T18:41:22.983883+00:00 0 10 1285 725 880 536 880 594 880 674 1660 656 0 0
exp_2023_04_28_10 144 152 162 1682707283.0001028 2023-04-28T18:41:23.000103+00:00 0 10 1285 725 880 536 880 594 880 674 1660 668 0 0
exp_2023_04_28_10 144 152 162 1682707283.0163207 2023-04-28T18:41:23.016321+00:00 0 10 1285 725 880 536 880 594 880 674 1660 678 0 0
exp_2023_04_28_10 144 152 162 1682707283.0325603 2023-04-28T18:41:23.032560+00:00 0 10 1285 725 880 536 880 594 880 674 1660 682 0 0
exp_2023_04_28_10 144 152 162 1682707283.048807 2023-04-28T18:41:23.048807+00:00 0 10 1285 725 880 536 880 594 880 674 1660 683 0 0
exp_2023_04_28_10 144 152 162 1682707283.065032 2023-04-28T18:41:23.065032+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.0812528 2023-04-28T18:41:23.081253+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.097496 2023-04-28T18:41:23.097496+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.1127179 2023-04-28T18:41:23.112718+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.128949 2023-04-28T18:41:23.128949+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.1451738 2023-04-28T18:41:23.145174+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.1614068 2023-04-28T18:41:23.161407+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.1766238 2023-04-28T18:41:23.176624+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.1928513 2023-04-28T18:41:23.192851+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.2090628 2023-04-28T18:41:23.209063+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.22529 2023-04-28T18:41:23.225290+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.2415335 2023-04-28T18:41:23.241534+00:00 0 10 1285 725 880 536 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.2577515 2023-04-28T18:41:23.257751+00:00 0 10 1285 725 880 535 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.2739582 2023-04-28T18:41:23.273958+00:00 0 10 1285 725 880 535 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.2901642 2023-04-28T18:41:23.290164+00:00 0 10 1285 725 880 541 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3063977 2023-04-28T18:41:23.306398+00:00 0 10 1285 725 880 554 880 594 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3216166 2023-04-28T18:41:23.321617+00:00 0 10 1285 725 880 554 880 596 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3378456 2023-04-28T18:41:23.337846+00:00 0 10 1285 725 880 570 880 602 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3540666 2023-04-28T18:41:23.354067+00:00 0 10 1285 725 880 583 880 605 880 674 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3702943 2023-04-28T18:41:23.370294+00:00 0 10 1285 725 880 588 880 607 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.3865683 2023-04-28T18:41:23.386568+00:00 0 10 1285 725 880 604 880 607 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.4028056 2023-04-28T18:41:23.402806+00:00 0 10 1285 725 880 625 880 609 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.4190614 2023-04-28T18:41:23.419061+00:00 0 10 1285 725 880 625 880 613 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.435292 2023-04-28T18:41:23.435292+00:00 0 10 1285 725 880 634 880 616 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.4515646 2023-04-28T18:41:23.451565+00:00 0 10 1285 725 880 643 880 618 880 688 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.467771 2023-04-28T18:41:23.467771+00:00 0 10 1285 725 880 648 880 619 880 689 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.483998 2023-04-28T18:41:23.483998+00:00 0 10 1285 725 880 649 880 620 880 690 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.500218 2023-04-28T18:41:23.500218+00:00 0 10 1285 725 880 649 880 621 880 693 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5164325 2023-04-28T18:41:23.516433+00:00 0 10 1285 725 880 653 880 622 880 696 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5316641 2023-04-28T18:41:23.531664+00:00 0 10 1285 725 880 653 880 623 880 701 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5478992 2023-04-28T18:41:23.547899+00:00 0 10 1285 725 880 653 880 623 880 705 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5641289 2023-04-28T18:41:23.564129+00:00 0 10 1285 725 880 653 880 624 880 707 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5803783 2023-04-28T18:41:23.580378+00:00 0 10 1285 725 880 653 880 625 880 714 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.5956264 2023-04-28T18:41:23.595626+00:00 0 10 1285 725 880 653 880 629 880 716 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.6118758 2023-04-28T18:41:23.611876+00:00 0 10 1285 725 880 653 880 631 880 718 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.6281226 2023-04-28T18:41:23.628123+00:00 0 10 1285 725 880 653 880 632 880 718 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.644344 2023-04-28T18:41:23.644344+00:00 0 10 1285 725 880 645 880 632 880 722 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.66057 2023-04-28T18:41:23.660570+00:00 0 10 1285 725 880 629 880 632 880 727 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.6768064 2023-04-28T18:41:23.676806+00:00 0 10 1285 725 880 614 880 632 880 734 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.693018 2023-04-28T18:41:23.693018+00:00 0 10 1285 725 880 607 880 632 880 742 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7092528 2023-04-28T18:41:23.709253+00:00 0 10 1285 725 880 596 880 632 880 750 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7254755 2023-04-28T18:41:23.725476+00:00 0 9 1285 725 880 581 880 632 880 756 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7407014 2023-04-28T18:41:23.740701+00:00 0 9 1285 725 880 563 880 632 880 760 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7569377 2023-04-28T18:41:23.756938+00:00 0 9 1285 725 880 549 880 632 880 763 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7731981 2023-04-28T18:41:23.773198+00:00 0 9 1285 725 880 549 880 624 880 765 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.7894325 2023-04-28T18:41:23.789433+00:00 0 9 1285 725 880 541 880 624 880 765 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.804654 2023-04-28T18:41:23.804654+00:00 0 9 1285 725 880 541 880 612 880 765 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.820883 2023-04-28T18:41:23.820883+00:00 0 9 1285 725 880 539 880 608 880 765 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.837098 2023-04-28T18:41:23.837098+00:00 0 9 1285 725 880 532 880 600 880 762 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.853319 2023-04-28T18:41:23.853319+00:00 0 9 1285 725 880 529 880 585 880 748 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.8695266 2023-04-28T18:41:23.869527+00:00 0 9 1285 725 880 529 880 576 880 738 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.8847575 2023-04-28T18:41:23.884758+00:00 0 9 1285 725 880 529 880 565 880 732 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.9009707 2023-04-28T18:41:23.900971+00:00 0 9 1285 725 880 529 880 555 880 721 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.917188 2023-04-28T18:41:23.917188+00:00 0 9 1285 725 880 533 880 548 880 706 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.9334025 2023-04-28T18:41:23.933403+00:00 0 9 1285 725 880 548 880 543 880 702 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.9486148 2023-04-28T18:41:23.948615+00:00 0 9 1285 725 880 548 880 540 880 696 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.964825 2023-04-28T18:41:23.964825+00:00 0 9 1285 725 880 582 880 539 880 689 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.981049 2023-04-28T18:41:23.981049+00:00 0 9 1285 725 880 615 880 537 880 689 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707283.997268 2023-04-28T18:41:23.997268+00:00 0 9 1285 725 880 665 880 535 880 684 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.013493 2023-04-28T18:41:24.013493+00:00 0 9 1285 725 880 680 880 535 880 681 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.028721 2023-04-28T18:41:24.028721+00:00 0 9 1285 725 880 680 880 535 880 680 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.044941 2023-04-28T18:41:24.044941+00:00 0 9 1285 725 880 681 880 535 880 680 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.061159 2023-04-28T18:41:24.061159+00:00 0 9 1285 725 880 681 880 535 880 680 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.0773826 2023-04-28T18:41:24.077383+00:00 0 9 1285 725 880 681 880 535 880 680 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.0936117 2023-04-28T18:41:24.093612+00:00 0 9 1285 725 880 678 880 535 880 682 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.1098342 2023-04-28T18:41:24.109834+00:00 0 9 1285 725 880 669 880 535 880 689 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.126056 2023-04-28T18:41:24.126056+00:00 0 9 1285 725 880 657 880 538 880 701 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.1422865 2023-04-28T18:41:24.142287+00:00 0 9 1285 725 880 641 880 544 880 718 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.158504 2023-04-28T18:41:24.158504+00:00 0 9 1285 725 880 625 880 549 880 738 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.173716 2023-04-28T18:41:24.173716+00:00 0 9 1285 725 880 603 880 556 880 758 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.1899319 2023-04-28T18:41:24.189932+00:00 0 9 1285 725 880 579 880 563 880 792 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2061608 2023-04-28T18:41:24.206161+00:00 0 9 1285 725 880 557 880 572 880 804 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2223804 2023-04-28T18:41:24.222380+00:00 0 9 1285 725 880 545 880 585 880 804 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2385974 2023-04-28T18:41:24.238597+00:00 0 9 1285 725 880 545 880 598 880 814 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2548072 2023-04-28T18:41:24.254807+00:00 0 9 1285 725 880 545 880 610 880 821 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2710207 2023-04-28T18:41:24.271021+00:00 0 9 1285 725 880 545 880 622 880 827 1660 684 0 0
exp_2023_04_28_10 144 152 162 1682707284.2872453 2023-04-28T18:41:24.287245+00:00 0 9 1285 725 880 546 880 632 880 830 1660 684 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_cooperative_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_3_id] INTEGER REFERENCES [participant]([id]),
   [timestamp_unix] TEXT,
   [timestamp_iso8601] TEXT,
   [task_started] INTEGER,
   [seconds] INTEGER,
   [ball_position_x] INTEGER,
   [ball_position_y] INTEGER,
   [player_1_paddle_position_x] INTEGER,
   [player_1_paddle_position_y] INTEGER,
   [player_2_paddle_position_x] INTEGER,
   [player_2_paddle_position_y] INTEGER,
   [player_3_paddle_position_x] INTEGER,
   [player_3_paddle_position_y] INTEGER,
   [ai_paddle_position_x] INTEGER,
   [ai_paddle_position_y] INTEGER,
   [team_score] INTEGER,
   [ai_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_3_id], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_3_id]
    ON [ping_pong_cooperative_task_observation] ([player_3_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_2_id]
    ON [ping_pong_cooperative_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_player_1_id]
    ON [ping_pong_cooperative_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_cooperative_task_observation_group_session]
    ON [ping_pong_cooperative_task_observation] ([group_session]);