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 group_session = "exp_2022_11_18_10"

View and edit SQL

Suggested facets: player_1_id, player_2_id, player_1_station, player_2_station, 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_11_18_10 35 56 lion tiger 1668797353.077392 2022-11-18T18:49:13.077392+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.0937927 2022-11-18T18:49:13.093793+00:00 1 10 1285 725 880 790 1660 795 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.1100037 2022-11-18T18:49:13.110004+00:00 1 10 1285 725 880 790 1660 795 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.12516 2022-11-18T18:49:13.125160+00:00 1 10 1285 725 880 790 1660 795 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.1413138 2022-11-18T18:49:13.141314+00:00 1 10 1285 725 880 790 1660 797 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.1574802 2022-11-18T18:49:13.157480+00:00 1 10 1285 725 880 790 1660 798 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.1736293 2022-11-18T18:49:13.173629+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.1897812 2022-11-18T18:49:13.189781+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.2059486 2022-11-18T18:49:13.205949+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.2221115 2022-11-18T18:49:13.222111+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.238264 2022-11-18T18:49:13.238264+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.254429 2022-11-18T18:49:13.254429+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.2705917 2022-11-18T18:49:13.270592+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.286742 2022-11-18T18:49:13.286742+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.302896 2022-11-18T18:49:13.302896+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3190541 2022-11-18T18:49:13.319054+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3342128 2022-11-18T18:49:13.334213+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3503752 2022-11-18T18:49:13.350375+00:00 1 10 1285 725 880 790 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3665442 2022-11-18T18:49:13.366544+00:00 1 10 1285 725 880 790 1660 798 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3826864 2022-11-18T18:49:13.382686+00:00 1 10 1285 725 880 790 1660 797 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.3988595 2022-11-18T18:49:13.398860+00:00 1 10 1285 725 880 790 1660 796 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.4150417 2022-11-18T18:49:13.415042+00:00 1 10 1285 725 880 790 1660 795 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.4301686 2022-11-18T18:49:13.430169+00:00 1 10 1285 725 880 790 1660 794 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.4463327 2022-11-18T18:49:13.446333+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.4624887 2022-11-18T18:49:13.462489+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.4786544 2022-11-18T18:49:13.478654+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.494817 2022-11-18T18:49:13.494817+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.510978 2022-11-18T18:49:13.510978+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.527144 2022-11-18T18:49:13.527144+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.5433083 2022-11-18T18:49:13.543308+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.5594761 2022-11-18T18:49:13.559476+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.5756478 2022-11-18T18:49:13.575648+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.591808 2022-11-18T18:49:13.591808+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.607967 2022-11-18T18:49:13.607967+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.6241539 2022-11-18T18:49:13.624154+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.6403384 2022-11-18T18:49:13.640338+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.6564972 2022-11-18T18:49:13.656497+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.6726573 2022-11-18T18:49:13.672657+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.688819 2022-11-18T18:49:13.688819+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.7049868 2022-11-18T18:49:13.704987+00:00 1 10 1285 725 880 790 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.7211645 2022-11-18T18:49:13.721164+00:00 1 10 1285 725 880 790 1660 794 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.737365 2022-11-18T18:49:13.737365+00:00 1 10 1285 725 880 790 1660 794 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.7535372 2022-11-18T18:49:13.753537+00:00 1 10 1285 725 880 790 1660 797 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.769704 2022-11-18T18:49:13.769704+00:00 1 10 1285 725 880 790 1660 797 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.7858589 2022-11-18T18:49:13.785859+00:00 1 10 1285 725 880 790 1660 800 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8020296 2022-11-18T18:49:13.802030+00:00 1 10 1285 725 880 790 1660 801 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8171875 2022-11-18T18:49:13.817188+00:00 1 10 1285 725 880 790 1660 802 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8333557 2022-11-18T18:49:13.833356+00:00 1 10 1285 725 880 790 1660 803 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8495307 2022-11-18T18:49:13.849531+00:00 1 10 1285 725 880 790 1660 804 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8657165 2022-11-18T18:49:13.865716+00:00 1 10 1285 725 880 790 1660 805 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.881935 2022-11-18T18:49:13.881935+00:00 1 10 1285 725 880 790 1660 805 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.8981392 2022-11-18T18:49:13.898139+00:00 1 10 1285 725 880 790 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.9143417 2022-11-18T18:49:13.914342+00:00 1 10 1285 725 880 790 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.9305196 2022-11-18T18:49:13.930520+00:00 1 10 1285 725 880 790 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.9467018 2022-11-18T18:49:13.946702+00:00 1 10 1285 725 880 790 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.962872 2022-11-18T18:49:13.962872+00:00 1 10 1285 725 880 790 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.9790316 2022-11-18T18:49:13.979032+00:00 1 10 1285 725 880 810 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797353.9951851 2022-11-18T18:49:13.995185+00:00 1 10 1285 725 880 813 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.0113554 2022-11-18T18:49:14.011355+00:00 1 10 1285 725 880 815 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.0275319 2022-11-18T18:49:14.027532+00:00 1 10 1285 725 880 819 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.043694 2022-11-18T18:49:14.043694+00:00 1 10 1285 725 880 824 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.0598562 2022-11-18T18:49:14.059856+00:00 1 10 1285 725 880 830 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.0760214 2022-11-18T18:49:14.076021+00:00 1 10 1285 725 880 835 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.0921783 2022-11-18T18:49:14.092178+00:00 1 10 1285 725 880 839 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1083503 2022-11-18T18:49:14.108350+00:00 1 9 1285 725 880 843 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1245208 2022-11-18T18:49:14.124521+00:00 1 9 1285 725 880 845 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1406786 2022-11-18T18:49:14.140679+00:00 1 9 1285 725 880 845 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1568496 2022-11-18T18:49:14.156850+00:00 1 9 1285 725 880 845 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1730206 2022-11-18T18:49:14.173021+00:00 1 9 1285 725 880 846 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.1891794 2022-11-18T18:49:14.189179+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.20534 2022-11-18T18:49:14.205340+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.2215092 2022-11-18T18:49:14.221509+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.2376661 2022-11-18T18:49:14.237666+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.2538364 2022-11-18T18:49:14.253836+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.2700026 2022-11-18T18:49:14.270003+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.2861617 2022-11-18T18:49:14.286162+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.302334 2022-11-18T18:49:14.302334+00:00 1 9 1285 725 880 847 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.318512 2022-11-18T18:49:14.318512+00:00 1 9 1285 725 880 843 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.3347251 2022-11-18T18:49:14.334725+00:00 1 9 1285 725 880 836 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.3508546 2022-11-18T18:49:14.350855+00:00 1 9 1285 725 880 834 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.366987 2022-11-18T18:49:14.366987+00:00 1 9 1285 725 880 834 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.383125 2022-11-18T18:49:14.383125+00:00 1 9 1285 725 880 826 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.398265 2022-11-18T18:49:14.398265+00:00 1 9 1285 725 880 821 1660 807 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.4144135 2022-11-18T18:49:14.414413+00:00 1 9 1285 725 880 817 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.430529 2022-11-18T18:49:14.430529+00:00 1 9 1285 725 880 817 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.4466536 2022-11-18T18:49:14.446654+00:00 1 9 1285 725 880 810 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.4627798 2022-11-18T18:49:14.462780+00:00 1 9 1285 725 880 807 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.4789007 2022-11-18T18:49:14.478901+00:00 1 9 1285 725 880 807 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.4950633 2022-11-18T18:49:14.495063+00:00 1 9 1285 725 880 807 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.510229 2022-11-18T18:49:14.510229+00:00 1 9 1285 725 880 806 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.5263944 2022-11-18T18:49:14.526394+00:00 1 9 1285 725 880 805 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.5425544 2022-11-18T18:49:14.542554+00:00 1 9 1285 725 880 804 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.5587192 2022-11-18T18:49:14.558719+00:00 1 9 1285 725 880 804 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.5748792 2022-11-18T18:49:14.574879+00:00 1 9 1285 725 880 804 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.5910559 2022-11-18T18:49:14.591056+00:00 1 9 1285 725 880 804 1660 806 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.6072218 2022-11-18T18:49:14.607222+00:00 1 9 1285 725 880 804 1660 805 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.6233869 2022-11-18T18:49:14.623387+00:00 1 9 1285 725 880 804 1660 802 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.6395373 2022-11-18T18:49:14.639537+00:00 1 9 1285 725 880 804 1660 799 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.655691 2022-11-18T18:49:14.655691+00:00 1 9 1285 725 880 804 1660 793 0 0
exp_2022_11_18_10 35 56 lion tiger 1668797354.671846 2022-11-18T18:49:14.671846+00:00 1 9 1285 725 880 803 1660 783 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]);