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_3_id = 114

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_16_14 106 107 114 1676587434.8619192 2023-02-16T22:43:54.861919+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_16_14 106 107 114 1676587434.8777308 2023-02-16T22:43:54.877731+00:00 1 10 1285 725 880 685 880 554 880 470 1660 633 0 0
exp_2023_02_16_14 106 107 114 1676587434.8939013 2023-02-16T22:43:54.893901+00:00 1 10 1285 725 880 685 880 554 880 470 1660 645 0 0
exp_2023_02_16_14 106 107 114 1676587434.9100695 2023-02-16T22:43:54.910069+00:00 1 10 1285 725 880 685 880 554 880 470 1660 657 0 0
exp_2023_02_16_14 106 107 114 1676587434.925251 2023-02-16T22:43:54.925251+00:00 1 10 1285 725 880 685 880 554 880 470 1660 669 0 0
exp_2023_02_16_14 106 107 114 1676587434.941409 2023-02-16T22:43:54.941409+00:00 1 10 1285 725 880 685 880 554 880 470 1660 678 0 0
exp_2023_02_16_14 106 107 114 1676587434.9575918 2023-02-16T22:43:54.957592+00:00 1 10 1285 725 880 685 880 554 880 470 1660 682 0 0
exp_2023_02_16_14 106 107 114 1676587434.9737868 2023-02-16T22:43:54.973787+00:00 1 10 1285 725 880 685 880 554 880 470 1660 683 0 0
exp_2023_02_16_14 106 107 114 1676587434.9900289 2023-02-16T22:43:54.990029+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.0051877 2023-02-16T22:43:55.005188+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.0213668 2023-02-16T22:43:55.021367+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.0375242 2023-02-16T22:43:55.037524+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.0537062 2023-02-16T22:43:55.053706+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.069888 2023-02-16T22:43:55.069888+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.0860505 2023-02-16T22:43:55.086051+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.101231 2023-02-16T22:43:55.101231+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.1173813 2023-02-16T22:43:55.117381+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.133569 2023-02-16T22:43:55.133569+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.1498094 2023-02-16T22:43:55.149809+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.165999 2023-02-16T22:43:55.165999+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.1811817 2023-02-16T22:43:55.181182+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.1973612 2023-02-16T22:43:55.197361+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.2135427 2023-02-16T22:43:55.213543+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.2297235 2023-02-16T22:43:55.229723+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.24591 2023-02-16T22:43:55.245910+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.262093 2023-02-16T22:43:55.262093+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.277274 2023-02-16T22:43:55.277274+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.293459 2023-02-16T22:43:55.293459+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.3096235 2023-02-16T22:43:55.309623+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.325811 2023-02-16T22:43:55.325811+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.3420112 2023-02-16T22:43:55.342011+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.3571677 2023-02-16T22:43:55.357168+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.3733506 2023-02-16T22:43:55.373351+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.3895333 2023-02-16T22:43:55.389533+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.405715 2023-02-16T22:43:55.405715+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.4218967 2023-02-16T22:43:55.421897+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.4380774 2023-02-16T22:43:55.438077+00:00 1 10 1285 725 880 685 880 554 880 470 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.4532602 2023-02-16T22:43:55.453260+00:00 1 10 1285 725 880 685 880 554 880 475 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.469451 2023-02-16T22:43:55.469451+00:00 1 10 1285 725 880 685 880 554 880 477 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.4856324 2023-02-16T22:43:55.485632+00:00 1 10 1285 725 880 685 880 554 880 484 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.5018148 2023-02-16T22:43:55.501815+00:00 1 10 1285 725 880 685 880 554 880 493 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.5179956 2023-02-16T22:43:55.517996+00:00 1 10 1285 725 880 685 880 554 880 499 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.533175 2023-02-16T22:43:55.533175+00:00 1 10 1285 725 880 685 880 554 880 508 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.549355 2023-02-16T22:43:55.549355+00:00 1 10 1285 725 880 685 880 554 880 510 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.5655365 2023-02-16T22:43:55.565536+00:00 1 10 1285 725 880 685 880 554 880 519 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.5817187 2023-02-16T22:43:55.581719+00:00 1 10 1285 725 880 685 880 554 880 523 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.5979047 2023-02-16T22:43:55.597905+00:00 1 10 1285 725 880 685 880 554 880 528 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.6140625 2023-02-16T22:43:55.614063+00:00 1 10 1285 725 880 685 880 554 880 528 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.6292222 2023-02-16T22:43:55.629222+00:00 1 10 1285 725 880 470 880 554 880 538 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.6454031 2023-02-16T22:43:55.645403+00:00 1 10 1285 725 880 470 880 554 880 541 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.6615832 2023-02-16T22:43:55.661583+00:00 1 10 1285 725 880 470 880 554 880 547 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.677765 2023-02-16T22:43:55.677765+00:00 1 10 1285 725 880 470 880 554 880 557 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.693943 2023-02-16T22:43:55.693943+00:00 1 10 1285 725 880 473 880 554 880 564 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.7101183 2023-02-16T22:43:55.710118+00:00 1 10 1285 725 880 478 880 554 880 582 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.726291 2023-02-16T22:43:55.726291+00:00 1 10 1285 725 880 484 880 554 880 589 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.7424634 2023-02-16T22:43:55.742463+00:00 1 10 1285 725 880 499 880 554 880 595 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.7586386 2023-02-16T22:43:55.758639+00:00 1 10 1285 725 880 513 880 554 880 595 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.7747998 2023-02-16T22:43:55.774800+00:00 1 10 1285 725 880 534 880 554 880 598 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.7909768 2023-02-16T22:43:55.790977+00:00 1 10 1285 725 880 534 880 554 880 598 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.8071475 2023-02-16T22:43:55.807148+00:00 1 10 1285 725 880 567 880 554 880 598 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.8233268 2023-02-16T22:43:55.823327+00:00 1 10 1285 725 880 582 880 554 880 598 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.8395135 2023-02-16T22:43:55.839514+00:00 1 10 1285 725 880 601 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.8556998 2023-02-16T22:43:55.855700+00:00 1 10 1285 725 880 620 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.8718565 2023-02-16T22:43:55.871856+00:00 1 10 1285 725 880 639 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.888011 2023-02-16T22:43:55.888011+00:00 1 9 1285 725 880 653 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9031923 2023-02-16T22:43:55.903192+00:00 1 9 1285 725 880 669 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9193778 2023-02-16T22:43:55.919378+00:00 1 9 1285 725 880 676 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9355817 2023-02-16T22:43:55.935582+00:00 1 9 1285 725 880 676 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9517627 2023-02-16T22:43:55.951763+00:00 1 9 1285 725 880 676 880 554 880 597 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9679449 2023-02-16T22:43:55.967945+00:00 1 9 1285 725 880 676 880 554 880 596 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587435.9841275 2023-02-16T22:43:55.984128+00:00 1 9 1285 725 880 676 880 554 880 593 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0003088 2023-02-16T22:43:56.000309+00:00 1 9 1285 725 880 676 880 554 880 589 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0164733 2023-02-16T22:43:56.016473+00:00 1 9 1285 725 880 676 880 554 880 588 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0326545 2023-02-16T22:43:56.032655+00:00 1 9 1285 725 880 676 880 554 880 588 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.048836 2023-02-16T22:43:56.048836+00:00 1 9 1285 725 880 676 880 554 880 588 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0650182 2023-02-16T22:43:56.065018+00:00 1 9 1285 725 880 676 880 554 880 588 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0802033 2023-02-16T22:43:56.080203+00:00 1 9 1285 725 880 676 880 554 880 588 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.0963855 2023-02-16T22:43:56.096385+00:00 1 9 1285 725 880 676 880 554 880 589 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.1125524 2023-02-16T22:43:56.112552+00:00 1 9 1285 725 880 676 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.1287222 2023-02-16T22:43:56.128722+00:00 1 9 1285 725 880 676 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.1449132 2023-02-16T22:43:56.144913+00:00 1 9 1285 725 880 663 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.161105 2023-02-16T22:43:56.161105+00:00 1 9 1285 725 880 650 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.1762867 2023-02-16T22:43:56.176287+00:00 1 9 1285 725 880 637 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.1924717 2023-02-16T22:43:56.192472+00:00 1 9 1285 725 880 626 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.2086859 2023-02-16T22:43:56.208686+00:00 1 9 1285 725 880 626 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.2248673 2023-02-16T22:43:56.224867+00:00 1 9 1285 725 880 626 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.241049 2023-02-16T22:43:56.241049+00:00 1 9 1285 725 880 626 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.256233 2023-02-16T22:43:56.256233+00:00 1 9 1285 725 880 628 880 554 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.27241 2023-02-16T22:43:56.272410+00:00 1 9 1285 725 880 628 880 556 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.2886002 2023-02-16T22:43:56.288600+00:00 1 9 1285 725 880 673 880 557 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.3047752 2023-02-16T22:43:56.304775+00:00 1 9 1285 725 880 703 880 557 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.3209674 2023-02-16T22:43:56.320967+00:00 1 9 1285 725 880 738 880 556 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.337169 2023-02-16T22:43:56.337169+00:00 1 9 1285 725 880 765 880 555 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.3533123 2023-02-16T22:43:56.353312+00:00 1 9 1285 725 880 802 880 549 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.3694956 2023-02-16T22:43:56.369496+00:00 1 9 1285 725 880 802 880 544 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.385691 2023-02-16T22:43:56.385691+00:00 1 9 1285 725 880 841 880 539 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.4018815 2023-02-16T22:43:56.401881+00:00 1 9 1285 725 880 880 880 535 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.4180596 2023-02-16T22:43:56.418060+00:00 1 9 1285 725 880 880 880 532 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.4332402 2023-02-16T22:43:56.433240+00:00 1 9 1285 725 880 880 880 531 880 592 1660 684 0 0
exp_2023_02_16_14 106 107 114 1676587436.4494014 2023-02-16T22:43:56.449401+00:00 1 9 1285 725 880 880 880 531 880 592 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]);