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

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_21_10 99901 143 146 1682102547.0420973 2023-04-21T18:42:27.042097+00:00 0 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_04_21_10 99901 143 146 1682102547.0580275 2023-04-21T18:42:27.058028+00:00 0 10 1285 725 880 633 880 880 880 776 1660 470 0 0
exp_2023_04_21_10 99901 143 146 1682102547.0733645 2023-04-21T18:42:27.073364+00:00 0 10 1285 725 880 640 880 880 880 776 1660 476 0 0
exp_2023_04_21_10 99901 143 146 1682102547.0896957 2023-04-21T18:42:27.089696+00:00 0 10 1285 725 880 655 880 880 880 776 1660 476 0 0
exp_2023_04_21_10 99901 143 146 1682102547.1060252 2023-04-21T18:42:27.106025+00:00 0 10 1285 725 880 672 880 880 880 776 1660 476 0 0
exp_2023_04_21_10 99901 143 146 1682102547.1213646 2023-04-21T18:42:27.121365+00:00 0 10 1285 725 880 672 880 880 880 776 1660 512 0 0
exp_2023_04_21_10 99901 143 146 1682102547.137704 2023-04-21T18:42:27.137704+00:00 0 10 1285 725 880 672 880 880 880 776 1660 512 0 0
exp_2023_04_21_10 99901 143 146 1682102547.1540387 2023-04-21T18:42:27.154039+00:00 0 10 1285 725 880 672 880 880 880 776 1660 536 0 0
exp_2023_04_21_10 99901 143 146 1682102547.1693964 2023-04-21T18:42:27.169396+00:00 0 10 1285 725 880 672 880 880 880 776 1660 548 0 0
exp_2023_04_21_10 99901 143 146 1682102547.1856537 2023-04-21T18:42:27.185654+00:00 0 10 1285 725 880 668 880 880 880 776 1660 560 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2019596 2023-04-21T18:42:27.201960+00:00 0 10 1285 725 880 665 880 880 880 776 1660 572 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2183022 2023-04-21T18:42:27.218302+00:00 0 10 1285 725 880 663 880 880 880 776 1660 584 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2346177 2023-04-21T18:42:27.234618+00:00 0 10 1285 725 880 663 880 880 880 776 1660 596 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2509227 2023-04-21T18:42:27.250923+00:00 0 10 1285 725 880 663 880 880 880 776 1660 608 0 0
exp_2023_04_21_10 99901 143 146 1682102547.267244 2023-04-21T18:42:27.267244+00:00 0 10 1285 725 880 663 880 880 880 776 1660 620 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2826056 2023-04-21T18:42:27.282606+00:00 0 10 1285 725 880 663 880 880 880 776 1660 620 0 0
exp_2023_04_21_10 99901 143 146 1682102547.2989466 2023-04-21T18:42:27.298947+00:00 0 10 1285 725 880 663 880 880 880 776 1660 632 0 0
exp_2023_04_21_10 99901 143 146 1682102547.315328 2023-04-21T18:42:27.315328+00:00 0 10 1285 725 880 663 880 880 880 776 1660 644 0 0
exp_2023_04_21_10 99901 143 146 1682102547.331665 2023-04-21T18:42:27.331665+00:00 0 10 1285 725 880 663 880 880 880 776 1660 656 0 0
exp_2023_04_21_10 99901 143 146 1682102547.3480082 2023-04-21T18:42:27.348008+00:00 0 10 1285 725 880 663 880 880 880 776 1660 668 0 0
exp_2023_04_21_10 99901 143 146 1682102547.3643498 2023-04-21T18:42:27.364350+00:00 0 10 1285 725 880 663 880 880 880 776 1660 678 0 0
exp_2023_04_21_10 99901 143 146 1682102547.3807063 2023-04-21T18:42:27.380706+00:00 0 10 1285 725 880 663 880 880 880 776 1660 682 0 0
exp_2023_04_21_10 99901 143 146 1682102547.3970296 2023-04-21T18:42:27.397030+00:00 0 10 1285 725 880 663 880 880 880 776 1660 683 0 0
exp_2023_04_21_10 99901 143 146 1682102547.4133668 2023-04-21T18:42:27.413367+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.4297032 2023-04-21T18:42:27.429703+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.4460468 2023-04-21T18:42:27.446047+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.461452 2023-04-21T18:42:27.461452+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.4777896 2023-04-21T18:42:27.477790+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.494148 2023-04-21T18:42:27.494148+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5094788 2023-04-21T18:42:27.509479+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5258114 2023-04-21T18:42:27.525811+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5421548 2023-04-21T18:42:27.542155+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5575175 2023-04-21T18:42:27.557518+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5738447 2023-04-21T18:42:27.573845+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.5901859 2023-04-21T18:42:27.590186+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6055107 2023-04-21T18:42:27.605511+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6218002 2023-04-21T18:42:27.621800+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6380897 2023-04-21T18:42:27.638090+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6534355 2023-04-21T18:42:27.653435+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6698046 2023-04-21T18:42:27.669805+00:00 0 10 1285 725 880 663 880 880 880 776 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.6861882 2023-04-21T18:42:27.686188+00:00 0 10 1285 725 880 663 880 880 880 777 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.7016127 2023-04-21T18:42:27.701613+00:00 0 10 1285 725 880 663 880 880 880 782 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.7179177 2023-04-21T18:42:27.717918+00:00 0 10 1285 725 880 663 880 880 880 786 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.734223 2023-04-21T18:42:27.734223+00:00 0 10 1285 725 880 667 880 880 880 790 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.7495704 2023-04-21T18:42:27.749570+00:00 0 10 1285 725 880 673 880 880 880 793 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.7659419 2023-04-21T18:42:27.765942+00:00 0 10 1285 725 880 673 880 880 880 799 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.7822564 2023-04-21T18:42:27.782256+00:00 0 10 1285 725 880 676 880 880 880 803 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.79757 2023-04-21T18:42:27.797570+00:00 0 10 1285 725 880 677 880 880 880 812 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.8138893 2023-04-21T18:42:27.813889+00:00 0 10 1285 725 880 677 880 880 880 823 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.830208 2023-04-21T18:42:27.830208+00:00 0 10 1285 725 880 679 880 880 880 841 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.8455217 2023-04-21T18:42:27.845522+00:00 0 10 1285 725 880 678 880 880 880 841 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.8618412 2023-04-21T18:42:27.861841+00:00 0 10 1285 725 880 678 880 880 880 854 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.8782198 2023-04-21T18:42:27.878220+00:00 0 10 1285 725 880 671 880 879 880 872 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.8935847 2023-04-21T18:42:27.893585+00:00 0 10 1285 725 880 661 880 878 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.909929 2023-04-21T18:42:27.909929+00:00 0 10 1285 725 880 661 880 876 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.9262848 2023-04-21T18:42:27.926285+00:00 0 10 1285 725 880 643 880 872 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.9416153 2023-04-21T18:42:27.941615+00:00 0 10 1285 725 880 625 880 869 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.9579358 2023-04-21T18:42:27.957936+00:00 0 10 1285 725 880 615 880 864 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.9742692 2023-04-21T18:42:27.974269+00:00 0 10 1285 725 880 598 880 859 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102547.9895985 2023-04-21T18:42:27.989599+00:00 0 10 1285 725 880 590 880 853 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.0059266 2023-04-21T18:42:28.005927+00:00 0 10 1285 725 880 587 880 847 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.0222018 2023-04-21T18:42:28.022202+00:00 0 10 1285 725 880 583 880 838 880 880 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.0374846 2023-04-21T18:42:28.037485+00:00 0 10 1285 725 880 582 880 831 880 879 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.0537796 2023-04-21T18:42:28.053780+00:00 0 10 1285 725 880 582 880 824 880 877 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.070079 2023-04-21T18:42:28.070079+00:00 0 9 1285 725 880 582 880 817 880 871 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.0863984 2023-04-21T18:42:28.086398+00:00 0 9 1285 725 880 582 880 811 880 862 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.102723 2023-04-21T18:42:28.102723+00:00 0 9 1285 725 880 582 880 805 880 850 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.1191223 2023-04-21T18:42:28.119122+00:00 0 9 1285 725 880 582 880 799 880 837 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.134508 2023-04-21T18:42:28.134508+00:00 0 9 1285 725 880 582 880 795 880 825 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.1508348 2023-04-21T18:42:28.150835+00:00 0 9 1285 725 880 582 880 791 880 816 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.167179 2023-04-21T18:42:28.167179+00:00 0 9 1285 725 880 582 880 789 880 807 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.1825254 2023-04-21T18:42:28.182525+00:00 0 9 1285 725 880 583 880 787 880 797 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.1988618 2023-04-21T18:42:28.198862+00:00 0 9 1285 725 880 589 880 784 880 788 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.2151804 2023-04-21T18:42:28.215180+00:00 0 9 1285 725 880 597 880 784 880 783 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.230482 2023-04-21T18:42:28.230482+00:00 0 9 1285 725 880 607 880 784 880 777 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.2467687 2023-04-21T18:42:28.246769+00:00 0 9 1285 725 880 623 880 784 880 775 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.2630734 2023-04-21T18:42:28.263073+00:00 0 9 1285 725 880 655 880 784 880 769 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.279375 2023-04-21T18:42:28.279375+00:00 0 9 1285 725 880 679 880 784 880 766 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.2957 2023-04-21T18:42:28.295700+00:00 0 9 1285 725 880 695 880 784 880 752 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3119957 2023-04-21T18:42:28.311996+00:00 0 9 1285 725 880 719 880 787 880 746 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3282917 2023-04-21T18:42:28.328292+00:00 0 9 1285 725 880 719 880 790 880 740 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3436062 2023-04-21T18:42:28.343606+00:00 0 9 1285 725 880 719 880 795 880 740 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3599176 2023-04-21T18:42:28.359918+00:00 0 9 1285 725 880 743 880 800 880 731 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3762226 2023-04-21T18:42:28.376223+00:00 0 9 1285 725 880 746 880 805 880 721 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.3915386 2023-04-21T18:42:28.391539+00:00 0 9 1285 725 880 746 880 811 880 714 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.4078333 2023-04-21T18:42:28.407833+00:00 0 9 1285 725 880 746 880 826 880 708 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.4241436 2023-04-21T18:42:28.424144+00:00 0 9 1285 725 880 746 880 826 880 704 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.4394429 2023-04-21T18:42:28.439443+00:00 0 9 1285 725 880 746 880 841 880 699 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.4557447 2023-04-21T18:42:28.455745+00:00 0 9 1285 725 880 746 880 849 880 696 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.472033 2023-04-21T18:42:28.472033+00:00 0 9 1285 725 880 746 880 856 880 693 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.488311 2023-04-21T18:42:28.488311+00:00 0 9 1285 725 880 746 880 856 880 691 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.5035934 2023-04-21T18:42:28.503593+00:00 0 9 1285 725 880 746 880 856 880 691 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.519889 2023-04-21T18:42:28.519889+00:00 0 9 1285 725 880 746 880 870 880 691 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.5361965 2023-04-21T18:42:28.536196+00:00 0 9 1285 725 880 746 880 876 880 691 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.5514925 2023-04-21T18:42:28.551492+00:00 0 9 1285 725 880 746 880 880 880 691 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.5677676 2023-04-21T18:42:28.567768+00:00 0 9 1285 725 880 746 880 880 880 703 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.5840638 2023-04-21T18:42:28.584064+00:00 0 9 1285 725 880 746 880 880 880 712 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.6004312 2023-04-21T18:42:28.600431+00:00 0 9 1285 725 880 746 880 880 880 724 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.6168342 2023-04-21T18:42:28.616834+00:00 0 9 1285 725 880 746 880 880 880 736 1660 684 0 0
exp_2023_04_21_10 99901 143 146 1682102548.6331286 2023-04-21T18:42:28.633129+00:00 0 9 1285 725 880 746 880 880 880 736 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]);