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

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_12_02_15 42 61 lion tiger 1670024642.2309477 2022-12-02T23:44:02.230948+00:00 1 10 1285 725 880 660 1660 660 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.2476168 2022-12-02T23:44:02.247617+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.263854 2022-12-02T23:44:02.263854+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.2801542 2022-12-02T23:44:02.280154+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.2964506 2022-12-02T23:44:02.296451+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3126745 2022-12-02T23:44:02.312675+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3279335 2022-12-02T23:44:02.327934+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3442261 2022-12-02T23:44:02.344226+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3605142 2022-12-02T23:44:02.360514+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3767872 2022-12-02T23:44:02.376787+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.3920732 2022-12-02T23:44:02.392073+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.4083092 2022-12-02T23:44:02.408309+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.4245608 2022-12-02T23:44:02.424561+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.4408247 2022-12-02T23:44:02.440825+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.457088 2022-12-02T23:44:02.457088+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.473321 2022-12-02T23:44:02.473321+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.4895797 2022-12-02T23:44:02.489580+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.5058198 2022-12-02T23:44:02.505820+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.5220432 2022-12-02T23:44:02.522043+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.5382938 2022-12-02T23:44:02.538294+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.5545378 2022-12-02T23:44:02.554538+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.570719 2022-12-02T23:44:02.570719+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.5858996 2022-12-02T23:44:02.585900+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.6020665 2022-12-02T23:44:02.602067+00:00 1 10 1285 725 880 800 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.618245 2022-12-02T23:44:02.618245+00:00 1 10 1285 725 880 811 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.634478 2022-12-02T23:44:02.634478+00:00 1 10 1285 725 880 811 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.6506822 2022-12-02T23:44:02.650682+00:00 1 10 1285 725 880 810 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.6659474 2022-12-02T23:44:02.665947+00:00 1 10 1285 725 880 810 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.6821494 2022-12-02T23:44:02.682149+00:00 1 10 1285 725 880 811 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.698347 2022-12-02T23:44:02.698347+00:00 1 10 1285 725 880 816 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.7145238 2022-12-02T23:44:02.714524+00:00 1 10 1285 725 880 822 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.7307217 2022-12-02T23:44:02.730722+00:00 1 10 1285 725 880 828 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.7459514 2022-12-02T23:44:02.745951+00:00 1 10 1285 725 880 828 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.762205 2022-12-02T23:44:02.762205+00:00 1 10 1285 725 880 834 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.7784352 2022-12-02T23:44:02.778435+00:00 1 10 1285 725 880 841 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.7946537 2022-12-02T23:44:02.794654+00:00 1 10 1285 725 880 843 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.810875 2022-12-02T23:44:02.810875+00:00 1 10 1285 725 880 848 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.827072 2022-12-02T23:44:02.827072+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.8432903 2022-12-02T23:44:02.843290+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.8594868 2022-12-02T23:44:02.859487+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.8756902 2022-12-02T23:44:02.875690+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.8909035 2022-12-02T23:44:02.890903+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.9071167 2022-12-02T23:44:02.907117+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.923349 2022-12-02T23:44:02.923349+00:00 1 10 1285 725 880 850 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.939588 2022-12-02T23:44:02.939588+00:00 1 10 1285 725 880 844 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.955793 2022-12-02T23:44:02.955793+00:00 1 10 1285 725 880 834 1660 850 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.9709976 2022-12-02T23:44:02.970998+00:00 1 10 1285 725 880 818 1660 849 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024642.987226 2022-12-02T23:44:02.987226+00:00 1 10 1285 725 880 799 1660 848 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0034587 2022-12-02T23:44:03.003459+00:00 1 10 1285 725 880 790 1660 845 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0196981 2022-12-02T23:44:03.019698+00:00 1 10 1285 725 880 790 1660 842 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0358758 2022-12-02T23:44:03.035876+00:00 1 10 1285 725 880 779 1660 840 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0520456 2022-12-02T23:44:03.052046+00:00 1 10 1285 725 880 778 1660 839 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0682611 2022-12-02T23:44:03.068261+00:00 1 10 1285 725 880 776 1660 838 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.0844173 2022-12-02T23:44:03.084417+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1005793 2022-12-02T23:44:03.100579+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1167045 2022-12-02T23:44:03.116704+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1328557 2022-12-02T23:44:03.132856+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1490414 2022-12-02T23:44:03.149041+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1652315 2022-12-02T23:44:03.165231+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.1813767 2022-12-02T23:44:03.181377+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.197517 2022-12-02T23:44:03.197517+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.2136955 2022-12-02T23:44:03.213696+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.228954 2022-12-02T23:44:03.228954+00:00 1 10 1285 725 880 776 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.2452083 2022-12-02T23:44:03.245208+00:00 1 10 1285 725 880 774 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.2614486 2022-12-02T23:44:03.261449+00:00 1 9 1285 725 880 774 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.277674 2022-12-02T23:44:03.277674+00:00 1 9 1285 725 880 774 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.293877 2022-12-02T23:44:03.293877+00:00 1 9 1285 725 880 773 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.3100631 2022-12-02T23:44:03.310063+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.32629 2022-12-02T23:44:03.326290+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.3425643 2022-12-02T23:44:03.342564+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.3588316 2022-12-02T23:44:03.358832+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.37404 2022-12-02T23:44:03.374040+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.3902717 2022-12-02T23:44:03.390272+00:00 1 9 1285 725 880 762 1660 837 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.4065316 2022-12-02T23:44:03.406532+00:00 1 9 1285 725 880 762 1660 836 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.4227965 2022-12-02T23:44:03.422796+00:00 1 9 1285 725 880 762 1660 836 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.438058 2022-12-02T23:44:03.438058+00:00 1 9 1285 725 880 762 1660 835 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.4542978 2022-12-02T23:44:03.454298+00:00 1 9 1285 725 880 762 1660 834 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.4705324 2022-12-02T23:44:03.470532+00:00 1 9 1285 725 880 762 1660 834 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.4868183 2022-12-02T23:44:03.486818+00:00 1 9 1285 725 880 762 1660 833 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.5020578 2022-12-02T23:44:03.502058+00:00 1 9 1285 725 880 762 1660 833 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.5183032 2022-12-02T23:44:03.518303+00:00 1 9 1285 725 880 762 1660 832 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.5345323 2022-12-02T23:44:03.534532+00:00 1 9 1285 725 880 762 1660 831 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.550754 2022-12-02T23:44:03.550754+00:00 1 9 1285 725 880 762 1660 831 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.5659509 2022-12-02T23:44:03.565951+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.5821364 2022-12-02T23:44:03.582136+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.598329 2022-12-02T23:44:03.598329+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6145418 2022-12-02T23:44:03.614542+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6307502 2022-12-02T23:44:03.630750+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6459136 2022-12-02T23:44:03.645914+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6620693 2022-12-02T23:44:03.662069+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6782572 2022-12-02T23:44:03.678257+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.6944387 2022-12-02T23:44:03.694439+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.7106097 2022-12-02T23:44:03.710610+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.7267842 2022-12-02T23:44:03.726784+00:00 1 9 1285 725 880 762 1660 830 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.741954 2022-12-02T23:44:03.741954+00:00 1 9 1285 725 880 762 1660 829 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.7581446 2022-12-02T23:44:03.758145+00:00 1 9 1285 725 880 762 1660 828 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.7743073 2022-12-02T23:44:03.774307+00:00 1 9 1285 725 880 762 1660 827 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.7904608 2022-12-02T23:44:03.790461+00:00 1 9 1285 725 880 762 1660 826 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.8066094 2022-12-02T23:44:03.806609+00:00 1 9 1285 725 880 762 1660 825 0 0
exp_2022_12_02_15 42 61 lion tiger 1670024643.8227856 2022-12-02T23:44:03.822786+00:00 1 9 1285 725 880 761 1660 825 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]);