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

View and edit SQL

Suggested facets: task_started, 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_2023_05_01_13 147 99905 lion tiger 1682977000.6006744 2023-05-01T21:36:40.600674+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.6166472 2023-05-01T21:36:40.616647+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.6329193 2023-05-01T21:36:40.632919+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.6492305 2023-05-01T21:36:40.649230+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.6655395 2023-05-01T21:36:40.665540+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.68181 2023-05-01T21:36:40.681810+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.6980958 2023-05-01T21:36:40.698096+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.7133772 2023-05-01T21:36:40.713377+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.729656 2023-05-01T21:36:40.729656+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.745956 2023-05-01T21:36:40.745956+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.762246 2023-05-01T21:36:40.762246+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.7785358 2023-05-01T21:36:40.778536+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.7948213 2023-05-01T21:36:40.794821+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.811212 2023-05-01T21:36:40.811212+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.827545 2023-05-01T21:36:40.827545+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.8438575 2023-05-01T21:36:40.843858+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.8601859 2023-05-01T21:36:40.860186+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.8755124 2023-05-01T21:36:40.875512+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.8918383 2023-05-01T21:36:40.891838+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.9081814 2023-05-01T21:36:40.908181+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.923504 2023-05-01T21:36:40.923504+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.939839 2023-05-01T21:36:40.939839+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.9562306 2023-05-01T21:36:40.956231+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.9725237 2023-05-01T21:36:40.972524+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977000.9888594 2023-05-01T21:36:40.988859+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.0051575 2023-05-01T21:36:41.005157+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.020416 2023-05-01T21:36:41.020416+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.0367043 2023-05-01T21:36:41.036704+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.0530305 2023-05-01T21:36:41.053030+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.0683804 2023-05-01T21:36:41.068380+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.0846884 2023-05-01T21:36:41.084688+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.1010108 2023-05-01T21:36:41.101011+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.1163144 2023-05-01T21:36:41.116314+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.132621 2023-05-01T21:36:41.132621+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.1489232 2023-05-01T21:36:41.148923+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.165217 2023-05-01T21:36:41.165217+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.1814997 2023-05-01T21:36:41.181500+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.1977901 2023-05-01T21:36:41.197790+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.2140949 2023-05-01T21:36:41.214095+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.2294035 2023-05-01T21:36:41.229403+00:00 0 10 1285 725 880 850 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.245699 2023-05-01T21:36:41.245699+00:00 0 10 1285 725 880 719 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.2620025 2023-05-01T21:36:41.262002+00:00 0 10 1285 725 880 717 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.2772996 2023-05-01T21:36:41.277300+00:00 0 10 1285 725 880 710 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.293572 2023-05-01T21:36:41.293572+00:00 0 10 1285 725 880 706 1660 736 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.3098617 2023-05-01T21:36:41.309862+00:00 0 10 1285 725 880 696 1660 842 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.3261912 2023-05-01T21:36:41.326191+00:00 0 10 1285 725 880 696 1660 836 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.341463 2023-05-01T21:36:41.341463+00:00 0 10 1285 725 880 685 1660 830 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.3577635 2023-05-01T21:36:41.357764+00:00 0 10 1285 725 880 679 1660 824 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.3740575 2023-05-01T21:36:41.374058+00:00 0 10 1285 725 880 670 1660 820 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.3892946 2023-05-01T21:36:41.389295+00:00 0 10 1285 725 880 670 1660 819 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4054976 2023-05-01T21:36:41.405498+00:00 0 10 1285 725 880 665 1660 816 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4216924 2023-05-01T21:36:41.421692+00:00 0 10 1285 725 880 662 1660 816 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4378915 2023-05-01T21:36:41.437891+00:00 0 10 1285 725 880 659 1660 816 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4541268 2023-05-01T21:36:41.454127+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4694633 2023-05-01T21:36:41.469463+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.4857435 2023-05-01T21:36:41.485744+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5020237 2023-05-01T21:36:41.502024+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5173306 2023-05-01T21:36:41.517331+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5336118 2023-05-01T21:36:41.533612+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5499065 2023-05-01T21:36:41.549906+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5661817 2023-05-01T21:36:41.566182+00:00 0 10 1285 725 880 658 1660 815 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.5815058 2023-05-01T21:36:41.581506+00:00 0 10 1285 725 880 658 1660 816 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.597754 2023-05-01T21:36:41.597754+00:00 0 10 1285 725 880 658 1660 817 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.614001 2023-05-01T21:36:41.614001+00:00 0 10 1285 725 880 658 1660 824 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.6293063 2023-05-01T21:36:41.629306+00:00 0 9 1285 725 880 658 1660 827 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.645601 2023-05-01T21:36:41.645601+00:00 0 9 1285 725 880 658 1660 828 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.6619198 2023-05-01T21:36:41.661920+00:00 0 9 1285 725 880 658 1660 828 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.6782107 2023-05-01T21:36:41.678211+00:00 0 9 1285 725 880 658 1660 828 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.6934917 2023-05-01T21:36:41.693492+00:00 0 9 1285 725 880 658 1660 828 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.709783 2023-05-01T21:36:41.709783+00:00 0 9 1285 725 880 658 1660 828 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.7260766 2023-05-01T21:36:41.726077+00:00 0 9 1285 725 880 658 1660 825 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.7413738 2023-05-01T21:36:41.741374+00:00 0 9 1285 725 880 658 1660 820 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.7576592 2023-05-01T21:36:41.757659+00:00 0 9 1285 725 880 658 1660 814 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.7739222 2023-05-01T21:36:41.773922+00:00 0 9 1285 725 880 658 1660 808 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.790214 2023-05-01T21:36:41.790214+00:00 0 9 1285 725 880 658 1660 802 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.8054867 2023-05-01T21:36:41.805487+00:00 0 9 1285 725 880 658 1660 798 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.8217766 2023-05-01T21:36:41.821777+00:00 0 9 1285 725 880 658 1660 788 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.838065 2023-05-01T21:36:41.838065+00:00 0 9 1285 725 880 658 1660 781 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.8533976 2023-05-01T21:36:41.853398+00:00 0 9 1285 725 880 658 1660 781 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.869708 2023-05-01T21:36:41.869708+00:00 0 9 1285 725 880 658 1660 768 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.8859897 2023-05-01T21:36:41.885990+00:00 0 9 1285 725 880 658 1660 758 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9022918 2023-05-01T21:36:41.902292+00:00 0 9 1285 725 880 658 1660 748 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9185848 2023-05-01T21:36:41.918585+00:00 0 9 1285 725 880 658 1660 737 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9348884 2023-05-01T21:36:41.934888+00:00 0 9 1285 725 880 658 1660 727 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.951198 2023-05-01T21:36:41.951198+00:00 0 9 1285 725 880 658 1660 719 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9665453 2023-05-01T21:36:41.966545+00:00 0 9 1285 725 880 658 1660 712 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9828475 2023-05-01T21:36:41.982847+00:00 0 9 1285 725 880 658 1660 706 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977001.9991663 2023-05-01T21:36:41.999166+00:00 0 9 1285 725 880 658 1660 703 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.0144758 2023-05-01T21:36:42.014476+00:00 0 9 1285 725 880 658 1660 700 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.030758 2023-05-01T21:36:42.030758+00:00 0 9 1285 725 880 658 1660 696 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.0470655 2023-05-01T21:36:42.047065+00:00 0 9 1285 725 880 658 1660 696 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.0623507 2023-05-01T21:36:42.062351+00:00 0 9 1285 725 880 658 1660 696 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.0787036 2023-05-01T21:36:42.078704+00:00 0 9 1285 725 880 658 1660 684 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.0950544 2023-05-01T21:36:42.095054+00:00 0 9 1285 725 880 658 1660 676 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.1103966 2023-05-01T21:36:42.110397+00:00 0 9 1285 725 880 658 1660 668 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.1267068 2023-05-01T21:36:42.126707+00:00 0 9 1285 725 880 658 1660 661 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.1429837 2023-05-01T21:36:42.142984+00:00 0 9 1285 725 880 658 1660 649 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.159303 2023-05-01T21:36:42.159303+00:00 0 9 1285 725 880 658 1660 640 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.1756155 2023-05-01T21:36:42.175616+00:00 0 9 1285 725 880 658 1660 632 0 0
exp_2023_05_01_13 147 99905 lion tiger 1682977002.1919112 2023-05-01T21:36:42.191911+00:00 0 9 1285 725 880 658 1660 620 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]);