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

View and edit SQL

Suggested facets: 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_09_30_10 19 -3 leopard cheetah 1664564399.6883297 2022-09-30T18:59:59.688330+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.705041 2022-09-30T18:59:59.705041+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.7202024 2022-09-30T18:59:59.720202+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.7363365 2022-09-30T18:59:59.736336+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.7524936 2022-09-30T18:59:59.752494+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.7686293 2022-09-30T18:59:59.768629+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.7847872 2022-09-30T18:59:59.784787+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.8009486 2022-09-30T18:59:59.800949+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.8170874 2022-09-30T18:59:59.817087+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.8322165 2022-09-30T18:59:59.832217+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.8483858 2022-09-30T18:59:59.848386+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.864533 2022-09-30T18:59:59.864533+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.880704 2022-09-30T18:59:59.880704+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.8968565 2022-09-30T18:59:59.896857+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.9130242 2022-09-30T18:59:59.913024+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.9291542 2022-09-30T18:59:59.929154+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.945291 2022-09-30T18:59:59.945291+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.9614556 2022-09-30T18:59:59.961456+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.9775949 2022-09-30T18:59:59.977595+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564399.9937654 2022-09-30T18:59:59.993765+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0099766 2022-09-30T19:00:00.009977+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0261302 2022-09-30T19:00:00.026130+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0412934 2022-09-30T19:00:00.041293+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0574536 2022-09-30T19:00:00.057454+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0735848 2022-09-30T19:00:00.073585+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.0897229 2022-09-30T19:00:00.089723+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.1058977 2022-09-30T19:00:00.105898+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.1220226 2022-09-30T19:00:00.122023+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.138159 2022-09-30T19:00:00.138159+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.1543162 2022-09-30T19:00:00.154316+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.1704452 2022-09-30T19:00:00.170445+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.186574 2022-09-30T19:00:00.186574+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.2027535 2022-09-30T19:00:00.202754+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.2188826 2022-09-30T19:00:00.218883+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.235018 2022-09-30T19:00:00.235018+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.2511773 2022-09-30T19:00:00.251177+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.2673013 2022-09-30T19:00:00.267301+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.283431 2022-09-30T19:00:00.283431+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.2996254 2022-09-30T19:00:00.299625+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.315878 2022-09-30T19:00:00.315878+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.3320615 2022-09-30T19:00:00.332062+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.348181 2022-09-30T19:00:00.348181+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.3643036 2022-09-30T19:00:00.364304+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.380407 2022-09-30T19:00:00.380407+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.396551 2022-09-30T19:00:00.396551+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.4128 2022-09-30T19:00:00.412800+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.4289732 2022-09-30T19:00:00.428973+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.445126 2022-09-30T19:00:00.445126+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.460298 2022-09-30T19:00:00.460298+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.4764442 2022-09-30T19:00:00.476444+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.4926045 2022-09-30T19:00:00.492604+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.5087671 2022-09-30T19:00:00.508767+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.5249257 2022-09-30T19:00:00.524926+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.5410693 2022-09-30T19:00:00.541069+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.556235 2022-09-30T19:00:00.556235+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.5723662 2022-09-30T19:00:00.572366+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.5885203 2022-09-30T19:00:00.588520+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6046932 2022-09-30T19:00:00.604693+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6208286 2022-09-30T19:00:00.620829+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6369674 2022-09-30T19:00:00.636967+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6531417 2022-09-30T19:00:00.653142+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6682775 2022-09-30T19:00:00.668278+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.6844277 2022-09-30T19:00:00.684428+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7006276 2022-09-30T19:00:00.700628+00:00 1 10 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7168033 2022-09-30T19:00:00.716803+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7329607 2022-09-30T19:00:00.732961+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7491014 2022-09-30T19:00:00.749101+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7642436 2022-09-30T19:00:00.764244+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7804027 2022-09-30T19:00:00.780403+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.7965603 2022-09-30T19:00:00.796560+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.8127434 2022-09-30T19:00:00.812743+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.828988 2022-09-30T19:00:00.828988+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.845209 2022-09-30T19:00:00.845209+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.8613763 2022-09-30T19:00:00.861376+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.877538 2022-09-30T19:00:00.877538+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.8937101 2022-09-30T19:00:00.893710+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.909861 2022-09-30T19:00:00.909861+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.9260714 2022-09-30T19:00:00.926071+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.9422333 2022-09-30T19:00:00.942233+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.9584253 2022-09-30T19:00:00.958425+00:00 1 9 1285 725 880 745 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.9746175 2022-09-30T19:00:00.974617+00:00 1 9 1285 725 880 848 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564400.9907644 2022-09-30T19:00:00.990764+00:00 1 9 1285 725 880 846 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.006892 2022-09-30T19:00:01.006892+00:00 1 9 1285 725 880 846 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.023015 2022-09-30T19:00:01.023015+00:00 1 9 1285 725 880 840 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.0391383 2022-09-30T19:00:01.039138+00:00 1 9 1285 725 880 830 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.0542557 2022-09-30T19:00:01.054256+00:00 1 9 1285 725 880 830 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.0703757 2022-09-30T19:00:01.070376+00:00 1 9 1285 725 880 821 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.0864954 2022-09-30T19:00:01.086495+00:00 1 9 1285 725 880 818 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.1026165 2022-09-30T19:00:01.102617+00:00 1 9 1285 725 880 817 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.1187367 2022-09-30T19:00:01.118737+00:00 1 9 1285 725 880 817 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.1348622 2022-09-30T19:00:01.134862+00:00 1 9 1285 725 880 817 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.150992 2022-09-30T19:00:01.150992+00:00 1 9 1285 725 880 817 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.1671293 2022-09-30T19:00:01.167129+00:00 1 9 1285 725 880 816 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.182254 2022-09-30T19:00:01.182254+00:00 1 9 1285 725 880 815 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.1983728 2022-09-30T19:00:01.198373+00:00 1 9 1285 725 880 814 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.2144914 2022-09-30T19:00:01.214491+00:00 1 9 1285 725 880 810 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.2306285 2022-09-30T19:00:01.230628+00:00 1 9 1285 725 880 806 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.246786 2022-09-30T19:00:01.246786+00:00 1 9 1285 725 880 799 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.2629232 2022-09-30T19:00:01.262923+00:00 1 9 1285 725 880 794 1660 660 0 0
exp_2022_09_30_10 19 -3 leopard cheetah 1664564401.2790534 2022-09-30T19:00:01.279053+00:00 1 9 1285 725 880 790 1660 660 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]);