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_1_station
Player 1's station.
player_2_station
Player 2's station.
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_1_score
Player 1's score.
player_2_score
Player 2's score.

where player_1_id = 29

View and edit SQL

Suggested facets: player_1_score, player_2_score, timestamp_iso8601 (date)

Link group_session player_1_id player_2_id player_1_station player_2_station 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_1_score player_2_score
exp_2022_10_18_10 29 46 lion tiger 1666119509.7558606 2022-10-18T18:58:29.755861+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.7724204 2022-10-18T18:58:29.772420+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.788581 2022-10-18T18:58:29.788581+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.8047388 2022-10-18T18:58:29.804739+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.819909 2022-10-18T18:58:29.819909+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.8360667 2022-10-18T18:58:29.836067+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.8522332 2022-10-18T18:58:29.852233+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.8684275 2022-10-18T18:58:29.868428+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.884637 2022-10-18T18:58:29.884637+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.9008722 2022-10-18T18:58:29.900872+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.9170914 2022-10-18T18:58:29.917091+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.93332 2022-10-18T18:58:29.933320+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.9495385 2022-10-18T18:58:29.949538+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.96574 2022-10-18T18:58:29.965740+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.9809623 2022-10-18T18:58:29.980962+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119509.9971745 2022-10-18T18:58:29.997175+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.013373 2022-10-18T18:58:30.013373+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.0295467 2022-10-18T18:58:30.029547+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.045732 2022-10-18T18:58:30.045732+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.060946 2022-10-18T18:58:30.060946+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.077249 2022-10-18T18:58:30.077249+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.0934572 2022-10-18T18:58:30.093457+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.1096451 2022-10-18T18:58:30.109645+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.125807 2022-10-18T18:58:30.125807+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.1409662 2022-10-18T18:58:30.140966+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.157126 2022-10-18T18:58:30.157126+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.173287 2022-10-18T18:58:30.173287+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.189475 2022-10-18T18:58:30.189475+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2057245 2022-10-18T18:58:30.205724+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2209854 2022-10-18T18:58:30.220985+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2372499 2022-10-18T18:58:30.237250+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2535355 2022-10-18T18:58:30.253536+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2698143 2022-10-18T18:58:30.269814+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.2850702 2022-10-18T18:58:30.285070+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.3013449 2022-10-18T18:58:30.301345+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.317615 2022-10-18T18:58:30.317615+00:00 1 10 1285 725 880 769 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.3338897 2022-10-18T18:58:30.333890+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.3501117 2022-10-18T18:58:30.350112+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.36635 2022-10-18T18:58:30.366350+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.3826046 2022-10-18T18:58:30.382605+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.3988745 2022-10-18T18:58:30.398875+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.4151394 2022-10-18T18:58:30.415139+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.4314814 2022-10-18T18:58:30.431481+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.4477324 2022-10-18T18:58:30.447732+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.463043 2022-10-18T18:58:30.463043+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.4793139 2022-10-18T18:58:30.479314+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.4955807 2022-10-18T18:58:30.495581+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.511844 2022-10-18T18:58:30.511844+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.5271442 2022-10-18T18:58:30.527144+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.5434253 2022-10-18T18:58:30.543425+00:00 1 10 1285 725 880 772 1660 850 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.5596862 2022-10-18T18:58:30.559686+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.5749419 2022-10-18T18:58:30.574942+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.5912216 2022-10-18T18:58:30.591222+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.6074848 2022-10-18T18:58:30.607485+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.6237488 2022-10-18T18:58:30.623749+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.6390085 2022-10-18T18:58:30.639009+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.6552672 2022-10-18T18:58:30.655267+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.671542 2022-10-18T18:58:30.671542+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.6878052 2022-10-18T18:58:30.687805+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7030838 2022-10-18T18:58:30.703084+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7193413 2022-10-18T18:58:30.719341+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7355504 2022-10-18T18:58:30.735550+00:00 1 10 1285 725 880 772 1660 693 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7517686 2022-10-18T18:58:30.751769+00:00 1 10 1285 725 880 772 1660 694 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7670174 2022-10-18T18:58:30.767017+00:00 1 10 1285 725 880 772 1660 695 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7832832 2022-10-18T18:58:30.783283+00:00 1 9 1285 725 880 772 1660 696 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.7995377 2022-10-18T18:58:30.799538+00:00 1 9 1285 725 880 772 1660 698 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.815834 2022-10-18T18:58:30.815834+00:00 1 9 1285 725 880 772 1660 704 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.8310564 2022-10-18T18:58:30.831056+00:00 1 9 1285 725 880 772 1660 704 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.8472986 2022-10-18T18:58:30.847299+00:00 1 9 1285 725 880 772 1660 709 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.8635225 2022-10-18T18:58:30.863523+00:00 1 9 1285 725 880 772 1660 714 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.879759 2022-10-18T18:58:30.879759+00:00 1 9 1285 725 880 772 1660 718 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.8950014 2022-10-18T18:58:30.895001+00:00 1 9 1285 725 880 772 1660 722 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.9112713 2022-10-18T18:58:30.911271+00:00 1 9 1285 725 880 772 1660 727 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.9275231 2022-10-18T18:58:30.927523+00:00 1 9 1285 725 880 772 1660 731 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.9437895 2022-10-18T18:58:30.943789+00:00 1 9 1285 725 880 772 1660 734 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.959044 2022-10-18T18:58:30.959044+00:00 1 9 1285 725 880 773 1660 735 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.9752705 2022-10-18T18:58:30.975271+00:00 1 9 1285 725 880 773 1660 737 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119510.9915102 2022-10-18T18:58:30.991510+00:00 1 9 1285 725 880 774 1660 738 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.007789 2022-10-18T18:58:31.007789+00:00 1 9 1285 725 880 775 1660 738 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.023058 2022-10-18T18:58:31.023058+00:00 1 9 1285 725 880 775 1660 738 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.0393236 2022-10-18T18:58:31.039324+00:00 1 9 1285 725 880 775 1660 739 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.055597 2022-10-18T18:58:31.055597+00:00 1 9 1285 725 880 776 1660 740 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.0718641 2022-10-18T18:58:31.071864+00:00 1 9 1285 725 880 779 1660 741 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.087127 2022-10-18T18:58:31.087127+00:00 1 9 1285 725 880 783 1660 743 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1033843 2022-10-18T18:58:31.103384+00:00 1 9 1285 725 880 787 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1196089 2022-10-18T18:58:31.119609+00:00 1 9 1285 725 880 788 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1357982 2022-10-18T18:58:31.135798+00:00 1 9 1285 725 880 795 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1509898 2022-10-18T18:58:31.150990+00:00 1 9 1285 725 880 795 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1671803 2022-10-18T18:58:31.167180+00:00 1 9 1285 725 880 798 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1833415 2022-10-18T18:58:31.183342+00:00 1 9 1285 725 880 802 1660 744 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.1995308 2022-10-18T18:58:31.199531+00:00 1 9 1285 725 880 805 1660 742 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.215698 2022-10-18T18:58:31.215698+00:00 1 9 1285 725 880 806 1660 741 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.231872 2022-10-18T18:58:31.231872+00:00 1 9 1285 725 880 807 1660 740 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.2480342 2022-10-18T18:58:31.248034+00:00 1 9 1285 725 880 807 1660 740 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.2642167 2022-10-18T18:58:31.264217+00:00 1 9 1285 725 880 807 1660 740 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.280384 2022-10-18T18:58:31.280384+00:00 1 9 1285 725 880 807 1660 739 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.2965553 2022-10-18T18:58:31.296555+00:00 1 9 1285 725 880 807 1660 739 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.3127162 2022-10-18T18:58:31.312716+00:00 1 9 1285 725 880 807 1660 738 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.3288834 2022-10-18T18:58:31.328883+00:00 1 9 1285 725 880 807 1660 738 0 0
exp_2022_10_18_10 29 46 lion tiger 1666119511.3450575 2022-10-18T18:58:31.345057+00:00 1 9 1285 725 880 807 1660 738 0 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "ping_pong_competitive_task_observation" (
   [group_session] TEXT REFERENCES [group_session]([id]),
   [player_1_id] INTEGER REFERENCES [participant]([id]),
   [player_2_id] INTEGER REFERENCES [participant]([id]),
   [player_1_station] TEXT REFERENCES [station]([id]),
   [player_2_station] TEXT REFERENCES [station]([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_1_score] INTEGER,
   [player_2_score] INTEGER,
   PRIMARY KEY ([group_session], [player_1_id], [player_2_id], [player_1_station], [player_2_station], [timestamp_unix])
);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_station]
    ON [ping_pong_competitive_task_observation] ([player_2_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_station]
    ON [ping_pong_competitive_task_observation] ([player_1_station]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_2_id]
    ON [ping_pong_competitive_task_observation] ([player_2_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_player_1_id]
    ON [ping_pong_competitive_task_observation] ([player_1_id]);
CREATE INDEX [idx_ping_pong_competitive_task_observation_group_session]
    ON [ping_pong_competitive_task_observation] ([group_session]);