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 = 53

View and edit SQL

Suggested facets: 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_2022_11_04_10 99906 53 52 1667588035.0671089 2022-11-04T18:53:55.067109+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_04_10 99906 53 52 1667588035.0828302 2022-11-04T18:53:55.082830+00:00 1 10 1285 725 880 692 880 470 880 776 1660 633 0 0
exp_2022_11_04_10 99906 53 52 1667588035.0990589 2022-11-04T18:53:55.099059+00:00 1 10 1285 725 880 692 880 470 880 776 1660 645 0 0
exp_2022_11_04_10 99906 53 52 1667588035.1153102 2022-11-04T18:53:55.115310+00:00 1 10 1285 725 880 689 880 470 880 776 1660 657 0 0
exp_2022_11_04_10 99906 53 52 1667588035.130526 2022-11-04T18:53:55.130526+00:00 1 10 1285 725 880 687 880 470 880 776 1660 669 0 0
exp_2022_11_04_10 99906 53 52 1667588035.1467264 2022-11-04T18:53:55.146726+00:00 1 10 1285 725 880 687 880 470 880 776 1660 678 0 0
exp_2022_11_04_10 99906 53 52 1667588035.1629107 2022-11-04T18:53:55.162911+00:00 1 10 1285 725 880 687 880 470 880 776 1660 682 0 0
exp_2022_11_04_10 99906 53 52 1667588035.1790953 2022-11-04T18:53:55.179095+00:00 1 10 1285 725 880 686 880 470 880 776 1660 683 0 0
exp_2022_11_04_10 99906 53 52 1667588035.195285 2022-11-04T18:53:55.195285+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.2114687 2022-11-04T18:53:55.211469+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.2276735 2022-11-04T18:53:55.227674+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.2438855 2022-11-04T18:53:55.243886+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.2601569 2022-11-04T18:53:55.260157+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.2764378 2022-11-04T18:53:55.276438+00:00 1 10 1285 725 880 685 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.291745 2022-11-04T18:53:55.291745+00:00 1 10 1285 725 880 684 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.3080564 2022-11-04T18:53:55.308056+00:00 1 10 1285 725 880 683 880 471 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.324294 2022-11-04T18:53:55.324294+00:00 1 10 1285 725 880 683 880 471 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.3405066 2022-11-04T18:53:55.340507+00:00 1 10 1285 725 880 683 880 474 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.3567414 2022-11-04T18:53:55.356741+00:00 1 10 1285 725 880 683 880 480 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.372965 2022-11-04T18:53:55.372965+00:00 1 10 1285 725 880 683 880 487 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.3892076 2022-11-04T18:53:55.389208+00:00 1 10 1285 725 880 683 880 495 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.4054036 2022-11-04T18:53:55.405404+00:00 1 10 1285 725 880 683 880 503 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.4205945 2022-11-04T18:53:55.420594+00:00 1 10 1285 725 880 683 880 514 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.4367836 2022-11-04T18:53:55.436784+00:00 1 10 1285 725 880 683 880 522 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.4529834 2022-11-04T18:53:55.452983+00:00 1 10 1285 725 880 683 880 526 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.4691978 2022-11-04T18:53:55.469198+00:00 1 10 1285 725 880 683 880 526 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.485423 2022-11-04T18:53:55.485423+00:00 1 10 1285 725 880 683 880 527 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5006726 2022-11-04T18:53:55.500673+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5169759 2022-11-04T18:53:55.516976+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5331905 2022-11-04T18:53:55.533190+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5494018 2022-11-04T18:53:55.549402+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5645926 2022-11-04T18:53:55.564593+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5807865 2022-11-04T18:53:55.580786+00:00 1 10 1285 725 880 683 880 528 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.5969853 2022-11-04T18:53:55.596985+00:00 1 10 1285 725 880 683 880 527 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.613193 2022-11-04T18:53:55.613193+00:00 1 10 1285 725 880 683 880 520 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.629385 2022-11-04T18:53:55.629385+00:00 1 10 1285 725 880 683 880 520 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.6445901 2022-11-04T18:53:55.644590+00:00 1 10 1285 725 880 683 880 513 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.6608229 2022-11-04T18:53:55.660823+00:00 1 10 1285 725 880 683 880 501 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.677054 2022-11-04T18:53:55.677054+00:00 1 10 1285 725 880 683 880 489 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.6932473 2022-11-04T18:53:55.693247+00:00 1 10 1285 725 880 683 880 479 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.709428 2022-11-04T18:53:55.709428+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.7246397 2022-11-04T18:53:55.724640+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.7408226 2022-11-04T18:53:55.740823+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.757005 2022-11-04T18:53:55.757005+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.773192 2022-11-04T18:53:55.773192+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.789416 2022-11-04T18:53:55.789416+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.804659 2022-11-04T18:53:55.804659+00:00 1 10 1285 725 880 683 880 470 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.8209221 2022-11-04T18:53:55.820922+00:00 1 10 1285 725 880 683 880 471 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.8371813 2022-11-04T18:53:55.837181+00:00 1 10 1285 725 880 683 880 477 880 776 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.8534224 2022-11-04T18:53:55.853422+00:00 1 10 1285 725 880 683 880 488 880 777 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.8686771 2022-11-04T18:53:55.868677+00:00 1 10 1285 725 880 698 880 503 880 777 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.8848886 2022-11-04T18:53:55.884889+00:00 1 10 1285 725 880 699 880 520 880 777 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.901083 2022-11-04T18:53:55.901083+00:00 1 10 1285 725 880 712 880 539 880 778 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.9172473 2022-11-04T18:53:55.917247+00:00 1 10 1285 725 880 727 880 558 880 778 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.9334664 2022-11-04T18:53:55.933466+00:00 1 10 1285 725 880 727 880 575 880 778 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.9486825 2022-11-04T18:53:55.948683+00:00 1 10 1285 725 880 739 880 575 880 779 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.964877 2022-11-04T18:53:55.964877+00:00 1 10 1285 725 880 739 880 603 880 780 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.981056 2022-11-04T18:53:55.981056+00:00 1 10 1285 725 880 741 880 612 880 783 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588035.9972322 2022-11-04T18:53:55.997232+00:00 1 10 1285 725 880 748 880 616 880 787 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.013415 2022-11-04T18:53:56.013415+00:00 1 10 1285 725 880 751 880 617 880 796 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.0285919 2022-11-04T18:53:56.028592+00:00 1 10 1285 725 880 754 880 617 880 803 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.0447602 2022-11-04T18:53:56.044760+00:00 1 10 1285 725 880 761 880 617 880 809 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.0609527 2022-11-04T18:53:56.060953+00:00 1 10 1285 725 880 761 880 617 880 819 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.077134 2022-11-04T18:53:56.077134+00:00 1 10 1285 725 880 761 880 617 880 819 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.0933125 2022-11-04T18:53:56.093313+00:00 1 9 1285 725 880 761 880 615 880 824 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.1094923 2022-11-04T18:53:56.109492+00:00 1 9 1285 725 880 761 880 605 880 828 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.124679 2022-11-04T18:53:56.124679+00:00 1 9 1285 725 880 761 880 590 880 831 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.1408834 2022-11-04T18:53:56.140883+00:00 1 9 1285 725 880 761 880 590 880 834 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.1570911 2022-11-04T18:53:56.157091+00:00 1 9 1285 725 880 754 880 557 880 838 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.1732726 2022-11-04T18:53:56.173273+00:00 1 9 1285 725 880 704 880 538 880 840 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.1894877 2022-11-04T18:53:56.189488+00:00 1 9 1285 725 880 695 880 538 880 842 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.204798 2022-11-04T18:53:56.204798+00:00 1 9 1285 725 880 695 880 514 880 843 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.2210765 2022-11-04T18:53:56.221076+00:00 1 9 1285 725 880 686 880 493 880 843 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.2373672 2022-11-04T18:53:56.237367+00:00 1 9 1285 725 880 670 880 477 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.2526562 2022-11-04T18:53:56.252656+00:00 1 9 1285 725 880 655 880 470 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.2689552 2022-11-04T18:53:56.268955+00:00 1 9 1285 725 880 648 880 470 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.2852526 2022-11-04T18:53:56.285253+00:00 1 9 1285 725 880 648 880 470 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.300617 2022-11-04T18:53:56.300617+00:00 1 9 1285 725 880 648 880 470 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.316883 2022-11-04T18:53:56.316883+00:00 1 9 1285 725 880 648 880 470 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.3331552 2022-11-04T18:53:56.333155+00:00 1 9 1285 725 880 648 880 482 880 844 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.3495104 2022-11-04T18:53:56.349510+00:00 1 9 1285 725 880 648 880 501 880 843 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.3648005 2022-11-04T18:53:56.364800+00:00 1 9 1285 725 880 648 880 501 880 840 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.3810835 2022-11-04T18:53:56.381083+00:00 1 9 1285 725 880 648 880 519 880 834 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.3973644 2022-11-04T18:53:56.397364+00:00 1 9 1285 725 880 648 880 537 880 825 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.4126563 2022-11-04T18:53:56.412656+00:00 1 9 1285 725 880 648 880 554 880 816 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.4289093 2022-11-04T18:53:56.428909+00:00 1 9 1285 725 880 648 880 569 880 816 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.4451084 2022-11-04T18:53:56.445108+00:00 1 9 1285 725 880 648 880 582 880 811 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.4613097 2022-11-04T18:53:56.461310+00:00 1 9 1285 725 880 648 880 594 880 807 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.4774997 2022-11-04T18:53:56.477500+00:00 1 9 1285 725 880 648 880 604 880 802 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.492692 2022-11-04T18:53:56.492692+00:00 1 9 1285 725 880 648 880 614 880 793 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.508864 2022-11-04T18:53:56.508864+00:00 1 9 1285 725 880 648 880 623 880 786 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.5250533 2022-11-04T18:53:56.525053+00:00 1 9 1285 725 880 648 880 633 880 775 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.5412388 2022-11-04T18:53:56.541239+00:00 1 9 1285 725 880 648 880 643 880 775 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.5574138 2022-11-04T18:53:56.557414+00:00 1 9 1285 725 880 648 880 649 880 769 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.5725884 2022-11-04T18:53:56.572588+00:00 1 9 1285 725 880 648 880 649 880 763 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.5887852 2022-11-04T18:53:56.588785+00:00 1 9 1285 725 880 648 880 649 880 759 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.6049893 2022-11-04T18:53:56.604989+00:00 1 9 1285 725 880 648 880 637 880 757 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.6211772 2022-11-04T18:53:56.621177+00:00 1 9 1285 725 880 648 880 630 880 756 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.6373792 2022-11-04T18:53:56.637379+00:00 1 9 1285 725 880 648 880 602 880 756 1660 684 0 0
exp_2022_11_04_10 99906 53 52 1667588036.6535594 2022-11-04T18:53:56.653559+00:00 1 9 1285 725 880 648 880 602 880 756 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]);