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

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_03_10 96 101 104 1675450381.503618 2023-02-03T18:53:01.503618+00:00 1 10 1285 725 880 572 880 674 880 776 1660 675 0 0
exp_2023_02_03_10 96 101 104 1675450381.5204391 2023-02-03T18:53:01.520439+00:00 1 10 1285 725 880 562 880 730 880 784 1660 633 0 0
exp_2023_02_03_10 96 101 104 1675450381.535683 2023-02-03T18:53:01.535683+00:00 1 10 1285 725 880 562 880 730 880 784 1660 645 0 0
exp_2023_02_03_10 96 101 104 1675450381.5518985 2023-02-03T18:53:01.551898+00:00 1 10 1285 725 880 562 880 730 880 784 1660 645 0 0
exp_2023_02_03_10 96 101 104 1675450381.568094 2023-02-03T18:53:01.568094+00:00 1 10 1285 725 880 562 880 730 880 784 1660 657 0 0
exp_2023_02_03_10 96 101 104 1675450381.5842862 2023-02-03T18:53:01.584286+00:00 1 10 1285 725 880 562 880 730 880 784 1660 669 0 0
exp_2023_02_03_10 96 101 104 1675450381.6004834 2023-02-03T18:53:01.600483+00:00 1 10 1285 725 880 562 880 730 880 784 1660 681 0 0
exp_2023_02_03_10 96 101 104 1675450381.6156762 2023-02-03T18:53:01.615676+00:00 1 10 1285 725 880 562 880 730 880 784 1660 683 0 0
exp_2023_02_03_10 96 101 104 1675450381.6318612 2023-02-03T18:53:01.631861+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.6480472 2023-02-03T18:53:01.648047+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.6642337 2023-02-03T18:53:01.664234+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.680421 2023-02-03T18:53:01.680421+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.6956186 2023-02-03T18:53:01.695619+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.7117867 2023-02-03T18:53:01.711787+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.7279882 2023-02-03T18:53:01.727988+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.7442052 2023-02-03T18:53:01.744205+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.76039 2023-02-03T18:53:01.760390+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.7755907 2023-02-03T18:53:01.775591+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.7917671 2023-02-03T18:53:01.791767+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.807975 2023-02-03T18:53:01.807975+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.824199 2023-02-03T18:53:01.824199+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.8404627 2023-02-03T18:53:01.840463+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.855702 2023-02-03T18:53:01.855702+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.871938 2023-02-03T18:53:01.871938+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.8881772 2023-02-03T18:53:01.888177+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.904384 2023-02-03T18:53:01.904384+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.9196222 2023-02-03T18:53:01.919622+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.9358695 2023-02-03T18:53:01.935869+00:00 1 10 1285 725 880 562 880 730 880 784 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.9521172 2023-02-03T18:53:01.952117+00:00 1 10 1285 725 880 562 880 730 880 783 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.9683976 2023-02-03T18:53:01.968398+00:00 1 10 1285 725 880 562 880 730 880 783 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450381.983701 2023-02-03T18:53:01.983701+00:00 1 10 1285 725 880 562 880 730 880 773 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0000062 2023-02-03T18:53:02.000006+00:00 1 10 1285 725 880 562 880 730 880 769 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0163448 2023-02-03T18:53:02.016345+00:00 1 10 1285 725 880 562 880 730 880 759 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.032597 2023-02-03T18:53:02.032597+00:00 1 10 1285 725 880 562 880 730 880 752 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0488448 2023-02-03T18:53:02.048845+00:00 1 10 1285 725 880 562 880 730 880 745 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0650923 2023-02-03T18:53:02.065092+00:00 1 10 1285 725 880 562 880 730 880 739 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0813107 2023-02-03T18:53:02.081311+00:00 1 10 1285 725 880 562 880 730 880 736 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.0975587 2023-02-03T18:53:02.097559+00:00 1 10 1285 725 880 562 880 730 880 735 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.1138222 2023-02-03T18:53:02.113822+00:00 1 10 1285 725 880 562 880 730 880 735 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.1300907 2023-02-03T18:53:02.130091+00:00 1 10 1285 725 880 562 880 730 880 738 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.146363 2023-02-03T18:53:02.146363+00:00 1 10 1285 725 880 562 880 730 880 748 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.1616325 2023-02-03T18:53:02.161633+00:00 1 10 1285 725 880 562 880 730 880 760 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.177926 2023-02-03T18:53:02.177926+00:00 1 10 1285 725 880 562 880 730 880 772 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.1941996 2023-02-03T18:53:02.194200+00:00 1 10 1285 725 880 562 880 730 880 781 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.2104626 2023-02-03T18:53:02.210463+00:00 1 10 1285 725 880 562 880 730 880 790 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.225745 2023-02-03T18:53:02.225745+00:00 1 10 1285 725 880 562 880 730 880 797 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.2420182 2023-02-03T18:53:02.242018+00:00 1 10 1285 725 880 562 880 730 880 802 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.2582734 2023-02-03T18:53:02.258273+00:00 1 10 1285 725 880 562 880 730 880 802 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.2745156 2023-02-03T18:53:02.274516+00:00 1 10 1285 725 880 562 880 730 880 802 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.2896771 2023-02-03T18:53:02.289677+00:00 1 10 1285 725 880 562 880 730 880 802 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.305875 2023-02-03T18:53:02.305875+00:00 1 10 1285 725 880 562 880 730 880 796 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.3220618 2023-02-03T18:53:02.322062+00:00 1 10 1285 725 880 562 880 730 880 786 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.3382452 2023-02-03T18:53:02.338245+00:00 1 10 1285 725 880 562 880 730 880 775 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.3544405 2023-02-03T18:53:02.354440+00:00 1 10 1285 725 880 562 880 730 880 764 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.369661 2023-02-03T18:53:02.369661+00:00 1 10 1285 725 880 562 880 730 880 753 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.3858342 2023-02-03T18:53:02.385834+00:00 1 10 1285 725 880 562 880 730 880 746 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.4020503 2023-02-03T18:53:02.402050+00:00 1 10 1285 725 880 562 880 730 880 744 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.4182813 2023-02-03T18:53:02.418281+00:00 1 10 1285 725 880 562 880 730 880 744 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.434547 2023-02-03T18:53:02.434547+00:00 1 10 1285 725 880 562 880 730 880 748 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.4498081 2023-02-03T18:53:02.449808+00:00 1 10 1285 725 880 562 880 730 880 761 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.4660628 2023-02-03T18:53:02.466063+00:00 1 10 1285 725 880 562 880 730 880 761 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.4823472 2023-02-03T18:53:02.482347+00:00 1 10 1285 725 880 562 880 730 880 788 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.498632 2023-02-03T18:53:02.498632+00:00 1 10 1285 725 880 562 880 730 880 811 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.514917 2023-02-03T18:53:02.514917+00:00 1 10 1285 725 880 562 880 730 880 838 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.5311966 2023-02-03T18:53:02.531197+00:00 1 9 1285 725 880 562 880 730 880 860 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.5474715 2023-02-03T18:53:02.547472+00:00 1 9 1285 725 880 562 880 730 880 878 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.562749 2023-02-03T18:53:02.562749+00:00 1 9 1285 725 880 562 880 730 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.5790427 2023-02-03T18:53:02.579043+00:00 1 9 1285 725 880 562 880 732 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.5954127 2023-02-03T18:53:02.595413+00:00 1 9 1285 725 880 562 880 735 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.6107228 2023-02-03T18:53:02.610723+00:00 1 9 1285 725 880 562 880 739 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.62705 2023-02-03T18:53:02.627050+00:00 1 9 1285 725 880 562 880 741 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.6433537 2023-02-03T18:53:02.643354+00:00 1 9 1285 725 880 562 880 744 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.6596446 2023-02-03T18:53:02.659645+00:00 1 9 1285 725 880 562 880 745 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.675907 2023-02-03T18:53:02.675907+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.6921964 2023-02-03T18:53:02.692196+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.7084734 2023-02-03T18:53:02.708473+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.7237656 2023-02-03T18:53:02.723766+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.7400272 2023-02-03T18:53:02.740027+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.756247 2023-02-03T18:53:02.756247+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.7724848 2023-02-03T18:53:02.772485+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.787693 2023-02-03T18:53:02.787693+00:00 1 9 1285 725 880 562 880 746 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8038952 2023-02-03T18:53:02.803895+00:00 1 9 1285 725 880 562 880 744 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8200867 2023-02-03T18:53:02.820087+00:00 1 9 1285 725 880 562 880 744 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8362684 2023-02-03T18:53:02.836268+00:00 1 9 1285 725 880 562 880 742 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8524723 2023-02-03T18:53:02.852472+00:00 1 9 1285 725 880 562 880 739 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8677433 2023-02-03T18:53:02.867743+00:00 1 9 1285 725 880 562 880 736 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.8839855 2023-02-03T18:53:02.883986+00:00 1 9 1285 725 880 562 880 733 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9001873 2023-02-03T18:53:02.900187+00:00 1 9 1285 725 880 562 880 732 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.91639 2023-02-03T18:53:02.916390+00:00 1 9 1285 725 880 562 880 730 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9325957 2023-02-03T18:53:02.932596+00:00 1 9 1285 725 880 562 880 730 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9487858 2023-02-03T18:53:02.948786+00:00 1 9 1285 725 880 562 880 728 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9649613 2023-02-03T18:53:02.964961+00:00 1 9 1285 725 880 562 880 727 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9812074 2023-02-03T18:53:02.981207+00:00 1 9 1285 725 880 562 880 724 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450382.9973907 2023-02-03T18:53:02.997391+00:00 1 9 1285 725 880 562 880 722 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0135798 2023-02-03T18:53:03.013580+00:00 1 9 1285 725 880 562 880 715 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0297859 2023-02-03T18:53:03.029786+00:00 1 9 1285 725 880 562 880 715 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0459657 2023-02-03T18:53:03.045966+00:00 1 9 1285 725 880 562 880 710 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0621667 2023-02-03T18:53:03.062167+00:00 1 9 1285 725 880 562 880 704 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0783393 2023-02-03T18:53:03.078339+00:00 1 9 1285 725 880 562 880 699 880 880 1660 684 0 0
exp_2023_02_03_10 96 101 104 1675450383.0944984 2023-02-03T18:53:03.094498+00:00 1 9 1285 725 880 562 880 694 880 880 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]);