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

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_2023_02_06_13 105 110 99909 1675719888.790573 2023-02-06T21:44:48.790573+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_06_13 105 110 99909 1675719888.8065338 2023-02-06T21:44:48.806534+00:00 1 10 1285 725 880 613 880 726 880 868 1660 633 0 0
exp_2023_02_06_13 105 110 99909 1675719888.8227258 2023-02-06T21:44:48.822726+00:00 1 10 1285 725 880 613 880 726 880 868 1660 645 0 0
exp_2023_02_06_13 105 110 99909 1675719888.838981 2023-02-06T21:44:48.838981+00:00 1 10 1285 725 880 613 880 726 880 868 1660 657 0 0
exp_2023_02_06_13 105 110 99909 1675719888.8551872 2023-02-06T21:44:48.855187+00:00 1 10 1285 725 880 613 880 726 880 868 1660 669 0 0
exp_2023_02_06_13 105 110 99909 1675719888.8714185 2023-02-06T21:44:48.871418+00:00 1 10 1285 725 880 613 880 726 880 868 1660 678 0 0
exp_2023_02_06_13 105 110 99909 1675719888.8875895 2023-02-06T21:44:48.887589+00:00 1 10 1285 725 880 613 880 726 880 868 1660 682 0 0
exp_2023_02_06_13 105 110 99909 1675719888.902759 2023-02-06T21:44:48.902759+00:00 1 10 1285 725 880 613 880 626 880 868 1660 683 0 0
exp_2023_02_06_13 105 110 99909 1675719888.9189432 2023-02-06T21:44:48.918943+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719888.935133 2023-02-06T21:44:48.935133+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719888.9513125 2023-02-06T21:44:48.951313+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719888.9674976 2023-02-06T21:44:48.967498+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719888.983701 2023-02-06T21:44:48.983701+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719888.9999094 2023-02-06T21:44:48.999909+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0161073 2023-02-06T21:44:49.016107+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0322995 2023-02-06T21:44:49.032300+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0484767 2023-02-06T21:44:49.048477+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0646617 2023-02-06T21:44:49.064662+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0798979 2023-02-06T21:44:49.079898+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.0960777 2023-02-06T21:44:49.096078+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.1122553 2023-02-06T21:44:49.112255+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.1284237 2023-02-06T21:44:49.128424+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.1446083 2023-02-06T21:44:49.144608+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.1598005 2023-02-06T21:44:49.159801+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.1759837 2023-02-06T21:44:49.175984+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.192165 2023-02-06T21:44:49.192165+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.2083533 2023-02-06T21:44:49.208353+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.22456 2023-02-06T21:44:49.224560+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.2407563 2023-02-06T21:44:49.240756+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.2569566 2023-02-06T21:44:49.256957+00:00 1 10 1285 725 880 613 880 626 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.2731378 2023-02-06T21:44:49.273138+00:00 1 10 1285 725 880 613 880 624 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.2893255 2023-02-06T21:44:49.289325+00:00 1 10 1285 725 880 613 880 622 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.3055143 2023-02-06T21:44:49.305514+00:00 1 10 1285 725 880 613 880 619 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.321702 2023-02-06T21:44:49.321702+00:00 1 10 1285 725 880 613 880 616 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.3368862 2023-02-06T21:44:49.336886+00:00 1 10 1285 725 880 613 880 611 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.35308 2023-02-06T21:44:49.353080+00:00 1 10 1285 725 880 613 880 606 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.369258 2023-02-06T21:44:49.369258+00:00 1 10 1285 725 880 613 880 600 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.385456 2023-02-06T21:44:49.385456+00:00 1 10 1285 725 880 613 880 594 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4016569 2023-02-06T21:44:49.401657+00:00 1 10 1285 725 880 613 880 587 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4168332 2023-02-06T21:44:49.416833+00:00 1 10 1285 725 880 613 880 582 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4330158 2023-02-06T21:44:49.433016+00:00 1 10 1285 725 880 613 880 579 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4491878 2023-02-06T21:44:49.449188+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4653745 2023-02-06T21:44:49.465374+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.481546 2023-02-06T21:44:49.481546+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.4977324 2023-02-06T21:44:49.497732+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5139234 2023-02-06T21:44:49.513923+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5301218 2023-02-06T21:44:49.530122+00:00 1 10 1285 725 880 613 880 576 880 868 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5463097 2023-02-06T21:44:49.546310+00:00 1 10 1285 725 880 613 880 576 880 867 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5625017 2023-02-06T21:44:49.562502+00:00 1 10 1285 725 880 613 880 577 880 866 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5786777 2023-02-06T21:44:49.578678+00:00 1 10 1285 725 880 613 880 582 880 865 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.5938485 2023-02-06T21:44:49.593848+00:00 1 10 1285 725 880 613 880 589 880 862 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.610026 2023-02-06T21:44:49.610026+00:00 1 10 1285 725 880 613 880 606 880 860 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.6261964 2023-02-06T21:44:49.626196+00:00 1 10 1285 725 880 582 880 622 880 859 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.6423726 2023-02-06T21:44:49.642373+00:00 1 10 1285 725 880 582 880 630 880 857 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.6585605 2023-02-06T21:44:49.658561+00:00 1 10 1285 725 880 582 880 636 880 857 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.6747222 2023-02-06T21:44:49.674722+00:00 1 10 1285 725 880 582 880 636 880 854 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.6909041 2023-02-06T21:44:49.690904+00:00 1 10 1285 725 880 582 880 642 880 851 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.7070954 2023-02-06T21:44:49.707095+00:00 1 10 1285 725 880 582 880 646 880 847 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.723272 2023-02-06T21:44:49.723272+00:00 1 10 1285 725 880 582 880 647 880 843 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.7394714 2023-02-06T21:44:49.739471+00:00 1 10 1285 725 880 582 880 647 880 838 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.7556417 2023-02-06T21:44:49.755642+00:00 1 10 1285 725 880 582 880 647 880 834 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.7708297 2023-02-06T21:44:49.770830+00:00 1 10 1285 725 880 581 880 647 880 830 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.787009 2023-02-06T21:44:49.787009+00:00 1 10 1285 725 880 578 880 647 880 827 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8031917 2023-02-06T21:44:49.803192+00:00 1 10 1285 725 880 575 880 642 880 827 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8193865 2023-02-06T21:44:49.819386+00:00 1 9 1285 725 880 575 880 633 880 823 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8355796 2023-02-06T21:44:49.835580+00:00 1 9 1285 725 880 572 880 620 880 821 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8517559 2023-02-06T21:44:49.851756+00:00 1 9 1285 725 880 572 880 601 880 820 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8679388 2023-02-06T21:44:49.867939+00:00 1 9 1285 725 880 571 880 588 880 819 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.8841252 2023-02-06T21:44:49.884125+00:00 1 9 1285 725 880 570 880 576 880 818 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9002955 2023-02-06T21:44:49.900295+00:00 1 9 1285 725 880 567 880 560 880 816 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9164917 2023-02-06T21:44:49.916492+00:00 1 9 1285 725 880 564 880 555 880 816 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9327233 2023-02-06T21:44:49.932723+00:00 1 9 1285 725 880 563 880 553 880 816 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9479642 2023-02-06T21:44:49.947964+00:00 1 9 1285 725 880 562 880 548 880 821 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9641922 2023-02-06T21:44:49.964192+00:00 1 9 1285 725 880 561 880 545 880 821 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9803662 2023-02-06T21:44:49.980366+00:00 1 9 1285 725 880 560 880 542 880 830 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719889.9965608 2023-02-06T21:44:49.996561+00:00 1 9 1285 725 880 559 880 538 880 836 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.012741 2023-02-06T21:44:50.012741+00:00 1 9 1285 725 880 559 880 538 880 844 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.0289245 2023-02-06T21:44:50.028924+00:00 1 9 1285 725 880 559 880 529 880 854 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.0451097 2023-02-06T21:44:50.045110+00:00 1 9 1285 725 880 559 880 525 880 864 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.0612862 2023-02-06T21:44:50.061286+00:00 1 9 1285 725 880 559 880 521 880 876 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.0774639 2023-02-06T21:44:50.077464+00:00 1 9 1285 725 880 558 880 519 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.0936534 2023-02-06T21:44:50.093653+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.1088758 2023-02-06T21:44:50.108876+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.1250818 2023-02-06T21:44:50.125082+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.141337 2023-02-06T21:44:50.141337+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.1575618 2023-02-06T21:44:50.157562+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.1738114 2023-02-06T21:44:50.173811+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.1900473 2023-02-06T21:44:50.190047+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2062957 2023-02-06T21:44:50.206296+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2225804 2023-02-06T21:44:50.222580+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2378192 2023-02-06T21:44:50.237819+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2540364 2023-02-06T21:44:50.254036+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2702708 2023-02-06T21:44:50.270271+00:00 1 9 1285 725 880 558 880 518 880 880 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.2864969 2023-02-06T21:44:50.286497+00:00 1 9 1285 725 880 558 880 518 880 876 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.3027787 2023-02-06T21:44:50.302779+00:00 1 9 1285 725 880 558 880 517 880 852 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.3190506 2023-02-06T21:44:50.319051+00:00 1 9 1285 725 880 558 880 516 880 832 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.3353162 2023-02-06T21:44:50.335316+00:00 1 9 1285 725 880 558 880 513 880 815 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.3515735 2023-02-06T21:44:50.351573+00:00 1 9 1285 725 880 557 880 510 880 799 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.3668277 2023-02-06T21:44:50.366828+00:00 1 9 1285 725 880 557 880 506 880 799 1660 684 0 0
exp_2023_02_06_13 105 110 99909 1675719890.383057 2023-02-06T21:44:50.383057+00:00 1 9 1285 725 880 557 880 501 880 784 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]);