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

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_04_28_10 144 152 lion tiger 1682707112.6889331 2023-04-28T18:38:32.688933+00:00 0 10 1285 725 880 660 1660 660 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.7045422 2023-04-28T18:38:32.704542+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.720748 2023-04-28T18:38:32.720748+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.736954 2023-04-28T18:38:32.736954+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.7531564 2023-04-28T18:38:32.753156+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.7694013 2023-04-28T18:38:32.769401+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.785598 2023-04-28T18:38:32.785598+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8017795 2023-04-28T18:38:32.801780+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8179753 2023-04-28T18:38:32.817975+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8341656 2023-04-28T18:38:32.834166+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8503575 2023-04-28T18:38:32.850358+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8655345 2023-04-28T18:38:32.865535+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.8817186 2023-04-28T18:38:32.881719+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.897901 2023-04-28T18:38:32.897901+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9141042 2023-04-28T18:38:32.914104+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9303355 2023-04-28T18:38:32.930336+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9455585 2023-04-28T18:38:32.945559+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9617999 2023-04-28T18:38:32.961800+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9780307 2023-04-28T18:38:32.978031+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707112.9942381 2023-04-28T18:38:32.994238+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0104158 2023-04-28T18:38:33.010416+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0266168 2023-04-28T18:38:33.026617+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0428126 2023-04-28T18:38:33.042813+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0590131 2023-04-28T18:38:33.059013+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0752344 2023-04-28T18:38:33.075234+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.0905018 2023-04-28T18:38:33.090502+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.1067219 2023-04-28T18:38:33.106722+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.1229386 2023-04-28T18:38:33.122939+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.1391847 2023-04-28T18:38:33.139185+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.1554117 2023-04-28T18:38:33.155412+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.1706734 2023-04-28T18:38:33.170673+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.18693 2023-04-28T18:38:33.186930+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.2032216 2023-04-28T18:38:33.203222+00:00 0 10 1285 725 880 846 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.2194486 2023-04-28T18:38:33.219449+00:00 0 10 1285 725 880 843 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.2356424 2023-04-28T18:38:33.235642+00:00 0 10 1285 725 880 840 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.251848 2023-04-28T18:38:33.251848+00:00 0 10 1285 725 880 840 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.268047 2023-04-28T18:38:33.268047+00:00 0 10 1285 725 880 828 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.2842352 2023-04-28T18:38:33.284235+00:00 0 10 1285 725 880 825 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.3004317 2023-04-28T18:38:33.300432+00:00 0 10 1285 725 880 823 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.3166637 2023-04-28T18:38:33.316664+00:00 0 10 1285 725 880 813 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.332873 2023-04-28T18:38:33.332873+00:00 0 10 1285 725 880 807 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.3491118 2023-04-28T18:38:33.349112+00:00 0 10 1285 725 880 807 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.3653352 2023-04-28T18:38:33.365335+00:00 0 10 1285 725 880 804 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.38055 2023-04-28T18:38:33.380550+00:00 0 10 1285 725 880 798 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.3967762 2023-04-28T18:38:33.396776+00:00 0 10 1285 725 880 792 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.41301 2023-04-28T18:38:33.413010+00:00 0 10 1285 725 880 781 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.4292316 2023-04-28T18:38:33.429232+00:00 0 10 1285 725 880 774 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.4454582 2023-04-28T18:38:33.445458+00:00 0 10 1285 725 880 765 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.4616723 2023-04-28T18:38:33.461672+00:00 0 10 1285 725 880 756 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.4778767 2023-04-28T18:38:33.477877+00:00 0 10 1285 725 880 750 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.4940856 2023-04-28T18:38:33.494086+00:00 0 10 1285 725 880 740 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5102854 2023-04-28T18:38:33.510285+00:00 0 10 1285 725 880 733 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5255008 2023-04-28T18:38:33.525501+00:00 0 10 1285 725 880 721 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5416946 2023-04-28T18:38:33.541695+00:00 0 10 1285 725 880 706 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5578923 2023-04-28T18:38:33.557892+00:00 0 10 1285 725 880 693 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5740983 2023-04-28T18:38:33.574098+00:00 0 10 1285 725 880 671 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.5902948 2023-04-28T18:38:33.590295+00:00 0 10 1285 725 880 661 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6055 2023-04-28T18:38:33.605500+00:00 0 10 1285 725 880 661 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6216896 2023-04-28T18:38:33.621690+00:00 0 10 1285 725 880 634 1660 850 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6378806 2023-04-28T18:38:33.637881+00:00 0 10 1285 725 880 620 1660 849 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6540709 2023-04-28T18:38:33.654071+00:00 0 10 1285 725 880 620 1660 849 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6702452 2023-04-28T18:38:33.670245+00:00 0 10 1285 725 880 620 1660 847 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.6864402 2023-04-28T18:38:33.686440+00:00 0 10 1285 725 880 620 1660 835 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.7026439 2023-04-28T18:38:33.702644+00:00 0 10 1285 725 880 620 1660 835 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.7188509 2023-04-28T18:38:33.718851+00:00 0 9 1285 725 880 620 1660 835 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.7350976 2023-04-28T18:38:33.735098+00:00 0 9 1285 725 880 620 1660 825 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.7513092 2023-04-28T18:38:33.751309+00:00 0 9 1285 725 880 623 1660 815 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.7665062 2023-04-28T18:38:33.766506+00:00 0 9 1285 725 880 627 1660 806 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.782717 2023-04-28T18:38:33.782717+00:00 0 9 1285 725 880 635 1660 803 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.79895 2023-04-28T18:38:33.798950+00:00 0 9 1285 725 880 645 1660 799 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.8153074 2023-04-28T18:38:33.815307+00:00 0 9 1285 725 880 649 1660 791 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.8306289 2023-04-28T18:38:33.830629+00:00 0 9 1285 725 880 650 1660 785 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.8469772 2023-04-28T18:38:33.846977+00:00 0 9 1285 725 880 656 1660 782 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.8633022 2023-04-28T18:38:33.863302+00:00 0 9 1285 725 880 667 1660 775 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.878588 2023-04-28T18:38:33.878588+00:00 0 9 1285 725 880 681 1660 771 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.8947988 2023-04-28T18:38:33.894799+00:00 0 9 1285 725 880 694 1660 770 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.910992 2023-04-28T18:38:33.910992+00:00 0 9 1285 725 880 710 1660 767 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.927198 2023-04-28T18:38:33.927198+00:00 0 9 1285 725 880 728 1660 762 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.9434566 2023-04-28T18:38:33.943457+00:00 0 9 1285 725 880 728 1660 761 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.959664 2023-04-28T18:38:33.959664+00:00 0 9 1285 725 880 742 1660 757 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.9758477 2023-04-28T18:38:33.975848+00:00 0 9 1285 725 880 742 1660 754 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707113.9919863 2023-04-28T18:38:33.991986+00:00 0 9 1285 725 880 742 1660 754 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.0081353 2023-04-28T18:38:34.008135+00:00 0 9 1285 725 880 742 1660 747 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.0242844 2023-04-28T18:38:34.024284+00:00 0 9 1285 725 880 742 1660 741 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.040509 2023-04-28T18:38:34.040509+00:00 0 9 1285 725 880 742 1660 735 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.0567183 2023-04-28T18:38:34.056718+00:00 0 9 1285 725 880 741 1660 730 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.0729296 2023-04-28T18:38:34.072930+00:00 0 9 1285 725 880 739 1660 727 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.0891185 2023-04-28T18:38:34.089118+00:00 0 9 1285 725 880 739 1660 725 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.1053078 2023-04-28T18:38:34.105308+00:00 0 9 1285 725 880 739 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.1214972 2023-04-28T18:38:34.121497+00:00 0 9 1285 725 880 738 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.137658 2023-04-28T18:38:34.137658+00:00 0 9 1285 725 880 738 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.15386 2023-04-28T18:38:34.153860+00:00 0 9 1285 725 880 729 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.1700454 2023-04-28T18:38:34.170045+00:00 0 9 1285 725 880 720 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.1862423 2023-04-28T18:38:34.186242+00:00 0 9 1285 725 880 710 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.2024448 2023-04-28T18:38:34.202445+00:00 0 9 1285 725 880 680 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.2176635 2023-04-28T18:38:34.217664+00:00 0 9 1285 725 880 680 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.2338598 2023-04-28T18:38:34.233860+00:00 0 9 1285 725 880 672 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.2500472 2023-04-28T18:38:34.250047+00:00 0 9 1285 725 880 669 1660 724 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.2662404 2023-04-28T18:38:34.266240+00:00 0 9 1285 725 880 665 1660 728 0 0
exp_2023_04_28_10 144 152 lion tiger 1682707114.282434 2023-04-28T18:38:34.282434+00:00 0 9 1285 725 880 661 1660 736 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]);