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_2_id = 64

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_31_10 99907 64 lion tiger 1667242292.408439 2022-10-31T18:51:32.408439+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.424263 2022-10-31T18:51:32.424263+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.4404414 2022-10-31T18:51:32.440441+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.456615 2022-10-31T18:51:32.456615+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.4727914 2022-10-31T18:51:32.472791+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.4889696 2022-10-31T18:51:32.488970+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.5051892 2022-10-31T18:51:32.505189+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.521395 2022-10-31T18:51:32.521395+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.5375621 2022-10-31T18:51:32.537562+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.5537286 2022-10-31T18:51:32.553729+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.5698924 2022-10-31T18:51:32.569892+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.586052 2022-10-31T18:51:32.586052+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6022198 2022-10-31T18:51:32.602220+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6183846 2022-10-31T18:51:32.618385+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6345556 2022-10-31T18:51:32.634556+00:00 1 10 1285 725 880 829 1660 850 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6507335 2022-10-31T18:51:32.650733+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6668942 2022-10-31T18:51:32.666894+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6830757 2022-10-31T18:51:32.683076+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.6982522 2022-10-31T18:51:32.698252+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.7144108 2022-10-31T18:51:32.714411+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.7305653 2022-10-31T18:51:32.730565+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.746721 2022-10-31T18:51:32.746721+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.762884 2022-10-31T18:51:32.762884+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.7790425 2022-10-31T18:51:32.779042+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.7952025 2022-10-31T18:51:32.795202+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.8113701 2022-10-31T18:51:32.811370+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.8275733 2022-10-31T18:51:32.827573+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.8437505 2022-10-31T18:51:32.843750+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.8599281 2022-10-31T18:51:32.859928+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.8761725 2022-10-31T18:51:32.876173+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.892367 2022-10-31T18:51:32.892367+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.9085994 2022-10-31T18:51:32.908599+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.9247992 2022-10-31T18:51:32.924799+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.9410143 2022-10-31T18:51:32.941014+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.957191 2022-10-31T18:51:32.957191+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.973359 2022-10-31T18:51:32.973359+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242292.9895372 2022-10-31T18:51:32.989537+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.005721 2022-10-31T18:51:33.005721+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.0219002 2022-10-31T18:51:33.021900+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.038079 2022-10-31T18:51:33.038079+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.0533154 2022-10-31T18:51:33.053315+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.0694907 2022-10-31T18:51:33.069491+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.0856655 2022-10-31T18:51:33.085665+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.1018329 2022-10-31T18:51:33.101833+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.118021 2022-10-31T18:51:33.118021+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.134197 2022-10-31T18:51:33.134197+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.1503806 2022-10-31T18:51:33.150381+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.1665552 2022-10-31T18:51:33.166555+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.1826787 2022-10-31T18:51:33.182679+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.198838 2022-10-31T18:51:33.198838+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.214992 2022-10-31T18:51:33.214992+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.2311168 2022-10-31T18:51:33.231117+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.2462428 2022-10-31T18:51:33.246243+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.2623749 2022-10-31T18:51:33.262375+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.2785463 2022-10-31T18:51:33.278546+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.2947268 2022-10-31T18:51:33.294727+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3109047 2022-10-31T18:51:33.310905+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3271055 2022-10-31T18:51:33.327106+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3422902 2022-10-31T18:51:33.342290+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3584697 2022-10-31T18:51:33.358470+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3746493 2022-10-31T18:51:33.374649+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.3908281 2022-10-31T18:51:33.390828+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.4070034 2022-10-31T18:51:33.407003+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.423209 2022-10-31T18:51:33.423209+00:00 1 10 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.4393835 2022-10-31T18:51:33.439384+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.4555614 2022-10-31T18:51:33.455561+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.4717445 2022-10-31T18:51:33.471745+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.4879186 2022-10-31T18:51:33.487919+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.504085 2022-10-31T18:51:33.504085+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.5192702 2022-10-31T18:51:33.519270+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.5354466 2022-10-31T18:51:33.535447+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.5516243 2022-10-31T18:51:33.551624+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.5677834 2022-10-31T18:51:33.567783+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.5839553 2022-10-31T18:51:33.583955+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6001163 2022-10-31T18:51:33.600116+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6152945 2022-10-31T18:51:33.615294+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6314762 2022-10-31T18:51:33.631476+00:00 1 9 1285 725 880 829 1660 545 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.647648 2022-10-31T18:51:33.647648+00:00 1 9 1285 725 880 829 1660 541 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6638248 2022-10-31T18:51:33.663825+00:00 1 9 1285 725 880 829 1660 537 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6800103 2022-10-31T18:51:33.680010+00:00 1 9 1285 725 880 829 1660 537 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.6962216 2022-10-31T18:51:33.696222+00:00 1 9 1285 725 880 829 1660 533 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.712397 2022-10-31T18:51:33.712397+00:00 1 9 1285 725 880 829 1660 527 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.7285783 2022-10-31T18:51:33.728578+00:00 1 9 1285 725 880 829 1660 521 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.7447524 2022-10-31T18:51:33.744752+00:00 1 9 1285 725 880 829 1660 517 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.7609262 2022-10-31T18:51:33.760926+00:00 1 9 1285 725 880 829 1660 507 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.7771003 2022-10-31T18:51:33.777100+00:00 1 9 1285 725 880 829 1660 503 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.7922783 2022-10-31T18:51:33.792278+00:00 1 9 1285 725 880 829 1660 499 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.8084629 2022-10-31T18:51:33.808463+00:00 1 9 1285 725 880 829 1660 499 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.8246295 2022-10-31T18:51:33.824630+00:00 1 9 1285 725 880 829 1660 495 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.840797 2022-10-31T18:51:33.840797+00:00 1 9 1285 725 880 829 1660 492 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.8569767 2022-10-31T18:51:33.856977+00:00 1 9 1285 725 880 829 1660 491 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.8731525 2022-10-31T18:51:33.873152+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.8883288 2022-10-31T18:51:33.888329+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.904501 2022-10-31T18:51:33.904501+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.920672 2022-10-31T18:51:33.920672+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.9368443 2022-10-31T18:51:33.936844+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.9530172 2022-10-31T18:51:33.953017+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.9691927 2022-10-31T18:51:33.969193+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242293.9843793 2022-10-31T18:51:33.984379+00:00 1 9 1285 725 880 829 1660 490 0 0
exp_2022_10_31_10 99907 64 lion tiger 1667242294.000549 2022-10-31T18:51:34.000549+00:00 1 9 1285 725 880 829 1660 490 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]);