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

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_18_10 35 56 77 1668797529.9932888 2022-11-18T18:52:09.993289+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2022_11_18_10 35 56 77 1668797530.0088859 2022-11-18T18:52:10.008886+00:00 1 10 1285 725 880 470 880 519 880 470 1660 633 0 0
exp_2022_11_18_10 35 56 77 1668797530.0251362 2022-11-18T18:52:10.025136+00:00 1 10 1285 725 880 470 880 519 880 470 1660 645 0 0
exp_2022_11_18_10 35 56 77 1668797530.041384 2022-11-18T18:52:10.041384+00:00 1 10 1285 725 880 470 880 519 880 470 1660 657 0 0
exp_2022_11_18_10 35 56 77 1668797530.057579 2022-11-18T18:52:10.057579+00:00 1 10 1285 725 880 470 880 519 880 470 1660 669 0 0
exp_2022_11_18_10 35 56 77 1668797530.073752 2022-11-18T18:52:10.073752+00:00 1 10 1285 725 880 470 880 519 880 470 1660 678 0 0
exp_2022_11_18_10 35 56 77 1668797530.0899239 2022-11-18T18:52:10.089924+00:00 1 10 1285 725 880 470 880 519 880 470 1660 682 0 0
exp_2022_11_18_10 35 56 77 1668797530.1061149 2022-11-18T18:52:10.106115+00:00 1 10 1285 725 880 470 880 519 880 470 1660 682 0 0
exp_2022_11_18_10 35 56 77 1668797530.122301 2022-11-18T18:52:10.122301+00:00 1 10 1285 725 880 470 880 519 880 470 1660 683 0 0
exp_2022_11_18_10 35 56 77 1668797530.13849 2022-11-18T18:52:10.138490+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.1536865 2022-11-18T18:52:10.153687+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.1699235 2022-11-18T18:52:10.169924+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.186153 2022-11-18T18:52:10.186153+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2023773 2022-11-18T18:52:10.202377+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2186143 2022-11-18T18:52:10.218614+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2348616 2022-11-18T18:52:10.234862+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2510998 2022-11-18T18:52:10.251100+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.267349 2022-11-18T18:52:10.267349+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2835581 2022-11-18T18:52:10.283558+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.2987833 2022-11-18T18:52:10.298783+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.3150167 2022-11-18T18:52:10.315017+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.3312929 2022-11-18T18:52:10.331293+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.347549 2022-11-18T18:52:10.347549+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.362806 2022-11-18T18:52:10.362806+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.3790262 2022-11-18T18:52:10.379026+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.3952293 2022-11-18T18:52:10.395229+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.4114318 2022-11-18T18:52:10.411432+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.426652 2022-11-18T18:52:10.426652+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.4428751 2022-11-18T18:52:10.442875+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.4591005 2022-11-18T18:52:10.459100+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.47528 2022-11-18T18:52:10.475280+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.4914725 2022-11-18T18:52:10.491472+00:00 1 10 1285 725 880 470 880 519 880 470 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5066996 2022-11-18T18:52:10.506700+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5229032 2022-11-18T18:52:10.522903+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5391078 2022-11-18T18:52:10.539108+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5552971 2022-11-18T18:52:10.555297+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5715165 2022-11-18T18:52:10.571517+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.5867257 2022-11-18T18:52:10.586726+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.602935 2022-11-18T18:52:10.602935+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6191328 2022-11-18T18:52:10.619133+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6353214 2022-11-18T18:52:10.635321+00:00 1 10 1285 725 880 470 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6515667 2022-11-18T18:52:10.651567+00:00 1 10 1285 725 880 724 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6668828 2022-11-18T18:52:10.666883+00:00 1 10 1285 725 880 721 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6831665 2022-11-18T18:52:10.683167+00:00 1 10 1285 725 880 720 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.6993947 2022-11-18T18:52:10.699395+00:00 1 10 1285 725 880 715 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7156017 2022-11-18T18:52:10.715602+00:00 1 10 1285 725 880 715 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7317946 2022-11-18T18:52:10.731795+00:00 1 10 1285 725 880 711 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7479894 2022-11-18T18:52:10.747989+00:00 1 10 1285 725 880 710 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7642066 2022-11-18T18:52:10.764207+00:00 1 10 1285 725 880 709 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7804043 2022-11-18T18:52:10.780404+00:00 1 10 1285 725 880 709 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.7965899 2022-11-18T18:52:10.796590+00:00 1 10 1285 725 880 709 880 519 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.8128 2022-11-18T18:52:10.812800+00:00 1 10 1285 725 880 709 880 648 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.8289983 2022-11-18T18:52:10.828998+00:00 1 10 1285 725 880 709 880 652 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.845214 2022-11-18T18:52:10.845214+00:00 1 10 1285 725 880 711 880 661 880 880 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.8614287 2022-11-18T18:52:10.861429+00:00 1 10 1285 725 880 720 880 668 880 876 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.8776367 2022-11-18T18:52:10.877637+00:00 1 10 1285 725 880 729 880 672 880 869 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.8938437 2022-11-18T18:52:10.893844+00:00 1 10 1285 725 880 735 880 676 880 862 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.9100542 2022-11-18T18:52:10.910054+00:00 1 10 1285 725 880 751 880 677 880 856 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.926263 2022-11-18T18:52:10.926263+00:00 1 10 1285 725 880 751 880 678 880 853 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.9424603 2022-11-18T18:52:10.942460+00:00 1 10 1285 725 880 755 880 678 880 852 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.9576476 2022-11-18T18:52:10.957648+00:00 1 10 1285 725 880 759 880 678 880 851 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.973863 2022-11-18T18:52:10.973863+00:00 1 10 1285 725 880 760 880 678 880 845 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797530.9901211 2022-11-18T18:52:10.990121+00:00 1 10 1285 725 880 760 880 678 880 844 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0064228 2022-11-18T18:52:11.006423+00:00 1 10 1285 725 880 760 880 678 880 844 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0216737 2022-11-18T18:52:11.021674+00:00 1 9 1285 725 880 760 880 678 880 840 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0378659 2022-11-18T18:52:11.037866+00:00 1 9 1285 725 880 760 880 678 880 839 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0540552 2022-11-18T18:52:11.054055+00:00 1 9 1285 725 880 760 880 678 880 839 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0702612 2022-11-18T18:52:11.070261+00:00 1 9 1285 725 880 760 880 678 880 839 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.0864394 2022-11-18T18:52:11.086439+00:00 1 9 1285 725 880 760 880 678 880 838 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.1026275 2022-11-18T18:52:11.102628+00:00 1 9 1285 725 880 757 880 678 880 835 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.1188679 2022-11-18T18:52:11.118868+00:00 1 9 1285 725 880 754 880 678 880 829 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.1351106 2022-11-18T18:52:11.135111+00:00 1 9 1285 725 880 750 880 678 880 825 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.151321 2022-11-18T18:52:11.151321+00:00 1 9 1285 725 880 750 880 678 880 823 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.167541 2022-11-18T18:52:11.167541+00:00 1 9 1285 725 880 750 880 678 880 823 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.1827543 2022-11-18T18:52:11.182754+00:00 1 9 1285 725 880 747 880 678 880 821 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.198959 2022-11-18T18:52:11.198959+00:00 1 9 1285 725 880 746 880 678 880 820 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.2151494 2022-11-18T18:52:11.215149+00:00 1 9 1285 725 880 742 880 677 880 819 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.231341 2022-11-18T18:52:11.231341+00:00 1 9 1285 725 880 739 880 677 880 818 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.2475443 2022-11-18T18:52:11.247544+00:00 1 9 1285 725 880 739 880 676 880 818 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.2627463 2022-11-18T18:52:11.262746+00:00 1 9 1285 725 880 739 880 675 880 815 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.2789521 2022-11-18T18:52:11.278952+00:00 1 9 1285 725 880 736 880 673 880 811 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.2951567 2022-11-18T18:52:11.295157+00:00 1 9 1285 725 880 734 880 671 880 807 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.3113616 2022-11-18T18:52:11.311362+00:00 1 9 1285 725 880 734 880 669 880 807 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.3275442 2022-11-18T18:52:11.327544+00:00 1 9 1285 725 880 731 880 666 880 804 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.34278 2022-11-18T18:52:11.342780+00:00 1 9 1285 725 880 726 880 661 880 803 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.358992 2022-11-18T18:52:11.358992+00:00 1 9 1285 725 880 725 880 661 880 802 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.375211 2022-11-18T18:52:11.375211+00:00 1 9 1285 725 880 724 880 658 880 801 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.391417 2022-11-18T18:52:11.391417+00:00 1 9 1285 725 880 724 880 655 880 799 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.4076538 2022-11-18T18:52:11.407654+00:00 1 9 1285 725 880 724 880 652 880 791 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.423897 2022-11-18T18:52:11.423897+00:00 1 9 1285 725 880 724 880 648 880 787 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.4401307 2022-11-18T18:52:11.440131+00:00 1 9 1285 725 880 724 880 644 880 787 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.4563522 2022-11-18T18:52:11.456352+00:00 1 9 1285 725 880 724 880 641 880 781 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.4725926 2022-11-18T18:52:11.472593+00:00 1 9 1285 725 880 724 880 636 880 775 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.4878926 2022-11-18T18:52:11.487893+00:00 1 9 1285 725 880 724 880 629 880 768 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.5041535 2022-11-18T18:52:11.504153+00:00 1 9 1285 725 880 724 880 622 880 761 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.520388 2022-11-18T18:52:11.520388+00:00 1 9 1285 725 880 724 880 622 880 748 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.53665 2022-11-18T18:52:11.536650+00:00 1 9 1285 725 880 724 880 618 880 736 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.5529187 2022-11-18T18:52:11.552919+00:00 1 9 1285 725 880 724 880 615 880 727 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.569165 2022-11-18T18:52:11.569165+00:00 1 9 1285 725 880 724 880 613 880 720 1660 684 0 0
exp_2022_11_18_10 35 56 77 1668797531.5854077 2022-11-18T18:52:11.585408+00:00 1 9 1285 725 880 724 880 612 880 714 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]);