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_1_id = 23

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_10_24_12 23 99905 51 1666643938.4993482 2022-10-24T20:38:58.499348+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5150216 2022-10-24T20:38:58.515022+00:00 1 10 1285 725 880 470 880 869 880 703 1660 645 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5312276 2022-10-24T20:38:58.531228+00:00 1 10 1285 725 880 470 880 869 880 703 1660 657 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5474203 2022-10-24T20:38:58.547420+00:00 1 10 1285 725 880 470 880 869 880 703 1660 669 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5636096 2022-10-24T20:38:58.563610+00:00 1 10 1285 725 880 470 880 869 880 703 1660 678 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5787895 2022-10-24T20:38:58.578789+00:00 1 10 1285 725 880 470 880 869 880 703 1660 682 0 0
exp_2022_10_24_12 23 99905 51 1666643938.5949588 2022-10-24T20:38:58.594959+00:00 1 10 1285 725 880 470 880 640 880 703 1660 683 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6111162 2022-10-24T20:38:58.611116+00:00 1 10 1285 725 880 470 880 640 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6273315 2022-10-24T20:38:58.627331+00:00 1 10 1285 725 880 470 880 641 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6435869 2022-10-24T20:38:58.643587+00:00 1 10 1285 725 880 470 880 641 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6587808 2022-10-24T20:38:58.658781+00:00 1 10 1285 725 880 470 880 645 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6749825 2022-10-24T20:38:58.674983+00:00 1 10 1285 725 880 470 880 652 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.6912005 2022-10-24T20:38:58.691200+00:00 1 10 1285 725 880 470 880 662 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.7074337 2022-10-24T20:38:58.707434+00:00 1 10 1285 725 880 470 880 672 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.7236884 2022-10-24T20:38:58.723688+00:00 1 10 1285 725 880 470 880 681 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.739885 2022-10-24T20:38:58.739885+00:00 1 10 1285 725 880 470 880 691 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.7560725 2022-10-24T20:38:58.756073+00:00 1 10 1285 725 880 470 880 699 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.7722344 2022-10-24T20:38:58.772234+00:00 1 10 1285 725 880 470 880 709 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.7884111 2022-10-24T20:38:58.788411+00:00 1 10 1285 725 880 470 880 716 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.804597 2022-10-24T20:38:58.804597+00:00 1 10 1285 725 880 470 880 720 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.8198125 2022-10-24T20:38:58.819813+00:00 1 10 1285 725 880 470 880 720 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.8360832 2022-10-24T20:38:58.836083+00:00 1 10 1285 725 880 470 880 726 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.852367 2022-10-24T20:38:58.852367+00:00 1 10 1285 725 880 470 880 733 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.868585 2022-10-24T20:38:58.868585+00:00 1 10 1285 725 880 470 880 739 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.8838274 2022-10-24T20:38:58.883827+00:00 1 10 1285 725 880 470 880 742 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9000537 2022-10-24T20:38:58.900054+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9162936 2022-10-24T20:38:58.916294+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9324975 2022-10-24T20:38:58.932498+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9477317 2022-10-24T20:38:58.947732+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9639153 2022-10-24T20:38:58.963915+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9800832 2022-10-24T20:38:58.980083+00:00 1 10 1285 725 880 470 880 743 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643938.9962723 2022-10-24T20:38:58.996272+00:00 1 10 1285 725 880 470 880 742 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.0124686 2022-10-24T20:38:59.012469+00:00 1 10 1285 725 880 470 880 742 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.0286937 2022-10-24T20:38:59.028694+00:00 1 10 1285 725 880 470 880 741 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.0449915 2022-10-24T20:38:59.044991+00:00 1 10 1285 725 880 470 880 741 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.0612488 2022-10-24T20:38:59.061249+00:00 1 10 1285 725 880 470 880 738 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.077469 2022-10-24T20:38:59.077469+00:00 1 10 1285 725 880 470 880 735 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.093729 2022-10-24T20:38:59.093729+00:00 1 10 1285 725 880 470 880 731 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1099937 2022-10-24T20:38:59.109994+00:00 1 10 1285 725 880 470 880 728 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1262228 2022-10-24T20:38:59.126223+00:00 1 10 1285 725 880 470 880 725 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1424632 2022-10-24T20:38:59.142463+00:00 1 10 1285 725 880 470 880 722 880 703 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1586795 2022-10-24T20:38:59.158679+00:00 1 10 1285 725 880 470 880 719 880 879 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1748915 2022-10-24T20:38:59.174891+00:00 1 10 1285 725 880 470 880 716 880 879 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.1911185 2022-10-24T20:38:59.191118+00:00 1 10 1285 725 880 470 880 709 880 879 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.2073443 2022-10-24T20:38:59.207344+00:00 1 10 1285 725 880 470 880 704 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.2235694 2022-10-24T20:38:59.223569+00:00 1 10 1285 725 880 470 880 698 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.2388713 2022-10-24T20:38:59.238871+00:00 1 10 1285 725 880 470 880 697 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.2551785 2022-10-24T20:38:59.255178+00:00 1 10 1285 725 880 470 880 696 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.271529 2022-10-24T20:38:59.271529+00:00 1 10 1285 725 880 470 880 696 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.2868164 2022-10-24T20:38:59.286816+00:00 1 10 1285 725 880 470 880 696 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.303143 2022-10-24T20:38:59.303143+00:00 1 10 1285 725 880 470 880 695 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3194256 2022-10-24T20:38:59.319426+00:00 1 10 1285 725 880 470 880 695 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3356204 2022-10-24T20:38:59.335620+00:00 1 10 1285 725 880 470 880 695 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3507836 2022-10-24T20:38:59.350784+00:00 1 10 1285 725 880 470 880 694 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3669605 2022-10-24T20:38:59.366961+00:00 1 10 1285 725 880 470 880 694 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3831522 2022-10-24T20:38:59.383152+00:00 1 10 1285 725 880 470 880 694 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.3993452 2022-10-24T20:38:59.399345+00:00 1 10 1285 725 880 470 880 691 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4155219 2022-10-24T20:38:59.415522+00:00 1 10 1285 725 880 470 880 683 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4317 2022-10-24T20:38:59.431700+00:00 1 10 1285 725 880 470 880 673 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4478977 2022-10-24T20:38:59.447898+00:00 1 10 1285 725 880 470 880 666 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4641814 2022-10-24T20:38:59.464181+00:00 1 10 1285 725 880 470 880 657 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4804997 2022-10-24T20:38:59.480500+00:00 1 10 1285 725 880 470 880 650 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.4957979 2022-10-24T20:38:59.495798+00:00 1 10 1285 725 880 470 880 650 880 873 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.5120804 2022-10-24T20:38:59.512080+00:00 1 10 1285 725 880 470 880 641 880 867 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.5283706 2022-10-24T20:38:59.528371+00:00 1 9 1285 725 880 470 880 638 880 858 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.5446455 2022-10-24T20:38:59.544646+00:00 1 9 1285 725 880 470 880 635 880 849 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.559846 2022-10-24T20:38:59.559846+00:00 1 9 1285 725 880 470 880 632 880 840 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.5760562 2022-10-24T20:38:59.576056+00:00 1 9 1285 725 880 470 880 630 880 822 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.5922556 2022-10-24T20:38:59.592256+00:00 1 9 1285 725 880 470 880 627 880 803 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.6084907 2022-10-24T20:38:59.608491+00:00 1 9 1285 725 880 470 880 626 880 790 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.6237867 2022-10-24T20:38:59.623787+00:00 1 9 1285 725 880 470 880 625 880 776 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.640046 2022-10-24T20:38:59.640046+00:00 1 9 1285 725 880 470 880 625 880 776 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.6562898 2022-10-24T20:38:59.656290+00:00 1 9 1285 725 880 470 880 625 880 767 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.6725583 2022-10-24T20:38:59.672558+00:00 1 9 1285 725 880 470 880 625 880 761 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.68785 2022-10-24T20:38:59.687850+00:00 1 9 1285 725 880 470 880 624 880 757 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7040992 2022-10-24T20:38:59.704099+00:00 1 9 1285 725 880 470 880 624 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7203376 2022-10-24T20:38:59.720338+00:00 1 9 1285 725 880 470 880 621 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7366006 2022-10-24T20:38:59.736601+00:00 1 9 1285 725 880 470 880 621 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7518585 2022-10-24T20:38:59.751858+00:00 1 9 1285 725 880 470 880 621 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7680745 2022-10-24T20:38:59.768075+00:00 1 9 1285 725 880 470 880 620 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.7843192 2022-10-24T20:38:59.784319+00:00 1 9 1285 725 880 470 880 620 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.8005598 2022-10-24T20:38:59.800560+00:00 1 9 1285 725 880 470 880 620 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.815853 2022-10-24T20:38:59.815853+00:00 1 9 1285 725 880 470 880 620 880 756 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.8320496 2022-10-24T20:38:59.832050+00:00 1 9 1285 725 880 470 880 620 880 762 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.8482478 2022-10-24T20:38:59.848248+00:00 1 9 1285 725 880 470 880 620 880 777 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.864443 2022-10-24T20:38:59.864443+00:00 1 9 1285 725 880 470 880 620 880 801 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.88067 2022-10-24T20:38:59.880670+00:00 1 9 1285 725 880 470 880 620 880 825 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.8959649 2022-10-24T20:38:59.895965+00:00 1 9 1285 725 880 470 880 620 880 841 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.9122574 2022-10-24T20:38:59.912257+00:00 1 9 1285 725 880 470 880 620 880 874 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.9285378 2022-10-24T20:38:59.928538+00:00 1 9 1285 725 880 470 880 620 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.9438336 2022-10-24T20:38:59.943834+00:00 1 9 1285 725 880 470 880 620 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.960136 2022-10-24T20:38:59.960136+00:00 1 9 1285 725 880 470 880 620 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.9763904 2022-10-24T20:38:59.976390+00:00 1 9 1285 725 880 470 880 620 880 880 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643939.9926403 2022-10-24T20:38:59.992640+00:00 1 9 1285 725 880 470 880 621 880 879 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.0078878 2022-10-24T20:39:00.007888+00:00 1 9 1285 725 880 470 880 621 880 870 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.024113 2022-10-24T20:39:00.024113+00:00 1 9 1285 725 880 470 880 621 880 857 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.0403817 2022-10-24T20:39:00.040382+00:00 1 9 1285 725 880 470 880 622 880 821 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.0566769 2022-10-24T20:39:00.056677+00:00 1 9 1285 725 880 470 880 622 880 800 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.0719514 2022-10-24T20:39:00.071951+00:00 1 9 1285 725 880 470 880 622 880 782 1660 684 0 0
exp_2022_10_24_12 23 99905 51 1666643940.0882404 2022-10-24T20:39:00.088240+00:00 1 9 1285 725 880 470 880 622 880 782 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]);